Reset rewritten, SQL fixed, zeros are now numeric

[mailer.git] / inc / libs / task_functions.php

diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php
index 2a51e25b22da981420d513b3eba913f03fef6ce1..94fb9b9c7da581f0b8f6ea31ca61f7b25bc7839c 100644 (file)
--- a/inc/libs/task_functions.php
+++ b/inc/libs/task_functions.php
@@ -298,8 +298,8 @@ ORDER BY d.userid";
        if (GET_EXT_VERSION("sql_patches") >= "0.3.4") {
                // Check for accounts without referral
                $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE refid='0' ORDER BY userid";
-               $DESCRs[] = TAKS_ADMIN_LIST_ACCOUNT_NOREF;
-               $TITLEs[] = TAKS_ADMIN_LIST_ACCOUNT_NOREF_TITLE;
+               $DESCRs[] = TASK_ADMIN_LIST_ACCOUNT_NOREF;
+               $TITLEs[] = TASK_ADMIN_LIST_ACCOUNT_NOREF_TITLE;
                $WHATs[]  = "list_norefs";
        }
 
@@ -323,6 +323,14 @@ ORDER BY d.userid";
                $TITLEs[] = TASK_ADMIN_LIST_WERNIS_ALL_TITLE;
        }
 
+       if (EXT_IS_ACTIVE("primera")) {
+               // List new primera requests
+               $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_primera ORDER BY userid";
+               $WHATs[]  = "list_primera";
+               $DESCRs[] = TASK_ADMIN_LIST_PRIMERA_ALL;
+               $TITLEs[] = TASK_ADMIN_LIST_PRIMERA_ALL_TITLE;
+       }
+
        if (EXT_IS_ACTIVE("holiday")) {
                // List holiday requests
                $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_holidays ORDER BY userid";
@@ -516,6 +524,20 @@ ORDER BY beg_points DESC, userid";
                $TITLEs[] = TASK_ADMIN_LIST_ADMINS_ALL_TITLE;
        }
 
+       if (EXT_IS_ACTIVE("surfbar")) {
+               // List all URLs in surfbar
+               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_surfbar_urls ORDER BY id";
+               $WHATs[]  = "list_surfbar_urls";
+               $DESCRs[] = TASK_ADMIN_LIST_SURFBAR_URLS_ALL;
+               $TITLEs[] = TASK_ADMIN_LIST_SURFBAR_URLS_ALL_TITLE;
+
+               // List all pending URLs in surfbar
+               $SQLs[]   = "SELECT id FROM "._MYSQL_PREFIX."_surfbar_urls WHERE status='PENDING' ORDER BY id";
+               $WHATs[]  = "unlock_surfbar_urls";
+               $DESCRs[] = TASK_ADMIN_LIST_SURFBAR_URLS_PENDING;
+               $TITLEs[] = TASK_ADMIN_LIST_SURFBAR_URLS_PENDING_TITLE;
+       }
+
        // Generate extra overview rows
        $EXTRAS .= TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs);
 
@@ -533,7 +555,7 @@ ORDER BY beg_points DESC, userid";
 function TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs){
        // Init
        $OUT = ""; $SW = 2; $MAX = sizeof($SQLs) - 1;
-       foreach ($SQLs as $key=>$sql) {
+       foreach ($SQLs as $key => $sql) {
                // Run SQL command, get line numbers and free memory
                $result = SQL_QUERY($sql, __FILE__, __LINE__);
                $value = SQL_NUMROWS($result);
@@ -550,7 +572,7 @@ function TASK_CREATE_EXTRA_ROWS($SQLs, $WHATs, $DESCRs, $TITLEs){
                        if (empty($TITLEs[$key])) $TITLEs[$key] = TASK_ADMIN_UNKNOWN_LIST_TITLE;
                        $content['row_link'] = "<A href=\"".URL."/modules.php?module=admin&amp;what=".$WHATs[$key]."\" title=\"".$TITLEs[$key]."\">".$value."</A>";
                } else {
-                       $content['row_link'] = "0";
+                       $content['row_link'] = 0;
                }
 
                // Switch color