[HELP]Rebirth System

derekgabs · May 8, 2009

How can i put rebirth system in my server?

zedawg · May 8, 2009

you have 2 options....using the auto rebirth query(i can give you) or you can use a User Control Panel that you can find in the release section

derekgabs · May 8, 2009

which of the two options would be better sir?
BTW: the auto rebirth querry do you mean when i would be a hero and if i logged out i would get rebirth??

alist3r06 · May 8, 2009

auto is better coz u just only need to relogin...

zedawg · May 8, 2009

that depends...i suggest you to make a poll with ur players...cause some prefer to stay hero

derekgabs · May 8, 2009

ok.. we choose the user control panel rebirth

zedawg · May 8, 2009

go in release section and find one you like...i warn you about Caja released one...its vulnerable to sql injections(dont know wtf is this??? google it)...learned how to sql inject and its funny ^^

derekgabs · May 8, 2009

sir i found one and only yet it is somewhat corrupt it keeps on saying id or pass incorrect

zedawg · May 8, 2009

http://forum.ragezone.com/f457/character-cp-536872/

derekgabs · May 8, 2009

ok thank you very much sir

derekgabs · May 8, 2009

sir I got an error that says "Your character can not yet be rebirth. You must be level 120 HERO and get 20000000 of penya."

zedawg · May 8, 2009

read this

http://forum.ragezone.com/f457/little-correction-on-bylol32-bbim-and-enmanuelprox-cp-570141/

derekgabs · May 11, 2009

i got an error on your rebirth system it says
"Parse error: parse error in C:\wamp\www\FlyForAll\Change\changejob.php on line 1035"

zedawg · May 11, 2009

but does it rebirth???

derekgabs · May 11, 2009

and in the ultimate item i got an error of
"Parse error: parse error in C:\wamp\www\FlyForAll\Change\changejob.php on line 1102"

derekgabs · May 11, 2009

zedawg said:
but does it rebirth???

nope it doesn't that is the only thing i see in my browser

zedawg · May 11, 2009

copy and paste ur script in here

derekgabs · May 11, 2009

Code:

<?php
 	//THIS MUST COME IN HOME PAGE, BEFORE YOU ALL, INCLUDING <html>
	require "config.php";
	session_start();
	$user = $_SESSION['user'];
	$login = $_POST['login'];
	$senha = $_POST['senha'];
	$act = $_GET['a'];
	function em()
	{
		$args = func_get_args();
		for ($cont = 1; $cont < func_num_args(); $cont++)
		{
			$arg = func_get_arg($cont);
			if ($arg == $args[0])
				return true;
		}
		return false;
	}
