}
// Do the member form request
-function SURFBAR_MEMBER_DO_FORM ($formData, $URLs) {
+function SURFBAR_MEMBER_DO_FORM ($formData, $urlArray) {
// By default no action is performed
$performed = false;
} elseif ((!isset($formData['id'])) || (!isset($formData['action']))) {
// Important form elements are missing!
return false;
- } elseif (!isset($URLs[$formData['id']])) {
+ } elseif (!isset($urlArray[$formData['id']])) {
// id not found in cache
return false;
- } elseif (!SURFBAR_VALIDATE_MEMBER_ACTION_STATUS($formData['action'], $URLs[$formData['id']]['url_status'])) {
+ } elseif (!SURFBAR_VALIDATE_MEMBER_ACTION_STATUS($formData['action'], $urlArray[$formData['id']]['url_status'])) {
// Action not allowed for current URL status
return false;
}
// Is the function there?
if (function_exists($functionName)) {
// Add new status
- $URLs[$formData['id']]['new_status'] = SURFBAR_GET_NEW_STATUS('new_status');
+ $urlArray[$formData['id']]['new_status'] = SURFBAR_GET_NEW_STATUS('new_status');
// Extract URL data for call-back
- $urlData = array(merge_array($URLs[$formData['id']], array($action => $formData)));
+ $urlData = array(merge_array($urlArray[$formData['id']], array($action => $formData)));
// Action found so execute it
$performed = call_user_func_array($functionName, $urlData);
function SURFBAR_MEMBER_BOOKNOW_ACTION ($urlData) {
// Create the data array for next function call
$data = array(
- $urlData['id'] => $urlData
+ $urlData['id'] => $urlData
);
// Simply change the status here
// Translate some data if present
$content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content);
- // Is the lock reason empty?
- if (empty($urlData['lock_reason'])) {
- // Fix it to three dashes
- $urlData['lock_reason'] = '---';
- } // END - if
-
// Include fields only for action 'edit'
if ($action == 'edit') {
// Default is not limited
} // END - if
} else {
// Not found!
- addFatalMessage(__FUNCTION__, __LINE__, getMessage('MEMBER_SURFBAR_EXECUTE_ACTION_404'), $functionName);
+ addFatalMessage(__FUNCTION__, __LINE__, '{--MEMBER_SURFBAR_EXECUTE_ACTION_404--}', $functionName);
}
// Return status
$userids = SURFBAR_DETERMINE_DEPLETED_USERIDS(getConfig('surfbar_warn_low_points'));
// "Walk" through all URLs
- foreach ($userids['userid'] as $userid => $dummy) {
+ foreach ($userids['url_userid'] as $userid => $dummy) {
// Is the last notification far enougth away to notify again?
if ((time() - $userids['notified'][$userid]) >= getConfig('surfbar_low_interval')) {
// Prepare content
$content = array(
- 'userid' => $userid,
- 'low' => translateComma(getConfig('surfbar_warn_low_points')),
- 'points' => translateComma($userids['points'][$userid]),
- 'notified' => generateDateTime($userids['notified'][$userid]),
- 'interval' => createFancyTime(getConfig('surfbar_low_interval'))
+ 'url_userid' => $userid,
+ 'points' => $userids['points'][$userid],
+ 'notified' => $userids['notified'][$userid]
);
// Notify this user
FROM
`{?_MYSQL_PREFIX?}_surfbar_urls`
WHERE
- `%s`='%s'".$add."
+ `%s`='%s'" . $add . "
ORDER BY
`%s` %s
%s",
return false;
} // END - if
- // Translate status and limit
- $content['limit'] = translateSurfbarLimit($content['limit']);
-
// If in reg-mode we notify admin
if (($addMode == 'reg') || (getConfig('surfbar_notify_admin_unlock') == 'Y')) {
// Notify admin even when he as unlocked an email
$content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content);
// Send the notification out
- return sendAdminNotification($subject, $templateName, $content, $content['userid']);
+ return sendAdminNotification($subject, $templateName, $content, $content['url_userid']);
}
// Notify the user about the performed action
function SURFBAR_NOTIFY_USER ($messageType, $content) {
// Skip notification if userid is zero
- if ($content['userid'] == '0') {
+ if ($content['url_userid'] == '0') {
return false;
} // END - if
// Is the subject line there?
if ((substr($subject, 0, 1) == '!') && (substr($subject, -1, 1) == '!')) {
// Set default subject if following eval() wents wrong
- $subject = getMessage('MEMBER_SURFBAR_NOTIFY_DEFAULT_SUBJECT');
+ $subject = '{--MEMBER_SURFBAR_NOTIFY_DEFAULT_SUBJECT--}';
} // END - if
// Translate some data if present
$content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content);
// Load template
- $mailText = loadEmailTemplate($templateName, $content, $content['userid']);
+ $mailText = loadEmailTemplate($templateName, $content, $content['url_userid']);
// Send the email
- return sendEmail($content['userid'], $subject, $mailText);
+ return sendEmail($content['url_userid'], $subject, $mailText);
}
// Translates some data for template usage
// @TODO Can't we use our new expression language instead of this ugly code?
function SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE ($content) {
// Prepare some code
- 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['url_views_total'])) $content['url_views_total'] = translateComma($content['url_views_total']);
- if (isset($content['url_views_allowed'])) $content['url_views_allowed'] = translateComma($content['url_views_allowed']);
- if (isset($content['views_max'])) $content['views_max'] = translateComma($content['views_max']);
// Return translated content
return $content;
// Is this zero?
if ($limit == '0') {
// Unlimited!
- $return = getMessage('MEMBER_SURFBAR_UNLIMITED_VIEWS');
+ $return = '{--MEMBER_SURFBAR_UNLIMITED_VIEWS--}';
} else {
// Translate comma
$return = translateComma($limit);
if (isGetRequestParameterSet('frame')) {
// Use the frame as a template name part... ;-)
$templateName = sprintf("surfbar_frame_%s",
- getRequestParameter('frame')
+ getRequestParameter('frame')
);
} // END - if
$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['url_userid']) == 0) {
// No user ids found, no URLs!
return 0;
} // END - if
// Is the exlude userid set?
if ($excludeUserId > 0) {
// Then add it
- $userids['userid'][$excludeUserId] = $excludeUserId;
+ $userids['url_userid'][$excludeUserId] = $excludeUserId;
} // END - if
// Get amount from database
FROM
`{?_MYSQL_PREFIX?}_surfbar_urls`
WHERE
- `url_userid` NOT IN (".implode(', ', $userids['userid']).") AND
+ `url_userid` NOT IN (".implode(', ', $userids['url_userid']).") AND
`url_status`='%s'
LIMIT 1",
array($status), __FUNCTION__, __LINE__
// Lockdown the userid/id combination (reload lock)
function SURFBAR_LOCKDOWN_ID ($urlId) {
- //* DEBUG: */ outputHtml('LOCK!');
+ //* DEBUG: */ debugOutput('LOCK!');
///* DEBUG: */ return;
// Just add it to the database
SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_locks` (`locks_userid`, `locks_url_id`) VALUES (%s, %s)",
function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) {
// Init array
$userids = array(
- 'userid' => array(),
- 'points' => array(),
- 'notified' => array(),
+ 'url_userid' => array(),
+ 'points' => array(),
+ 'notified' => array(),
);
// Do we have a current user id?
if ((isMember()) && ($limit == '0')) {
// Then add this as well
- $userids['userid'][getMemberId()] = getMemberId();
+ $userids['url_userid'][getMemberId()] = getMemberId();
$userids['points'][getMemberId()] = countSumTotalData(getMemberId(), 'user_points', 'points') - countSumTotalData(getMemberId(), 'user_data', 'used_points');
$userids['notified'][getMemberId()] = '0';
// Load all userid
while ($content = SQL_FETCHARRAY($result)) {
// Get total points
- $points = countSumTotalData($content['userid'], 'user_points', 'points') - countSumTotalData($content['userid'], 'user_data', 'used_points');
- //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "userid={$content['userid']},points={$points}", false);
+ $points = countSumTotalData($content['url_userid'], 'user_points', 'points') - countSumTotalData($content['url_userid'], 'user_data', 'used_points');
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "userid={$content['url_userid']},points={$points}", false);
// Shall we add this to ignore?
if ($points <= $limit) {
// Ignore this one!
- //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "userid={$content['userid']} has depleted points amount!", false);
- $userids['userid'][$content['userid']] = $content['userid'];
- $userids['points'][$content['userid']] = $points;
- $userids['notified'][$content['userid']] = $content['notified'];
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "userid={$content['url_userid']} has depleted points amount!", false);
+ $userids['url_userid'][$content['url_userid']] = $content['url_userid'];
+ $userids['points'][$content['url_userid']] = $points;
+ $userids['notified'][$content['url_userid']] = $content['notified'];
} // END - if
} // END - while
// Update the status now
// ---------- Comment out for debugging/developing member actions! ---------
- //SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `status`='%s' WHERE `id`=%s LIMIT 1",
+ //SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `status`='%s' WHERE `url_id`=%s LIMIT 1",
// array($newStatus, bigintval($urlId)), __FUNCTION__, __LINE__);
// ---------- Comment out for debugging/developing member actions! ---------
// ---------- Comment out for debugging/developing member actions! ---------
// Prepare content for notification routines
- $data[$urlId]['userid'] = $data[$urlId]['userid'];
+ $data[$urlId]['url_userid'] = $data[$urlId]['url_userid'];
$data[$urlId]['frametester'] = generateFrametesterUrl($data[$urlId]['url']);
$data[$urlId]['reward'] = translateComma(getConfig('surfbar_static_reward'));
$data[$urlId]['costs'] = translateComma(getConfig('surfbar_static_costs'));
$percent = abs(log(getConfig('surfbar_dynamic_percent') / 100 + 1));
// Get total users
- $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true);
+ $totalUsers = getTotalConfirmedUser();
// Get online users
$onlineUsers = SURFBAR_DETERMINE_TOTAL_ONLINE();
$percent = abs(log(getConfig('surfbar_dynamic_percent') / 100 + 1));
// Get total users
- $totalUsers = countSumTotalData('CONFIRMED', 'user_data', 'userid', 'status', true);
+ $totalUsers = getTotalConfirmedUser();
// Calculate addon
$addon += abs($max * $percent * $totalUsers);
// Load all URLs of the current user and return it as an array
function SURFBAR_GET_USER_URLS () {
// Init array
- $URLs = array();
+ $urlArray = array();
// Begin the query
$result = SQL_QUERY_ESC("SELECT
// Load all rows
while ($row = SQL_FETCHARRAY($result)) {
// Add the row
- $URLs[$row['id']] = $row;
+ $urlArray[$row['id']] = $row;
} // END - while
} // END - if
SQL_FREERESULT($result);
// Return the array
- return $URLs;
+ return $urlArray;
}
// "Getter" for member action array for given status
$userids = SURFBAR_DETERMINE_DEPLETED_USERIDS();
// Get maximum randomness factor
- $maxRand = SURFBAR_GET_MAX_RANDOM($userids['userid'], $add);
+ $maxRand = SURFBAR_GET_MAX_RANDOM($userids['url_userid'], $add);
// If more than one URL can be called generate the random number!
if ($maxRand > 1) {
ON
sbu.url_id=l.locks_url_id
WHERE
- sbu.url_userid NOT IN (".implode(',', $userids['userid']).") AND
+ sbu.url_userid NOT IN (".implode(',', $userids['url_userid']).") AND
sbu.url_status='ACTIVE' AND
(sbu.url_views_allowed=0 OR (sbu.url_views_allowed > 0 AND sbu.url_views_max > 0))
".$add."
// Then take it
$data = $GLOBALS['surfbar_cache'][$element];
} else { // END - if
- print("<pre>");
+ print('<pre>');
print_r($GLOBALS['surfbar_cache']);
- print("</pre>");
- debug_report_bug();
+ print('</pre>');
+ debug_report_bug(__FUNCTION__, __LINE__, 'Element ' . $element . ' not found.');
}
// Return result
- //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "element[$element]={$data}", false);
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'element[' . $element . ']=[' . gettype($data) . ']' . $data, false);
return $data;
}