<?php
include 'travia_config.php';
$tabelka = '<table>
<form action=test2.php method=post>
<tr><td>Login</td><td><input type=text name=login value="'.$_POST['login'].'"></td></tr>
<tr><td>CharName</td><td><input type=text name=charname value="'.$_POST['charname'].'"></td></tr>
<tr><td>Password</td><td><input type=password name=pass></td></tr>
<tr><td><input type=submit value="Change job"></td></tr>
</form>
</table>';
echo $tabelka;
if($reg_open AND isset($_POST['login']))
{
$conn=@mssql_connect($hostbazy,$user,$haslo) or die("<b>Critical Error</b><br>MSSQL server is offline OR I can't Access to it !");
@mssql_select_db($nazwabazy, $conn) or die("<b>Critical Error</b><br>Database don't exists OR I can't Access to it !");
$login = $_POST['login'];
$pw = $_POST['pass'];
$login = trim($login);
$pw = trim($pw);
$login_user = strtolower($login);
$result_user = mssql_query("SELECT LOWER(UT_USERID) FROM usertable
WHERE LOWER(UT_USERID) = ('$login_user')") or die;
$login_pass = strtolower($pw);
$result_pass = mssql_query("SELECT LOWER(UT_PASSWORD) FROM usertable
WHERE LOWER(UT_PASSWORD) = ('$login_pass')") or die;
if (mssql_num_rows($result_user))
{
if(mssql_num_rows($result_pass)) // if ppass = ok
{
$conn_=@mssql_connect($hostbazy,$user,$haslo) or die("<b>Critical Error</b><br>MSSQL server is offline OR I can't Access to it !");
@mssql_select_db($nazwabazy_, $conn_) or die("<b>Critical Error</b><br>Database don't exists OR I can't Access to it !");
$charname = $_POST['charname'];
$charname = trim($charname);
$login_charname = strtolower($charname);
$result_charname = mssql_query("SELECT LOWER(CT_NAME) FROM CHARTABLE
WHERE LOWER(CT_USERID) = ('$login_user')") or die;
if(mssql_num_rows($result_charname)) //if charname = OK
{
//after charname check if char is lvl 100
$query = "SELECT CT_LVL FROM CHARTABLE WHERE CT_USERID='$login_user' and CT_NAME='$login_charname'";
$result = mssql_query($query);
while($line = mssql_fetch_row($result))
{
if($line[0] > 99) //if char lvl = 100+ then
{ print "$login_charname lvl is $line[0]"; } //displays your char lvl you tried to changed job
//hire replcae job changin values......woever know what to change..
else
{ echo "$login_charname Must be lvl 100 to change job" ; }
}
}#if charname NOT OK
else
{ echo '<br>Wrong username or password or charname.<br>'; }
}#if pass NOT OK
else
{ echo '<br>Wrong username or password or charname.<br>'; }
}#if user NOT OK
else
{ echo '<br>Wrong username or password or charname.<br>'; }
}
?>