$sql = mysql_query("SELECT `wapen` FROM `uitrust` WHERE `id`=".ID) or die(mysql_error());

$res = mysql_fetch_assoc($sql);

 

$wapen = $res['wapen'];

 

$wpns = array(

 

    "Mes", "Desert Eagle", "Aka-Beta", "Thompson", "Colt MX 17", "Shotgun", "M-16", "RPG-7"

 

 

$time_hoeren = mysql_query("SELECT `wapenervaring` FROM `usertimes` WHERE `id` =".ID." LIMIT 1") or die(mysql_error());

$timeho = mysql_fetch_assoc($time_hoeren);

$tho = $timeho['wapenervaring'];

 

 

$sql = mysql_query("SELECT wapenervaring, wapentraining FROM userstats WHERE id = ".ID." LIMIT 1") or die(mysql_error());

$res = mysql_fetch_assoc($sql);

$w_erv = $res['wapenervaring'];

$w_train = $res['wapentraining'];

 

       

        if($w_train >= 100){

                $msg = "Je hebt al 100% wapentraining!";

                $msg = bad($msg);

        } elseif($tho > time()){

                $msg = "Je moet nog <b>".($tho - time())."</b> seconden wachten voordat je weer wapentraining kan doen!";

                $msg = bad($msg);

        } else {

                $w_percentage = rand(2, 5);

                $w_train = $w_train + $w_percentage;

                $msg = "Je hebt <b>" .$w_percentage. "%</b> wapentraining erbij gekregen!";

                $msg = good($msg);

                if($w_train > 100){

                        $w_train = 100;

                }

 

                mysql_query("UPDATE `userstats` SET `wapentraining`=".$w_train." WHERE `id`=".ID." LIMIT 1") or die(mysql_error());

               

                // Update de tijd

                $nieuwetijd = time() + 300;

                mysql_query("UPDATE `usertimes` SET `wapenervaring`=".$nieuwetijd." WHERE `id`=".ID." LIMIT 1") or die(mysql_error());

               

        }

 

       

 

<table border='0' cellspacing='1' width='96%' bgcolor='#000' align='center'>

<tr><td class='top'>Wapen Ervaring Trainen</td></tr><tr>

<td width='100%' class='container'>

 

<?php  

        if (isset($msg)){

        echo "<center>".$msg. "</center><br><br>";

}

?>Hier kun je, je wapen ervaring trainen <b>(wapen training)</b> zodat je betere wapens kunt gaan dragen.Je <b>wapen ervaring </b>gaat omhoog door personen aan te vallen met je wapen! Let op! Pas als je beide op 100% hebt schiet je als beste.<br /><br />                         

<table border='0' cellspacing='1' width='90%' bgcolor='#000' align='center'>

 

<tr><td class='subtop' colspan='3'>Status</td></tr>

<tr><td class='inhoud_c' rowspan='3' style='width: 110px;'><img src='images/attack.jpg' alt='' /></td>

<td class='inhoud' style='width: 200px;'><b>Huidige wapen:</b></td>

<td class='inhoud'><?=$wpns[$wapen];?></td></tr>

 

<tr><td class='inhoud' style='width: 200px;'><b>Wapen ervaring:</b></td><td class='inhoud'><?php echo createBalk($w_erv); ?></td></tr>

<td class='inhoud' style='width: 200px;'><b>Wapen trainen:</b></td><td class='inhoud'><?php echo createBalk($w_train); ?></td></tr></table>

 

<br><form method="post" action="game.php?pagina=wapenervaring"><input type="submit" name="trainen" value="Trainen"><br></td></tr></table>