-$result = SQL_QUERY("SELECT
- `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
- `url_id` ASC", __FILE__, __LINE__);
-
-// Do we have some URLs left?
-if (SQL_NUMROWS($result) > 0) {
- // List all URLs
- $OUT = ''; $SW = 2;
- while ($content = SQL_FETCHARRAY($result)) {
- // "Translate"/add content
- $content['sw'] = $SW;
- $content['url_registered'] = generateDateTime($content['url_registered'], 2);
- $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
- if (empty($content['url_lock_reason'])) $content['url_lock_reason'] = '---';
-
- // Load row template
- $OUT .= loadTemplate('admin_list_surfbar_urls_row', true, $content);
-
- // Switch color
- $SW = 3 - $SW;
- } // END - while
-
- // Load main template
- loadTemplate('admin_list_surfbar_urls', false, $OUT);
-} else {
- // No URLs in surfbar
- loadTemplate('admin_settings_saved', false, getMessage('ADMIN_SURFBAR_NO_URLS_FOUND'));
-}
-
-// Free result
-SQL_FREERESULT($result);