function uid_to_tablename($uid) { $uid = trim($uid); if (preg_match("#(.+?)\\/(.+)#", $uid, $re)) { $uid = $re[2]; } if (!class_exists("class.html.tools.inc")) { include_once dirname(__FILE__) . "/class.html.tools.inc"; } $t = new htmltools_inc(); $uid = $t->replace_accents($uid); $uid = str_replace("\$", "", $uid); $uid = str_replace(" ", "_", $uid); return $uid; }
function route_save() { include_once dirname(__FILE__) . "/class.html.tools.inc"; $html = new htmltools_inc(); $ID = $_POST["ID"]; $RouteName = trim(strtolower($html->replace_accents($_POST["RouteName"]))); $RouteName = str_replace(" ", "", $RouteName); $RouteName = str_replace("/", "", $RouteName); $RouteName = str_replace("#", "", $RouteName); $RouteName = str_replace("\$", "", $RouteName); $ADD = false; if ($ID == 0) { $sql = "INSERT INTO routing_rules (`RouteName`,`nic`,`enabled`)\n\t\tVALUES('{$RouteName}','{$_POST["nic"]}',1);"; $eth = $_POST["nic"]; $ADD = true; } else { $sql = "UPDATE routing_rules SET\n\t\t\t\t`RouteName`='{$RouteName}',\n\t\t\t\t`nic`='{$_POST["nic"]}',\n\t\t\t\t`enabled`='{$_POST["enabled"]}'\n\t\t\t\t WHERE `ID`='{$ID}'"; } $q = new mysql(); $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { echo $q->mysql_error; return; } if ($ADD) { $ruleid = $q->last_id; $nicClass = new system_nic($eth); $metric = $ruleid + 1; $tr = explode(".", $nicClass->IPADDR); unset($tr[3]); $ipf = @implode(".", $tr) . ".0"; $sql = "INSERT INTO routing_rules_dest (`type`,`gateway`,`pattern`,`ruleid`,`nic`,`metric`,`zOrder`)\n\t\tVALUES('1','','{$ipf}/{$nicClass->NETMASK}','{$ruleid}','{$eth}','{$metric}','1');"; $q->QUERY_SQL($sql, "artica_backup"); } }