* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009, 2010 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// Add userid and his ref count to table
$result_ref = SQL_QUERY_ESC("SELECT
- SUM(p.points) AS points
+ SUM(p.points) AS `points`
FROM
`{?_MYSQL_PREFIX?}_user_points` AS p
LEFT JOIN
// Free result
SQL_FREERESULT($result);
- // Load users array (!) with assigned prices
- $prices = getArrayFromReferalRallyeUsers($id);
-
// Init array
$DATA = array();
$count = '0';
$DATA['end'] = generateDateTime($end , 1);
$DATA['now_t'] = generateDateTime(time(), 1);
+ // Load users array (!) with assigned prices
+ $prices = getArrayFromReferalRallyeUsers($id);
+
// Just count...
$total = '0';
foreach ($prices['userid'] as $key => $userid) {
// Check status
// active = 1: account is still confirmed
// active = 0: account is deleted or locked
- $active = countSumTotalData($DATA['userid'][$idx], 'user_data', 'userid', 'userid', true, " AND `status`='CONFIRMED'");
+ $active = countSumTotalData($userid, 'user_data', 'userid', 'userid', true, " AND `status`='CONFIRMED'");
$prices['active'][$key] = $active;
), __FUNCTION__, __LINE__);
while ($content = SQL_FETCHARRAY($result)) {
// Construct the message masked and add it
- $ret .= sprintf("%s %s %s (%s) - %s\n",
- translateGender($content['gender']),
+ $ret .= sprintf("{%%pipe,translateGender=%s%} %s %s (%s) - %s\n",
+ $content['gender'],
$content['surname'],
$content['family'],
$content['email'],
// Points of ref's
$result_ref = SQL_QUERY_ESC("SELECT
- SUM(p.points) AS points
+ SUM(p.points) AS `points`
FROM
`{?_MYSQL_PREFIX?}_user_points` AS p
LEFT JOIN
// Accept only template names between 1 and 255 chars length
if ((strlen($read) < 256) && (!empty($read))) {
- // Valid entry found!
+ // Valid entry found
$ral[$read] = $read;
} else {
// Log invalid
return $return;
}
-// Filter for extra-autpurge
-function FILTER_RALLYE_EXTRA_AUTOPURGE () {
- // Check expired rallyes (hard-coded 3 days limit for displaying expired rallyes!)
- purgeExpiredReferalRallyes();
-}
-
// [EOF]
?>