A lot while() conditions rewritten to SQL_FETCHARRAY(), see bug #107, @TODO tags...
[mailer.git] / inc / libs / rallye_functions.php
index 039f36d..eaf6323 100644 (file)
@@ -63,36 +63,24 @@ function RALLYE_AUTOSTART_RALLYES($result)
        $DATA['title']      = $title;
        $DATA['id']         = $id;  // ID for the rallye details link
 
-       if ($min_users == 0) {
-               // Rallye ends without user limitation
-               $DATA['min_users'] = getMessage('RALLYE_END_NO_USER_LIMITATION');
-       } else {
-               // Rallye ends when X members are totally in your exchange
-               $DATA['min_users'] = RALLYE_END_USERS_1." ".$min_users." ".RALLYE_END_USERS_2;
-       }
-
-       if ($min_prices == 0) {
-               // Rallye ends without user limitation
-               $DATA['min_prices'] = getMessage('RALLYE_END_NO_PRICE_LIMITATION');
-       } else {
-               // Rallye ends when X members are totally in your exchange
-               $DATA['min_prices'] = RALLYE_END_PRICES_1." ".$min_prices." ".RALLYE_END_PRICES_2;
-       }
+       // Determine min_users and min_prices
+       $DATA['min_users']  = RALLYE_DETERMINE_MIN_USERS($min_users);
+       $DATA['min_prices'] = RALLYE_DETERMINE_MIN_PRICES($min_prices);
 
        // Load prices
        $prices = RALLYE_ADD_PRICES($id);
 
        // Let's begin with the userids...
-       while (list($uid) = SQL_FETCHROW($result_user)) {
+       while ($content = SQL_FETCHARRAY($result_user)) {
                $un = false;
 
                // Get refs by userid
-               $cnt = RALLYE_GET_REFCOUNT($uid);
+               $cnt = RALLYE_GET_REFCOUNT($content['userid']);
                if (empty($cnt)) $cnt = 0; // Added prevent some unknown troubles... :-?
 
                // Check if line is already included...
                $result_ref = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s AND userid=%s LIMIT 1",
-                       array(bigintval($id), bigintval($uid)), __FUNCTION__, __LINE__);
+                       array(bigintval($id), bigintval($content['userid'])), __FUNCTION__, __LINE__);
                if (SQL_NUMROWS($result_ref) == 0) {
                        // Free memory
                        SQL_FREERESULT($result_ref);
@@ -103,7 +91,7 @@ FROM `{!_MYSQL_PREFIX!}_user_points` AS p
 LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
 ON p.userid=d.userid
 WHERE d.`status`='CONFIRMED' AND d.max_mails > 0 AND d.mails_confirmed >= %s AND p.ref_depth=1 AND p.points > 0 AND d.userid=%s",
array(getConfig('ref_payout'), bigintval($uid)), __FUNCTION__, __LINE__);
                              array(getConfig('ref_payout'), bigintval($content['userid'])), __FUNCTION__, __LINE__);
                        list($cpoints) = SQL_FETCHROW($result_ref);
                        SQL_FREERESULT($result_ref);
 
