if (isGetRequestElementSet('activate')) {
// Activate / deactivate
switch (getRequestElement('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"
+ 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(SQL_QUERY_ESC("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(SQL_QUERY_ESC("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(SQL_QUERY_ESC("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(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"
+ 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(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"
+ 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;
$SW = 3 - $SW;
} // END - while
+ // Remember rows
+ $content['rows'] = $OUT;
+ $content['rallye'] = getRequestElement('rallye');
+
// Free memory
SQL_FREERESULT($result);
// Load template
- loadTemplate('admin_list_rallye_usr', false, $OUT);
+ loadTemplate('admin_list_rallye_usr', false, $content);
} else {
// No entries found?
loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ADMIN_USERS_404'));
$row = array(
'select' => "<input type=\"checkbox\" name=\"sel[".$data['id']."]\" class=\"admin_normal\" value=\"1\" />",
'admin_id' => $data['admin_id'],
- 'email_link' => generateEmailLink($data['admin_id']),
+ 'admin_link' => generateAdminLink($data['admin_id']),
'login' => $data['login'],
'id' => $data['id'],
'sw' => $SW,
// 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':