]> git.mxchange.org Git - mailer.git/blobdiff - inc/libs/refback_functions.php
New naming convention applied to many functions, see #118 for details
[mailer.git] / inc / libs / refback_functions.php
index 386eb564d26455cd3f8242cc61ef90c3814939cd..22d611da747f8ddac5fdcb2e0c36149c13268ea7 100644 (file)
@@ -83,7 +83,7 @@ function ADD_REFBACK_POINTS ($uid, $ref, $points, $ref_points) {
 
                                // Add points again, but only directly
                                //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):refback={$refback}<br />\n";
-                               ADD_POINTS_REFSYSTEM(sprintf("refback:%s", $refid), $uid, $refback, false, "0", false, "direct");
+                               ADD_POINTS_REFSYSTEM_DIRECT(sprintf("refback:%s", $refid), $uid, $refback);
 
                                // Reduce points if refid is found
                                if ($refid == $ref) {
@@ -173,7 +173,7 @@ ORDER BY userid ASC",
 }
 
 // Update "refback table"
-function UPDATE_REFBACK_TABLE ($uid) {
+function updateRefbackTable ($uid) {
        //* DEBUG: */ print "----------------------- <font color=\"#00aa00\">".__FUNCTION__." - ENTRY</font> ------------------------<ul><li>\n";
        // Make it sure referal level zero (member him-/herself) is at least selected
        if (empty($GLOBALS['cache_array']['back_level'])) $GLOBALS['cache_array']['back_level'] = 1;
@@ -208,7 +208,7 @@ function UPDATE_REFBACK_TABLE ($uid) {
                                } // END - if
 
                                // Check existence
-                               $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE userid=%s AND level='%s' AND refid=%s LIMIT 1",
+                               $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE userid=%s AND level='%s' AND refid=%s LIMIT 1",
                                        array(bigintval($uid), $GLOBALS['cache_array']['back_level'], bigintval($GLOBALS['cache_array']['up_refid'][$GLOBALS['cache_array']['back_level']])), __FUNCTION__, __LINE__);
 
                                // Do we have no entry?
@@ -220,7 +220,7 @@ function UPDATE_REFBACK_TABLE ($uid) {
                                                array(bigintval($uid), $GLOBALS['cache_array']['back_level'], bigintval($GLOBALS['cache_array']['up_refid'][$GLOBALS['cache_array']['back_level']])), __FUNCTION__, __LINE__);
 
                                        // Move to next referal level and count his counter one up!
-                                       $GLOBALS['cache_array']['back_level']++; UPDATE_REFBACK_TABLE($GLOBALS['cache_array']['up_refid'][($GLOBALS['cache_array']['back_level'] - 1)]);
+                                       $GLOBALS['cache_array']['back_level']++; updateRefbackTable($GLOBALS['cache_array']['up_refid'][($GLOBALS['cache_array']['back_level'] - 1)]);
                                } // END - if
 
                                // Do we have another level here?
@@ -229,7 +229,7 @@ function UPDATE_REFBACK_TABLE ($uid) {
                                        $uid = $old;
 
                                        // Shall we add this as well?
-                                       $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE userid=%s AND level='%s' AND refid=%s LIMIT 1",
+                                       $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE userid=%s AND level='%s' AND refid=%s LIMIT 1",
                                                array(bigintval($uid), ($GLOBALS['cache_array']['back_level']-$minus), bigintval($GLOBALS['cache_array']['up_refid'][$GLOBALS['cache_array']['back_level']])), __FUNCTION__, __LINE__);
 
                                        // Do we have no entry?
@@ -314,7 +314,7 @@ function GET_USER_REF_ENTRY ($id) {
        $id = bigintval($id);
 
        // Get entry from database
-       $result = SQL_QUERY_ESC("SELECT id, refid, refback, level FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE id=%s AND userid=%s LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT id, refid, refback, level FROM `{!_MYSQL_PREFIX!}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array($id, getUserId()), __FUNCTION__, __LINE__);
 
        // Is there an entry?
@@ -342,7 +342,7 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
                // No member!
                $status['message'] = getMessage('MEMBER_REFBACK_ERROR_NO_MEMBER');
                return $status;
-       } elseif ("".$id."" != "".($id + 0)."") {
+       } elseif ("".$id."" != ''.($id + 0)."") {
                // No number!
                $status['message'] = getMessage('MEMBER_REFBACK_ERROR_INVALID_ID_NUMBER');
                return $status;
@@ -363,10 +363,10 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
        } // END - if
 
        // Revert german commata
-       $percents = REVERT_COMMA($percents);
+       $percents = convertCommaToDot($percents);
 
        // Update entry
-       SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_refs` SET refback='%s' WHERE id=%s AND userid=%s LIMIT 1",
+       SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_refs` SET refback='%s' WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array($percents, $id, getUserId()), __FUNCTION__, __LINE__);
 
        // Entry updated?
@@ -378,7 +378,7 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
 
        // Prepare email content
        $content = array(
-               'percents' => TRANSLATE_COMMA($percents),
+               'percents' => translateComma($percents),
                'refid'    => $dummy['refid'],
                'level'    => $dummy['level']
        );
@@ -387,10 +387,10 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
        $mail = LOAD_EMAIL_TEMPLATE("member_refback", $content, getUserId());
 
        // Send email to user
-       SEND_EMAIL($dummy['refid'], getMessage('MEMBER_REFBACK_SUBJECT'), $mail);
+       sendEmail($dummy['refid'], getMessage('MEMBER_REFBACK_SUBJECT'), $mail);
 
        // Send admin notification
-       SEND_ADMIN_NOTIFICATION(getMessage('ADMIN_REFBACK_SUBJECT'), "admin_refback", $content, getUserId());
+       sendAdminNotification(getMessage('ADMIN_REFBACK_SUBJECT'), "admin_refback", $content, getUserId());
 
        // All fine!
        $status['ok'] = true;