if (isGetRequestElementSet('activate')) {
// Activate / deactivate
switch (getRequestElement('activate')) {
- case 1: // Activate
+ 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
+ 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)
);
} elseif (isGetRequestElementSet('notify')) {
// Automatic notification
switch (getRequestElement('notify')) {
- case 1: // Activate
+ 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
+ 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)
);
} elseif (isGetRequestElementSet('auto')) {
// Automatic adding of new members
switch (getRequestElement('auto')) {
- case 1: // Activate
+ 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
+ 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)
);