- $result = SQL_QUERY_ESC("SELECT u.id, u.userid, u.url, u.views_total, u.views_max, u.views_allowed, u.status, UNIX_TIMESTAMP(u.registered) AS registered, UNIX_TIMESTAMP(u.last_locked) AS last_locked, u.lock_reason AS lock_reason
-FROM `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
-WHERE u.userid=%s AND u.status != 'DELETED'
-ORDER BY u.id ASC",
- array(getUserId()), __FUNCTION__, __LINE__);
+ $result = SQL_QUERY_ESC("SELECT
+ u.id, u.userid, u.url, u.status,
+ u.views_total, u.views_max, u.views_allowed,
+ UNIX_TIMESTAMP(u.registered) AS url_registered,
+ UNIX_TIMESTAMP(u.last_locked) AS url_last_locked,
+ u.lock_reason AS lock_reason
+FROM
+ `{?_MYSQL_PREFIX?}_surfbar_urls` AS u
+WHERE
+ u.userid=%s AND
+ u.status != 'DELETED'
+ORDER BY
+ u.id ASC",
+ array(getMemberId()), __FUNCTION__, __LINE__);