-// List all URLs
-$result = SQL_QUERY("SELECT
- `url_id`,
- `url_userid`,
- `url`,
- UNIX_TIMESTAMP(`url_registered`) AS `url_registered`
-FROM
- `{?_MYSQL_PREFIX?}_surfbar_urls`
-WHERE
- `url_status`='PENDING'
-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['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);
-
- // Switch color
- $SW = 3 - $SW;
- } // END - while
-
- // Load main template
- loadTemplate('admin_unlock_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);