Counter for yester hits in surfbar added

[mailer.git] / inc / libs / bonus_functions.php

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index c52b7a9bbdb06b8e91abe77564de6aac08a891c2..266866130f5455344450cb2e255e51e7858960dd 100644 (file)
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -43,20 +43,20 @@ function BONUS_ADD_TURBO_POINTS($mid, $uid, $type)
        global $_CONFIG;
 
        // Shall we add bonus points?
-       if ($_CONFIG['bonus_active'] == 'N') return;
+       if ($_CONFIG['bonus_active'] == "N") return;
 
        // Select SQL command
        $SQL = "";
        switch ($type)
        {
        case "bonusid":
-               $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
+               $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1",
                 array($mid), __FILE__, __LINE__);
                $bonus = $mid; $mail = "0";
                break;
 
        case "mailid" :
-               $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1",
+               $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%s LIMIT 1",
                 array($mid), __FILE__, __LINE__);
                $bonus = "0"; $mail = $mid;
                break;
@@ -88,7 +88,7 @@ function BONUS_ADD_TURBO_POINTS($mid, $uid, $type)
        }
 
        // Add points to his account directly
-       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%d LIMIT 1",
+       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1",
         array(bigintval($uid)), __FILE__, __LINE__);
 
        // Rember this whole data for displaying ranking list
@@ -107,7 +107,7 @@ function BONUS_MAKE_RANK_ROWS($data, $type, $uid)
        $ranks = sizeof(explode(";", $_CONFIG['bonus_rates'])) + 1;
 
        // Load current user's data
-       $result = SQL_QUERY_ESC("SELECT level, points, timemark FROM "._MYSQL_PREFIX."_bonus_turbo WHERE %s=%s AND userid=%d LIMIT 1",
+       $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), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) == 1)
        {
@@ -186,7 +186,7 @@ function BONUS_POINTS_HANDLER($MODE)
        global $_CONFIG;
 
        // Shall we add bonus points?
-       if ($_CONFIG['bonus_active'] == 'N') return;
+       if ($_CONFIG['bonus_active'] == "N") return;
 
        // Switch to jackpot-mode when no UID is supplied but userid-mode is selected
        if (($_CONFIG['bonus_mode'] == "UID") && ($_CONFIG['bonus_uid'] == "0")) $_CONFIG['bonus_mode'] = "JACKPOT";
@@ -213,15 +213,7 @@ function BONUS_POINTS_HANDLER($MODE)
                        if ($TOTAL >= $points)
                        {
                                // Subtract points from userid's account
-                               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET used_points=used_points+%s WHERE userid=%d LIMIT 1",
-                                array(bigintval($points), bigintval($_CONFIG['bonus_uid'])), __FILE__, __LINE__);
-
-                               // Update mediadata as well
-                               if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-                               {
-                                       // Update database
-                                       MEDIA_UPDATE_ENTRY(array("total_points"), "sub", $points);
-                               }
+                               SUB_POINTS($_CONFIG['bonus_uid'], $points);
                        }
                }
                break;
@@ -232,20 +224,12 @@ function BONUS_POINTS_HANDLER($MODE)
                if ($TOTAL >= $points)
                {
                        // Subtract points from userid's account
-                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET used_points=used_points+%s WHERE userid=%d LIMIT 1",
-                        array(bigintval($points), bigintval($_CONFIG['bonus_uid'])),  __FILE__, __LINE__);
-
-                       // Update mediadata as well
-                       if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-                       {
-                               // Update database
-                               MEDIA_UPDATE_ENTRY(array("total_points"), "sub", $points);
-                       }
+                       SUB_POINTS($_CONFIG['bonus_uid'], $points);
                }
                 else
                {
                        // Try to subtract from jackpot
-                       $DUMMY = SUB_JACKPOT($points);
+                       $dummy = SUB_JACKPOT($points);
                }
                break;
        }
@@ -260,15 +244,7 @@ function BONUS_PURGE_EXPIRED_TURBO_BONUS()
        if ($DELETED > 0)
        {
                // Send out email to admin
-               if (GET_EXT_VERSION("admins") >= "0.4.1")
-               {
-                       SEND_ADMIN_EMAILS_PRO(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", $DELETED, "");
-               }
-                else
-               {
-                       $msg = LOAD_EMAIL_TEMPLATE("admin_autopurge_turbo", $DELETED, "");
-                       SEND_ADMIN_EMAILS(AUTOPURGE_ADMIN_TURBO_SUBJECT, $msg);
-               }
+               SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", $DELETED, "");
        }
 }
 //