]> git.mxchange.org Git - mailer.git/blobdiff - inc/pool-update.php
Fixes for sql_patches removal vs. password reset of admin
[mailer.git] / inc / pool-update.php
index fc71a8ae81f281e9cf156b54fde61c7421895554..c110f343069ee611c0e834b9d9240fbe351a720b 100644 (file)
@@ -54,13 +54,13 @@ if ($HTML_EXT)
 }
 
 // Reset variables
-$cnt = "0"; $cnt2 = "0"; $LAST_SENT_ID = "0"; $cnt_back = array("0"); $POINTS_BACK = array("0");
+$cnt = "0"; $cnt2 = "0"; $LAST_SENT_ID = "0"; $cnt_back = array("0"); $points_BACK = array("0");
 if (SQL_NUMROWS($result_main) > 0)
 {
        while ($DATA = SQL_FETCHROW($result_main))
        {
                // Check fetched data for HTML
-               $HTML = $DATA[10]; if ($HTML == $DATA[0]) $HTML = 'N';
+               $HTML = $DATA[10]; if ($HTML == $DATA[0]) $HTML = "N";
 
                // Compile URL and subject line
                $DATA[7] = COMPILE_CODE($DATA[7]);
@@ -86,7 +86,7 @@ if (SQL_NUMROWS($result_main) > 0)
                                // No users left
                                $RECEIVERS = array("0");
                        }
-                       $DUMMY = $RECEIVERS;
+                       $dummy = $RECEIVERS;
 
                        // Now, if we are good little boys and girls Santa left us some user-ids.
                        // We can now send mails to them...
@@ -131,8 +131,8 @@ if (SQL_NUMROWS($result_main) > 0)
                                                SQL_FREERESULT($result_stats);
 
                                                // Mark this user as "spammed" ;-) And place a line for him...
-                                               //* DEBUG: */ echo "?L:".__LINE__."/".$DUMMY."/".$key."/".$uid."(".$DATA[1].")/".$DATA[0]."/".$stats_id."?<br />";
-                                               switch (REMOVE_RECEIVER($DUMMY, $key, bigintval($uid), bigintval($DATA[0]), bigintval($stats_id)))
+                                               //* DEBUG: */ echo "?L:".__LINE__."/".$dummy."/".$key."/".$uid."(".$DATA[1].")/".$DATA[0]."/".$stats_id."?<br />";
+                                               switch (REMOVE_RECEIVER($dummy, $key, bigintval($uid), bigintval($DATA[0]), bigintval($stats_id)))
                                                {
                                                case "done":
                                                        // Prepare the mail
@@ -179,8 +179,8 @@ if (SQL_NUMROWS($result_main) > 0)
                                                }
                                        }
 
-                                       // Do we have reached the maximum to send mails? || ($CONFIG['max_send'] >= $cnt)
-                                       //* DEBUG: */ echo "*L:".__LINE__."/".$cnt.">=".$DATA[8]."/".$CONFIG['max_send'].">=".$cnt."/".$LAST_SENT_ID."!=".$DATA[0]."*<br />";
+                                       // Do we have reached the maximum to send mails? || ($_CONFIG['max_send'] >= $cnt)
+                                       //* DEBUG: */ echo "*L:".__LINE__."/".$cnt.">=".$DATA[8]."/".$_CONFIG['max_send'].">=".$cnt."/".$LAST_SENT_ID."!=".$DATA[0]."*<br />";
                                        if ((($cnt >= $DATA[8])) && ($LAST_SENT_ID != $DATA[0]))
                                        {
                                                // Yes we do, so we notify admin and sender about fully sent mail!
@@ -232,13 +232,13 @@ if (SQL_NUMROWS($result_main) > 0)
                                                break;
                                        }
                                        // Do we have send maximum mails?
-                                        elseif (($cnt >= $CONFIG['max_send']) || ($cnt2 >= $CONFIG['max_send']))
+                                        elseif (($cnt >= $_CONFIG['max_send']) || ($cnt2 >= $_CONFIG['max_send']))
                                        {
                                                // There are some mails left to send for next round, so we reset the status back to NEW (=still not fully delivered)
                                                $ADD = "";
                                                if ($cnt <= $DATA[8]) $ADD = ", target_send=target_send-".$cnt;
                                                $result_queue = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_pool SET data_type='NEW', receivers='%s'".$ADD." WHERE id=%d LIMIT 1",
-                                                array(implode(";", $DUMMY), bigintval($DATA[0])), __FILE__, __LINE__);
+                                                array(implode(";", $dummy), bigintval($DATA[0])), __FILE__, __LINE__);
 
                                                //* DEBUG: */ echo"*EXIT/L:".__LINE__."*<br />";
                                                break;
@@ -258,36 +258,36 @@ if (SQL_NUMROWS($result_main) > 0)
                                                if ($uid > 0)
                                                {
                                                        // User does not exists, pay points back
-                                                       $POINTS = GET_PAY_POINTS($DATA[5]);
+                                                       $points = GET_PAY_POINTS($DATA[5]);
                                                        $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s WHERE userid=%d AND ref_depth=0 LIMIT 1",
-                                                        array($POINTS, bigintval($DATA[1])), __FILE__, __LINE__);
+                                                        array($points, bigintval($DATA[1])), __FILE__, __LINE__);
 
                                                        // Update mediadata as well
                                                        if (GET_EXT_VERSION("mediadata") >= "0.0.4")
                                                        {
                                                                // Update database
-                                                               //* DEBUG: */ echo "*MEDIA/L:".__LINE__."/".$POINTS."*<br />";
-                                                               MEDIA_UPDATE_ENTRY(array("total_points"), "add", $POINTS);
+                                                               //* DEBUG: */ echo "*MEDIA/L:".__LINE__."/".$points."*<br />";
+                                                               MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
                                                        }
 
                                                        // Add points together and remove user
