Fixes for ext-surfbar (the usual asset)

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

diff --git a/inc/modules/admin/what-unlock_surfbar_urls.php b/inc/modules/admin/what-unlock_surfbar_urls.php
index d5ef600a3335dc5c042a87c9dde11e25588bce6c..d41b8acc658ec161659b0a351ff5c8bb465bb22c 100644 (file)
--- a/inc/modules/admin/what-unlock_surfbar_urls.php
+++ b/inc/modules/admin/what-unlock_surfbar_urls.php
@@ -46,18 +46,18 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 addMenuDescription('admin', __FILE__);
 
 // Is the form sent?
-if ((isPostRequestParameterSet('unlock')) && (is_array(postRequestParameter('id'))) && (count(postRequestParameter('id')) > 0)) {
+if ((isPostRequestParameterSet('unlock')) && (is_array(postRequestParameter('url_id'))) && (count(postRequestParameter('url_id')) > 0)) {
        // Unlock selected URLs
-       if (SURFBAR_ADMIN_UNLOCK_URL_IDS(postRequestParameter('id'))) {
+       if (SURFBAR_ADMIN_UNLOCK_URL_IDS(postRequestParameter('url_id'))) {
                // Unlock done! :-)
                loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_UNLOCK_DONE'));
        } else {
                // Unlock failed!
                loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_UNLOCK_FAILED'));
        }
-} elseif ((isPostRequestParameterSet(('reject'))) && (is_array(postRequestParameter('id'))) && (count(postRequestParameter('id')) > 0)) {
+} elseif ((isPostRequestParameterSet(('reject'))) && (is_array(postRequestParameter('url_id'))) && (count(postRequestParameter('url_id')) > 0)) {
        // Reject selected URLs
-       if (SURFBAR_ADMIN_REJECT_URL_IDS(postRequestParameter('id'))) {
+       if (SURFBAR_ADMIN_REJECT_URL_IDS(postRequestParameter('url_id'))) {
                // Unlock done! :-)
                loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_UNLOCK_DONE'));
        } else {
@@ -68,13 +68,16 @@ if ((isPostRequestParameterSet('unlock')) && (is_array(postRequestParameter('id'
 
 // List all URLs
 $result = SQL_QUERY("SELECT
-       `id`, `userid`, `url`, UNIX_TIMESTAMP(`registered`) AS registered
+       `url_id`,
+       `url_userid`,
+       `url`,
+       UNIX_TIMESTAMP(`url_registered`) AS `url_registered`
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 WHERE
-       `status`='PENDING'
+       `url_status`='PENDING'
 ORDER BY
-       `id` ASC", __FILE__, __LINE__);
+       `url_id` ASC", __FILE__, __LINE__);
 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {
@@ -82,10 +85,10 @@ if (SQL_NUMROWS($result) > 0) {
        $OUT = ''; $SW = 2;
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate"/add content
-               $content['sw']          = $SW;
-               $content['userid']      = generateUserProfileLink($content['userid']);
-               $content['framekiller'] = generateFrametesterUrl($content['url']);
-               $content['registered']  = generateDateTime($content['registered'], 2);
+               $content['sw']             = $SW;
+               $content['userid']         = generateUserProfileLink($content['userid']);
+               $content['framekiller']    = generateFrametesterUrl($content['url']);
+               $content['url_registered'] = generateDateTime($content['url_registered'], 2);
 
                // Load row template
                $OUT .= loadTemplate('admin_unlock_surfbar_urls_row', true, $content);