Личный кабинет

[Lampard_DS]

Собственно тема подобная есть но мой вопрос в корне отличается от нее. Так вот, идея написать для сайта Аион личный кабинет. Не люблю я все эти заготовки типа готовых cms и прочее, вообщем у меня есть сайт полностью на пхп))) Писал сам и доволен) каждая страничка по 10кб) Летает))) Так вот, помню еще когда с пиратией возился там был код(правда по запросам под mssql) вот сам код

Код:

                <center><h2>Аккаунт</h2>
                <center>Приветствую <?
if(auth() == -1){
echo "<strong>Гость</strong>!";}
else{
echo "<Strong>".$_COOKIE['PKO_login']."</strong>!";}
?>
                <?

$page = " ";
$auth = auth();
if($auth == -1)
{
$page = "<form action=\"login.php\" method=\"POST\">
<center><table class=\"tabset_content\">
<tr><td>Логин:</td><td><input class=\"text\" type=\"text\" width=15 name=\"login\" /></td></tr>
<tr><td>Пароль:</td><td><input class=\"text\" type=\"password\" width=15 name=\"password\" /></td></tr>
<tr><td><a href=\"reg.php\">Регистрация</a></td><td align=\"right\"><input type=\"submit\" class=\"button\" value=\" Войти \" /></td></tr>
</table>
</form>";
}
if($auth == 0)
{
//do normal player??
$page = "<center><table class=\"tabset_content\"><br>
Управление
<br><br>
<a href=\"pl.php\"><b>Персонажи</a>
<br><br>
<tr align=\"left\"><td><a href=\"logout.php\"><b>Выйти</a></b></td></tr>
</table>";
}

if($auth == 99)
{
//do gm
$page = "<center><table class=\"tabset_content\">
<tr align=\"left\"><td><a href=\"list.php?type=act\">Аккаунты</a></td></tr>
<tr align=\"left\"><td><a href=\"info.php\">ИнфоВещи</a></td></tr>
<tr align=\"left\"><td><a href=\"logout.php\">Выйти</a></td></tr>
</table>";
}

?>

                 <?
//bgcolor="0099FF"
echo $page;

$result = do_query("SELECT * FROM account_login","AccountServer");
$num_act = mssql_num_rows($result);

$result = do_query("SELECT cha_id FROM character","GameDB");
$num_char = mssql_num_rows($result);



?>

Однажды уже делал из mssql все под mysql, просто менял букву) сросталось(ну и базы) а сейчас просто ошибку в auth, но никак не могу ничего поделать. А идея то неплохая, такое можно в любой сайт запихнуть. Если кто поможет, как правильнее сделать. Буду благодарен)

Вот конфиг

Код:

<?

$host = 'localhost';
$username = 'root';
$password = 'vertrigo';
$chinese_jobs = true;               //are the jobs stored in chinese?

$connection = mysql_connect($host,$username,$password) OR DIE("Can't connect to DB!!");

function do_query($query,$database)
    {
        mysql_select_db($database) OR DIE("Can't find the database!!");
        return mysql_query($query);
    }

function auth()
    {
        if(isset($_COOKIE['PKO_login']))
            {
                if(isset($_COOKIE['PKO_password']))
                    {
                        $login = $_COOKIE['PKO_login'];
                        $password = $_COOKIE['PKO_password'];
                        $result = do_query("SELECT * FROM account_login WHERE name LIKE '$login' AND password = '$password'","au_server_ls");
                        if(mssql_num_rows($result) > 0)
                            {
                                $result = do_query("SELECT gm FROM account WHERE act_name LIKE '$login'","au_server_ls");
                                $gm_level = mssql_fetch_array($result);
                                $gm_level = $gm_level['gm'];
                                return $gm_level;
                            }
                        else
                            {
                                setcookie("PKO_login", $login, -time()+60*60*24*30);
                                setcookie("PKO_password",$pw, -time()+60*60*24*30);
                        
                                $page = "<font color=\"red\">Your cookies are not correct! You've been trying to hack me!</font><br>
                                            <a href=\"index.php\">Login</a>";
                            }
                    }
                else
                    {
                        setcookie("PKO_login", $login, -time()+60*60*24*30);
                        setcookie("PKO_password",$pw, -time()+60*60*24*30);
                        
                        $page = "<font color=\"red\">Your cookies are not correct! You've been trying to hack me!</font><br>
                                            <a href=\"index.php\">Login</a>";
                                
                    }
            }
        else
            {
                return -1;
            }
    }

function exp_to_lv($exp)
    {
        $file = fopen("exp.txt","r");
        while($line = explode(";",fgets($file)))
            {
                if($line[2] > $exp)
                    {
                        $level = $line[1] - 1;
                        break;
                    }
            }
        fclose($file);
        return $level;
    }
    
function zh_to_eng($zh_job,$zh_jobs)
    {
        if($zh_jobs === true)
            {
                $file = fopen("job.txt","r");
                $i=0;
                while($line = explode(";",fgets($file)))
                    { $i++;
                        if($line[0] == $zh_job)
                            {
                                $job = $line[2];
                                break;
                            }
                        if($i >20)
                            break;
                    }
                fclose($file);
                if(isset($job))
                {
                    return $job;}
                else {
                    return $zh_job;}
            }
        else
            return $zh_job;
    }
    
function eng_to_zh($eng_job,$zh_jobs)
    {
        if($zh_jobs === true)
            {
                $file = fopen("job.txt","r");
                $i=0;
                while($line = explode(";",fgets($file)))
                    {$i++;

                        if(strcasecmp($line[2],$eng_job) == 2) // YOU MIGHT NEED TO CHANGE THIS!!!
                            {
                                $job = $line[0];
                                break;
                            }
                        if($i >10)
                            break;
                    }
                fclose($file);
                if(isset($job))
                
                    return $job;
                else
                    return $eng_job;
            }
        else
            return $eng_job;
    }
?>