Complete refacture for previously discovered inconsistency

[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 e9964c13cca376b7923a7fb451a2c83201c695fe..9afddf7f6a692df3454abfd5ed497f27076c7f40 100644 (file)
--- a/inc/modules/admin/what-list_surfbar_urls.php
+++ b/inc/modules/admin/what-list_surfbar_urls.php
@@ -140,14 +140,14 @@ if ($show === false) return false;
 
 // List all URLs
 $result = SQL_QUERY("SELECT
 
 // List all URLs
 $result = SQL_QUERY("SELECT

-       `id`, `userid`, `url`, `views_total`, `status` AS `url_status`,
-       UNIX_TIMESTAMP(`registered`) AS url_registered,
-       UNIX_TIMESTAMP(`last_locked`) AS url_last_locked,
-       `lock_reason`
+       `url_id`, `url_userid`, `url`, `url_views_total`, `url_status`,
+       UNIX_TIMESTAMP(`url_registered`) AS `url_registered`,
+       UNIX_TIMESTAMP(`url_last_locked`) AS `url_last_locked`,
+       `url_lock_reason`

 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 ORDER BY
 FROM
        `{?_MYSQL_PREFIX?}_surfbar_urls`
 ORDER BY

-       `id` ASC", __FILE__, __LINE__);
+       `url_id` ASC", __FILE__, __LINE__);

 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {
 
 // Do we have some URLs left?
 if (SQL_NUMROWS($result) > 0) {


@@ -156,9 +156,9 @@ if (SQL_NUMROWS($result) > 0) {
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate"/add content
                $content['sw']              = $SW;
        while ($content = SQL_FETCHARRAY($result)) {
                // "Translate"/add content
                $content['sw']              = $SW;

-               $content['userid']          = generateUserProfileLink($content['userid']);
+               $content['url_userid']      = generateUserProfileLink($content['url_userid']);

                $content['url']             = generateFrametesterUrl($content['url']);
                $content['url']             = generateFrametesterUrl($content['url']);

-               $content['views_total']     = translateComma($content['views_total']);
+               $content['views_total']     = translateComma($content['url_views_total']);

                $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
                $content['url_registered']  = generateDateTime($content['url_registered'], 2);
                $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
                $content['url_status']      = translateSurfbarUrlStatus($content['url_status']);
                $content['url_registered']  = generateDateTime($content['url_registered'], 2);
                $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);