More improved SQL queries

[mailer.git] / inc / monthly / monthly_beg.php

diff --git a/inc/monthly/monthly_beg.php b/inc/monthly/monthly_beg.php
index c11b477238a04065d7510df981283424824be59e..17a38d2a8b69c10cdb168d03ffc86421271c92b9 100644 (file)
--- a/inc/monthly/monthly_beg.php
+++ b/inc/monthly/monthly_beg.php
@@ -69,8 +69,8 @@ if (($curr != getConfig('last_month')) && (getConfig('last_month') > 0) && (getC
 
        // SQL string to check for accounts
        $result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, beg_points AS points
-FROM `{!MYSQL_PREFIX!}_user_data`
-WHERE status='CONFIRMED'".$whereStatement1." AND beg_points > 0
+FROM `{!_MYSQL_PREFIX!}_user_data`
+WHERE `status`='CONFIRMED'".$whereStatement1." AND beg_points > 0
 ORDER BY beg_points DESC, userid
 LIMIT %s",
                array($whereStatement2), __FILE__, __LINE__);
@@ -91,7 +91,7 @@ LIMIT %s",
                } // END - while
 
                // Reset accounts
-               $result = SQL_QUERY("UPDATE `{!MYSQL_PREFIX!}_user_data` SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__);
+               $result = SQL_QUERY("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__);
        } // END - if
 
        // Free memory