if (isGetRequestElementSet('activate')) {
// Activate / deactivate
switch (getRequestElement('activate')) {
- case 1: // Activate
- addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1");
+ case '1': // Activate
+ addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1",
+ array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+ );
break;
- case 0: // Deactivate
- addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1");
+ case '0': // Deactivate
+ addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1",
+ array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+ );
break;
}
} elseif (isGetRequestElementSet('notify')) {
// Automatic notification
switch (getRequestElement('notify')) {
- case 1: // Activate
- addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1");
+ case '1': // Activate
+ addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1",
+ array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+ );
break;
- case 0: // Deactivate
- addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1");
+ case '0': // Deactivate
+ addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1",
+ array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+ );
break;
}
} elseif (isGetRequestElementSet('auto')) {
// Automatic adding of new members
switch (getRequestElement('auto')) {
- case 1: // Activate
- addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='Y' WHERE `id`=%s AND `auto_add_new_user`='N' LIMIT 1");
+ case '1': // Activate
+ addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='Y' WHERE `id`=%s AND `auto_add_new_user`='N' LIMIT 1",
+ array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+ );
break;
- case 0: // Deactivate
- addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='N' WHERE `id`=%s AND `auto_add_new_user`='Y' LIMIT 1");
+ case '0': // Deactivate
+ addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='N' WHERE `id`=%s AND `auto_add_new_user`='Y' LIMIT 1",
+ array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+ );
break;
}
}
foreach (postRequestElement('sel') as $id => $selected) {
// Remove selected rallye entirely...
addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__, false));
+ array(bigintval($id)), __FILE__, __LINE__, false));
addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s",
- array(bigintval($id)), __FILE__, __LINE__, false));
+ array(bigintval($id)), __FILE__, __LINE__, false));
addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE rallye_id=%s",
- array(bigintval($id)), __FILE__, __LINE__, false));
+ array(bigintval($id)), __FILE__, __LINE__, false));
} // END - foreach
// Run SQLS
// Rallye is active so do not edit it!
$row['select'] = "<div class=\"big\">".$row['id']."</div>";
$row['active_title'] = getMessage('RALLYE_DEACTIVATE_NOW');
- $row['active'] = 0;
+ $row['active'] = '0';
break;
case 'N':
switch ($data['send_notify']) {
case 'Y':
$row['notify_title'] = getMessage('RALLYE_STOP_NOTIFY_NOW');
- $row['notify'] = 0;
+ $row['notify'] = '0';
break;
case 'N':
switch ($data['auto_add_new_user']) {
case 'Y':
$row['auto_title'] = getMessage('RALLYE_STOP_AUTO_ADD_NOW');
- $row['auto'] = 0;
+ $row['auto'] = '0';
break;
case 'N':