-// 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 = '';
- while ($content = SQL_FETCHARRAY($result)) {
- // "Translate"/add content
- $content['url_registered'] = generateDateTime($content['url_registered'], 2);
-
- // Load row template
- $OUT .= loadTemplate('admin_unlock_surfbar_urls_row', true, $content);
- } // END - while
-
- // Load main template
- loadTemplate('admin_unlock_surfbar_urls', false, $OUT);
-} else {
- // No URLs in surfbar
- loadTemplate('admin_settings_saved', false, '{--ADMIN_SURFBAR_NO_URLS_FOUND--}');
-}
-
-// Free result
-SQL_FREERESULT($result);