Refactured
authorRoland Häder <roland@mxchange.org>
Fri, 25 Jan 2008 22:46:58 +0000 (22:46 +0000)
committerRoland Häder <roland@mxchange.org>
Fri, 25 Jan 2008 22:46:58 +0000 (22:46 +0000)
0.2.1/inc/libs/task_functions.php

index ee72a2a..c16eca1 100644 (file)
@@ -32,8 +32,7 @@
  ************************************************************************/\r
 \r
 // Some security stuff...\r
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))\r
-{\r
+if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {\r
        $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
        require($INC);\r
 }\r
@@ -55,8 +54,7 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        // Chheck for new extensions and updates\r
        $JOBS_DONE = OUTPUT_STANDARD_OVERVIEW($result_main);\r
 \r
-       if (!$JOBS_DONE)\r
-       {\r
+       if (!$JOBS_DONE) {\r
                // New extensions or updates found\r
                $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE assigned_admin='%s' AND status='NEW' AND task_type='EXTENSION_UPDATE'",\r
                 array(GET_ADMIN_ID($_COOKIE['admin_login'])), __FILE__, __LINE__);\r
@@ -64,17 +62,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
                $value = SQL_NUMROWS($result);\r
                SQL_FREERESULT($result);\r
 \r
-               if ($value > 0)\r
-               {\r
+               if ($value > 0) {\r
                        define ('__TASK_UPDATE_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=updates\">".$value."</A>");\r
-               }\r
-                else\r
-               {\r
+               } else {\r
                        define ('__TASK_UPDATE_VALUE', "0");\r
                }\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define ('__TASK_UPDATE_VALUE', "0");\r
        }\r
 \r
@@ -86,40 +79,34 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__CONFIRMED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_user&amp;mode=confirmed\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__CONFIRMED_VALUE', "0");\r
        }\r
+
        // Unconfirmed accounts\r
        $result = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED'", __FILE__, __LINE__);\r
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__UNCONFIRMED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=chk_regs\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__UNCONFIRMED_VALUE', "0");\r
        }\r
+
        // And locked accounts\r
        $result = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='LOCKED'", __FILE__, __LINE__);\r
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__LOCKED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_user&amp;mode=locked\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__LOCKED_VALUE', "0");\r
        }\r
+
        //\r
        // Unassigned tasks\r
        //\r
@@ -127,14 +114,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__TASK_NEW_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=unassigned\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__TASK_NEW_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Closed tasks\r
        //\r
@@ -142,14 +127,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__TASK_CLOSED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=closed\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__TASK_CLOSED_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Deleted tasks\r
        //\r
@@ -157,14 +140,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__TASK_DELETED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=deleted\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__TASK_DELETED_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Solved tasks\r
        //\r
@@ -173,14 +154,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__TASK_SOLVED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=solved\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__TASK_SOLVED_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Your tasks\r
        //\r
@@ -189,14 +168,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__TASK_YOUR_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__TASK_YOUR_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Mails waiting to be approved\r
        //\r
@@ -204,14 +181,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__MAIL_ADMIN_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=unlock_emails\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__MAIL_ADMIN_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Unfinished mail orders\r
        //\r
@@ -219,14 +194,12 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__MAIL_TEMP_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__MAIL_TEMP_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Sent mail orders\r
        //\r
@@ -234,91 +207,69 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
        $value = SQL_NUMROWS($result);\r
        SQL_FREERESULT($result);\r
 \r
-       if ($value > 0)\r
-       {\r
+       if ($value > 0) {\r
                define('__MAIL_SEND_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_archiv\">".$value."</A>");\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__MAIL_SEND_VALUE', "0");\r
-       }\r
+       }
+\r
        //\r
        // Autopurged mails\r
        //\r
