Refback will be payed now (user cannot setup currently)
[mailer.git] / inc / modules / admin / what-config_points.php
index 7d4abc3768c17e0bb5116306257f436128e171e2..7241b9727c0a1577fac2aa91f49a07f4bb81d758 100644 (file)
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
-{
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
        $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
        require($INC);
 }
 
-global $link;
-
 // Add description as navigation point
 ADD_DESCR("admin", basename(__FILE__));
 
-OPEN_TABLE("100%", "admin_content admin_content_align", "");
-if (!empty($_GET['sub']))
-{
+if (!empty($_GET['sub'])) {
        switch ($_GET['sub'])
        {
        case "points":
-               if ((empty($_POST['points_register'])) || (empty($_POST['points_ref'])))
-               {
+               if ((empty($_POST['points_register'])) || (empty($_POST['points_ref']))) {
                        unset($_POST['ok']);
                }
                break;
 
        case "ref":
-               if (isset($_GET['do']))
-               {
-                       if (((empty($_POST['lvl'])) || (empty($_POST['perc']))) && ($_GET['do'] == "add"))
-                       {
+               if (isset($_GET['do'])) {
+                       if (((empty($_POST['lvl'])) || (empty($_POST['perc']))) && ($_GET['do'] == "add")) {
                                unset($_POST['ok']);
                        }
                }
                break;
        }
-}
- else
-{
+} else {
        // Display overview
        $_GET['sub'] = "overview";
 }
 
-if (isset($_POST['ok']))
-{
+if (isset($_POST['ok'])) {
        $SQL = array();
        switch ($_GET['sub'])
        {
@@ -85,26 +74,24 @@ if (isset($_POST['ok']))
                switch ($_GET['do'])
                {
                case "add":
-                       $SQL[] = "INSERT INTO "._MYSQL_PREFIX."_refdepths (level, percents) VALUES ('".$_POST['lvl']."', '".$_POST['perc']."')";
+                       $SQL[] = "INSERT INTO "._MYSQL_PREFIX."_refdepths (level, percents) VALUES ('".$_POST['lvl']."','".$_POST['perc']."')";
                        break;
 
                case "edit": // Change entries
-                       foreach ($_POST['lvl'] as $id=>$value)
-                       {
+                       foreach ($_POST['lvl'] as $id => $value) {
                                // Secure ID
                                $id = bigintval($id);
 
                                // Update entry
-                               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refdepths SET level='%s', percents='%s' WHERE id=%d LIMIT 1",
+                               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refdepths SET level=%s, percents='%s' WHERE id=%s LIMIT 1",
                                 array(bigintval($value), $_POST['perc'][$id], $id), __FILE__, __LINE__);
                        }
                        $TEXT = REF_DEPTHS_SAVED;
                        break;
 
                case "del":
-                       foreach ($_POST['id'] as $id=>$value)
-                       {
-                               $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refdepths WHERE id=%d LIMIT 1",
+                       foreach ($_POST['id'] as $id => $value) {
+                               $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refdepths WHERE id=%s LIMIT 1",
                                 array(bigintval($id)), __FILE__, __LINE__);
                        }
                        $TEXT = REF_DEPTHS_DELETED;
@@ -112,8 +99,7 @@ if (isset($_POST['ok']))
                }
 
                // Update cache file
-               if (GET_EXT_VERSION("cache") >= "0.1.2")
-               {
+               if (GET_EXT_VERSION("cache") >= "0.1.2") {
                        if ($cacheInstance->cache_file("refdepths", true)) $cacheInstance->cache_destroy();
                }
                break;
@@ -123,7 +109,7 @@ if (isset($_POST['ok']))
                $SQL[] = sprintf("UPDATE "._MYSQL_PREFIX."_config SET
 allow_direct_pay='%s',
 reg_points_mode='%s',
-ref_payout='%d'
+ref_payout='%s'
 WHERE config=0 LIMIT 1",
  $_POST['allow_direct_pay'],
  $_POST['reg_points_mode'],
@@ -132,8 +118,8 @@ WHERE config=0 LIMIT 1",
                if (($_CONFIG['ref_payout'] == 0) && ($_POST['ref_payout'] > 0))
                {
                        // Update account's ref_payout for "must-confirm"
-                       $SQL[] = sprintf("UPDATE "._MYSQL_PREFIX."_user_data SET ref_payout=(%d - mails_confirmed)
-WHERE mails_confirmed < %d", $REF, $REF);
+                       $SQL[] = sprintf("UPDATE "._MYSQL_PREFIX."_user_data SET ref_payout=(%s - mails_confirmed)
+WHERE mails_confirmed < %s", $REF, $REF);
                }
                 elseif (($_CONFIG['ref_payout'] > 0) && ($_POST['ref_payout'] == 0))
                {
@@ -148,7 +134,7 @@ WHERE mails_confirmed < %d", $REF, $REF);
        {
                if (strpos($SQL[0], "INSERT") > -1)
                {
-                       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_refdepths WHERE level='%s' LIMIT 1",
+                       $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_refdepths WHERE level=%s LIMIT 1",
                         array(bigintval($_POST['lvl'])), __FILE__, __LINE__);
                        SQL_FREERESULT($result);
                }
@@ -163,11 +149,7 @@ WHERE mails_confirmed < %d", $REF, $REF);
                        $content = "<SPAN class=\"admin_done\">".SETTINGS_SAVED."</SPAN>";
 
                        // Destroy config cache file here...
-                       if (GET_EXT_VERSION("cache") >= "0.1.2")
-                       {
-                               if ($cacheInstance->cache_file("config", true)) $cacheInstance->cache_destroy();
-                               unset($cacheArray);
-                       }
+                       REBUILD_CACHE("config", "config");
                }
                 else
                {
@@ -217,9 +199,9 @@ WHERE mails_confirmed < %d", $REF, $REF);
        {
                // Delete entries
                $SW = 2; $OUT = "";
-               foreach ($_POST['sel'] as $id=>$value)
+               foreach ($_POST['sel'] as $id => $value)
                {
-                       $result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%d LIMIT 1",
+                       $result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%s LIMIT 1",
                         array(bigintval($id)), __FILE__, __LINE__);
                        list($lvl, $perc) = SQL_FETCHROW($result);
                        SQL_FREERESULT($result);
@@ -245,9 +227,9 @@ WHERE mails_confirmed < %d", $REF, $REF);
        {
                // Edit entries
                $SW = 2; $OUT = "";
-               foreach ($_POST['sel'] as $id=>$value)
+               foreach ($_POST['sel'] as $id => $value)
                {
-                       $result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%d LIMIT 1",
+                       $result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%s LIMIT 1",
                         array(bigintval($id)), __FILE__, __LINE__);
                        list($lvl, $perc) = SQL_FETCHROW($result);
                        SQL_FREERESULT($result);
@@ -321,6 +303,5 @@ WHERE mails_confirmed < %d", $REF, $REF);
        LOAD_TEMPLATE("admin_config_points");
 }
 
-CLOSE_TABLE();
 //
 ?>