$sql_query = 'SELECT `m`.`group_id` `id`, `m`.`active`, `m`.`display_columns`, `m`.`display_width`, `m`.`display_height`, `m`.`display_extension`, `m`.`display_name`, `m`.`display_forw`, `m`.`display_comment` FROM `monitor_groups` `m` WHERE `m`.`user_id` = ' . $user_id; $rs = $DB->execute($sql_query); if ($rs) { while ($r = $rs->fetchRow()) { group_defaults($groups[$r['id']], $r); } } $sql_query = 'SELECT `display_x`, `display_y`, `columns`, `update`, `reload` FROM `monitor` WHERE `user_id` = ' . $user_id . ' AND `type` = 2 LIMIT 1'; $rs = $DB->execute($sql_query); $extmon_data = array(); $extmon_data['columns'] = 2; $extmon_data['update'] = 2; $extmon_data['reload'] = 120; if ($rs->numRows() == 1) { $r = $rs->fetchRow(); foreach ($r as $key => $value) {
function group_save() { $q = new mysql_squid_builder(); $ID = $_POST["editgroupid"]; if ($ID == 0) { $sql = "INSERT IGNORE INTO nginx_exploits_groups (`groupname`) \n\t\tVALUES ('{$_POST["groupname"]}')"; $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; return; } $ID = $q->last_id; if ($_POST["servername"] != null) { $zmd5 = md5("{$ID}{$_POST["servername"]}"); $sql = "INSERT IGNORE INTO nginx_exploits (`zmd5`,`groupid`,`servername`)\n\t\t\tVALUES ('{$zmd5}',{$ID},'{$_POST["servername"]}')"; $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; return; } } if ($_POST["addef"] == 1) { group_defaults($ID); } return; } $q->QUERY_SQL("UPDATE nginx_exploits_groups SET `groupname`='{$_POST["groupname"]}',\n\t`enabled`='{$_POST["enabled"]}' WHERE ID={$ID}"); if (!$q->ok) { echo $q->mysql_error; return; } }
function group_save() { $_POST["groupname"] = mysql_escape_string2(url_decode_special_tool($_POST["groupname"])); $q = new mysql_squid_builder(); if (!$q->FIELD_EXISTS("nginx_exploits_groups", "enabled")) { $q->QUERY_SQL("ALTER TABLE `nginx_exploits_groups` ADD `enabled` smallint(1) NOT NULL DEFAULT '1', ADD INDEX ( `enabled`)"); if (!$q->ok) { echo $q->mysql_error . "\nLine: " . __LINE__; return; } } $ID = $_POST["editgroupid"]; if ($ID == 0) { $sql = "INSERT IGNORE INTO nginx_exploits_groups (`groupname`)\n\t\tVALUES ('{$_POST["groupname"]}')"; $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; return; } $ID = $q->last_id; if ($_POST["servername"] != null) { $zmd5 = md5("{$ID}{$_POST["servername"]}"); $sql = "INSERT IGNORE INTO nginx_exploits (`zmd5`,`groupid`,`servername`)\n\t\tVALUES ('{$zmd5}',{$ID},'{$_POST["servername"]}')"; $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; return; } } if ($_POST["addef"] == 1) { group_defaults($ID); } return; } $q->QUERY_SQL("UPDATE nginx_exploits_groups SET `groupname`='{$_POST["groupname"]}',`enabled`='{$_POST["enabled"]}' WHERE ID={$ID}"); if (!$q->ok) { echo $q->mysql_error; return; } }