-       if (EXT_IS_ACTIVE("autopurge"))\r
-       {\r
+       if (EXT_IS_ACTIVE("autopurge")) {\r
                $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_pool WHERE data_type='DELETED'", __FILE__, __LINE__);\r
                $value = SQL_NUMROWS($result);\r
                SQL_FREERESULT($result);\r
 \r
-               if ($value > 0)\r
-               {\r
+               if ($value > 0) {\r
                        define('__MAIL_DELETED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
-               }\r
-                else\r
-               {\r
+               } else {\r
                        define('__MAIL_DELETED_VALUE', "0");\r
-               }\r
+               }
+\r
                //\r
                // Autopurged bonus mails\r
                //\r
-               if (GET_EXT_VERSION("bonus") >= "0.1.8")\r
-               {\r
+               if (GET_EXT_VERSION("bonus") >= "0.1.8") {\r
                        $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE data_type='DELETED'", __FILE__, __LINE__);\r
                        $value = SQL_NUMROWS($result);\r
                        SQL_FREERESULT($result);\r
 \r
-                       if ($value > 0)\r
-                       {\r
+                       if ($value > 0) {\r
                                define('__MAIL_BONUS_AP_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
-                       }\r
-                        else\r
-                       {\r
+                       } else {\r
                                define('__MAIL_BONUS_AP_VALUE', "0");\r
                        }\r
-               }\r
-                elseif (EXT_IS_ACTIVE("bonus"))\r
-               {\r
+               } elseif (EXT_IS_ACTIVE("bonus")) {\r
                        define('__MAIL_BONUS_AP_VALUE', ADMIN_EXT_BONUS_OUTDATED_1."0.1.8".ADMIN_EXT_BONUS_OUTDATED_2);\r
-               }\r
-                else\r
-               {\r
+               } else {\r
                        define('__MAIL_BONUS_AP_VALUE', "<FONT class=\"admin_note\">".ADMIN_EXT_BONUS_404."</FONT>");\r
                }\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__MAIL_BONUS_AP_VALUE', "<FONT class=\"admin_note\">".ADMIN_EXT_AUTOPURGE_404."</FONT>");\r
                define('__MAIL_DELETED_VALUE', "<FONT class=\"admin_note\">".ADMIN_EXT_AUTOPURGE_404."</FONT>");\r
-       }\r
+       }
+\r
        //\r
        // Sent bonus mails\r
        //\r
-       if (GET_EXT_VERSION("bonus") >= "0.1.8")\r
-       {\r
+       if (GET_EXT_VERSION("bonus") >= "0.1.8") {\r
                $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE data_type='SEND'", __FILE__, __LINE__);\r
                $value = SQL_NUMROWS($result);\r
                SQL_FREERESULT($result);\r
 \r
-               if ($value > 0)\r
-               {\r
+               if ($value > 0) {\r
                        define('__MAIL_BONUS_SEND_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
-               }\r
-                else\r
-               {\r
+               } else {\r
                        define('__MAIL_BONUS_SEND_VALUE', "0");\r
                }\r
-       }\r
-        elseif (EXT_IS_ACTIVE("bonus"))\r
-       {\r
+       } elseif (EXT_IS_ACTIVE("bonus")) {\r
                define('__MAIL_BONUS_SEND_VALUE', ADMIN_EXT_BONUS_OUTDATED_1."0.1.8".ADMIN_EXT_BONUS_OUTDATED_2);\r
-       }\r
-        else\r
-       {\r
+       } else {\r
                define('__MAIL_BONUS_SEND_VALUE', ADMIN_EXT_BONUS_404);\r
-       }\r
-       if (EXT_IS_ACTIVE("autopurge"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("autopurge")) {\r
                // Start finding them...\r
                $since = (time() - $CONFIG['ap_in_since']);\r
                $EXCLUDE_LIST = " AND d.userid != c.def_refid";\r
@@ -329,8 +280,7 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
                if (EXT_IS_ACTIVE("doubler")) $EXCLUDE_LIST .= " AND d.userid != c.doubler_uid";\r
 \r
                // Check for new holiday system\r
-               if (GET_EXT_VERSION("holiday") >= "0.1.3")\r
-               {\r
+               if (GET_EXT_VERSION("holiday") >= "0.1.3") {\r
                        $EXCLUDE_LIST .= " AND d.holiday_active = 'N'";\r
                }\r
 \r
@@ -343,17 +293,17 @@ ORDER BY d.userid";
                $WHATs[]  = "list_autopurge";\r
                $DESCRs[] = TASK_ADMIN_INACTIVE_AUTOPURGE;\r
                $TITLEs[] = TASK_ADMIN_INACTIVE_AUTOPURGE_TITLE;\r
-       }\r
-       if (GET_EXT_VERSION("sql_patches") >= "0.3.4")\r
-       {\r
+       }
+\r
+       if (GET_EXT_VERSION("sql_patches") >= "0.3.4") {\r
                // Check for accounts without referral\r
                $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE refid='0' ORDER BY userid";\r
                $DESCRs[] = TAKS_ADMIN_LIST_ACCOUNT_NOREF;\r
                $TITLEs[] = TAKS_ADMIN_LIST_ACCOUNT_NOREF_TITLE;\r
                $WHATs[]  = "list_norefs";\r
-       }\r
-       if (EXT_IS_ACTIVE("payout"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("payout")) {\r
                // List new payout requests\r
                $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_payouts WHERE status='NEW' ORDER BY userid";\r
                $WHATs[]  = "list_payouts";\r
@@ -363,28 +313,27 @@ ORDER BY d.userid";
                $WHATs[]  = "list_payouts";\r
                $DESCRs[] = TASK_ADMIN_LIST_PAYOUTS_ALL;\r
                $TITLEs[] = TASK_ADMIN_LIST_PAYOUTS_ALL_TITLE;\r
-       }\r
-       if (EXT_IS_ACTIVE("wernis"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("wernis")) {\r
                // List new wernis requests\r
                $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_wernis ORDER BY userid";\r
                $WHATs[]  = "list_wernis";\r
                $DESCRs[] = TASK_ADMIN_LIST_WERNIS_ALL;\r
                $TITLEs[] = TASK_ADMIN_LIST_WERNIS_ALL_TITLE;\r
-       }\r
-       if (EXT_IS_ACTIVE("holiday"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("holiday")) {\r
                // List holiday requests\r
                $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_holidays ORDER BY userid";\r
                $WHATs[]  = "list_holiday";\r
                $DESCRs[] = TASK_ADMIN_LIST_HOLIDAYS;\r
                $TITLEs[] = TASK_ADMIN_LIST_HOLIDAYS_TITLE;\r
-       }\r
-       if (GET_EXT_VERSION("bonus") >= "0.2.3")\r
-       {\r
+       }
+\r
+       if (GET_EXT_VERSION("bonus") >= "0.2.3") {\r
                // Active rallye\r
-               if (GET_EXT_VERSION("bonus") >= "0.6.9")\r
-               {\r
+               if (GET_EXT_VERSION("bonus") >= "0.6.9") {\r
                        // Add more bonus points here\r
                        $USE = "(0";\r
                        if ($CONFIG['bonus_click_yn'] == "Y") $USE .= " + turbo_bonus";\r
@@ -393,17 +342,14 @@ ORDER BY d.userid";
                        if ($CONFIG['bonus_stats_yn'] == "Y") $USE .= " + bonus_stats";\r
                        if ($CONFIG['bonus_ref_yn']   == "Y") $USE .= " + bonus_ref";\r
                        $USE .= ")";\r
-               }\r
-                else\r
-               {\r
+               } else {\r
                        // Old version ???\r
                        $USE = "turbo_bonus";\r
                }\r
 \r
                // Autopurge installed?\r
                $LAST = ""; $ONLINE = "";\r
-               if ((EXT_IS_ACTIVE("autopurge")) && ($CONFIG['ap_inactive'] == "Y") && ($CONFIG['ap_in_since'] > 0))\r
-               {\r
+               if ((EXT_IS_ACTIVE("autopurge")) && ($CONFIG['ap_inactive'] == "Y") && ($CONFIG['ap_in_since'] > 0)) {\r
                        // Use last online timestamp to keep inactive members away from here\r
                        $LAST   = " AND last_online >= ";\r
                        $ONLINE = bigintval(time() - $CONFIG['ap_in_since']);\r
@@ -416,14 +362,13 @@ ORDER BY active_bonus DESC, userid";
                $DESCRs[] = TASK_ADMIN_LIST_BONUS;\r
                $TITLEs[] = TASK_ADMIN_LIST_BONUS_TITLE;\r
        }\r
-       if (GET_EXT_VERSION("beg") >= "0.1.2")\r
-       {\r
+
+       if (GET_EXT_VERSION("beg") >= "0.1.2") {\r
                // Begging rallye\r
 \r
                // Autopurge installed?\r
                $LAST = ""; $ONLINE = "";\r
-               if ((EXT_IS_ACTIVE("autopurge")) && ($CONFIG['ap_inactive'] == "Y") && ($CONFIG['ap_in_since'] > 0))\r
-               {\r
+               if ((EXT_IS_ACTIVE("autopurge")) && ($CONFIG['ap_inactive'] == "Y") && ($CONFIG['ap_in_since'] > 0)) {\r
                        // Use last online timestamp to keep inactive members away from here\r
                        $LAST   = " AND last_online >= ";\r
                        $ONLINE = bigintval(time() - $CONFIG['ap_in_since']);\r
@@ -436,8 +381,8 @@ ORDER BY beg_points DESC, userid";
                $DESCRs[] = TASK_ADMIN_LIST_BEG;\r
                $TITLEs[] = TASK_ADMIN_LIST_BEG_TITLE;\r
        }\r
-       if (EXT_IS_ACTIVE("doubler"))\r
-       {\r
+
+       if (EXT_IS_ACTIVE("doubler")) {\r
                // List waiting payouts\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_doubler WHERE completed='N' ORDER BY id";\r
                $WHATs[]  = "list_doubler&amp;mode=waiting&amp;select=all";\r
@@ -447,7 +392,8 @@ ORDER BY beg_points DESC, userid";
                $WHATs[]  = "list_doubler";\r
                $DESCRs[] = TASK_ADMIN_LIST_DOUBLER_ALL;\r
                $TITLEs[] = TASK_ADMIN_LIST_DOUBLER_ALL_TITLE;\r
-       }\r
+       }
+\r
        //\r
        // All referral banner\r
        //\r
@@ -455,6 +401,7 @@ ORDER BY beg_points DESC, userid";
        $WHATs[] = "refbanner";\r
        $DESCRs[] = TASK_ADMIN_LIST_REFBANNER_ALL;\r
        $TITLEs[] = TASK_ADMIN_LIST_REFBANNER_ALL_TITLE;\r
+
        //\r
        // All activated referral banner\r
        //\r
@@ -462,6 +409,7 @@ ORDER BY beg_points DESC, userid";
        $WHATs[] = "refbanner";\r
        $DESCRs[] = TASK_ADMIN_LIST_REFBANNER_ACTIVE;\r
        $TITLEs[] = TASK_ADMIN_LIST_REFBANNER_ACTIVE_TITLE;\r
+
        //\r
        // All extensions\r
        //\r
@@ -469,6 +417,7 @@ ORDER BY beg_points DESC, userid";
        $WHATs[] = "extensions";\r
        $DESCRs[] = TASK_ADMIN_LIST_EXTENSIONS_ALL;\r
        $TITLEs[] = TASK_ADMIN_LIST_EXTENSIONS_ALL_TITLE;\r
+
        //\r
        // All activated extensions\r
        //\r
@@ -476,82 +425,90 @@ ORDER BY beg_points DESC, userid";
        $WHATs[] = "extensions&amp;active=Y";\r
        $DESCRs[] = TASK_ADMIN_LIST_EXTENSIONS_ACTIVE;\r
        $TITLEs[] = TASK_ADMIN_LIST_EXTENSIONS_ACTIVE_TITLE;\r
-       //\r
-       if (EXT_IS_ACTIVE("engine"))\r
-       {\r
+\r
+       if (EXT_IS_ACTIVE("engine")) {\r
                // List all export accounts\r
                $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_accounts ORDER BY id";\r
                $WHATs[] = "list_engine";\r
                $DESCRs[] = TASK_ADMIN_LIST_ENGINE;\r
+
                // List all pending accounts\r
                $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_accounts WHERE status='UNCONFIRMED' ORDER BY id";\r
                $WHATs[] = "unlock_engine";\r
                $DESCRs[] = TASK_ADMIN_UNLOCK_ENGINE;\r
+
                // List all safes\r
                $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_safe ORDER BY id";\r
                $WHATs[] = "list_engine&amp;mode=safe";\r
                $DESCRs[] = TASK_ADMIN_LIST_ENGINE_SAFES;\r
+
                // List all export URLs\r
                $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_urls ORDER BY id";\r
                $WHATs[] = "engine_urls";\r
                $DESCRs[] = TASK_ADMIN_LIST_ENGINE_URLS;\r
-       }\r
-       if (EXT_IS_ACTIVE("sponsor"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("sponsor")) {\r
                // List all sponsors\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data ORDER BY id";\r
                $WHATs[]  = "list_sponsor";\r
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR;\r
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_TITLE;\r
+
                // List confirmed sponsor accounts\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='CONFIRMED' ORDER BY id";\r
                $WHATs[]  = "list_sponsor";\r
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED;\r
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED_TITLE;\r
+
                // List unconfirmed sponsor accounts\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='UNCONFIRMED' ORDER BY id";\r
                $WHATs[]  = "list_sponsor";\r
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED;\r
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED_TITLE;\r
+
                // List locked sponsor accounts\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='LOCKED' ORDER BY id";\r
                $WHATs[]  = "list_sponsor";\r
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED;\r
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED_TITLE;\r
+
                // List waiting sponsor accounts to be approved\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='PENDING' ORDER BY id";\r
                $WHATs[]  = "unlock_sponsor";\r
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_PENDING;\r
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_PENDING_TITLE;\r
+
                // Waiting payments\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_orders WHERE pay_status='PENDING' ORDER BY id";\r
                $WHATs[]  = "list_sponsor_pays";\r
                $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS;\r
                $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS_TITLE;\r
-       }\r
-       if (EXT_IS_ACTIVE("country"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("country")) {\r
                // List country codes\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_countries ORDER BY id";\r
                $WHATs[]  = "list_country";\r
                $DESCRs[] = TASK_ADMIN_LIST_COUNTRY;\r
                $TITLEs[] = TASK_ADMIN_LIST_COUNTRY_TITLE;\r
-       }\r
-       if (EXT_IS_ACTIVE("theme"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("theme")) {\r
                // List all themes\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_themes ORDER BY id";\r
                $WHATs[]  = "theme_edit";\r
                $DESCRs[] = TASK_ADMIN_LIST_THEME_ALL;\r
                $TITLEs[] = TASK_ADMIN_LIST_THEME_ALL_TITLE;\r
+
                // List active themes\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_themes WHERE theme_active='Y' ORDER BY id";\r
                $WHATs[]  = "theme_edit";\r
                $DESCRs[] = TASK_ADMIN_LIST_THEME_ACTIVE;\r
                $TITLEs[] = TASK_ADMIN_LIST_THEME_ACTIVE_TITLE;\r
-       }\r
-       if (EXT_IS_ACTIVE("admins"))\r
-       {\r
+       }
+\r
+       if (EXT_IS_ACTIVE("admins")) {\r
                // List all administrator logins\r
                $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_admins ORDER BY id";\r
                $WHATs[]  = "admins_edit";\r
@@ -570,13 +527,13 @@ ORDER BY beg_points DESC, userid";
 \r
        // Simply load the template... :-)\r
        LOAD_TEMPLATE("admin_overview_task");\r
-}\r
+}
+\r
 //\r
-function TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs)\r
-{\r
+function TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs){
+       // Init\r
        $OUT = ""; $SW = 2; $MAX = sizeof($SQLs) - 1;\r
-       foreach ($SQLs as $key=>$sql)\r
-       {\r
+       foreach ($SQLs as $key=>$sql) {\r
                // Run SQL command, get line numbers and free memory\r
                $result = SQL_QUERY($sql, __FILE__, __LINE__);\r
                $value = SQL_NUMROWS($result);\r
@@ -586,15 +543,13 @@ function TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs)
                        'row_descr' => $DESCRs[$key],\r
                        'row_sw'    => $SW,\r
                        'bottom'    => "",\r
-               );\r
+               );
+\r
                if ($key < $MAX) $content['bottom'] = "bottom2";\r
-               if (($value > 0) && (!empty($WHATs[$key])))\r
-               {\r
+               if (($value > 0) && (!empty($WHATs[$key]))) {\r
                        if (empty($TITLEs[$key])) $TITLEs[$key] = TASK_ADMIN_UNKNOWN_LIST_TITLE;\r
                        $content['row_link'] = "<A href=\"".URL."/modules.php?module=admin&amp;what=".$WHATs[$key]."\" title=\"".$TITLEs[$key]."\">".$value."</A>";\r
-               }\r
-                else\r
-               {\r
+               } else {\r
                        $content['row_link'] = "0";\r
                }\r
 \r