0.2.1/inc/libs/task_functions.php

   1 <?php\r
   2 /************************************************************************\r
   3  * MXChange v0.2.1                                    Start: 08/03/2004 *\r
   4  * ================                             Last change: 11/19/2005 *\r
   5  *                                                                      *\r
   6  * -------------------------------------------------------------------- *\r
   7  * File              : task_functions.php                               *\r
   8  * -------------------------------------------------------------------- *\r
   9  * Short description : Special task functions                           *\r
  10  * -------------------------------------------------------------------- *\r
  11  * Kurzbeschreibung  : Spezielle task-Funktionen                        *\r
  12  * -------------------------------------------------------------------- *\r
  13  *                                                                      *\r
  14  * -------------------------------------------------------------------- *\r
  15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *\r
  16  * For more information visit: http://www.mxchange.org                  *\r
  17  *                                                                      *\r
  18  * This program is free software; you can redistribute it and/or modify *\r
  19  * it under the terms of the GNU General Public License as published by *\r
  20  * the Free Software Foundation; either version 2 of the License, or    *\r
  21  * (at your option) any later version.                                  *\r
  22  *                                                                      *\r
  23  * This program is distributed in the hope that it will be useful,      *\r
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *\r
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *\r
  26  * GNU General Public License for more details.                         *\r
  27  *                                                                      *\r
  28  * You should have received a copy of the GNU General Public License    *\r
  29  * along with this program; if not, write to the Free Software          *\r
  30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *\r
  31  * MA  02110-1301  USA                                                  *\r
  32  ************************************************************************/\r
  33 \r
  34 // Some security stuff...\r
  35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {\r
  36         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
  37         require($INC);\r
  38 }\r
  39 //\r
  40 // The advanced overview shows detailed informations to your exchange script:\r
  41 //  - Unconfirmed / locked accounts\r
  42 //  - Mails waiting to be approved\r
  43 //  - Open tasks\r
  44 //  - Your own tasks\r
  45 //  - ...\r
  46 //\r
  47 function OUTPUT_ADVANCED_OVERVIEW (&$result_main)\r
  48 {\r
  49         global $_COOKIE, $CONFIG;\r
  50 \r
  51         // Init variables/arrays\r
  52         $EXTRAS = ""; $OUT = ""; $SQLs = array(); $WHATs = array(); $DESCRs = array(); $TITLEs = array();\r
  53 \r
  54         // Chheck for new extensions and updates\r
  55         $JOBS_DONE = OUTPUT_STANDARD_OVERVIEW($result_main);\r
  56 \r
  57         if (!$JOBS_DONE) {\r
  58                 // New extensions or updates found\r
  59                 $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE assigned_admin='%s' AND status='NEW' AND task_type='EXTENSION_UPDATE'",\r
  60                  array(GET_ADMIN_ID($_COOKIE['admin_login'])), __FILE__, __LINE__);\r
  61 \r
  62                 $value = SQL_NUMROWS($result);\r
  63                 SQL_FREERESULT($result);\r
  64 \r
  65                 if ($value > 0) {\r
  66                         define ('__TASK_UPDATE_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=updates\">".$value."</A>");\r
  67                 } else {\r
  68                         define ('__TASK_UPDATE_VALUE', "0");\r
  69                 }\r
  70         } else {\r
  71                 define ('__TASK_UPDATE_VALUE', "0");\r
  72         }\r
  73 \r
  74         //\r
  75         // First check for all account status seperately\r
  76         //\r
  77         // Confirmed accounts\r
  78         $result = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED'", __FILE__, __LINE__);\r
  79         $value = SQL_NUMROWS($result);\r
  80         SQL_FREERESULT($result);\r
  81 \r
  82         if ($value > 0) {\r
  83                 define('__CONFIRMED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_user&amp;mode=confirmed\">".$value."</A>");\r
  84         } else {\r
  85                 define('__CONFIRMED_VALUE', "0");\r
  86         }\r
  87
  88         // Unconfirmed accounts\r
  89         $result = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED'", __FILE__, __LINE__);\r
  90         $value = SQL_NUMROWS($result);\r
  91         SQL_FREERESULT($result);\r
  92 \r
  93         if ($value > 0) {\r
  94                 define('__UNCONFIRMED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=chk_regs\">".$value."</A>");\r
  95         } else {\r
  96                 define('__UNCONFIRMED_VALUE', "0");\r
  97         }\r
  98
  99         // And locked accounts\r
 100         $result = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='LOCKED'", __FILE__, __LINE__);\r
 101         $value = SQL_NUMROWS($result);\r
 102         SQL_FREERESULT($result);\r
 103 \r
 104         if ($value > 0) {\r
 105                 define('__LOCKED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_user&amp;mode=locked\">".$value."</A>");\r
 106         } else {\r
 107                 define('__LOCKED_VALUE', "0");\r
 108         }\r
 109
 110         //\r
 111         // Unassigned tasks\r
 112         //\r
 113         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE assigned_admin='0' AND status != 'DELETED'", __FILE__, __LINE__);\r
 114         $value = SQL_NUMROWS($result);\r
 115         SQL_FREERESULT($result);\r
 116 \r
 117         if ($value > 0) {\r
 118                 define('__TASK_NEW_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=unassigned\">".$value."</A>");\r
 119         } else {\r
 120                 define('__TASK_NEW_VALUE', "0");\r
 121         }
 122 \r
 123         //\r
 124         // Closed tasks\r
 125         //\r
 126         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE status = 'CLOSED'", __FILE__, __LINE__);\r
 127         $value = SQL_NUMROWS($result);\r
 128         SQL_FREERESULT($result);\r
 129 \r
 130         if ($value > 0) {\r
 131                 define('__TASK_CLOSED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=closed\">".$value."</A>");\r
 132         } else {\r
 133                 define('__TASK_CLOSED_VALUE', "0");\r
 134         }
 135 \r
 136         //\r
 137         // Deleted tasks\r
 138         //\r
 139         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE status = 'DELETED'", __FILE__, __LINE__);\r
 140         $value = SQL_NUMROWS($result);\r
 141         SQL_FREERESULT($result);\r
 142 \r
 143         if ($value > 0) {\r
 144                 define('__TASK_DELETED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=deleted\">".$value."</A>");\r
 145         } else {\r
 146                 define('__TASK_DELETED_VALUE', "0");\r
 147         }
 148 \r
 149         //\r
 150         // Solved tasks\r
 151         //\r
 152         $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE status = 'SOLVED' AND assigned_admin='%s'",\r
 153          array(GET_ADMIN_ID($_COOKIE['admin_login'])), __FILE__, __LINE__);\r
 154         $value = SQL_NUMROWS($result);\r
 155         SQL_FREERESULT($result);\r
 156 \r
 157         if ($value > 0) {\r
 158                 define('__TASK_SOLVED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task&amp;type=solved\">".$value."</A>");\r
 159         } else {\r
 160                 define('__TASK_SOLVED_VALUE', "0");\r
 161         }
 162 \r
 163         //\r
 164         // Your tasks\r
 165         //\r
 166         $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_task_system WHERE assigned_admin='%s' AND status = 'NEW' AND task_type != 'EXTENSION_UPDATE'",\r
 167          array(GET_ADMIN_ID($_COOKIE['admin_login'])), __FILE__, __LINE__);\r
 168         $value = SQL_NUMROWS($result);\r
 169         SQL_FREERESULT($result);\r
 170 \r
 171         if ($value > 0) {\r
 172                 define('__TASK_YOUR_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=list_task\">".$value."</A>");\r
 173         } else {\r
 174                 define('__TASK_YOUR_VALUE', "0");\r
 175         }
 176 \r
 177         //\r
 178         // Mails waiting to be approved\r
 179         //\r
 180         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_pool WHERE data_type='ADMIN'", __FILE__, __LINE__);\r
 181         $value = SQL_NUMROWS($result);\r
 182         SQL_FREERESULT($result);\r
 183 \r
 184         if ($value > 0) {\r
 185                 define('__MAIL_ADMIN_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=unlock_emails\">".$value."</A>");\r
 186         } else {\r
 187                 define('__MAIL_ADMIN_VALUE', "0");\r
 188         }
 189 \r
 190         //\r
 191         // Unfinished mail orders\r
 192         //\r
 193         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_pool WHERE data_type='TEMP'", __FILE__, __LINE__);\r
 194         $value = SQL_NUMROWS($result);\r
 195         SQL_FREERESULT($result);\r
 196 \r
 197         if ($value > 0) {\r
 198                 define('__MAIL_TEMP_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
 199         } else {\r
 200                 define('__MAIL_TEMP_VALUE', "0");\r
 201         }
 202 \r
 203         //\r
 204         // Sent mail orders\r
 205         //\r
 206         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_pool WHERE data_type='SEND'", __FILE__, __LINE__);\r
 207         $value = SQL_NUMROWS($result);\r
 208         SQL_FREERESULT($result);\r
 209 \r
 210         if ($value > 0) {\r
 211                 define('__MAIL_SEND_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_archiv\">".$value."</A>");\r
 212         } else {\r
 213                 define('__MAIL_SEND_VALUE', "0");\r
 214         }
 215 \r
 216         //\r
 217         // Autopurged mails\r
 218         //\r
 219         if (EXT_IS_ACTIVE("autopurge")) {\r
 220                 $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_pool WHERE data_type='DELETED'", __FILE__, __LINE__);\r
 221                 $value = SQL_NUMROWS($result);\r
 222                 SQL_FREERESULT($result);\r
 223 \r
 224                 if ($value > 0) {\r
 225                         define('__MAIL_DELETED_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
 226                 } else {\r
 227                         define('__MAIL_DELETED_VALUE', "0");\r
 228                 }
 229 \r
 230                 //\r
 231                 // Autopurged bonus mails\r
 232                 //\r
 233                 if (GET_EXT_VERSION("bonus") >= "0.1.8") {\r
 234                         $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE data_type='DELETED'", __FILE__, __LINE__);\r
 235                         $value = SQL_NUMROWS($result);\r
 236                         SQL_FREERESULT($result);\r
 237 \r
 238                         if ($value > 0) {\r
 239                                 define('__MAIL_BONUS_AP_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
 240                         } else {\r
 241                                 define('__MAIL_BONUS_AP_VALUE', "0");\r
 242                         }\r
 243                 } elseif (EXT_IS_ACTIVE("bonus")) {\r
 244                         define('__MAIL_BONUS_AP_VALUE', ADMIN_EXT_BONUS_OUTDATED_1."0.1.8".ADMIN_EXT_BONUS_OUTDATED_2);\r
 245                 } else {\r
 246                         define('__MAIL_BONUS_AP_VALUE', "<FONT class=\"admin_note\">".ADMIN_EXT_BONUS_404."</FONT>");\r
 247                 }\r
 248         } else {\r
 249                 define('__MAIL_BONUS_AP_VALUE', "<FONT class=\"admin_note\">".ADMIN_EXT_AUTOPURGE_404."</FONT>");\r
 250                 define('__MAIL_DELETED_VALUE', "<FONT class=\"admin_note\">".ADMIN_EXT_AUTOPURGE_404."</FONT>");\r
 251         }
 252 \r
 253         //\r
 254         // Sent bonus mails\r
 255         //\r
 256         if (GET_EXT_VERSION("bonus") >= "0.1.8") {\r
 257                 $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_bonus WHERE data_type='SEND'", __FILE__, __LINE__);\r
 258                 $value = SQL_NUMROWS($result);\r
 259                 SQL_FREERESULT($result);\r
 260 \r
 261                 if ($value > 0) {\r
 262                         define('__MAIL_BONUS_SEND_VALUE', "<A href=\"".URL."/modules.php?module=admin&amp;what=email_details\">".$value."</A>");\r
 263                 } else {\r
 264                         define('__MAIL_BONUS_SEND_VALUE', "0");\r
 265                 }\r
 266         } elseif (EXT_IS_ACTIVE("bonus")) {\r
 267                 define('__MAIL_BONUS_SEND_VALUE', ADMIN_EXT_BONUS_OUTDATED_1."0.1.8".ADMIN_EXT_BONUS_OUTDATED_2);\r
 268         } else {\r
 269                 define('__MAIL_BONUS_SEND_VALUE', ADMIN_EXT_BONUS_404);\r
 270         }
 271 \r
 272         if (EXT_IS_ACTIVE("autopurge")) {\r
 273                 // Start finding them...\r
 274                 $since = (time() - $CONFIG['ap_in_since']);\r
 275                 $EXCLUDE_LIST = " AND d.userid != c.def_refid";\r
 276 \r
 277                 // Check for more extensions\r
 278                 if (EXT_IS_ACTIVE("beg"))     $EXCLUDE_LIST .= " AND d.userid != c.beg_uid";\r
 279                 if (EXT_IS_ACTIVE("bonus"))   $EXCLUDE_LIST .= " AND d.userid != c.bonus_uid";\r
 280                 if (EXT_IS_ACTIVE("doubler")) $EXCLUDE_LIST .= " AND d.userid != c.doubler_uid";\r
 281 \r
 282                 // Check for new holiday system\r
 283                 if (GET_EXT_VERSION("holiday") >= "0.1.3") {\r
 284                         $EXCLUDE_LIST .= " AND d.holiday_active = 'N'";\r
 285                 }\r
 286 \r
 287                 // Check for all accounts\r
 288                 $SQLs[] = "SELECT DISTINCT d.userid, d.email, d.last_online\r
 289 FROM "._MYSQL_PREFIX."_user_data AS d, "._MYSQL_PREFIX."_config AS c\r
 290 WHERE d.status='CONFIRMED' AND d.joined < ".$since." AND d.last_online < ".$since." AND d.ap_notified < ".$since."\r
 291 ".$EXCLUDE_LIST."\r
 292 ORDER BY d.userid";\r
 293                 $WHATs[]  = "list_autopurge";\r
 294                 $DESCRs[] = TASK_ADMIN_INACTIVE_AUTOPURGE;\r
 295                 $TITLEs[] = TASK_ADMIN_INACTIVE_AUTOPURGE_TITLE;\r
 296         }
 297 \r
 298         if (GET_EXT_VERSION("sql_patches") >= "0.3.4") {\r
 299                 // Check for accounts without referral\r
 300                 $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE refid='0' ORDER BY userid";\r
 301                 $DESCRs[] = TAKS_ADMIN_LIST_ACCOUNT_NOREF;\r
 302                 $TITLEs[] = TAKS_ADMIN_LIST_ACCOUNT_NOREF_TITLE;\r
 303                 $WHATs[]  = "list_norefs";\r
 304         }
 305 \r
 306         if (EXT_IS_ACTIVE("payout")) {\r
 307                 // List new payout requests\r
 308                 $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_payouts WHERE status='NEW' ORDER BY userid";\r
 309                 $WHATs[]  = "list_payouts";\r
 310                 $DESCRs[] = TASK_ADMIN_LIST_PAYOUTS_WAITING;\r
 311                 $TITLEs[] = TASK_ADMIN_LIST_PAYOUTS_WAITING_TITLE;\r
 312                 $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_payouts ORDER BY userid";\r
 313                 $WHATs[]  = "list_payouts";\r
 314                 $DESCRs[] = TASK_ADMIN_LIST_PAYOUTS_ALL;\r
 315                 $TITLEs[] = TASK_ADMIN_LIST_PAYOUTS_ALL_TITLE;\r
 316         }
 317 \r
 318         if (EXT_IS_ACTIVE("wernis")) {\r
 319                 // List new wernis requests\r
 320                 $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_wernis ORDER BY userid";\r
 321                 $WHATs[]  = "list_wernis";\r
 322                 $DESCRs[] = TASK_ADMIN_LIST_WERNIS_ALL;\r
 323                 $TITLEs[] = TASK_ADMIN_LIST_WERNIS_ALL_TITLE;\r
 324         }
 325 \r
 326         if (EXT_IS_ACTIVE("holiday")) {\r
 327                 // List holiday requests\r
 328                 $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_holidays ORDER BY userid";\r
 329                 $WHATs[]  = "list_holiday";\r
 330                 $DESCRs[] = TASK_ADMIN_LIST_HOLIDAYS;\r
 331                 $TITLEs[] = TASK_ADMIN_LIST_HOLIDAYS_TITLE;\r
 332         }
 333 \r
 334         if (GET_EXT_VERSION("bonus") >= "0.2.3") {\r
 335                 // Active rallye\r
 336                 if (GET_EXT_VERSION("bonus") >= "0.6.9") {\r
 337                         // Add more bonus points here\r
 338                         $USE = "(0";\r
 339                         if ($CONFIG['bonus_click_yn'] == "Y") $USE .= " + turbo_bonus";\r
 340                         if ($CONFIG['bonus_login_yn'] == "Y") $USE .= " + login_bonus";\r
 341                         if ($CONFIG['bonus_order_yn'] == "Y") $USE .= " + bonus_order";\r
 342                         if ($CONFIG['bonus_stats_yn'] == "Y") $USE .= " + bonus_stats";\r
 343                         if ($CONFIG['bonus_ref_yn']   == "Y") $USE .= " + bonus_ref";\r
 344                         $USE .= ")";\r
 345                 } else {\r
 346                         // Old version ???\r
 347                         $USE = "turbo_bonus";\r
 348                 }\r
 349 \r
 350                 // Autopurge installed?\r
 351                 $LAST = ""; $ONLINE = "";\r
 352                 if ((EXT_IS_ACTIVE("autopurge")) && ($CONFIG['ap_inactive'] == "Y") && ($CONFIG['ap_in_since'] > 0)) {\r
 353                         // Use last online timestamp to keep inactive members away from here\r
 354                         $LAST   = " AND last_online >= ";\r
 355                         $ONLINE = bigintval(time() - $CONFIG['ap_in_since']);\r
 356                 }\r
 357 \r
 358                 $SQLs[]   = "SELECT ".$USE." AS active_bonus FROM "._MYSQL_PREFIX."_user_data\r
 359 WHERE status='CONFIRMED' AND ".$USE.">0".$LAST."".$ONLINE."\r
 360 ORDER BY active_bonus DESC, userid";\r
 361                 $WHATs[]  = "list_bonus";\r
 362                 $DESCRs[] = TASK_ADMIN_LIST_BONUS;\r
 363                 $TITLEs[] = TASK_ADMIN_LIST_BONUS_TITLE;\r
 364         }\r
 365
 366         if (GET_EXT_VERSION("beg") >= "0.1.2") {\r
 367                 // Begging rallye\r
 368 \r
 369                 // Autopurge installed?\r
 370                 $LAST = ""; $ONLINE = "";\r
 371                 if ((EXT_IS_ACTIVE("autopurge")) && ($CONFIG['ap_inactive'] == "Y") && ($CONFIG['ap_in_since'] > 0)) {\r
 372                         // Use last online timestamp to keep inactive members away from here\r
 373                         $LAST   = " AND last_online >= ";\r
 374                         $ONLINE = bigintval(time() - $CONFIG['ap_in_since']);\r
 375                 }\r
 376 \r
 377                 $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_data\r
 378 WHERE status='CONFIRMED' AND beg_points>0".$LAST."".$ONLINE."\r
 379 ORDER BY beg_points DESC, userid";\r
 380                 $WHATs[]  = "list_beg";\r
 381                 $DESCRs[] = TASK_ADMIN_LIST_BEG;\r
 382                 $TITLEs[] = TASK_ADMIN_LIST_BEG_TITLE;\r
 383         }\r
 384
 385         if (EXT_IS_ACTIVE("doubler")) {\r
 386                 // List waiting payouts\r
 387                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_doubler WHERE completed='N' ORDER BY id";\r
 388                 $WHATs[]  = "list_doubler&amp;mode=waiting&amp;select=all";\r
 389                 $DESCRs[] = TASK_ADMIN_LIST_DOUBLER_WAITING;\r
 390                 $TITLEs[] = TASK_ADMIN_LIST_DOUBLER_WAITING_TITLE;\r
 391                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_doubler ORDER BY id";\r
 392                 $WHATs[]  = "list_doubler";\r
 393                 $DESCRs[] = TASK_ADMIN_LIST_DOUBLER_ALL;\r
 394                 $TITLEs[] = TASK_ADMIN_LIST_DOUBLER_ALL_TITLE;\r
 395         }
 396 \r
 397         //\r
 398         // All referral banner\r
 399         //\r
 400         $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_refbanner ORDER BY id";\r
 401         $WHATs[] = "refbanner";\r
 402         $DESCRs[] = TASK_ADMIN_LIST_REFBANNER_ALL;\r
 403         $TITLEs[] = TASK_ADMIN_LIST_REFBANNER_ALL_TITLE;\r
 404
 405         //\r
 406         // All activated referral banner\r
 407         //\r
 408         $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_refbanner WHERE visible='Y' ORDER BY id";\r
 409         $WHATs[] = "refbanner";\r
 410         $DESCRs[] = TASK_ADMIN_LIST_REFBANNER_ACTIVE;\r
 411         $TITLEs[] = TASK_ADMIN_LIST_REFBANNER_ACTIVE_TITLE;\r
 412
 413         //\r
 414         // All extensions\r
 415         //\r
 416         $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_extensions ORDER BY id";\r
 417         $WHATs[] = "extensions";\r
 418         $DESCRs[] = TASK_ADMIN_LIST_EXTENSIONS_ALL;\r
 419         $TITLEs[] = TASK_ADMIN_LIST_EXTENSIONS_ALL_TITLE;\r
 420
 421         //\r
 422         // All activated extensions\r
 423         //\r
 424         $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_extensions WHERE ext_active='Y' ORDER BY id";\r
 425         $WHATs[] = "extensions&amp;active=Y";\r
 426         $DESCRs[] = TASK_ADMIN_LIST_EXTENSIONS_ACTIVE;\r
 427         $TITLEs[] = TASK_ADMIN_LIST_EXTENSIONS_ACTIVE_TITLE;\r
 428 \r
 429         if (EXT_IS_ACTIVE("engine")) {\r
 430                 // List all export accounts\r
 431                 $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_accounts ORDER BY id";\r
 432                 $WHATs[] = "list_engine";\r
 433                 $DESCRs[] = TASK_ADMIN_LIST_ENGINE;\r
 434
 435                 // List all pending accounts\r
 436                 $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_accounts WHERE status='UNCONFIRMED' ORDER BY id";\r
 437                 $WHATs[] = "unlock_engine";\r
 438                 $DESCRs[] = TASK_ADMIN_UNLOCK_ENGINE;\r
 439
 440                 // List all safes\r
 441                 $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_safe ORDER BY id";\r
 442                 $WHATs[] = "list_engine&amp;mode=safe";\r
 443                 $DESCRs[] = TASK_ADMIN_LIST_ENGINE_SAFES;\r
 444
 445                 // List all export URLs\r
 446                 $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_engine_urls ORDER BY id";\r
 447                 $WHATs[] = "engine_urls";\r
 448                 $DESCRs[] = TASK_ADMIN_LIST_ENGINE_URLS;\r
 449         }
 450 \r
 451         if (EXT_IS_ACTIVE("sponsor")) {\r
 452                 // List all sponsors\r
 453                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data ORDER BY id";\r
 454                 $WHATs[]  = "list_sponsor";\r
 455                 $DESCRs[] = TASK_ADMIN_LIST_SPONSOR;\r
 456                 $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_TITLE;\r
 457
 458                 // List confirmed sponsor accounts\r
 459                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='CONFIRMED' ORDER BY id";\r
 460                 $WHATs[]  = "list_sponsor";\r
 461                 $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED;\r
 462                 $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_CONFIRMED_TITLE;\r
 463
 464                 // List unconfirmed sponsor accounts\r
 465                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='UNCONFIRMED' ORDER BY id";\r
 466                 $WHATs[]  = "list_sponsor";\r
 467                 $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED;\r
 468                 $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_UNCONFIRMED_TITLE;\r
 469
 470                 // List locked sponsor accounts\r
 471                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='LOCKED' ORDER BY id";\r
 472                 $WHATs[]  = "list_sponsor";\r
 473                 $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED;\r
 474                 $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_LOCKED_TITLE;\r
 475
 476                 // List waiting sponsor accounts to be approved\r
 477                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_data WHERE status='PENDING' ORDER BY id";\r
 478                 $WHATs[]  = "unlock_sponsor";\r
 479                 $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_PENDING;\r
 480                 $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_PENDING_TITLE;\r
 481
 482                 // Waiting payments\r
 483                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_sponsor_orders WHERE pay_status='PENDING' ORDER BY id";\r
 484                 $WHATs[]  = "list_sponsor_pays";\r
 485                 $DESCRs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS;\r
 486                 $TITLEs[] = TASK_ADMIN_LIST_SPONSOR_ORDERS_TITLE;\r
 487         }
 488 \r
 489         if (EXT_IS_ACTIVE("country")) {\r
 490                 // List country codes\r
 491                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_countries ORDER BY id";\r
 492                 $WHATs[]  = "list_country";\r
 493                 $DESCRs[] = TASK_ADMIN_LIST_COUNTRY;\r
 494                 $TITLEs[] = TASK_ADMIN_LIST_COUNTRY_TITLE;\r
 495         }
 496 \r
 497         if (EXT_IS_ACTIVE("theme")) {\r
 498                 // List all themes\r
 499                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_themes ORDER BY id";\r
 500                 $WHATs[]  = "theme_edit";\r
 501                 $DESCRs[] = TASK_ADMIN_LIST_THEME_ALL;\r
 502                 $TITLEs[] = TASK_ADMIN_LIST_THEME_ALL_TITLE;\r
 503
 504                 // List active themes\r
 505                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_themes WHERE theme_active='Y' ORDER BY id";\r
 506                 $WHATs[]  = "theme_edit";\r
 507                 $DESCRs[] = TASK_ADMIN_LIST_THEME_ACTIVE;\r
 508                 $TITLEs[] = TASK_ADMIN_LIST_THEME_ACTIVE_TITLE;\r
 509         }
 510 \r
 511         if (EXT_IS_ACTIVE("admins")) {\r
 512                 // List all administrator logins\r
 513                 $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_admins ORDER BY id";\r
 514                 $WHATs[]  = "admins_edit";\r
 515                 $DESCRs[] = TASK_ADMIN_LIST_ADMINS_ALL;\r
 516                 $TITLEs[] = TASK_ADMIN_LIST_ADMINS_ALL_TITLE;\r
 517         }\r
 518 \r
 519         // Generate extra overview rows\r
 520         $EXTRAS .= TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs);\r
 521 \r
 522         // If empty just keep a forced-space left for CSS issues\r
 523         if (empty($EXTRAS)) $EXTRAS = "&nbsp;";\r
 524 \r
 525         // Add compiled string to constant for final template\r
 526         define('__OVERVIEW_EXTRA_TABLE', $EXTRAS);\r
 527 \r
 528         // Simply load the template... :-)\r
 529         LOAD_TEMPLATE("admin_overview_task");\r
 530 }
 531 \r
 532 //\r
 533 function TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs){
 534         // Init\r
 535         $OUT = ""; $SW = 2; $MAX = sizeof($SQLs) - 1;\r
 536         foreach ($SQLs as $key=>$sql) {\r
 537                 // Run SQL command, get line numbers and free memory\r
 538                 $result = SQL_QUERY($sql, __FILE__, __LINE__);\r
 539                 $value = SQL_NUMROWS($result);\r
 540                 SQL_FREERESULT($result);\r
 541 \r
 542                 $content = array(\r
 543                         'row_descr' => $DESCRs[$key],\r
 544                         'row_sw'    => $SW,\r
 545                         'bottom'    => "",\r
 546                 );
 547 \r
 548                 if ($key < $MAX) $content['bottom'] = "bottom2";\r
 549                 if (($value > 0) && (!empty($WHATs[$key]))) {\r
 550                         if (empty($TITLEs[$key])) $TITLEs[$key] = TASK_ADMIN_UNKNOWN_LIST_TITLE;\r
 551                         $content['row_link'] = "<A href=\"".URL."/modules.php?module=admin&amp;what=".$WHATs[$key]."\" title=\"".$TITLEs[$key]."\">".$value."</A>";\r
 552                 } else {\r
 553                         $content['row_link'] = "0";\r
 554                 }\r
 555 \r
 556                 // Switch color\r
 557                 $SW = 3 - $SW;\r
 558 \r
 559                 // And insert the final string into extras template\r
 560                 $OUT .= LOAD_TEMPLATE("admin_overview_task_rows", true, $content);\r
 561         }\r
 562 \r
 563         // Return output\r
 564         return LOAD_TEMPLATE("admin_overview_task_extras", true, $OUT);\r
 565 }\r
 566 //\r
 567 ?>\r