<?php
$dbhost ='localhost';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'l2db;
$msc = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

$password = base64_encode(pack('H*', sha1($password)));
$sql = mysql_query("select * from accounts where login='$login'");
$result=mysql_fetch_array($sql);
if ($result[password]==$password) {
$sql = mysql_query("SELECT * FROM characters WHERE account_name='$login'");
echo "
<HR>
<font size=2><center>Добро пожаловть в личный кабинет</center></font><br>
<table border=0 width=100%>
<tr><td width=45%>
<table border=0 width=100%>
<tr><td><center>Список персонажей</center></td></tr>";
While ($result = mysql_fetch_array($sql)) {
echo "<center><tr><td width=><a href=index.php?id=persone&char=$result[obj_Id]>$result[char_name]</a> - $result[level]lvl - ($result[obj_Id])</td></tr></center>"; }
echo "</table></td></tr></table>";

;}else{ echo "Не верный логин или пароль";;}

?>