X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsurfbar_functions.php;h=0199f568c5f7e0f98fd1cd5f9f247e5e7e5b710f;hb=00e734ff1236dc875952f5b34dada9892568e7cd;hp=543f145bdbe9374f5984f097273dbb63959d07ee;hpb=1c4e78c5d68b97b82a3b930aa6db1e6df188f653;p=mailer.git diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php index 543f145bdb..0199f568c5 100644 --- a/inc/libs/surfbar_functions.php +++ b/inc/libs/surfbar_functions.php @@ -14,11 +14,9 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -40,38 +38,38 @@ // Some security stuff... if (!defined('__SECURITY')) { die(); -} +} // END - if -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // Admin functions -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // // Admin has added an URL with given user id and so on function SURFBAR_ADMIN_ADD_URL ($url, $limit, $reload) { // Do some pre-checks if (!isAdmin()) { // Not an admin - logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Not admin.", $url, $limit, $reload)); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s: Not admin.", $url, $limit, $reload)); return false; } elseif (!isUrlValid($url)) { // URL invalid - logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Invalid URL.", $url, $limit, $reload)); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s: Invalid URL.", $url, $limit, $reload)); return false; } elseif (SURFBAR_LOOKUP_BY_URL($url, 0)) { // URL already found in surfbar! - logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Already added.", $url, $limit, $reload)); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s: Already added.", $url, $limit, $reload)); return false; } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS()) { // No more allowed! - logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : No more URLs allowed.", $url, $limit, $reload)); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s: No more URLs allowed.", $url, $limit, $reload)); return false; } elseif ('' . ($limit + 0) . '' != '' . $limit . '') { // Invalid limit entered - logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Invalid limit entered.", $url, $limit, $reload)); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s: Invalid limit entered.", $url, $limit, $reload)); return false; } elseif ('' . ($reload + 0) . '' != '' . $reload . '') { // Invalid amount entered - logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Invalid reload entered.", $url, $limit, $reload)); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s: Invalid reload entered.", $url, $limit, $reload)); return false; } @@ -84,15 +82,19 @@ function SURFBAR_ADMIN_MIGRATE_URL ($url, $userid) { // Do some pre-checks if (!isAdmin()) { // Not an admin + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot migrate URL: Not admin, url=' . $url . ',userid=' . $userid); return false; } elseif (!isUrlValid($url)) { // URL invalid + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot migrate URL: Invalid URL, url=' . $url . ',userid=' . $userid); return false; } elseif (SURFBAR_LOOKUP_BY_URL($url, $userid)) { // URL already found in surfbar! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot migrate URL: Already added, url=' . $url . ',userid=' . $userid); return false; } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS($userid)) { // No more allowed! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot migrate URL: Maximum exceeded, url=' . $url . ',userid=' . $userid); return false; } @@ -105,12 +107,15 @@ function SURFBAR_ADMIN_UNLOCK_URL_IDS ($IDs) { // Is this an admin or invalid array? if (!isAdmin()) { // Not admin or invalid ids array + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Not admin'); return false; } elseif (!is_array($IDs)) { // No array + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: IDs type ' . gettype($IDs) . '!=array'); return false; } elseif (count($IDs) == 0) { // Empty array + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: IDs is empty'); return false; } @@ -132,12 +137,15 @@ function SURFBAR_ADMIN_REJECT_URL_IDS ($IDs) { // Is this an admin or invalid array? if (!isAdmin()) { // Not admin or invalid ids array + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Not admin'); return false; } elseif (!is_array($IDs)) { // No array + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: IDs type ' . gettype($IDs) . '!=array'); return false; } elseif (count($IDs) == 0) { // Empty array + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: IDs is empty'); return false; } @@ -155,27 +163,32 @@ function SURFBAR_ADMIN_REJECT_URL_IDS ($IDs) { } // -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // Member functions -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // // Member has added an URL function SURFBAR_MEMBER_ADD_URL ($url, $limit) { // Do some pre-checks if (!isMember()) { // Not a member + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Not member'); return false; } elseif ((!isUrlValid($url)) && (!isAdmin())) { // URL invalid + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Invalid, url=' . $url . ',limit=' . $limit); return false; } elseif (SURFBAR_LOOKUP_BY_URL($url, getMemberId())) { // URL already found in surfbar! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Already found, url=' . $url . ',limit=' . $limit); return false; } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS(getMemberId())) { // No more allowed! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Maximum exceeded, url=' . $url . ',limit=' . $limit); return false; } elseif (''.($limit + 0).'' != ''.$limit.'') { // Invalid amount entered + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Invalid limit, url=' . $url . ',limit=' . $limit); return false; } @@ -189,8 +202,8 @@ function SURFBAR_MEMBER_ACTIONS ($urlId, $status) { $actionArray = SURFBAR_GET_ARRAY_FROM_STATUS($status); // Init HTML code - $OUT = " -\n"; + $OUT = '
+'; // Calculate width $width = round(100 / count($actionArray)); @@ -198,18 +211,16 @@ function SURFBAR_MEMBER_ACTIONS ($urlId, $status) { // "Walk" through all actions and create forms foreach ($actionArray as $actionId => $action) { // Add form for this action - $OUT .= loadTemplate('member_surfbar_list_form', true, array( - 'width' => $width, - 'id' => bigintval($urlId), - 'action' => strtolower($action), - 'title' => '{--MEMBER_SURFBAR_ACTION_' . strtoupper($action) . '_TITLE--}', - 'submit' => '{--MEMBER_SURFBAR_ACTION_' . strtoupper($action) . '_SUBMIT--}', + $OUT .= loadTemplate('member_list_surfbar_form', true, array( + 'width' => $width, + 'url_id' => bigintval($urlId), + 'action' => strtolower($action) )); } // END - foreach // Close table - $OUT .= " -
\n"; + $OUT .= ' +'; // Return code return $OUT; @@ -223,15 +234,19 @@ function SURFBAR_MEMBER_DO_FORM ($formData, $urlArray) { // Is this a member? if (!isMember()) { // No member! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Not member'); return false; } elseif ((!isset($formData['id'])) || (!isset($formData['action']))) { // Important form elements are missing! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Invalid form data, required field id/action not found'); return false; } elseif (!isset($urlArray[$formData['id']])) { - // id not found in cache + // Id not found in cache + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Field id not found in cache'); return false; } elseif (!SURFBAR_VALIDATE_MEMBER_ACTION_STATUS($formData['action'], $urlArray[$formData['id']]['url_status'])) { // Action not allowed for current URL status + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot add URL: Action not allowed to perform. action=' . $formData['action'] . ',url_status=' . $urlArray[$formData['id']]['url_status'] . 'id=' . $formData['id']); return false; } @@ -259,8 +274,7 @@ function SURFBAR_MEMBER_DO_FORM ($formData, $urlArray) { $performed = call_user_func_array($functionName, $urlData); } else { // Log invalid request - logDebugMessage(__FUNCTION__, __LINE__, "action={$formData['action']},id={$formData['id']},function={$functionName}"); - addFatalMessage(__FUNCTION__, __LINE__, "Invalid member action! action=%s,id=%s,function=%s", array($formData['action'], $formData['id'], $functionName)); + debug_report_bug(__FUNCTION__, __LINE__, 'Invalid member action! action=' . $formData['action'] . ',id=' . $formData['id'] . ',function=' . $functionName); } // Return status @@ -270,8 +284,8 @@ function SURFBAR_MEMBER_DO_FORM ($formData, $urlArray) { // Validate if the requested action can be performed on current URL status function SURFBAR_VALIDATE_MEMBER_ACTION_STATUS ($action, $status) { // Search for the requested action/status combination in database - $result = SQL_QUERY_ESC("SELECT new_status FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `action`='%s' AND `status`='%s' LIMIT 1", - array($action, $status), __FUNCTION__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `actions_new_status` FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `actions_action`='%s' AND `actions_status`='%s' LIMIT 1", + array($action, $status), __FUNCTION__, __LINE__); // Is the entry there? $isValid = (SQL_NUMROWS($result) == 1); @@ -290,9 +304,9 @@ function SURFBAR_VALIDATE_MEMBER_ACTION_STATUS ($action, $status) { } // -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // Member actions -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // // Retreat a booked URL function SURFBAR_MEMBER_RETREAT_ACTION ($urlData) { @@ -366,25 +380,19 @@ function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) { // Translate some data if present $content = SURFBAR_PREPARE_CONTENT_FOR_TEMPLATE($content); - // Is the lock reason empty? - if (empty($urlData['url_lock_reason'])) { - // Fix it to three dashes - $urlData['url_lock_reason'] = '---'; - } // END - if - // Include fields only for action 'edit' if ($action == 'edit') { // Default is not limited - $urlData['limited_y'] = ''; - $urlData['limited_n'] = ' checked="checked"'; - $urlData['limited'] = 'false'; + $urlData['limited_yes'] = ''; + $urlData['limited_no'] = ' checked="checked"'; + $urlData['limited'] = 'false'; // Is this URL limited? if (SURFBAR_GET_VIEWS_MAX() > 0) { // Then rewrite form data - $urlData['limited_y'] = ' checked="checked"'; - $urlData['limited_n'] = ''; - $urlData['limited'] = 'true'; + $urlData['limited_yes'] = ' checked="checked"'; + $urlData['limited_no'] = ''; + $urlData['limited'] = 'true'; } // END - if } // END - if @@ -417,8 +425,8 @@ function SURFBAR_MEMBER_EXECUTE_ACTION ($action, $urlData) { $executed = SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['url_status'], $urlData['new_status'], array($urlData['id'] => $urlData)); } // END - if } else { - // Not found! - addFatalMessage(__FUNCTION__, __LINE__, getMessage('MEMBER_SURFBAR_EXECUTE_ACTION_404'), $functionName); + // Not found + debug_report_bug(__FUNCTION__, __LINE__, 'Callback function ' . $functionName . ' not found.'); } // Return status @@ -449,9 +457,9 @@ function SURFBAR_MEMBER_EXECUTE_DELETE_ACTION ($urlData) { return true; } // -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // Self-maintenance functions -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // // Main function function SURFBAR_HANDLE_SELF_MAINTENANCE () { @@ -461,6 +469,7 @@ function SURFBAR_HANDLE_SELF_MAINTENANCE () { // Handle low-points amounts SURFBAR_HANDLE_LOW_POINTS(); } + // Handle URLs which limit has depleted function SURFBAR_HANDLE_DEPLETED_VIEWS () { // Get all URLs @@ -474,7 +483,9 @@ function SURFBAR_HANDLE_DEPLETED_VIEWS () { $data = $urlData; // Rewrite array for next call - $urlData[$id] = $data; + $urlData = array( + $id => $data + ); // Handle the status SURFBAR_CHANGE_STATUS($id, 'ACTIVE', 'DEPLETED', $urlData); @@ -509,9 +520,9 @@ function SURFBAR_HANDLE_LOW_POINTS () { } // -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // Generic functions -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // // Looks up by an URL @@ -571,7 +582,7 @@ ORDER BY ), __FUNCTION__, __LINE__); // Is there at least one record? - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Then load all! while ($dataRow = SQL_FETCHARRAY($result)) { // Shall we group these results? @@ -602,16 +613,15 @@ function SURFBAR_REGISTER_URL ($url, $userid, $status = 'PENDING', $addMode = 'r // Prepare content $content = merge_array($extraFields, array( 'url' => $url, - 'frametester' => generateFrametesterUrl($url), 'url_userid' => $userid, 'url_status' => $status, )); // Is limit/reload set? - if (!isset($config['limit'])) { + if (!isset($content['limit'])) { $content['limit'] = '0'; } // END - if - if (!isset($config['reload'])) { + if (!isset($content['reload'])) { $content['reload'] = '0'; } // END - if @@ -643,7 +653,9 @@ function SURFBAR_INSERT_URL_BY_ARRAY ($urlData) { $userid = bigintval($urlData['url_userid']); // Is the id set? - if (empty($userid)) $userid = '0'; + if (empty($userid)) { + $userid = 'NULL'; + } // END - if // Just run the insert query for now SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_urls` (`url_userid`,`url`,`url_status`,`url_views_max`,`url_views_allowed`,`url_fixed_reload`) VALUES (%s,'%s','%s',%s,%s,%s)", @@ -667,14 +679,14 @@ function SURFBAR_NOTIFY_ADMIN ($messageType, $content) { $templateName = sprintf("admin_surfbar_%s", $messageType); // Prepare subject - $subject = getMessage(sprintf("ADMIN_SURFBAR_NOTIFY_%s_SUBJECT", + $subject = sprintf("{--ADMIN_SURFBAR_NOTIFY_%s_SUBJECT--}", strtoupper($messageType) - )); + ); // Is the subject line there? if ((substr($subject, 0, 1) == '!') && (substr($subject, -1, 1) == '!')) { // Set default subject if following eval() wents wrong - $subject = getMaskedMessage('ADMIN_SURFBAR_NOTIFY_DEFAULT_SUBJECT', strtoupper($messageType)); + $subject = '{%message,ADMIN_SURFBAR_NOTIFY_DEFAULT_SUBJECT=' . strtoupper($messageType) . '%}'; } // END - if // Translate some data if present @@ -695,14 +707,14 @@ function SURFBAR_NOTIFY_USER ($messageType, $content) { $templateName = sprintf("member_surfbar_%s", $messageType); // Prepare subject - $subject = getMessage(sprintf("MEMBER_SURFBAR_NOTIFY_%s_SUBJECT", + $subject = sprintf("{--MEMBER_SURFBAR_NOTIFY_%s_SUBJECT--}", strtoupper($messageType) - )); + ); // 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 @@ -731,10 +743,10 @@ function translateSurfbarLimit ($limit) { // Is this zero? if ($limit == '0') { // Unlimited! - $return = getMessage('MEMBER_SURFBAR_UNLIMITED_VIEWS'); + $return = '{--MEMBER_SURFBAR_UNLIMITED_VIEWS--}'; } else { // Translate comma - $return = translateComma($limit); + $return = '{%pipe,translateComma=' . $limit . '%}'; } // Return value @@ -743,25 +755,67 @@ function translateSurfbarLimit ($limit) { // Translate the URL status function translateSurfbarUrlStatus ($status) { - // Create constant name - $constantName = sprintf("SURFBAR_URL_STATUS_%s", strtoupper($status)); + // NULL must be handled carfefully + if ((is_null($status)) || (trim($status) == '')) { + // Is NULL, so return other language string + return '{--SURFBAR_URL_STATUS_NONE--}'; + } else { + // Return regular result + return sprintf("{--SURFBAR_URL_STATUS_%s--}", strtoupper($status)); + } +} - // Get message - $statusTranslated = getMessage($constantName); +// Translates the given action into a link title for members +function translateMemberSurfbarActionToTitle ($action) { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__][$action])) { + // Construct default return string (unknown + $GLOBALS[__FUNCTION__][$action] = '{%message,MEMBER_SURFBAR_ACTION_UNKNOWN_TITLE=' . $action . '%}'; - // Return result - return $statusTranslated; + // ... and the id's name + $messageId = 'MEMBER_SURFBAR_ACTION_' . strtoupper($action) . '_TITLE'; + + // Is the id there? + if (isMessageIdValid($messageId)) { + // Then use it + $GLOBALS[__FUNCTION__][$action] = '{--' . $messageId . '--}'; + } // END - if + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__][$action]; +} + +// Translates the given action into a submit button for members +function translateMemberSurfbarActionToSubmit ($action) { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__][$action])) { + // Construct default return string (unknown + $GLOBALS[__FUNCTION__][$action] = '{%message,MEMBER_SURFBAR_ACTION_UNKNOWN_SUBMIT=' . $action . '%}'; + + // ... and the id's name + $messageId = 'MEMBER_SURFBAR_ACTION_' . strtoupper($action) . '_SUBMIT'; + + // Is the id there? + if (isMessageIdValid($messageId)) { + // Then use it + $GLOBALS[__FUNCTION__][$action] = '{--' . $messageId . '--}'; + } // END - if + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__][$action]; } // Determine reward -function SURFBAR_DETERMINE_REWARD ($onlyMin=false) { +function SURFBAR_DETERMINE_REWARD ($onlyMin = false) { // Static values are default $reward = getConfig('surfbar_static_reward'); // Do we have static or dynamic? - if (getConfig('surfbar_pay_model') == 'DYNAMIC') { + if (getSurfbarPaymentModel() == 'DYNAMIC') { // "Calculate" dynamic reward - if ($onlyMin) { + if ($onlyMin === true) { $reward += SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); } else { $reward += SURFBAR_CALCULATE_DYNAMIC_ADD(); @@ -778,7 +832,7 @@ function SURFBAR_DETERMINE_COSTS ($onlyMin=false) { $costs = getConfig('surfbar_static_costs'); // Do we have static or dynamic? - if (getConfig('surfbar_pay_model') == 'DYNAMIC') { + if (getSurfbarPaymentModel() == 'DYNAMIC') { // "Calculate" dynamic costs if ($onlyMin) { $costs += SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); @@ -804,7 +858,7 @@ function SURFBAR_CALCULATE_DYNAMIC_ADD () { // Determine right template name function SURFBAR_DETERMINE_TEMPLATE_NAME() { // Default is the frameset - $templateName = "surfbar_frameset"; + $templateName = 'surfbar_frameset'; // Any frame set? ;-) if (isGetRequestParameterSet('frame')) { @@ -820,35 +874,37 @@ function SURFBAR_DETERMINE_TEMPLATE_NAME() { // Check if the "reload lock" of the current user is full, call this function // before you call SURFBAR_CHECK_RELOAD_LOCK(). -function SURFBAR_CHECK_RELOAD_FULL() { +function SURFBAR_CHECK_RELOAD_FULL () { + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Fixed surf lock is ' . getConfig('surfbar_static_lock') . ' - ENTERED!'); // Default is full! $isFull = true; // Cache static reload lock $GLOBALS['surfbar_cache']['surf_lock'] = getConfig('surfbar_static_lock'); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Fixed surf lock is '.getConfig('surfbar_static_lock') . '', false); // Do we have dynamic model? - if (getConfig('surfbar_pay_model') == 'DYNAMIC') { + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'surf_lock=' . $GLOBALS['surfbar_cache']['surf_lock'] . ' - BEFORE'); + if (getSurfbarPaymentModel() == 'DYNAMIC') { // "Calculate" dynamic lock $GLOBALS['surfbar_cache']['surf_lock'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); } // END - if + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'surf_lock=' . $GLOBALS['surfbar_cache']['surf_lock'] . ' - AFTER'); // Ask the database $result = SQL_QUERY_ESC("SELECT - COUNT(l.locks_id) AS cnt + COUNT(l.`locks_id`) AS `cnt` FROM `{?_MYSQL_PREFIX?}_surfbar_locks` AS l INNER JOIN `{?_MYSQL_PREFIX?}_surfbar_urls` AS u ON - u.url_id=l.locks_url_id + u.`url_id`=l.`locks_url_id` WHERE - l.locks_userid=%s AND - (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(l.locks_last_surfed) AND + l.`locks_userid`=%s AND + (UNIX_TIMESTAMP() - {%%pipe,SURFBAR_GET_SURF_LOCK%%}) < UNIX_TIMESTAMP(l.`locks_last_surfed`) AND ( - ((UNIX_TIMESTAMP(l.locks_last_surfed) - u.url_fixed_reload) < 0 AND u.url_fixed_reload > 0) OR - u.url_fixed_reload = '0' + ((UNIX_TIMESTAMP(l.`locks_last_surfed`) - u.`url_fixed_reload`) < 0 AND u.`url_fixed_reload` > 0) OR + u.`url_fixed_reload` = 0 ) LIMIT 1", array(getMemberId()), __FUNCTION__, __LINE__ @@ -870,10 +926,10 @@ LIMIT 1", $total = SURFBAR_GET_TOTAL_URLS(); // Do we have some URLs in lock? Admins can always surf on own URLs! - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "userLocks=".SURFBAR_GET_USER_LOCKS().",total={$total}", false); $isFull = ((SURFBAR_GET_USER_LOCKS() == $total) && ($total > 0)); // Return result + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userLocks=' . SURFBAR_GET_USER_LOCKS() . ',total=' . $total . 'isFull=' . intval($isFull) . ' - EXIT!'); return $isFull; } @@ -889,7 +945,7 @@ function SURFBAR_GET_TOTAL_URLS ($status = 'ACTIVE', $excludeUserId = '0') { } // END - if // Is the exlude userid set? - if ($excludeUserId > 0) { + if (isValidUserId($excludeUserId)) { // Then add it $userids['url_userid'][$excludeUserId] = $excludeUserId; } // END - if @@ -907,30 +963,33 @@ LIMIT 1", ); // Fetch row - list($cnt) = SQL_FETCHROW($result); + list($count) = SQL_FETCHROW($result); // Free result SQL_FREERESULT($result); + // Debug message + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'cnt=' . $count); + // Return result - return $cnt; + return $count; } // Check wether the user is allowed to book more URLs -function SURFBAR_IF_USER_BOOK_MORE_URLS ($userid = '0') { +function SURFBAR_IF_USER_BOOK_MORE_URLS ($userid = NULL) { // Is this admin and userid is zero or does the user has some URLs left to book? - return ((($userid == '0') && (isAdmin())) || (SURFBAR_GET_TOTAL_USER_URLS($userid, '', array('REJECTED')) < getConfig('surfbar_max_order'))); + return (((is_null($userid)) && (isAdmin())) || (SURFBAR_GET_TOTAL_USER_URLS($userid, '', array('REJECTED')) < getSurfbarMaxOrder())); } // Get total amount of URLs of given status for current user -function SURFBAR_GET_TOTAL_USER_URLS ($userid = '0', $status = '', $exclude = '') { +function SURFBAR_GET_TOTAL_USER_URLS ($userid = NULL, $status = '', $exclude = '') { // Is the user 0 and user is logged in? - if (($userid == '0') && (isMember())) { + if ((is_null($userid)) && (isMember())) { // Then use this userid $userid = getMemberId(); - } elseif ($userid == '0') { + } elseif (is_null($userid)) { // Error! - return (getConfig('surfbar_max_order') + 1); + return (getSurfbarMaxOrder() + 1); } // Default is all URLs @@ -939,68 +998,53 @@ function SURFBAR_GET_TOTAL_USER_URLS ($userid = '0', $status = '', $exclude = '' // Is the status set? if (is_array($status)) { // Only URLs with these status - $add = sprintf(" AND `url_status` IN('%s')", implode("','", $status)); + $add = sprintf(" WHERE `url_status` IN('%s')", implode("','", $status)); } elseif (!empty($status)) { // Only URLs with this status - $add = sprintf(" AND `url_status`='%s'", $status); + $add = sprintf(" WHERE `url_status`='%s'", $status); } elseif (is_array($exclude)) { // Exclude URLs with these status - $add = sprintf(" AND `url_status` NOT IN('%s')", implode("','", $exclude)); + $add = sprintf(" WHERE `url_status` NOT IN('%s')", implode("','", $exclude)); } elseif (!empty($exclude)) { // Exclude URLs with this status - $add = sprintf(" AND `url_status` != '%s'", $exclude); + $add = sprintf(" WHERE `url_status` != '%s'", $exclude); } // Get amount from database - $cnt = countSumTotalData($userid, 'surfbar_urls', 'url_id', 'url_userid', true, $add); + $count = countSumTotalData($userid, 'surfbar_urls', 'url_id', 'url_userid', true, $add); // Return result - return $cnt; + return $count; } // Generate a validation code for the given id number function SURFBAR_GENERATE_VALIDATION_CODE ($urlId, $salt = '') { - // @TODO Invalid salt should be refused - $GLOBALS['surfbar_cache']['salt'] = 'INVALID'; - - // Get code length from config - $length = getConfig('code_length'); - - // Fix length to 10 - if ($length == '0') $length = 10; - - // Generate a code until the length matches - $valCode = ''; - while (strlen($valCode) != $length) { - // Is the salt set? - if (empty($salt)) { - // Generate random hashed string - $GLOBALS['surfbar_cache']['salt'] = sha1(generatePassword(mt_rand(200, 255))); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'newSalt='.SURFBAR_GET_SALT().'', false); - } else { - // Use this as salt! - $GLOBALS['surfbar_cache']['salt'] = $salt; - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'oldSalt='.SURFBAR_GET_SALT().'', false); - } - - // ... and now the validation code - $valCode = generateRandomCode($length, sha1(SURFBAR_GET_SALT().':'.$urlId), getMemberId()); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'valCode='.valCode.'', false); - } // END - while + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',salt=' . $salt . ' - ENTERED!'); + // Init hash with invalid value + if (empty($salt)) { + // Generate random hashed string + $GLOBALS['surfbar_cache']['salt'] = sha1(generatePassword(mt_rand(200, 255))); + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'newSalt='.SURFBAR_GET_SALT().'', false); + } else { + // Use this as salt! + $GLOBALS['surfbar_cache']['salt'] = $salt; + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'oldSalt='.SURFBAR_GET_SALT().'', false); + } // Hash it with md5() and salt it with the random string - $hashedCode = generateHash(md5($valCode), SURFBAR_GET_SALT()); + $hashedCode = generateHash(md5($urlId . getEncryptSeperator() . getMemberId()), SURFBAR_GET_SALT()); // Finally encrypt it PGP-like and return it $valHashedCode = encodeHashForCookie($hashedCode); // Return hashed value - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'finalValCode='.$valHashedCode.'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',salt=' . $salt . ',urlId=' . $urlId . ',salt=' . $salt . ',valHashedCode=' . $valHashedCode . ' - EXIT!'); return $valHashedCode; } // Check validation code function SURFBAR_CHECK_VALIDATION_CODE ($urlId, $check, $salt) { + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',check=' . $check . ',salt=' . $salt . ' - ENTERED!'); // Secure id number $urlId = bigintval($urlId); @@ -1008,35 +1052,52 @@ function SURFBAR_CHECK_VALIDATION_CODE ($urlId, $check, $salt) { $code = SURFBAR_GENERATE_VALIDATION_CODE($urlId, $salt); // Return result of checking hashes and salts - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '---'.$code.'|'.$check.'---', false); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '+++'.$salt.'|'.SURFBAR_GET_DATA('salts_last_salt').'+++', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',(code==check)=' . intval($code == $check) . ',(salt==salts_last_salt)=' . intval($salt == SURFBAR_GET_DATA('salts_last_salt')) . ' - EXIT!'); return (($code == $check) && ($salt == SURFBAR_GET_DATA('salts_last_salt'))); } // Lockdown the userid/id combination (reload lock) function SURFBAR_LOCKDOWN_ID ($urlId) { - //* 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)", - array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',getMemberId()=' . getMemberId() . ' - ENTERED!'); + // Search for an entry + $countLock = countSumTotalData(getMemberId(), 'surfbar_locks', 'locks_id', 'locks_userid', true, ' AND `locks_url_id`=' . bigintval($urlId)); + + // Do we have no record? + if ($countLock == 0) { + // Just add it to the database + SQL_QUERY_ESC('INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_locks` (`locks_userid`,`locks_url_id`) VALUES (%s, %s)', + array( + getMemberId(), + bigintval($urlId) + ), __FUNCTION__, __LINE__); + } // END - if // Remove the salt from database - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_surfbar_salts` WHERE `salts_url_id`=%s AND `salts_userid`=%s LIMIT 1", - array(bigintval($urlId), getMemberId()), __FUNCTION__, __LINE__); + SQL_QUERY_ESC('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_surfbar_salts` WHERE `salts_url_id`=%s AND `salts_userid`=%s LIMIT 1', + array( + bigintval($urlId), + getMemberId() + ), __FUNCTION__, __LINE__); + + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',getMemberId()=' . getMemberId() . ',SQL_AFFECTEDROWS()=' . SQL_AFFECTEDROWS() . ' - EXIT!'); } // Pay points to the user and remove it from the sender if userid is given else it is a "sponsored surf" function SURFBAR_PAY_POINTS () { // Remove it from the URL owner - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid='.SURFBAR_GET_USERID().',costs='.SURFBAR_GET_COSTS().'', false); - if (SURFBAR_GET_USERID() > 0) { - subtractPoints(sprintf("surfbar_%s", getConfig('surfbar_pay_model')), SURFBAR_GET_USERID(), SURFBAR_GET_COSTS()); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid='.SURFBAR_GET_USERID().',costs='.SURFBAR_GET_COSTS() . ' - ENTERED!'); + if (isValidUserId(SURFBAR_GET_USERID())) { + // Subtract points and ignore return status + subtractPoints(sprintf("surfbar_%s", getSurfbarPaymentModel()), SURFBAR_GET_USERID(), SURFBAR_GET_COSTS()); } // END - if - // Book it to the user - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid='.getMemberId().',reward='.SURFBAR_GET_REWARD().'', false); - addPointsThroughReferalSystem(sprintf("surfbar_%s", getConfig('surfbar_pay_model')), getMemberId(), SURFBAR_GET_DATA('reward')); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid='.getMemberId().',reward='.SURFBAR_GET_REWARD()); + // Init referal system here + initReferalSystem(); + + // Book it to the user and ignore return status + addPointsThroughReferalSystem(sprintf("surfbar:%s", getSurfbarPaymentModel()), getMemberId(), SURFBAR_GET_REWARD()); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid='.SURFBAR_GET_USERID().',costs='.SURFBAR_GET_COSTS() . ' - EXIT!'); } // Updates the statistics of current URL/userid @@ -1050,24 +1111,24 @@ function SURFBAR_UPDATE_INSERT_STATS_RECORD () { // Do we have a limit? if ($allowed > 0) { // Then count views_max down! - $add .= ", `views_max`=`views_max`-1"; + $add .= ', `url_views_max`=`url_views_max`-1'; } // END - if // Update URL stats - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url_views_total`=`url_views_total`+1".$add." WHERE `url_id`=%s LIMIT 1", + SQL_QUERY_ESC('UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url_views_total`=`url_views_total`+1' . $add . ' WHERE `url_id`=%s LIMIT 1', array(SURFBAR_GET_ID()), __FUNCTION__, __LINE__); // Update the stats entry - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_stats` SET `stats_count`=`stats_count`+1 WHERE `stats_userid`=%s AND `stats_url_id`=%s LIMIT 1", + SQL_QUERY_ESC('UPDATE `{?_MYSQL_PREFIX?}_surfbar_stats` SET `stats_count`=`stats_count`+1 WHERE `stats_userid`=%s AND `stats_url_id`=%s LIMIT 1', array( getMemberId(), SURFBAR_GET_ID() ), __FUNCTION__, __LINE__); // Was that update okay? - if (SQL_AFFECTEDROWS() < 1) { + if (SQL_HASZEROAFFECTED()) { // No, then insert entry - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_stats` (`stats_userid`, `stats_url_id`, `stats_count`) VALUES (%s,%s,1)", + SQL_QUERY_ESC('INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_stats` (`stats_userid`,`stats_url_id`,`stats_count`) VALUES (%s,%s,1)', array( getMemberId(), SURFBAR_GET_ID() @@ -1086,6 +1147,15 @@ function SURFBAR_UPDATE_INSERT_STATS_RECORD () { // Update the salt for validation and statistics function SURFBAR_UPDATE_SALT_STATS () { + // Update salt + SURFBAR_GENERATE_VALIDATION_CODE(SURFBAR_GET_ID()); + + // Make sure only valid salts can pass + if (SURFBAR_GET_SALT() == 'INVALID') { + // Invalid provided + debug_report_bug(__FUNCTION__, __LINE__, 'Invalid salt provided, id=' . SURFBAR_GET_ID() . ',getMemberId()=' . getMemberId()); + } // END - if + // Update statistics record SURFBAR_UPDATE_INSERT_STATS_RECORD(); @@ -1098,25 +1168,29 @@ function SURFBAR_UPDATE_SALT_STATS () { ), __FUNCTION__, __LINE__); // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'salt='.SURFBAR_GET_SALT().',id='.SURFBAR_GET_ID().',userid='.getMemberId().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'salt=' . SURFBAR_GET_SALT() . ',id=' . SURFBAR_GET_ID() . ',userid=' . getMemberId() . ',SQL_AFFECTEDROWS()=' . SQL_AFFECTEDROWS() . ' - UPDATE!'); // Was that okay? - if (SQL_AFFECTEDROWS() < 1) { + if (SQL_HASZEROAFFECTED()) { // Insert missing entry! - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_salts` (`salts_url_id`, `salts_userid`, `salts_last_salt`) VALUES (%s, %s, '%s')", - array(SURFBAR_GET_ID(), getMemberId(), SURFBAR_GET_SALT()), __FUNCTION__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_salts` (`salts_url_id`,`salts_userid`,`salts_last_salt`) VALUES (%s, %s, '%s')", + array( + SURFBAR_GET_ID(), + getMemberId(), + SURFBAR_GET_SALT() + ), __FUNCTION__, __LINE__); } // END - if // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'affectedRows='.SQL_AFFECTEDROWS().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'affectedRows=' . SQL_AFFECTEDROWS() . ' - EXIT!'); // Return if the update was okay - return (SQL_AFFECTEDROWS() == 1); + return (!SQL_HASZEROAFFECTED()); } // Check if the reload lock is active for given id function SURFBAR_CHECK_RELOAD_LOCK ($urlId) { - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'id=' . $urlId . '', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'id=' . $urlId . ' - ENTERED!'); // Ask the database $result = SQL_QUERY_ESC("SELECT COUNT(`locks_id`) AS cnt FROM @@ -1132,14 +1206,14 @@ LIMIT 1", ); // Fetch counter - list($cnt) = SQL_FETCHROW($result); + list($count) = SQL_FETCHROW($result); // Free result SQL_FREERESULT($result); // Return check - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'cnt=' . $cnt . ',' . SURFBAR_GET_SURF_LOCK() . '', false); - return ($cnt == 1); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',count=' . $count . ',SURFBAR_GET_SURF_LOCK()=' . SURFBAR_GET_SURF_LOCK() . ' - EXIT!'); + return ($count == 1); } // Determine which user hash no more points left @@ -1154,9 +1228,9 @@ function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) { // Do we have a current user id? if ((isMember()) && ($limit == '0')) { // Then add this as well - $userids['url_userid'][getMemberId()] = getMemberId(); - $userids['points'][getMemberId()] = countSumTotalData(getMemberId(), 'user_points', 'points') - countSumTotalData(getMemberId(), 'user_data', 'used_points'); - $userids['notified'][getMemberId()] = '0'; + $userids['url_userid'][getMemberId()] = getMemberId(); + $userids['points'][getMemberId()] = getTotalPoints(getMemberId()); + $userids['notified'][getMemberId()] = '0'; // Get all userid except logged in one $result = SQL_QUERY_ESC("SELECT @@ -1166,13 +1240,14 @@ FROM INNER JOIN `{?_MYSQL_PREFIX?}_user_data` AS d ON - u.url_userid=d.userid + u.`url_userid`=d.`userid` WHERE - u.url_userid NOT IN (%s,0) AND u.url_status='ACTIVE' + u.`url_userid` NOT IN (%s,0) AND + u.`url_status`='ACTIVE' GROUP BY - u.url_userid + u.`url_userid` ORDER BY - u.url_userid ASC", + u.`url_userid` ASC", array(getMemberId()), __FUNCTION__, __LINE__); } else { // Get all userid @@ -1183,28 +1258,29 @@ FROM INNER JOIN `{?_MYSQL_PREFIX?}_user_data` AS d ON - u.url_userid=d.userid + u.`url_userid`=d.`userid` WHERE - u.url_status='ACTIVE' + u.`url_userid` > 0 AND + u.`url_status`='ACTIVE' GROUP BY - u.url_userid + u.`url_userid` ORDER BY - u.url_userid ASC", __FUNCTION__, __LINE__); + u.`url_userid` ASC", __FUNCTION__, __LINE__); } // Load all userid while ($content = SQL_FETCHARRAY($result)) { // Get total points - $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); + $points = getTotalPoints($content['url_userid']); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $content['url_userid'] . ',points=' . $points); // Shall we add this to ignore? if ($points <= $limit) { // Ignore this one! - //* 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']; + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $content['url_userid'] . ' has depleted points amount!'); + $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 @@ -1212,7 +1288,7 @@ ORDER BY SQL_FREERESULT($result); // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "UIDs::count=".count($userids)." (with own userid=".getMemberId().')', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'UIDs::count=' . count($userids) . ' (with own userid=' . getMemberId() . ')'); // Return result return $userids; @@ -1221,23 +1297,23 @@ ORDER BY // Determine how many users are Online in surfbar function SURFBAR_DETERMINE_TOTAL_ONLINE () { // Count all users in surfbar modue and return the value - $result = SQL_QUERY("SELECT + $result = SQL_QUERY('SELECT `stats_id` FROM `{?_MYSQL_PREFIX?}_surfbar_stats` WHERE (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`stats_last_surfed`)) <= {?online_timeout?} GROUP BY - `stats_userid` ASC", __FUNCTION__, __LINE__); + `stats_userid` ASC', __FUNCTION__, __LINE__); // Fetch count - $cnt = SQL_NUMROWS($result); + $count = SQL_NUMROWS($result); // Free result SQL_FREERESULT($result); // Return result - return $cnt; + return $count; } // Determine waiting time for one URL @@ -1255,7 +1331,7 @@ function SURFBAR_DETERMINE_WAIT_TIME () { $time = getConfig('surfbar_static_time'); // Which payment model do we have? - if (getConfig('surfbar_pay_model') == 'DYNAMIC') { + if (getSurfbarPaymentModel() == 'DYNAMIC') { // "Calculate" dynamic time $time += SURFBAR_CALCULATE_DYNAMIC_ADD(); } // END - if @@ -1265,7 +1341,8 @@ function SURFBAR_DETERMINE_WAIT_TIME () { } // Changes the status of an URL from given to other -function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) { +function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data = array()) { + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',prevStatus=' . $prevStatus . ',newStatus=' . $newStatus . ' - ENTERED!'); // Make new status always lower-case $newStatus = strtolower($newStatus); @@ -1275,52 +1352,49 @@ function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) $data = SURFBAR_GET_URL_DATA($urlId); } // END - if - // Is the new status set? - if ((!is_string($newStatus)) || (empty($newStatus))) { - // Abort here, but fine! - return true; - } // END - if + // Prepare array + $filterData = array( + 'url_id' => $urlId, + 'prev_status' => $prevStatus, + 'new_status' => $newStatus, + 'data' => $data, + 'abort' => null + ); - // Is the status like prevStatus is saying? - if ($data[$urlId]['url_status'] != $prevStatus) { - // No, then abort here - return false; - } // END - if + // Run pre filter chain + $filterData = runFilterChain('pre_change_surfbar_url_status', $filterData); + // Abort here? + if (!is_null($filterData['abort'])) { + // Abort here + return $filterData['abort']; + } // Update the status now // ---------- Comment out for debugging/developing member actions! --------- - //SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `status`='%s' WHERE `url_id`=%s LIMIT 1", - // array($newStatus, bigintval($urlId)), __FUNCTION__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url_status`='%s' WHERE `url_id`=%s LIMIT 1", + array( + $newStatus, + bigintval($urlId) + ), __FUNCTION__, __LINE__); // ---------- Comment out for debugging/developing member actions! --------- // Was that fine? // ---------- Comment out for debugging/developing member actions! --------- - //if (SQL_AFFECTEDROWS() != 1) { - // // No, something went wrong - // return false; - //} // END - if - // ---------- Comment out for debugging/developing member actions! --------- - - // Prepare content for notification routines - $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')); - - // Do some dirty fixing here: - if (($data[$urlId]['url_status'] == 'STOPPED') && ($newStatus == 'pending')) { - // Fix for template change - $newStatus = 'continued'; + if (SQL_AFFECTEDROWS() != 1) { + // No, something went wrong + return false; } // END - if + // ---------- Comment out for debugging/developing member actions! --------- - // Send admin notification - SURFBAR_NOTIFY_ADMIN('url_' . $data[$urlId]['url_status'] . '_' . $newStatus, $data[$urlId]); + // Run post filter chain + $filterData = runFilterChain('post_change_surfbar_url_status', $filterData); - // Send user notification - SURFBAR_NOTIFY_USER('url_' . $data[$urlId]['url_status'] . '_' . $newStatus, $data[$urlId]); + // Extract data from it again + $data = $filterData['data']; // All done! + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',prevStatus=' . $prevStatus . ',newStatus=' . $newStatus . ' - EXIT!'); return true; } @@ -1408,7 +1482,10 @@ function SURFBAR_GET_LOCK_IDS () { $ignored = array(); // Get all id from locks within the timestamp - $result = SQL_QUERY_ESC("SELECT `locks_id`, `locks_url_id`, UNIX_TIMESTAMP(`locks_last_surfed`) AS last_surfed + $result = SQL_QUERY_ESC("SELECT + `locks_id`, + `locks_url_id`, + UNIX_TIMESTAMP(`locks_last_surfed`) AS `last_surfed` FROM `{?_MYSQL_PREFIX?}_surfbar_locks` WHERE @@ -1420,30 +1497,30 @@ ORDER BY // Load all entries while ($content = SQL_FETCHARRAY($result)) { // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'next - lid='.$content['id'].',url='.$content['url_id'].',rest='.(time() - $content['last_surfed']).'/'.SURFBAR_GET_SURF_LOCK().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'next - lid='.$content['locks_id'].',url='.$content['locks_url_id'].',rest='.(time() - $content['last_surfed']).'/'.SURFBAR_GET_SURF_LOCK()); // Skip entries that are too old - if (($content['last_surfed'] > (time() - SURFBAR_GET_SURF_LOCK())) && (!in_array($content['url_id'], $ignored))) { + if (($content['last_surfed'] > (time() - SURFBAR_GET_SURF_LOCK())) && (!in_array($content['locks_url_id'], $ignored))) { // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'okay - lid='.$content['id'].',url='.$content['url_id'].',last='.$content['last_surfed'].'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'okay - lid='.$content['locks_id'].',url='.$content['locks_url_id'].',last='.$content['last_surfed']); // Add only if missing or bigger - if ((!isset($IDs[$content['url_id']])) || ($IDs[$content['url_id']] > $content['last_surfed'])) { + if ((!isset($IDs[$content['locks_url_id']])) || ($IDs[$content['locks_url_id']] > $content['last_surfed'])) { // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'ADD - lid='.$content['id'].',url='.$content['url_id'].',last='.$content['last_surfed'].'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'ADD - lid='.$content['locks_id'].',url='.$content['locks_url_id'].',last='.$content['last_surfed']); // Add this id - $IDs[$content['url_id']] = $content['last_surfed']; - $USE[$content['url_id']] = $content['id']; + $IDs[$content['locks_url_id']] = $content['last_surfed']; + $USE[$content['locks_url_id']] = $content['locks_id']; } // END - if } else { // Debug message - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'ignore - lid='.$content['id'].',url='.$content['url_id'].',last='.$content['last_surfed'].'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'ignore - lid='.$content['locks_id'].',url='.$content['locks_url_id'].',last='.$content['last_surfed']); // Ignore these old entries! - $ignored[] = $content['url_id']; - unset($IDs[$content['url_id']]); - unset($USE[$content['url_id']]); + $ignored[] = $content['locks_url_id']; + unset($IDs[$content['locks_url_id']]); + unset($USE[$content['locks_url_id']]); } } // END - while @@ -1470,15 +1547,15 @@ LEFT JOIN ON sbu.url_id=l.locks_url_id WHERE - sbu.url_userid NOT IN (".implode(',', $userids).") AND + sbu.url_userid NOT IN (" . implode(',', $userids) . ") AND (sbu.url_views_allowed=0 OR (sbu.url_views_allowed > 0 AND sbu.url_views_max > 0)) AND sbu.url_status='ACTIVE' - ".$add." + " . $add . " GROUP BY sbu.url_id ASC", __FUNCTION__, __LINE__); // Log last query - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS()); // Fetch max rand $maxRand = SQL_NUMROWS($result); @@ -1505,23 +1582,23 @@ function SURFBAR_GET_USER_URLS () { u.url_views_max, u.url_views_allowed, UNIX_TIMESTAMP(u.url_registered) AS `url_registered`, - UNIX_TIMESTAMP(u.url_last_locked) AS `url_last_locked`, - u.url_lock_reason + UNIX_TIMESTAMP(u.`url_last_locked`) AS `url_last_locked`, + u.`url_lock_reason` FROM `{?_MYSQL_PREFIX?}_surfbar_urls` AS u WHERE - u.url_userid=%s AND - u.url_status != 'DELETED' + u.`url_userid`=%s AND + u.`url_status` != 'DELETED' ORDER BY u.url_id ASC", array(getMemberId()), __FUNCTION__, __LINE__); // Are there entries? - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Load all rows while ($row = SQL_FETCHARRAY($result)) { // Add the row - $urlArray[$row['id']] = $row; + $urlArray[$row['url_id']] = $row; } // END - while } // END - if @@ -1538,15 +1615,15 @@ function SURFBAR_GET_ARRAY_FROM_STATUS ($status) { $returnArray = array(); // Get all assigned actions - $result = SQL_QUERY_ESC("SELECT `action` FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `actions_status`='%s' ORDER BY `actions_id` ASC", + $result = SQL_QUERY_ESC("SELECT `actions_action` FROM `{?_MYSQL_PREFIX?}_surfbar_actions` WHERE `actions_status`='%s' ORDER BY `actions_id` ASC", array($status), __FUNCTION__, __LINE__); // Some entries there? - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Load all actions // @TODO This can be somehow rewritten while ($content = SQL_FETCHARRAY($result)) { - $returnArray[] = $content['action']; + $returnArray[] = $content['actions_action']; } // END - if } // END - if @@ -1560,6 +1637,7 @@ function SURFBAR_GET_ARRAY_FROM_STATUS ($status) { // Reload to configured stop page function SURFBAR_RELOAD_TO_STOP_PAGE ($page = 'stop') { // Internal or external? + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'page=' . $page . ' - ENTERED!'); if ((getConfig('surfbar_pause_mode') == 'INTERNAL') || (getConfig('surfbar_pause_url') == '')) { // Reload to internal page redirectToUrl('surfbar.php?frame=' . $page); @@ -1570,8 +1648,9 @@ function SURFBAR_RELOAD_TO_STOP_PAGE ($page = 'stop') { } // Determine next id for surfbar or get data for given id, always call this before you call other -// getters below this function!!! +// getters below this function! function SURFBAR_DETERMINE_NEXT_ID ($urlId = '0') { + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ' - ENTERED!'); // Default is no id and no random number $nextId = '0'; $randNum = '0'; @@ -1585,7 +1664,7 @@ function SURFBAR_DETERMINE_NEXT_ID ($urlId = '0') { $add = ''; if (count($USE) > 0) { // Ignore some! - $add = " AND sbu.url_id NOT IN ("; + $add = " AND sbu.`url_id` NOT IN ("; foreach ($USE as $url_id => $lid) { // Add URL id $add .= $url_id.','; @@ -1608,7 +1687,7 @@ function SURFBAR_DETERMINE_NEXT_ID ($urlId = '0') { } // END - if // And query the database - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'randNum='.$randNum.',maxRand='.$maxRand.',surfLock='.SURFBAR_GET_SURF_LOCK().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'randNum='.$randNum.',maxRand='.$maxRand.',surfLock='.SURFBAR_GET_SURF_LOCK()); $result = SQL_QUERY_ESC("SELECT sbu.url_id, sbu.url_userid, @@ -1630,12 +1709,12 @@ LEFT JOIN ON sbu.url_id=l.locks_url_id WHERE - sbu.url_userid NOT IN (".implode(',', $userids['url_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." GROUP BY - sbu.url_id + sbu.`url_id` ORDER BY l.locks_last_surfed ASC, sbu.url_id ASC @@ -1675,12 +1754,12 @@ LIMIT 1", } // Is there an id number? - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'lastQuery='.getConfig('db_last_query').'|numRows='.SQL_NUMROWS($result).'|Affected='.SQL_AFFECTEDROWS()); if (SQL_NUMROWS($result) == 1) { // Load/cache data - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'count('.count($GLOBALS['surfbar_cache']).') - BEFORE', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'count('.count($GLOBALS['surfbar_cache']).') - BEFORE', false); $GLOBALS['surfbar_cache'] = merge_array($GLOBALS['surfbar_cache'], SQL_FETCHARRAY($result)); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'count('.count($GLOBALS['surfbar_cache']).') - AFTER', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'count('.count($GLOBALS['surfbar_cache']).') - AFTER', false); // Determine waiting time $GLOBALS['surfbar_cache']['time'] = SURFBAR_DETERMINE_WAIT_TIME(); @@ -1688,28 +1767,28 @@ LIMIT 1", // Is the last salt there? if (is_null($GLOBALS['surfbar_cache']['salts_last_salt'])) { // Then repair it wit the static! - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'last_salt - FIXED!', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'last_salt - FIXED!', false); $GLOBALS['surfbar_cache']['salts_last_salt'] = ''; } // END - if // Fix missing last_surfed if ((!isset($GLOBALS['surfbar_cache']['last_surfed'])) || (is_null($GLOBALS['surfbar_cache']['last_surfed']))) { // Fix it here - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'last_surfed - FIXED!', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'last_surfed - FIXED!', false); $GLOBALS['surfbar_cache']['last_surfed'] = '0'; } // END - if // Get base/fixed reward and costs $GLOBALS['surfbar_cache']['reward'] = SURFBAR_DETERMINE_REWARD(); $GLOBALS['surfbar_cache']['costs'] = SURFBAR_DETERMINE_COSTS(); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'BASE/STATIC - reward='.SURFBAR_GET_REWARD().'|costs='.SURFBAR_GET_COSTS().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'BASE/STATIC - reward='.SURFBAR_GET_REWARD().'|costs='.SURFBAR_GET_COSTS()); // Only in dynamic model add the dynamic bonus! - if (getConfig('surfbar_pay_model') == 'DYNAMIC') { + if (getSurfbarPaymentModel() == 'DYNAMIC') { // Calculate dynamic reward/costs and add it $GLOBALS['surfbar_cache']['reward'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); $GLOBALS['surfbar_cache']['costs'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'DYNAMIC+ - reward='.SURFBAR_GET_REWARD().'|costs='.SURFBAR_GET_COSTS().'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'DYNAMIC+ - reward='.SURFBAR_GET_REWARD().'|costs='.SURFBAR_GET_COSTS()); } // END - if // Now get the id @@ -1720,14 +1799,78 @@ LIMIT 1", SQL_FREERESULT($result); // Return result - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'nextId='.$nextId.'', false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',nextId=' . $nextId . ' - EXIT!'); return $nextId; } -// ----------------------------------------------------------------------------- +//----------------------------------------------------------------------------- +// Wrapper function +//----------------------------------------------------------------------------- + +// "Getter" for surfbar_dynamic_percent +function getSurfbarDynamicPercent () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('surfbar_dynamic_percent'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// "Getter" for surfbar_static_reward +function getSurfbarStaticReward () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('surfbar_static_reward'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// "Getter" for surfbar_static_time +function getSurfbarStaticTime () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('surfbar_static_time'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// "Getter" for surfbar_max_order +function getSurfbarMaxOrder () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('surfbar_max_order'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// "Getter" for surfbar_payment_model +function getSurfbarPaymentModel () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('surfbar_payment_model'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +//------------------------------------------------------------------------------ // PLEASE DO NOT ADD ANY OTHER FUNCTIONS BELOW THIS LINE IF THEY DON'T "WRAP" // THE $GLOBALS['surfbar_cache'] ARRAY! -// ----------------------------------------------------------------------------- +//------------------------------------------------------------------------------ // Initializes the surfbar function SURFBAR_INIT () { @@ -1737,10 +1880,10 @@ function SURFBAR_INIT () { // Private getter for data elements function SURFBAR_GET_DATA ($element) { - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, "element={$element}", false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'element=' . $element . ' - ENTERED!'); // Default is null - $data = null; + $data = NULL; // Is the entry there? if (isset($GLOBALS['surfbar_cache'][$element])) { @@ -1754,7 +1897,7 @@ function SURFBAR_GET_DATA ($element) { } // Return result - //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'element[' . $element . ']=[' . gettype($data) . ']' . $data, false); + /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'element[' . $element . ']=[' . gettype($data) . ']' . $data . ' - EXIT!'); return $data; } @@ -1836,5 +1979,11 @@ function SURFBAR_GET_NEW_STATUS () { return SURFBAR_GET_DATA('new_status'); } +// Getter for last salt +function SURFBAR_GET_LAST_SALT () { + // Get data element and return its contents + return SURFBAR_GET_DATA('salts_last_salt'); +} + // [EOF] ?>