Rebirth System.

[Dave]

You might want to change the query to:

UPDATE Account SET Coins = Coins + ".$value." 

Else if someone already has got some coins it will be set to 100, no matter what.

[sart123]

Updated the attachment, I had something wrong with it.

As for the BlueB thing, here it is:

templates/template_character.php

            <?php
            if(!$_SESSION['userid'])
            {
              die();
            }
            
            $value = 100;
            
            if(isset($_POST['rebirth']))
            {
                $q = mssql_query("SELECT * FROM Character WHERE Name = '".clean($_POST['lul'])."'");
                if(mssql_result($q, 0, 'Level') != 99)
                {
                    alert( "Character selected is not level 99." );
                    //return false;
                }
                else
                {
                    $q = mssql_query("UPDATE Character SET Level = 1, XP = 0 WHERE Name = '".clean($_POST['lul'])."'");
                    $q2 = mssql_query("UPDATE Account SET Coins = ".$value."");
                    
                    alert( "The character ".$_POST['lul']." successfully rebirthed." );
                    //return true;
                }
            }
            ?>
            <div id="content5">
                <h1><?php echo $gunzname; ?> - Character(s)</h1>
                <p><br />
                    <table border="0" class="charhome">
                        <tr><td class="titlestrong" width="80px">Name</td><td class="titlestrong" width="50px">Level</td><td class="titlestrong" width="80px">EXP</td><td class="titlestrong" width="80px">Kill Count</td><td class="titlestrong" width="90px">Death count</td></tr>
                        <?php $sqlf->getchars($_SESSION['userid']); ?>
                    </table>
                    <p><strong>Change Gender:</strong>
                        <form action="" method="post" class="cgender">
                            <table border="0">
                                <tr><td>Name:</td> <td><select name="char"><?php $sqlf->getcharscid($_SESSION['userid']); ?></select></td></tr>
                                <tr><td>To:</td>   <td><select name="gender"><option value="male">Male</option><option value="female">Female</option></select></td></tr>
                                <tr><td></td>      <td><input type="submit" name="changegender" value="Change" /></td></tr>
                            </table>
                        </form> </p>


                </p>
            <?php
            if($_SESSION['userid'] != "")
            {
                $aid_q = mssql_query("SELECT * FROM Account WHERE UserID = '".$_SESSION['userid']."'");
                $aid = mssql_result($aid_q, 0, 'AID');
                
                $q = mssql_query("SELECT * FROM Character WHERE AID = '".$aid."'");

                echo "<p><strong>Rebirth a Character:</strong><form method='post' action=''>";
                echo  "<table border='0'><tr><td>Character:</td><td><select name='lul'>";

                while($fetch = mssql_fetch_array($q))
                {
                    echo "<option value=".$fetch['Name'].">".$fetch['Name']." Lv.".$fetch['Level']."</option>";
                }

                echo "</select></td></tr>";
                echo "<tr><td></td><td><input type='submit' name='rebirth' value='Rebirth' /></td></tr></table>";
                echo "</form></p>";
            }
            ?>
            </div>

You might want to change the query to:

UPDATE Account SET Coins = Coins + ".$value." 

Else if someone already has got some coins it will be set to 100, no matter what.

Thanks allot guys!!

[jur13n]

done this ages ago with lloyd but okay
nice work..

[Vusion]

You might want to change the query to:

UPDATE Account SET Coins = Coins + ".$value." 

Else if someone already has got some coins it will be set to 100, no matter what.

Oh yeah, I was in a rush uh :/. Well, the whole code is shit anyway xD..

done this ages ago with lloyd but okay
nice work..

It literally took me 10 minutes, it's no big deal.

So, yeah, updated the attachment again.

[RlyfPHP]

good job.