- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET notified='Y' WHERE `id`=%s LIMIT 1",
- 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');
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `notified`='Y' WHERE `id`=%s LIMIT 1",
+ array(bigintval($id)), __FUNCTION__, __LINE__);
+
+ // Transfer all neccessary data to the $DATA array
+ $DATA['userid_cnt'] = countSumTotalData('CONFIRMED','user_data','userid','status',true);
+ $DATA['start'] = generateDateTime($start, 2);
+ $DATA['end'] = generateDateTime($end , 2);
+ $DATA['now_t'] = generateDateTime(time(), 2);