[HELP]Rebirth System

Results 1 to 22 of 22
  1. #1
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    [HELP]Rebirth System

    How can i put rebirth system in my server?


  2. #2
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System

    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

  3. #3
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    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??

  4. #4
    Account Upgraded | Title Enabled! alist3r06 is offline
    MemberRank
    Apr 2009 Join Date
    269Posts

    Re: [HELP]Rebirth System

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

  5. #5
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System

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

  6. #6
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    ok.. we choose the user control panel rebirth

  7. #7
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System

    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 ^^

  8. #8
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

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

  9. #9
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

  10. #10
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    ok thank you very much sir

  11. #11
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    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."

  12. #12
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System


  13. #13
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    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"

  14. #14
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System

    but does it rebirth???

  15. #15
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    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"

  16. #16
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    Quote Originally Posted by zedawg View Post
    but does it rebirth???
    nope it doesn't that is the only thing i see in my browser

  17. #17
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System

    copy and paste ur script in here

  18. #18
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    [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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

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

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

    none;'>Live Chat</a>&nbsp;&nbsp;|&nbsp;&nbsp;<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

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

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

    Controller</a>&nbsp;&nbsp;</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>&nbsp;&nbsp;PICK THE CHAR&nbsp;&nbsp;</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>&nbsp;&nbsp;<font size='3'><b> Slot $slot </b>&nbsp;&nbsp;</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>&nbsp;|&nbsp;<a href='changejob.php?a=tele&charid=$id' style='text-decoration: none;'>Teleport</a> &nbsp;|&nbsp; <a

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

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

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

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

    &nbsp;|&nbsp; </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>&nbsp;&nbsp;<b> GameMaster Online </b>&nbsp;&nbsp;</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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>&nbsp;&nbsp;<b>CHOOSE YOUR JOB</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Teleport</b>&nbsp;&nbsp;</legend>";
    echo "<b>Instructions</b>: Click your desired destination.<br>";
    echo "<b>Current Location:</b> World $posWorldID&nbsp;&nbsp;x$posX&nbsp;&nbsp;y$posY&nbsp;&nbsp;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>&nbsp;&nbsp;Buffs&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>RE-STAT</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Change Size</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Size Custom&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Change Name&nbsp;&nbsp;</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>

  19. #19
    Account Upgraded | Title Enabled! zedawg is offline
    MemberRank
    Oct 2008 Join Date
    495Posts

    Re: [HELP]Rebirth System

    lol you added the complete sentence...only add


    $penya = $get['penya'];

  20. #20
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

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

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

    none;'>Live Chat</a>&nbsp;&nbsp;|&nbsp;&nbsp;<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

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

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

    Controller</a>&nbsp;&nbsp;</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>&nbsp;&nbsp;PICK THE CHAR&nbsp;&nbsp;</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>&nbsp;&nbsp;<font size='3'><b> Slot $slot </b>&nbsp;&nbsp;</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>&nbsp;|&nbsp;<a href='changejob.php?a=tele&charid=$id' style='text-decoration: none;'>Teleport</a> &nbsp;|&nbsp; <a

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

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

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

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

    &nbsp;|&nbsp; </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>&nbsp;&nbsp;<b> GameMaster Online </b>&nbsp;&nbsp;</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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>&nbsp;&nbsp;<b>CHOOSE YOUR JOB</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Teleport</b>&nbsp;&nbsp;</legend>";
    echo "<b>Instructions</b>: Click your desired destination.<br>";
    echo "<b>Current Location:</b> World $posWorldID&nbsp;&nbsp;x$posX&nbsp;&nbsp;y$posY&nbsp;&nbsp;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>&nbsp;&nbsp;Buffs&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>RE-STAT</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Change Size</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Size Custom&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Change Name&nbsp;&nbsp;</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>

  21. #21
    [R8]ℓσℓ32 caja is offline
    MemberRank
    Oct 2008 Join Date
    Here!Location
    1,502Posts

    Re: [HELP]Rebirth System

    [QUOTE=derekgabs;5012328]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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

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

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

    none;'>Live Chat</a>&nbsp;&nbsp;|&nbsp;&nbsp;<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a

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

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

    Controller</a>&nbsp;&nbsp;</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>&nbsp;&nbsp;PICK THE CHAR&nbsp;&nbsp;</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>&nbsp;&nbsp;<font size='3'><b> Slot $slot </b>&nbsp;&nbsp;</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>&nbsp;|&nbsp;<a href='changejob.php?a=tele&charid=$id' style='text-decoration: none;'>Teleport</a> &nbsp;|&nbsp; <a

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

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

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

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

    &nbsp;|&nbsp; </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>&nbsp;&nbsp;<b> GameMaster Online </b>&nbsp;&nbsp;</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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>&nbsp;&nbsp;<b>CHOOSE YOUR JOB</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Teleport</b>&nbsp;&nbsp;</legend>";
    echo "<b>Instructions</b>: Click your desired destination.<br>";
    echo "<b>Current Location:</b> World $posWorldID&nbsp;&nbsp;x$posX&nbsp;&nbsp;y$posY&nbsp;&nbsp;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>&nbsp;&nbsp;Buffs&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>RE-STAT</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Change Size</b>&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Size Custom&nbsp;&nbsp;</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>&nbsp;&nbsp;<b>Change Name&nbsp;&nbsp;</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>

  22. #22
    Member derekgabs is offline
    MemberRank
    Apr 2009 Join Date
    Between Heaven and HellLocation
    60Posts

    Re: [HELP]Rebirth System

    Quote Originally Posted by caja View Post
    Noob-.-''
    PHP Code:
    <center><font size=3Gabs And Miller</center></font>
    <
    center><font size=3>Fly For Philippine</center></font
    lolz... your even out of the topic your not helping.. anyways im still giving the credits to lol32 and others..



Advertisement