* $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 - 2016 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 *
$data['points'] = '0.00000';
// Read them
- $result = SQL_QUERY("SELECT `points` FROM `{?_MYSQL_PREFIX?}_jackpot` WHERE `ok`='ok' LIMIT 1", __FUNCTION__, __LINE__);
+ $result = sqlQuery("SELECT `points` FROM `{?_MYSQL_PREFIX?}_jackpot` WHERE `ok`='ok' LIMIT 1", __FUNCTION__, __LINE__);
- // Do we have an entry?
- if (SQL_HASZERONUMS($result)) {
+ // Is there an entry?
+ if (ifSqlHasZeroNumRows($result)) {
// No, so create line
- SQL_QUERY("INSERT INTO `{?_MYSQL_PREFIX?}_jackpot` (`ok`,`points`) VALUES ('ok','0.00000')", __FUNCTION__, __LINE__);
+ sqlQuery("INSERT INTO `{?_MYSQL_PREFIX?}_jackpot` (`ok`, `points`) VALUES ('ok','0.00000')", __FUNCTION__, __LINE__);
} else {
// Read the line
- $data = SQL_FETCHARRAY($result);
+ $data = sqlFetchArray($result);
}
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return them
return $data['points'];
$jackpot = getJackpotPoints();
// Update points
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_jackpot` SET `points`=`points`+%s WHERE `ok`='ok' LIMIT 1",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_jackpot` SET `points`=`points`+%s WHERE `ok`='ok' LIMIT 1",
array($points), __FUNCTION__, __LINE__);
}
// Subtracts points from the jackpot
function subtractPointsFromJackpot ($points) {
// First failed
- $ret = false;
+ $ret = FALSE;
// Get jackpot points for dummy
$jackpot = getJackpotPoints();
// Enougth points i jackpot?
if ($jackpot >= $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",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_jackpot` SET `points`=`points`-%s WHERE `ok`='ok' LIMIT 1",
array($points), __FUNCTION__, __LINE__);
- $ret = (!SQL_HASZEROAFFECTED());
+ $ret = (!ifSqlHasZeroAffectedRows());
} // END - if
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return the result
return $ret;