Hi, help me plz with my game...the interest value is not showing..i think the calculation has a mistake or so..also I need to heir a moderator if anyone is inrested Thanks <?php ob_start(); //Start script include("../language/english.inc.php"); include("include/config.php"); if(! $class->check_login()){ header("Location: login.php"); exit; } $begin_1 = 0 + $_GET['p'] * 5; $begin_2 = 0 + $_GET['q'] * 5; class bank{ var $data; var $game_id; function gegevens(){ global $inc_bank_1; global $inc_bank_2; global $inc_bank_3; global $inc_bank_4; global $inc_bank_5; global $inc_bank_6; global $inc_bank_7; global $inc_bank_8; global $inc_bank_9; global $inc_bank_10; global $inc_bank_11; global $inc_bank_12; global $inc_bank_13; global $inc_bank_14; global $inc_bank_15; global $inc_bank_16; global $inc_bank_17; global $inc_bank_18; global $inc_bank_19; global $inc_bank_20; global $inc_bank_21; global $inc_bank_22; global $inc_bank_23; global $inc_bank_24; global $inc_bank_25; global $inc_bank_26; global $inc_bank_27; global $inc_bank_28; global $inc_bank_29; global $inc_bank_30; global $inc_bank_31; global $inc_bank_32; global $inc_bank_33; global $inc_bank_34; global $inc_bank_35; global $inc_bank_36; global $data; $this->data = $data; global $game_id; global $inc_bank_1; global $inc_bank_2; global $inc_bank_3; global $inc_bank_4; global $inc_bank_5; global $inc_bank_6; global $inc_bank_7; global $inc_bank_8; global $inc_bank_9; global $inc_bank_10; global $inc_bank_11; global $inc_bank_12; global $inc_bank_13; global $inc_bank_14; global $inc_bank_15; global $inc_bank_16; global $inc_bank_17; global $inc_bank_18; global $inc_bank_19; global $inc_bank_20; global $inc_bank_21; global $inc_bank_22; global $inc_bank_23; global $inc_bank_24; global $inc_bank_25; global $inc_bank_26; global $inc_bank_27; global $inc_bank_28; global $inc_bank_29; global $inc_bank_30; global $inc_bank_31; global $inc_bank_32; global $inc_bank_33; global $inc_bank_34; global $inc_bank_35; global $inc_bank_36; $this->game_id = $game_id; } function pinnen($bedrag){ global $inc_bank_1; global $inc_bank_2; global $inc_bank_3; global $inc_bank_4; global $inc_bank_5; global $inc_bank_6; global $inc_bank_7; global $inc_bank_8; global $inc_bank_9; global $inc_bank_10; global $inc_bank_11; global $inc_bank_12; global $inc_bank_13; global $inc_bank_14; global $inc_bank_15; global $inc_bank_16; global $inc_bank_17; global $inc_bank_18; global $inc_bank_19; global $inc_bank_20; global $inc_bank_21; global $inc_bank_22; global $inc_bank_23; global $inc_bank_24; global $inc_bank_25; global $inc_bank_26; global $inc_bank_27; global $inc_bank_28; global $inc_bank_29; global $inc_bank_30; global $inc_bank_31; global $inc_bank_32; global $inc_bank_33; global $inc_bank_34; global $inc_bank_35; global $inc_bank_36; if($this->data[bank] < $bedrag) echo "$inc_bank_1"; else if($bedrag == "" || $bedrag < 1) echo "$inc_bank_2"; else if(!is_numeric($bedrag)) echo "$inc_bank_3"; else { $this->data[bank] -= $bedrag; $this->data[cash] += $bedrag; $this->update_geld(); echo "$inc_bank_4 $".number_format($bedrag)." $inc_bank_5"; } } function storten($bedrag){ global $inc_bank_1; global $inc_bank_2; global $inc_bank_3; global $inc_bank_4; global $inc_bank_5; global $inc_bank_6; global $inc_bank_7; global $inc_bank_8; global $inc_bank_9; global $inc_bank_10; global $inc_bank_11; global $inc_bank_12; global $inc_bank_13; global $inc_bank_14; global $inc_bank_15; global $inc_bank_16; global $inc_bank_17; global $inc_bank_18; global $inc_bank_19; global $inc_bank_20; global $inc_bank_21; global $inc_bank_22; global $inc_bank_23; global $inc_bank_24; global $inc_bank_25; global $inc_bank_26; global $inc_bank_27; global $inc_bank_28; global $inc_bank_29; global $inc_bank_30; global $inc_bank_31; global $inc_bank_32; global $inc_bank_33; global $inc_bank_34; global $inc_bank_35; global $inc_bank_36; if($this->data[cash] < $bedrag) echo "$inc_bank_6"; else if($bedrag == "" || $bedrag < 1) echo "$inc_bank_2"; else if(!is_numeric($bedrag)) echo "$inc_bank_3"; else { $this->data[bank] += $bedrag; $this->data[cash] -= $bedrag; $this->update_geld(); echo "$inc_bank_7 $".number_format($bedrag)." $inc_bank_8"; } } function update_geld(){ global $inc_bank_1; global $inc_bank_2; global $inc_bank_3; global $inc_bank_4; global $inc_bank_5; global $inc_bank_6; global $inc_bank_7; global $inc_bank_8; global $inc_bank_9; global $inc_bank_10; global $inc_bank_11; global $inc_bank_12; global $inc_bank_13; global $inc_bank_14; global $inc_bank_15; global $inc_bank_16; global $inc_bank_17; global $inc_bank_18; global $inc_bank_19; global $inc_bank_20; global $inc_bank_21; global $inc_bank_22; global $inc_bank_23; global $inc_bank_24; global $inc_bank_25; global $inc_bank_26; global $inc_bank_27; global $inc_bank_28; global $inc_bank_29; global $inc_bank_30; global $inc_bank_31; global $inc_bank_32; global $inc_bank_33; global $inc_bank_34; global $inc_bank_35; global $inc_bank_36; mysql_query("UPDATE `gebruiker` SET `cash`='".$this->data[cash]."',`bank`='".$this->data[bank]."' WHERE `login`='".$this->data[login]."' AND `game_id`='".$this->game_id."'"); $dbres = mysql_query("SELECT `cash`,`bank` FROM `gebruiker` WHERE `login`='".$this->data[login]."' AND `game_id`='".$this->game_id."'"); $geld = mysql_fetch_assoc($dbres); $this->data[cash] = $geld[cash]; $this->data[bank] = $geld[bank]; if($this->data[cash] < 0) $this->data[cash] = 0; if($this->data[bank] < 0) $this->data[bank] = 0; } function overboeken($bedrag, $soort, $persoon, $log){ global $inc_bank_1; global $inc_bank_2; global $inc_bank_3; global $inc_bank_4; global $inc_bank_5; global $inc_bank_6; global $inc_bank_7; global $inc_bank_8; global $inc_bank_9; global $inc_bank_10; global $inc_bank_11; global $inc_bank_12; global $inc_bank_13; global $inc_bank_14; global $inc_bank_15; global $inc_bank_16; global $inc_bank_17; global $inc_bank_18; global $inc_bank_19; global $inc_bank_20; global $inc_bank_21; global $inc_bank_22; global $inc_bank_23; global $inc_bank_24; global $inc_bank_25; global $inc_bank_26; global $inc_bank_27; global $inc_bank_28; global $inc_bank_29; global $inc_bank_30; global $inc_bank_31; global $inc_bank_32; global $inc_bank_33; global $inc_bank_34; global $inc_bank_35; global $inc_bank_36; if($soort == "crimineel"){ if($member = mysql_fetch_assoc(mysql_query("SELECT `id`,`login`,`familie`,`level` FROM `gebruiker` WHERE `login`='".$persoon."' AND `game_id`='".$this->game_id."'"))){ if($member[level] == 0 || $member[level] == -1 || $member[level] == -2) echo "$inc_bank_9"; else if($member[login] == $this->data[login]) echo "$inc_bank_10"; else if($this->data[bank] < $bedrag) echo "$inc_bank_6"; else if($bedrag == "" || $bedrag < 1) echo "$inc_bank_2"; else if(!is_numeric($bedrag)) echo "$inc_bank_3"; else { $this->data[bank] -= $bedrag; $this->update_geld(); mysql_query("UPDATE `gebruiker` SET `bank`=`bank`+'".$bedrag."' WHERE `login`='".$persoon."' AND `game_id`='".$this->game_id."'"); mysql_query("INSERT INTO `overschrijving`(`time`, `ip`, `van`, `naar`, `bedrag`, `message`, `game_id`) VALUES('".time()."', '".$_SERVER['REMOTE_ADDR']."', '".$this->data[login]."', '".$persoon."', '".$bedrag."', '".$log."', '".$this->game_id."')"); echo "$inc_bank_7 $".number_format($bedrag)." $inc_bank_11 ".$persoon."."; } } else echo "$inc_bank_12"; } else if($soort == "Familie"){ if($this->data[familie] != ""){ if($this->data[bank] < $bedrag) echo "$inc_bank_6"; else if($bedrag == "" || $bedrag < 1) echo "$inc_bank_2"; else if(!is_numeric($bedrag)) echo "$inc_bank_3"; else { $this->data[bank] -= $bedrag; $this->update_geld(); mysql_query("UPDATE `families` SET `bank`=`bank`+'".$bedrag."' WHERE `familie`='".$this->data[familie]."' AND `game_id`='".$this->game_id."'"); mysql_query("INSERT INTO `overschrijving`(`time`, `ip`, `van`, `naar`, `bedrag`, `message`, `game_id`) VALUES('".time()."', '".$_SERVER['REMOTE_ADDR']."', '".$this->data[login]."', '".$this->data[familie]."', '".$bedrag."', '".$log."', '".$this->game_id."')"); echo "$inc_bank_7 $".number_format($bedrag)." $inc_bank_11 ".$this->data[familie]."."; } } else echo "$inc_bank_13"; } } } $bank = new bank; $bank->gegevens(); $rente_geld = array("-1", "1000000", "1500000", "2000000", "2500000", "3000000", "3500000", "4000000", "4500000", "5000000", "5500000"); $rente = 11; for($a = 1; $a <= 11; $a++){ if($data[bank] > $rente_geld[$a - 1] && $data[bank] <= $rente_geld[$a]) $a = 12; $rente--; } ?> <html> <head> <title><?php echo $game_title;?></title> <?php require("include/db.php"); mysql_connect($host,$user,$pass) or die(mysql_error()); mysql_select_db($tablename) or die(mysql_error()); $id_game=$data['game_id']; $res = mysql_query("select layout from games where id='1'") or die(mysql_error()); if(mysql_num_rows($res) > 0){ $arr = mysql_fetch_assoc($res); $id_layout = $arr['layout']; }else{ $id_layout = 1; } ?> <link rel="stylesheet" type="text/css" href="layout/<?php echo $id_layout ?>/css.css"> </head> <body> <table width="563" height="135" cellpadding="0" cellspacing="0"> <tr> <td width="563" height="135" background="images/main_stats.jpg" style="padding-left: 32px;" valign="top"> <br /> <br /> <?php include("mainframe_stats.php"); ?> </td> </tr> </table> <br /> <table width="550" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="sub" align="center"> <b><?php echo $inc_bank_14 ?></b> </td> </tr> </table> <table width="538" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="main"> <table width="525" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="center"><a href="bank.php"><strong><?php echo $inc_bank_15 ?></strong></a></td> <td align="center"><a href="bank.php?show=transfer"><strong><?php echo $inc_bank_16 ?></strong></a></td> <td align="center"><a href="bank.php?show=transactions"><strong><?php echo $inc_bank_17 ?></strong></a></td> </tr> </table> </td> </tr> </table> <br /> <table width="550" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="sub" align="center"> <b><?php echo $inc_bank_19 ?></b> </td> </tr> </table> <table width="538" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="main" align="center"> <?php if($_GET['show'] == "transfer"){ if(isset($_POST['submit'])){ $bank->overboeken($_POST['bedrag'], $_POST['type'], $_POST['naam'], $_POST['description']); } else { ?> <u><b><?php echo $inc_bank_18 ?> $<?php echo number_format($data[bank]); ?> </strong><br /> </td> </tr> </table> <table width="80%" border="0" align="center" cellpadding="0" cellspacing="0"> <td width="100"> <tr> <td> <select name="type" style="width:125;"><option value="crimineel"><?php echo $inc_bank_20 ?></option><option value="Familie"><?php echo $inc_bank_21 ?></option></select> <input type="text" name="naam" maxlength="16" value="<?php echo $_GET['login']; ?>" style="width:150;"> $ <input type="text" name="bedrag" maxlength="20" style="width: 150;"></td> </tr> </td> <td width="75%"> <tr> <td> <select name="type" style="width:125;"><option value="crimineel"><?php echo $inc_bank_20 ?></option><option value="Familie"><?php echo $inc_bank_21 ?></option></select> <input type="text" name="naam" maxlength="16" value="<?php echo $_GET['login']; ?>" style="width:150;"> $ <input type="text" name="bedrag" maxlength="20" style="width: 150;"></td> </tr> <tr> <td> </td> </tr> <tr> <td> <input type="text" name="description" maxlength="90" style="width:477;"></td> </tr> <tr> <td> </td> </tr> <tr> <td> <input type="submit" name="submit" value="<?php echo $inc_bank_22 ?>" style="width: 200;"></td> </tr> </td> </table> </form> <?php } ?> </td> </tr> </table> <br /> <?php } else if($_GET['show'] == "transactions"){ $dbres = mysql_query("SELECT * FROM `overschrijving` WHERE `van`='".$data[login]."' AND `game_id`='1' ORDER BY `id` DESC LIMIT $begin_1,5"); ?> <table width="525" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="center"><b>$ <?php echo number_format($data[cash]); ?> cash</b></td> <td align="center"><b>$ <?php echo number_format($data[bank]); ?> bank</b></td> <td align="center"><b>$ <?php echo number_format(round($data[bank]/100)*$rente); ?> <?php echo $inc_bank_30 ?> (<?php echo $rente; ?>%)</b></td> </tr> </table> </td> </tr> </table> <br /> <table width="550" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="sub" align="center"> <b><?php echo $inc_bank_24 ?></b> </td> </tr> </table> <table width="538" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="main" align="center"> <?php if(($rijen = mysql_num_rows($dbres)) != 0){ echo "<br />"; while($info = mysql_fetch_assoc($dbres)){ ?> <table width="500" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="200"><a href="profile.php?x=<?php echo $info[naar]; ?>"><strong><?php echo $info[naar]; ?></strong></a></td> <td width="250"><strong><?php echo date("d-m-Y H:i", $info[time]); ?></strong></td> <td><strong>$ <?php echo number_format($info[bedrag]); ?></strong></td> </tr> <tr> <td colspan="3"><i><?php echo $info[message]; ?></i></td> </tr> <tr> <td colspan="3"> </td> </tr> </table> <?php } ?> </td> </tr> </table> <?php $dbres = mysql_query("SELECT * FROM `overschrijving` WHERE `van`='".$data[login]."' AND `game_id`='1'"); if(mysql_num_rows($dbres) > 5){ echo "<table width=\"2\" height=\"2\" cellpadding=\"0\" cellspacing=\"0\"><tr><td width=\"2\" height=\"2\"></td></tr></table><table width=\"538\" style=\"margin: 0 auto;\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\"><tr><td class=\"main\" align=\"center\">"; if($begin_1 / 5 == 0) echo "<<</font>"; else echo "<a href=\"bank.php?show=transactions&q=".$_GET['q']."&p=0\" style=\"text-decoration: none;\"><<</a>"; if($_GET['p'] - 3 > 0){ $x = $_GET['p'] - 3; echo " ..."; } else $x = 0; if($_GET['p'] + 4 <= ceil(mysql_num_rows($dbres) / 5)) $y = $_GET['p'] + 4; else $y = ceil(mysql_num_rows($dbres) / 5); for($i = $x; $i < $y; $i++){ if($_GET['p'] == $i) echo "<b>"; echo " <a href=\"bank.php?show=transactions&q=".$_GET['q']."&p=$i\" style=\"text-decoration: none;\">". ($i+1) ."</a> "; if($_GET['p'] == $i) echo "</b>"; } if((mysql_num_rows($dbres) / 5) > $_GET['p'] + 4) echo "... "; if($begin_1 + 5 >= mysql_num_rows($dbres)) echo ">>"; else echo "<a href=\"bank.php?show=transactions&q=".$_GET['q']."&p=".(ceil(mysql_num_rows($dbres) / 5) - 1)."\" style=\"text-decoration: none;\">>></a>"; echo " </td></tr></table>"; } } else echo "<i>$inc_bank_25</i>"; ?> <br /> <table width="550" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="sub" align="center"> <b><?php echo $inc_bank_26 ?></b> </td> </tr> </table> <table width="538" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="main" align="center"> <?php $dbres = mysql_query("SELECT * FROM `overschrijving` WHERE `naar`='".$data[login]."' AND `game_id`='1' ORDER BY `id` DESC LIMIT $begin_2,5"); if(($rijen = mysql_num_rows($dbres)) != 0){ echo "<br />"; while($info = mysql_fetch_assoc($dbres)){ ?> <table width="500" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td class="mainD" width="200"><a href="profile.php?x=<?php echo $info[van]; ?>"><strong><?php echo $info[van]; ?></strong></a></td> <td class="mainD" width="250"><strong><?php echo date("d-m-Y H:i", $info[time]); ?></strong></td> <td class="mainD" width="100"><strong>$ <?php echo number_format($info[bedrag]); ?></strong></td> <td class="mainD"><a href="bank.php?delete=<?php echo $info[id]; ?>"><img src="images/delete.gif" border="0" alt="<?php echo $inc_bank_27 ?>"></a></td> </tr> <tr> <td class="mainD" colspan="4"><i><?php echo $info[message]; ?></i></td> </tr> <tr> <td colspan="4"> </td> </tr> </table> <?php } ?> </td> </tr> </table> <?php $dbres = mysql_query("SELECT * FROM `overschrijving` WHERE `naar`='".$data[login]."' AND `game_id`='1'"); if(mysql_num_rows($dbres) > 5){ echo "<table width=\"2\" height=\"2\" cellpadding=\"0\" cellspacing=\"0\"><tr><td width=\"2\" height=\"2\"></td></tr></table><table width=\"538\" style=\"margin: 0 auto;\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\"><tr><td class=\"main\" align=\"center\">"; if($begin_2 / 5 == 0) echo "<<</font>"; else echo "<a href=\"bank.php?show=transactions&p=".$_GET['p']."&q=0\" style=\"text-decoration: none;\"><<</a>"; if($_GET['q'] - 3 > 0){ $x = $_GET['q'] - 3; echo " ..."; } else $x = 0; if($_GET['q'] + 4 <= ceil(mysql_num_rows($dbres) / 5)) $y = $_GET['q'] + 4; else $y = ceil(mysql_num_rows($dbres) / 5); for($i = $x; $i < $y; $i++){ if($_GET['q'] == $i) echo "<b>"; echo " <a href=\"bank.php?show=transactions&p=".$_GET['p']."&q=$i\" style=\"text-decoration: none;\">". ($i+1) ."</a> "; if($_GET['q'] == $i) echo "</b>"; } if((mysql_num_rows($dbres) / 5) > $_GET['q'] + 4) echo "... "; if($begin_2 + 5 >= mysql_num_rows($dbres)) echo ">>"; else echo "<a href=\"bank.php?show=transactions&p=".$_GET['p']."&q=".(ceil(mysql_num_rows($dbres) / 5) - 1)."\" style=\"text-decoration: none;\">>></a>"; echo " </td></tr></table>"; } } else echo "<i>$inc_bank_28</i>"; ?> <br /> <?php } else { if(isset($_GET['delete'])){ mysql_query("DELETE FROM `overschrijving` WHERE `id`='".$_GET['delete']."' AND `game_id`='1'"); echo "$inc_bank_29"; } else if($_POST['type'] == "stort") $bank->storten($_POST['bedrag']); else if($_POST['type'] == "pin") $bank->pinnen($_POST['bedrag']); else { ?> <table width="525" border="0" align="center" cellpadding="0" cellspacing="0"> <tr><td align="center"><u><b><?php echo $inc_bank_32 ?></b></u></td><td align="center"><b>$<?php echo number_format($data[cash]); ?></b></td></tr> <tr><td align="center"><u><b><?php echo $inc_bank_31 ?></b></u></td><td align="center"><b>$<?php echo number_format($data[bank]); ?></b></td></tr> <tr><td align="center"><u><b><?php echo $inc_bank_30 ?></b></u></td><td align="center"><b>$<?php echo number_format(round($data[bank]/100)*$rente); ?> (<?php echo $rente; ?>%)</b></td></tr> </table> </td> </tr> </table> <br /> <table width="550" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="sub" align="center"> <b><?php echo $inc_bank_33 ?></b> </td> </tr> </table> <table width="538" style="margin: 0 auto;" align="center" cellspacing="0" cellpadding="0"> <tr> <td class="main" align="center"> <table width="525" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="center"> <form method="post" style="margin:0px"> <input type="radio" name="type" value="pin" class="radio" checked> <?php echo $inc_bank_34 ?> / <input type="radio" class="radio" name="type" value="stort"> <?php echo $inc_bank_35 ?> $ <input type="text" name="bedrag" maxlength="20" style="width:200;"> <input type="submit" name="submit" value="<?php echo $inc_bank_36 ?>" style="width: 100;"> </form> </td> </tr> </table> <?php } ?> </td> </tr> </table> <?php } ?> </body> </html> Code (markup):