?>
<html>
<head>
<style type="text/css">
<!--
body {
	background-image: url(images/bg103.gif);
}
-->
</style><body>
<script language="javascript" type="text/javascript">
function sel()
{
	for(var x = 0; x < document.buff.elements.length; x++)
	{
		var y = document.buff.elements[x];
		if (y.name != 'selall')
			y.checked = document.buff.selall.checked;
		}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a:link {
	color: #000000;
	text-decoration: underline;
}
a:visited {
	text-decoration: underline;
	color: #000000;
}
a:hover {
	text-decoration: none;
	color: #000000;
}
a:active {
	text-decoration: underline;
	color: #000000;
}
-->
</style>
</head>
<body>
<?php
?>
<?php
{
      echo "<table style='margin-top: 5px; border-style: inset; border-width: 1px; border-spacing: 0px; font-size: 9pt;' width='98%' height='25' align='center'><tr 

valign='center'><td><div style='float: left; margin-left: 5px;'><b>Welcome $user</b>          <a 

href='http://flyffemergencia.servegame.com/index.php' style='text-decoration: none;'>Home</a>  |  <a href='changejob.php?a=senha' 

style='text-decoration: none;'>Change Password</a>  |  <a href='http://flyffemergencia.servegame.com/chat.php' style='text-decoration: 

none;'>Live Chat</a>  |  <a href='logout.php' style='text-decoration: none;'>Logout</a></div></td></tr></table>";
	  echo "<table style='margin-top: 5px; border-style: inset; border-width: 1px; border-spacing: 0px; font-size: 9pt;' width='98%' height='25' align='center'><tr 

valign='center'><td><div style='float: left; margin-left: 5px;'><b>Welcome Administrator</b>          <a 

href='changejob.php?a=adminpanel' style='text-decoration: none;'>Admin Panel</a>  |  <a href='changejob.php?a=ipban' style='text-decoration: 

none;'>IP Ban</a>  |  <a href='changejob.php?a=database' style='text-decoration: none;'>Database 

Controller</a>  </div></td></tr></table>";
	  echo "<title>Fly For Friends - $user's user control panel</title>";
	  if (($act != 'login') && ($act != 'char') && ($act != 'job') && ($act != 'setjob') && ($act != 'listbuff') && ($act != 'buffar') && ($act != 'senha') && ($act !='transy') 

&& ($act !='reborn') && ($act !='restat') && ($act !='restatstr') && ($act !='restatsta') && ($act !='restatdex') && ($act !='restatint') && ($act !='size') && ($act !='size0.5') 

&& ($act !='size1.0') && ($act !='size1.5') && ($act !='size2.0') && ($act!='sizecustom') && ($act!='sizecustombox') && ($act !='tele') && ($act !='telefl') && ($act 

!='telesm') && ($act !='teledk1') && ($act !='teledk2') && ($act !='teledk3') && ($act !='teleazria') && ($act !='televolcan') && ($act !='telefortower') && ($act !='telecw') 

&& ($act!='telecoral') && ($act!='changename') && ($act!='ultiname') && ($act!='ultichar') && ($act!='changenam') && ($act!='ipban') && ($act!='database') && 

($act!='adminpanel') && ($act !='ulti'))
	{
		echo '<form method="post" action="changejob.php?a=login">';
		echo 'Login <input type="text" name="login"><p>';
		echo 'Password <input type="password" name="senha"><p>';
		echo '<input type="submit" value="login" name="OK">';
		echo '</form>';
		}
	if ($act == 'login')
	{
		$senha = md5('kikugalanet' . $senha);
		$resultado = mysql_query("select * from accounts where username = '$login' and password = '$senha'");
		if (is_resource($resultado))
			$qde_registros = mysql_num_rows($resultado);
		if ($qde_registros != 0)
		{
			$act = 'char';
			$_SESSION['user'] = $login;
			$user = $login;
			session_write_close();	
		}
		else
		{
			echo "<font color='#FF0000'>ID or password incorrect, please try again.</font><br>";
			echo '<form method="post" action="changejob.php?a=login">';
			echo 'Login <input type="text" name="login"><p>';
			echo 'Password <input type="password" name="senha"><p>';
			echo '<input type="submit" value="login" name="OK">';
			echo '</form>';
		}
	}
	if ($act == 'char')
	{
		if (isset($_SESSION['user']))
		{
			$resultado = mysql_query("select * from accounts AS a WHERE a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$resultado = mysql_query("select * from characters where accountname = '$user' order by charslot asc");
				$qde_registros = mysql_num_rows($resultado);
				if ($qde_registros == 0)
					echo "You have no characters on this account<br>";
				else
					echo "<fieldset><legend>  PICK THE CHAR  </legend>";
				$qtde = $qde_registros;
				while ($reg = mysql_fetch_assoc($resultado))
				{
					$qtde--;
					$idJob = $reg['class'];
					if ($idJob == 0) $nomeJob = 'Vagrant';
					if ($idJob == 1) $nomeJob = 'Mercenary';
					if ($idJob == 2) $nomeJob = 'Acrobat';
					if ($idJob == 3) $nomeJob = 'Assist';
					if ($idJob == 4) $nomeJob = 'Magician';
					if ($idJob == 6) $nomeJob = 'Knight';
					if ($idJob == 7) $nomeJob = 'Blade';
					if ($idJob == 8) $nomeJob = 'Jester';
					if ($idJob == 9) $nomeJob = 'Ranger';
					if ($idJob == 10) $nomeJob = 'Ringmaster';
					if ($idJob == 11) $nomeJob = 'Billposter';
					if ($idJob == 12) $nomeJob = 'Psykeeper';
					if ($idJob == 13) $nomeJob = 'Elementor';
					if ($idJob == 16) $nomeJob = 'Knight [Master]';
					if ($idJob == 17) $nomeJob = 'Blade [Master]';
					if ($idJob == 18) $nomeJob = 'Jester [Master]';
					if ($idJob == 19) $nomeJob = 'Ranger [Master]';
					if ($idJob == 20) $nomeJob = 'Ringmaster [Master]';
					if ($idJob == 21) $nomeJob = 'Billposter [Master]';
					if ($idJob == 22) $nomeJob = 'Psykeeper [Master]';
					if ($idJob == 23) $nomeJob = 'Elementor [Master]';
					if ($idJob == 24) $nomeJob = 'Knight - <img src="images/h.png"';
					if ($idJob == 25) $nomeJob = 'Blade - <img src="images/h.png"';
					if ($idJob == 26) $nomeJob = 'Jester - <img src="images/h.png"';
					if ($idJob == 27) $nomeJob = 'Ranger - <img src="images/h.png"';
					if ($idJob == 28) $nomeJob = 'Ringmaster - <img src="images/h.png"';
					if ($idJob == 29) $nomeJob = 'Billposter - <img src="images/h.png"';
					if ($idJob == 30) $nomeJob = 'Psykeeper - <img src="images/h.png"';
					if ($idJob == 31) $nomeJob = 'Elementor - <img src="images/h.png"';
					$slot = $reg['charslot'];
         $name = $reg['charname'];
         $lvl = $reg['level'];
         $rebirths = $reg['rebirths'];
         $id = $reg['id'];
         $sex = $reg['sex'];
         if ($sex == 0) $truesex = 'Male';
         if ($sex == 1) $truesex = 'Female';
		 $sizeMod = $reg['sizeMod'];
		 $penya = $reg['penya'];
         echo "<fieldset><legend>  <font size='3'><b> Slot $slot </b>  </legend>";
         echo "<b>Name</b>: <font size='3'><font color='#FF0000'>$name</font><br>"; 
         echo "<b>Sex</b>: <font color='#FF0000'>$truesex</font><br>";
         echo "<b>Level</b>: <font color='#FF0000'>$lvl</font><br>";
		 echo "<b>Job</b>: <font color='#FF0000'>$nomeJob</font><br>";
         echo "<b>Rebirths</b>: <font color='#FF0000'>$rebirths</font><br>";
		 echo "<b>Sizemod</b>: <font color='#FF0000'>$sizeMod</font><br>";
		 echo "<b>Penya</b>: <font color='#FF0000'>$penya</font><br>";
         echo "<hr size='1'>";
         if ($reg['channelnum'] == -1)
					{
						echo "<a href='changejob.php?a=job&char=$id' style='text-decoration: none;'>Change 

Job</a> | <a href='changejob.php?a=tele&charid=$id' style='text-decoration: none;'>Teleport</a>  |  <a 

href='changejob.php?a=listbuff&char=$id' style='text-decoration: none;'>Buffs</a>  |  <a href='changejob.php?a=transy&charid=$id' style='text-decoration: 

none;'>Change Sex</a>  |  <a href='changejob.php?a=restat&charid=$id' style='text-decoration: none;'>Restat</a>  |  <a 

href='changejob.php?a=size&charid=$id' style='text-decoration: none;'>Change Size</a>  |  <a href='changejob.php?a=changename&charid=$id' 

style='text-decoration: none;'>Change Name</a>  |  <a href='changejob.php?a=ulti&charid=$id' style='text-decoration: none;'>Make Ultimate</a> 

 |  </a> <a href='changejob.php?a=reborn&charid=$id' style='text-decoration: none;'>Rebirth</a>";
					}
					else
						 echo "Your character is Online, you must be logged out of the game before you can edit your character.";
         echo "</fieldset>";
         if ($qtde != 0) { echo ""; }
      }
      if ($checkchars != 0)
      {
         echo "</td>";
      }
      
      echo "<td width='25%' height='100'><fieldset height='100'><div aling=right><legend>  <b> GameMaster Online </b>  </legend>";
      $querygm = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE a.accesslevel >= 800 AND a.logged_in 

= 1 AND c.channelnum >= 1");
      $listgm = mysql_num_rows($querygm);
      if ($listgm == 0)
         echo "<br><br>There are no GMs online.<br>";
      else
         echo "<br><right>";
      $qtde = $listgm;
      while ($reg = mysql_fetch_assoc($querygm))
      {
         
         $qtde--;
         $gmchar = $reg['charname'];
         echo "<div style='float: left;' align='left'><b>$gmchar</b></div> <div align='left'>      <img 

src='images/on.png'></div><br>";
         if ($qtde != 0) { echo ""; }
         
      }
      echo "</center><br><br></fieldset></td></tr>";
      echo "<tr><td colspan='2'>"; 
			}
		}
	}
		if ($act == 'job') //big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$resultado = mysql_query("select * from characters where id = $id");
				$reg = mysql_fetch_assoc($resultado);
				$lvl = $reg['level'];
				$job = $reg['class'];
				$mostrou = 'false';
				echo "<fieldset><legend>  <b>CHOOSE YOUR JOB</b>  </legend>";
				if (($lvl == 15) && ($job == 0))
				{
					$mostrou = 'true';
					echo "<a href='changejob.php?a=setjob&char=$id&job=1' style='text-decoration: none;'>Mercenary</a><br>";
					echo "<a href='changejob.php?a=setjob&char=$id&job=2' style='text-decoration: none;'>Acrobat</a><br>";
					echo "<a href='changejob.php?a=setjob&char=$id&job=3' style='text-decoration: none;'>Assist</a><br>";
					echo "<a href='changejob.php?a=setjob&char=$id&job=4' style='text-decoration: none;'>Magician</a><br>";
				}
				if (($lvl == 60) && ($job >= 1) && ($job <= 4))
				{
					$mostrou = 'true';
					switch($job)
					{
						case 1:	echo "<a href='changejob.php?a=setjob&char=$id&job=6' style='text-decoration: 

none;'>Knight</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=7' style='text-decoration: 

none;'>Blade</a><br>";
								break;
						case 2: echo "<a href='changejob.php?a=setjob&char=$id&job=8' style='text-decoration: 

none;'>Jester</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=9' style='text-decoration: 

none;'>Ranger</a><br>";
								break;
						case 3: echo "<a href='changejob.php?a=setjob&char=$id&job=10' style='text-decoration: 

none;'>Ringmaster</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=11' style='text-decoration: 

none;'>BillPoster</a><br>";
								break;
						case 4: echo "<a href='changejob.php?a=setjob&char=$id&job=12' style='text-decoration: 

none;'>Psykeeper</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=13' style='text-decoration: 

none;'>Elementor</a><br>";
								break;
					}
				}
				if (($lvl == 120) && ($job >= 6) && ($job <= 13))
				{
					$mostrou = 'true';
					switch($job)
					{
						case 6:		echo "<a href='changejob.php?a=setjob&char=$id&job=16' style='text-decoration: 

none;'>Knight [M]</a><br>";
									break;
						case 7:		echo "<a href='changejob.php?a=setjob&char=$id&job=17' style='text-decoration: 

none;'>Blade [M]</a><br>";
									break;
						case 8: 	echo "<a href='changejob.php?a=setjob&char=$id&job=18' style='text-decoration: none;'>Jester 

[M]</a><br>";
									break;
						case 9: 	echo "<a href='changejob.php?a=setjob&char=$id&job=19' style='text-decoration: none;'>Ranger 

[M]</a><br>";
									break;
						case 10: 	echo "<a href='changejob.php?a=setjob&char=$id&job=20' style='text-decoration: none;'>Ringmaster 

[M]</a><br>";
									break;
						case 11: 	echo "<a href='changejob.php?a=setjob&char=$id&job=21' style='text-decoration: none;'>BillPoster 

[M]</a><br>";
									break;
						case 12: 	echo "<a href='changejob.php?a=setjob&char=$id&job=22' style='text-decoration: none;'>Psykeeper 

[M]</a><br>";
									break;
						case 13: 	echo "<a href='changejob.php?a=setjob&char=$id&job=23' style='text-decoration: none;'>Elementor 

[M]</a><br>";
									break;
					}
				}
				if (($lvl == 120) && ($job >= 16) && ($job <= 23))
				{
					$mostrou = 'true';
					switch($job)
					{
						case 16:	echo "<a href='changejob.php?a=setjob&char=$id&job=24' style='text-decoration: none;'>Knight 

[H]</a><br>";
									break;
						case 17:	echo "<a href='changejob.php?a=setjob&char=$id&job=25' style='text-decoration: none;'>Blade 

[H]</a><br>";
									break;
						case 18: 	echo "<a href='changejob.php?a=setjob&char=$id&job=26' style='text-decoration: none;'>Jester 

[H]</a><br>";
									break;
						case 19: 	echo "<a href='changejob.php?a=setjob&char=$id&job=27' style='text-decoration: none;'>Ranger 

[H]</a><br>";
									break;
						case 20: 	echo "<a href='changejob.php?a=setjob&char=$id&job=28' style='text-decoration: none;'>Ringmaster 

[H]</a><br>";
									break;
						case 21: 	echo "<a href='changejob.php?a=setjob&char=$id&job=29' style='text-decoration: none;'>BillPoster 

[H]</a><br>";
									break;
						case 22: 	echo "<a href='changejob.php?a=setjob&char=$id&job=30' style='text-decoration: none;'>Psykeeper 

[H]</a><br>";
									break;
						case 23: 	echo "<a href='changejob.php?a=setjob&char=$id&job=31' style='text-decoration: none;'>Elementor 

[H]</a><br>";
									break;
					}
				}
				if ($mostrou == 'false')
				{
					echo "<h3><font color='#FF0000'>NOTICE</font>: Your char Already have a job, or your char is not Lvl 15 or 60 or 

120</h3>";
					echo "</fieldset>";
				}
				echo "</fieldset>";
			}
		} 
	}
	if ($act == 'setjob') //big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$fjob = $_GET["job"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$resultado = mysql_query("select * from characters where id = $id");
				$reg = mysql_fetch_assoc($resultado);
				$lvl = $reg['level'];
				$job = $reg['class'];
				$sp = $reg['skillpoints'];
				$passou = 'false';
				$passou = ((($lvl == 15) && ($job == 0) && ($fjob >= 1) && ($fjob <= 4)) || ($passou == 'true')) ? 'true' : 'false';
				
				$passou = ((($lvl == 60) && ($job == 1) && (($fjob == 6) || ($fjob == 7))) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 60) && ($job == 2) && (($fjob == 8) || ($fjob == 9))) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 60) && ($job == 3) && (($fjob == 10) || ($fjob == 11))) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 60) && ($job == 4) && (($fjob == 12) || ($fjob == 13))) || ($passou == 'true')) ? 'true' : 'false';
				
				$passou = ((($lvl == 120) && ($job == 6) && ($fjob == 16)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 7) && ($fjob == 17)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 8) && ($fjob == 18)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 9) && ($fjob == 19)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 10) && ($fjob == 20)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 11) && ($fjob == 21)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 12) && ($fjob == 22)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 13) && ($fjob == 23)) || ($passou == 'true')) ? 'true' : 'false';
				
				$passou = ((($lvl == 120) && ($job == 16) && ($fjob == 24)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 17) && ($fjob == 25)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 18) && ($fjob == 26)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 19) && ($fjob == 27)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 20) && ($fjob == 28)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 21) && ($fjob == 29)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 22) && ($fjob == 30)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 23) && ($fjob == 31)) || ($passou == 'true')) ? 'true' : 'false';
				if ($passou == 'true')
				{
					switch($fjob)
					{
						case 1: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 2: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 3: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 4: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 6: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,128,129,130,131,1***133,134,135,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 7: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,136,137,138,139,140,141,142,143,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 8: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,207,208,209,210,211,212,213,214,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 9: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,215,216,217,218,219,220,221,222,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 10: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,144,145,146,147,148,149,150,151,230,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 11: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,152,153,154,155,156,157,158,159,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 12: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,160,161,162,163,164,165,166,167,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 13: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,0,0,0'; break;
						case 16: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,128,129,130,131,1***133,134,135,0,0,0,0,0,0,0,0,0,0,0,0,310,0'; break;
						case 17: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,136,137,138,139,140,141,142,143,0,0,0,0,0,0,0,0,0,0,0,0,309,0'; break;
						case 18: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,207,208,209,210,211,212,213,214,0,0,0,0,0,0,0,0,0,0,0,0,311,0'; break;
						case 19: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,215,216,217,218,219,220,221,222,0,0,0,0,0,0,0,0,0,0,0,0,312,0'; break;
						case 20: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,144,145,146,147,148,149,150,151,230,0,0,0,0,0,0,0,0,0,0,0,316,0'; break;
						case 21: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,152,153,154,155,156,157,158,159,0,0,0,0,0,0,0,0,0,0,0,0,315,0'; break;
						case 22: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,160,161,162,163,164,165,166,167,0,0,0,0,0,0,0,0,0,0,0,0,314,0'; break;
						case 23: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,0,313,0'; break;
						case 24: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,128,129,130,131,1***133,134,135,0,0,0,0,0,0,0,0,0,0,0,0,310,238'; break;
						case 25: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,136,137,138,139,140,141,142,143,0,0,0,0,0,0,0,0,0,0,0,0,309,237'; break;
						case 26: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,207,208,209,210,211,212,213,214,0,0,0,0,0,0,0,0,0,0,0,0,311,239'; break;
						case 27: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,215,216,217,218,219,220,221,222,0,0,0,0,0,0,0,0,0,0,0,0,312,240'; break;
						case 28: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,144,145,146,147,148,149,150,151,230,0,0,0,0,0,0,0,0,0,0,0,316,244'; break;
						case 29: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,152,153,154,155,156,157,158,159,0,0,0,0,0,0,0,0,0,0,0,0,315,243'; break;
						case 30: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,160,161,162,163,164,165,166,167,0,0,0,0,0,0,0,0,0,0,0,0,314,242'; break;
						case 31: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,0,313,241'; break;
					}
					if (($fjob >= 1) && ($fjob <= 4))
						$lvl = ', stat_str = 15, stat_int = 15, stat_sta = 15, stat_dex = 15, statpoints = 28 ';
					if (($fjob >= 16) && ($fjob <= 23))
						$lvl = ', level = 60, exp = 644602 ';
					else
						$lvl = '';
					$s_query = '';
					switch($fjob)
					{
						case 1: $sp = $sp + 40; break;
						case 2: $sp = $sp + 60; break;
						case 3: $sp = $sp + 60; break;
						case 4: $sp = $sp + 90; break;
						case 6: $sp = $sp + 100; break;
						case 7: $sp = $sp + 60; break;
						case 8: $sp = $sp + 80; break;
						case 9: $sp = $sp + 100; break;
						case 10: $sp = $sp + 100; break;
						case 11: $sp = $sp + 120; break;
						case 12: $sp = $sp + 90; break;
						case 13: $sp = $sp + 300; break;
					}
					if (($fjob >= 1) && ($fjob <= 13))
						$s_query = ", skillpoints = $sp";
					$query = mysql_query("update characters set class = $fjob, skills = '$skills'$lvl$s_query where id = $id");
					if (mysql_affected_rows() != 0)
					{
						echo "<h3>Successfully Changed Job!</h3>";
					}
					else
					{
						echo "<h3><font color='#FF0000'>AVISO</font>: Erro ao mudar job.</h3>";
					}
				}
				else
				{	
					echo "<h3><font color='#FF0000'>AVISO</font>: Erro ao mudar job.</h3>";
				}
			}
		} 
	}
	}
	if ($act == 'tele')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $ok = $_GET["success"];
            $error = $_GET["fail"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $telefl = $get['telefl'];
            $telesm = $get['telesm'];
            $teledk1 = $get['teledk1'];
            $teledk2 = $get['teledk2'];
            $teledk3 = $get['teledk3'];
			$teleazria = $get['teleazria'];
			$televolcan = $get['televolcan'];
			$telefortower = $get['telefortower'];
			$telecw = $get['telecw'];
			$posX = $get['posX'];
			$posY = $get['posY'];
			$posZ = $get['posZ'];
			$posWorldID = $get['posWorldID'];
            echo "<font size='3'><fieldset><legend>  <b>Teleport</b>  </legend>";
            echo "<b>Instructions</b>: Click your desired destination.<br>";
			echo "<b>Current Location:</b> World $posWorldID  x$posX  y$posY  z$posZ<br><br>";
            echo "<a href='changejob.php?a=telefl&charid=$id' style='text-decoration: none;'>Flaris</a> $telefl<br>";
            echo "<a href='changejob.php?a=telesm&charid=$id' style='text-decoration: none;'>Saint Morning</a> $telesm <br>";
            echo "<a href='changejob.php?a=teledk1&charid=$id' style='text-decoration: none;'>Darkon 1</a> $teledk1 <br>";
            echo "<a href='changejob.php?a=teledk2&charid=$id' style='text-decoration: none;'>Darkon 2</a> $teledk2 <br>";
            echo "<a href='changejob.php?a=teledk3&charid=$id' style='text-decoration: none;'>Darkon 3</a> $teledk3 <br>";
            echo "<a href='changejob.php?a=teleazria&charid=$id' style='text-decoration: none;'>Azria</a> $teleazria <br>";
			echo "<a href='changejob.php?a=televolcan&charid=$id' style='text-decoration: none;'>Volcano</a> $televolcan <br>";
			echo "<a href='changejob.php?a=telefortower&charid=$id' style='text-decoration: none;'>Forsaden Tower</a> $telefortower <br>";
			echo "<a href='changejob.php?a=telecw&charid=$id' style='text-decoration: none;'>Clockwork Cage</a> $telecw <br>";
            echo "</fieldset>";
         }
      }
	        if ($act == 'telefl')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 6950 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 50 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3250 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Flaris!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	        if ($act == 'telesm')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 8465 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 50 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3620 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Saint Morning!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	        if ($act == 'teledk1')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 5573 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 75 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3904 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Darkon 1!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'teledk2')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 3850 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 50 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 4440 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Darkon 2!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'teledk3')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 3222 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 10 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3421 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Darkon 3!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'teleazria')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 2 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 1272 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 114 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 1125 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Azria!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'televolcan')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 203 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 1411 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 86 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 510 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Volcano!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	if ($act == 'telefortower')
		{
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 150 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 253 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 100 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 78 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Forsaden Tower!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
		if ($act == 'telecw')
			{
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 3889 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 53 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3923 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Clockwork Cage!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	if ($act == 'listbuff')//big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$cQuery = mysql_query("select * from characters where id = $id");
				$char = mysql_fetch_assoc($cQuery);
				$job = $char["class"];
				$str = $char["str"];
				$int = $char["int"];
				$dex = $char["dex"];
				$cCannon = ' checked';
				$cProtect = ' checked';
				$cQS = ' checked';
				$cCats = ' checked';
				$cHeapUp = ' checked';
				$cSF = ' checked';
				$cGT = ' checked';
				$cPatience = '';
				$cAccuracy = '';
				$cBeefUp = '';
				$cHaste = '';
				$cMental = '';
				if ((em($job, '0', '1', '6', '7', '11', '16', '17', '21', '24', '25', '29')) || ((em($job, 2, 3, 8, 10, 18, 20, 26, 28)) && $str >= 20))
				{
					$cBeefUp = ' checked';
					$cHaste = ' checked';
					$cAccuracy = ' checked';
				}
				if ((em($job, '4', '12', '13', '22', '23', '30', '31')) || ((em($job, '3', '10', '20', '28')) && $int >= 20))
				{
					$cMental = ' checked';
				}
				if ((em($job, '2', '8', '18', '26')) && $dex >= 20)
				{
					$cHaste = ' checked';
					$cAccuracy = ' checked';
				}
				if (em($job, '9', '19', '27'))
				{
					$cHaste = ' checked';
					$cAccuracy = ' checked';
					$cMental = ' checked';
				}
				echo "<fieldset style='padding:5px;'><legend>  Buffs  </legend>";
				echo "<form action='changejob.php?a=buffar&char=$id' method='POST' name='buff' id='buff'>";
				echo "<table border=1 cellpadding='1' cellspacing='0'>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='116'$cAccuracy> 

Accuracy</label></td><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='53'$cBeefUp> Beef Up</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='50'$cCannon>  Cannon 

Ball</label></td><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='115'$cCats> Cat's Reflex</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='150'$cGT> Geburah 

Tiphreth</label></td><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='20'$cHaste> Haste</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='49'$cHeapUp> Heap Up</label></td><td 

style='width:250px;'><label><input type='checkbox' name='chkb[]' value='52'$cMental> Mental Sign</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='46'$cPatience> Patience</label></td><td 

style='width:250px;'><label><input type='checkbox' name='chkb[]' value='146'$cProtect> Protect</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='114'$cQS> Quick Step</label></td><td 

style='width:250px;'><label><input type='checkbox' name='chkb[]' value='148'$cSF> Spirit Fortune</label></td></tr>";
				echo "<tr><td colspan=2><label><input type='checkbox' name='selall'  onClick='sel();'> Select / Deselect All</label></td></tr>";
				echo "</table><div style='height:7px; width:100%'></div>";
				echo "<input type='submit' value='Buffs' name='buff' style='position:relative;float:left;'>";
				echo "</form>";
				echo "</fieldset>";
				$act = 'char';
				continue;
			}
		} 
	}
	if ($act == 'buffar')//big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$chkBuff = $_POST["chkb"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			//$resultado = mysql_query("select * from accounts where username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$tempo = 60000 * 60 * 3;
				$query = mysql_query("delete from buffs where ((skillid = 49) OR (skillid = 116) OR (skillid = 20) OR (skillid = 115) OR (skillid = 46) 

OR (skillid = 114) OR (skillid = 50) OR (skillid = 53) OR (skillid = 148) OR (skillid = 150) OR (skillid = 52) OR (skillid = 146)) AND charid = $id");
				for ($cont = 0; $cont < count($chkBuff); $cont++)
				{
					switch ($chkBuff[$cont])
					{
						case 49:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('49', '20', '4', '40', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 116:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('116', '20', '47', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 20:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('20', '20', '24', '500', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 115:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('115', '20', '14', '12', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 46:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('46', '20', '35', '210', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 114:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('114', '20', '11', '30', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 50:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('50', '20', '2', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 53:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('53', '20', '1', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 148:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('148', '10', '63', '140', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 150:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('150', '10', '63', '150', '24', '500', '0', '0', '$tempo', '$id');");
									break;
						case 52:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('52', '20', '3', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 52:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('146', '10', '26', '50', '0', '0', '0', '0', '$tempo', '$id');");
									break;
					}
				}
				if (mysql_affected_rows() != 0)
				{
					echo "<h3>Buffed your Character Successfully.</h3>";
				}
				else
				{
					echo "<h3><font color='#FF0000'>WARNING</font>: Error attempting to buffer. either you not select a skill to 

buffs.</h3>";
				}
			}
/*			else
			{
				echo "<h3><font color='#FF0000'>ERROR</font>: This in its char.</h3>";
				$act = 'login';
			}
*/
		} 
	}
	
	if ($act == 'senha')
	{
		if (isset($_SESSION['user']))
		{
			$login = $_POST["login"];
			$senhaA = $_POST["senhaAntiga"];
			$senhaN = $_POST["senhaNova"];
			$senhaN2 = $_POST["senhaNova2"];
			if ((!isSet($_POST["login"])) && (!isSet($_POST["senhaAntiga"])) && (!isSet($_POST["senhaNova"])) && (!isSet($_POST["senhaNova2"])))
			{
				echo '<form method="post" action="changejob.php?a=senha">';
				echo 'Login <input type="text" name="login" READONLY value="' . $user . '"><p>';
				echo 'Old Password <input type="password" name="senhaAntiga"><p>';
				echo 'New Password <input type="password" name="senhaNova"><p>';
				echo 'Confirm New Password <input type="password" name="senhaNova2"><p>';
				echo '<input type="submit" value="OK" name="OK">';
				echo '</form>';
			}
			else
			{
				$senhaNova = md5("kikugalanet" . $senhaN);
				if (md5("kikugalanet" . $senhaN2) != $senhaNova)
				{
					echo "<h3><font color='#FF0000'>WARNING</font>: The new passwords in known.</h3>";
					unset($_POST["login"]);
					unset($_POST["senhaAntiga"]);
					unset($_POST["senhaNova"]);
					unset($_POST["senhaNova2"]);
				}
				else
				{
					$senhaAntiga = md5("kikugalanet" . $senhaA);
					$res = mysql_query("select * from accounts where username = '$login' AND password = '$senhaAntiga'");
					$qtde = mysql_num_rows($res);
					if ($qtde == 0)
					{
						echo "<h3><font color='#FF0000'>NOTICE</font>: Please fill up all fields.</h3>";
						unset($_POST["login"]);
						unset($_POST["senhaAntiga"]);
						unset($_POST["senhaNova"]);
						unset($_POST["senhaNova2"]);
					}
					else
					{
						$res = mysql_query("update accounts set password = '$senhaNova' where username = '$login' and password = 

'$senhaAntiga'");
						if (mysql_affected_rows() != 0)
						{
							echo "<h3>Password changed successfully.</h3>";
							unset($_POST["login"]);
							unset($_POST["senhaAntiga"]);
							unset($_POST["senhaNova"]);
							unset($_POST["senhaNova2"]);						}
						else
						{
							echo "<h3><font color='#FF0000'>WARNING</font>: Error attempting to change Password.</h3>";
							unset($_POST["login"]);
							unset($_POST["senhaAntiga"]);
							unset($_POST["senhaNova"]);
							unset($_POST["senhaNova2"]);
						}
					}
				}
			}
		}  
	}
	if ($act == 'restat')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $ok = $_GET["success"];
            $error = $_GET["fail"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_str = $get['stat_str'];
            $stat_sta = $get['stat_sta'];
            $stat_dex = $get['stat_dex'];
            $stat_int = $get['stat_int'];
            $statpoints = $get['statpoints'];
            echo "<font size='3'><fieldset><legend>  <b>RE-STAT</b>  </legend>";
            echo "<b>Instructions</b>: Simply click on a stat to return all the stat points back to your unused stat points.<br><br>";
            echo "<b><a href='changejob.php?a=restatstr&charid=$id' style='text-decoration: none;'>Strength</a></b>: $stat_str<br>";
            echo "<b><a href='changejob.php?a=restatsta&charid=$id' style='text-decoration: none;'>Stamina</a></b>: $stat_sta <br>";
            echo "<b><a href='changejob.php?a=restatdex&charid=$id' style='text-decoration: none;'>Dexitery</a></b>: $stat_dex <br>";
            echo "<b> <a href='changejob.php?a=restatint&charid=$id' style='text-decoration: none;'>Intellegence</b></a>: $stat_int <br>";
            echo "<b>Unused Stat Points</b>: $statpoints <br></font>";
            
            echo "</fieldset>";
         }
      }
      if ($act == 'restatstr')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_str = $get['stat_str'];
            $statpoints = $get['statpoints'];
            $truestr = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_str - $truestr WHERE id = $id");
            mysql_query("UPDATE characters SET stat_str = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Strength stat reset successfuly!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'restatsta')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_sta = $get['stat_sta'];
            $statpoints = $get['statpoints'];
            $truesta = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_sta - $truesta WHERE id = $id");
            mysql_query("UPDATE characters SET stat_sta = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Stamina stat reset successfuly!</h3></center>";
			  
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'restatdex')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_dex = $get['stat_dex'];
            $statpoints = $get['statpoints'];
            $truedex = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_dex - $truedex WHERE id = $id");
            mysql_query("UPDATE characters SET stat_dex = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Dextery stat reset successfuly!</h3></center>";
			   
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'restatint')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_int = $get['stat_int'];
            $statpoints = $get['statpoints'];
            $trueint = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_int - $trueint WHERE id = $id");
            mysql_query("UPDATE characters SET stat_int = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Intellegence stat reset successfuly!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'reborn')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $class = $get['class'];
            $lvl = $get['level'];
            $rebirths = $get['rebirths'];
add   ``$penya = $get['penya'];``  here!!!
            
            if (($lvl == 120) && ($class >= 24) && ($class <= 31) && ($rebirths < $maxrebirths) && ($penya >= $rebirthcost))
            {
               if ($class == 24) { mysql_query("UPDATE characters SET class = 6 WHERE id = $id"); }
               if ($class == 25) { mysql_query("UPDATE characters SET class = 7 WHERE id = $id"); }
               if ($class == 26) { mysql_query("UPDATE characters SET class = 8 WHERE id = $id"); }
               if ($class == 27) { mysql_query("UPDATE characters SET class = 9 WHERE id = $id"); }
               if ($class == 28) { mysql_query("UPDATE characters SET class = 10 WHERE id = $id"); }
               if ($class == 29) { mysql_query("UPDATE characters SET class = 11 WHERE id = $id"); }
               if ($class == 30) { mysql_query("UPDATE characters SET class = 12 WHERE id = $id"); }
               if ($class == 31) { mysql_query("UPDATE characters SET class = 13 WHERE id = $id"); }
               
               mysql_query("UPDATE characters SET level = 60 WHERE id = $id");
               mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
               mysql_query("UPDATE characters SET posX = 6973 WHERE id = $id");
               mysql_query("UPDATE characters SET posY = 10 WHERE id = $id");
               mysql_query("UPDATE characters SET posZ = 3328 WHERE id = $id");
               mysql_query("UPDATE characters SET rebirths = rebirths + 1 WHERE id = $id");
			   mysql_query("UPDATE characters SET penya = $penya - $rebirthcost WHERE id = $id");
               
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Character has successfully been rebirth!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Your character can not yet be rebirth. You must be level 120 HERO and get 20000000 of penya.</h3></center>";
            }
        }
    }
      if ($act == 'transy')
   {
         $id = $_GET["charid"];
          $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
          $checkrows = @mysql_num_rows($matchrows);
          if ($checkrows != 0)
          {
            $id = $_GET['charid'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
            $sex = $get['sex'];
            if ($sex == 1) 
            { 
            mysql_query("UPDATE characters SET sex = 0 WHERE id = $id"); 
            echo "<center><h3>Congratulations! Your character is now Male.</h3></center>";
            }
            if ($sex == 0) 
            { 
            mysql_query("UPDATE characters SET sex = 1 WHERE id = $id");
            echo "<center><h3>Congratulations! Your character is now Female.</h3></center>";
            }
            if (mysql_affected_rows() == 0)
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
			}
		}

	if ($act == 'ulti')
	{
			{
				$id = $_GET["charid"];
				$query = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id 

AND a.username = '$user'") or die(mysql_error());
				$checkrows = mysql_num_rows($query);
				if ($checkrows != 0)
				{
					$ccQuery = mysql_query("SELECT * FROM `inventory` WHERE `charid` = '$id' AND `refine`='10'");
					$char = mysql_fetch_assoc($ccQuery);
					$itemid = $char['itemid'];
					$ultiid = NULL;
					
					//Guardian Ambidextrous Axe
					if($itemid == '22038')
					{
					$ultiid = '22383';
					}
					//Guardian Axe
					if($itemid == '22034')
					{
					$ultiid = '20378';
					}
					//Guardian Big Sword
					if($itemid == '22030')
					{
					$ultiid = '22373';
					}
					//Guardian Bow
					if($itemid == '22050')
					{
					$ultiid = '22398';
					}
					//Guardian Knuckle
					if($itemid == '22042')
					{
					$ultiid = '22388';
					}
					//Guardian Staff
					if($itemid == '22062')
					{
					$ultiid = '22413';
					}
					//Guardian Stick
					if($itemid == '22046')
					{
					$ultiid = '22393';
					}
					//Guardian Sword 
					if($itemid == '22026')
					{
					$ultiid = '22368';
					}
					//Guardian Wand
					if($itemid == '22058')
					{
					$ultiid = '22408';
					}
					//Guardian Yo-Yo
					if($itemid == '22054')
					{
					$ultiid = '22403';
					}
					
					//Historic Ambidextrous Axe
					if($itemid == '22039')
					{
					$ultiid = '22384';
					}
					//Historic Axe 
					if($itemid == '22035')
					{
					$ultiid = '22379';
					}
					//Historic Big Sword
					if($itemid == '22031')
					{
					$ultiid = '22374';
					}
					//Historic Bow
					if($itemid == '22051')
					{
					$ultiid = '22399';
					}
					//Historic Knuckle
					if($itemid == '22043')
					{
					$ultiid = '22389';
					}
					//Historic Staff
					if($itemid == '22063')
					{
					$ultiid = '22414';
					}
					//Historic Stick
					if($itemid == '22047')
					{
					$ultiid = '22394';
					}
					//Historic Sword
					if($itemid == '22027')
					{
					$ultiid = '22369';
					}
					//Historic Wand
					if($itemid == '22059')
					{
					$ultiid = '22409';
					}
					//Historic Yo-Yo
					if($itemid == '22055')
					{
					$ultiid = '22404';
					}
					
					//Angel Axe
					if($itemid == '22036')
					{
					$ultiid = '22380';
					}
					//Angel Big Sword
					if($itemid == '22032')
					{
					$ultiid = '22375';
					}
					//Angel Bow
					if($itemid == '22052')
					{
					$ultiid = '22400';
					}
					//Angel Glove
					if($itemid == '22044')
					{
					$ultiid = '22390';
					}
					//Angel Staff
					if($itemid == '22064')
					{
					$ultiid = '22415';
					}
					//Angel Stick
					if($itemid == '22048')
					{
					$ultiid = '22395';
					}
					//Angel Sword
					if($itemid == '22028')
					{
					$ultiid = '22370';
					}
					//Angel Wand
					if($itemid == '22060')
					{
					$ultiid = '22410';
					}
					//Angel Yo-Yo
					if($itemid == '22056')
					{
					$ultiid = '22405';
					}
					
					//Legendary Big Golden Axe
					if($itemid == '22041')
					{
					$ultiid = '22386';
					}
					//Legendary Golden Axe
					if($itemid == '22037')
					{
					$ultiid = '22381';
					}
					//Legendary Golden Big Sword
					if($itemid == '22033')
					{
					$ultiid = '22376';
					}
					//Legendary Golden Bow
					if($itemid == '22053')
					{
					$ultiid = '22401';
					}
					//Legendary Golden Gloves 
					if($itemid == '22045')
					{
					$ultiid = '22391';
					}
					//Legendary Golden Staff
					if($itemid == '22065')
					{
					$ultiid = '22416';
					}
					//Legendary Golden Stick
					if($itemid == '22049')
					{
					$ultiid = '22396';
					}
					//Legendary Golden Sword
					if($itemid == '22029')
					{
					$ultiid = '22371';
					}
					//Legendary Golden Wand
					if($itemid == '22061')
					{
					$ultiid = '22411';
					}
					//Legendary Golden Yo-Yo
					if($itemid == '22057')
					{
					$ultiid = '22406';
					}
					
					//Bloody Axe
					if($itemid == '22356')
					{
					$ultiid = '22382';
					}
					//Bloody Two-Handed Axe
					if($itemid == '22357')
					{
					$ultiid = '22375';
					}
					//Bloody Bow
					if($itemid == '22363')
					{
					$ultiid = '22402';
					}
					//Bloody Knuckle
					if($itemid == '22358')
					{
					$ultiid = '22392';
					}
					//Bloody Staff
					if($itemid == '22361')
					{
					$ultiid = '22417';
					}
					//Bloody Stick
					if($itemid == '22359')
					{
					$ultiid = '22397';
					}
					//Bloody Sword
					if($itemid == '22354')
					{
					$ultiid = '22372';
					}
					//Bloody Wand
					if($itemid == '22360')
					{
					$ultiid = '22412';
					}
					//Bloody Yo-Yo
					if($itemid == '22362')
					{
					$ultiid = '22407';
					}
					//Bloody Slayer
					if($itemid == '22355')
					{
					$ultiid = '22377';
					}
					if ($ultiid != NULL)
					{
					
						$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND 

`charid` = '".$id."'";
						
					
						if(mysql_query($sql)){
						
							echo "<h3><center>Have fun with your new Ultimate Weapon!</center></h3>";
							
						}else{
						
						
							echo "Mistake";
						
						
						}	
					}
					else
					{
						echo "<h3><center>You don't have any green weapon +10 in your inventary!</center></h3>";
					}
				}
			}
			}
	if ($act == 'size')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $ok = $_GET["success"];
            $error = $_GET["fail"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $size05 = $get['size05'];
            $size1 = $get['size1'];
            $size15 = $get['size15'];
            $size2 = $get['size2'];
			$sizecustom = $get['sizecustom'];	
			echo "<font size='3'><fieldset><legend>  <b>Change Size</b>  </legend>";
            echo "<b>Instructions</b>: Simply click on size buttons and you will get your size. Min size 0.1 - Max size 2.0 <font color=red> (10000000 penya 

cost).</font><br><br>";
            echo "<b><a href='changejob.php?a=size05&charid=$id' style='text-decoration: none;'>Size 0.5</a></b><br>";
            echo "<b><a href='changejob.php?a=size1&charid=$id' style='text-decoration: none;'>Size 1.0</a></b><br>";
            echo "<b><a href='changejob.php?a=size15&charid=$id' style='text-decoration: none;'>Size 1.5</a></b><br>";
            echo "<b><a href='changejob.php?a=size2&charid=$id' style='text-decoration: none;'>Size 2.0</b></a><br>";
			echo "<b><a href='changejob.php?a=sizecustombox&charid=$id' style='text-decoration: none;'>Size Custom</b></a><br>";
			echo "</fieldset>";
			}
			}
      if ($act == 'size0.5')
       {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 0.5 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 0.5!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
      if ($act == 'size1.0')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 1.0 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 1.0!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
      if ($act == 'size1.5')
       {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 1.5 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 1.5!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
      if ($act == 'size2.0')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 2.0 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 2.0</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
	     if ($act == 'sizecustom')
		{
            $id = $_GET["charid"];
            $size = $_POST['size'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);

			$con = mysql_query("UPDATE characters SET sizeMod = '$size' where id = '$id'");
			
			echo "<center><h3>Congratulations! Your size have changed!</h3></center>";
			}
			
		if ($act == 'sizecustombox')
		{
	echo "<center><td colspan=4 align='center'><fieldset><legend>  <b>Size Custom  </b></legend></td>";
	echo "<form action='changejob.php?a=sizecustom&charid=$charid' method='post' >";
	echo "<td width ='107' align = 'right'><strong>New Size</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='sizeMod' type='text'/></td></br>";
	echo "</br><td><input type='submit' value='Change my Size'/></td></br>";
	echo "</tr>";
	echo "</form>";
	echo "</fieldset></center>";
	}
          if ($act == 'changenam')
		  {
            $id = $_GET["charid"];
            $name = $_POST['name'];
            $oldname = $_POST['oldname'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);

			$query = mysql_query("UPDATE characters SET charname = '$name' where charname = '$oldname'");
			
			echo "<center><h3>Congratulations! Your name have changed!</h3></center>";
			}
			 
			 if ($act == 'changename')
			 {			 
	echo "<center><td colspan=4 align='center'><fieldset><legend>  <b>Change Name  </b></legend></td>";
	echo "<form action='changejob.php?a=changenam&charid=$id' method='post' >";
	echo "<td width ='107' align = 'right'><strong>New Name</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='name' type='text'/></td></br></br>";
	echo "<td width ='107' align ='right'><strong>Old Name</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='oldname' type='text'/></td></br>";
	echo "</br><td><input type='submit' value='Change my Name'/></td></br>";
	echo "</tr>";
	echo "</form>";
	echo "</fieldset></center>";
	}
?>
<?php
?>
<br>
<center><font size=3> Gabs And Miller</center></font>
<center><font size=3>Fly For Philippine</center></font>
<font size=1>

zedawg · May 11, 2009

lol you added the complete sentence...only add

$penya = $get['penya'];

derekgabs · May 11, 2009

now i got an error of
"Parse error: parse error in C:\wamp\www\FlyForAll\Change\changejob.php on line 1593"

Code:

<?php
 	//THIS MUST COME IN HOME PAGE, BEFORE YOU ALL, INCLUDING <html>
	require "config.php";
	session_start();
	$user = $_SESSION['user'];
	$login = $_POST['login'];
	$senha = $_POST['senha'];
	$act = $_GET['a'];
	function em()
	{
		$args = func_get_args();
		for ($cont = 1; $cont < func_num_args(); $cont++)
		{
			$arg = func_get_arg($cont);
			if ($arg == $args[0])
				return true;
		}
		return false;
	}
?>
<html>
<head>
<style type="text/css">
<!--
body {
	background-image: url(images/bg103.gif);
}
-->
</style><body>
<script language="javascript" type="text/javascript">
function sel()
{
	for(var x = 0; x < document.buff.elements.length; x++)
	{
		var y = document.buff.elements[x];
		if (y.name != 'selall')
			y.checked = document.buff.selall.checked;
		}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a:link {
	color: #000000;
	text-decoration: underline;
}
a:visited {
	text-decoration: underline;
	color: #000000;
}
a:hover {
	text-decoration: none;
	color: #000000;
}
a:active {
	text-decoration: underline;
	color: #000000;
}
-->
</style>
</head>
<body>
<?php
?>
<?php
{
      echo "<table style='margin-top: 5px; border-style: inset; border-width: 1px; border-spacing: 0px; font-size: 9pt;' width='98%' height='25' align='center'><tr 

valign='center'><td><div style='float: left; margin-left: 5px;'><b>Welcome $user</b>          <a 

href='http://flyffemergencia.servegame.com/index.php' style='text-decoration: none;'>Home</a>  |  <a href='changejob.php?a=senha' 

style='text-decoration: none;'>Change Password</a>  |  <a href='http://flyffemergencia.servegame.com/chat.php' style='text-decoration: 

none;'>Live Chat</a>  |  <a href='logout.php' style='text-decoration: none;'>Logout</a></div></td></tr></table>";
	  echo "<table style='margin-top: 5px; border-style: inset; border-width: 1px; border-spacing: 0px; font-size: 9pt;' width='98%' height='25' align='center'><tr 

valign='center'><td><div style='float: left; margin-left: 5px;'><b>Welcome Administrator</b>          <a 

href='changejob.php?a=adminpanel' style='text-decoration: none;'>Admin Panel</a>  |  <a href='changejob.php?a=ipban' style='text-decoration: 

none;'>IP Ban</a>  |  <a href='changejob.php?a=database' style='text-decoration: none;'>Database 

Controller</a>  </div></td></tr></table>";
	  echo "<title>Fly For Friends - $user's user control panel</title>";
	  if (($act != 'login') && ($act != 'char') && ($act != 'job') && ($act != 'setjob') && ($act != 'listbuff') && ($act != 'buffar') && ($act != 'senha') && ($act !='transy') 

&& ($act !='reborn') && ($act !='restat') && ($act !='restatstr') && ($act !='restatsta') && ($act !='restatdex') && ($act !='restatint') && ($act !='size') && ($act !='size0.5') 

&& ($act !='size1.0') && ($act !='size1.5') && ($act !='size2.0') && ($act!='sizecustom') && ($act!='sizecustombox') && ($act !='tele') && ($act !='telefl') && ($act 

!='telesm') && ($act !='teledk1') && ($act !='teledk2') && ($act !='teledk3') && ($act !='teleazria') && ($act !='televolcan') && ($act !='telefortower') && ($act !='telecw') 

&& ($act!='telecoral') && ($act!='changename') && ($act!='ultiname') && ($act!='ultichar') && ($act!='changenam') && ($act!='ipban') && ($act!='database') && 

($act!='adminpanel') && ($act !='ulti'))
	{
		echo '<form method="post" action="changejob.php?a=login">';
		echo 'Login <input type="text" name="login"><p>';
		echo 'Password <input type="password" name="senha"><p>';
		echo '<input type="submit" value="login" name="OK">';
		echo '</form>';
		}
	if ($act == 'login')
	{
		$senha = md5('kikugalanet' . $senha);
		$resultado = mysql_query("select * from accounts where username = '$login' and password = '$senha'");
		if (is_resource($resultado))
			$qde_registros = mysql_num_rows($resultado);
		if ($qde_registros != 0)
		{
			$act = 'char';
			$_SESSION['user'] = $login;
			$user = $login;
			session_write_close();	
		}
		else
		{
			echo "<font color='#FF0000'>ID or password incorrect, please try again.</font><br>";
			echo '<form method="post" action="changejob.php?a=login">';
			echo 'Login <input type="text" name="login"><p>';
			echo 'Password <input type="password" name="senha"><p>';
			echo '<input type="submit" value="login" name="OK">';
			echo '</form>';
		}
	}
	if ($act == 'char')
	{
		if (isset($_SESSION['user']))
		{
			$resultado = mysql_query("select * from accounts AS a WHERE a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$resultado = mysql_query("select * from characters where accountname = '$user' order by charslot asc");
				$qde_registros = mysql_num_rows($resultado);
				if ($qde_registros == 0)
					echo "You have no characters on this account<br>";
				else
					echo "<fieldset><legend>  PICK THE CHAR  </legend>";
				$qtde = $qde_registros;
				while ($reg = mysql_fetch_assoc($resultado))
				{
					$qtde--;
					$idJob = $reg['class'];
					if ($idJob == 0) $nomeJob = 'Vagrant';
					if ($idJob == 1) $nomeJob = 'Mercenary';
					if ($idJob == 2) $nomeJob = 'Acrobat';
					if ($idJob == 3) $nomeJob = 'Assist';
					if ($idJob == 4) $nomeJob = 'Magician';
					if ($idJob == 6) $nomeJob = 'Knight';
					if ($idJob == 7) $nomeJob = 'Blade';
					if ($idJob == 8) $nomeJob = 'Jester';
					if ($idJob == 9) $nomeJob = 'Ranger';
					if ($idJob == 10) $nomeJob = 'Ringmaster';
					if ($idJob == 11) $nomeJob = 'Billposter';
					if ($idJob == 12) $nomeJob = 'Psykeeper';
					if ($idJob == 13) $nomeJob = 'Elementor';
					if ($idJob == 16) $nomeJob = 'Knight [Master]';
					if ($idJob == 17) $nomeJob = 'Blade [Master]';
					if ($idJob == 18) $nomeJob = 'Jester [Master]';
					if ($idJob == 19) $nomeJob = 'Ranger [Master]';
					if ($idJob == 20) $nomeJob = 'Ringmaster [Master]';
					if ($idJob == 21) $nomeJob = 'Billposter [Master]';
					if ($idJob == 22) $nomeJob = 'Psykeeper [Master]';
					if ($idJob == 23) $nomeJob = 'Elementor [Master]';
					if ($idJob == 24) $nomeJob = 'Knight - <img src="images/h.png"';
					if ($idJob == 25) $nomeJob = 'Blade - <img src="images/h.png"';
					if ($idJob == 26) $nomeJob = 'Jester - <img src="images/h.png"';
					if ($idJob == 27) $nomeJob = 'Ranger - <img src="images/h.png"';
					if ($idJob == 28) $nomeJob = 'Ringmaster - <img src="images/h.png"';
					if ($idJob == 29) $nomeJob = 'Billposter - <img src="images/h.png"';
					if ($idJob == 30) $nomeJob = 'Psykeeper - <img src="images/h.png"';
					if ($idJob == 31) $nomeJob = 'Elementor - <img src="images/h.png"';
					$slot = $reg['charslot'];
         $name = $reg['charname'];
         $lvl = $reg['level'];
         $rebirths = $reg['rebirths'];
         $id = $reg['id'];
         $sex = $reg['sex'];
         if ($sex == 0) $truesex = 'Male';
         if ($sex == 1) $truesex = 'Female';
		 $sizeMod = $reg['sizeMod'];
		 $penya = $reg['penya'];
         echo "<fieldset><legend>  <font size='3'><b> Slot $slot </b>  </legend>";
         echo "<b>Name</b>: <font size='3'><font color='#FF0000'>$name</font><br>"; 
         echo "<b>Sex</b>: <font color='#FF0000'>$truesex</font><br>";
         echo "<b>Level</b>: <font color='#FF0000'>$lvl</font><br>";
		 echo "<b>Job</b>: <font color='#FF0000'>$nomeJob</font><br>";
         echo "<b>Rebirths</b>: <font color='#FF0000'>$rebirths</font><br>";
		 echo "<b>Sizemod</b>: <font color='#FF0000'>$sizeMod</font><br>";
		 echo "<b>Penya</b>: <font color='#FF0000'>$penya</font><br>";
         echo "<hr size='1'>";
         if ($reg['channelnum'] == -1)
					{
						echo "<a href='changejob.php?a=job&char=$id' style='text-decoration: none;'>Change 

Job</a> | <a href='changejob.php?a=tele&charid=$id' style='text-decoration: none;'>Teleport</a>  |  <a 

href='changejob.php?a=listbuff&char=$id' style='text-decoration: none;'>Buffs</a>  |  <a href='changejob.php?a=transy&charid=$id' style='text-decoration: 

none;'>Change Sex</a>  |  <a href='changejob.php?a=restat&charid=$id' style='text-decoration: none;'>Restat</a>  |  <a 

href='changejob.php?a=size&charid=$id' style='text-decoration: none;'>Change Size</a>  |  <a href='changejob.php?a=changename&charid=$id' 

style='text-decoration: none;'>Change Name</a>  |  <a href='changejob.php?a=ulti&charid=$id' style='text-decoration: none;'>Make Ultimate</a> 

 |  </a> <a href='changejob.php?a=reborn&charid=$id' style='text-decoration: none;'>Rebirth</a>";
					}
					else
						 echo "Your character is Online, you must be logged out of the game before you can edit your character.";
         echo "</fieldset>";
         if ($qtde != 0) { echo ""; }
      }
      if ($checkchars != 0)
      {
         echo "</td>";
      }
      
      echo "<td width='25%' height='100'><fieldset height='100'><div aling=right><legend>  <b> GameMaster Online </b>  </legend>";
      $querygm = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE a.accesslevel >= 800 AND a.logged_in 

= 1 AND c.channelnum >= 1");
      $listgm = mysql_num_rows($querygm);
      if ($listgm == 0)
         echo "<br><br>There are no GMs online.<br>";
      else
         echo "<br><right>";
      $qtde = $listgm;
      while ($reg = mysql_fetch_assoc($querygm))
      {
         
         $qtde--;
         $gmchar = $reg['charname'];
         echo "<div style='float: left;' align='left'><b>$gmchar</b></div> <div align='left'>      <img 

src='images/on.png'></div><br>";
         if ($qtde != 0) { echo ""; }
         
      }
      echo "</center><br><br></fieldset></td></tr>";
      echo "<tr><td colspan='2'>"; 
			}
		}
	}
		if ($act == 'job') //big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$resultado = mysql_query("select * from characters where id = $id");
				$reg = mysql_fetch_assoc($resultado);
				$lvl = $reg['level'];
				$job = $reg['class'];
				$mostrou = 'false';
				echo "<fieldset><legend>  <b>CHOOSE YOUR JOB</b>  </legend>";
				if (($lvl == 15) && ($job == 0))
				{
					$mostrou = 'true';
					echo "<a href='changejob.php?a=setjob&char=$id&job=1' style='text-decoration: none;'>Mercenary</a><br>";
					echo "<a href='changejob.php?a=setjob&char=$id&job=2' style='text-decoration: none;'>Acrobat</a><br>";
					echo "<a href='changejob.php?a=setjob&char=$id&job=3' style='text-decoration: none;'>Assist</a><br>";
					echo "<a href='changejob.php?a=setjob&char=$id&job=4' style='text-decoration: none;'>Magician</a><br>";
				}
				if (($lvl == 60) && ($job >= 1) && ($job <= 4))
				{
					$mostrou = 'true';
					switch($job)
					{
						case 1:	echo "<a href='changejob.php?a=setjob&char=$id&job=6' style='text-decoration: 

none;'>Knight</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=7' style='text-decoration: 

none;'>Blade</a><br>";
								break;
						case 2: echo "<a href='changejob.php?a=setjob&char=$id&job=8' style='text-decoration: 

none;'>Jester</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=9' style='text-decoration: 

none;'>Ranger</a><br>";
								break;
						case 3: echo "<a href='changejob.php?a=setjob&char=$id&job=10' style='text-decoration: 

none;'>Ringmaster</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=11' style='text-decoration: 

none;'>BillPoster</a><br>";
								break;
						case 4: echo "<a href='changejob.php?a=setjob&char=$id&job=12' style='text-decoration: 

none;'>Psykeeper</a><br>";
								echo "<a href='changejob.php?a=setjob&char=$id&job=13' style='text-decoration: 

none;'>Elementor</a><br>";
								break;
					}
				}
				if (($lvl == 120) && ($job >= 6) && ($job <= 13))
				{
					$mostrou = 'true';
					switch($job)
					{
						case 6:		echo "<a href='changejob.php?a=setjob&char=$id&job=16' style='text-decoration: 

none;'>Knight [M]</a><br>";
									break;
						case 7:		echo "<a href='changejob.php?a=setjob&char=$id&job=17' style='text-decoration: 

none;'>Blade [M]</a><br>";
									break;
						case 8: 	echo "<a href='changejob.php?a=setjob&char=$id&job=18' style='text-decoration: none;'>Jester 

[M]</a><br>";
									break;
						case 9: 	echo "<a href='changejob.php?a=setjob&char=$id&job=19' style='text-decoration: none;'>Ranger 

[M]</a><br>";
									break;
						case 10: 	echo "<a href='changejob.php?a=setjob&char=$id&job=20' style='text-decoration: none;'>Ringmaster 

[M]</a><br>";
									break;
						case 11: 	echo "<a href='changejob.php?a=setjob&char=$id&job=21' style='text-decoration: none;'>BillPoster 

[M]</a><br>";
									break;
						case 12: 	echo "<a href='changejob.php?a=setjob&char=$id&job=22' style='text-decoration: none;'>Psykeeper 

[M]</a><br>";
									break;
						case 13: 	echo "<a href='changejob.php?a=setjob&char=$id&job=23' style='text-decoration: none;'>Elementor 

[M]</a><br>";
									break;
					}
				}
				if (($lvl == 120) && ($job >= 16) && ($job <= 23))
				{
					$mostrou = 'true';
					switch($job)
					{
						case 16:	echo "<a href='changejob.php?a=setjob&char=$id&job=24' style='text-decoration: none;'>Knight 

[H]</a><br>";
									break;
						case 17:	echo "<a href='changejob.php?a=setjob&char=$id&job=25' style='text-decoration: none;'>Blade 

[H]</a><br>";
									break;
						case 18: 	echo "<a href='changejob.php?a=setjob&char=$id&job=26' style='text-decoration: none;'>Jester 

[H]</a><br>";
									break;
						case 19: 	echo "<a href='changejob.php?a=setjob&char=$id&job=27' style='text-decoration: none;'>Ranger 

[H]</a><br>";
									break;
						case 20: 	echo "<a href='changejob.php?a=setjob&char=$id&job=28' style='text-decoration: none;'>Ringmaster 

[H]</a><br>";
									break;
						case 21: 	echo "<a href='changejob.php?a=setjob&char=$id&job=29' style='text-decoration: none;'>BillPoster 

[H]</a><br>";
									break;
						case 22: 	echo "<a href='changejob.php?a=setjob&char=$id&job=30' style='text-decoration: none;'>Psykeeper 

[H]</a><br>";
									break;
						case 23: 	echo "<a href='changejob.php?a=setjob&char=$id&job=31' style='text-decoration: none;'>Elementor 

[H]</a><br>";
									break;
					}
				}
				if ($mostrou == 'false')
				{
					echo "<h3><font color='#FF0000'>NOTICE</font>: Your char Already have a job, or your char is not Lvl 15 or 60 or 

120</h3>";
					echo "</fieldset>";
				}
				echo "</fieldset>";
			}
		} 
	}
	if ($act == 'setjob') //big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$fjob = $_GET["job"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$resultado = mysql_query("select * from characters where id = $id");
				$reg = mysql_fetch_assoc($resultado);
				$lvl = $reg['level'];
				$job = $reg['class'];
				$sp = $reg['skillpoints'];
				$passou = 'false';
				$passou = ((($lvl == 15) && ($job == 0) && ($fjob >= 1) && ($fjob <= 4)) || ($passou == 'true')) ? 'true' : 'false';
				
				$passou = ((($lvl == 60) && ($job == 1) && (($fjob == 6) || ($fjob == 7))) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 60) && ($job == 2) && (($fjob == 8) || ($fjob == 9))) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 60) && ($job == 3) && (($fjob == 10) || ($fjob == 11))) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 60) && ($job == 4) && (($fjob == 12) || ($fjob == 13))) || ($passou == 'true')) ? 'true' : 'false';
				
				$passou = ((($lvl == 120) && ($job == 6) && ($fjob == 16)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 7) && ($fjob == 17)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 8) && ($fjob == 18)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 9) && ($fjob == 19)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 10) && ($fjob == 20)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 11) && ($fjob == 21)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 12) && ($fjob == 22)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 13) && ($fjob == 23)) || ($passou == 'true')) ? 'true' : 'false';
				
				$passou = ((($lvl == 120) && ($job == 16) && ($fjob == 24)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 17) && ($fjob == 25)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 18) && ($fjob == 26)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 19) && ($fjob == 27)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 20) && ($fjob == 28)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 21) && ($fjob == 29)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 22) && ($fjob == 30)) || ($passou == 'true')) ? 'true' : 'false';
				$passou = ((($lvl == 120) && ($job == 23) && ($fjob == 31)) || ($passou == 'true')) ? 'true' : 'false';
				if ($passou == 'true')
				{
					switch($fjob)
					{
						case 1: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 2: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 3: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 4: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 6: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,128,129,130,131,1***133,134,135,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 7: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,136,137,138,139,140,141,142,143,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 8: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,207,208,209,210,211,212,213,214,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 9: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,215,216,217,218,219,220,221,222,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 10: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,144,145,146,147,148,149,150,151,230,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 11: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,152,153,154,155,156,157,158,159,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 12: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,160,161,162,163,164,165,166,167,0,0,0,0,0,0,0,0,0,0,0,0,0,0'; break;
						case 13: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,0,0,0'; break;
						case 16: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,128,129,130,131,1***133,134,135,0,0,0,0,0,0,0,0,0,0,0,0,310,0'; break;
						case 17: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,136,137,138,139,140,141,142,143,0,0,0,0,0,0,0,0,0,0,0,0,309,0'; break;
						case 18: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,207,208,209,210,211,212,213,214,0,0,0,0,0,0,0,0,0,0,0,0,311,0'; break;
						case 19: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,215,216,217,218,219,220,221,222,0,0,0,0,0,0,0,0,0,0,0,0,312,0'; break;
						case 20: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,144,145,146,147,148,149,150,151,230,0,0,0,0,0,0,0,0,0,0,0,316,0'; break;
						case 21: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,152,153,154,155,156,157,158,159,0,0,0,0,0,0,0,0,0,0,0,0,315,0'; break;
						case 22: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,160,161,162,163,164,165,166,167,0,0,0,0,0,0,0,0,0,0,0,0,314,0'; break;
						case 23: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,0,313,0'; break;
						case 24: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,128,129,130,131,1***133,134,135,0,0,0,0,0,0,0,0,0,0,0,0,310,238'; break;
						case 25: $skills = 

'0,0,0,4,5,6,9,10,7,8,11,12,13,14,108,************0,0,0,0,0,136,137,138,139,140,141,142,143,0,0,0,0,0,0,0,0,0,0,0,0,309,237'; break;
						case 26: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,207,208,209,210,211,212,213,214,0,0,0,0,0,0,0,0,0,0,0,0,311,239'; break;
						case 27: $skills = 

'0,0,0,191,192,193,194,195,1***1***198,1***200,201,202,203,204,205,206,0,0,0,0,215,216,217,218,219,220,221,222,0,0,0,0,0,0,0,0,0,0,0,0,312,240'; break;
						case 28: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,144,145,146,147,148,149,150,151,230,0,0,0,0,0,0,0,0,0,0,0,316,244'; break;
						case 29: $skills = 

'0,0,0,44,45,46,48,49,50,51,51,52,53,********113,********116,117,20,0,0,152,153,154,155,156,157,158,159,0,0,0,0,0,0,0,0,0,0,0,0,315,243'; break;
						case 30: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,160,161,162,163,164,165,166,167,0,0,0,0,0,0,0,0,0,0,0,0,314,242'; break;
						case 31: $skills = 

'0,0,0,64,65,69,70,107,118,119,120,121,30,31,***33,34,35,36,37,0,0,0,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,0,313,241'; break;
					}
					if (($fjob >= 1) && ($fjob <= 4))
						$lvl = ', stat_str = 15, stat_int = 15, stat_sta = 15, stat_dex = 15, statpoints = 28 ';
					if (($fjob >= 16) && ($fjob <= 23))
						$lvl = ', level = 60, exp = 644602 ';
					else
						$lvl = '';
					$s_query = '';
					switch($fjob)
					{
						case 1: $sp = $sp + 40; break;
						case 2: $sp = $sp + 60; break;
						case 3: $sp = $sp + 60; break;
						case 4: $sp = $sp + 90; break;
						case 6: $sp = $sp + 100; break;
						case 7: $sp = $sp + 60; break;
						case 8: $sp = $sp + 80; break;
						case 9: $sp = $sp + 100; break;
						case 10: $sp = $sp + 100; break;
						case 11: $sp = $sp + 120; break;
						case 12: $sp = $sp + 90; break;
						case 13: $sp = $sp + 300; break;
					}
					if (($fjob >= 1) && ($fjob <= 13))
						$s_query = ", skillpoints = $sp";
					$query = mysql_query("update characters set class = $fjob, skills = '$skills'$lvl$s_query where id = $id");
					if (mysql_affected_rows() != 0)
					{
						echo "<h3>Successfully Changed Job!</h3>";
					}
					else
					{
						echo "<h3><font color='#FF0000'>AVISO</font>: Erro ao mudar job.</h3>";
					}
				}
				else
				{	
					echo "<h3><font color='#FF0000'>AVISO</font>: Erro ao mudar job.</h3>";
				}
			}
		} 
	}
	}
	if ($act == 'tele')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $ok = $_GET["success"];
            $error = $_GET["fail"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $telefl = $get['telefl'];
            $telesm = $get['telesm'];
            $teledk1 = $get['teledk1'];
            $teledk2 = $get['teledk2'];
            $teledk3 = $get['teledk3'];
			$teleazria = $get['teleazria'];
			$televolcan = $get['televolcan'];
			$telefortower = $get['telefortower'];
			$telecw = $get['telecw'];
			$posX = $get['posX'];
			$posY = $get['posY'];
			$posZ = $get['posZ'];
			$posWorldID = $get['posWorldID'];
            echo "<font size='3'><fieldset><legend>  <b>Teleport</b>  </legend>";
            echo "<b>Instructions</b>: Click your desired destination.<br>";
			echo "<b>Current Location:</b> World $posWorldID  x$posX  y$posY  z$posZ<br><br>";
            echo "<a href='changejob.php?a=telefl&charid=$id' style='text-decoration: none;'>Flaris</a> $telefl<br>";
            echo "<a href='changejob.php?a=telesm&charid=$id' style='text-decoration: none;'>Saint Morning</a> $telesm <br>";
            echo "<a href='changejob.php?a=teledk1&charid=$id' style='text-decoration: none;'>Darkon 1</a> $teledk1 <br>";
            echo "<a href='changejob.php?a=teledk2&charid=$id' style='text-decoration: none;'>Darkon 2</a> $teledk2 <br>";
            echo "<a href='changejob.php?a=teledk3&charid=$id' style='text-decoration: none;'>Darkon 3</a> $teledk3 <br>";
            echo "<a href='changejob.php?a=teleazria&charid=$id' style='text-decoration: none;'>Azria</a> $teleazria <br>";
			echo "<a href='changejob.php?a=televolcan&charid=$id' style='text-decoration: none;'>Volcano</a> $televolcan <br>";
			echo "<a href='changejob.php?a=telefortower&charid=$id' style='text-decoration: none;'>Forsaden Tower</a> $telefortower <br>";
			echo "<a href='changejob.php?a=telecw&charid=$id' style='text-decoration: none;'>Clockwork Cage</a> $telecw <br>";
            echo "</fieldset>";
         }
      }
	        if ($act == 'telefl')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 6950 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 50 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3250 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Flaris!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	        if ($act == 'telesm')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 8465 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 50 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3620 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Saint Morning!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	        if ($act == 'teledk1')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 5573 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 75 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3904 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Darkon 1!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'teledk2')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 3850 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 50 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 4440 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Darkon 2!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'teledk3')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 3222 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 10 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3421 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Darkon 3!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'teleazria')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 2 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 1272 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 114 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 1125 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Azria!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	        if ($act == 'televolcan')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 203 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 1411 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 86 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 510 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Volcano!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	  	if ($act == 'telefortower')
		{
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 150 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 253 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 100 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 78 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Forsaden Tower!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
		if ($act == 'telecw')
			{
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            
            mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
			mysql_query("UPDATE characters SET posX = 3889 WHERE id = $id");
			mysql_query("UPDATE characters SET posY = 53 WHERE id = $id");
			mysql_query("UPDATE characters SET posZ = 3923 WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>You are now in Clockwork Cage!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
	if ($act == 'listbuff')//big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$cQuery = mysql_query("select * from characters where id = $id");
				$char = mysql_fetch_assoc($cQuery);
				$job = $char["class"];
				$str = $char["str"];
				$int = $char["int"];
				$dex = $char["dex"];
				$cCannon = ' checked';
				$cProtect = ' checked';
				$cQS = ' checked';
				$cCats = ' checked';
				$cHeapUp = ' checked';
				$cSF = ' checked';
				$cGT = ' checked';
				$cPatience = '';
				$cAccuracy = '';
				$cBeefUp = '';
				$cHaste = '';
				$cMental = '';
				if ((em($job, '0', '1', '6', '7', '11', '16', '17', '21', '24', '25', '29')) || ((em($job, 2, 3, 8, 10, 18, 20, 26, 28)) && $str >= 20))
				{
					$cBeefUp = ' checked';
					$cHaste = ' checked';
					$cAccuracy = ' checked';
				}
				if ((em($job, '4', '12', '13', '22', '23', '30', '31')) || ((em($job, '3', '10', '20', '28')) && $int >= 20))
				{
					$cMental = ' checked';
				}
				if ((em($job, '2', '8', '18', '26')) && $dex >= 20)
				{
					$cHaste = ' checked';
					$cAccuracy = ' checked';
				}
				if (em($job, '9', '19', '27'))
				{
					$cHaste = ' checked';
					$cAccuracy = ' checked';
					$cMental = ' checked';
				}
				echo "<fieldset style='padding:5px;'><legend>  Buffs  </legend>";
				echo "<form action='changejob.php?a=buffar&char=$id' method='POST' name='buff' id='buff'>";
				echo "<table border=1 cellpadding='1' cellspacing='0'>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='116'$cAccuracy> 

Accuracy</label></td><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='53'$cBeefUp> Beef Up</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='50'$cCannon>  Cannon 

Ball</label></td><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='115'$cCats> Cat's Reflex</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='150'$cGT> Geburah 

Tiphreth</label></td><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='20'$cHaste> Haste</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='49'$cHeapUp> Heap Up</label></td><td 

style='width:250px;'><label><input type='checkbox' name='chkb[]' value='52'$cMental> Mental Sign</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='46'$cPatience> Patience</label></td><td 

style='width:250px;'><label><input type='checkbox' name='chkb[]' value='146'$cProtect> Protect</label></td></tr>";
				echo "<tr><td style='width:250px;'><label><input type='checkbox' name='chkb[]' value='114'$cQS> Quick Step</label></td><td 

style='width:250px;'><label><input type='checkbox' name='chkb[]' value='148'$cSF> Spirit Fortune</label></td></tr>";
				echo "<tr><td colspan=2><label><input type='checkbox' name='selall'  onClick='sel();'> Select / Deselect All</label></td></tr>";
				echo "</table><div style='height:7px; width:100%'></div>";
				echo "<input type='submit' value='Buffs' name='buff' style='position:relative;float:left;'>";
				echo "</form>";
				echo "</fieldset>";
				$act = 'char';
				continue;
			}
		} 
	}
	if ($act == 'buffar')//big if starts here
	{
		if (isset($_SESSION['user']))
		{
			$id = $_GET["char"];
			$chkBuff = $_POST["chkb"];
			$resultado = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND 

a.username = '$user'");
			//$resultado = mysql_query("select * from accounts where username = '$user'");
			$qde_registros = mysql_num_rows($resultado);
			if ($qde_registros != 0)
			{
				$tempo = 60000 * 60 * 3;
				$query = mysql_query("delete from buffs where ((skillid = 49) OR (skillid = 116) OR (skillid = 20) OR (skillid = 115) OR (skillid = 46) 

OR (skillid = 114) OR (skillid = 50) OR (skillid = 53) OR (skillid = 148) OR (skillid = 150) OR (skillid = 52) OR (skillid = 146)) AND charid = $id");
				for ($cont = 0; $cont < count($chkBuff); $cont++)
				{
					switch ($chkBuff[$cont])
					{
						case 49:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('49', '20', '4', '40', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 116:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('116', '20', '47', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 20:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('20', '20', '24', '500', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 115:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('115', '20', '14', '12', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 46:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('46', '20', '35', '210', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 114:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('114', '20', '11', '30', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 50:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('50', '20', '2', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 53:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('53', '20', '1', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 148:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('148', '10', '63', '140', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 150:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, 

`ability1`, `abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('150', '10', '63', '150', '24', '500', '0', '0', '$tempo', '$id');");
									break;
						case 52:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('52', '20', '3', '20', '0', '0', '0', '0', '$tempo', '$id');");
									break;
						case 52:	$resultado = mysql_query("INSERT INTO `flyff`.`buffs` (`skillid`, `skilllvl`, `abilityType1`, `ability1`, 

`abilityType2`, `ability2`, `abilityType3`, `ability3`, `remainingTime`, `charid`) VALUES ('146', '10', '26', '50', '0', '0', '0', '0', '$tempo', '$id');");
									break;
					}
				}
				if (mysql_affected_rows() != 0)
				{
					echo "<h3>Buffed your Character Successfully.</h3>";
				}
				else
				{
					echo "<h3><font color='#FF0000'>WARNING</font>: Error attempting to buffer. either you not select a skill to 

buffs.</h3>";
				}
			}
/*			else
			{
				echo "<h3><font color='#FF0000'>ERROR</font>: This in its char.</h3>";
				$act = 'login';
			}
*/
		} 
	}
	
	if ($act == 'senha')
	{
		if (isset($_SESSION['user']))
		{
			$login = $_POST["login"];
			$senhaA = $_POST["senhaAntiga"];
			$senhaN = $_POST["senhaNova"];
			$senhaN2 = $_POST["senhaNova2"];
			if ((!isSet($_POST["login"])) && (!isSet($_POST["senhaAntiga"])) && (!isSet($_POST["senhaNova"])) && (!isSet($_POST["senhaNova2"])))
			{
				echo '<form method="post" action="changejob.php?a=senha">';
				echo 'Login <input type="text" name="login" READONLY value="' . $user . '"><p>';
				echo 'Old Password <input type="password" name="senhaAntiga"><p>';
				echo 'New Password <input type="password" name="senhaNova"><p>';
				echo 'Confirm New Password <input type="password" name="senhaNova2"><p>';
				echo '<input type="submit" value="OK" name="OK">';
				echo '</form>';
			}
			else
			{
				$senhaNova = md5("kikugalanet" . $senhaN);
				if (md5("kikugalanet" . $senhaN2) != $senhaNova)
				{
					echo "<h3><font color='#FF0000'>WARNING</font>: The new passwords in known.</h3>";
					unset($_POST["login"]);
					unset($_POST["senhaAntiga"]);
					unset($_POST["senhaNova"]);
					unset($_POST["senhaNova2"]);
				}
				else
				{
					$senhaAntiga = md5("kikugalanet" . $senhaA);
					$res = mysql_query("select * from accounts where username = '$login' AND password = '$senhaAntiga'");
					$qtde = mysql_num_rows($res);
					if ($qtde == 0)
					{
						echo "<h3><font color='#FF0000'>NOTICE</font>: Please fill up all fields.</h3>";
						unset($_POST["login"]);
						unset($_POST["senhaAntiga"]);
						unset($_POST["senhaNova"]);
						unset($_POST["senhaNova2"]);
					}
					else
					{
						$res = mysql_query("update accounts set password = '$senhaNova' where username = '$login' and password = 

'$senhaAntiga'");
						if (mysql_affected_rows() != 0)
						{
							echo "<h3>Password changed successfully.</h3>";
							unset($_POST["login"]);
							unset($_POST["senhaAntiga"]);
							unset($_POST["senhaNova"]);
							unset($_POST["senhaNova2"]);						}
						else
						{
							echo "<h3><font color='#FF0000'>WARNING</font>: Error attempting to change Password.</h3>";
							unset($_POST["login"]);
							unset($_POST["senhaAntiga"]);
							unset($_POST["senhaNova"]);
							unset($_POST["senhaNova2"]);
						}
					}
				}
			}
		}  
	}
	if ($act == 'restat')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $ok = $_GET["success"];
            $error = $_GET["fail"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_str = $get['stat_str'];
            $stat_sta = $get['stat_sta'];
            $stat_dex = $get['stat_dex'];
            $stat_int = $get['stat_int'];
            $statpoints = $get['statpoints'];
            echo "<font size='3'><fieldset><legend>  <b>RE-STAT</b>  </legend>";
            echo "<b>Instructions</b>: Simply click on a stat to return all the stat points back to your unused stat points.<br><br>";
            echo "<b><a href='changejob.php?a=restatstr&charid=$id' style='text-decoration: none;'>Strength</a></b>: $stat_str<br>";
            echo "<b><a href='changejob.php?a=restatsta&charid=$id' style='text-decoration: none;'>Stamina</a></b>: $stat_sta <br>";
            echo "<b><a href='changejob.php?a=restatdex&charid=$id' style='text-decoration: none;'>Dexitery</a></b>: $stat_dex <br>";
            echo "<b> <a href='changejob.php?a=restatint&charid=$id' style='text-decoration: none;'>Intellegence</b></a>: $stat_int <br>";
            echo "<b>Unused Stat Points</b>: $statpoints <br></font>";
            
            echo "</fieldset>";
         }
      }
      if ($act == 'restatstr')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_str = $get['stat_str'];
            $statpoints = $get['statpoints'];
            $truestr = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_str - $truestr WHERE id = $id");
            mysql_query("UPDATE characters SET stat_str = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Strength stat reset successfuly!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'restatsta')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_sta = $get['stat_sta'];
            $statpoints = $get['statpoints'];
            $truesta = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_sta - $truesta WHERE id = $id");
            mysql_query("UPDATE characters SET stat_sta = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Stamina stat reset successfuly!</h3></center>";
			  
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'restatdex')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_dex = $get['stat_dex'];
            $statpoints = $get['statpoints'];
            $truedex = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_dex - $truedex WHERE id = $id");
            mysql_query("UPDATE characters SET stat_dex = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Dextery stat reset successfuly!</h3></center>";
			   
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'restatint')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $stat_int = $get['stat_int'];
            $statpoints = $get['statpoints'];
            $trueint = 15;
            
            mysql_query("UPDATE characters SET statpoints = $statpoints + $stat_int - $trueint WHERE id = $id");
            mysql_query("UPDATE characters SET stat_int = '15' WHERE id = $id");
            
            if (mysql_affected_rows() != 0)
            {
               echo "<center><h3>Intellegence stat reset successfuly!</h3></center>";
            }
            else
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
            }
         }
      }
      if ($act == 'reborn')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $class = $get['class'];
            $lvl = $get['level'];
            $rebirths = $get['rebirths'];
            $penya = $get['penya'];
            
            if (($lvl == 120) && ($class >= 24) && ($class <= 31) && ($rebirths < $maxrebirths) && ($penya >= $rebirthcost))
            {
               if ($class == 24) { mysql_query("UPDATE characters SET class = 6 WHERE id = $id"); }
               if ($class == 25) { mysql_query("UPDATE characters SET class = 7 WHERE id = $id"); }
               if ($class == 26) { mysql_query("UPDATE characters SET class = 8 WHERE id = $id"); }
               if ($class == 27) { mysql_query("UPDATE characters SET class = 9 WHERE id = $id"); }
               if ($class == 28) { mysql_query("UPDATE characters SET class = 10 WHERE id = $id"); }
               if ($class == 29) { mysql_query("UPDATE characters SET class = 11 WHERE id = $id"); }
               if ($class == 30) { mysql_query("UPDATE characters SET class = 12 WHERE id = $id"); }
               if ($class == 31) { mysql_query("UPDATE characters SET class = 13 WHERE id = $id"); }
               
               mysql_query("UPDATE characters SET level = 60 WHERE id = $id");
               mysql_query("UPDATE characters SET posWorldID = 1 WHERE id = $id");
               mysql_query("UPDATE characters SET posX = 6973 WHERE id = $id");
               mysql_query("UPDATE characters SET posY = 10 WHERE id = $id");
               mysql_query("UPDATE characters SET posZ = 3328 WHERE id = $id");
               mysql_query("UPDATE characters SET rebirths = rebirths + 1 WHERE id = $id");
			   mysql_query("UPDATE characters SET penya = $penya - $rebirthcost WHERE id = $id");
               
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Character has successfully been rebirth!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Your character can not yet be rebirth. You must be level 120 HERO and get 20000000 of penya.</h3></center>";
            }
        }
    }
      if ($act == 'transy')
   {
         $id = $_GET["charid"];
          $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
          $checkrows = @mysql_num_rows($matchrows);
          if ($checkrows != 0)
          {
            $id = $_GET['charid'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
            $sex = $get['sex'];
            if ($sex == 1) 
            { 
            mysql_query("UPDATE characters SET sex = 0 WHERE id = $id"); 
            echo "<center><h3>Congratulations! Your character is now Male.</h3></center>";
            }
            if ($sex == 0) 
            { 
            mysql_query("UPDATE characters SET sex = 1 WHERE id = $id");
            echo "<center><h3>Congratulations! Your character is now Female.</h3></center>";
            }
            if (mysql_affected_rows() == 0)
            {
               echo "<center><h3>An error has occured, please try again.</h3></center>";
			}
		}

	if ($act == 'ulti')
	{
			{
				$id = $_GET["charid"];
				$query = mysql_query("select * from characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id 

AND a.username = '$user'") or die(mysql_error());
				$checkrows = mysql_num_rows($query);
				if ($checkrows != 0)
				{
					$ccQuery = mysql_query("SELECT * FROM `inventory` WHERE `charid` = '$id' AND `refine`='10'");
					$char = mysql_fetch_assoc($ccQuery);
					$itemid = $char['itemid'];
					$ultiid = NULL;
					
					//Guardian Ambidextrous Axe
					if($itemid == '22038')
					{
					$ultiid = '22383';
					}
					//Guardian Axe
					if($itemid == '22034')
					{
					$ultiid = '20378';
					}
					//Guardian Big Sword
					if($itemid == '22030')
					{
					$ultiid = '22373';
					}
					//Guardian Bow
					if($itemid == '22050')
					{
					$ultiid = '22398';
					}
					//Guardian Knuckle
					if($itemid == '22042')
					{
					$ultiid = '22388';
					}
					//Guardian Staff
					if($itemid == '22062')
					{
					$ultiid = '22413';
					}
					//Guardian Stick
					if($itemid == '22046')
					{
					$ultiid = '22393';
					}
					//Guardian Sword 
					if($itemid == '22026')
					{
					$ultiid = '22368';
					}
					//Guardian Wand
					if($itemid == '22058')
					{
					$ultiid = '22408';
					}
					//Guardian Yo-Yo
					if($itemid == '22054')
					{
					$ultiid = '22403';
					}
					
					//Historic Ambidextrous Axe
					if($itemid == '22039')
					{
					$ultiid = '22384';
					}
					//Historic Axe 
					if($itemid == '22035')
					{
					$ultiid = '22379';
					}
					//Historic Big Sword
					if($itemid == '22031')
					{
					$ultiid = '22374';
					}
					//Historic Bow
					if($itemid == '22051')
					{
					$ultiid = '22399';
					}
					//Historic Knuckle
					if($itemid == '22043')
					{
					$ultiid = '22389';
					}
					//Historic Staff
					if($itemid == '22063')
					{
					$ultiid = '22414';
					}
					//Historic Stick
					if($itemid == '22047')
					{
					$ultiid = '22394';
					}
					//Historic Sword
					if($itemid == '22027')
					{
					$ultiid = '22369';
					}
					//Historic Wand
					if($itemid == '22059')
					{
					$ultiid = '22409';
					}
					//Historic Yo-Yo
					if($itemid == '22055')
					{
					$ultiid = '22404';
					}
					
					//Angel Axe
					if($itemid == '22036')
					{
					$ultiid = '22380';
					}
					//Angel Big Sword
					if($itemid == '22032')
					{
					$ultiid = '22375';
					}
					//Angel Bow
					if($itemid == '22052')
					{
					$ultiid = '22400';
					}
					//Angel Glove
					if($itemid == '22044')
					{
					$ultiid = '22390';
					}
					//Angel Staff
					if($itemid == '22064')
					{
					$ultiid = '22415';
					}
					//Angel Stick
					if($itemid == '22048')
					{
					$ultiid = '22395';
					}
					//Angel Sword
					if($itemid == '22028')
					{
					$ultiid = '22370';
					}
					//Angel Wand
					if($itemid == '22060')
					{
					$ultiid = '22410';
					}
					//Angel Yo-Yo
					if($itemid == '22056')
					{
					$ultiid = '22405';
					}
					
					//Legendary Big Golden Axe
					if($itemid == '22041')
					{
					$ultiid = '22386';
					}
					//Legendary Golden Axe
					if($itemid == '22037')
					{
					$ultiid = '22381';
					}
					//Legendary Golden Big Sword
					if($itemid == '22033')
					{
					$ultiid = '22376';
					}
					//Legendary Golden Bow
					if($itemid == '22053')
					{
					$ultiid = '22401';
					}
					//Legendary Golden Gloves 
					if($itemid == '22045')
					{
					$ultiid = '22391';
					}
					//Legendary Golden Staff
					if($itemid == '22065')
					{
					$ultiid = '22416';
					}
					//Legendary Golden Stick
					if($itemid == '22049')
					{
					$ultiid = '22396';
					}
					//Legendary Golden Sword
					if($itemid == '22029')
					{
					$ultiid = '22371';
					}
					//Legendary Golden Wand
					if($itemid == '22061')
					{
					$ultiid = '22411';
					}
					//Legendary Golden Yo-Yo
					if($itemid == '22057')
					{
					$ultiid = '22406';
					}
					
					//Bloody Axe
					if($itemid == '22356')
					{
					$ultiid = '22382';
					}
					//Bloody Two-Handed Axe
					if($itemid == '22357')
					{
					$ultiid = '22375';
					}
					//Bloody Bow
					if($itemid == '22363')
					{
					$ultiid = '22402';
					}
					//Bloody Knuckle
					if($itemid == '22358')
					{
					$ultiid = '22392';
					}
					//Bloody Staff
					if($itemid == '22361')
					{
					$ultiid = '22417';
					}
					//Bloody Stick
					if($itemid == '22359')
					{
					$ultiid = '22397';
					}
					//Bloody Sword
					if($itemid == '22354')
					{
					$ultiid = '22372';
					}
					//Bloody Wand
					if($itemid == '22360')
					{
					$ultiid = '22412';
					}
					//Bloody Yo-Yo
					if($itemid == '22362')
					{
					$ultiid = '22407';
					}
					//Bloody Slayer
					if($itemid == '22355')
					{
					$ultiid = '22377';
					}
					if ($ultiid != NULL)
					{
					
						$sql = "UPDATE `inventory` SET `itemid` = '".$ultiid."',`refine` = '0' WHERE `itemid` = '".$itemid."' AND 

`charid` = '".$id."'";
						
					
						if(mysql_query($sql)){
						
							echo "<h3><center>Have fun with your new Ultimate Weapon!</center></h3>";
							
						}else{
						
						
							echo "Mistake";
						
						
						}	
					}
					else
					{
						echo "<h3><center>You don't have any green weapon +10 in your inventary!</center></h3>";
					}
				}
			}
			}
	if ($act == 'size')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $ok = $_GET["success"];
            $error = $_GET["fail"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = mysql_fetch_array($query);
            $size05 = $get['size05'];
            $size1 = $get['size1'];
            $size15 = $get['size15'];
            $size2 = $get['size2'];
			$sizecustom = $get['sizecustom'];	
			echo "<font size='3'><fieldset><legend>  <b>Change Size</b>  </legend>";
            echo "<b>Instructions</b>: Simply click on size buttons and you will get your size. Min size 0.1 - Max size 2.0 <font color=red> (10000000 penya 

cost).</font><br><br>";
            echo "<b><a href='changejob.php?a=size05&charid=$id' style='text-decoration: none;'>Size 0.5</a></b><br>";
            echo "<b><a href='changejob.php?a=size1&charid=$id' style='text-decoration: none;'>Size 1.0</a></b><br>";
            echo "<b><a href='changejob.php?a=size15&charid=$id' style='text-decoration: none;'>Size 1.5</a></b><br>";
            echo "<b><a href='changejob.php?a=size2&charid=$id' style='text-decoration: none;'>Size 2.0</b></a><br>";
			echo "<b><a href='changejob.php?a=sizecustombox&charid=$id' style='text-decoration: none;'>Size Custom</b></a><br>";
			echo "</fieldset>";
			}
			}
      if ($act == 'size0.5')
       {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 0.5 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 0.5!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
      if ($act == 'size1.0')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 1.0 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 1.0!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
      if ($act == 'size1.5')
       {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 1.5 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 1.5!</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
      if ($act == 'size2.0')
      {
         $id = $_GET["charid"];
         $matchrows = mysql_query("SELECT * FROM characters AS c INNER JOIN accounts AS a ON a.username = c.accountname WHERE c.id = $id AND a.username = 

'$user'");
         $checkrows = @mysql_num_rows($matchrows);
         if ($checkrows != 0)
         {
            $id = $_GET["charid"];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);
			$penya = $get['penya'];
            if ($penya >= 10000000)
            {
            mysql_query("UPDATE characters SET sizeMod = 2.0 WHERE id = $id");
			mysql_query("UPDATE characters SET penya = $penya -10000000 WHERE id = $id");
            
               if (mysql_affected_rows() != 0)
			   {
                  echo "<center><h3>Congratulations!You size have changed to 2.0</h3></center>";
               }
               else
               {
                  echo "<center><h3>An error has occured, please try again.</h3></center>";
               }
            }
            else
            {
               echo "<center><h3>Not enought money.</h3></center>";
            }
        }
    }
	     if ($act == 'sizecustom')
		{
            $id = $_GET["charid"];
            $size = $_POST['size'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);

			$con = mysql_query("UPDATE characters SET sizeMod = '$size' where id = '$id'");
			
			echo "<center><h3>Congratulations! Your size have changed!</h3></center>";
			}
			
		if ($act == 'sizecustombox')
		{
	echo "<center><td colspan=4 align='center'><fieldset><legend>  <b>Size Custom  </b></legend></td>";
	echo "<form action='changejob.php?a=sizecustom&charid=$charid' method='post' >";
	echo "<td width ='107' align = 'right'><strong>New Size</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='sizeMod' type='text'/></td></br>";
	echo "</br><td><input type='submit' value='Change my Size'/></td></br>";
	echo "</tr>";
	echo "</form>";
	echo "</fieldset></center>";
	}
          if ($act == 'changenam')
		  {
            $id = $_GET["charid"];
            $name = $_POST['name'];
            $oldname = $_POST['oldname'];
            $query = mysql_query("SELECT * FROM characters WHERE id = $id");
            $get = @mysql_fetch_array($query);

			$query = mysql_query("UPDATE characters SET charname = '$name' where charname = '$oldname'");
			
			echo "<center><h3>Congratulations! Your name have changed!</h3></center>";
			}
			 
			 if ($act == 'changename')
			 {			 
	echo "<center><td colspan=4 align='center'><fieldset><legend>  <b>Change Name  </b></legend></td>";
	echo "<form action='changejob.php?a=changenam&charid=$id' method='post' >";
	echo "<td width ='107' align = 'right'><strong>New Name</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='name' type='text'/></td></br></br>";
	echo "<td width ='107' align ='right'><strong>Old Name</strong></td></br>";
	echo "<td width ='151'><input size ='15' name='oldname' type='text'/></td></br>";
	echo "</br><td><input type='submit' value='Change my Name'/></td></br>";
	echo "</tr>";
	echo "</form>";
	echo "</fieldset></center>";
	}
?>
<?php
?>
<br>
<center><font size=3> Gabs And Miller</center></font>
<center><font size=3>Fly For Philippine</center></font>
<font size=1>

[HELP]Rebirth System

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Experienced Elementalist

Elite Diviner

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners