X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fsurfbar_functions.php;h=b4364a6a49675a517a35558cf8c4bb57573cdea4;hp=5af00ce901b202e82a00851e5442f14a18ba9695;hb=fb54237bf1d0c0a7435ad4322a4ac40f3bd72eba;hpb=53e715060d8c41a8065bec85f706aff86f8cbc7c diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php index 5af00ce901..b4364a6a49 100644 --- a/inc/libs/surfbar_functions.php +++ b/inc/libs/surfbar_functions.php @@ -38,7 +38,7 @@ if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) { } // Admin has added an URL with given user id -function SURFBAR_ADMIN_ADD_URL ($url, $uid, $reward, $paymentId) { +function SURFBAR_ADMIN_ADD_URL ($url, $uid, $reward, $costs, $paymentId) { // Is this really an admin? if (!IS_ADMIN()) { // Then leave here @@ -52,7 +52,7 @@ function SURFBAR_ADMIN_ADD_URL ($url, $uid, $reward, $paymentId) { } // END - if // Register the new URL - return SURFBAR_REGISTER_URL($url, $uid, $reward, $paymentId, "CONFIRMED", "unlock"); + return SURFBAR_REGISTER_URL($url, $uid, $reward, $costs, $paymentId, "CONFIRMED", "unlock"); } // Looks up by an URL function SURFBAR_LOOKUP_BY_URL ($url) { @@ -76,7 +76,7 @@ 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, views_total, status, registered, last_locked, lock_reason + $result = SQL_QUERY_ESC("SELECT id, userid, url, reward, costs, views_total, status, registered, last_locked, lock_reason FROM "._MYSQL_PREFIX."_surfbar_urls WHERE %s='%s' ORDER BY %s %s", @@ -104,7 +104,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, $paymentId, $status="PENDING", $addMode="reg") { +function SURFBAR_REGISTER_URL ($url, $uid, $reward, $paymentId, $costs, $status="PENDING", $addMode="reg") { global $_CONFIG; // Make sure by the user registered URLs are always pending @@ -116,6 +116,7 @@ function SURFBAR_REGISTER_URL ($url, $uid, $reward, $paymentId, $status="PENDING 'frametester' => FRAMETESTER($url), 'uid' => $uid, 'reward' => $reward, + 'costs' => $costs, 'payment_id' => $paymentId, 'status' => $status ); @@ -123,9 +124,10 @@ function SURFBAR_REGISTER_URL ($url, $uid, $reward, $paymentId, $status="PENDING // Insert the URL into database $content['insert_id'] = SURFBAR_INSERT_URL_BY_ARRAY($content); - // Translate status and reward + // Translate status, reward and costs $content['status'] = SURFBAR_TRANSLATE_STATUS($content['status']); $content['reward'] = TRANSLATE_COMMA($content['reward']); + $content['costs'] = TRANSLATE_COMMA($content['costs']); // If in reg-mode we notify admin if (($addMode == "reg") || ($_CONFIG['surfbar_notify_admin_unlock'] == "Y")) { @@ -142,11 +144,12 @@ function SURFBAR_REGISTER_URL ($url, $uid, $reward, $paymentId, $status="PENDING // Inserts an url by given data array and return the insert id function SURFBAR_INSERT_URL_BY_ARRAY ($urlData) { // Just run the insert query for now - SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_surfbar_urls (userid, url, reward, payment_id, status) VALUES(%s, '%s', %s, %s, '%s')", + SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_surfbar_urls (userid, url, reward, costs, payment_id, status) VALUES(%s, '%s', %s, %s, %s, '%s')", array( bigintval($urlData['uid']), $urlData['url'], (float)$urlData['reward'], + (float)$urlData['costs'], bigintval($urlData['payment_id']), $urlData['status'] ), __FILE__, __LINE__ @@ -339,10 +342,10 @@ function SURFBAR_PAY_POINTS ($id) { $_CONFIG['db_table'] = "surfbar_reflevels"; // Book it to the user - ADD_POINTS_REFSYSTEM($GLOBALS['userid'], $SURFBAR_DATA['reward']); + ADD_POINTS_REFSYSTEM($GLOBALS['userid'], SURFBAR_GET_DATA('reward')); // Remove it from the URL owner - SUB_POINTS($SURFBAR_DATA['userid'], $SURFBAR_DATA['reward']); + SUB_POINTS($SURFBAR_DATA['userid'], SURFBAR_GET_DATA('costs')); } // Update the salt for validation function SURFBAR_UPDATE_SALT() { @@ -372,7 +375,7 @@ function SURFBAR_GET_NEXT_ID ($id = 0) { $randNum = mt_rand(0, $maxRand); // And query the database - $result = SQL_QUERY_ESC("SELECT sb.id, sb.userid, sb.url, sb.last_salt, sb.reward, sb.views_total, p.time, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed + $result = SQL_QUERY_ESC("SELECT sb.id, sb.userid, sb.url, sb.last_salt, sb.reward, sb.costs, sb.views_total, p.time, UNIX_TIMESTAMP(l.last_surfed) AS last_surfed FROM "._MYSQL_PREFIX."_surfbar_urls AS sb LEFT JOIN "._MYSQL_PREFIX."_payments AS p ON sb.payment_id=p.id @@ -385,7 +388,7 @@ LIMIT %d,1", ); } else { // Get data from specified id number - $result = SQL_QUERY_ESC("SELECT sb.id, sb.userid, sb.url, sb.last_salt, sb.reward, sb.views_total, p.time + $result = SQL_QUERY_ESC("SELECT sb.id, sb.userid, sb.url, sb.last_salt, sb.reward, sb.costs, sb.views_total, p.time FROM "._MYSQL_PREFIX."_surfbar_urls AS sb LEFT JOIN "._MYSQL_PREFIX."_payments AS p ON sb.payment_id=p.id @@ -416,11 +419,13 @@ LIMIT 1", // Are we in static mode? if ($_CONFIG['surfbar_pay_model'] == "STATIC") { - // Then use static reward! + // Then use static reward/costs! $SURFBAR_DATA['reward'] = $_CONFIG['surfbar_static_reward']; + $SURFBAR_DATA['costs'] = $_CONFIG['surfbar_static_costs']; } else { - // Calculate dynamic reward and add it + // Calculate dynamic reward/costs and add it $SURFBAR_DATA['reward'] += SURFBAR_CALCULATE_DYNAMIC_REWARD_ADD(); + $SURFBAR_DATA['costs'] += SURFBAR_CALCULATE_DYNAMIC_COSTS_ADD(); } // Now get the id @@ -464,6 +469,11 @@ 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