// Add info line
SQL_QUERY_ESC("INSERT INTO
`{?_MYSQL_PREFIX?}_rallye_users`
-(`rallye_id`, `userid`, `refs`, `curr_points`)
+(`rallye_id`,`userid`,`refs`,`curr_points`)
VALUES
(%s, %s, %s, %s)",
array(
// Load prices
$result_prices = SQL_QUERY_ESC("SELECT
- `price_level`, `points`, `info`
+ `price_level`,`points`,`info`
FROM
`{?_MYSQL_PREFIX?}_rallye_prices`
WHERE
}
//
-function addReferalRallyeTopUsers ($rallye, $default=0) {
+function addReferalRallyeTopUsers ($mode, $rallye, $default=0) {
// Init variables
$min_users = 0; $min_prices = 0;
);
// Load row template and switch color
- $OUT .= loadTemplate('guest_rallye_row', true, $content);
+ $OUT .= loadTemplate($mode . '_list_rallye_row', true, $content);
} // END - for
// Add min_prices/users
$content['min_users'] = bigintval($min_users);
// And finnally return the output
- return loadTemplate('guest_rallye', true, $content);
+ return loadTemplate($mode . '_list_rallye', true, $content);
}
// Run this function only when a new member has confirmed his email address!
// Updated extension?
if (isExtensionInstalledAndNewer('rallye', '0.2.0')) {
- $add .= ', `min_users`, `min_prices`';
+ $add .= ', `min_users`,`min_prices`';
} // END - if
// Check for an auto-add rallye
$result = SQL_QUERY("SELECT
- `id`, `title`, `start_time`, `end_time`, `send_notify`".$add."
+ `id`,`title`,`start_time`,`end_time`,`send_notify`".$add."
FROM
`{?_MYSQL_PREFIX?}_rallye_data`
WHERE
// Add userid and his ref count to table
SQL_QUERY_ESC("INSERT INTO
`{?_MYSQL_PREFIX?}_rallye_users`
-(`rallye_id`, `userid`, `refs`)
+(`rallye_id`,`userid`,`refs`)
VALUES
(%s,%s,0)",
array(
//
function markReferalRallyesAsExpired ($result) {
+ // @TODO Deprecated variable and global statement, please try to rewrite this
global $DATA;
// Load rallye data
// Determine winner level
if ($DATA['level'] == 1) {
// The winner!
- $winnerLevel = '_gold';
+ $winnerLevel = 'gold';
} elseif ($DATA['level'] == 2) {
// The vice winner!
- $winnerLevel = '_silver';
+ $winnerLevel = 'silver';
} elseif ($DATA['level'] == 3) {
// The bronce winner
- $winnerLevel = '_bronce';
+ $winnerLevel = 'bronce';
}
if ($DATA['points'] > 0) {
// Add points directly to user's account
- addPointsDirectly('rallye_winner' . $winnerLevel, $userid, $DATA['points']);
+ initReferalSystem();
+ addPointsThroughReferalSystem('rallye_winner:' . $winnerLevel, $userid, $DATA['points']);
} // END - if
if ($notify == 'Y') {
// Load users
$result = SQL_QUERY_ESC("SELECT
- `userid`, `gender`, `surname`, `family`, `email`
+ `userid`,`gender`,`surname`,`family`,`email`
FROM
`{?_MYSQL_PREFIX?}_user_data`
WHERE
// Load prices
$result = SQL_QUERY_ESC("SELECT
- `price_level`, `points`, `info`
+ `price_level`,`points`,`info`
FROM
`{?_MYSQL_PREFIX?}_rallye_prices`
WHERE
);
// Load users userid 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` ASC",
+ $result_user = SQL_QUERY_ESC("SELECT `userid`,`refs`,`curr_points` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s ORDER BY `userid` ASC",
array(bigintval($rallye)), __FUNCTION__, __LINE__);
while ($content = SQL_FETCHARRAY($result_user)) {
// Load current ref count
}
// @TODO This function does not load min_users, min_prices, please encapsulate loading rallye data with e.g. getRallyeDataFromId()
-function addReferalRallyeWinners ($rallye, $default=0) {
+function addReferalRallyeWinners ($mode, $rallye, $default=0) {
// First check how many prices are set
$prices = countSumTotalData(bigintval($rallye), 'rallye_prices', 'id', 'rallye_id', true);
);
// Load row template
- $OUT .= loadTemplate('guest_rallye_row', true, $content);
+ $OUT .= loadTemplate($mode . '_list_rallye_row', true, $content);
} // END - for
// Prepare content
);
// Load main template and finnally return the output
- return loadTemplate('guest_rallye', true, $content);
+ return loadTemplate($mode . '_list_rallye', true, $content);
}
//
// Check for expired rallyes
$EXPIRE = 3; // @TODO The hard-coded value...
$result_rallye = SQL_QUERY_ESC("SELECT
- `id`, `title`, `start_time`, `end_time`
+ `id`,`title`,`start_time`,`end_time`
FROM
`{?_MYSQL_PREFIX?}_rallye_data`
WHERE