コード例 #1
0
 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;
 }
コード例 #2
0
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");
    }
}