@@ -112,7 +100,7 @@ WHERE d.`status`='CONFIRMED' AND d.max_mails > 0 AND d.mails_confirmed >= %s AND
                        // Add info line
                        SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_rallye_users` (rallye_id, userid, refs, curr_points)
 VALUES ('%s','%s','%s','%s')",
-                               array(bigintval($id), bigintval($uid), bigintval($cnt), $cpoints), __FUNCTION__, __LINE__);
+                               array(bigintval($id), bigintval($content['userid']), bigintval($cnt), $cpoints), __FUNCTION__, __LINE__);
                        $un = true;
                } // END - if
 
@@ -122,8 +110,8 @@ VALUES ('%s','%s','%s','%s')",
                // Shall I notify this member?
                if (($notify == "Y") && ($un)) {
                        // Load email template and send it to the user
-                       $msg = LOAD_EMAIL_TEMPLATE("member_rallye_notify", array('prices' => $prices), $uid);
-                       SEND_EMAIL($uid, RALLYE_MEMBER_NOTIFY.$title, $msg);
+                       $msg = LOAD_EMAIL_TEMPLATE("member_rallye_notify", array('prices' => $prices), $content['userid']);
+                       SEND_EMAIL($content['userid'], sprintf(getMessage('RALLYE_MEMBER_NOTIFY'), $title), $msg);
                } // END - if
        } // END - while
 
@@ -132,14 +120,13 @@ VALUES ('%s','%s','%s','%s')",
        if ($notify == "Y") $templ = "admin_rallye_notify";
 
        // Send email to admin
-       SEND_ADMIN_NOTIFICATION(RALLYE_ADMIN_NOTIFY.$title, $templ, $prices, "0");
+       SEND_ADMIN_NOTIFICATION(sprintf(getMessage('RALLYE_ADMIN_NOTIFY'), $title), $templ, $prices, "0");
 
        // Free memory
        SQL_FREERESULT($result_user);
 }
 //
-function RALLYE_ADD_PRICES($rallye,$mode="email")
-{
+function RALLYE_ADD_PRICES ($rallye, $mode="email") {
        // Output mode
        switch($mode) {
                case "email": $mode = "\n";     break;
@@ -148,45 +135,39 @@ function RALLYE_ADD_PRICES($rallye,$mode="email")
 
        // Load prices
        $result_prices = SQL_QUERY("SELECT price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id='".$rallye."' ORDER BY price_level", __FUNCTION__, __LINE__);
-       if (SQL_NUMROWS($result_prices) > 0)
-       {
+       if (SQL_NUMROWS($result_prices) > 0) {
                // Load prices
-               if ($mode == "\n") $prices = RALLYE_MEMBER_PRICES_ADDED.":".$mode."------------------------------".$mode;
+               if ($mode == "\n") $prices = "{--RALLYE_MEMBER_PRICES_ADDED--}:".$mode."------------------------------".$mode;
                $prices = "";
-               while (list($level, $points, $info) = SQL_FETCHROW($result_prices))
-               {
-                       $prices .= $level.RALLYE_PRICE.": ";
-                       if (!empty($info))
-                       {
-                               $prices .= $info;
-                       }
-                        else
-                       {
-                               $prices .= $points." ".POINTS;
+               while ($content = SQL_FETCHARRAY($result_prices)) {
+                       $prices .= $content['price_level'].getMessage('RALLYE_PRICE').": ";
+                       if (!empty($content['info'])) {
+                               $prices .= $content['info'];
+                       } else {
+                               $prices .= $content['points']." {!POINTS!}";
                        }
                        $prices .= "".$mode;
-               }
+               } // END - if
 
                // Free memory
                SQL_FREERESULT($result_prices);
-       }
-        else
-       {
+       } else {
                // No prices???
-               $prices = RALLYE_MEMBER_NO_PRICES.$mode;
+               $prices = sprintf(getMessage('RALLYE_MEMBER_NO_PRICES'), $mode);
        }
+
        // Add last line for email mode
        if ($mode == "\n") $prices .= "------------------------------";
 
        // Return price list
        return $prices;
 }
+
 //
-function RALLYE_ADD_TOPUSERS($rallye,$default=0)
-{
+function RALLYE_ADD_TOPUSERS ($rallye, $default=0) {
        // First check how many prices are set
        $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level",
-        array(bigintval($rallye)), __FUNCTION__, __LINE__);
+               array(bigintval($rallye)), __FUNCTION__, __LINE__);
        $prices = SQL_NUMROWS($result);
        SQL_FREERESULT($result);
 
@@ -195,7 +176,7 @@ function RALLYE_ADD_TOPUSERS($rallye,$default=0)
 LEFT JOIN `{!_MYSQL_PREFIX!}_refsystem` AS r
 ON u.userid=r.userid
 WHERE u.rallye_id=%s AND r.counter > 0 ORDER BY u.refs DESC",
- array(bigintval($rallye)), __FUNCTION__, __LINE__);
              array(bigintval($rallye)), __FUNCTION__, __LINE__);
 
        // Load users
        $DATA = array(
@@ -204,17 +185,16 @@ WHERE u.rallye_id=%s AND r.counter > 0 ORDER BY u.refs DESC",
                'cpoints'  => array()
        );
 
-       while (list($uid, $refs, $cpoints) = SQL_FETCHROW($result))
-       {
+       while ($content = SQL_FETCHARRAY($result)) {
                // Get current refs
-               $cnt = RALLYE_GET_REFCOUNT($uid, $refs);
+               $cnt = RALLYE_GET_REFCOUNT($content['userid'], $content['refs']);
 
                // Points of ref's
                $result_ref = SQL_QUERY_ESC("SELECT DISTINCT p.points FROM `{!_MYSQL_PREFIX!}_user_points` AS p
 LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
 ON p.userid=d.userid
 WHERE d.userid=%s AND d.`status`='CONFIRMED' AND p.ref_depth=1 AND d.max_mails > 0 AND d.mails_confirmed >= %s
-LIMIT 1", array(bigintval($uid), getConfig('ref_payout')), __FUNCTION__, __LINE__);
+LIMIT 1", array(bigintval($content['userid']), getConfig('ref_payout')), __FUNCTION__, __LINE__);
                list($refpoints) = SQL_FETCHROW($result_ref);
                SQL_FREERESULT($result_ref);
 
@@ -223,13 +203,13 @@ LIMIT 1", array(bigintval($uid), getConfig('ref_payout')), __FUNCTION__, __LINE_
                // Init userid for list
                $_uid = "---";
                // List only users with at least one ref!
-               //* DEBUG: */ echo "*".$cnt."/".$uid."/".$cpoints."/".$refpoints."*<br />\n";
-               if (($cnt > 0) && ($refpoints > $cpoints)) { $_uid = $uid; } else { $cnt = ""; }
+               //* DEBUG: */ echo "*".$cnt."/".$content['userid']."/".$content['curr_points']."/".$refpoints."*<br />\n";
+               if (($cnt > 0) && ($refpoints > $content['curr_points'])) { $_uid = $content['userid']; } else { $cnt = ""; }
 
                // Save values to array
                $DATA['uid'][]     = $_uid;
                $DATA['ref'][]     = $cnt;
-               $DATA['cpoints'][] = $cpoints;
+               $DATA['cpoints'][] = $content['curr_points'];
        }
 
        // Free memory
@@ -268,8 +248,7 @@ LIMIT 1", array(bigintval($uid), getConfig('ref_payout')), __FUNCTION__, __LINE_
        return $OUT;
 }
 // Run this function only when a new member has confirmed his email address!
-function RALLYE_AUTOADD_USER($uid)
-{
+function RALLYE_AUTOADD_USER ($uid) {
        global $DATA;
        $ADD = "";
 
@@ -321,25 +300,13 @@ VALUES ('%s','%s','0')",
                        // Load prices
                        $prices = RALLYE_ADD_PRICES($id);
 
-                       if ($min_users == 0) {
-                               // Rallye ends without user limitation
-                               $DATA['min_users'] = RALLYE_END_NO_USER_LIMITATION;
-                       } else {
-                               // Rallye ends when X members are totally in your exchange
-                               $DATA['min_users'] = RALLYE_END_USERS_1." ".$min_users." ".RALLYE_END_USERS_2;
-                       }
-
-                       if ($min_prices == 0) {
-                               // Rallye ends without user limitation
-                               $DATA['min_prices'] = RALLYE_END_NO_PRICE_LIMITATION;
-                       } else {
-                               // Rallye ends when X members are totally in your exchange
-                               $DATA['min_prices'] = RALLYE_END_PRICES_1." ".$min_prices." ".RALLYE_END_PRICES_2;
-                       }
+                       // Determine min_users/prices tring
+                       $DATA['min_users']  = RALLYE_DETERMINE_MIN_USERS($min_users);
+                       $DATA['min_prices'] = RALLYE_DETERMINE_MIN_PRICES($min_prices);
 
                        // Send notification to member
                        $msg = LOAD_EMAIL_TEMPLATE("member_rallye_notify", array('prices' => $prices), $uid);
-                       SEND_EMAIL($uid, RALLYE_MEMBER_NOTIFY.$title, $msg);
+                       SEND_EMAIL($uid, sprintf(getMessage('RALLYE_MEMBER_NOTIFY'), $title), $msg);
                } // END - if
        } // END - if
 }
@@ -431,7 +398,7 @@ LIMIT 1", array(bigintval($uid)), __FUNCTION__, __LINE__);
                                        $DATA['infos'] = $DATA['info'];
                                } else {
                                        // Take points
-                                       $DATA['infos'] = $DATA['points']." ".POINTS;
+                                       $DATA['infos'] = $DATA['points']." {!POINTS!}";
                                }
 
                                // Add suffix to template name
@@ -439,7 +406,7 @@ LIMIT 1", array(bigintval($uid)), __FUNCTION__, __LINE__);
 
                                // Load template
                                $msg = LOAD_EMAIL_TEMPLATE($template, $DATA, $uid);
-                               SEND_EMAIL($uid, RALLYE_MEMBER_EXPIRED.": ".$DATA['level']." "._RALLYE_PRICE, $msg);
+                               SEND_EMAIL($uid, sprintf(getMessage('RALLYE_MEMBER_EXPIRED_SUBJ'), $DATA['level']), $msg);
                        } // END - if
 
                        // Count userid
@@ -458,36 +425,44 @@ LIMIT 1", array(bigintval($uid)), __FUNCTION__, __LINE__);
        }
 
        // Send mail to admin
-       SEND_ADMIN_NOTIFICATION(RALLYE_ADMIN_EXPIRED.": ".$title, $templ, $cnt, 0);
+       SEND_ADMIN_NOTIFICATION(sprintf(getMessage('RALLYE_ADMIN_EXPIRED_SUBJ'), $title), $templ, $cnt, 0);
 
        // Add task
        SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_task_system` (status, task_type, subject, text, task_created)
