* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * 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 *
// Read them
$result = SQL_QUERY("SELECT `points` FROM `{?_MYSQL_PREFIX?}_jackpot` WHERE `ok`='ok' LIMIT 1", __FUNCTION__, __LINE__);
- // Do we have an entry?
+ // 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__);
// Subtracts points from the jackpot
function subtractPointsFromJackpot ($points) {
// First failed
- $ret = '-1';
+ $ret = FALSE;
// Get jackpot points for dummy
$jackpot = getJackpotPoints();
// 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