// Set notified to Y
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET notified='Y' WHERE `id`=%s LIMIT 1",
- array(bigintval($id)), __FUNCTION__, __LINE__);
+ array(bigintval($id)), __FUNCTION__, __LINE__);
// Do a snapshot off all user refs
$result_user = SQL_QUERY("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC", __FUNCTION__, __LINE__);
// Transfer all neccessary data to the global $DATA array
$DATA['uid_cnt'] = SQL_NUMROWS($result_user);
- $DATA['start'] = generateDateTime($start, "2");
- $DATA['end'] = generateDateTime($end , "2");
- $DATA['now_t'] = generateDateTime(time(), "2");
+ $DATA['start'] = generateDateTime($start, '2');
+ $DATA['end'] = generateDateTime($end , '2');
+ $DATA['now_t'] = generateDateTime(time(), '2');
$DATA['title'] = $title;
$DATA['id'] = $id; // ID for the rallye details link
// 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($content['userid'])), __FUNCTION__, __LINE__);
+ array(bigintval($id), bigintval($content['userid'])), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result_ref) == 0) {
// Free memory
SQL_FREERESULT($result_ref);
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($content['userid'])), __FUNCTION__, __LINE__);
+ array(getConfig('ref_payout'), bigintval($content['userid'])), __FUNCTION__, __LINE__);
list($cpoints) = SQL_FETCHROW($result_ref);
SQL_FREERESULT($result_ref);
// 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($content['userid']), bigintval($cnt), $cpoints), __FUNCTION__, __LINE__);
+ array(bigintval($id), bigintval($content['userid']), bigintval($cnt), $cpoints), __FUNCTION__, __LINE__);
$un = true;
} // END - if
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);
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(
// Check if line is already included...
$result = 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($uid)), __FUNCTION__, __LINE__);
// Is this user added?
if (SQL_NUMROWS($result) == 0) {
// Add userid and his ref count to table
SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_rallye_users` (rallye_id, userid, refs)
VALUES ('%s','%s','0')",
- array(bigintval($id), bigintval($uid)), __FUNCTION__, __LINE__);
+ array(bigintval($id), bigintval($uid)), __FUNCTION__, __LINE__);
} // END - if
// Free memory
if ($notify == 'Y') {
// Transfer all neccessary data to the global $DATA array
- $DATA['start'] = generateDateTime($start, "2");
- $DATA['end'] = generateDateTime($end , "2");
- $DATA['now_t'] = generateDateTime(time(), "2");
+ $DATA['start'] = generateDateTime($start, '2');
+ $DATA['end'] = generateDateTime($end , '2');
+ $DATA['now_t'] = generateDateTime(time(), '2');
$DATA['title'] = $title;
$DATA['id'] = $id; // ID for the rallye details link
$DATA['ref'] = 0;
$DATA = array(); $cnt = 0;
$users = array();
$DATA['title'] = $title;
- $DATA['start'] = generateDateTime($start, "1");
- $DATA['end'] = generateDateTime($end , "1");
- $DATA['now_t'] = generateDateTime(time(), "1");
+ $DATA['start'] = generateDateTime($start, '1');
+ $DATA['end'] = generateDateTime($end , '1');
+ $DATA['now_t'] = generateDateTime(time(), '1');
// Just count...
$total = 0;
// Expire rallye
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET expired='Y' WHERE `id`=%s LIMIT 1",
- array(bigintval($id)), __FUNCTION__, __LINE__);
+ array(bigintval($id)), __FUNCTION__, __LINE__);
// Run array through (by uid is the most important 2nd-level-array)
foreach($prices['uid'] as $key => $uid) {
// 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__);
+ array($title), __FUNCTION__, __LINE__);
// All work done here...
}
//
function RALLYE_LOAD_USER_DATA ($uids_array) {
// Implode user ids
- $uid_string = implode(",", $uids_array['uid']);
+ $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__);
+ 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",
- translateGender($content['gender']),
- $content['surname'],
- $content['family'],
- $content['email'],
- $uids_array['poi'][$content['userid']]
+ translateGender($content['gender']),
+ $content['surname'],
+ $content['family'],
+ $content['email'],
+ $uids_array['poi'][$content['userid']]
);
} // END - while
// 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__);
+ array(bigintval($rallye)), __FUNCTION__, __LINE__);
// Transfer elements
while ($content = SQL_FETCHARRAY($result)) {
// 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` ASC",
- array(bigintval($rallye)), __FUNCTION__, __LINE__);
+ array(bigintval($rallye)), __FUNCTION__, __LINE__);
while ($content = SQL_FETCHARRAY($result_user)) {
// Load current ref count
$cnt = RALLYE_GET_REFCOUNT($content['userid'], $content['refs']);
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($content['userid'])), __FUNCTION__, __LINE__);
+ array(getConfig('ref_payout'), bigintval($content['userid'])), __FUNCTION__, __LINE__);
list($refpoints) = SQL_FETCHROW($result_ref);
SQL_FREERESULT($result_ref);
function RALLYE_LIST_WINNERS ($rallye, $default=0) {
// First check how many prices are set
$result_prices = 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_prices);
SQL_FREERESULT($result_prices);
// active = 1: account is still confirmed
// active = 0: account is deleted or locked
$result_active = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s AND `status`='CONFIRMED' LIMIT 1",
- array(bigintval($DATA['uid'][$idx])), __FUNCTION__, __LINE__);
+ array(bigintval($DATA['uid'][$idx])), __FUNCTION__, __LINE__);
list($active) = SQL_FETCHROW($result_active);
SQL_FREERESULT($result_active);
$result_rallye = SQL_QUERY_ESC("SELECT id, title, start_time, end_time
FROM `{!_MYSQL_PREFIX!}_rallye_data`
WHERE end_time <= (UNIX_TIMESTAMP() - %s) AND expired='Y'",
- array($EXPIRE), __FUNCTION__, __LINE__);
+ array($EXPIRE), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result_rallye) > 0) {
// Init SQLs
while ($content = SQL_FETCHARRAY($result_rallye)) {
// Prepare data for mail template
$DATA['title'] = $content['title'];
- $DATA['start'] = generateDateTime($content['start_time'], "1");
- $DATA['end'] = generateDateTime($content['end_time'] , "1");
- $DATA['now_t'] = generateDateTime(time(), "1");
+ $DATA['start'] = generateDateTime($content['start_time'], '1');
+ $DATA['end'] = generateDateTime($content['end_time'] , '1');
+ $DATA['now_t'] = generateDateTime(time(), '1');
// Send mail to admin
sendAdminNotification(sprintf(getMessage('RALLYE_ADMIN_PURGED_SUBJ'), $content['title']), "admin_rallye_purged", '', 0);
// Purge whole rallye
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));
+ 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));
+ 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));
+ 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($content['title']), __FUNCTION__, __LINE__, false));
+ array($content['title']), __FUNCTION__, __LINE__, false));
} // END - while
// Run all SQLs
projects / mailer.git / blobdiff