-                                                       $POINTS_BACK[$DATA[1]] += $POINTS;
+                                                       $points_BACK[$DATA[1]] += $points;
                                                }
                                                $cnt_back[$DATA[1]]++;
                                        }
                                        // Remove entry from list
-                                       unset($DUMMY[$key]);
+                                       unset($dummy[$key]);
 
                                        // Update receivers
                                        $result_queue = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_pool SET receivers='%s' WHERE id=%d LIMIT 1",
-                                        array(implode(";", $DUMMY), bigintval($DATA[0])), __FILE__, __LINE__);
+                                        array(implode(";", $dummy), bigintval($DATA[0])), __FILE__, __LINE__);
                                }
                        }
                }
        }
-       if ((sizeof($POINTS_BACK) > 0) && (!empty($POINTS_BACK[0])))
+       if ((sizeof($points_BACK) > 0) && (!empty($points_BACK[0])))
        {
-               foreach ($POINTS_BACK as $uid=>$PB)
+               foreach ($points_BACK as $uid=>$PB)
                {
                        // Add points only when we have points left to add and a valid user ID
                        if (($PB > 0) && ($uid > 0))
@@ -331,7 +331,7 @@ if (SQL_NUMROWS($result_main) > 0)
 SQL_FREERESULT($result_main);
 
 // Only send bonus mail when bonus extension is active and maximum send-mails is not reached
-if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
+if ((EXT_IS_ACTIVE("bonus") && ($cnt < $_CONFIG['max_send'])))
 {
        // Do we need to send out bonus mails?
        if ($HTML_EXT)
@@ -374,7 +374,7 @@ if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
                                // No users left
                                $RECEIVERS = array("0");
                        }
-                       $DUMMY = $RECEIVERS;
+                       $dummy = $RECEIVERS;
 
                        // Now, if we are good little boys and girls Santa left us some user-ids.
                        // We can now send mails to them...
@@ -393,7 +393,7 @@ if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
                                        //* DEBUG: */ echo "OK!/L:".__LINE__."<br />";
 
                                        // Mark this user as "spammed" ;-) And place a line for him...
-                                       if (REMOVE_RECEIVER($DUMMY, $key, $uid, $DATA[0], $DATA[0], true) == "done")
+                                       if (REMOVE_RECEIVER($dummy, $key, $uid, $DATA[0], $DATA[0], true) == "done")
                                        {
                                                // Prepare the mail
                                                $msg = LOAD_EMAIL_TEMPLATE("bonus-mail", $DATA[2], $uid);
@@ -402,7 +402,7 @@ if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
                                                SEND_EMAIL($email, $DATA[1], $msg, $DATA[11]);
 
                                                // Count one up and remove entry from dummy array
-                                               $cnt++; unset($DUMMY[$key]);
+                                               $cnt++; unset($dummy[$key]);
 
                                                if (GET_EXT_VERSION("user") >= "0.1.4")
                                                {
@@ -412,7 +412,7 @@ if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
                                                }
 
                                                // Do we have send maximum mails?
-                                               if (($cnt >= $CONFIG['max_send']) || (SELECTION_COUNT($DUMMY) == 0))
+                                               if (($cnt >= $_CONFIG['max_send']) || (SELECTION_COUNT($dummy) == 0))
                                                {
                                                        // Yes, we have
                                                        //* DEBUG: */ echo "*EXIT/L:".__LINE__."<br />";
@@ -436,8 +436,8 @@ if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
                        }
 
                        // Close sending system
-                       //* DEBUG: */ echo "-L:".__LINE__."/".SELECTION_COUNT($DUMMY)."-<br />";
-                       if (SELECTION_COUNT($DUMMY) == 0)
+                       //* DEBUG: */ echo "-L:".__LINE__."/".SELECTION_COUNT($dummy)."-<br />";
+                       if (SELECTION_COUNT($dummy) == 0)
                        {
                                // Queue reached!
                                $result_done = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_bonus SET data_type='SEND', target_send='0', receivers='' WHERE id=%d LIMIT 1",
@@ -452,13 +452,13 @@ if ((EXT_IS_ACTIVE("bonus") && ($cnt < $CONFIG['max_send'])))
                                        MEDIA_UPDATE_ENTRY(array("total_orders", "bonus_orders"), "add", 1);
                                }
                        }
-                        elseif ($cnt >= $CONFIG['max_send'])
+                        elseif ($cnt >= $_CONFIG['max_send'])
                        {
                                // Update bonus pool
                                $result_done = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_bonus SET data_type='NEW', target_send=%d, receivers='%s' WHERE id=%d LIMIT 1",
-                                array(SELECTION_COUNT($DUMMY), implode(";", $DUMMY), bigintval($DATA[0])), __FILE__, __LINE__);
+                                array(SELECTION_COUNT($dummy), implode(";", $dummy), bigintval($DATA[0])), __FILE__, __LINE__);
                                //* DEBUG: */ echo "*L:".__LINE__."<PRE>";
-                               //* DEBUG: */ print_r($DUMMY);
+                               //* DEBUG: */ print_r($dummy);
                                //* DEBUG: */ echo "</PRE>\n!!!<br />";
                                break;
                        }