More improved SQL queries

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

diff --git a/inc/modules/admin/what-list_surfbar_urls.php b/inc/modules/admin/what-list_surfbar_urls.php
index 9cf67c054f289c4d9670d3f6e1f6ad97be159d03..aabef21732e367c6f4b07136340aa6ef129ef9e0 100644 (file)
--- a/inc/modules/admin/what-list_surfbar_urls.php
+++ b/inc/modules/admin/what-list_surfbar_urls.php
@@ -32,26 +32,35 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((!defined('__SECURITY')) || (!is_admin())) {
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
        $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
        require($INC);
 } // END - if
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
 
 // By default show the list...
 $show = true;
 
+// Check for 'id' element
+if ((count($_POST) > 0) && ((!isset($_POST['id'])) || (!is_array($_POST['id'])) || (count($_POST['id']) == 0))) {
+       // Not found so output message
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_SURFBAR_NO_SELECTIONS'));
+
+       // Abort here
+       return;
+}
+
 // Edit or delete button hit?
 if (isset($_POST['edit'])) {
        // Show entries for editing
        ADMIN_EDIT_ENTRIES_CONFIRM(
                $_POST['id'],
                "surfbar_urls",
-               array("id", "userid", "url", "reward", "costs"),
-               array("bigintval", "ADD_MEMBER_SELECTION_BOX", "", "TRANSLATE_COMMA", "TRANSLATE_COMMA"),
-               array("", array(false, true, true), "", "", "")
+               array("id", "userid", "url"),
+               array("bigintval", "ADD_MEMBER_SELECTION_BOX", ""),
+               array("", array(false, true, true), "")
        );
        $show = false;
 } elseif (isset($_POST['do_edit'])) {
@@ -59,9 +68,9 @@ if (isset($_POST['edit'])) {
        ADMIN_EDIT_ENTRIES_CONFIRM(
                $_POST['id'],
                "surfbar_urls",
-               array("", ""),
-               array('reward' => "REVERT_COMMA", 'costs' => "REVERT_COMMA"),
-               array('reward' => "", 'costs' => ""),
+               array(),
+               array(),
+               array(),
                true
        );
 } elseif (isset($_POST['delete'])) {
@@ -70,8 +79,8 @@ if (isset($_POST['edit'])) {
                $_POST['id'],
                "surfbar_urls",
                array("id", "userid", "url", "registered"),
-               array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", "MAKE_DATETIME"),
-               array("", "", "", "2")
+               array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", ""),
+               array("", "", "", "")
        );
        $show = false;
 } elseif (isset($_POST['do_delete'])) {
@@ -83,8 +92,8 @@ if (isset($_POST['edit'])) {
                $_POST['id'],
                "surfbar_urls",
                array("id", "userid", "url", "registered", "status"),
-               array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", "MAKE_DATETIME", "SURFBAR_TRANSLATE_STATUS"),
-               array("", "", "", "2", "")
+               array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", "", "SURFBAR_TRANSLATE_STATUS"),
+               array("", "", "", "", "")
        );
        $show = false;
 } elseif (isset($_POST['do_lock'])) {
@@ -95,28 +104,28 @@ if (isset($_POST['edit'])) {
                array(),
                array(),
                array(),
-               array("status" => array("CONFIRMED" => "LOCKED", "LOCKED" => "CONFIRMED")),
+               array("status" => array("ACTIVE" => "LOCKED", "LOCKED" => "ACTIVE")),
                true
        );
 } elseif (isset($_POST['undelete'])) {
        // Undelete selected URLs. This does only work for deleted URLs... ;-)
-       ADMIN_LOCK_ENTRIES_CONFIRM(
+       ADMIN_UNDELETE_ENTRIES_CONFIRM(
                $_POST['id'],
                "surfbar_urls",
                array("id", "userid", "url", "registered", "status"),
-               array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", "MAKE_DATETIME", "SURFBAR_TRANSLATE_STATUS"),
-               array("", "", "", "2", "")
+               array("bigintval", "ADMIN_USER_PROFILE_LINK", "FRAMETESTER", "", "SURFBAR_TRANSLATE_STATUS"),
+               array("", "", "", "", "")
        );
        $show = false;
 } elseif (isset($_POST['do_undelete'])) {
        // Undelete selected URLs. This does only work for deleted URLs... ;-)
-       ADMIN_LOCK_ENTRIES_CONFIRM(
+       ADMIN_UNDELETE_ENTRIES_CONFIRM(
                $_POST['id'],
                "surfbar_urls",
                array(),
                array(),
                array(),
-               array("status" => array("DELETED" => "CONFIRMED"),
+               array("status" => array("DELETED" => "ACTIVE")),
                true
        );
 }
@@ -125,9 +134,9 @@ if (isset($_POST['edit'])) {
 if (!$show) return false;
 
 // List all URLs
-$result = SQL_QUERY("SELECT id, userid, url, reward, costs, views_total, status, UNIX_TIMESTAMP(registered) AS registered, UNIX_TIMESTAMP(last_locked) AS last_locked, lock_reason
-FROM "._MYSQL_PREFIX."_surfbar_urls
-ORDER BY id ASC", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT id, userid, url, views_total, status, UNIX_TIMESTAMP(registered) AS registered, UNIX_TIMESTAMP(last_locked) AS last_locked, lock_reason
+FROM `{!_MYSQL_PREFIX!}_surfbar_urls`
+ORDER BY `id` ASC", __FILE__, __LINE__);
 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {
@@ -138,8 +147,6 @@ if (SQL_NUMROWS($result) > 0) {
                $content['sw']          = $SW;
                $content['userid']      = ADMIN_USER_PROFILE_LINK($content['userid']);
                $content['url']         = FRAMETESTER($content['url']);
-               $content['reward']      = TRANSLATE_COMMA($content['reward']);
-               $content['costs']       = TRANSLATE_COMMA($content['costs']);
                $content['views_total'] = TRANSLATE_COMMA($content['views_total']);
                $content['status']      = SURFBAR_TRANSLATE_STATUS($content['status']);
                $content['registered']  = MAKE_DATETIME($content['registered'], 2);
@@ -157,7 +164,7 @@ if (SQL_NUMROWS($result) > 0) {
        LOAD_TEMPLATE("admin_list_surfbar_urls", false, $OUT);
 } else {
        // No URLs in surfbar
-       LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_SURFBAR_NO_URLS_FOUND);
+       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_SURFBAR_NO_URLS_FOUND'));
 }
 
 // Free result