Constant SECS and MINS are now deprecated/removed, surfbar extended with static costs...

[mailer.git] / inc / libs / surfbar_functions.php

diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php
index 5af00ce901b202e82a00851e5442f14a18ba9695..b4364a6a49675a517a35558cf8c4bb57573cdea4 100644 (file)
--- 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
 }
 
 // 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
        // 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
        } // 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) {
 }
 // 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
        } // 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",
 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!
        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
        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,
                'frametester' => FRAMETESTER($url),
                'uid'         => $uid,
                'reward'      => $reward,

+               'costs'       => $costs,

                'payment_id'  => $paymentId,
                'status'      => $status
        );
                '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);
 
        // 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['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")) {
 
        // 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
 // 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'],
                array(
                        bigintval($urlData['uid']),
                        $urlData['url'],
                        (float)$urlData['reward'],

+                       (float)$urlData['costs'],

                        bigintval($urlData['payment_id']),
                        $urlData['status']
                ), __FILE__, __LINE__
                        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
        $_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
 
        // 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() {
 }
 // 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
                $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
 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
                );
        } 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
 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") {
 
                // 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['reward'] = $_CONFIG['surfbar_static_reward'];

+                       $SURFBAR_DATA['costs']  = $_CONFIG['surfbar_static_costs'];

                } else {
                } else {

-                       // Calculate dynamic reward and add it
+                       // Calculate dynamic reward/costs and add it

                        $SURFBAR_DATA['reward'] += SURFBAR_CALCULATE_DYNAMIC_REWARD_ADD();
                        $SURFBAR_DATA['reward'] += SURFBAR_CALCULATE_DYNAMIC_REWARD_ADD();

+                       $SURFBAR_DATA['costs']  += SURFBAR_CALCULATE_DYNAMIC_COSTS_ADD();

                }
 
                // Now get the id
                }
 
                // Now get the id


@@ -464,6 +469,11 @@ function SURFBAR_GET_REWARD () {
        // Get data element and return its contents
        return SURFBAR_GET_DATA('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
 // Getter for URL from cache
 function SURFBAR_GET_URL () {
        // Get data element and return its contents