$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;
}
}
