// 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) {
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);