-VALUES ('NEW','RALLYE_EXPIRED','".RALLYE_ADMIN_EXPIRED.": %s','".RALLYE_ADMIN_EXPIRED_TEXT."',UNIX_TIMESTAMP())",
- array($title), __FUNCTION__, __LINE__);
+VALUES ('NEW','RALLYE_EXPIRED','{--RALLYE_ADMIN_EXPIRED--}: %s','{--RALLYE_ADMIN_EXPIRED_TEXT--}',UNIX_TIMESTAMP())",
              array($title), __FUNCTION__, __LINE__);
 
        // All work done here...
 }
+
 //
-function RALLYE_LOAD_USER_DATA($uids_array)
-{
+function RALLYE_LOAD_USER_DATA ($uids_array) {
        // Implode user ids
        $uid_string = implode(",", $uids_array['uid']);
 
+       // Init result string
+       $ret = "";
+
        // Load users
        $result = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid IN(%s) AND `status`='CONFIRMED' ORDER BY userid LIMIT %s",
-        array($uid_string, count($uids_array)), __FUNCTION__, __LINE__);
-       $ret = "";
-       while (list($u, $gender, $surname, $family, $email) = SQL_FETCHROW($result))
-       {
-               $ret .= TRANSLATE_GENDER($gender)." ".$surname." ".$family." (".$email.") - ".$uids_array['poi'][$u]."\n";
-       }
+               array($uid_string, count($uids_array)), __FUNCTION__, __LINE__);
+       while ($content = SQL_FETCHARRAY($result)) {
+               // Construct the message masked and add it
+               $ret .= sprintf("%s %s %s (%s) - %s\n",
+                       TRANSLATE_GENDER($content['gender']),
+                       $content['surname'],
+                       $content['family'],
+                       $content['email'],
+                       $uids_array['poi'][$content['userid']]
+               );
+       } // END - while
 
        // Return result
        return substr($ret, 0, -1);
 }
