/////////////// site 4 db /////////////////
if($sitenr==4 && isset($_POST["check4"])) {
    $_SESSION["dbcheck"]=false;
    $dbhost=trim($_POST["dbhost"]);
    $dbuser=trim($_POST["dbuser"]);
    $dbpass=trim($_POST["dbpass"]);
    $dbdb=trim($_POST["dbdb"]);
    $dbprefix=trim($_POST["dbprefix"]);

    $_SESSION["dbhost"]=$dbhost;
    $_SESSION["dbuser"]=$dbuser;
    $_SESSION["dbpass"]=$dbpass;
    $_SESSION["dbdb"]=$dbdb;
    $_SESSION["dbprefix"]=$dbprefix;

    $smarty->assign("db",array($dbhost,$dbuser,$dbpass,$dbdb,$dbprefix));

    if($dbhost=="" || $dbuser=="" || $dbdb=="" || $dbprefix=="") {
        $msg="_NOREQUIREDFIELDS";
    }

    $mysql=@mysql_connect($dbhost,$dbuser,$dbpass) or $msg="_CANTCONNECT";
    if(!$msg) $ressource=@mysql_select_db($dbdb) or $msg="_CANTSELECTDB";

    //get user privileges
    if(!$msg) {
        $previleges=sql_get_privilege();
        $prev[]=array("name"=>"SELECT","value"=>in_array("SELECT",$previleges));
        $prev[]=array("name"=>"INSERT","value"=>in_array("INSERT",$previleges));
        $prev[]=array("name"=>"UPDATE","value"=>in_array("UPDATE",$previleges));
        $prev[]=array("name"=>"DELETE","value"=>in_array("DELETE",$previleges));
        $prev[]=array("name"=>"CREATE","value"=>in_array("CREATE",$previleges));
        //search for all needed previleges
        foreach($prev as $k => $v) {
            if(in_array(false,$v)) {$msg="_NOTALLPREVILEGES";break;}
        }
    }
    //check for existing tables
    if(!$msg) {
        $ressource=@mysql_select_db($dbdb);
        //search for existing dbprefix
        if( mysql_num_rows( @mysql_query("SHOW TABLES FROM `".$dbdb."` LIKE '".$dbprefix."\_%'"))) {
            $prefix_exists=true;
            //search for field "imported" in bans table, added since 6.0
            if( mysql_num_rows( @mysql_query("SHOW COLUMNS FROM `".$dbprefix."_bans` WHERE Field LIKE 'imported'"))) {
                $prefix_isnew=true;
            }
        }
    }

    $smarty->assign("prevs",$prev);

    if(!$msg) {
        if($prefix_exists) {
            if($prefix_isnew) {
                $msg="_PREFIXEXISTSV6";
                $_SESSION["dbcheck"]=true;
                $smarty->assign("next",true);
            } else {
                $msg="_PREFIXEXISTSV5";
            }
        } else {
            $msg="_DBOK";
            $_SESSION["dbcheck"]=true;
            $smarty->assign("next",true);
        }
    }
}
if($sitenr==4) $smarty->assign("checkvalue","_DBCHECK");