X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsurfbar_functions.php;h=932259cc4087a93641850e22ff85c106936f8a77;hp=c183e5e0aafac1610bae4db28a06d7794ffc80c8;hb=f928ad2bed60fa256d0641eaf6d2c027a2944688;hpb=8b71e1e79133cd3148fd66ed319920cf58d4360b diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php index c183e5e0aa..932259cc40 100644 --- a/inc/libs/surfbar_functions.php +++ b/inc/libs/surfbar_functions.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Funktionen fuer die Surfbar * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $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 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -33,7 +38,7 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } @@ -42,35 +47,45 @@ if (!defined('__SECURITY')) { // ----------------------------------------------------------------------------- // // Admin has added an URL with given user id and so on -function SURFBAR_ADMIN_ADD_URL ($url, $limit) { +function SURFBAR_ADMIN_ADD_URL ($url, $limit, $reload) { // Do some pre-checks if (!IS_ADMIN()) { // Not an admin + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Not admin.", $url, $limit, $reload)); return false; - } elseif (!VALIDATE_URL($url)) { + } elseif (!isUrlValid($url)) { // URL invalid + DEBUG_LOG(__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")) { + } elseif (SURFBAR_LOOKUP_BY_URL($url, '0')) { // URL already found in surfbar! + DEBUG_LOG(__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! + DEBUG_LOG(__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 + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Invalid limit entered.", $url, $limit, $reload)); return false; - } elseif ("".($limit + 0)."" != "".$limit."") { + } elseif ('' . ($reload + 0) . '' != '' . $reload . '') { // Invalid amount entered + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Cannot add URL=%s,limit=%s,reload=%s : Invalid reload entered.", $url, $limit, $reload)); return false; } // Register the new URL - return SURFBAR_REGISTER_URL($url, "0", "ACTIVE", "unlock", $limit); + return SURFBAR_REGISTER_URL($url, '0', 'ACTIVE', 'unlock', array('limit' => $limit, 'reload' => $reload)); } + // Admin unlocked an email so we can migrate the URL function SURFBAR_ADMIN_MIGRATE_URL ($url, $uid) { // Do some pre-checks if (!IS_ADMIN()) { // Not an admin return false; - } elseif (!VALIDATE_URL($url)) { + } elseif (!isUrlValid($url)) { // URL invalid return false; } elseif (SURFBAR_LOOKUP_BY_URL($url, $uid)) { @@ -82,8 +97,9 @@ function SURFBAR_ADMIN_MIGRATE_URL ($url, $uid) { } // Register the new URL - return SURFBAR_REGISTER_URL($url, $uid, "MIGRATED", "migrate"); + return SURFBAR_REGISTER_URL($url, $uid, 'MIGRATED', 'migrate'); } + // Admin function for unlocking URLs function SURFBAR_ADMIN_UNLOCK_URL_IDS ($IDs) { // Is this an admin or invalid array? @@ -104,12 +120,13 @@ function SURFBAR_ADMIN_UNLOCK_URL_IDS ($IDs) { // Update the status for all ids foreach ($IDs as $id => $dummy) { // Test all ids through (ignores failed) - $done = (($done) && (SURFBAR_CHANGE_STATUS($id, "PENDING", "ACTIVE"))); + $done = (($done) && (SURFBAR_CHANGE_STATUS($id, 'PENDING', 'ACTIVE'))); } // END - if // Return total status return $done; } + // Admin function for rejecting URLs function SURFBAR_ADMIN_REJECT_URL_IDS ($IDs) { // Is this an admin or invalid array? @@ -130,12 +147,13 @@ function SURFBAR_ADMIN_REJECT_URL_IDS ($IDs) { // Update the status for all ids foreach ($IDs as $id => $dummy) { // Test all ids through (ignores failed) - $done = (($done) && (SURFBAR_CHANGE_STATUS($id, "PENDING", "REJECTED"))); + $done = (($done) && (SURFBAR_CHANGE_STATUS($id, 'PENDING', 'REJECTED'))); } // END - if // Return total status return $done; } + // // ----------------------------------------------------------------------------- // Member functions @@ -143,33 +161,32 @@ function SURFBAR_ADMIN_REJECT_URL_IDS ($IDs) { // // Member has added an URL function SURFBAR_MEMBER_ADD_URL ($url, $limit) { - global $_CONFIG; - // Do some pre-checks if (!IS_MEMBER()) { // Not a member return false; - } elseif (!VALIDATE_URL($url)) { + } elseif ((!isUrlValid($url)) && (!IS_ADMIN())) { // URL invalid return false; - } elseif (SURFBAR_LOOKUP_BY_URL($url, $GLOBALS['userid'])) { + } elseif (SURFBAR_LOOKUP_BY_URL($url, getUserId())) { // URL already found in surfbar! return false; - } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS($GLOBALS['userid'])) { + } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS(getUserId())) { // No more allowed! return false; - } elseif ("".($limit + 0)."" != "".$limit."") { + } elseif (''.($limit + 0).'' != ''.$limit.'') { // Invalid amount entered return false; } // Register the new URL - return SURFBAR_REGISTER_URL($url, $GLOBALS['userid'], "PENDING", "reg", $limit); + return SURFBAR_REGISTER_URL($url, getUserId(), 'PENDING', 'reg', array('limit' => $limit)); } + // Create list of actions depending on status for the user function SURFBAR_MEMBER_ACTIONS ($urlId, $status) { // Load all actions in an array for given status - $actionArray = SURFBAR_GET_ACTION_ARRAY($status); + $actionArray = SURFBAR_getModeAction_ARRAY($status); // Init HTML code $OUT = " @@ -179,21 +196,15 @@ function SURFBAR_MEMBER_ACTIONS ($urlId, $status) { $width = round(100 / count($actionArray)); // "Walk" through all actions and create forms - foreach ($actionArray as $actionId=>$action) { + foreach ($actionArray as $actionId => $action) { // Add form for this action - $OUT .= sprintf(" \n", - $width, - bigintval($urlId), - strtolower($action), - strtoupper($action), - strtoupper($action) - ); + $OUT .= LOAD_TEMPLATE('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--}', + )); } // END - foreach // Close table @@ -203,10 +214,9 @@ function SURFBAR_MEMBER_ACTIONS ($urlId, $status) { // Return code return $OUT; } + // Do the member form request function SURFBAR_MEMBER_DO_FORM ($formData, $URLs) { - global $SURFBAR_CACHE; - // By default no action is performed $performed = false; @@ -240,29 +250,28 @@ function SURFBAR_MEMBER_DO_FORM ($formData, $URLs) { // Is the function there? if (function_exists($functionName)) { // Add new status - $URLs[$formData['id']]['new_status'] = $SURFBAR_CACHE['new_status']; + $URLs[$formData['id']]['new_status'] = SURFBAR_GET_NEW_STATUS('new_status'); // Extract URL data for call-back - $urlData = array(array_merge($URLs[$formData['id']], array($action => $formData))); + $urlData = array(merge_array($URLs[$formData['id']], array($action => $formData))); // Action found so execute it $performed = call_user_func_array($functionName, $urlData); } else { // Log invalid request - DEBUG_LOG(__FUNCTION__, __LINE__, " action={$formData['action']},id={$formData['id']},function={$functionName}"); - ADD_FATAL(sprintf("Invalid member action! action=%s,id=%s,function=%s", $formData['action'], $formData['id'], $functionName)); + DEBUG_LOG(__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)); } // Return status return $performed; } + // Validate if the requested action can be performed on current URL status function SURFBAR_VALIDATE_MEMBER_ACTION_STATUS ($action, $status) { - global $SURFBAR_CACHE; - // 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), __FILE__, __LINE__); + $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__); // Is the entry there? $isValid = (SQL_NUMROWS($result) == 1); @@ -270,7 +279,7 @@ function SURFBAR_VALIDATE_MEMBER_ACTION_STATUS ($action, $status) { // Fetch the new status if found if ($isValid) { // Load new status - list($SURFBAR_CACHE['new_status']) = SQL_FETCHROW($result); + list($GLOBALS['surfbar_cache']['new_status']) = SQL_FETCHROW($result); } // END - if // Free result @@ -279,6 +288,7 @@ function SURFBAR_VALIDATE_MEMBER_ACTION_STATUS ($action, $status) { // Return status return $isValid; } + // // ----------------------------------------------------------------------------- // Member actions @@ -288,70 +298,98 @@ function SURFBAR_VALIDATE_MEMBER_ACTION_STATUS ($action, $status) { function SURFBAR_MEMBER_RETREAT_ACTION ($urlData) { // Create the data array for next function call $data = array( - $urlData['id'] => $urlData + $urlData['id'] => $urlData ); // Simply change the status here return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['status'], $urlData['new_status'], $data); } + // Book an URL now (from migration) 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 return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['status'], $urlData['new_status'], $data); } + // Show edit form or do the changes function SURFBAR_MEMBER_EDIT_ACTION ($urlData) { // Is the "execute" flag there? if (isset($urlData['edit']['execute'])) { // Execute the changes - return SURFBAR_MEMBER_EXECUTE_ACTION("edit", $urlData); + return SURFBAR_MEMBER_EXECUTE_ACTION('edit', $urlData); } // END - if // Display form - return SURFBAR_MEMBER_DISPLAY_ACTION_FORM("edit", $urlData); + return SURFBAR_MEMBER_DISPLAY_ACTION_FORM('edit', $urlData); } + // Show delete form or do the changes function SURFBAR_MEMBER_DELETE_ACTION ($urlData) { // Is the "execute" flag there? if (isset($urlData['delete']['execute'])) { // Execute the changes - return SURFBAR_MEMBER_EXECUTE_ACTION("delete", $urlData); + return SURFBAR_MEMBER_EXECUTE_ACTION('delete', $urlData); } // END - if // Display form - return SURFBAR_MEMBER_DISPLAY_ACTION_FORM("delete", $urlData); + return SURFBAR_MEMBER_DISPLAY_ACTION_FORM('delete', $urlData); +} + +// Pause active banner +function SURFBAR_MEMBER_PAUSE_ACTION ($urlData) { + return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['status'], $urlData['new_status'], array($urlData['id'] => $urlData)); +} + +// Unpause stopped banner +function SURFBAR_MEMBER_UNPAUSE_ACTION ($urlData) { + // Fix missing entry for template + $urlData['edit'] = $urlData['unpause']; + $urlData['edit']['url'] = $urlData['url']; + $urlData['edit']['limit'] = $urlData['views_max']; + + // Return status change + return SURFBAR_CHANGE_STATUS($urlData['id'], $urlData['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)); } + // Display selected "action form" function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) { // Translate some data - $urlData['registered'] = MAKE_DATETIME($urlData['registered'], "2"); - $urlData['views_total'] = TRANSLATE_COMMA($urlData['views_total']); - $urlData['views_max'] = TRANSLATE_COMMA($urlData['views_max']); - $urlData['views_allowed'] = TRANSLATE_COMMA($urlData['views_allowed']); - $urlData['last_locked'] = MAKE_DATETIME($urlData['last_locked'], "2"); + $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'); // Is the lock reason empty? if (empty($urlData['lock_reason'])) { // Fix it to three dashes - $urlData['lock_reason'] = "---"; + $urlData['lock_reason'] = '---'; } // END - if - // Default is not limited - $urlData['limited_yes'] = ""; - $urlData['limited_no'] = " checked=\"checked\""; - $urlData['limited'] = "false"; - - // Is this URL limited? - if ($urlData['views_max'] > 0) { - // Then rewrite form data - $urlData['limited_yes'] = " checked=\"checked\""; - $urlData['limited_no'] = ""; - $urlData['limited'] = "true"; + // Include fields only for action 'edit' + if ($action == 'edit') { + // Default is not limited + $urlData['limited_yes'] = ''; + $urlData['limited_no'] = ' checked="checked"'; + $urlData['limited'] = 'false'; + + // Is this URL limited? + if ($urlData['views_max'] > 0) { + // Then rewrite form data + $urlData['limited_yes'] = ' checked="checked"'; + $urlData['limited_no'] = ''; + $urlData['limited'] = 'true'; + } // END - if } // END - if // Load the form and display it @@ -360,13 +398,14 @@ function SURFBAR_MEMBER_DISPLAY_ACTION_FORM ($action, $urlData) { // All fine by default ... ;-) return true; } + // Execute choosen action function SURFBAR_MEMBER_EXECUTE_ACTION ($action, $urlData) { // By default nothing is executed $executed = false; // Is limitation "no" and "limit" is > 0? - if ((isset($urlData[$action]['limited'])) && ($urlData[$action]['limited'] == "N") && ((isset($urlData[$action]['limit'])) && ($urlData[$action]['limit'] > 0)) || (!isset($urlData[$action]['limit']))) { + if ((isset($urlData[$action]['limited'])) && ($urlData[$action]['limited'] == 'N') && ((isset($urlData[$action]['limit'])) && ($urlData[$action]['limit'] > 0)) || (!isset($urlData[$action]['limit']))) { // Set it to unlimited $urlData[$action]['limit'] = 0; } // END - if @@ -389,7 +428,7 @@ function SURFBAR_MEMBER_EXECUTE_ACTION ($action, $urlData) { } // END - if } else { // Not found! - ADD_FATAL(sprintf(MEMBER_SURFBAR_EXECUTE_ACTION_404, $functionName)); + addFatalMessage(__FUNCTION__, __LINE__, getMessage('MEMBER_SURFBAR_EXECUTE_ACTION_404'), $functionName); } // Return status @@ -397,33 +436,31 @@ function SURFBAR_MEMBER_EXECUTE_ACTION ($action, $urlData) { } // "Execute edit" function: Update changed data function SURFBAR_MEMBER_EXECUTE_EDIT_ACTION ($urlData) { + // Default is nothing done + $status = false; + // Translate URLs for testing $url1 = COMPILE_CODE($urlData['url']); $url2 = COMPILE_CODE($urlData['edit']['url']); // Has the URL or limit changed? - if (($urlData['views_allowed'] != $urlData['edit']['limit']) || ($url1 != $url2)) { + if (true) { + //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']), __FILE__, __LINE__); - - // Prepare new data - $urlData['new_url'] = $urlData['edit']['url']; - $urlData['new_limit'] = $urlData['edit']['limit']; - unset($urlData['edit']); - - // Send admin notification - SURFBAR_NOTIFY_ADMIN("url_edited", $urlData); - - // Send user notification - SURFBAR_NOTIFY_USER("url_edited", $urlData); + 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__); // All fine - return true; + $status = true; } - // Not updated - return false; + // Return status + return $status; +} +// "Execute delete" function: Does nothing... +function SURFBAR_MEMBER_EXECUTE_DELETE_ACTION ($urlData) { + // Nothing special to do (see above function for such "special actions" to perform) + return true; } // // ----------------------------------------------------------------------------- @@ -441,7 +478,7 @@ function SURFBAR_HANDLE_SELF_MAINTENANCE () { // Handle URLs which limit has depleted function SURFBAR_HANDLE_DEPLETED_VIEWS () { // Get all URLs - $urlArray = SURFBAR_GET_URL_DATA("0", "views_max", "id", "ASC", "id", " AND views_allowed>0 AND status='ACTIVE'"); + $urlArray = SURFBAR_GET_URL_DATA('0', 'views_max', 'id', 'ASC', 'id', " AND views_allowed>0 AND `status`='ACTIVE'"); // Do we have some entries? if (count($urlArray) > 0) { @@ -454,90 +491,90 @@ function SURFBAR_HANDLE_DEPLETED_VIEWS () { $urlData[$id] = $data; // Handle the status - SURFBAR_CHANGE_STATUS($id, "ACTIVE", "DEPLETED", $urlData); + SURFBAR_CHANGE_STATUS($id, 'ACTIVE', 'DEPLETED', $urlData); } // END - foreach } // END - if } + // Alert users which have URLs booked and are low on points amount function SURFBAR_HANDLE_LOW_POINTS () { - global $_CONFIG; - // Get all userids - $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS($_CONFIG['surfbar_warn_low_points']); + $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS(getConfig('surfbar_warn_low_points')); // "Walk" through all URLs foreach ($UIDs['uid'] as $uid => $dummy) { // Is the last notification far enougth away to notify again? - if ((time() - $UIDs['notified'][$uid]) >= $_CONFIG['surfbar_low_interval']) { + if ((time() - $UIDs['notified'][$uid]) >= getConfig('surfbar_low_interval')) { // Prepare content $content = array( 'uid' => $uid, - 'low' => TRANSLATE_COMMA($_CONFIG['surfbar_warn_low_points']), - 'points' => TRANSLATE_COMMA($UIDs['points'][$uid]), - 'notified' => MAKE_DATETIME($UIDs['notified'][$uid]), - 'interval' => CREATE_FANCY_TIME($_CONFIG['surfbar_low_interval']) + 'low' => translateComma(getConfig('surfbar_warn_low_points')), + 'points' => translateComma($UIDs['points'][$uid]), + 'notified' => generateDateTime($UIDs['notified'][$uid]), + 'interval' => createFancyTime(getConfig('surfbar_low_interval')) ); // Notify this user - SURFBAR_NOTIFY_USER("low_points", $content); + SURFBAR_NOTIFY_USER('low_points', $content); // Update last notified - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET surfbar_low_notified=NOW() WHERE userid=%s LIMIT 1", - array($uid), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET surfbar_low_notified=NOW() WHERE `userid`=%s LIMIT 1", + array($uid), __FUNCTION__, __LINE__); } // END - if } // END - foreach } + // // ----------------------------------------------------------------------------- // Generic functions // ----------------------------------------------------------------------------- // + // Looks up by an URL function SURFBAR_LOOKUP_BY_URL ($url, $uid) { // Now lookup that given URL by itself - $urlArray = SURFBAR_GET_URL_DATA($url, "url", "id", "ASC", "id", sprintf(" AND userid=%s", bigintval($uid))); + $urlArray = SURFBAR_GET_URL_DATA($url, 'url', 'id', 'ASC', 'id', sprintf(" AND `userid`=%s", bigintval($uid))); // Was it found? return (count($urlArray) > 0); } -// Load URL data by given search term and column -function SURFBAR_GET_URL_DATA ($searchTerm, $column="id", $order="id", $sort="ASC", $group="id", $add="") { - global $lastUrlData; +// Load URL data by given search term and column +function SURFBAR_GET_URL_DATA ($searchTerm, $column = 'id', $order = 'id', $sort = 'ASC', $group = 'id', $add = '') { // By default nothing is found - $lastUrlData = array(); + $GLOBALS['last_url_data'] = array(); // Is the column an id number? - if (($column == "id") || ($column == "userid")) { + if (($column == 'id') || ($column == 'userid')) { // Extra secure input $searchTerm = bigintval($searchTerm); } // END - if - // If the column is "id" there can be only one entry - $limit = ""; - if ($column == "id") { + // If the column is 'id' there can be only one entry + $limit = ''; + if ($column == 'id') { $limit = "LIMIT 1"; } // 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 -FROM "._MYSQL_PREFIX."_surfbar_urls + $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 %s", - array($column, $searchTerm, $order, $sort, $limit), __FILE__, __LINE__); + array($column, $searchTerm, $order, $sort, $limit), __FUNCTION__, __LINE__); // Is there at least one record? if (SQL_NUMROWS($result) > 0) { // Then load all! while ($dataRow = SQL_FETCHARRAY($result)) { // Shall we group these results? - if ($group == "id") { + if ($group == 'id') { // Add the row by id as index - $lastUrlData[$dataRow['id']] = $dataRow; + $GLOBALS['last_url_data'][$dataRow['id']] = $dataRow; } else { // Group entries - $lastUrlData[$dataRow[$group]][$dataRow['id']] = $dataRow; + $GLOBALS['last_url_data'][$dataRow[$group]][$dataRow['id']] = $dataRow; } } // END - while } // END - if @@ -546,23 +583,31 @@ ORDER BY %s %s SQL_FREERESULT($result); // Return the result - return $lastUrlData; + return $GLOBALS['last_url_data']; } -// Registers an URL with the surfbar. You should have called SURFBAR_LOOKUP_BY_URL() first! -function SURFBAR_REGISTER_URL ($url, $uid, $status="PENDING", $addMode="reg", $limit=0) { - global $_CONFIG; +// Registers an URL with the surfbar. You should have called SURFBAR_LOOKUP_BY_URL() first! +function SURFBAR_REGISTER_URL ($url, $uid, $status = 'PENDING', $addMode = 'reg', $extraFields = array()) { // Make sure by the user registered URLs are always pending - if ($addMode == "reg") $status = "PENDING"; + if ($addMode == 'reg') { + $status = 'PENDING'; + } // END - if // Prepare content - $content = array( + $content = merge_array($extraFields, array( 'url' => $url, 'frametester' => FRAMETESTER($url), 'uid' => $uid, 'status' => $status, - 'limit' => $limit - ); + )); + + // Is limit/reload set? + if (!isset($config['limit'])) { + $content['limit'] = 0; + } // END - if + if (!isset($config['reload'])) { + $content['reload'] = 0; + } // END - if // Insert the URL into database $content['insert_id'] = SURFBAR_INSERT_URL_BY_ARRAY($content); @@ -574,10 +619,10 @@ function SURFBAR_REGISTER_URL ($url, $uid, $status="PENDING", $addMode="reg", $l } // END - if // Translate status and limit - $content['limit'] = SURFBAR_TRANSLATE_LIMIT($content['limit']); + $content['limit'] = surfbarTranslateLimit($content['limit']); // If in reg-mode we notify admin - if (($addMode == "reg") || ($_CONFIG['surfbar_notify_admin_unlock'] == "Y")) { + if (($addMode == 'reg') || (getConfig('surfbar_notify_admin_unlock') == 'Y')) { // Notify admin even when he as unlocked an email SURFBAR_NOTIFY_ADMIN("url_{$addMode}", $content); } // END - if @@ -588,6 +633,7 @@ function SURFBAR_REGISTER_URL ($url, $uid, $status="PENDING", $addMode="reg", $l // Return the insert id return $content['insert_id']; } + // Inserts an url by given data array and return the insert id function SURFBAR_INSERT_URL_BY_ARRAY ($urlData) { // Get userid @@ -597,50 +643,49 @@ function SURFBAR_INSERT_URL_BY_ARRAY ($urlData) { if (empty($uid)) $uid = 0; // Just run the insert query for now - SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_surfbar_urls (userid,url,status,views_max,views_allowed) VALUES (%s,'%s','%s',%s,%s)", - array( - $uid, - $urlData['url'], - $urlData['status'], - $urlData['limit'], - $urlData['limit'] - ), __FILE__, __LINE__ + 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( + $uid, + $urlData['url'], + $urlData['status'], + $urlData['limit'], + $urlData['limit'], + $urlData['reload'] + ), __FUNCTION__, __LINE__ ); // Return insert id return SQL_INSERTID(); } + // Notify admin(s) with a selected message and content function SURFBAR_NOTIFY_ADMIN ($messageType, $content) { // Prepare template name $templateName = sprintf("admin_surfbar_%s", $messageType); - // Set default subject if following eval() wents wrong - $subject = ADMIN_SURFBAR_NOTIFY_DEFAULT_SUBJECT; - - // Create constant name - $constantName = sprintf("ADMIN_SURFBAR_NOTIFY_%s_SUBJECT", - strtoupper($messageType) - ); - // Prepare subject - if (defined($constantName)) { - $subject = constant($constantName); - } else { - ADD_FATAL(ADMIN_SURFBAR_NOTIFY_SUBJECT_404, $constantName); - } + $subject = getMessage(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 = getMessage('ADMIN_SURFBAR_NOTIFY_DEFAULT_SUBJECT'); + } // END - if // Translate some data if present - if (isset($content['status'])) $content['status'] = SURFBAR_TRANSLATE_STATUS($content['status']); - if (isset($content['registered'])) $content['registered'] = MAKE_DATETIME($content['registered'], "2"); - if (isset($content['last_locked'])) $content['last_locked'] = MAKE_DATETIME($content['last_locked'], "2"); - if (isset($content['views_total'])) $content['views_total'] = TRANSLATE_COMMA($content['views_total']); - if (isset($content['views_allowed'])) $content['views_allowed'] = TRANSLATE_COMMA($content['views_allowed']); - if (isset($content['views_max'])) $content['views_max'] = TRANSLATE_COMMA($content['views_max']); + if (isset($content['status'])) $content['status'] = surfbarTranslateUserStatus($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']); // Send the notification out - return SEND_ADMIN_NOTIFICATION($subject, $templateName, $content, $content['uid']); + return sendAdminNotification($subject, $templateName, $content, $content['uid']); } + // Notify the user about the performed action function SURFBAR_NOTIFY_USER ($messageType, $content) { // Skip notification if userid is zero @@ -651,48 +696,54 @@ function SURFBAR_NOTIFY_USER ($messageType, $content) { // Prepare template name $templateName = sprintf("member_surfbar_%s", $messageType); - // Set default subject if following eval() wents wrong - $subject = MEMBER_SURFBAR_NOTIFY_DEFAULT_SUBJECT; - - // Create constant name - $constantName = sprintf("MEMBER_SURFBAR_NOTIFY_%s_SUBJECT", - strtoupper($messageType) - ); - // Prepare subject - if (defined($constantName)) { - $subject = constant($constantName); - } else { - ADD_FATAL(MEMBER_SURFBAR_NOTIFY_SUBJECT_404, $constantName); - } + $subject = getMessage(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'); + } // END - if + + // Translate some data if present + if (isset($content['status'])) $content['status'] = surfbarTranslateUserStatus($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']); // Load template $mailText = LOAD_EMAIL_TEMPLATE($templateName, $content, $content['uid']); // Send the email - return SEND_EMAIL($content['uid'], $subject, $mailText); + return sendEmail($content['uid'], $subject, $mailText); } + // Translates the limit -function SURFBAR_TRANSLATE_LIMIT ($limit) { +function surfbarTranslateLimit ($limit) { // Is this zero? if ($limit == 0) { // Unlimited! - $return = MEMBER_SURFBAR_UNLIMITED_VIEWS; + $return = getMessage('MEMBER_SURFBAR_UNLIMITED_VIEWS'); } else { // Translate comma - $return = TRANSLATE_COMMA($limit); + $return = translateComma($limit); } // Return value return $return; } + // Translate the URL status -function SURFBAR_TRANSLATE_STATUS ($status) { +function surfbarTranslateUserStatus ($status) { // Create constant name $constantName = sprintf("SURFBAR_URL_STATUS_%s", strtoupper($status)); // Set default translated status - $statusTranslated = "!".$constantName."!"; + $statusTranslated = '!'.$constantName.'!'; // Is the constant there? if (defined($constantName)) { @@ -703,15 +754,14 @@ function SURFBAR_TRANSLATE_STATUS ($status) { // Return result return $statusTranslated; } + // Determine reward function SURFBAR_DETERMINE_REWARD ($onlyMin=false) { - global $_CONFIG; - // Static values are default - $reward = $_CONFIG['surfbar_static_reward']; + $reward = getConfig('surfbar_static_reward'); // Do we have static or dynamic? - if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { + if (getConfig('surfbar_pay_model') == 'DYNAMIC') { // "Calculate" dynamic reward if ($onlyMin) { $reward += SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); @@ -723,15 +773,14 @@ function SURFBAR_DETERMINE_REWARD ($onlyMin=false) { // Return reward return $reward; } + // Determine costs function SURFBAR_DETERMINE_COSTS ($onlyMin=false) { - global $_CONFIG; - // Static costs is default - $costs = $_CONFIG['surfbar_static_costs']; + $costs = getConfig('surfbar_static_costs'); // Do we have static or dynamic? - if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { + if (getConfig('surfbar_pay_model') == 'DYNAMIC') { // "Calculate" dynamic costs if ($onlyMin) { $costs += SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); @@ -743,6 +792,7 @@ function SURFBAR_DETERMINE_COSTS ($onlyMin=false) { // Return costs return $costs; } + // "Calculate" dynamic add function SURFBAR_CALCULATE_DYNAMIC_ADD () { // Get min/max values @@ -752,54 +802,62 @@ function SURFBAR_CALCULATE_DYNAMIC_ADD () { // "Calculate" dynamic part and return it return mt_rand($min, $max); } + // Determine right template name function SURFBAR_DETERMINE_TEMPLATE_NAME() { // Default is the frameset $templateName = "surfbar_frameset"; // Any frame set? ;-) - if (isset($_GET['frame'])) { + if (REQUEST_ISSET_GET('frame')) { // Use the frame as a template name part... ;-) $templateName = sprintf("surfbar_frame_%s", - SQL_ESCAPE($_GET['frame']) + REQUEST_GET('frame') ); } // END - if // Return result return $templateName; } + // 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() { - global $SURFBAR_CACHE, $_CONFIG; - // Default is full! $isFull = true; // Cache static reload lock - $SURFBAR_CACHE['surf_lock'] = $_CONFIG['surfbar_static_lock']; - //DEBUG_LOG(__FUNCTION__, __LINE__, "Fixed surf lock is ".$_CONFIG['surfbar_static_lock']."", false); + $GLOBALS['surfbar_cache']['surf_lock'] = getConfig('surfbar_static_lock'); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "Fixed surf lock is ".getConfig('surfbar_static_lock')."", false); // Do we have dynamic model? - if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { + if (getConfig('surfbar_pay_model') == 'DYNAMIC') { // "Calculate" dynamic lock - $SURFBAR_CACHE['surf_lock'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); + $GLOBALS['surfbar_cache']['surf_lock'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); } // END - if // Ask the database - $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt FROM "._MYSQL_PREFIX."_surfbar_locks -WHERE userid=%s AND (UNIX_TIMESTAMP() - ".SURFBAR_GET_DATA('surf_lock').") < UNIX_TIMESTAMP(last_surfed) + $result = SQL_QUERY_ESC("SELECT + COUNT(l.id) AS cnt +FROM + `{!_MYSQL_PREFIX!}_surfbar_locks` AS l +INNER JOIN + `{!_MYSQL_PREFIX!}_surfbar_urls` AS u +ON + u.id=l.url_id +WHERE + l.userid=%s AND (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(l.last_surfed) AND (((UNIX_TIMESTAMP(l.last_surfed) - u.fixed_reload) < 0 AND u.fixed_reload > 0) OR u.fixed_reload = 0) LIMIT 1", - array($GLOBALS['userid']), __FILE__, __LINE__ + array(getUserId()), __FUNCTION__, __LINE__ ); // Fetch row - list($SURFBAR_CACHE['user_locks']) = SQL_FETCHROW($result); + list($GLOBALS['surfbar_cache']['user_locks']) = SQL_FETCHROW($result); // Is it null? - if (is_null($SURFBAR_CACHE['user_locks'])) { + if (is_null($GLOBALS['surfbar_cache']['user_locks'])) { // Then fix it to zero! - $SURFBAR_CACHE['user_locks'] = 0; + $GLOBALS['surfbar_cache']['user_locks'] = 0; } // END - if // Free result @@ -809,14 +867,15 @@ LIMIT 1", $total = SURFBAR_GET_TOTAL_URLS(); // Do we have some URLs in lock? Admins can always surf on own URLs! - //DEBUG_LOG(__FUNCTION__, __LINE__, "userLocks=".SURFBAR_GET_DATA('user_locks').",total={$total}", false); - $isFull = ((SURFBAR_GET_DATA('user_locks') == $total) && ($total > 0)); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "userLocks=".SURFBAR_GET_USER_LOCKS().",total={$total}", false); + $isFull = ((SURFBAR_GET_USER_LOCKS() == $total) && ($total > 0)); // Return result return $isFull; } + // Get total amount of URLs of given status for current user or of ACTIVE URLs by default -function SURFBAR_GET_TOTAL_URLS ($status="ACTIVE", $excludeUserId=0) { +function SURFBAR_GET_TOTAL_URLS ($status = 'ACTIVE', $excludeUserId = 0) { // Determine depleted user account $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS(); @@ -828,9 +887,9 @@ function SURFBAR_GET_TOTAL_URLS ($status="ACTIVE", $excludeUserId=0) { // Get amount from database $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt -FROM "._MYSQL_PREFIX."_surfbar_urls -WHERE userid NOT IN (".implode(",", $UIDs['uid']).") AND status='%s'", - array($status), __FILE__, __LINE__ +FROM `{!_MYSQL_PREFIX!}_surfbar_urls` +WHERE userid NOT IN (".implode(',', $UIDs['uid']).") AND `status`='%s'", + array($status), __FUNCTION__, __LINE__ ); // Fetch row @@ -842,91 +901,77 @@ WHERE userid NOT IN (".implode(",", $UIDs['uid']).") AND status='%s'", // Return result return $cnt; } + // Check wether the user is allowed to book more URLs function SURFBAR_IF_USER_BOOK_MORE_URLS ($uid=0) { - global $_CONFIG; - // Is this admin and userid is zero or does the user has some URLs left to book? - return ((($uid == 0) && (IS_ADMIN())) || (SURFBAR_GET_TOTAL_USER_URLS($uid, "", array("REJECTED")) < $_CONFIG['surfbar_max_order'])); + return ((($uid == 0) && (IS_ADMIN())) || (SURFBAR_GET_TOTAL_USER_URLS($uid, '', array("REJECTED")) < getConfig('surfbar_max_order'))); } -// Get total amount of URLs of given status for current user -function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="",$exclude="") { - global $_CONFIG; +// Get total amount of URLs of given status for current user +function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status = '',$exclude = '') { // Is the user 0 and user is logged in? if (($uid == 0) && (IS_MEMBER())) { // Then use this userid - $uid = $GLOBALS['userid']; + $uid = getUserId(); } elseif ($uid == 0) { // Error! - return ($_CONFIG['surfbar_max_order'] + 1); + return (getConfig('surfbar_max_order') + 1); } // Default is all URLs - $ADD = ""; + $add = ''; // Is the status set? if (is_array($status)) { // Only URLs with these status - $ADD = sprintf(" AND status IN('%s')", implode("','", $status)); + $add = sprintf(" AND `status` IN('%s')", implode("','", $status)); } elseif (!empty($status)) { // Only URLs with this status - $ADD = sprintf(" AND status='%s'", $status); + $add = sprintf(" AND `status`='%s'", $status); } elseif (is_array($exclude)) { // Exclude URLs with these status - $ADD = sprintf(" AND status NOT IN('%s')", implode("','", $exclude)); + $add = sprintf(" AND `status` NOT IN('%s')", implode("','", $exclude)); } elseif (!empty($exclude)) { // Exclude URLs with this status - $ADD = sprintf(" AND status != '%s'", $exclude); + $add = sprintf(" AND `status` != '%s'", $exclude); } // Get amount from database - $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt -FROM "._MYSQL_PREFIX."_surfbar_urls -WHERE userid=%s".$ADD." -LIMIT %s", - array($uid, $_CONFIG['surfbar_max_order']), __FILE__, __LINE__ - ); - - // Fetch row - list($cnt) = SQL_FETCHROW($result); - - // Free result - SQL_FREERESULT($result); + $cnt = GET_TOTAL_DATA($uid, 'surfbar_urls', 'id', 'userid', true, $add); // Return result return $cnt; } -// Generate a validation code for the given id number -function SURFBAR_GENERATE_VALIDATION_CODE ($urlId, $salt="") { - global $_CONFIG, $SURFBAR_CACHE; +// Generate a validation code for the given id number +function SURFBAR_GENERATE_VALIDATION_CODE ($urlId, $salt = '') { // @TODO Invalid salt should be refused - $SURFBAR_CACHE['salt'] = "INVALID"; + $GLOBALS['surfbar_cache']['salt'] = 'INVALID'; // Get code length from config - $length = $_CONFIG['code_length']; + $length = getConfig('code_length'); // Fix length to 10 if ($length == 0) $length = 10; // Generate a code until the length matches - $valCode = ""; + $valCode = ''; while (strlen($valCode) != $length) { // Is the salt set? if (empty($salt)) { // Generate random hashed string - $SURFBAR_CACHE['salt'] = sha1(GEN_PASS(255)); - //DEBUG_LOG(__FUNCTION__, __LINE__, "newSalt=".SURFBAR_GET_SALT()."", false); + $GLOBALS['surfbar_cache']['salt'] = sha1(generatePassword(mt_rand(200, 255))); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "newSalt=".SURFBAR_GET_SALT()."", false); } else { // Use this as salt! - $SURFBAR_CACHE['salt'] = $salt; - //DEBUG_LOG(__FUNCTION__, __LINE__, "oldSalt=".SURFBAR_GET_SALT()."", false); + $GLOBALS['surfbar_cache']['salt'] = $salt; + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "oldSalt=".SURFBAR_GET_SALT()."", false); } // ... and now the validation code - $valCode = GEN_RANDOM_CODE($length, sha1(SURFBAR_GET_SALT().":".$urlId), $GLOBALS['userid']); - //DEBUG_LOG(__FUNCTION__, __LINE__, "valCode={$valCode}", false); + $valCode = generateRandomCode($length, sha1(SURFBAR_GET_SALT().':'.$urlId), getUserId()); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "valCode={$valCode}", false); } // END - while // Hash it with md5() and salt it with the random string @@ -936,13 +981,12 @@ function SURFBAR_GENERATE_VALIDATION_CODE ($urlId, $salt="") { $valHashedCode = generatePassString($hashedCode); // Return hashed value - //DEBUG_LOG(__FUNCTION__, __LINE__, "finalValCode={$valHashedCode}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "finalValCode={$valHashedCode}", false); return $valHashedCode; } + // Check validation code function SURFBAR_CHECK_VALIDATION_CODE ($urlId, $check, $salt) { - global $SURFBAR_CACHE; - // Secure id number $urlId = bigintval($urlId); @@ -950,109 +994,115 @@ function SURFBAR_CHECK_VALIDATION_CODE ($urlId, $check, $salt) { $code = SURFBAR_GENERATE_VALIDATION_CODE($urlId, $salt); // Return result of checking hashes and salts - //DEBUG_LOG(__FUNCTION__, __LINE__, "---".$code."|".$check."---", false); - //DEBUG_LOG(__FUNCTION__, __LINE__, "+++".$salt."|".SURFBAR_GET_DATA('last_salt')."+++", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, '---'.$code.'|'.$check.'---', false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "+++".$salt.'|'.SURFBAR_GET_DATA('last_salt')."+++", false); return (($code == $check) && ($salt == SURFBAR_GET_DATA('last_salt'))); } + // Lockdown the userid/id combination (reload lock) function SURFBAR_LOCKDOWN_ID ($urlId) { - //* DEBUG: */ print "LOCK!"); + //* DEBUG: */ print "LOCK!"; ///* DEBUG: */ return; // Just add it to the database - SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_surfbar_locks (userid, url_id) VALUES (%s, %s)", - array($GLOBALS['userid'], bigintval($urlId)), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_surfbar_locks` (`userid`, `url_id`) VALUES (%s, %s)", + array(getUserId(), bigintval($urlId)), __FUNCTION__, __LINE__); // Remove the salt from database - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_surfbar_salts WHERE url_id=%s AND userid=%s LIMIT 1", - array(bigintval($urlId), $GLOBALS['userid']), __FILE__, __LINE__); + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_surfbar_salts` WHERE `url_id`=%s AND `userid`=%s LIMIT 1", + array(bigintval($urlId), getUserId()), __FUNCTION__, __LINE__); } -// Pay points to the user and remove it from the sender -function SURFBAR_PAY_POINTS ($urlId) { + +// 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_LOG(__FUNCTION__, __LINE__, "uid=".SURFBAR_GET_USERID().",costs=".SURFBAR_GET_COSTS()."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "uid=".SURFBAR_GET_USERID().",costs=".SURFBAR_GET_COSTS()."", false); if (SURFBAR_GET_USERID() > 0) { - SUB_POINTS("surfbar", SURFBAR_GET_USERID(), SURFBAR_GET_COSTS()); + SUB_POINTS(sprintf("surfbar_%s", getConfig('surfbar_pay_model')), SURFBAR_GET_USERID(), SURFBAR_GET_COSTS()); } // END - if // Book it to the user - //DEBUG_LOG(__FUNCTION__, __LINE__, "uid=".$GLOBALS['userid'].",reward=".SURFBAR_GET_REWARD()."", false); - ADD_POINTS_REFSYSTEM("surfbar", $GLOBALS['userid'], SURFBAR_GET_DATA('reward')); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "uid=".getUserId().",reward=".SURFBAR_GET_REWARD()."", false); + ADD_POINTS_REFSYSTEM(sprintf("surfbar_%s", getConfig('surfbar_pay_model')), getUserId(), SURFBAR_GET_DATA('reward')); } + // Updates the statistics of current URL/userid function SURFBAR_UPDATE_INSERT_STATS_RECORD () { - global $_CONFIG; - // Init add - $ADD = ""; + $add = ''; // Get allowed views - $allowed = SURFBAR_GET_ALLOWED_VIEWS(); + $allowed = SURFBAR_GET_VIEWS_ALLOWED(); // Do we have a limit? if ($allowed > 0) { // Then count views_max down! - $ADD .= ",views_max=views_max-1"; + $add .= ", `views_max`=`views_max`-1"; } // END - if // Update URL stats - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_surfbar_urls SET views_total=views_total+1".$ADD." WHERE id=%s LIMIT 1", - array(SURFBAR_GET_ID()), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_surfbar_urls` SET `views_total`=`views_total`+1".$add." WHERE `id`=%s LIMIT 1", + array(SURFBAR_GET_ID()), __FUNCTION__, __LINE__); // Update the stats entry - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_surfbar_stats SET count=count+1 WHERE userid=%s AND url_id=%s LIMIT 1", - array($GLOBALS['userid'], SURFBAR_GET_ID()), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_surfbar_stats` SET `count`=`count`+1 WHERE `userid`=%s AND `url_id`=%s LIMIT 1", + array(getUserId(), SURFBAR_GET_ID()), __FUNCTION__, __LINE__); // Was that update okay? if (SQL_AFFECTEDROWS() < 1) { // No, then insert entry - SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_surfbar_stats (userid,url_id,count) VALUES (%s,%s,1)", - array($GLOBALS['userid'], SURFBAR_GET_ID()), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_surfbar_stats` (userid,url_id,count) VALUES (%s,%s,1)", + array(getUserId(), SURFBAR_GET_ID()), __FUNCTION__, __LINE__); } // END - if // Update total/daily/weekly/monthly counter - $_CONFIG['surfbar_total_counter']++; - $_CONFIG['surfbar_daily_counter']++; - $_CONFIG['surfbar_weekly_counter']++; - $_CONFIG['surfbar_monthly_counter']++; + incrementConfigEntry('surfbar_total_counter'); + incrementConfigEntry('surfbar_daily_counter'); + incrementConfigEntry('surfbar_weekly_counter'); + incrementConfigEntry('surfbar_monthly_counter'); // Update config as well - UPDATE_CONFIG(array("surfbar_total_counter", "surfbar_daily_counter", "surfbar_weekly_counter", "surfbar_monthly_counter"), array(1,1,1,1), "+"); + updateConfiguration(array('surfbar_total_counter', 'surfbar_daily_counter', 'surfbar_weekly_counter', 'surfbar_monthly_counter'), array(1,1,1,1), '+'); } + // Update the salt for validation and statistics function SURFBAR_UPDATE_SALT_STATS () { // Update statistics record SURFBAR_UPDATE_INSERT_STATS_RECORD(); // Simply store the salt from cache away in database... - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_surfbar_salts SET last_salt='%s' WHERE url_id=%s AND userid=%s LIMIT 1", - array(SURFBAR_GET_SALT(), SURFBAR_GET_ID(), $GLOBALS['userid']), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_surfbar_salts` SET `last_salt`='%s' WHERE `url_id`=%s AND `userid`=%s LIMIT 1", + array(SURFBAR_GET_SALT(), SURFBAR_GET_ID(), getUserId()), __FUNCTION__, __LINE__); // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "salt=".SURFBAR_GET_SALT().",id=".SURFBAR_GET_ID().",uid=".$GLOBALS['userid']."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "salt=".SURFBAR_GET_SALT().",id=".SURFBAR_GET_ID().",uid=".getUserId()."", false); // Was that okay? if (SQL_AFFECTEDROWS() < 1) { // Insert missing entry! - SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_surfbar_salts (url_id,userid,last_salt) VALUES (%s, %s, '%s')", - array(SURFBAR_GET_ID(), $GLOBALS['userid'], SURFBAR_GET_SALT()), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_surfbar_salts` (`url_id`, `userid`, `last_salt`) VALUES (%s, %s, '%s')", + array(SURFBAR_GET_ID(), getUserId(), SURFBAR_GET_SALT()), __FUNCTION__, __LINE__); } // END - if // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "affectedRows=".SQL_AFFECTEDROWS()."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "affectedRows=".SQL_AFFECTEDROWS()."", false); // Return if the update was okay return (SQL_AFFECTEDROWS() == 1); } + // Check if the reload lock is active for given id function SURFBAR_CHECK_RELOAD_LOCK ($urlId) { - //DEBUG_LOG(__FUNCTION__, __LINE__, "id={$urlId}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "id={$urlId}", false); // Ask the database - $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt -FROM "._MYSQL_PREFIX."_surfbar_locks -WHERE userid=%s AND url_id=%s AND (UNIX_TIMESTAMP() - ".SURFBAR_GET_DATA('surf_lock').") < UNIX_TIMESTAMP(last_surfed) -ORDER BY last_surfed ASC + $result = SQL_QUERY_ESC("SELECT COUNT(`id`) AS cnt +FROM + `{!_MYSQL_PREFIX!}_surfbar_locks` +WHERE + `userid`=%s AND `url_id`=%s AND (UNIX_TIMESTAMP() - ".SURFBAR_GET_SURF_LOCK().") < UNIX_TIMESTAMP(`last_surfed`) +ORDER BY + `last_surfed` ASC LIMIT 1", - array($GLOBALS['userid'], bigintval($urlId)), __FILE__, __LINE__ + array(getUserId(), bigintval($urlId)), __FUNCTION__, __LINE__ ); // Fetch counter @@ -1062,9 +1112,10 @@ LIMIT 1", SQL_FREERESULT($result); // Return check - //DEBUG_LOG(__FUNCTION__, __LINE__, "cnt={$cnt},".SURFBAR_GET_DATA('surf_lock')."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "cnt={$cnt},".SURFBAR_GET_SURF_LOCK()."", false); return ($cnt == 1); } + // Determine which user hash no more points left function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) { // Init array @@ -1077,43 +1128,57 @@ function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) { // Do we have a current user id? if ((IS_MEMBER()) && ($limit == 0)) { // Then add this as well - $UIDs['uid'][$GLOBALS['userid']] = $GLOBALS['userid']; - $UIDs['points'][$GLOBALS['userid']] = GET_TOTAL_DATA($GLOBALS['userid'], "user_points", "points") - GET_TOTAL_DATA($GLOBALS['userid'], "user_data", "used_points"); - $UIDs['notified'][$GLOBALS['userid']] = 0; + $UIDs['uid'][getUserId()] = getUserId(); + $UIDs['points'][getUserId()] = GET_TOTAL_DATA(getUserId(), 'user_points', 'points') - GET_TOTAL_DATA(getUserId(), 'user_data', 'used_points'); + $UIDs['notified'][getUserId()] = 0; // Get all userid except logged in one - $result = SQL_QUERY_ESC("SELECT u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified -FROM "._MYSQL_PREFIX."_surfbar_urls AS u -INNER JOIN "._MYSQL_PREFIX."_user_data AS d -ON u.userid=d.userid -WHERE u.userid NOT IN (%s,0) AND u.status='ACTIVE' -GROUP BY u.userid -ORDER BY u.userid ASC", - array($GLOBALS['userid']), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT + u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified +FROM + `{!_MYSQL_PREFIX!}_surfbar_urls` AS u +INNER JOIN + `{!_MYSQL_PREFIX!}_user_data` AS d +ON + u.userid=d.userid +WHERE + u.userid NOT IN (%s,0) AND u.`status`='ACTIVE' +GROUP BY + u.userid +ORDER BY + u.userid ASC", + array(getUserId()), __FUNCTION__, __LINE__); } else { // Get all userid - $result = SQL_QUERY("SELECT u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified -FROM "._MYSQL_PREFIX."_surfbar_urls AS u -INNER JOIN "._MYSQL_PREFIX."_user_data AS d -ON u.userid=d.userid -WHERE u.status='ACTIVE' -GROUP BY u.userid -ORDER BY u.userid ASC", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT + u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified +FROM + `{!_MYSQL_PREFIX!}_surfbar_urls` AS u +INNER JOIN + `{!_MYSQL_PREFIX!}_user_data` AS d +ON + u.userid=d.userid +WHERE + u.`status`='ACTIVE' +GROUP BY + u.userid +ORDER BY + u.userid ASC", __FUNCTION__, __LINE__); } // Load all userid - while (list($uid, $notified) = SQL_FETCHROW($result)) { + while ($content = SQL_FETCHARRAY($result)) { // Get total points - $points = GET_TOTAL_DATA($uid, "user_points", "points") - GET_TOTAL_DATA($uid, "user_data", "used_points"); - //DEBUG_LOG(__FUNCTION__, __LINE__, "uid={$uid},points={$points}", false); + $points = GET_TOTAL_DATA($content['userid'], 'user_points', 'points') - GET_TOTAL_DATA($content['userid'], 'user_data', 'used_points'); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "uid={$content['userid']},points={$points}", false); // Shall we add this to ignore? if ($points <= $limit) { // Ignore this one! - //DEBUG_LOG(__FUNCTION__, __LINE__, "uid={$uid} has depleted points amount!", false); - $UIDs['uid'][$uid] = $uid; - $UIDs['points'][$uid] = $points; - $UIDs['notified'][$uid] = $notified; + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "uid={$content['userid']} has depleted points amount!", false); + $UIDs['uid'][$content['userid']] = $content['userid']; + $UIDs['points'][$content['userid']] = $points; + $UIDs['notified'][$content['userid']] = $content['notified']; } // END - if } // END - while @@ -1121,21 +1186,20 @@ ORDER BY u.userid ASC", __FILE__, __LINE__); SQL_FREERESULT($result); // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "UIDs::count=".count($UIDs)." (with own userid=".$GLOBALS['userid'].")", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "UIDs::count=".count($UIDs)." (with own userid=".getUserId().')', false); // Return result return $UIDs; } + // Determine how many users are Online in surfbar function SURFBAR_DETERMINE_TOTAL_ONLINE () { - global $_CONFIG; - // Count all users in surfbar modue and return the value $result = SQL_QUERY_ESC("SELECT id -FROM "._MYSQL_PREFIX."_surfbar_stats +FROM `{!_MYSQL_PREFIX!}_surfbar_stats` WHERE (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_online)) <= %s GROUP BY userid", - array($_CONFIG['online_timeout']), __FILE__, __LINE__); + array(getConfig('online_timeout')), __FUNCTION__, __LINE__); // Fetch count $cnt = SQL_NUMROWS($result); @@ -1146,15 +1210,23 @@ GROUP BY userid", // Return result return $cnt; } -// Determine waiting time for one URL + +// Determine waiting time for one URL function SURFBAR_DETERMINE_WAIT_TIME () { - global $_CONFIG; + // Get fixed reload lock + $fixed = SURFBAR_GET_FIXED_RELOAD(); + + // Is the fixed reload time set? + if ($fixed > 0) { + // Return it + return $fixed; + } // END - if // Static time is default - $time = $_CONFIG['surfbar_static_time']; + $time = getConfig('surfbar_static_time'); // Which payment model do we have? - if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { + if (getConfig('surfbar_pay_model') == 'DYNAMIC') { // "Calculate" dynamic time $time += SURFBAR_CALCULATE_DYNAMIC_ADD(); } // END - if @@ -1162,10 +1234,9 @@ function SURFBAR_DETERMINE_WAIT_TIME () { // Return value return $time; } + // Changes the status of an URL from given to other function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) { - global $_CONFIG; - // Make new status always lower-case $newStatus = strtolower($newStatus); @@ -1190,43 +1261,50 @@ function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) // 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", - // array($newStatus, bigintval($urlId)), __FILE__, __LINE__); + //SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_surfbar_urls` SET `status`='%s' WHERE `id`=%s LIMIT 1", + // array($newStatus, bigintval($urlId)), __FUNCTION__, __LINE__); // ---------- Comment out for debugging/developing member actions! --------- // Was that fine? - if (SQL_AFFECTEDROWS() != 1) { - // No, something went wrong - return false; - } // END - if + // ---------- 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]['uid'] = $data[$urlId]['userid']; $data[$urlId]['frametester'] = FRAMETESTER($data[$urlId]['url']); - $data[$urlId]['reward'] = TRANSLATE_COMMA($_CONFIG['surfbar_static_reward']); - $data[$urlId]['costs'] = TRANSLATE_COMMA($_CONFIG['surfbar_static_costs']); + $data[$urlId]['reward'] = translateComma(getConfig('surfbar_static_reward')); + $data[$urlId]['costs'] = translateComma(getConfig('surfbar_static_costs')); + + // Do some dirty fixing here: + if (($data[$urlId]['status'] == 'STOPPED') && ($newStatus == 'pending')) { + // Fix for template change + $newStatus = 'continued'; + } // END - if // Send admin notification - SURFBAR_NOTIFY_ADMIN("url_{$newStatus}", $data[$urlId]); + SURFBAR_NOTIFY_ADMIN("url_{$data[$urlId]['status']}_{$newStatus}", $data[$urlId]); // Send user notification - SURFBAR_NOTIFY_USER("url_{$newStatus}", $data[$urlId]); + SURFBAR_NOTIFY_USER("url_{$data[$urlId]['status']}_{$newStatus}", $data[$urlId]); // All done! return true; } + // Calculate minimum value for dynamic payment model function SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE () { - global $_CONFIG; - // Addon is zero by default $addon = 0; // Percentage part - $percent = abs(log($_CONFIG['surfbar_dynamic_percent'] / 100 + 1)); + $percent = abs(log(getConfig('surfbar_dynamic_percent') / 100 + 1)); // Get total users - $totalUsers = GET_TOTAL_DATA("CONFIRMED", "user_data", "userid", "status", true); + $totalUsers = GET_TOTAL_DATA('CONFIRMED', 'user_data', 'userid', 'status', true); // Get online users $onlineUsers = SURFBAR_DETERMINE_TOTAL_ONLINE(); @@ -1235,10 +1313,10 @@ function SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE () { $addon += abs(log($onlineUsers / $totalUsers + 1) * $percent * $totalUsers); // Get total URLs - $totalUrls = SURFBAR_GET_TOTAL_URLS("ACTIVE", "0"); + $totalUrls = SURFBAR_GET_TOTAL_URLS('ACTIVE', '0'); // Get user's total URLs - $userUrls = SURFBAR_GET_TOTAL_USER_URLS(0, "ACTIVE"); + $userUrls = SURFBAR_GET_TOTAL_USER_URLS(0, 'ACTIVE'); // Calculate addon if ($totalUrls > 0) { @@ -1250,10 +1328,9 @@ function SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE () { // Return addon return $addon; } + // Calculate maximum value for dynamic payment model function SURFBAR_CALCULATE_DYNAMIC_MAX_VALUE () { - global $_CONFIG; - // Addon is zero by default $addon = 0; @@ -1261,16 +1338,16 @@ function SURFBAR_CALCULATE_DYNAMIC_MAX_VALUE () { $max = log(2); // Percentage part - $percent = abs(log($_CONFIG['surfbar_dynamic_percent'] / 100 + 1)); + $percent = abs(log(getConfig('surfbar_dynamic_percent') / 100 + 1)); // Get total users - $totalUsers = GET_TOTAL_DATA("CONFIRMED", "user_data", "userid", "status", true); + $totalUsers = GET_TOTAL_DATA('CONFIRMED', 'user_data', 'userid', 'status', true); // Calculate addon $addon += abs($max * $percent * $totalUsers); // Get total URLs - $totalUrls = SURFBAR_GET_TOTAL_URLS("ACTIVE", "0"); + $totalUrls = SURFBAR_GET_TOTAL_URLS('ACTIVE', '0'); // Calculate addon $addon += abs($max * $percent * $totalUrls); @@ -1278,10 +1355,9 @@ function SURFBAR_CALCULATE_DYNAMIC_MAX_VALUE () { // Return addon return $addon; } + // Calculate dynamic lock function SURFBAR_CALCULATE_DYNAMIC_LOCK () { - global $_CONFIG; - // Default lock is 30 seconds $addon = 30; @@ -1294,6 +1370,7 @@ function SURFBAR_CALCULATE_DYNAMIC_LOCK () { // Return value return $addon; } + // "Getter" for lock ids array function SURFBAR_GET_LOCK_IDS () { // Prepare some arrays @@ -1304,40 +1381,40 @@ function SURFBAR_GET_LOCK_IDS () { // Get all id from locks within the timestamp $result = SQL_QUERY_ESC("SELECT id, url_id, UNIX_TIMESTAMP(last_surfed) AS last FROM - "._MYSQL_PREFIX."_surfbar_locks + {!_MYSQL_PREFIX!}_surfbar_locks WHERE userid=%s ORDER BY - id ASC", array($GLOBALS['userid']), - __FILE__, __LINE__); + id ASC", array(getUserId()), + __FUNCTION__, __LINE__); // Load all entries - while (list($lid, $url, $last) = SQL_FETCHROW($result)) { + while ($content = SQL_FETCHARRAY($result)) { // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "next - lid={$lid},url={$url},rest=".(time() - $last)."/".SURFBAR_GET_DATA('surf_lock')."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "next - lid={$content['id']},url={$content['url_id']},rest=".(time() - $last).'/'.SURFBAR_GET_SURF_LOCK()."", false); // Skip entries that are too old - if (($last > (time() - SURFBAR_GET_DATA('surf_lock'))) && (!in_array($url, $ignored))) { + if (($last > (time() - SURFBAR_GET_SURF_LOCK())) && (!in_array($content['url_id'], $ignored))) { // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "okay - lid={$lid},url={$url},last={$last}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "okay - lid={$content['id']},url={$content['url_id']},last={$last}", false); // Add only if missing or bigger - if ((!isset($IDs[$url])) || ($IDs[$url] > $last)) { + if ((!isset($IDs[$content['url_id']])) || ($IDs[$content['url_id']] > $last)) { // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "ADD - lid={$lid},url={$url},last={$last}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "ADD - lid={$content['id']},url={$content['url_id']},last={$last}", false); // Add this ID - $IDs[$url] = $last; - $USE[$url] = $lid; + $IDs[$content['url_id']] = $last; + $USE[$content['url_id']] = $content['id']; } // END - if } else { // Debug message - //DEBUG_LOG(__FUNCTION__, __LINE__, "ignore - lid={$lid},url={$url},last={$last}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "ignore - lid={$content['id']},url={$content['url_id']},last={$last}", false); // Ignore these old entries! - $ignored[] = $url; - unset($IDs[$url]); - unset($USE[$url]); + $ignored[] = $content['url_id']; + unset($IDs[$content['url_id']]); + unset($USE[$content['url_id']]); } } // END - while @@ -1347,21 +1424,21 @@ ORDER BY // Return array return $USE; } + // "Getter" for maximum random number -function SURFBAR_GET_MAX_RANDOM ($UIDs, $ADD) { - global $_CONFIG; +function SURFBAR_GET_MAX_RANDOM ($UIDs, $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 +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 +LEFT JOIN `{!_MYSQL_PREFIX!}_surfbar_locks` AS l ON sbu.id=l.url_id -WHERE sbu.userid NOT IN (".implode(",", $UIDs).") AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0)) AND sbu.status='ACTIVE'".$ADD." -GROUP BY sbu.id", __FILE__, __LINE__); +WHERE sbu.userid NOT IN (".implode(',', $UIDs).") 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__); // Log last query - //DEBUG_LOG(__FUNCTION__, __LINE__, "lastQuery=".$_CONFIG['db_last_query']."|numRows=".SQL_NUMROWS($result)."|Affected=".SQL_AFFECTEDROWS()."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "lastQuery=".getConfig('db_last_query')."|numRows=".SQL_NUMROWS($result)."|Affected=".SQL_AFFECTEDROWS()."", false); // Fetch max rand $maxRand = SQL_NUMROWS($result); @@ -1372,6 +1449,7 @@ GROUP BY sbu.id", __FILE__, __LINE__); // Return value return $maxRand; } + // Load all URLs of the current user and return it as an array function SURFBAR_GET_USER_URLS () { // Init array @@ -1379,10 +1457,10 @@ function SURFBAR_GET_USER_URLS () { // 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 +FROM `{!_MYSQL_PREFIX!}_surfbar_urls` AS u WHERE u.userid=%s AND u.status != 'DELETED' ORDER BY u.id ASC", - array($GLOBALS['userid']), __FILE__, __LINE__); + array(getUserId()), __FUNCTION__, __LINE__); // Are there entries? if (SQL_NUMROWS($result) > 0) { @@ -1399,20 +1477,22 @@ ORDER BY u.id ASC", // Return the array return $URLs; } + // "Getter" for member action array for given status -function SURFBAR_GET_ACTION_ARRAY ($status) { +function SURFBAR_getModeAction_ARRAY ($status) { // Init array $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), __FILE__, __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) { // Load all actions - while (list($action) = SQL_FETCHROW($result)) { - $returnArray[] = $action; + // @TODO This can be somehow rewritten + while ($content = SQL_FETCHARRAY($result)) { + $returnArray[] = $content['action']; } // END - if } // END - if @@ -1422,25 +1502,22 @@ function SURFBAR_GET_ACTION_ARRAY ($status) { // Return result return $returnArray; } -// Reload to configured stop page -function SURFBAR_RELOAD_TO_STOP_PAGE($page="stop") { - global $_CONFIG; +// Reload to configured stop page +function SURFBAR_RELOAD_TO_STOP_PAGE ($page="stop") { // Internal or external? - if (($_CONFIG['surfbar_pause_mode'] == "INTERNAL") || (empty($_CONFIG['surfbar_pause_url']))) { + if ((getConfig('surfbar_pause_mode') == 'INTERNAL') || (getConfig('surfbar_pause_url') == '')) { // Reload to internal page - LOAD_URL("surfbar.php?frame=".$page); + redirectToUrl('surfbar.php?frame=' . $page); } else { // Reload to external page - LOAD_URL($_CONFIG['surfbar_pause_url']); + redirectToConfiguredUrl('surfbar_pause_url'); } } // Determine next id for surfbar or get data for given id, always call this before you call other // getters below this function!!! function SURFBAR_DETERMINE_NEXT_ID ($urlId = 0) { - global $SURFBAR_CACHE, $_CONFIG; - // Default is no id and no random number $nextId = 0; $randNum = 0; @@ -1451,24 +1528,24 @@ function SURFBAR_DETERMINE_NEXT_ID ($urlId = 0) { $USE = SURFBAR_GET_LOCK_IDS(); // Shall we add some URL ids to ignore? - $ADD = ""; + $add = ''; if (count($USE) > 0) { // Ignore some! - $ADD = " AND sbu.id NOT IN ("; + $add = " AND sbu.id NOT IN ("; foreach ($USE as $url_id => $lid) { // Add URL id - $ADD .= $url_id.","; + $add .= $url_id.','; } // END - foreach // Add closing bracket - $ADD = substr($ADD, 0, -1) . ")"; + $add = substr($add, 0, -1) . ')'; } // END - if // Determine depleted user account $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS(); // Get maximum randomness factor - $maxRand = SURFBAR_GET_MAX_RANDOM($UIDs['uid'], $ADD); + $maxRand = SURFBAR_GET_MAX_RANDOM($UIDs['uid'], $add); // If more than one URL can be called generate the random number! if ($maxRand > 1) { @@ -1477,69 +1554,69 @@ function SURFBAR_DETERMINE_NEXT_ID ($urlId = 0) { } // END - if // And query the database - //DEBUG_LOG(__FUNCTION__, __LINE__, "randNum={$randNum},maxRand={$maxRand},surfLock=".SURFBAR_GET_DATA('surf_lock')."", false); - $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.views_total, sbu.views_max, sbu.views_allowed, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed -FROM "._MYSQL_PREFIX."_surfbar_urls AS sbu -LEFT JOIN "._MYSQL_PREFIX."_surfbar_salts AS sbs + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "randNum={$randNum},maxRand={$maxRand},surfLock=".SURFBAR_GET_SURF_LOCK()."", false); + $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.views_total, sbu.views_max, sbu.views_allowed, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed, sbu.fixed_reload +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 +LEFT JOIN `{!_MYSQL_PREFIX!}_surfbar_locks` AS l ON sbu.id=l.url_id -WHERE sbu.userid NOT IN (".implode(",", $UIDs['uid']).") AND sbu.status='ACTIVE' AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0))".$ADD." +WHERE sbu.userid NOT IN (".implode(',', $UIDs['uid']).") AND sbu.`status`='ACTIVE' AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0))".$add." GROUP BY sbu.id ORDER BY l.last_surfed ASC, sbu.id ASC LIMIT %s,1", - array($randNum), __FILE__, __LINE__ + array($randNum), __FUNCTION__, __LINE__ ); } else { // Get data from specified id number - $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.views_total, sbu.views_max, sbu.views_allowed, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed -FROM "._MYSQL_PREFIX."_surfbar_urls AS sbu -LEFT JOIN "._MYSQL_PREFIX."_surfbar_salts AS sbs + $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.views_total, sbu.views_max, sbu.views_allowed, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed, sbu.fixed_reload +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 +LEFT JOIN `{!_MYSQL_PREFIX!}_surfbar_locks` AS l ON sbu.id=l.url_id -WHERE sbu.userid != %s AND sbu.status='ACTIVE' AND sbu.id=%s AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0)) +WHERE sbu.userid != %s AND sbu.`status`='ACTIVE' AND sbu.id=%s AND (sbu.views_allowed=0 OR (sbu.views_allowed > 0 AND sbu.views_max > 0)) LIMIT 1", - array($GLOBALS['userid'], bigintval($urlId)), __FILE__, __LINE__ + array(getUserId(), bigintval($urlId)), __FUNCTION__, __LINE__ ); } // Is there an id number? - //DEBUG_LOG(__FUNCTION__, __LINE__, "lastQuery=".$_CONFIG['db_last_query']."|numRows=".SQL_NUMROWS($result)."|Affected=".SQL_AFFECTEDROWS()."", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "lastQuery=".getConfig('db_last_query')."|numRows=".SQL_NUMROWS($result)."|Affected=".SQL_AFFECTEDROWS()."", false); if (SQL_NUMROWS($result) == 1) { // Load/cache data - //DEBUG_LOG(__FUNCTION__, __LINE__, "count(".count($SURFBAR_CACHE).") - BEFORE", false); - $SURFBAR_CACHE = merge_array($SURFBAR_CACHE, SQL_FETCHARRAY($result)); - //DEBUG_LOG(__FUNCTION__, __LINE__, "count(".count($SURFBAR_CACHE).") - AFTER", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "count(".count($GLOBALS['surfbar_cache']).") - BEFORE", false); + $GLOBALS['surfbar_cache'] = merge_array($GLOBALS['surfbar_cache'], SQL_FETCHARRAY($result)); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "count(".count($GLOBALS['surfbar_cache']).") - AFTER", false); // Determine waiting time - $SURFBAR_CACHE['time'] = SURFBAR_DETERMINE_WAIT_TIME(); + $GLOBALS['surfbar_cache']['time'] = SURFBAR_DETERMINE_WAIT_TIME(); // Is the last salt there? - if (is_null($SURFBAR_CACHE['last_salt'])) { + if (is_null($GLOBALS['surfbar_cache']['last_salt'])) { // Then repair it wit the static! - //DEBUG_LOG(__FUNCTION__, __LINE__, "last_salt - FIXED!", false); - $SURFBAR_CACHE['last_salt'] = ""; + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "last_salt - FIXED!", false); + $GLOBALS['surfbar_cache']['last_salt'] = ''; } // END - if // Fix missing last_surfed - if ((!isset($SURFBAR_CACHE['last_surfed'])) || (is_null($SURFBAR_CACHE['last_surfed']))) { + if ((!isset($GLOBALS['surfbar_cache']['last_surfed'])) || (is_null($GLOBALS['surfbar_cache']['last_surfed']))) { // Fix it here - //DEBUG_LOG(__FUNCTION__, __LINE__, "last_surfed - FIXED!", false); - $SURFBAR_CACHE['last_surfed'] = 0; + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "last_surfed - FIXED!", false); + $GLOBALS['surfbar_cache']['last_surfed'] = 0; } // END - if // Get base/fixed reward and costs - $SURFBAR_CACHE['reward'] = SURFBAR_DETERMINE_REWARD(); - $SURFBAR_CACHE['costs'] = SURFBAR_DETERMINE_COSTS(); - //DEBUG_LOG(__FUNCTION__, __LINE__, "BASE/STATIC - reward=".SURFBAR_GET_REWARD()."|costs=".SURFBAR_GET_COSTS()."", false); + $GLOBALS['surfbar_cache']['reward'] = SURFBAR_DETERMINE_REWARD(); + $GLOBALS['surfbar_cache']['costs'] = SURFBAR_DETERMINE_COSTS(); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "BASE/STATIC - reward=".SURFBAR_GET_REWARD()."|costs=".SURFBAR_GET_COSTS()."", false); // Only in dynamic model add the dynamic bonus! - if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { + if (getConfig('surfbar_pay_model') == 'DYNAMIC') { // Calculate dynamic reward/costs and add it - $SURFBAR_CACHE['reward'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); - $SURFBAR_CACHE['costs'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); - //DEBUG_LOG(__FUNCTION__, __LINE__, "DYNAMIC+ - reward=".SURFBAR_GET_REWARD()."|costs=".SURFBAR_GET_COSTS()."", false); + $GLOBALS['surfbar_cache']['reward'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); + $GLOBALS['surfbar_cache']['costs'] += SURFBAR_CALCULATE_DYNAMIC_ADD(); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "DYNAMIC+ - reward=".SURFBAR_GET_REWARD()."|costs=".SURFBAR_GET_COSTS()."", false); } // END - if // Now get the id @@ -1550,80 +1627,115 @@ LIMIT 1", SQL_FREERESULT($result); // Return result - //DEBUG_LOG(__FUNCTION__, __LINE__, "nextId={$nextId}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "nextId={$nextId}", false); return $nextId; } + // ----------------------------------------------------------------------------- -// PLEASE DO NOT ADD ANY OTHER FUNCTIONS BELOW THIS LINE ELSE THEY "WRAP" THE -// $SURFBAR_CACHE ARRAY! +// 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 () { + // Init cache array + $GLOBALS['surfbar_cache'] = array(); +} + // Private getter for data elements function SURFBAR_GET_DATA ($element) { - global $SURFBAR_CACHE; - //DEBUG_LOG(__FUNCTION__, __LINE__, "element={$element}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "element={$element}", false); // Default is null $data = null; // Is the entry there? - if (isset($SURFBAR_CACHE[$element])) { + if (isset($GLOBALS['surfbar_cache'][$element])) { // Then take it - $data = $SURFBAR_CACHE[$element]; + $data = $GLOBALS['surfbar_cache'][$element]; } else { // END - if print("
");
-		print_r($SURFBAR_CACHE);
-		debug_print_backtrace();
-		die("
"); + print_r($GLOBALS['surfbar_cache']); + print(""); + debug_report_bug(); } // Return result - //DEBUG_LOG(__FUNCTION__, __LINE__, "element[$element]={$data}", false); + //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "element[$element]={$data}", false); return $data; } + // Getter for reward from cache function SURFBAR_GET_REWARD () { // Get data element and return its contents return SURFBAR_GET_DATA('reward'); } + // Getter for costs from cache function SURFBAR_GET_COSTS () { // Get data element and return its contents return SURFBAR_GET_DATA('costs'); } + // Getter for URL from cache function SURFBAR_GET_URL () { // Get data element and return its contents return SURFBAR_GET_DATA('url'); } + // Getter for salt from cache function SURFBAR_GET_SALT () { // Get data element and return its contents return SURFBAR_GET_DATA('salt'); } + // Getter for id from cache function SURFBAR_GET_ID () { // Get data element and return its contents return SURFBAR_GET_DATA('id'); } + // Getter for userid from cache function SURFBAR_GET_USERID () { // Get data element and return its contents return SURFBAR_GET_DATA('userid'); } + // Getter for user reload locks -function SURFBAR_GET_USER_RELOAD_LOCK () { +function SURFBAR_GET_USER_LOCKS () { // Get data element and return its contents return SURFBAR_GET_DATA('user_locks'); } + // Getter for reload time function SURFBAR_GET_RELOAD_TIME () { // Get data element and return its contents return SURFBAR_GET_DATA('time'); } + // Getter for allowed views -function SURFBAR_GET_ALLOWED_VIEWS () { +function SURFBAR_GET_VIEWS_ALLOWED () { // Get data element and return its contents return SURFBAR_GET_DATA('views_allowed'); } -// + +// Getter for fixed reload +function SURFBAR_GET_FIXED_RELOAD () { + // Get data element and return its contents + return SURFBAR_GET_DATA('fixed_reload'); +} + +// Getter for surf lock +function SURFBAR_GET_SURF_LOCK () { + // Get data element and return its contents + return SURFBAR_GET_DATA('surf_lock'); +} + +// Getter for new status +function SURFBAR_GET_NEW_STATUS () { + // Get data element and return its contents + return SURFBAR_GET_DATA('new_status'); +} + +// [EOF] ?>
-
- - - -
-