hallo iedereen

ik heb een script gemaakt het gaat hier om een script over een bank
nou er zitten volgens mij geen fouten in maar hij vieuwt nix
ik heb hem gehost bij lycos
kan iemand kijken wat het probleem is?
want ik snap er echt helemaal nix van!
nou groetjuhs mzzl

ps: dit is het script


<?php
session_start();
define ('INCLUDECHECK', true);
require('site.conf.php');
include('functions.php');
include('bbcode.php');
include_once('class.RegInfo.php');
include_once('class.Reg.php');
include_once('class.Crime.php');
include_once('class.Messages.php');
include_once('class.Log.php');
include_once('class.Login.php');
include_once('class.Kill.php');
require('auth.php');
setlocale (LC_ALL, 'nl_NL');
$query = "SELECT * FROM `banned` WHERE `ip`= '". $_SERVER["REMOTE_ADDR"] ."' LIMIT 0,1" ;
$result = mysql_query($query);
$lst = mysql_fetch_array ($result);
if ( $_SERVER["REMOTE_ADDR"] == $lst['ip'] AND $lst['time'] > gmtime() ) {
$timenl = $lst['time'] + 3600 * 2;
die ("Je bent verbannen op deze site door: <strong>". $lst['by'] ."</strong>, tot: <strong>". strftime("%A %e %B %Y %H:%M:%S", $timenl) ."</strong>, omdat: <strong>". $lst['reason'] ."</strong>");
}
$info = new RegInfo();
$info->setId( $_SESSION['delucid'] );
if($info->getHealth() <= "0" AND $info->getClassId() <= "1") {
$sql = "SELECT members.nickname, kill_log.date FROM `kill_log` LEFT JOIN `members` ON kill_log.`shootid` = members.`id` WHERE kill_log.`killid` = '". $info->getId() ."' ORDER BY kill_log.`date` DESC LIMIT 0,1";
$query = mysql_query( $sql );
while( $lst = mysql_fetch_array( $query ) ) {
$name = $lst['nickname'];
$date = $lst['date'];
}
$messages = new Message();
$messages->setMemberId( $_COOKIE['delucid'] );
mysql_query("UPDATE `members` SET `lastaction` = '". gmtime() ."' WHERE `id` = '". $info->getId() ."' LIMIT 1");
// User Menu's
if( $info->getClassId() >= "1" ) {

switch ($_GET['p']) {
// Main:
CASE "home": $include = "members.home.php"; $title = "Home"; break;
CASE "faq": $include = "faq.php"; $title = "Frequently Asked Questions"; break;
CASE "reis": include_once('reis.php'); $title = "Reizen"; break;
CASE "nieuws": include_once('nieuws.php'); $title = "Nieuws"; break;
CASE "profile": include_once('profile.php'); $title = "Profiel"; break;
CASE "profiletest": $include = "profile_test.php"; $title = "Profile"; break;
CASE "stats": include_once('stats.php'); $title = "Stats"; break;
CASE "bank": include_once('bank.php'); $title = "Bank"; break;
CASE "kluis": include_once('bank.php'); $title = "Kluis"; break;
CASE "gevangenis": include_once('jail.php'); $title = "Gevangenis"; break;
CASE "uonline": include_once('uonline.php'); $title = "Online Users"; break;
CASE "meminfo": include_once('meminfo.php'); $title = "Member Info"; break;
CASE "bulletfactory": include_once('bulletfactory.php'); $title = "Bullitfactory"; break;
CASE "shop": include_once('shop.php'); $title = "Shop"; break;
CASE "search": include_once('search.php'); $title = "Search"; break;
CASE "kill": include_once('kill.php'); $title = "Kill"; break;
CASE "attacklog": include_once('attacklog.php'); $title = "Attac Log"; break;
// Crimes:
CASE "crime": include_once('crime.php'); $title = "Pleeg Misdaad"; break;
CASE "crimeautos": include_once('crimeautos.php'); $title = "Steel een Auto"; break;
CASE "garage": include_once('garage.php'); $title = "Garage"; break;
// Casino:
CASE "numbergame": include_once('numbergame.php'); $title = "Raad het Nummer"; break;
// Private Messages:
CASE "inbox": include_once('messages.php'); $title = "Inbox"; break;
CASE "outbox": include_once('messages.php'); $title = "Outbox"; break;
CASE "sendmsg": include_once('messages.php'); $title = "Send Message"; break;
CASE "readmsg": include_once('messages.php'); $title = "Read Message"; break;
CASE "deletemsg": include_once('messages.php'); $title = "Delete Message"; break;
}
$menu .= "\t\t&nbsp;<strong>Main:</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=home\">Beginpagina</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=faq\">FAQ</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=profile\">Profiel</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=nieuws\">Nieuws</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=reis\">Reizen</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=gevangenis\">Gevangenis</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=uonline\">Online Users</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=bulletfactory\">Bullet Factory</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=shop\">Shop</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=kill\">Kill / Search</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=attacklog\">Attacklog</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";

$menu .= "\t\t&nbsp;<strong>Crimes:</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=crime\">Misdaad</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=crimeautos\">Steel een Auto</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=garage\">Garage</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";

$menu .= "\t\t&nbsp;<strong>Bankzaken:</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=bank\">Bank</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=kluis\">Kluis</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";

$menu .= "\t\t&nbsp;<strong>Communicatie</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"javascript:popUp('WebChat/index.php?PHPSESSID=". session_id() ."')\">WebChat</a><br/>\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=inbox\">Inbox (". $messages->getCountInboxUnread() ."/". $messages->getCountInbox() .")</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=outbox\">Outbox (". $messages->getCountOutbox() .")</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=sendmsg\">Stuur Bericht</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";

$menu .= "\t\t&nbsp;<strong>Casino:</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=numbergame\">Raad het Nummer</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";

$menu .= "\t\t&nbsp;<strong>Zoek Speler:</strong><br />\n";
$menu .= "\t\t<form name=\"search\" method=\"post\" action=\"members.php?p=search\">";
$menu .= "\t\t<input type=\"text\" name=\"searchstring\">";
$menu .= "\t\t<br>";
$menu .= "\t\t<input type=\"submit\" name=\"search\" value=\"Zoek\">";
$menu .= "\t\t</form>";
$menu .= "\t\t&nbsp;<br />\n";
}

if( $info->getClassId() >= "2" ) {

switch ($_GET['p']) {
//CASE "bleh": include_once('bleh.php'); $title = "bleh"; break;
}
$menu .= "\t\t&nbsp;<strong>Moderator Tools:</strong><br />\n";
$menu .= "\t\t&nbsp;Geef Waarschuwing<br />\n";
$menu .= "\t\t&nbsp;Punish<br />\n";
$menu .= "\t\t&nbsp;<br />\n";
}

if( $info->getClassId() >= "3" ) {

switch ($_GET['p']) {
CASE "banip": include_once('banip.php'); $title = "Ban IP"; break;
CASE "unbanip": include_once('banip.php'); $title = "Unban IP"; break;
CASE "bannick": include_once('bannick.php'); $title = "Ban Nick"; break;
CASE "unbannick": include_once('bannick.php'); $title = "Unban Nick"; break;
CASE "usercheck": include_once('usercheck.php'); $title = "User Check"; break;
}
$menu .= "\t\t&nbsp;<strong>SuperMod Tools:</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=banip\">IP Ban</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=unbanip\">UnIP Ban</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=bannick\">Nick Ban</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=unbannick\">UnNick Ban</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=usercheck\">User RegDate Check</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";
}

if( $info->getClassId() >= "4" ) {

switch ($_GET['p']) {
CASE "regnew": include_once('admin.regnew.php'); $title = "Register New User"; break;
CASE "regupdate": include_once('admin.regupdate.php'); $title = "Update User"; break;
CASE "regdelete": include_once('admin.regdel.php'); $title = "Delete User"; break;
}
$menu .= "\t\t&nbsp;<strong>Admin Tools:</strong><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=regnew\">Reg New User</a><br />\n";
$menu .= "\t\t&nbsp;<a href=\"members.php?p=regupdate\">Update User</a><br />\n";
$menu .= "\t\t&nbsp;<br />\n";
}

$menu .= "\t\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a onclick=\"return(confirm('Weet je zeker dat je wil uitloggen?'))\" href=\"logout.php\">Uitloggen</a><br />\n";

// Updating UserData
$info->ReSet();

// Login Data
$loginmenu .= "\t\t&nbsp;Logged in As: ". $info->getName() ."<br />\n";
$loginmenu .= "\t\t&nbsp;Cash: &euro;". number_format($info->getGeld(), 0, ',', '.') ."<br />\n";
$loginmenu .= "\t\t&nbsp;Bank: &euro;". number_format($info->getBank(), 0, ',', '.') ."<br />\n";
$loginmenu .= "\t\t&nbsp;Safe: &euro;". number_format($info->getKluis(), 0, ',', '.') ."<br />\n";
$loginmenu .= "\t\t&nbsp;Rang: ". $info->getSubClass() ."<br />\n";
$loginmenu .= "\t\t&nbsp;Location: ". $info->getLokatie() ."<br />\n";
$loginmenu .= "\t\t&nbsp;Bullets: ". number_format($info->getBullets(), 0, ',', '.') ."<br />\n";
$loginmenu .= "\t\t&nbsp;Health: <img src=\"img/health.gif\" />". $info->getHealth() ."%<br />\n";
$loginmenu .= "\t\t&nbsp;Shield: <img src=\"img/shield.gif\" />". $info->getShield() ."%<br />\n";
$loginmenu .= "\t\t<br />\n";

$logindata = $loginmenu;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">;
<html>

<head>
<title>The godfather 2005 :: <?php echo "$title"; ?></title>
<link href="deluccio.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT LANGUAGE="JavaScript">
function popUp(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=800,height=600,left = 240,top = 212');");
}
</script>
</head>
<body bgcolor="#868686" text="#000000">
<div align="center">
<table width="800" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" rowspan="4" align="left" valign="top" nowrap bgcolor="#999999">
<br />
<?
echo "\t\t&nbsp;Logged in As: ". $info->getName() ."<br />\n";
echo "\t\t&nbsp;Rang: ". $info->getSubClass() ."<br />\n";
echo "\t\t&nbsp;Cash: &euro;". number_format($info->getGeld(), 0, ',', '.') ."<br />\n";
echo "\t\t&nbsp;Bank: &euro;". number_format($info->getBank(), 0, ',', '.') ."<br />\n";
echo "\t\t&nbsp;Safe: &euro;". number_format($info->getKluis(), 0, ',', '.') ."<br />\n";
echo "\t\t&nbsp;Location: ". $info->getLokatie() ."<br />\n";
echo "\t\t&nbsp;Bullets: ". number_format($info->getBullets(), 0, ',', '.') ."<br />\n";
echo "\t\t&nbsp;Health: <img src=\"img/health.gif\" />". $info->getHealth() ."%<br />\n";
echo "\t\t&nbsp;Shield: <img src=\"img/shield.gif\" />". $info->getShield() ."%<br />\n";
echo "\t\t<br />\n";
echo "\t\t<br />\n";
echo "\t\t&nbsp;<strong>Main:</strong><br />\n";
echo "\t\t&nbsp;<a href=\"members.php?p=home\">Beginpagina</a><br />\n";
echo "\t\t&nbsp;<a href=\"faq.php\">FAQ</a><br />\n";
echo "\t\t&nbsp;<a href=\"profiel.php\">Profiel</a><br />\n";
echo "\t\t&nbsp;<a href=\"nieuws.php\">Nieuws</a><br />\n";
echo "\t\t&nbsp;<a href=\"reis.php\">Reizen</a><br />\n";
echo "\t\t&nbsp;<a href=\"gevangenis.php\">Gevangenis</a><br />\n";
echo "\t\t&nbsp;<a href=\"uonline.php\">Online Users</a><br />\n";
echo "\t\t&nbsp;<a href=\"bulletfactory.php\">Bullet Factory</a><br />\n";
echo "\t\t&nbsp;<a href=\"shop.php\">Shop</a><br />\n";
echo "\t\t&nbsp;<a href=\"kill.php\">Kill / Search</a><br />\n";
echo "\t\t&nbsp;<a href=\"attacklog.php\">Attacklog</a><br />\n";
echo "\t\t&nbsp;<br />\n";
echo "\t\t&nbsp;<strong>Crimes:</strong><br />\n";
echo "\t\t&nbsp;<a href=\"crime.php\">Misdaad</a><br />\n";
echo "\t\t&nbsp;<a href=\"crimeautos.php\">Steel een Auto</a><br />\n";
echo "\t\t&nbsp;<a href=\"garage.php\">Garage</a><br />\n";
echo "\t\t&nbsp;<br />\n";
echo "\t\t&nbsp;<strong>Bankzaken:</strong><br />\n";
echo "\t\t&nbsp;<a href=\"bank.php\">Bank</a><br />\n";
echo "\t\t&nbsp;<a href=\"kluis.php\">Kluis</a><br />\n";
echo "\t\t&nbsp;<br />\n";
echo "\t\t&nbsp;<br />\n";
echo "\t\t&nbsp;<strong>Casino:</strong><br />\n";
echo "\t\t&nbsp;<a href=\"\numbergame.php\">Raad het Nummer</a><br />\n";
echo "\t\t&nbsp;<br />\n";
echo "\t\t&nbsp;<strong>Zoek Speler:</strong><br />\n";
echo "\t\t<form name=\"search\" method=\"post\" action=\"search.php\">";
echo "\t\t<input type=\"text\" name=\"searchstring\">";
echo "\t\t<br>";
echo "\t\t<input type=\"submit\" name=\"search\" value=\"Zoek\">";
echo "\t\t</form>";
?>
</td>
</tr>
<tr>
<td width="15" rowspan="3">&nbsp;</td>
<td width="400" rowspan="3" valign="top" nowrap>&nbsp;<p>
<p class=Normal align=center style='text-align:center;'><b><i><span style='font-weight:bold;'>Bank</span></b></i></p>

<?
if( $info->getJail() != FALSE ) {
echo "\t\t&nbsp;<strong>
<div align=\"center\">
<img src=\"img/jail.gif\" width=\"200\" height=\"200\" border=\"0\" />
<br />
<script>
<!--
var seconds=". ($info->getJail()+1) ."
document.write(\"Je zit nog <span id='cntdwn'></span>&nbsp;seconden in de gevangenis!\");
function display(){
if (seconds<=0){
seconds=0
location = \"". $_SERVER['REQUEST_URI'] ."\";
}
else {
seconds-=1

document.getElementById(\"cntdwn\").innerHTML = seconds;
setTimeout(\"display()\",1000)
}
}
display()
//-->
</script>
</div>";
}
else {
if($_GET['p'] == "bank") {

if(isset($_POST['overschrijven'])) {
$bedrag = str_replace(".","",$_POST['bedrag']);
$sql = "SELECT * FROM `members` WHERE `nickname` = '". $_POST['to'] ."' ";
$query = mysql_query( $sql );

// Converting Username to Userid
while( $lst = mysql_fetch_object( $query ) ) {
$to_id = $lst->id;
$to_geld = $lst->geld;
}

if ( empty( $_POST['to'] ) ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Empty Username!</td>
</tr>";
}
elseif ( $to_id == $info->getId() ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Je kan niet naar jezelf Overmaken!</td>
</tr>";
}
elseif ( !is_numeric( $bedrag ) ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
elseif( substr($bedrag,0,1) == "-" ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
elseif ( mysql_num_rows( $query ) == "0" ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Geen geldinge username</td>
</tr>";
}
elseif ( empty( $bedrag ) ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Empty Bedrag!</td>
</tr>";
}
elseif ( $info->getGeld() < $bedrag ) {
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Je hebt niet zoveel Geld!</td>
</tr>";
}
else {
$sql = "INSERT INTO `bank_transactions` ( `to_id` , `from_id` , `date` , `ip` `bedrag` , `details` ) VALUES ('". $to_id ."', '". $info->getId() ."', '". gmtime() ."', '". $_SERVER['REMOTE_ADDR'] ."', '". $bedrag ."', '". $_POST['details'] ."')";
mysql_query( $sql );
$newgeld1 = $info->getGeld()-$bedrag;
$newgeld2 = $to_geld+$bedrag;
$sql = "UPDATE `members` SET `geld` = '". $newgeld1 ."' WHERE `id` = '". $info->getId() ."' LIMIT 1";
mysql_query( $sql );
$sql = "UPDATE `members` SET `geld` = '". $newgeld2 ."' WHERE `id` = '". $to_id ."' LIMIT 1";
mysql_query( $sql );
$transaction .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">&euro;". number_format($bedrag, 0, ',', '.') ." overgemaakt naar: ". $_POST['to'] ."</td>
</tr>";

}
}

if(isset($_POST['storten'])){
$bedrag = str_replace(".","",$_POST['bedrag']);
if( $info->getGeld() < $bedrag ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Je hebt niet genoeg geld om &euro;". number_format($bedrag, 0, ',', '.') ." te storten!</td>
</tr>";
}
elseif ( !is_numeric( $bedrag ) ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
elseif( substr($bedrag,0,1) == "-" ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
else {
$newgeld = $info->getGeld()-$bedrag;
$newbank = $info->getBank()+$bedrag;
$sql = "UPDATE `members` SET `geld` = '". $newgeld ."', `bank` = '". $newbank ."', `laststort` = '". gmtime() ."' WHERE `id` = '". $info->getId() ."' LIMIT 1";
mysql_query( $sql );
// Updating UserData
$info->ReSet();
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Bijgeschreven op de bank: &euro;". number_format($bedrag, 0, ',', '.') ."</td>
</tr>";
}
}
if(isset($_POST['opnemen'])){
$bedrag = str_replace(".","",$_POST['bedrag']);
if( $info->getBank() < $bedrag ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Je hebt niet genoeg geld op de bank om &euro;". number_format($bedrag, 0, ',', '.') ." op te nemen!</td>
</tr>";
}
elseif ( !is_numeric( $bedrag ) ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
elseif( substr($bedrag,0,1) == "-" ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
else {
$newgeld = $info->getGeld()+$bedrag;
$newbank = $info->getBank()-$bedrag;
$sql = "UPDATE `members` SET `geld` = '". $newgeld ."', `bank` = '". $newbank ."' WHERE `id` = '". $info->getId() ."' LIMIT 1";
mysql_query( $sql );
// Updating UserData
$info->ReSet();
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">Afgeschreven van de bank: &euro;". number_format($bedrag, 0, ',', '.') ."</td>
</tr>";
}
}
if(isset($_POST['rente'])){
$rente = ($info->getBank()/10);
$newgeld = $info->getBank()+$rente;
$sql = "UPDATE `members` SET `bank` = '". $newgeld ."', `lastrente` = '". gmtime() ."' WHERE `id` = '". $info->getId() ."' LIMIT 1";
mysql_query( $sql );
// Updating UserData
$info->ReSet();
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">&euro;". number_format($rente, 0, ',', '.') ." ontvangen!</td>
</tr>";
}
// Updating UserData
$info->ReSet();

$hour = gmdate("H");
$shour = gmdate("H")-1;
$minute = gmdate("i");
$second = gmdate("s");
$month = gmdate("m");
$day = gmdate("d");
$sday = gmdate("d")-1;
$year = gmdate("Y");

$time1 = mktime ( $hour, $minute, $second, $month, $sday, $year);
$time2 = mktime ( $shour, $minute, $second, $month, $day, $year);
$sql = "SELECT * FROM `members` WHERE `lastrente` < '". $time1 ."' AND `laststort` < '". $time2 ."' AND `id` = '". $info->getId() ."' LIMIT 0,1";
$query = mysql_query( $sql );
if( mysql_num_rows( $query ) != "0" ) {
$rentebutton = "<input type=\"submit\" name=\"rente\" value=\"Rente\">";
}
else {
$rentebutton = "Je moet nog even wachten!";
}

echo "\t\t&nbsp;<strong>
<table width=\"400\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#999999\">
<tr align=\"center\" valign=\"top\" bordercolor=\"#000000\">
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr>
<tr align=\"center\" valign=\"top\"><td colspan=\"4\"><strong>BANK</strong></td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr>
<tr>
<td width=\"300\" colspan=\"4\">Je hebt op je bank: </td>
<td width=\"100\" colspan=\"1\">&euro;". number_format($info->getBank(), 0, ',', '.') ."</td>
</tr>
<tr>
<td width=\"300\" colspan=\"4\">Je ontvangt 10%</td>
<td width=\"100\" colspan=\"1\">&euro;". number_format(($info->getBank()/10), 0, ',', '.') ."</td>
</tr>
<tr>
<td width=\"300\" colspan=\"4\">Je hebt op zak: </td>
<td width=\"100\" colspan=\"1\">&euro;". number_format($info->getGeld(), 0, ',', '.') ."</td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr></strong><br />\n";


echo "\t\t&nbsp;<strong>$bankzaken</strong><br />\n";

echo "\t\t&nbsp;<strong>
<form name=\"storten\" method=\"post\" action=\"banks.php?p=bank\">
<tr>
<td width=\"300\" colspan=\"4\" align=\"center\">
<input type=\"text\" name=\"bedrag\">
</td>
<td width=\"100\" colspan=\"1\"><input type=\"submit\" name=\"storten\" value=\"Storten\"></td>
</tr>
</form>
<form name=\"opnemen\" method=\"post\" action=\"bank.php?p=bank\">
<tr>
<td width=\"300\" colspan=\"4\" align=\"center\">
<input type=\"text\" name=\"bedrag\">
</td>
<td width=\"100\" colspan=\"1\"><input type=\"submit\" name=\"opnemen\" value=\"Opnemen\"></td>
</tr>
</form>
<form name=\"rente\" method=\"post\" action=\"bank.php?p=bank\">
<tr>
<td width=\"300\" colspan=\"4\">Stort Rente (max 1x per dag en minimaal 1 uur na je laatste storting)</td>
<td width=\"100\" colspan=\"1\">". $rentebutton ."</td>
</tr>
</form></strong><br />\n";

echo "\t\t&nbsp;<strong>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><strong>OVERSCHRIJVINGEN</strong></td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr>
<tr>
<td width=\"75\" align=\"left\" valign=\"top\">Naam</td>
<td width=\"100\" align=\"left\" valign=\"top\">Datum</td>
<td width=\"100\" align=\"left\" valign=\"top\">Details</td>
<td width=\"50\" align=\"left\" valign=\"top\">Af/Bij</td>
<td width=\"75\" align=\"left\" valign=\"top\">Bedrag</td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr></strong><br />\n";

$sql = "
SELECT members.nickname, bank_transactions.*
FROM `bank_transactions`
INNER JOIN `members` ON
CASE
WHEN bank_transactions.to_id=". $info->getId() ." THEN
bank_transactions.from_id
ELSE
bank_transactions.to_id
END = members.id
WHERE bank_transactions.to_id=". $info->getId() ."
OR bank_transactions.from_id=". $info->getId() ."
ORDER by bank_transactions.date DESC LIMIT 0,5";

$query = mysql_query( $sql );
while( $lst = mysql_fetch_array( $query ) ) {
if( $info->getId() == $lst['to_id'] ) {
$afbij = "Bij";
}
elseif ( $info->getId() == $lst['from_id'] ) {
$afbij = "Af";
}
$regtimenl = $lst['date'] + 3600 * 2 ;
echo "\t\t&nbsp;<strong>

<tr>
<td width=\"75\" align=\"left\" valign=\"top\">". $lst['nickname'] ."</td>
<td width=\"100\" align=\"left\" valign=\"top\">". date("d-m H:i", $regtimenl) ."</td>
<td width=\"100\" align=\"left\" valign=\"top\">". $lst['details'] ."</td>
<td width=\"50\" align=\"left\" valign=\"top\">". $afbij ."</td>
<td width=\"75\" align=\"left\" valign=\"top\">&euro;". number_format($lst['bedrag'], 0, ',', '.') ."</td>
</tr></strong><br />\n";
}

echo "\t\t&nbsp;<strong>
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\"><hr size=\"1\"></td>
</tr></strong><br />\n";


echo "\t\t&nbsp;<strong>$transaction</strong><br />\n";

echo "\t\t&nbsp;<strong>
<form name=\"transaction\" method=\"post\" action=\"members.php?p=bank\">
<tr>
<td width=\"100\" colspan=\"1\" align=\"center\">
To: <input type=\"text\" name=\"to\" size=\"15\">
</td>
<td width=\"100\" colspan=\"1\" align=\"center\">
Bedrag: <input type=\"text\" name=\"bedrag\" size=\"15\">
</td>
<td width=\"100\" colspan=\"1\" align=\"center\">
Details: <input type=\"text\" name=\"details\" size=\"15\">
</td>
<td width=\"100\" colspan=\"2\" valign=\"bottom\"><input type=\"submit\" name=\"overschrijven\" value=\"Overschrijven!\"></td>
</tr>
</form>
</table></strong><br />\n";
}

elseif($_GET['p'] == "kluis") {
if(isset($_POST['storten'])){
$bedrag = str_replace(".","",$_POST['bedrag']);
if( $info->getGeld() < $bedrag ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\">Je hebt niet genoeg geld om &euro;". number_format($bedrag, 0, ',', '.') ." te storten!</td>
</tr>";
}
elseif ( !is_numeric( $bedrag ) ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
elseif( substr($bedrag,0,1) == "-" ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
else {
$newgeld = $info->getGeld()-$bedrag;
$newkluis = $info->getKluis()+$bedrag;
$sql = "UPDATE `members` SET `geld` = '". $newgeld ."', `kluis` = '". $newkluis ."' WHERE `id` = '". $info->getId() ."' LIMIT 1";
mysql_query( $sql );
// Updating UserData
$info->ReSet();
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\">Bijgeschreven in de kluis: &euro;". number_format($bedrag, 0, ',', '.') ."</td>
</tr>";
}
}
if(isset($_POST['opnemen'])){
$bedrag = str_replace(".","",$_POST['bedrag']);
if( $info->getKluis() < $bedrag ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\">Je hebt niet genoeg geld in de kluis om &euro;". number_format($bedrag, 0, ',', '.') ." op te nemen!</td>
</tr>";
}
elseif ( !is_numeric( $bedrag ) ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
elseif( substr($bedrag,0,1) == "-" ) {
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"5\">". $bedrag ." is geen geldig bedrag!</td>
</tr>";
}
else {
$newgeld = $info->getGeld()+$bedrag;
$newkluis = $info->getKluis()-$bedrag;
$sql = "UPDATE `members` SET `geld` = '". $newgeld ."', `kluis` = '". $newkluis ."' WHERE `id` = '". $info->getId() ."' LIMIT 1";
mysql_query( $sql );
// Updating UserData
$info->ReSet();
$bankzaken .= "
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\">Afgeschreven van de kluis: &euro;". number_format($bedrag, 0, ',', '.') ."</td>
</tr>";
}
}

echo "\t\t&nbsp;<strong>
<table width=\"400\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#999999\">
<tr align=\"center\" valign=\"top\" bordercolor=\"#000000\">
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\"><hr size=\"1\"></td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\"><strong>KLUIS</strong></td>
</tr>
<tr align=\"center\" valign=\"top\">
<td colspan=\"4\"><hr size=\"1\"></td>
</tr></strong><br />\n";


echo "\t\t&nbsp;<strong>$bankzaken</strong><br />\n";

echo "\t\t&nbsp;<strong>
<tr>
<td width=\"300\" colspan=\"3\">Je hebt in je kluis: </td>
<td width=\"100\" colspan=\"1\">&euro;". number_format($info->getKluis(), 0, ',', '.') ."</td>
</tr>
<form name=\"storten\" method=\"post\" action=\"bank.php?p=kluis\">
<tr>
<td width=\"300\" colspan=\"3\" align=\"center\">
<input type=\"text\" name=\"bedrag\">
</td>
<td width=\"100\" colspan=\"1\"><input type=\"submit\" name=\"storten\" value=\"Storten\"></td>
</tr>
</form>
<form name=\"opnemen\" method=\"post\" action=\"bank.php?p=kluis\">
<tr>
<td width=\"300\" colspan=\"3\" align=\"center\">
<input type=\"text\" name=\"bedrag\">
</td>
<td width=\"100\" colspan=\"1\"><input type=\"submit\" name=\"opnemen\" value=\"Opnemen\"></td>
</tr>
</form>
</table></strong><br />\n";
}
}
?>


<td width="15" rowspan="3">&nbsp;</td>
<td height="10" valign="top" nowrap class="news">

<?
echo "\t\t<strong>Rank Vordering:</strong><br />\n";
echo "\t\t<table width=\"100\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo "\t\t <tr>\n";
echo "\t\t <td width=\"". $info->getProgress() ."\" bgcolor=\"#999999\" align=\"center\">". $info->getProgress() ."%</td>\n";
echo "\t\t <td width=\"". ( 100 - $info->getProgress() ) ."\"bgcolor=\"#333333\"></td>\n";
echo "\t\t </tr>\n";
echo "\t\t</table>\n";
?>
</td>
</tr>
<tr>
<td width="175" height="10" valign="top" nowrap class="news" align="center">
<p>
<strong>News:</strong></td>
</tr>
<tr>
<td width="170" valign="top" nowrap class="news" align="center">
<? echo $outputnews; ?>
Geachtige spelers,<br>
<br>
The Godfather is nog niet klaar! en er is nog veel te doen. Als je kunt
helpen mail me maar!!!! <br>
<br>
<br>
De admins zijn: Gianello, Sanvito<br>
<br>
houd je aan de regels of er zal een ban volgen! Of een admin kill!<br>
<br>
<br>
Als je bent gehackt stuur gerust een mailtje naar de admin en we zullen
de hacker streng aanpakken!<p>We zoeken nog crew members dusssss meld je
snelll aan!!!<br>
<br>
<br>
Groetjuhs,<br>
The Godfather crew<br><br>
</td>
</tr>
<tr>
<td colspan="5" height="10" align="center">&nbsp;</td>
</tr>
<tr>
<td height="15" colspan="5" align="center" valign="bottom"><font size="1">Copyright &copy; The Godfather 2005. All rights reserved</font></td>
</tr>
</table>
</div>
</body>
</html>
ps: hij laat alleen op de pagina het woord bank zien niet een error ofzo
nou groetjuhssss(alweer):p
Je moet het ook niet bij Lycos derop gooien, heb ik wel vaker gehad dat iets daar niet werkt.
weet jij nog een gratis host met een makkelijk bestuurbare database en php ondersteuning en zonder reclame?
funpic.org...
gerard schreef op 05.06.2005 11:53
weet jij nog een gratis host met een makkelijk bestuurbare database en php ondersteuning en zonder reclame?


Zie dit topic.
Ik vind het altijd bijzonder dat men niet bereid is om 40 euro per jaar voor hosting te betalen maar wel uren besteedt aan het uitzoeken voor een gratis host...
ik ben pas 12 en ik mag geen host van me ouders dusss:P

Reageren