Several more constants rewritten to getConfig()

[mailer.git] / inc / modules / admin / what-config_points.php

diff --git a/inc/modules/admin/what-config_points.php b/inc/modules/admin/what-config_points.php
index a37e7414d79b3e063fc2a30cc9bb60743fb59fba..6be930611ab19b57a16f55b809e5087dfa641672 100644 (file)
--- a/inc/modules/admin/what-config_points.php
+++ b/inc/modules/admin/what-config_points.php
@@ -75,7 +75,7 @@ if (isFormSent()) {
        INIT_SQLS();
        switch (REQUEST_GET('sub')) {
                case 'points':
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_config` SET points_register='".REQUEST_POST('points_register')."', points_ref='".REQUEST_POST('points_ref')."' WHERE config=0 LIMIT 1");
+                       updateConfiguration(array('points_register', 'points_ref'), array(REQUEST_POST('points_register'), REQUEST_POST('points_ref')));
                        break;
 
                case 'ref':
@@ -117,24 +117,19 @@ if (isFormSent()) {
 
                                case "settings":
                                        $REF = bigintval(REQUEST_POST('ref_payout'));
-                                       ADD_SQL(sprintf("UPDATE `{!_MYSQL_PREFIX!}_config` SET
-allow_direct_pay='%s',
-reg_points_mode='%s',
-ref_payout='%s'
-WHERE config=0 LIMIT 1",
-                                       REQUEST_POST('allow_direct_pay'),
-                                       REQUEST_POST('reg_points_mode'),
-                                       $REF
-                                       ));
+                                       updateConfiguration(
+                                               array('allow_direct_pay', 'reg_points_mode', 'ref_payout'),
+                                               array(REQUEST_POST('allow_direct_pay'), REQUEST_POST('reg_points_mode'), $REF)
+                                       );
                                        if ((getConfig('ref_payout') == 0) && (REQUEST_POST('ref_payout') > 0)) {
                                                // Update account's ref_payout for "must-confirm"
-                                               ADD_SQL(sprintf("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET ref_payout=(%s - mails_confirmed)
-WHERE mails_confirmed < %s", $REF, $REF));
+                                               ADD_SQL(sprintf("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `ref_payout`=(%s - `mails_confirmed`)
+WHERE `mails_confirmed` < %s", $REF, $REF));
                                        } elseif ((getConfig('ref_payout') > 0) && (REQUEST_POST('ref_payout') == 0)) {
                                                // Update account's ref_payout for "not-must-confirm"
-                                               ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET ref_payout=0 WHERE ref_payout > 0");
-                                               ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_user_points` SET points=points+locked_points WHERE locked_points>0");
-                                               ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_user_points` SET locked_points=0 WHERE locked_points>0");
+                                               ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `ref_payout`=0 WHERE `ref_payout` > 0");
+                                               ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_user_points` SET `points`=`points`+`locked_points` WHERE `locked_points` > 0");
+                                               ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_user_points` SET `locked_points`=0 WHERE `locked_points` > 0");
                                        }
                                        break;
        }