+
 //
-function RALLYE_LOAD_PRICES_ARRAY($rallye)
-{
+function RALLYE_LOAD_PRICES_ARRAY ($rallye) {
        // Init multi array
        $prices = array(
                'level'  => array(),
@@ -497,13 +472,14 @@ function RALLYE_LOAD_PRICES_ARRAY($rallye)
 
        // Load prices
        $result = SQL_QUERY_ESC("SELECT price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level",
-        array(bigintval($rallye)), __FUNCTION__, __LINE__);
-       while (list($level, $points, $info) = SQL_FETCHROW($result))
-       {
-               $prices['level'][]  = $level;
-               $prices['points'][] = $points;
-               $prices['info'][]   = $info;
-       }
+               array(bigintval($rallye)), __FUNCTION__, __LINE__);
+
+       // Transfer elements
+       while ($content = SQL_FETCHARRAY($result)) {
+               $prices['level'][]  = $content['price_level'];
+               $prices['points'][] = $content['points'];
+               $prices['info'][]   = $content['info'];
+       } // END - while
 
        // Free memory
        SQL_FREERESULT($result);
@@ -527,9 +503,9 @@ function RALLYE_LOAD_USERS_ARRAY ($rallye) {
        // Load users                          uid    old  points earned
        $result_user = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s ORDER BY userid",
                array(bigintval($rallye)), __FUNCTION__, __LINE__);
-       while (list($uid, $refs, $cpoints) = SQL_FETCHROW($result_user)) {
+       while ($content = SQL_FETCHARRAY($result_user)) {
                // Load current ref count
-               $cnt = RALLYE_GET_REFCOUNT($uid, $refs);
+               $cnt = RALLYE_GET_REFCOUNT($content['userid'], $content['refs']);
 
                // Points of ref's
                $result_ref = SQL_QUERY_ESC("SELECT DISTINCT SUM(p.points)
@@ -537,16 +513,17 @@ FROM `{!_MYSQL_PREFIX!}_user_points` AS p
 LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
 ON p.userid=d.userid
 WHERE d.`status`='CONFIRMED' AND d.max_mails > 0 AND d.mails_confirmed >= %s AND p.ref_depth=1 AND p.points > 0 AND d.userid=%s",
-                       array(getConfig('ref_payout'), bigintval($uid)), __FUNCTION__, __LINE__);
+                       array(getConfig('ref_payout'), bigintval($content['userid'])), __FUNCTION__, __LINE__);
                list($refpoints) = SQL_FETCHROW($result_ref);
                SQL_FREERESULT($result_ref);
 
+               // Fix empty refpoints
                if (empty($refpoints)) $refpoints = 0;
 
                // Store calculated new refs to array
-               $users['uid'][]     = $uid;
-               $users['ref'][]     = abs($cnt - $refs);
-               $users['cpoints'][] = $refpoints - $cpoints;
+               $users['uid'][]     = $content['userid'];
+               $users['ref'][]     = abs($cnt - $content['refs']);
+               $users['cpoints'][] = $refpoints - $content['curr_points'];
        }
 
        // Free memory
@@ -613,7 +590,7 @@ function RALLYE_LIST_WINNERS ($rallye, $default=0) {
                 else
                {
                        // Take ppints
-                       $DATA['infos'][$idx] = $DATA['points'][$idx]." ".POINTS;
+                       $DATA['infos'][$idx] = $DATA['points'][$idx]." {!POINTS!}";
                }
 
                // Add row
@@ -644,9 +621,9 @@ function RALLYE_LIST_WINNERS ($rallye, $default=0) {
        // And finnally return the output
        return $OUT;
 }
+
 //
-function RALLYE_DELETE_EXPIRED_RALLYES()
-{
+function RALLYE_DELETE_EXPIRED_RALLYES () {
        global $DATA;
 
        // Check for expired rallyes
@@ -656,34 +633,39 @@ FROM `{!_MYSQL_PREFIX!}_rallye_data`
 WHERE end_time <= (UNIX_TIMESTAMP() - %s) AND expired='Y'",
                array($EXPIRE), __FUNCTION__, __LINE__);
 
-       if (SQL_NUMROWS($result_rallye) > 0)
-       {
+       if (SQL_NUMROWS($result_rallye) > 0) {
+               // Init SQLs
+               INIT_SQLS();
+
                // Expire found rallyes and notify admin
-               while (list($id, $title, $start, $end) = SQL_FETCHROW($result_rallye))
-               {
+               while ($content = SQL_FETCHARRAY($result_rallye)) {
                        // Prepare data for mail template
-                       $DATA['title']  = $title;
-                       $DATA['start']  = MAKE_DATETIME($start, "1");
-                       $DATA['end']    = MAKE_DATETIME($end  , "1");
+                       $DATA['title']  = $content['title'];
+                       $DATA['start']  = MAKE_DATETIME($content['start_time'], "1");
+                       $DATA['end']    = MAKE_DATETIME($content['end_time']  , "1");
                        $DATA['now_t']  = MAKE_DATETIME(time(), "1");
 
                        // Send mail to admin
-                       SEND_ADMIN_NOTIFICATION(RALLYE_ADMIN_PURGED.": ".$title, "admin_rallye_purged", "", 0);
+                       SEND_ADMIN_NOTIFICATION(sprintf(getMessage('RALLYE_ADMIN_PURGED_SUBJ'), $content['title']), "admin_rallye_purged", "", 0);
 
                        // Purge whole rallye
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_data` WHERE id=%s LIMIT 1",
-                               array(bigintval($id)), __FUNCTION__, __LINE__);
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s LIMIT 1",
-                               array(bigintval($id)), __FUNCTION__, __LINE__);
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s LIMIT 1",
-                               array(bigintval($id)), __FUNCTION__, __LINE__);
-               }
-
-               // Add task
-               SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_task_system` (status, task_type, subject, text, task_created)
+                       ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_data` WHERE id=%s LIMIT 1",
+                               array(bigintval($content['id'])), __FUNCTION__, __LINE__, false));
+                       ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s LIMIT 1",
+                               array(bigintval($content['id'])), __FUNCTION__, __LINE__, false));
+                       ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s LIMIT 1",
+                               array(bigintval($content['id'])), __FUNCTION__, __LINE__, false));
+
+                       // Add task
+                       // @TODO Rewrite this to a function
+                       ADD_SQL(SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_task_system` (status, task_type, subject, text, task_created)
 VALUES ('NEW','RALLYE_PURGED','{--RALLYE_ADMIN_PURGED--}: %s','{--RALLYE_ADMIN_PURGED_TEXT--}',UNIX_TIMESTAMP())",
-                       array($title), __FUNCTION__, __LINE__);
-       }
+                               array($content['title']), __FUNCTION__, __LINE__, false));
+               } // END - while
+
+               // Run all SQLs
+               runFilterChain('run_sqls');
+       } // END - if
 
        // Free memory
        SQL_FREERESULT($result_rallye);
@@ -732,7 +714,7 @@ function RALLYE_TEMPLATE_SELECTION($name="template", $default="")
        return $OUT;
 }
 //
-function RALLYE_GET_REFCOUNT($uid, $old=0) {
+function RALLYE_GET_REFCOUNT ($uid, $old=0) {
        // Check current refs
        if (GET_EXT_VERSION("cache") >= "0.1.2") {
                // Get refs from cache
@@ -792,6 +774,34 @@ WHERE s.userid=%s AND s.level=1", array(bigintval($uid)), __FUNCTION__, __LINE__
        return $cnt;
 }
 
+// Determines the right language string for min_users
+function RALLYE_DETERMINE_MIN_USERS ($min_users) {
+       // Rallye ends without user limitation is the default
+       $return = getMessage('RALLYE_END_NO_USER_LIMITATION');
+
+       if ($min_users > 0) {
+               // Rallye ends when X members are totally in your exchange
+               $return = sprintf(getMessage('RALLYE_END_USERS'), $min_users);
+       } // END - if
+
+       // Return
+       return $return;
+}
+
+// Determines the right language string for min_prices
+function RALLYE_DETERMINE_MIN_PRICES ($min_prices) {
+       // Rallye ends without user limitation is the default
+       $return = getMessage('RALLYE_END_NO_PRICE_LIMITATION');
+
+       if ($min_prices > 0) {
+               // Rallye ends when X members are totally in your exchange
+               $return = sprintf(getMessage('RALLYE_END_PRICES'), $min_prices);
+       } // END - if
+
+       // Return
+       return $return;
+}
+
 // Filter for extra-autpurge
 function FILTER_RALLYE_EXTRA_AUTOPURGE () {
        // Check expired rallyes (hard-coded 3 days limit for displaying expired rallyes!)