コード例 #1
0
function rule_save()
{
    $q = new mysql_builder();
    $_POST["rulename"] = mysql_escape_string2(url_decode_special_tool($_POST["rulename"]));
    if (!$q->FIELD_EXISTS("artica_caches", "MaxSizeBytes", "artica_backup")) {
        $sql = "ALTER TABLE `artica_caches` ADD `MaxSizeBytes` BIGINT UNSIGNED NOT NULL DEFAULT '3145728000'";
        $q->QUERY_SQL($sql, "artica_backup");
    }
    if (!$q->FIELD_EXISTS("artica_caches", "FileTypes", "artica_backup")) {
        $sql = "ALTER TABLE `artica_caches` ADD `FileTypes` TEXT";
        $q->QUERY_SQL($sql, "artica_backup");
    }
    if (!$q->FIELD_EXISTS("artica_caches", "OtherDomains", "artica_backup")) {
        $sql = "ALTER TABLE `artica_caches` ADD `OtherDomains` TEXT";
        $q->QUERY_SQL($sql, "artica_backup");
    }
    $_POST["sitename"] = mysql_escape_string2(url_decode_special_tool($_POST["sitename"]));
    $q->QUERY_SQL("UPDATE artica_caches\n\t\t\tSET MaxSizeBytes='{$_POST["MaxSizeBytes"]}',\n\t\t\t`rulename`='{$_POST["rulename"]}',\n\t\t\t`sitename`='{$_POST["sitename"]}',\n\t\t\t`enabled`='{$_POST["enabled"]}'\n\t\t\tWHERE ID={$_POST["ID"]}\n\t\t\n\t\t\t\n\t\t\t");
    if (!$q->ok) {
        echo $q->mysql_error;
    }
}