X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_surfbar_urls.php;h=9afddf7f6a692df3454abfd5ed497f27076c7f40;hp=e9964c13cca376b7923a7fb451a2c83201c695fe;hb=b6a10f5ccfe2ff6e9e5c43f42e33966ae25ffbaa;hpb=d5f116612a5b83fee707282ff7b108f0c9380c5d

diff --git a/inc/modules/admin/what-list_surfbar_urls.php b/inc/modules/admin/what-list_surfbar_urls.php
index e9964c13cc..9afddf7f6a 100644
--- 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
-	`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
-	`id` ASC", __FILE__, __LINE__);
+	`url_id` ASC", __FILE__, __LINE__);
 
 // 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;
-		$content['userid']          = generateUserProfileLink($content['userid']);
+		$content['url_userid']      = generateUserProfileLink($content['url_userid']);
 		$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);