X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fjackpot_functions.php;h=1ab1efed809f2c4cec66716143cd2fb31bdb42e8;hb=b01f073d391432e1d5bd81e198ef255934b746d8;hp=55cbbb96bc970281b84f3d58663ba1aa23602fbd;hpb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;p=mailer.git

diff --git a/inc/libs/jackpot_functions.php b/inc/libs/jackpot_functions.php
index 55cbbb96bc..1ab1efed80 100644
--- a/inc/libs/jackpot_functions.php
+++ b/inc/libs/jackpot_functions.php
@@ -14,11 +14,10 @@
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -45,25 +44,25 @@ if (!defined('__SECURITY')) {
 // Getter for jackpot points
 function getJackpotPoints () {
 	// Default is zero
-	$jackpot = '0.00000';
+	$data['points'] = '0.00000';
 
 	// Read them
 	$result = SQL_QUERY("SELECT `points` FROM `{?_MYSQL_PREFIX?}_jackpot` WHERE `ok`='ok' LIMIT 1", __FUNCTION__, __LINE__);
 
-	// Do we have an entry?
-	if (SQL_NUMROWS($result) == '0') {
+	// Is there an entry?
+	if (SQL_HASZERONUMS($result)) {
 		// No, so create line
 		SQL_QUERY("INSERT INTO `{?_MYSQL_PREFIX?}_jackpot` (`ok`, `points`) VALUES ('ok','0.00000')", __FUNCTION__, __LINE__);
 	} else {
 		// Read the line
-		list($jackpot) = SQL_FETCHROW($result);
+		$data = SQL_FETCHARRAY($result);
 	}
 
 	// Free result
 	SQL_FREERESULT($result);
 
 	// Return them
-	return $jackpot;
+	return $data['points'];
 }
 
 // Adds points to the jackpot
@@ -79,7 +78,7 @@ function addPointsToJackpot ($points) {
 // Subtracts points from the jackpot
 function subtractPointsFromJackpot ($points) {
 	// First failed
-	$ret = '-1';
+	$ret = FALSE;
 
 	// Get jackpot points for dummy
 	$jackpot = getJackpotPoints();
@@ -89,7 +88,7 @@ function subtractPointsFromJackpot ($points) {
 		// Update points when there are enougth points in jackpot
 		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_jackpot` SET `points`=`points`-%s WHERE `ok`='ok' LIMIT 1",
 			array($points), __FUNCTION__, __LINE__);
-		$ret = $jackpot - $points;
+		$ret = (!SQL_HASZEROAFFECTED());
 	} // END - if
 
 	// Free memory