} elseif (!is_array($IDs)) {
// No array
return false;
- } elseif (count($IDs) == '0') {
+ } elseif (count($IDs) == 0) {
// Empty array
return false;
}
} elseif (!is_array($IDs)) {
// No array
return false;
- } elseif (count($IDs) == '0') {
+ } elseif (count($IDs) == 0) {
// Empty array
return false;
}
// Display selected "action form"
function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) {
// Translate some data
- $urlData['registered'] = generateDateTime($urlData['registered'], 2);
- $urlData['views_total'] = translateComma($urlData['views_total']);
- $urlData['views_max'] = translateComma($urlData['views_max']);
- $urlData['views_allowed'] = translateComma($urlData['views_allowed']);
- $urlData['last_locked'] = generateDateTime($urlData['last_locked'], 2);
+ $urlData['url_registered'] = generateDateTime($urlData['url_registered'], 2);
+ $urlData['views_total'] = translateComma($urlData['views_total']);
+ $urlData['views_max'] = translateComma($urlData['views_max']);
+ $urlData['views_allowed'] = translateComma($urlData['views_allowed']);
+ $urlData['url_last_locked'] = generateDateTime($urlData['url_last_locked'], 2);
// Is the lock reason empty?
if (empty($urlData['lock_reason'])) {
} // END - if
// Look up the record
- $result = SQL_QUERY_ESC("SELECT id, userid, url, views_total, views_max, views_allowed, status, registered, last_locked, lock_reason, views_max, views_allowed, fixed_reload
-FROM `{?_MYSQL_PREFIX?}_surfbar_urls`
-WHERE %s='%s'".$add."
-ORDER BY %s %s
+ $result = SQL_QUERY_ESC("SELECT
+ `id`, `userid`, `url`,
+ `views_total`, `views_max`, `views_allowed`, `status`,
+ UNIX_TIMESTAMP(`registered`) AS `url_registered`, UNIX_TIMESTAMP(`last_locked`) AS `url_last_locked`, `lock_reason`,
+ `views_max`, `views_allowed`, `fixed_reload`
+FROM
+ `{?_MYSQL_PREFIX?}_surfbar_urls`
+WHERE
+ `%s`='%s'".$add."
+ORDER BY
+ `%s` %s
%s",
- array($column, $searchTerm, $order, $sort, $limit), __FUNCTION__, __LINE__);
+ array(
+ $column,
+ $searchTerm,
+ $order,
+ $sort,
+ $limit
+ ), __FUNCTION__, __LINE__);
// Is there at least one record?
if (SQL_NUMROWS($result) > 0) {
// Just run the insert query for now
SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_urls` (userid,url,status,views_max,views_allowed,fixed_reload) VALUES (%s,'%s','%s',%s,%s,%s)",
- array(
- $userid,
- $urlData['url'],
- $urlData['status'],
- $urlData['limit'],
- $urlData['limit'],
- $urlData['reload']
- ), __FUNCTION__, __LINE__
+ array(
+ $userid,
+ $urlData['url'],
+ $urlData['status'],
+ $urlData['limit'],
+ $urlData['limit'],
+ $urlData['reload']
+ ), __FUNCTION__, __LINE__
);
// Return insert id
} // END - if
// Translate some data if present
- if (isset($content['status'])) $content['status'] = translateSurfbarUrlStatus($content['status']);
- if (isset($content['registered'])) $content['registered'] = generateDateTime($content['registered'], 2);
- if (isset($content['last_locked'])) $content['last_locked'] = generateDateTime($content['last_locked'], 2);
- if (isset($content['views_total'])) $content['views_total'] = translateComma($content['views_total']);
- if (isset($content['views_allowed'])) $content['views_allowed'] = translateComma($content['views_allowed']);
- if (isset($content['views_max'])) $content['views_max'] = translateComma($content['views_max']);
+ if (isset($content['status'])) $content['status'] = translateSurfbarUrlStatus($content['status']);
+ if (isset($content['url_registered'])) $content['url_registered'] = generateDateTime($content['url_registered'], 2);
+ if (isset($content['url_last_locked'])) $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
+ if (isset($content['views_total'])) $content['views_total'] = translateComma($content['views_total']);
+ if (isset($content['views_allowed'])) $content['views_allowed'] = translateComma($content['views_allowed']);
+ if (isset($content['views_max'])) $content['views_max'] = translateComma($content['views_max']);
// Send the notification out
return sendAdminNotification($subject, $templateName, $content, $content['userid']);
} // END - if
// Translate some data if present
- if (isset($content['status'])) $content['status'] = translateSurfbarUrlStatus($content['status']);
- if (isset($content['registered'])) $content['registered'] = generateDateTime($content['registered'], 2);
- if (isset($content['last_locked'])) $content['last_locked'] = generateDateTime($content['last_locked'], 2);
- if (isset($content['views_total'])) $content['views_total'] = translateComma($content['views_total']);
- if (isset($content['views_allowed'])) $content['views_allowed'] = translateComma($content['views_allowed']);
- if (isset($content['views_max'])) $content['views_max'] = translateComma($content['views_max']);
+ if (isset($content['status'])) $content['status'] = translateSurfbarUrlStatus($content['status']);
+ if (isset($content['url_registered'])) $content['url_registered'] = generateDateTime($content['url_registered'], 2);
+ if (isset($content['url_last_locked'])) $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
+ if (isset($content['views_total'])) $content['views_total'] = translateComma($content['views_total']);
+ if (isset($content['views_allowed'])) $content['views_allowed'] = translateComma($content['views_allowed']);
+ if (isset($content['views_max'])) $content['views_max'] = translateComma($content['views_max']);
// Load template
$mailText = loadEmailTemplate($templateName, $content, $content['userid']);
$userids = SURFBAR_DETERMINE_DEPLETED_USERIDS();
// If we dont get any user ids back, there are no URLs
- if (count($userids['userid']) == '0') {
+ if (count($userids['userid']) == 0) {
// No user ids found, no URLs!
return 0;
} // END - if
$newStatus = strtolower($newStatus);
// Get URL data for status comparison if missing
- if ((!is_array($data)) || (count($data) == '0')) {
+ if ((!is_array($data)) || (count($data) == 0)) {
// Fetch missing URL data
$data = SURFBAR_GET_URL_DATA($urlId);
} // END - if
// "Getter" for maximum random number
function SURFBAR_GET_MAX_RANDOM ($userids, $add) {
// Count max availabe entries
- $result = SQL_QUERY("SELECT sbu.id AS cnt
-FROM `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
-LEFT JOIN `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
-ON sbu.id=sbs.url_id
-LEFT JOIN `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
-ON sbu.id=l.url_id
-WHERE sbu.userid NOT IN (".implode(',', $userids).") AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0)) AND sbu.`status`='ACTIVE'".$add."
-GROUP BY sbu.id", __FUNCTION__, __LINE__);
+ $result = SQL_QUERY("SELECT
+ sbu.id AS cnt
+FROM
+ `{?_MYSQL_PREFIX?}_surfbar_urls` AS sbu
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_surfbar_salts` AS sbs
+ON
+ sbu.id=sbs.url_id
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_surfbar_locks` AS l
+ON
+ sbu.id=l.url_id
+WHERE
+ sbu.userid NOT IN (".implode(',', $userids).") AND
+ (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0)) AND
+ sbu.`status`='ACTIVE'
+ ".$add."
+GROUP BY
+ sbu.id ASC", __FUNCTION__, __LINE__);
// Log last query
//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS().'', false);
$URLs = array();
// Begin the query
- $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",
+ $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__);
// Are there entries?