query masking rewritten in more SQLs, several cleanups and fix on beg link

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

diff --git a/inc/monthly/monthly_bonus.php b/inc/monthly/monthly_bonus.php
index 1dec6c3bef6a4478ce355a66ba9f02d74d25f481..d877e5e6f9f50bf9818b108ea9f6f6f14d551047 100644 (file)
--- a/inc/monthly/monthly_bonus.php
+++ b/inc/monthly/monthly_bonus.php
@@ -71,11 +71,11 @@ if (($curr != $CONFIG['bonus_month']) && ($CONFIG['bonus_ranks'] > 0) && ($CSS !
 
        // Add more bonus points here
        $ADD = " AND (0";
-       if ($CONFIG['bonus_click_yn'] == "Y") $ADD .= " + turbo_bonus";
-       if ($CONFIG['bonus_login_yn'] == "Y") $ADD .= " + login_bonus";
-       if ($CONFIG['bonus_order_yn'] == "Y") $ADD .= " + bonus_order";
-       if ($CONFIG['bonus_stats_yn'] == "Y") $ADD .= " + bonus_stats";
-       if ($CONFIG['bonus_ref_yn']   == "Y") $ADD .= " + bonus_ref";
+       if ($CONFIG['bonus_click_yn'] == 'Y') $ADD .= " + turbo_bonus";
+       if ($CONFIG['bonus_login_yn'] == 'Y') $ADD .= " + login_bonus";
+       if ($CONFIG['bonus_order_yn'] == 'Y') $ADD .= " + bonus_order";
+       if ($CONFIG['bonus_stats_yn'] == 'Y') $ADD .= " + bonus_stats";
+       if ($CONFIG['bonus_ref_yn']   == 'Y') $ADD .= " + bonus_ref";
        $ADD .= ") > 0";
 
        // SQL string to check for accounts
@@ -96,7 +96,7 @@ ORDER BY active_bonus DESC, userid LIMIT %s",
 
                        // Add points to user's account directly
                        $result_data = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points
-SET points=points+%s WHERE ref_depth='0' AND userid=%d LIMIT 1",
+SET points=points+%s WHERE ref_depth=0 AND userid=%d LIMIT 1",
  array($points, bigintval($uid)), __FILE__, __LINE__);
 
                        // Update mediadata as well