projects / mailer.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Login procedure rewritten to filters (internal TODO)
[mailer.git] / inc / libs / bonus_functions.php
diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 5b7358917ef5bec4e9a2ba12e4b24bdc0c207ee6..af551a1b82a40a81f378f4a6dd58682ce3a8244c 100644 (file)
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 11/10/2004 *
- * ===============                              Last change: 03/18/2005 *
+ * Mailer v0.2.1-FINAL                                Start: 11/10/2004 *
+ * ===================                          Last change: 03/18/2005 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : bonus_functions.php                              *
@@ -47,7 +47,7 @@ function addTurboBonus ($mid, $userid, $type) {
        if (getConfig('bonus_active') != 'Y') return false;
 
        // Init variables
-       $sql = ''; $bonus = 0; $mail = 0; $column = '';
+       $sql = ''; $bonus = '0'; $mail = '0'; $column = '';
 
        // Select SQL command
        switch ($type) {
@@ -93,7 +93,10 @@ function addTurboBonus ($mid, $userid, $type) {
 
        // Add points to his account directly
        SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1",
-               array(bigintval($userid), $points), __FUNCTION__, __LINE__);
+               array(
+                       bigintval($userid),
+                       $points
+               ), __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())",
@@ -121,7 +124,13 @@ function addBonusRanks ($data, $type, $userid) {
 
        // 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, $userid), __FUNCTION__, __LINE__);
+               array(
+                       $type,
+                       $data,
+                       $userid
+               ), __FUNCTION__, __LINE__);
+
+       // Entry found?
        if (SQL_NUMROWS($result) == 1) {
                // Load data
                $GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], SQL_FETCHARRAY($result));
@@ -132,15 +141,15 @@ function addBonusRanks ($data, $type, $userid) {
                // Transfer data to template
                $GLOBALS['ranking_content']['yr_level']  = $GLOBALS['ranking_content']['level'];
                $GLOBALS['ranking_content']['yr_points'] = translateComma($GLOBALS['ranking_content']['points']);
-               $GLOBALS['ranking_content']['yr_tmark']  = generateDateTime($GLOBALS['ranking_content']['timemark'], '1');
+               $GLOBALS['ranking_content']['yr_tmark']  = generateDateTime($GLOBALS['ranking_content']['timemark'], 1);
 
                // Load template
                $GLOBALS['ranking_content']['own'] = loadTemplate('show_bonus_yr', true, $GLOBALS['ranking_content']);
        } // END - if
 
        // Load rankings
-       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE %s=%s ORDER BY `level` ASC LIMIT %s",
-               array($type, $data, getConfig('bonus_lines')), __FUNCTION__, __LINE__);
+       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE %s=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}",
+               array($type, $data), __FUNCTION__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // Start generating the ranking list
                $max = SQL_NUMROWS($result);
@@ -170,6 +179,15 @@ LIMIT 1",
                                // Load data
                                $rows = merge_array($rows, SQL_FETCHARRAY($result_users));
 
+                               // Is ext-nickname active?
+                               if (isExtensionActive('nickname')) {
+                                       // Then get the nickname
+                                       $nick = getNickname($rows['userid']);
+
+                                       // Is it not empty? Then use it
+                                       if (!empty($nick)) $rows['userid'] = $nick;
+                               } // END - if
+
                                // Translate comma
                                $rows['points'] = translateComma($rows['points']);
                        } // END - if
@@ -183,9 +201,9 @@ LIMIT 1",
 
                        // Output row
                        $OUT .= "<tr>
-  <td class=\"bonus_rank_".$rows['rank']." bottom2 switch_sw".$rows['sw']."\">&nbsp;".$rows['rank'].".</td>
-  <td class=\"bonus_rank_".$rows['rank']." bottom2 switch_sw".$rows['sw']."\" align=\"center\">".$rows['userid']."</td>
-  <td class=\"bonus_rank_".$rows['rank']." bottom2 switch_sw".$rows['sw']."\" align=\"center\">".$rows['points']."</td>
+  <td class=\"bonus_rank_".$rows['rank']." bottom switch_sw".$rows['sw']."\">&nbsp;".$rows['rank'].".</td>
+  <td class=\"bonus_rank_".$rows['rank']." bottom switch_sw".$rows['sw']."\" align=\"center\">".$rows['userid']."</td>
+  <td class=\"bonus_rank_".$rows['rank']." bottom switch_sw".$rows['sw']."\" align=\"center\">".$rows['points']."</td>
 </tr>\n";
 
                        // Switch color
