} elseif (!isset($URLs[$formData['id']])) {
// id not found in cache
return false;
- } elseif (!SURFBAR_VALIDATE_MEMBER_ACTION_STATUS($formData['action'], $URLs[$formData['id']]['status'])) {
+ } elseif (!SURFBAR_VALIDATE_MEMBER_ACTION_STATUS($formData['action'], $URLs[$formData['id']]['url_status'])) {
// Action not allowed for current URL status
return false;
}
);
// Simply change the status here
- return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['status'], $urlData['new_status'], $data);
+ return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['url_status'], $urlData['new_status'], $data);
}
// Book an URL now (from migration)
);
// Simply change the status here
- return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['status'], $urlData['new_status'], $data);
+ return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['url_status'], $urlData['new_status'], $data);
}
// Show edit form or do the changes
// Pause active banner
function SURFBAR_MEMBER_PAUSE_ACTION ($urlData) {
- return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['status'], $urlData['new_status'], array($urlData['id'] => $urlData));
+ return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData));
}
// Unpause stopped banner
$urlData['edit']['limit'] = $urlData['views_max'];
// Return status change
- return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['status'], $urlData['new_status'], array($urlData['id'] => $urlData));
+ return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData));
}
// Resubmit locked URL
function SURFBAR_MEMBER_RESUBMIT_ACTION ($urlData) {
- return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['status'], $urlData['new_status'], array($urlData['id'] => $urlData));
+ return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData));
}
// 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'])) {
// Execute the function
if (call_user_func_array($functionName, array($urlData)) == true) {
// Update status as well
- $executed = SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['status'], $urlData['new_status'], array($urlData['id'] => $urlData));
+ $executed = SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData));
} // END - if
} else {
// Not found!
//if (($urlData['views_allowed'] != $urlData['edit']['limit']) || ($url1 != $url2)) {
// Run the query
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET url='%s', views_allowed=%s, views_max=%s WHERE `id`=%s AND `status`='%s' LIMIT 1",
- array($urlData['url'], $urlData['edit']['limit'], $urlData['edit']['limit'], $urlData['id'], $urlData['status']), __FUNCTION__, __LINE__);
+ array($urlData['url'], $urlData['edit']['limit'], $urlData['edit']['limit'], $urlData['id'], $urlData['url_status']), __FUNCTION__, __LINE__);
// All fine
$status = true;
// Look up the record
$result = SQL_QUERY_ESC("SELECT
`id`, `userid`, `url`,
- `views_total`, `views_max`, `views_allowed`, `status`,
- UNIX_TIMESTAMP(`registered`) AS `registered`, UNIX_TIMESTAMP(`last_locked`) AS `last_locked`, `lock_reason`,
+ `views_total`, `views_max`, `views_allowed`, `status` AS `url_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`
$content = merge_array($extraFields, array(
'url' => $url,
'frametester' => generateFrametesterUrl($url),
- 'userid' => $userid,
- 'status' => $status,
+ 'userid' => $userid,
+ 'url_status' => $status,
));
// Is limit/reload set?
array(
$userid,
$urlData['url'],
- $urlData['status'],
+ $urlData['url_status'],
$urlData['limit'],
$urlData['limit'],
$urlData['reload']
// Is the subject line there?
if ((substr($subject, 0, 1) == '!') && (substr($subject, -1, 1) == '!')) {
// Set default subject if following eval() wents wrong
- $subject = getMessage('ADMIN_SURFBAR_NOTIFY_DEFAULT_SUBJECT');
+ $subject = getMaskedMessage('ADMIN_SURFBAR_NOTIFY_DEFAULT_SUBJECT', strtoupper($messageType));
} // 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['url_status'])) $content['url_status'] = translateSurfbarUrlStatus($content['url_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['url_status'])) $content['url_status'] = translateSurfbarUrlStatus($content['url_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']);
} // END - if
// Is the status like prevStatus is saying?
- if ($data[$urlId]['status'] != $prevStatus) {
+ if ($data[$urlId]['url_status'] != $prevStatus) {
// No, then abort here
return false;
} // END - if
$data[$urlId]['costs'] = translateComma(getConfig('surfbar_static_costs'));
// Do some dirty fixing here:
- if (($data[$urlId]['status'] == 'STOPPED') && ($newStatus == 'pending')) {
+ if (($data[$urlId]['url_status'] == 'STOPPED') && ($newStatus == 'pending')) {
// Fix for template change
$newStatus = 'continued';
} // END - if
// Send admin notification
- SURFBAR_NOTIFY_ADMIN("url_{$data[$urlId]['status']}_{$newStatus}", $data[$urlId]);
+ SURFBAR_NOTIFY_ADMIN('url_' . $data[$urlId]['url_status'] . '_' . $newStatus, $data[$urlId]);
// Send user notification
- SURFBAR_NOTIFY_USER("url_{$data[$urlId]['status']}_{$newStatus}", $data[$urlId]);
+ SURFBAR_NOTIFY_USER('url_' . $data[$urlId]['url_status'] . '_' . $newStatus, $data[$urlId]);
// All done!
return true;
// "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?
$returnArray = array();
// Get all assigned actions
- $result = SQL_QUERY_ESC("SELECT action FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `status`='%s' ORDER BY `id` ASC",
- array($status), __FUNCTION__, __LINE__);
+ $result = SQL_QUERY_ESC("SELECT `action` FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `status`='%s' ORDER BY `id` ASC",
+ array($status), __FUNCTION__, __LINE__);
// Some entries there?
if (SQL_NUMROWS($result) > 0) {
projects / mailer.git / blobdiff