X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsurfbar_functions.php;h=da2d55ded961963e2f6b848f4091084825bc5fe8;hp=61a901eadecbae88820ea361a6324d5442dce625;hb=3482b953460718915a60361a1073206654abde9e;hpb=387a99be2a05128c307013cb7ed27628a46c27f4 diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php index 61a901eade..da2d55ded9 100644 --- a/inc/libs/surfbar_functions.php +++ b/inc/libs/surfbar_functions.php @@ -178,7 +178,6 @@ function SURFBAR_MEMBER_ADD_URL ($url, $limit) { } // Register the new URL - die('limit='.$limit); return SURFBAR_REGISTER_URL($url, getMemberId(), 'PENDING', 'reg', array('limit' => $limit)); } @@ -452,6 +451,7 @@ function SURFBAR_HANDLE_SELF_MAINTENANCE () { // Handle low-points amounts SURFBAR_HANDLE_LOW_POINTS(); } + // Handle URLs which limit has depleted function SURFBAR_HANDLE_DEPLETED_VIEWS () { // Get all URLs @@ -465,7 +465,9 @@ function SURFBAR_HANDLE_DEPLETED_VIEWS () { $data = $urlData; // Rewrite array for next call - $urlData[$id] = $data; + $urlData = array( + $id => $data + ); // Handle the status SURFBAR_CHANGE_STATUS($id, 'ACTIVE', 'DEPLETED', $urlData); @@ -1059,11 +1061,11 @@ function SURFBAR_LOCKDOWN_ID ($urlId) { //* DEBUG: */ debugOutput('LOCK!'); ///* DEBUG: */ return; // Just add it to the database - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_locks` (`locks_userid`, `locks_url_id`) VALUES (%s, %s)", + SQL_QUERY_ESC('INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_locks` (`locks_userid`, `locks_url_id`) VALUES (%s, %s)', array(getMemberId(), bigintval($urlId)), __FUNCTION__, __LINE__); // Remove the salt from database - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_surfbar_salts` WHERE `salts_url_id`=%s AND `salts_userid`=%s LIMIT 1", + SQL_QUERY_ESC('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_surfbar_salts` WHERE `salts_url_id`=%s AND `salts_userid`=%s LIMIT 1', array(bigintval($urlId), getMemberId()), __FUNCTION__, __LINE__); } @@ -1094,15 +1096,15 @@ function SURFBAR_UPDATE_INSERT_STATS_RECORD () { // Do we have a limit? if ($allowed > 0) { // Then count views_max down! - $add .= ", `views_max`=`views_max`-1"; + $add .= ', `url_views_max`=`url_views_max`-1'; } // END - if // Update URL stats - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url_views_total`=`url_views_total`+1".$add." WHERE `url_id`=%s LIMIT 1", + SQL_QUERY_ESC('UPDATE `{?_MYSQL_PREFIX?}_surfbar_urls` SET `url_views_total`=`url_views_total`+1' . $add . ' WHERE `url_id`=%s LIMIT 1', array(SURFBAR_GET_ID()), __FUNCTION__, __LINE__); // Update the stats entry - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_surfbar_stats` SET `stats_count`=`stats_count`+1 WHERE `stats_userid`=%s AND `stats_url_id`=%s LIMIT 1", + SQL_QUERY_ESC('UPDATE `{?_MYSQL_PREFIX?}_surfbar_stats` SET `stats_count`=`stats_count`+1 WHERE `stats_userid`=%s AND `stats_url_id`=%s LIMIT 1', array( getMemberId(), SURFBAR_GET_ID() @@ -1111,7 +1113,7 @@ function SURFBAR_UPDATE_INSERT_STATS_RECORD () { // Was that update okay? if (SQL_HASZEROAFFECTED()) { // No, then insert entry - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_stats` (`stats_userid`, `stats_url_id`, `stats_count`) VALUES (%s,%s,1)", + SQL_QUERY_ESC('INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_stats` (`stats_userid`, `stats_url_id`, `stats_count`) VALUES (%s,%s,1)', array( getMemberId(), SURFBAR_GET_ID() @@ -1315,7 +1317,7 @@ function SURFBAR_DETERMINE_WAIT_TIME () { // Changes the status of an URL from given to other function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) { - /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',prevStatus=' . $prevStatus . ',newStatus=' . $newStatus . ' - ENTERED!'); + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',prevStatus=' . $prevStatus . ',newStatus=' . $newStatus . ' - ENTERED!'); // Make new status always lower-case $newStatus = strtolower($newStatus); @@ -1368,26 +1370,8 @@ function SURFBAR_CHANGE_STATUS ($urlId, $prevStatus, $newStatus, $data=array()) // Extract data from it again $data = $filterData['data']; - // Prepare content for notification routines - $data[$urlId]['url_userid'] = $data[$urlId]['url_userid']; - $data[$urlId]['frametester'] = '{%pipe,generateFrametesterUrl=' . $data[$urlId]['url'] . '%}'; - $data[$urlId]['reward'] = '{%config,translateComma=surfbar_static_reward%}'; - $data[$urlId]['costs'] = '{%config,translateComma=surfbar_static_costs%}'; - - // Do some dirty fixing here: - if (($data[$urlId]['url_status'] == 'STOPPED') && ($newStatus == 'pending')) { - // Fix for template change - $newStatus = 'continued'; - } // END - if - - // Send admin notification - SURFBAR_NOTIFY_ADMIN('url_' . strtolower($data[$urlId]['url_status']) . '_' . $newStatus, $data[$urlId]); - - // Send user notification - SURFBAR_NOTIFY_USER('url_' . strtolower($data[$urlId]['url_status']) . '_' . $newStatus, $data[$urlId]); - // All done! - /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',prevStatus=' . $prevStatus . ',newStatus=' . $newStatus . ' - EXIT!'); + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'urlId=' . $urlId . ',prevStatus=' . $prevStatus . ',newStatus=' . $newStatus . ' - EXIT!'); return true; }