@@ -200,7 +218,7 @@ LIMIT 1",
        } else {
                // No entries found!
                $OUT = "<tr>
-  <td colspan=\"3\" align=\"center\" height=\"30\" class=\"bottom2\">
+  <td colspan=\"3\" align=\"center\" height=\"30\" class=\"bottom\">
     <div class=\"guest_failed\">".sprintf(getMessage('BONUS_NO_RANKS'), $data)."</div>
   </td>
 </tr>\n";
@@ -229,22 +247,21 @@ function handleBonusPoints ($mode) {
                $points = $mode;
        }
 
+       // Check his amount first
+       $total = countSumTotalData(getConfig('bonus_userid'), 'user_points', 'points') - countSumTotalData(getConfig('bonus_userid'), 'user_data', 'used_points');
+
        // Subtract points from...
        switch (getConfig('bonus_mode')) {
                case 'JACKPOT': // ... jackpot
                        if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) == -1) && (getConfig('bonus_userid') > 0)) {
-                               // Check points amount first...
-                               $total = countSumTotalData(getConfig('bonus_userid'), 'user_points', 'points') - countSumTotalData(getConfig('bonus_userid'), 'user_data', 'used_points');
                                if ($total >= $points) {
                                        // Subtract points from userid's account
-                                       subtractPoints('bonus_payout_jackpot', getConfig('bonus_userid'), $points);
+                                       subtractPointsFromJackpot('bonus_payout_jackpot', getConfig('bonus_userid'), $points);
                                } // END - if
                        } // END - if
                        break;
 
                case 'UID': // ... userid's account
-                       // Check his amount first
-                       $total = countSumTotalData(getConfig('bonus_userid'), 'user_points', 'points') - countSumTotalData(getConfig('bonus_userid'), 'user_data', 'used_points');
                        if ($total >= $points) {
                                // Subtract points from userid's account
                                subtractPoints('bonus_payout_userid', getConfig('bonus_userid'), $points);
@@ -253,7 +270,7 @@ function handleBonusPoints ($mode) {
                                $dummy = subtractPointsFromJackpot($points);
                        }
                        break;
-       }
+       } // END - switch
 }
 
 // Purges expired fast-click bonus entries
@@ -267,5 +284,50 @@ function purgeExpiredTurboBonus() {
        } // END - if
 }
 
-//
+///////////////////////////////////////////////////////////////////////////////
+//                              Only filter functions
+///////////////////////////////////////////////////////////////////////////////
+
+// Filter for adding login bonus to the user's account
+function FILTER_ADD_LOGIN_BONUS () {
+       // Is the user data valid?
+       if (!isMember()) {
+               // Do only run for logged in members
+               debug_report_bug('Please only run this filter for logged in users.');
+       } // END - if
+
+       // Bonus is not given by default ;-)
+       $bonus = false;
+       if ((isExtensionInstalledAndNewer('sql_patches', '0.2.8')) && (getConfig('bonus_active') == 'Y') && (getConfig('bonus_login_yn') == 'Y')) {
+               // Update last login if far enougth away
+               // @TODO This query isn't right, it will only update if the user was for a longer time away!
+               SQL_QUERY_ESC("UPDATE
+       `{?_MYSQL_PREFIX?}_user_data`
+SET
+       `last_login`=UNIX_TIMESTAMP()
+WHERE
+       `userid`=%s AND
+       `last_login` < (UNIX_TIMESTAMP() - {?login_timeout?})
+LIMIT 1",
+                       array(
+                               getMemberId()
+                       ), __FILE__, __LINE__
+               );
+
+               // Updated entry?
+               $bonus = (SQL_AFFECTEDROWS() == 1);
+       } // END - if
+
+       if (($bonus === true) && (getRequestElement('mode') == 'bonus')) {
+               // Output message with added points
+               $GLOBALS['message'] .= "<div class=\"tiny\">
+  ".sprintf(getMessage('BONUS_LOGIN_BONUS_ADDED'), translateComma(getConfig('login_bonus')))."
+</div>";
+       } elseif (isExtensionActive('bonus')) {
+               // No login bonus added!
+               $GLOBALS['message'] .= "<div class=\"member_failed\">{--BONUS_LOGIN_BONUS_NOT_ADDED--}</div>";
+       }
+}
+
+// [EOF]
 ?>
Mailer-Project repository