X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fsurfbar_functions.php;h=f83d4fac911e1d363d1393252870b7b25474ece2;hb=7f104f6fe558bb56b4205241435a2357c2feece1;hp=e235ce19cbab6d757e6c18abaa248044bef81720;hpb=78dc19b40041f126eede57575484c684d5fd0ddb;p=mailer.git diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php index e235ce19cb..f83d4fac91 100644 --- a/inc/libs/surfbar_functions.php +++ b/inc/libs/surfbar_functions.php @@ -40,9 +40,9 @@ if (!defined('__SECURITY')) { // ----------------------------------------------------------------------------- // Admin functions // ----------------------------------------------------------------------------- - +// // Admin has added an URL with given user id and so on -function SURFBAR_ADMIN_ADD_URL ($url) { +function SURFBAR_ADMIN_ADD_URL ($url, $limit) { // Do some pre-checks if (!IS_ADMIN()) { // Not an admin @@ -56,14 +56,33 @@ function SURFBAR_ADMIN_ADD_URL ($url) { } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS()) { // No more allowed! return false; + } elseif ("".bigintval($limit)."" != "".$limit."") { + // Invalid amount entered + return false; } - // Do we have fixed or dynamic payment model? - $reward = SURFBAR_DETERMINE_REWARD(); - $costs = SURFBAR_DETERMINE_COSTS(); + // Register the new URL + return SURFBAR_REGISTER_URL($url, "0", "ACTIVE", "unlock", $limit); +} +// 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)) { + // URL invalid + return false; + } elseif (SURFBAR_LOOKUP_BY_URL($url, $uid)) { + // URL already found in surfbar! + return false; + } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS($uid)) { + // No more allowed! + return false; + } // Register the new URL - return SURFBAR_REGISTER_URL($url, "0", $reward, $costs, "0", "CONFIRMED", "unlock"); + return SURFBAR_REGISTER_URL($url, $uid, "MIGRATED", "migrate"); } // Admin function for unlocking URLs function SURFBAR_ADMIN_UNLOCK_URL_IDS ($IDs) { @@ -85,19 +104,45 @@ 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", "CONFIRMED"))); + $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? + if (!IS_ADMIN()) { + // Not admin or invalid IDs array + return false; + } elseif (!is_array($IDs)) { + // No array + return false; + } elseif (count($IDs) == 0) { + // Empty array + return false; + } + // Set to true to make AND expression valid if first URL got unlocked + $done = true; + + // 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"))); + } // END - if + + // Return total status + return $done; +} +// // ----------------------------------------------------------------------------- // Member functions // ----------------------------------------------------------------------------- - +// // Member has added an URL -function SURFBAR_MEMBER_ADD_URL ($url) { +function SURFBAR_MEMBER_ADD_URL ($url, $limit) { global $_CONFIG; // Do some pre-checks @@ -113,29 +158,218 @@ function SURFBAR_MEMBER_ADD_URL ($url) { } elseif (!SURFBAR_IF_USER_BOOK_MORE_URLS($GLOBALS['userid'])) { // No more allowed! return false; + } elseif ("".bigintval($limit)."" != "".$limit."") { + // Invalid amount entered + return false; } - // Do we have fixed or dynamic payment model? - $reward = SURFBAR_DETERMINE_REWARD(); - $costs = SURFBAR_DETERMINE_COSTS(); - // Register the new URL - return SURFBAR_REGISTER_URL($url, $GLOBALS['userid'], $reward, $costs); + return SURFBAR_REGISTER_URL($url, $GLOBALS['userid'], "PENDING", "reg", $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); + + // Init HTML code + $OUT = " +\n"; + + // Calculate width + $width = round(100 / count($actionArray)); + + // "Walk" through all actions and create forms + foreach ($actionArray as $actionId=>$action) { + // Add form for this action + $OUT .= sprintf(" \n", + $width, + bigintval($urlId), + strtolower($action), + strtoupper($action), + strtoupper($action) + ); + } // END - foreach + + // Close table + $OUT .= " +
+
+ + + +
+
\n"; + + // 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; + + // Is this a member? + if (!IS_MEMBER()) { + // No member! + return false; + } elseif ((!isset($formData['id'])) || (!isset($formData['action']))) { + // Important form elements are missing! + return false; + } elseif (!isset($URLs[$formData['id']])) { + // ID not found in cache + return false; + } elseif (!SURFBAR_VALIDATE_MEMBER_ACTION_STATUS($formData['action'], $URLs[$formData['id']]['status'])) { + // Action not allowed for current URL status + return false; + } + + // Create the function name for selected action + $functionName = sprintf("SURFBAR_MEMBER_%s_ACTION", strtoupper(SQL_ESCAPE($formData['action']))); + + // Is the function there? + if (function_exists($functionName)) { + // Add new status + $URLs[$formData['id']]['new_status'] = $SURFBAR_CACHE['new_status']; + + // Extract URL data for call-back + $urlData = array($URLs[$formData['id']]); + + // Action found so execute it + $performed = call_user_func_array($functionName, $urlData); + } else { + // Log invalid request + DEBUG_LOG(__FUNCTION__.": action={$formData['action']},id={$formData['id']},function={$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__); + + // Is the entry there? + $isValid = (SQL_NUMROWS($result) == 1); + + // Fetch the new status if found + if ($isValid) { + list($SURFBAR_CACHE['new_status']) = SQL_FETCHROW($result); + } // END - if + + // Free result + SQL_FREERESULT($result); + + // Return status + return $isValid; +} +// // ----------------------------------------------------------------------------- -// Generic functions +// Member actions +// ----------------------------------------------------------------------------- +// +// Retreat an URL +function SURFBAR_MEMBER_RETREAT_ACTION ($urlData) { + // Create the data array for next function call + $data = array( + $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 + ); + + // Simply change the status here + return SURFBAR_CHANGE_STATUS ($urlData['id'], $urlData['status'], $urlData['new_status'], $data); +} +// +// ----------------------------------------------------------------------------- +// Self-maintenance functions // ----------------------------------------------------------------------------- +// +// Main function +function SURFBAR_HANDLE_SELF_MAINTENANCE () { + // Handle URLs which limit has depleted so we can stop them + SURFBAR_HANDLE_DEPLETED_VIEWS(); + + // Handle low-points amounts + SURFBAR_HANDLE_LOW_POINTS(); +} +// 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'"); + + // Do we have some entries? + if (count($urlArray) > 0) { + // Then handle all! + foreach ($urlArray as $id => $urlData) { + // Backup data + $data = $urlData; + + // Rewrite array for next call + $urlData[$id] = $data; + + // Handle the status + 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']); + + // "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']) { + // 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']) + ); + + // Notify this user + 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__); + } // END - if + } // END - foreach +} +// +// ----------------------------------------------------------------------------- +// Generic functions +// ----------------------------------------------------------------------------- +// // Looks up by an URL -function SURFBAR_LOOKUP_BY_URL ($url) { +function SURFBAR_LOOKUP_BY_URL ($url, $uid) { // Now lookup that given URL by itself - $urlArray = SURFBAR_GET_URL_DATA($url, "url"); + $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") { +function SURFBAR_GET_URL_DATA ($searchTerm, $column="id", $order="id", $sort="ASC", $group="id", $add="") { global $lastUrlData; // By default nothing is found @@ -154,9 +388,9 @@ function SURFBAR_GET_URL_DATA ($searchTerm, $column="id", $order="id", $sort="AS } // END - if // Look up the record - $result = SQL_QUERY_ESC("SELECT id, userid, url, reward, costs, views_total, status, registered, last_locked, lock_reason + $result = SQL_QUERY_ESC("SELECT id, userid, url, views_total, status, registered, last_locked, lock_reason, views_max, views_allowed FROM "._MYSQL_PREFIX."_surfbar_urls -WHERE %s='%s' +WHERE %s='%s'".$add." ORDER BY %s %s %s", array($column, $searchTerm, $order, $sort, $limit), __FILE__, __LINE__); @@ -183,7 +417,7 @@ ORDER BY %s %s return $lastUrlData; } // Registers an URL with the surfbar. You should have called SURFBAR_LOOKUP_BY_URL() first! -function SURFBAR_REGISTER_URL ($url, $uid, $reward, $costs, $paymentId=0, $status="PENDING", $addMode="reg") { +function SURFBAR_REGISTER_URL ($url, $uid, $status="PENDING", $addMode="reg", $limit=0) { global $_CONFIG; // Make sure by the user registered URLs are always pending @@ -194,18 +428,22 @@ function SURFBAR_REGISTER_URL ($url, $uid, $reward, $costs, $paymentId=0, $statu 'url' => $url, 'frametester' => FRAMETESTER($url), 'uid' => $uid, - 'reward' => $reward, - 'costs' => $costs, - 'status' => $status + 'status' => $status, + 'limit' => $limit ); // Insert the URL into database $content['insert_id'] = SURFBAR_INSERT_URL_BY_ARRAY($content); - // Translate status, reward and costs + // Is this ID valid? + if ($content['insert_id'] == 0) { + // INSERT did not insert any data! + return false; + } // END - if + + // Translate status and limit $content['status'] = SURFBAR_TRANSLATE_STATUS($content['status']); - $content['reward'] = TRANSLATE_COMMA($content['reward']); - $content['costs'] = TRANSLATE_COMMA($content['costs']); + $content['limit'] = SURFBAR_TRANSLATE_LIMIT($content['limit']); // If in reg-mode we notify admin if (($addMode == "reg") || ($_CONFIG['surfbar_notify_admin_unlock'] == "Y")) { @@ -228,13 +466,13 @@ 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, reward, costs, status) VALUES('%s', '%s', %s, %s, '%s')", + 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'], - (float)$urlData['reward'], - (float)$urlData['costs'], - $urlData['status'] + $urlData['status'], + $urlData['limit'], + $urlData['limit'] ), __FILE__, __LINE__ ); @@ -246,11 +484,14 @@ 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; + // Prepare subject $eval = sprintf("\$subject = ADMIN_SURFBAR_NOTIFY_%s_SUBJECT;", strtoupper($messageType) ); - eval($eval); + @eval($eval); // Send the notification out return SEND_ADMIN_NOTIFICATION($subject, $templateName, $content, $content['uid']); @@ -265,18 +506,35 @@ 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; + // Prepare subject $eval = sprintf("\$subject = MEMBER_SURFBAR_NOTIFY_%s_SUBJECT;", strtoupper($messageType) ); - eval($eval); + @eval($eval); // Load template - $mailText = LOAD_EMAIL_TEMPLATE($templateName, $content); + $mailText = LOAD_EMAIL_TEMPLATE($templateName, $content, $content['uid']); // Send the email return SEND_EMAIL($content['uid'], $subject, $mailText); } +// Translates the limit +function SURFBAR_TRANSLATE_LIMIT ($limit) { + // Is this zero? + if ($limit == 0) { + // Unlimited! + $return = MEMBER_SURFBAR_UNLIMITED_VIEWS; + } else { + // Translate comma + $return = TRANSLATE_COMMA($limit); + } + + // Return value + return $return; +} // Translate the URL status function SURFBAR_TRANSLATE_STATUS ($status) { // Create constant name @@ -295,7 +553,7 @@ function SURFBAR_TRANSLATE_STATUS ($status) { return $statusTranslated; } // Determine reward -function SURFBAR_DETERMINE_REWARD () { +function SURFBAR_DETERMINE_REWARD ($onlyMin=false) { global $_CONFIG; // Static values are default @@ -304,23 +562,18 @@ function SURFBAR_DETERMINE_REWARD () { // Do we have static or dynamic? if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { // "Calculate" dynamic reward - $reward += SURFBAR_CALCULATE_DYNAMIC_ADD(); + if ($onlyMin) { + $reward += SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); + } else { + $reward += SURFBAR_CALCULATE_DYNAMIC_ADD(); + } } // END - if // Return reward return $reward; } -// "Calculate" dynamic add -function SURFBAR_CALCULATE_DYNAMIC_ADD () { - // Get min/max values - $min = SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); - $max = SURFBAR_CALCULATE_DYNAMIC_MAX_VALUE(); - - // "Calculate" dynamic part and return it - return mt_rand($min, $max); -} // Determine costs -function SURFBAR_DETERMINE_COSTS () { +function SURFBAR_DETERMINE_COSTS ($onlyMin=false) { global $_CONFIG; // Static costs is default @@ -329,12 +582,25 @@ function SURFBAR_DETERMINE_COSTS () { // Do we have static or dynamic? if ($_CONFIG['surfbar_pay_model'] == "DYNAMIC") { // "Calculate" dynamic costs - $costs += SURFBAR_CALCULATE_DYNAMIC_ADD(); + if ($onlyMin) { + $costs += SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); + } else { + $costs += SURFBAR_CALCULATE_DYNAMIC_ADD(); + } } // END - if // Return costs return $costs; } +// "Calculate" dynamic add +function SURFBAR_CALCULATE_DYNAMIC_ADD () { + // Get min/max values + $min = SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE(); + $max = SURFBAR_CALCULATE_DYNAMIC_MAX_VALUE(); + + // "Calculate" dynamic part and return it + return mt_rand($min, $max); +} // Determine right template name function SURFBAR_DETERMINE_TEMPLATE_NAME() { // Default is the frameset @@ -398,21 +664,21 @@ LIMIT 1", // Return result return $isFull; } -// Get total amount of URLs of given status for current user or of CONFIRMED URLs by default -function SURFBAR_GET_TOTAL_URLS ($status="CONFIRMED", $excludeUserId="") { +// 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) { // Determine depleted user account $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS(); // Is the exlude userid set? - if ($excludeUserId !== "") { + if ($excludeUserId > 0) { // Then add it - $UIDs[] = $excludeUserId; + $UIDs['uid'][$excludeUserId] = $excludeUserId; } // END - if // Get amount from database $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt FROM "._MYSQL_PREFIX."_surfbar_urls -WHERE userid NOT IN (".implode(",", $UIDs).") AND status='%s'", +WHERE userid NOT IN (".implode(",", $UIDs['uid']).") AND status='%s'", array($status), __FILE__, __LINE__ ); @@ -430,10 +696,10 @@ 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) < $_CONFIG['surfbar_max_order'])); + return ((($uid == 0) && (IS_ADMIN())) || (SURFBAR_GET_TOTAL_USER_URLS($uid, "", array("REJECTED")) < $_CONFIG['surfbar_max_order'])); } // Get total amount of URLs of given status for current user -function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="") { +function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="",$exclude="") { global $_CONFIG; // Is the user 0 and user is logged in? @@ -449,9 +715,19 @@ function SURFBAR_GET_TOTAL_USER_URLS ($uid=0, $status="") { $ADD = ""; // Is the status set? - if (!empty($status)) { + if (is_array($status)) { + // Only URLs with these status + $ADD = sprintf(" AND status IN('%s')", implode("','", $status)); + } elseif (!empty($status)) { + // Only URLs with this status $ADD = sprintf(" AND status='%s'", $status); - } // END - if + } elseif (is_array($exclude)) { + // Exclude URLs with these status + $ADD = sprintf(" AND status NOT IN('%s')", implode("','", $exclude)); + } elseif (!empty($exclude)) { + // Exclude URLs with this status + $ADD = sprintf(" AND status != '%s'", $exclude); + } // Get amount from database $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt @@ -471,7 +747,7 @@ LIMIT %s", return $cnt; } // Generate a validation code for the given id number -function SURFBAR_GENERATE_VALIDATION_CODE ($id, $salt="") { +function SURFBAR_GENERATE_VALIDATION_CODE ($urlId, $salt="") { global $_CONFIG, $SURFBAR_CACHE; // @TODO Invalid salt should be refused @@ -498,7 +774,7 @@ function SURFBAR_GENERATE_VALIDATION_CODE ($id, $salt="") { } // ... and now the validation code - $valCode = GEN_RANDOM_CODE($length, sha1(SURFBAR_GET_SALT().":".$id), $GLOBALS['userid']); + $valCode = GEN_RANDOM_CODE($length, sha1(SURFBAR_GET_SALT().":".$urlId), $GLOBALS['userid']); //DEBUG_LOG(__FUNCTION__.":valCode={$valCode}"); } // END - while @@ -511,14 +787,14 @@ function SURFBAR_GENERATE_VALIDATION_CODE ($id, $salt="") { return $valHashedCode; } // Check validation code -function SURFBAR_CHECK_VALIDATION_CODE ($id, $check, $salt) { +function SURFBAR_CHECK_VALIDATION_CODE ($urlId, $check, $salt) { global $SURFBAR_CACHE; // Secure id number - $id = bigintval($id); + $urlId = bigintval($urlId); // Now generate the code again - $code = SURFBAR_GENERATE_VALIDATION_CODE($id, $salt); + $code = SURFBAR_GENERATE_VALIDATION_CODE($urlId, $salt); // Return result of checking hashes and salts //DEBUG_LOG(__FUNCTION__.":---".$code."|".$check."---"); @@ -526,19 +802,19 @@ function SURFBAR_CHECK_VALIDATION_CODE ($id, $check, $salt) { return (($code == $check) && ($salt == SURFBAR_GET_DATA('last_salt'))); } // Lockdown the userid/id combination (reload lock) -function SURFBAR_LOCKDOWN_ID ($id) { +function SURFBAR_LOCKDOWN_ID ($urlId) { //* //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($id)), __FILE__, __LINE__); + array($GLOBALS['userid'], bigintval($urlId)), __FILE__, __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($id), $GLOBALS['userid']), __FILE__, __LINE__); + array(bigintval($urlId), $GLOBALS['userid']), __FILE__, __LINE__); } // Pay points to the user and remove it from the sender -function SURFBAR_PAY_POINTS ($id) { +function SURFBAR_PAY_POINTS ($urlId) { // Remove it from the URL owner //DEBUG_LOG(__FUNCTION__.":uid=".SURFBAR_GET_USERID().",costs=".SURFBAR_GET_COSTS().""); if (SURFBAR_GET_USERID() > 0) { @@ -553,8 +829,20 @@ function SURFBAR_PAY_POINTS ($id) { function SURFBAR_UPDATE_INSERT_STATS_RECORD () { global $_CONFIG; - // Update views_total - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_surfbar_urls SET views_total=views_total+1 WHERE id=%s LIMIT 1", + // Init add + $ADD = ""; + + // Get allowed views + $allowed = SURFBAR_GET_ALLOWED_VIEWS(); + + // Do we have a limit? + if ($allowed > 0) { + // Then count views_max down! + $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__); // Update the stats entry @@ -562,7 +850,7 @@ function SURFBAR_UPDATE_INSERT_STATS_RECORD () { array($GLOBALS['userid'], SURFBAR_GET_ID()), __FILE__, __LINE__); // Was that update okay? - if (SQL_AFFECTEDROWS() == 0) { + 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__); @@ -590,7 +878,7 @@ function SURFBAR_UPDATE_SALT_STATS () { //DEBUG_LOG(__FUNCTION__.":salt=".SURFBAR_GET_SALT().",id=".SURFBAR_GET_ID().",uid=".$GLOBALS['userid'].""); // Was that okay? - if (SQL_AFFECTEDROWS() == 0) { + 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__); @@ -603,15 +891,15 @@ function SURFBAR_UPDATE_SALT_STATS () { return (SQL_AFFECTEDROWS() == 1); } // Check if the reload lock is active for given id -function SURFBAR_CHECK_RELOAD_LOCK ($id) { - //DEBUG_LOG(__FUNCTION__.":id={$id}"); +function SURFBAR_CHECK_RELOAD_LOCK ($urlId) { + //DEBUG_LOG(__FUNCTION__.":id={$urlId}"); // 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 LIMIT 1", - array($GLOBALS['userid'], bigintval($id)), __FILE__, __LINE__ + array($GLOBALS['userid'], bigintval($urlId)), __FILE__, __LINE__ ); // Fetch counter @@ -625,40 +913,50 @@ LIMIT 1", return ($cnt == 1); } // Determine which user hash no more points left -function SURFBAR_DETERMINE_DEPLETED_USERIDS() { +function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) { // Init array $UIDs = array(); // Do we have a current user id? - if (IS_MEMBER()) { + if ((IS_MEMBER()) && ($limit == 0)) { // Then add this as well - $UIDs[] = $GLOBALS['userid']; + $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; // Get all userid except logged in one - $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_surfbar_urls -WHERE userid NOT IN (%s,0) AND status='CONFIRMED' -GROUP BY userid -ORDER BY userid ASC", + $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__); } else { // Get all userid - $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_surfbar_urls -WHERE status='CONFIRMED' -GROUP BY userid -ORDER BY 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", __FILE__, __LINE__); } // Load all userid - while (list($uid) = SQL_FETCHROW($result)) { + while (list($uid, $notified) = SQL_FETCHROW($result)) { // Get total points $points = GET_TOTAL_DATA($uid, "user_points", "points") - GET_TOTAL_DATA($uid, "user_data", "used_points"); //DEBUG_LOG(__FUNCTION__.":uid={$uid},points={$points}"); // Shall we add this to ignore? - if ($points <= 0) { + if ($points <= $limit) { // Ignore this one! //DEBUG_LOG(__FUNCTION__.":uid={$uid} has depleted points amount!"); - $UIDs[] = $uid; + $UIDs['uid'][$uid] = $uid; + $UIDs['points'][$uid] = $points; + $UIDs['notified'][$uid] = $notified; } // END - if } // END - while @@ -708,19 +1006,26 @@ function SURFBAR_DETERMINE_WAIT_TIME () { return $time; } // Changes the status of an URL from given to other -function SURFBAR_CHANGE_STATUS ($id, $prevStatus, $newStatus) { - // Get URL data for status comparison - $data = SURFBAR_GET_URL_DATA($id); +function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) { + global $_CONFIG; + + // Get URL data for status comparison if missing + if (count($data) == 0) { + $data = SURFBAR_GET_URL_DATA($urlId); + } // END - if // Is the status like prevStatus is saying? - if ($data[$id]['status'] != $prevStatus) { + if ($data[$urlId]['status'] != $prevStatus) { // No, then abort here return false; } // END - if + // Update the status now - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_surfbar_urls SET status='%s' WHERE id=%s LIMIT 1", - array($newStatus, bigintval($id)), __FILE__, __LINE__); + // ---------------------- Commented out for debugging member actions! ----------------------- + //SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_surfbar_urls SET status='%s' WHERE id=%s LIMIT 1", + // array($newStatus, bigintval($urlId)), __FILE__, __LINE__); + // ---------------------- Commented out for debugging member actions! ----------------------- // Was that fine? if (SQL_AFFECTEDROWS() != 1) { @@ -729,19 +1034,19 @@ function SURFBAR_CHANGE_STATUS ($id, $prevStatus, $newStatus) { } // END - if // Prepare content for notification routines - $data[$id]['uid'] = $data[$id]['userid']; - $data[$id]['frametester'] = FRAMETESTER($data[$id]['url']); - $data[$id]['reward'] = TRANSLATE_COMMA($data[$id]['reward']); - $data[$id]['costs'] = TRANSLATE_COMMA($data[$id]['costs']); - $data[$id]['status'] = SURFBAR_TRANSLATE_STATUS($newStatus); - $data[$id]['registered'] = MAKE_DATETIME($data[$id]['registered'], "2"); + $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]['status'] = SURFBAR_TRANSLATE_STATUS($newStatus); + $data[$urlId]['registered'] = MAKE_DATETIME($data[$urlId]['registered'], "2"); $newStatus = strtolower($newStatus); // Send admin notification - SURFBAR_NOTIFY_ADMIN("url_{$newStatus}", $data[$id]); + SURFBAR_NOTIFY_ADMIN("url_{$newStatus}", $data[$urlId]); // Send user notification - SURFBAR_NOTIFY_USER("url_{$newStatus}", $data[$id]); + SURFBAR_NOTIFY_USER("url_{$newStatus}", $data[$urlId]); // All done! return true; @@ -766,10 +1071,10 @@ function SURFBAR_CALCULATE_DYNAMIC_MIN_VALUE () { $addon += abs(log($onlineUsers / $totalUsers + 1) * $percent * $totalUsers); // Get total URLs - $totalUrls = SURFBAR_GET_TOTAL_URLS("CONFIRMED", "0"); + $totalUrls = SURFBAR_GET_TOTAL_URLS("ACTIVE", "0"); // Get user's total URLs - $userUrls = SURFBAR_GET_TOTAL_USER_URLS(0, "CONFIRMED"); + $userUrls = SURFBAR_GET_TOTAL_USER_URLS(0, "ACTIVE"); // Calculate addon if ($totalUrls > 0) { @@ -801,7 +1106,7 @@ function SURFBAR_CALCULATE_DYNAMIC_MAX_VALUE () { $addon += abs($max * $percent * $totalUsers); // Get total URLs - $totalUrls = SURFBAR_GET_TOTAL_URLS("CONFIRMED", "0"); + $totalUrls = SURFBAR_GET_TOTAL_URLS("ACTIVE", "0"); // Calculate addon $addon += abs($max * $percent * $totalUrls); @@ -888,7 +1193,7 @@ LEFT JOIN "._MYSQL_PREFIX."_surfbar_salts AS sbs ON sbu.id=sbs.url_id LEFT JOIN "._MYSQL_PREFIX."_surfbar_locks AS l ON sbu.id=l.url_id -WHERE sbu.userid NOT IN (".implode(",", $UIDs).") AND sbu.status='CONFIRMED'".$ADD." +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__); // Log last query @@ -909,9 +1214,9 @@ function SURFBAR_GET_USER_URLS () { $URLs = array(); // Begin the query - $result = SQL_QUERY_ESC("SELECT u.id, u.url, u.views_total, u.status, UNIX_TIMESTAMP(u.registered) AS registered, UNIX_TIMESTAMP(u.last_locked) AS last_locked, u.lock_reason AS lock_reason + $result = SQL_QUERY_ESC("SELECT u.id, u.userid, u.url, u.views_total, u.status, UNIX_TIMESTAMP(u.registered) AS registered, UNIX_TIMESTAMP(u.last_locked) AS last_locked, u.lock_reason AS lock_reason FROM "._MYSQL_PREFIX."_surfbar_urls AS u -WHERE u.userid=%s +WHERE u.userid=%s AND u.status != 'DELETED' ORDER BY u.id ASC", array($GLOBALS['userid']), __FILE__, __LINE__); @@ -930,9 +1235,46 @@ ORDER BY u.id ASC", // Return the array return $URLs; } +// "Getter" for member action array for given status +function SURFBAR_GET_ACTION_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__); + + // Some entries there? + if (SQL_NUMROWS($result) > 0) { + // Load all actions + while (list($action) = SQL_FETCHROW($result)) { + $returnArray[] = $action; + } // END - if + } // END - if + + // Free result + SQL_FREERESULT($result); + + // Return result + return $returnArray; +} +// Reload to configured stop page +function SURFBAR_RELOAD_TO_STOP_PAGE($page="stop") { + global $_CONFIG; + + // Internal or external? + if (($_CONFIG['surfbar_pause_mode'] == "INTERNAL") || (empty($_CONFIG['surfbar_pause_url']))) { + // Reload to internal page + LOAD_URL("surfbar.php?frame=".$page); + } else { + // Reload to external page + LOAD_URL($_CONFIG['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 ($id = 0) { +function SURFBAR_DETERMINE_NEXT_ID ($urlId = 0) { global $SURFBAR_CACHE, $_CONFIG; // Default is no id and no random number @@ -940,7 +1282,7 @@ function SURFBAR_DETERMINE_NEXT_ID ($id = 0) { $randNum = 0; // Is the ID set? - if ($id == 0) { + if ($urlId == 0) { // Get array with lock ids $USE = SURFBAR_GET_LOCK_IDS(); @@ -962,7 +1304,7 @@ function SURFBAR_DETERMINE_NEXT_ID ($id = 0) { $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS(); // Get maximum randomness factor - $maxRand = SURFBAR_GET_MAX_RANDOM($UIDs, $ADD); + $maxRand = SURFBAR_GET_MAX_RANDOM($UIDs['uid'], $ADD); // If more than one URL can be called generate the random number! if ($maxRand > 1) { @@ -972,13 +1314,13 @@ function SURFBAR_DETERMINE_NEXT_ID ($id = 0) { // And query the database //DEBUG_LOG(__FUNCTION__.":randNum={$randNum},maxRand={$maxRand},surfLock=".SURFBAR_GET_DATA('surf_lock').""); - $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.reward, sbu.costs, sbu.views_total, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed + $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 ON sbu.id=sbs.url_id LEFT JOIN "._MYSQL_PREFIX."_surfbar_locks AS l ON sbu.id=l.url_id -WHERE sbu.userid NOT IN (".implode(",", $UIDs).") AND sbu.status='CONFIRMED'".$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", @@ -986,15 +1328,15 @@ LIMIT %s,1", ); } else { // Get data from specified id number - $result = SQL_QUERY_ESC("SELECT sbu.id, sbu.userid, sbu.url, sbs.last_salt, sbu.reward, sbu.costs, sbu.views_total, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed + $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 ON sbu.id=sbs.url_id LEFT JOIN "._MYSQL_PREFIX."_surfbar_locks AS l ON sbu.id=l.url_id -WHERE sbu.userid != %s AND sbu.status='CONFIRMED' AND sbu.id=%s +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($id)), __FILE__, __LINE__ + array($GLOBALS['userid'], bigintval($urlId)), __FILE__, __LINE__ ); } @@ -1114,5 +1456,10 @@ 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 () { + // Get data element and return its contents + return SURFBAR_GET_DATA('views_allowed'); +} // ?>