// Check for new started but not notified rallyes
$result = SQL_QUERY("SELECT SQL_SMALL_RESULT
- d.`id`,
- d.`title`,
- d.`start_time`,
- d.`end_time`,
- d.`send_notify`
+ `d`.`id`,
+ `d`.`title`,
+ `d`.`start_time`,
+ `d`.`end_time`,
+ `d`.`send_notify`
" . $sqlAddons['add'] . "
FROM
- `{?_MYSQL_PREFIX?}_rallye_data` AS d
+ `{?_MYSQL_PREFIX?}_rallye_data` AS `d`
WHERE
- d.`is_active`='Y' AND
- d.`notified`='N' AND
- d.`expired`='N' AND
- d.`start_time` <= UNIX_TIMESTAMP() AND
- d.`end_time` > UNIX_TIMESTAMP()
+ `d`.`is_active`='Y' AND
+ `d`.`notified`='N' AND
+ `d`.`expired`='N' AND
+ `d`.`start_time` <= UNIX_TIMESTAMP() AND
+ `d`.`end_time` > UNIX_TIMESTAMP()
LIMIT 1", __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Start rallye
// Check for expired rallyes
$result = SQL_QUERY("SELECT SQL_SMALL_RESULT
- d.`id`,
- d.`title`,
- d.`start_time`,
- d.`end_time`,
- d.`send_notify`
+ `d`.`id`,
+ `d`.`title`,
+ `d`.`start_time`,
+ `d`.`end_time`,
+ `d`.`send_notify`
" . $sqlAddons['add'] . "
FROM
- `{?_MYSQL_PREFIX?}_rallye_data` AS d
+ `{?_MYSQL_PREFIX?}_rallye_data` AS `d`
WHERE
- d.`is_active`='Y' AND
- d.`notified`='Y' AND
- d.`expired`='N' AND
- (d.`end_time` <= UNIX_TIMESTAMP()" . $sqlAddons['or'] . ")
+ `d`.`is_active`='Y' AND
+ `d`.`notified`='Y' AND
+ `d`.`expired`='N' AND
+ (`d`.`end_time` <= UNIX_TIMESTAMP()" . $sqlAddons['or'] . ")
LIMIT 1", __FILE__, __LINE__);
if ((SQL_NUMROWS($result) == 1) && (isExtensionActive('autopurge'))) {
// End rallye here...
if (isExtensionInstalledAndNewer('rallye', '0.2.0')) {
// Add more data on higher versions
$filterData['add'] .= ',`min_users`, `min_prices`';
- $filterData['or'] .= ' OR (d.`min_users` <= ' . getTotalConfirmedUser() . ' AND d.`min_users` > 0)';
+ $filterData['or'] .= ' OR (`d`.`min_users` <= ' . getTotalConfirmedUser() . ' AND `d`.`min_users` > 0)';
} // END - if
// Return data