x-MU.net форум

<?php
//Class change script
//© 2008 SkyLinE
require 'config.php';
$name = $char_name;
$login = $_SESSION['DS_UserName'];
$oldpwd = $_SESSION['DS_PassWord'];
if (empty($login)){
die("please login first!");
}
$query = "select Class from Character WHERE Name='$name'";
$result = mssql_query( $query );
$row = mssql_fetch_row($result);
$class=$row[0];


if ($class == 64) {
$class = 'Dark Lord';
}
if ($class == 0) {
$class = 'Dark Wizard';
}
if ($class == 1) {
$class = 'Soul Master';
}
if ($class == 2) {
$class = 'Grand Master';
}
if($class == 16){
$class = 'Dark Knight';
}
if($class == 17){
$class = 'Blade Knight';
}
if($class == 18){
$class = 'Blade Master';
}
if($class == 32){
$class = 'Elf';
}
if($class == 33){
$class = 'Muse Elf';
}
if($class == 34){
$class = 'High Elf';
}
if($class == 48){
$class = 'Magic Gladiator';
}
if($class == 49){
$class = 'Duel Master';
}
if ($class == 64) {
$class = 'Dark Lord';
}
if ($class == 65) {
$class = 'Lord Emperror';
}
if ($class == 80) {
$class = 'Summoner';
}
if ($class == 81) {
$class = 'Bloody Summoner';
}
if ($class == 82) {
$class = 'Dimension Master';
}


if (isset($_POST['chgclass_s'])){
//=============Credit count=============
$need_credits='1';
//====================================

require 'config.php';
$name = $char_name;
$login = $_SESSION['DS_UserName'];
$oldpwd = $_SESSION['DS_PassWord'];

$count = stripslashes($_POST['zen_byeitem']);




if($count=='1'){
$class_number='1';
}
elseif($count=='2'){
$class_number='17';
}
elseif($count=='3'){
$class_number='33';
}
elseif($count=='4'){
$class_number='48';
}
elseif($count=='5'){
$class_number='64';
}

$msconnect=mssql_connect($Sql['host'],$Sql['user'],$Sql['password']);
$msdb=mssql_select_db("MuOnline",$msconnect);

$sql_username_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE memb___id='$username'");
$username_check = mssql_num_rows($sql_username_check);

$sql_pw_check = mssql_query("SELECT memb__pwd FROM MEMB_INFO WHERE memb__pwd='$oldpwd' and memb___id='$username'");
$pw_check = mssql_num_rows($sql_pw_check);

$query = "select Class from Character WHERE Name='$name'";
$result = mssql_query( $query );
$row = mssql_fetch_row($result);

$query_ = "select Credits,memb___id from MEMB_CREDITS WHERE memb___id='$login'";
$result_ = mssql_query( $query_ );
$row_ = mssql_fetch_row($result_);

if($row_[1]== NULL){

$msquery = "INSERT INTO MEMB_CREDITS (memb___id,credits) VALUES ('$login','0')";
$msresults= mssql_query($msquery);

}

$class=$row[0];

$new_credits = $row_[0] - $need_credits;





if (empty($login) || empty($oldpwd) || empty($name)) {
echo "<div id="msg-error"><ul><li>Error: some of the fields are empty. Go back and try again.</li></ul></div><br>";
}

elseif($count != '1' AND $count != '2' AND $count != '3' AND $count != '4' AND $count != '5'){ echo "<div id="msg-error"><ul><li>Some Error.#3<br></li></ul></div>"; }
elseif($class == 0 OR $class == 16 OR $class == 32){ echo "<div id="msg-error"><ul><li>Need Second Quest Completed<br></li></ul></div>"; }


elseif ($row_[0] < $need_credits){
echo "<div id="msg-error"><ul><li>You Don't have credits <br></li></ul></div>"; }


else {   $msconnect=mssql_connect("$dbhost","$dbuser","$dbpasswd");
$msdb=mssql_select_db("MuOnline",$msconnect);
$msquery = "
UPDATE dbo.Character SET Class = '$class_number'
WHERE Name = '$name'
UPDATE dbo.MEMB_CREDITS SET Credits = '$new_credits'
WHERE memb___id = '$login'"; //UPDATE dbo.Character SET Inventory = NULL WHERE Name = '$name'


$msresults= mssql_query($msquery);
echo" <div id="msg-ok"><ul><li>Your Class changed</li></ul></div>";}




}
?>

<FIELDSET><LEGEND>&nbsp;Class change&nbsp;</LEGEND>
<FORM class=postZkForm action='' method=post>
There you can change your class.Price - 300 credits.All items from inventory Will be removed!<BR><BR>
<?php
print"<B>Selected Char:</B> $name<BR>";
print"<B>Current Class:</B> $class<BR>";
print"<BR>";
?>
<TABLE class=btb cellSpacing=0 cellPadding=0 border=0>
<TBODY>

<TR class=style2 align=middle>
<TD><B>#</B></TD>
<TD><B>Class</B></TD></TR>
<TR class=style2>
<TD><INPUT type=radio value=1 name=zen_byeitem></TD>
<TD>Soul Master</TD></TR>
<TR class=style2>
<TD><INPUT type=radio value=2 name=zen_byeitem></TD>
<TD>Blade Knight</TD></TR>
<TR class=style2>
<TD><INPUT type=radio value=3 name=zen_byeitem></TD>
<TD>Muse Elf</TD>
</TR>
<TR class=style2>
<TD><INPUT type=radio value=4 name=zen_byeitem></TD>
<TD>Magic Gladiator</TD>
</TR>
<TR class=style2>
<TD><INPUT type=radio value=5 name=zen_byeitem></TD>
<TD>Dark Lord</TD>
</TR></TBODY></TABLE>

<BR><INPUT class=button-gray type=submit value="Change class" name=chgclass_s>


</FORM><BR>
</FIELDSET>