<?php

Session_Start();

Include "Settings.php";

Function Secure($Input) { Return AddSlashes(HTMLSpecialChars($Input)); }
Function UserExist($Id) { $SrchUser = MySQL_Query("SELECT * FROM `users` WHERE `id` = '".$Id."'"); $SrchUser = MySQL_Fetch_Array($SrchUser); Return (IsSet($SrchUser["id"])) ? True : False; }
Function UserName2Id($Username) { $SrchUser = MySQL_Query("SELECT * FROM `users` WHERE `username` = '".$Username."'"); $SrchUser = MySQL_Fetch_Array($SrchUser); Return $SrchUser["id"]; }
Function IPLog($Action) { $Query = MySQL_Query("INSERT INTO `iplog` (`id`, `ip`, `action`, `username`) VALUES(null, '".(($_SERVER["REMOTE_ADDR"]=="::1")?"127.0.0.1":$_SERVER["REMOTE_ADDR"])."', '".$Action."', '".((LOGGED_IN)?$User["username"]:"none")."');"); }

$Connection = MySQL_Connect($_SETTINGS["MySQL"]["Hostname"], $_SETTINGS["MySQL"]["Username"], $_SETTINGS["MySQL"]["Password"]) or die("SQL Error.");
MySQL_Select_Db($_SETTINGS["MySQL"]["Database"]) or die("SQL Error.");

Define("LOGGED_IN", (IsSet($_SESSION["id"])&&UserExist(Secure($_SESSION["id"])))?True:False);

If(LOGGED_IN) {
    $User = MySQL_Query("SELECT * FROM `users` WHERE `id` = '".Secure($_SESSION["id"])."'");
    $User = MySQL_Fetch_Array($User);
    $Rank = MySQL_Query("SELECT * FROM `ranks` WHERE `id` = '".$User["rank"]."'");
    $Rank = MySQL_Fetch_Array($Rank);
}

?>