// Select SQL command
switch ($type)
{
- case 'bonusid':
- $column = 'bonus_id';
- $bonus = $mid;
- break;
-
- case 'mailid' :
- $column = 'mail_id';
- $mail = $mid;
- break;
-
- default:
- DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Invalid type %s detected.", $type));
- break;
+ case 'bonusid':
+ $column = 'bonus_id';
+ $bonus = $mid;
+ break;
+
+ case 'mailid' :
+ $column = 'mail_id';
+ $mail = $mid;
+ break;
+
+ default:
+ DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Invalid type %s detected.", $type));
+ break;
}
// Is a column name set?
// Check for entry
$result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE userid=%s AND %s=%s LIMIT 1",
- array($uid, $column, $mid), __FUNCTION__, __LINE__);
+ array($uid, $column, $mid), __FUNCTION__, __LINE__);
// Load clicks from table as current rank
list($rank) = SQL_FETCHROW($result);
// Add points to his account directly
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1",
- array(bigintval($uid)), __FUNCTION__, __LINE__);
+ array(bigintval($uid)), __FUNCTION__, __LINE__);
// Rember this whole data for displaying ranking list
SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_bonus_turbo` (userid, mail_id, bonus_id, level, points, timemark) VALUES ('%s', '%s', '%s', '%s', '%s', UNIX_TIMESTAMP())",
- array(bigintval($uid), bigintval($mail), bigintval($bonus), $rank, $points), __FUNCTION__, __LINE__);
+ array(bigintval($uid), bigintval($mail), bigintval($bonus), $rank, $points), __FUNCTION__, __LINE__);
if ((GET_EXT_VERSION('bonus') >= '0.3.5') && (getConfig('bonus_mode') != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points);
}
// Load current user's data
$result = SQL_QUERY_ESC("SELECT level, points, timemark FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s AND `userid`=%s LIMIT 1",
- array($type, $data, $uid), __FUNCTION__, __LINE__);
+ array($type, $data, $uid), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Load data
list($rank, $points, $mark) = SQL_FETCHROW($result);
// Load rankings
$result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s ORDER BY level LIMIT %s",
- array($type, $data, getConfig('bonus_lines')), __FUNCTION__, __LINE__);
+ array($type, $data, getConfig('bonus_lines')), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// Start generating the ranking list
$max = SQL_NUMROWS($result);
for ($rank = 1; $rank <= $max; $rank++) {
// Load data
$result_users = SQL_QUERY_ESC("SELECT userid, points, timemark FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s AND level=%s LIMIT 1",
- array($type, $data, $rank), __FUNCTION__, __LINE__);
+ array($type, $data, $rank), __FUNCTION__, __LINE__);
// Nothing found by default
$userid = '---'; $points = '---';
// Subtract points from...
switch (getConfig('bonus_mode'))
{
- case 'JACKPOT': // ... jackpot
- if ((SUB_JACKPOT($points) == -1) && (getConfig('bonus_uid') > 0)) {
- // Check points amount first...
+ case 'JACKPOT': // ... jackpot
+ if ((SUB_JACKPOT($points) == -1) && (getConfig('bonus_uid') > 0)) {
+ // Check points amount first...
+ $total = GET_TOTAL_DATA(getConfig('bonus_uid'), 'user_points', 'points') - GET_TOTAL_DATA(getConfig('bonus_uid'), 'user_data', 'used_points');
+ if ($total >= $points) {
+ // Subtract points from userid's account
+ SUB_POINTS('bonus_payout_jackpot', getConfig('bonus_uid'), $points);
+ } // END - if
+ } // END - if
+ break;
+
+ case 'UID': // ... userid's account
+ // Check his amount first
$total = GET_TOTAL_DATA(getConfig('bonus_uid'), 'user_points', 'points') - GET_TOTAL_DATA(getConfig('bonus_uid'), 'user_data', 'used_points');
if ($total >= $points) {
// Subtract points from userid's account
- SUB_POINTS('bonus_payout_jackpot', getConfig('bonus_uid'), $points);
- } // END - if
- } // END - if
- break;
-
- case 'UID': // ... userid's account
- // Check his amount first
- $total = GET_TOTAL_DATA(getConfig('bonus_uid'), 'user_points', 'points') - GET_TOTAL_DATA(getConfig('bonus_uid'), 'user_data', 'used_points');
- if ($total >= $points) {
- // Subtract points from userid's account
- SUB_POINTS('bonus_payout_uid', getConfig('bonus_uid'), $points);
- } else {
- // Try to subtract from jackpot
- $dummy = SUB_JACKPOT($points);
- }
- break;
+ SUB_POINTS('bonus_payout_uid', getConfig('bonus_uid'), $points);
+ } else {
+ // Try to subtract from jackpot
+ $dummy = SUB_JACKPOT($points);
+ }
+ break;
}
}