Jump to content

[PHP] help!

Gamblexmaster

By Gamblexmaster
in PHP Coding Help

 Share

Recommended Posts

Gamblexmaster Newbie

Gamblexmaster

Posted
Posted

Best,

 

I am currently working on a mafia crime game. But there is something wrong with my script.
I have 1 error on my news. php, and will you even error + the script here.

I know that my script is messy but am still but a novice :P

It would be great if this solved hit!

And sorry for my bad English. (IM a Belgian)

Here the error + script:

 

error:

Parse error: syntax error, unexpected $end in C:\xampp\htdocs\_menu_l.php on line 881

and here the script:

<?php

$__admin = 16;
$__gmod = 8;
$__fmod = 4;
$__help = 2;

include("./includes/_mysql_connection.php");
include("./includes/_functions.php");
include("_functies.php");

if(!isset($_SESSION['__id'])){

	header("location: index.php");

}


define("ID", $_SESSION['__id']);



$select = mysql_query("SELECT `username`, `ip`, `lastclick`, `id` FROM `users` WHERE `id` = ".ID." LIMIT 1") or die(mysql_error());


if(mysql_num_rows($select) == 0){
	header("location: index.php");
}

$res = mysql_fetch_assoc($select);


$naam = $res['username'];


$SESSID = $_COOKIE['PHPSESSID'];

$s = mysql_query("SELECT `id` FROM `sessions` WHERE `id`=".ID." AND `SESSID`='".mr($SESSID)."' LIMIT 1") or die(mysql_error());
if(mysql_num_rows($s) == 0){
 	$sql = mysql_query("SELECT `id` FROM `sessions` WHERE `id`=".ID." LIMIT 1") or die(mysql_error());
	if(mysql_num_rows($sql) == 0){
		mysql_query("INSERT INTO `sessions`(`id`, `SESSID`) VALUES (".ID.", '".mr($_COOKIE['PHPSESSID'])."')") or die(mysql_error());
	}
        /* else {
		unset($_SESSION);
		header("location: index.php");
}*/
 if(mysql_num_rows($s) > 0 AND !isset($_SESSION['logged'])) {
		unset($_SESSION);
		header("location: index.php");
	}
	
}

mysql_query("UPDATE `sessions` SET `SESSID`='".$SESSID."' WHERE `id`=".ID." LIMIT 1") or die(mysql_error());



// Selecteer wat data
$sql = mysql_query("SELECT `speldata`. * , `landen`.`land` , `familie`.`naam`
FROM `speldata`
LEFT JOIN `landen` ON ( `speldata`.`land_id` = `landen`.`id` )
LEFT JOIN `familie` ON ( `speldata`.`familie_id` = `familie`.`id` )
WHERE `speldata`.`id` =".ID."
LIMIT 1 ") or die(mysql_error());


$res = mysql_fetch_assoc($sql);

/* Data invullen */
if(!is_null($res['naam'])){
	$hasfam = true;
} else {
	$hasfam = false;
}

$sql = mysql_query("SELECT COUNT(`id`) FROM `familie` WHERE `baas_id`=".ID." LIMIT 1") or die(mysql_error());

if(mysql_result($sql, 0) == 1){
	$famboss = true;
} else {
	$famboss = false;
}

$sql = mysql_query("SELECT COUNT(`id`) FROM `familie` WHERE `onderbaas_id`=".ID." LIMIT 1") or die(mysql_error());

if(mysql_result($sql, 0) == 1){
	$famunderboss = true;
} else {
	$famunderboss = false;
}

$sql = mysql_query("SELECT COUNT(`id`) FROM `familie` WHERE `shoutboxmod`=".ID." LIMIT 1") or die(mysql_error());

if(mysql_result($sql, 0) == 1){
	$shoutmod = true;
} else {
	$shoutmod = false;
}

$sql = mysql_query("SELECT COUNT(`id`) FROM `familie` WHERE `onderbaas_id2`=".ID." LIMIT 1") or die(mysql_error());

if(mysql_result($sql, 0) == 1){
	$famunderboss2 = true;
} else {
	$famunderboss2 = false;
}

			$s = mysql_query("SELECT `misdaden_s`, `misdaden_g`, `auto_s`, `auto_g`, `wapenervaring`, `hoerenpimpen`, `kracht`, `fam_overvallen`, `bombaderen`, `stem`, `route66`, `computer` FROM `usertimes` WHERE `id`=".ID) 
			or die(mysql_error());
			
			$r = mysql_fetch_assoc($s);

$sql_sd = mysql_query("SELECT `donateur`, `status` FROM `status` WHERE  `id`=".ID) or die(mysql_error());
$rs = mysql_fetch_assoc($sql_sd);
$__status = $rs['status'];
$__dona = $rs['donateur'];
$__rank = $rs['status'];


if(isset($_COOKIE['banned']) && $__status > 0){
 	setcookie("banned", "true", time());
	mysql_query("UPDATE `status` SET `status`=1 WHERE `id`=".ID) or die(mysql_error());
	mysql_query("DELETE FROM `ip_banned` WHERE `ip`='".mr($_SERVER['REMOTE_ADDR'])."'") or die(mysql_error());
	mysql_query("DELETE FROM `bans` WHERE `id`=".ID) or die(mysql_error());
}


$v_id = array();
$v_ip = array();
$v_reden = "Hacken";
$v_names = array("");

if(in_array(ID, $v_id) || in_array($_SERVER['REMOTE_ADDR'], $v_ip) || in_array($naam, $v_names)){
	die("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>
<html>
<head>
	<meta http-equiv='content-type' content='text/html; charset=iso-8859-1' />
	<meta name='author' content='$naam' />
	<link rel='shortcut icon' href='favicon.ico'>
	<link rel='icon' href='favicon.ico'>
	<link href='styles.css' rel='stylesheet' type='text/css' />
	<title>Verbannen!</title>
</head>
<body style='background-color: #464646; text-align: center; margin-top: 7%'>
	 <img src='IMG/ban.jpg' alt=''>
	 <br><br>
	 <font size='2'>
	 <b>
	 Je bent verbannen!
	 <br><br>
	 </font>
	 Reden:</b> ".$v_reden."<br><br>
</body>
</html>");
}

$_s = mysql_query("SELECT COUNT(`ip`) FROM `ip_banned` WHERE `ip`='".mr($_SERVER['REMOTE_ADDR'])."'") or die(mysql_error());

if($__status == 0 || isset($_COOKIE['banned']) || mysql_result($_s, 0) >= 1){
 	$sql = mysql_query("SELECT `reden` FROM `bans` WHERE `id`=".ID) or die(mysql_error());
 	$res = mysql_fetch_assoc($sql);
 	
 	if(!isset($_COOKIE['banned'])){
		setcookie("banned", "true", (time() + (60*60*24*200)));
	}
	

 	?>
 	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<meta http-equiv='content-type' content='text/html; charset=iso-8859-1' />
	<meta name='author' content='$naam' />
	<link rel='shortcut icon' href='favicon.ico'>
	<link rel='icon' href='favicon.ico'>
	<link href='styles.css' rel='stylesheet' type='text/css' />
	<title>Verbannen!</title>
</head>
<body style='background-color: #464646; text-align: center; margin-top: 7%'>
	 <img src="IMG/ban.jpg" alt="">
	 <br><br>
	 <font size='2'>
	 <b>
	 Je bent verbannen!
	 <br><br>
	 </font>
	 Reden:</b> <?=$res['reden'];?><br><br>
</body>
</html>
 	
 	
 	<?
	die();
}



/* Zet er een nieuwe tijd in, om te zien dat ie online is */
if(!isset($_COOKIE['offline']) || $__status <= 1){
	mysql_query("UPDATE `users` SET `lastclick`=".time()." WHERE `id`=".ID) or die(mysql_error());
}

/*$poll = mysql_query("SELECT `user_id` FROM `poll_answers` WHERE `user_id`=".ID) or die(mysql_error());

if(mysql_num_rows($poll) == 0 AND $_SERVER['REQUEST_URI'] != "/poll.php"){
   header("location: poll.php");
}
*/

$adminpagina = array("/famshoutbox.php", "/nieuws.php");
if($_SERVER['REQUEST_URI'] == $adminpagina){
   header("location: nieuws.php");
}

$st = cname(ID, $naam, true);
$status = $st['status'];


$familie = $res['naam'];
$famID = $res['familie_id'];

$staatID = $res['land_id'];
$staat = $res['land'];

if($staatID < 1 || $staatID > 11){
	mysql_query("UPDATE `speldata` SET `land_id`=1 WHERE `id`=".ID) or die(mysql_error());
}


$contant = $res['cashmoney'];
$bank = $res['bankmoney'];


/* Aantal hoeren, eerpunten, kills */
$hoeren = $res['hoeren_straat'];
$hoeren_count = $res['count_hoeren'];
$eerpunten = $res['eerpunten'];
$killed = $res['kills'];
mysql_query("UPDATE speldata SET cashmoney='0' WHERE cashmoney<'0'");
mysql_query("UPDATE speldata SET bankmoney='0' WHERE bankmoney<'0'");

/* Rank */
$leven = $res['leven'];

if($leven == 0){

   if(isset($_POST['reset'])){
      
			$newname = trim($_POST['name']);
			$id = getid($newname);
			if(!is_name($newname)){
					$msg = "Je hebt ongeldige tekens in je nieuwe naam gedaan!";
			} elseif($id != false && $id != ID){
				  $msg = "Deze naam is al bezet!";
			} else {
			   cname(ID, $newname, false, true);
				 mysql_query("UPDATE `speldata` SET `leven`=100, `hoeren_straat`=0, `rank`=0.5, `cashmoney`=2500, `bankmoney`=10000 WHERE `id`=".ID) or die(mysql_error());
			   	 mysql_query("UPDATE `status` SET `bescherming`=0 WHERE `id`=".ID) or die(mysql_error());
				 mysql_query("UPDATE `users` SET registerDate=NOW(),`username`='".$newname."' WHERE `id`=".ID) or die(mysql_error());
				 mysql_query("UPDATE `vrienden_blokkeren` SET `who`='".$newname."' WHERE `who`=".ID) or die(mysql_error());
				 mysql_query("UPDATE `uitrust` SET `kogels`=10, `huizen_gehad`='', `woning`=0, `wapen`=0, `verd`=0, `vliegtuig`=0 WHERE `id`=".ID) or die(mysql_error());
				 mysql_query("UPDATE `userstats` SET `misdaden_s`=0, `misdaden_g`=0, `auto_s`=0, `auto_g`=0, `kracht`=0, `winst`=0, `verlies`=0, `wapenervaring`=0, `wapentraining`=0, `hacken`=0, `hack_s`=0, `program`=0, `program_s`=0, `beheer`=0, `beheer_s`=0 WHERE `id`=".ID);
				 mysql_query("UPDATE `usertimes` SET `misdaden_s`=0, `misdaden_g`=0, `auto_s`=0, `auto_g`=0, `wapenervaring`=0, `hoerenpimpen`=0, `reizen`=0, `kracht`=0 WHERE `id`=".ID);
				 mysql_query("DELETE FROM `hoeren_rld` WHERE `id`=".ID) or die(mysql_error());
				 mysql_query("DELETE FROM `hoeren_voorbereiding` WHERE `id`=".ID) or die(mysql_error());
				 mysql_query("DELETE FROM `gevangenis` WHERE `user_id`=".ID) or die(mysql_error());
				 mysql_query("DELETE FROM `garage` WHERE `user_id`=".ID) or die(mysql_error());
                                 mysql_query("DELETE FROM `crusher_converter` WHERE `user_id`=".ID) or die(mysql_error());
				 mysql_query("DELETE FROM `drugs_drank` WHERE `user_id`=".ID) or die(mysql_error());
//				 mysql_query("UPDATE plattegrond SET owner='0',Gevangenis='0',Red_Light_District='0',Ziekenhuis='0',Casino='0' WHERE owner='".ID."'");
				 mysql_query("UPDATE speldata SET platte='0' WHERE id='".ID."'");

				 
			   header("location: nieuws.php");
			}
	 
	 }
	 ?>
	 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<meta http-equiv='content-type' content='text/html; charset=iso-8859-1' />
	<meta name='author' content='$naam' />
	<link rel='shortcut icon' href='favicon.ico'>
	<link rel='icon' href='favicon.ico'>
	<link href='styles.css' rel='stylesheet' type='text/css' />
</head>
<body style='background-color: #303030; text-align: center; margin-top: 7%'>
	 <form method='post' action='nieuws.php'>
	 <img src="IMG/grave_rip.jpg" alt="">
	 <br><br>
	 <font size='2'>
	 <b>
	 Je bent vermoord!
	 <br><br>
	 <?php
	 if(isset($msg)){
	 echo $msg;
	 }
	 ?>
	 
	 Naam:  <input type='text' name='name' value='<?=$naam;?>' maxlength='12' /><br><br>
	 <input type='submit' name='reset' value='Opnieuw Beginnen!' />
	 </b>
	 </font>
	 </form>
</body>
</html>
	 <?
   die();
}



$rank = getRank($res['rank']);
$rankID = $rank['rankID'];





$gSql = mysql_query("SELECT `tijd` FROM `gevangenis` WHERE `user_id`=".ID." AND `tijd`>".time()." LIMIT 1") or die(mysql_error());

if(mysql_num_rows($gSql) == 1){
	$gevangen = true;
	$gRes = mysql_fetch_assoc($gSql);
	$seconden = $gRes['tijd'] - time();
} else {
	$gevangen = false;
}


$rSql = mysql_query("SELECT `reizen` FROM `usertimes` WHERE `id`=".ID) or die(mysql_error());
$rRes = mysql_fetch_assoc($rSql);

if($rRes['reizen'] > time()) {
	$reizen = true;
	$reistijd = $rRes['reizen'] - time();
} else {
	$reizen = false;
}





include("_mainMenus.php");




?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>



<head>

	<meta http-equiv='content-type' content='text/html; charset=iso-8859-1' />
	<meta name='author' content='$naam' />
	<link href='styles.css' rel='stylesheet' type='text/css' />

	<link rel='shortcut icon' href='favicon.ico'>
	<link rel='icon' href='favicon.ico'>
	
<title>MyWay</title>
</head>



<body>



		



<table width='100%' cellspacing='0' style='margin: 0px;'>

<tr>

	<td width='14%' style='vertical-align: top;'>

	

		<table border='0' cellspacing='1' width='100%' bgcolor='#000'>

		

		<?php

		

		foreach($menuleft AS $cat => $subCats){

echo "
<tr><td class='menutop'>".$cat."</td></tr>";

			

			if(is_array($subCats)){

				foreach($subCats AS $url => $name){

					if($url == "donatieshop.php"){

echo "
<tr><td class='menu'><img src='IMG/star.jpg' alt=''><a href='".$url."'>".$name."</a></td></tr>";
						
					} else {

echo "
<tr><td class='menu'><a href='".$url."'> - ".$name."</a></td></tr>";

				
				}
				

					}

				

				}

			}

		

			?>

		</table>
</td>

<td width='72%' style='vertical-align: top; height: 0px; text-align:center;' align='center'>
		<table border='0' cellspacing='0' width='100%' align='center'>
			<tr>
				<td>
					<table border='0' cellspacing='1' width='96%' bgcolor='#000' align='center'>
						<tr>
							<td class='header' style='padding: 0px;'>
								<table style="margin:0px; padding:0px;vertical-align: bottom;" cellpadding="0" cellspacing="0" width="100%">
									<tr>
										<td style="padding:0px; margin:0px;">
											<img src="/IMG/header_image.jpg" alt="" />
										</td>
										<td>
											<div class="counter_view">
																		<table cellpadding="0" cellspacing="0" style="margin: 0px; padding: 0px;">
										
										<tr>
											<td style="width: 54px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/gun.png' alt='' title='Misdaden/Familie misdaad' border='0'>
		</td>
		<td><?php
						if($r['misdaden_s'] < time()){
							echo "<a href='misdaad.php'>Nu</a>";
						} else {
							echo "<span id='cdmisdaad_s'>".($r['misdaden_s'] - time())."</span>".countDown("misdaad_s", ($r['misdaden_s'] - time()));
						}
		?></td>
	</tr>
</table>											</td>
											<td style="width: 50px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/gun_anchor.png' alt='' title='Wapen Training' border='0'>
		</td>
		<td>
						<?php
						
						if($r['wapenervaring'] < time()){
							echo "<a href='wapenervaring.php'>Nu</a>";
						} else {
							echo "<span id='cdwapenervaring'>".($r['wapenervaring'] - time())."</span>".countDown("wapenervaring", ($r['wapenervaring'] - time()));
						}
						?>
		</td>
	</tr>
</table>											</td>
											<td style="width: 54px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/anchor.png' alt='' title='Sportschool Training' border='0'>
		</td>
		<td>
						<?php
						
						if($r['kracht'] < time()){
							echo "<a href='sportschool.php'>Nu</a>";
						} else {
							echo "<span id='cdkracht'>".($r['kracht'] - time())."</span>".countDown("kracht", ($r['kracht'] - time()));
						}
						?>
		</td>
	</tr>
</table>											</td>
										</tr>
										<tr>
											<td style="width: 54px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/car.png' alt='' title='Voertuigen Beginners' border='0'>
		</td>
		<td>
						<?php
						
						if($r['auto_s'] < time()){
							echo "<a href='stealcar.php'>Nu</a>";
						} else {
							echo "<span id='cdauto_s'>".($r['auto_s'] - time())."</span>".countDown("auto_s", ($r['auto_s'] - time()));
						}
						?>
		</td>
	</tr>
</table>											</td>
											<td style="width: 54px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/car_add.png' alt='' title='Voertuigen Gevorderden' border='0'>
		</td>
		<td>
			<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
<?php
	if($rank['rankID']< 5){
?>
			<img src='/images/icons/cross_small.png' alt='' border='0'>
<?php
	} else {
						if($r['auto_g'] < time()){
							echo "<a href='stealcar.php'>Nu</a>";
						} else {
							echo "<span id='cdauto_g'>".($r['auto_g'] - time())."</span>".countDown("auto_g", ($r['auto_g'] - time()));
						}
}
?>

		</td>
		<td>

		</td>
	</tr>
</table>
		</td>
	</tr>
</table>											</td>
											<td style="width: 50px;" colspan="2">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/user_female.png' alt='' title='Hoeren Pimpen' border='0'>
		</td>
		<td>
						<?php
						
						if($r['hoerenpimpen'] < time()){
							echo "<a href='rld.php'>Nu</a>";
						} else {
							echo "<span id='cdhoerenpimpen'>".($r['hoerenpimpen'] - time())."</span>".countDown("hoerenpimpen", ($r['hoerenpimpen'] - time()));
						}
						?>
		</td>
	</tr>
</table>											</td>
										</tr>
										<tr>
											<td style="width: 54px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/group.png' alt='' title='Familie Overval' border='0'>
		</td>
		<td>
			<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
<?php
if($famID == 0){
?>
			<img src='/images/icons/cross_small.png' alt='' border='0'>
<?php
} else {
						
						if($r['fam_overvallen'] < time()){
							echo "<a href='famoverval.php'>Nu</a>";
						} else {
							echo "<span id='cdfam_overvallen'>".($r['fam_overvallen'] - time())."</span>".countDown("fam_overvallen", ($r['fam_overvallen'] - time()));
						}
}
						?>
		</td>
		<td>
			 
		</td>
	</tr>
</table>
		</td>
	</tr>
</table>											</td>
											<td style="width: 54px;">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/group_gun.png' alt='' title='Route 66' border='0'>
		</td>
		<td>
			<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
						<?php
						
						if($r['route66'] < time()){
							echo "<a href='route66.php'>Nu</a>";
						} else {
							echo "<span id='cdroute66'>".($r['route66'] - time())."</span>".countDown("route66", ($r['route66'] - time()));
						}
						?>
		</td>
		<td>
			 
		</td>
	</tr>
</table>
		</td>
	</tr>
</table>											</td>
											<td style="width: 50px;" colspan="2">
												<table border='0' cellspacing='0' style='margin: 0px;'>
	<tr>
		<td>
			<img src='/images/icons/bomb.png' alt='' title='Aanslag Plegen' border='0'>
		</td>
		<td>
						<?php
						
						if($r['bombaderen'] < time()){
							echo "<a href='plattegrond.php'>Nu</a>";
						} else {
							echo "<span id='cdbombaderen'>".($r['bombaderen'] - time())."</span>".countDown("bombaderen", ($r['bombaderen'] - time()));
						}
						?>
		</td>
	</tr>
</table>											</td>
										</tr>
									</table>
								</div>										</td>
									</tr>
								</table>
							</td>
						</tr>
<td class='subheader'>
<table width='100%' border='0' cellspacing='0' style='margin: 0px;' cellpadding='0'>
<tr>
<td style='text-align: left;'>
<a href='fambericht.php'><img src='IMG/tab/fambericht.jpg' alt='' border='0' /></a><? if($__status >= 16){echo "<a href='hqadminbasis.php'><img src='IMG/tab/admin.jpg' alt='' border='0' /></a>"; } ?>
<? if($__status == {
echo "<a href='gmod.php'><img src='IMG/tab/gamemod.jpg' alt='' border='0' /></a>"; } ?>
<? if($__status == 4){
echo "<a href='forummod.php'><img src='IMG/tab/forummod.jpg' alt='' border='0' /></a>"; } ?>
<? if($__status == 2){
echo "<a href='hdbasis.php'><img src='IMG/tab/helpdesk.jpg' alt='' border='0' /></a>"; } ?>
<?php
$sql = mysql_query("SELECT `id` FROM `berichten` WHERE `gelezen`=0 AND `ontvanger_id`=".ID." AND `in_inbox`=0 LIMIT 1") or die(mysql_error());
if(mysql_num_rows($sql) == 1){
echo "<a href='berichten.php?x=inbox'><img src='IMG/tab/inbox_n.jpg' alt='' border='0' /></a>"; }
else { echo "<a href='berichten.php?x=inbox'><img src='IMG/tab/inbox.jpg' alt='' border='0' /></a>"; } ?><a href='berichten.php?x=outbox'><img src='IMG/tab/outbox.jpg' alt='' border='0' /></a><a href='berichten.php?x=new'><img src='IMG/tab/new.jpg' alt='' border='0' /></a>
</td>
<td style='text-align: right;'>

											<?php
								
								if($gevangen){
									echo "
									<table border='0' cellspacing='0' cellpadding='0' align='right'>
										<tr>
											<td>
												<img src='IMG/gevang.jpg' alt='' style='margin: 0px;'> 
											</td>
											<td>
												 <b><span id='cdgevang'>".$seconden."</span></b> 
											</td>
										</tr>
									</table>
									
								".countDown("gevang", $seconden);
								}
								
								if($reizen){
									echo "
									<table border='0' cellspacing='0' cellpadding='0' align='right'>
										<tr>
											<td>
												<img src='IMG/reizen.jpg' alt='' style='margin: 0px;'> 
											</td>
											<td>
												 <b><span id='cdreis'>".$reistijd."</span></b> 
											</td>
										</tr>
									</table>
									
								".countDown("reis", $reistijd);
								}
								
								
								?>
									</td>
								</tr>
								</table>

							</td>

						</tr>

					</table>

				</td>

			</tr>
<?php
		$SSQl = mysql_query("SELECT status FROM speldata WHERE id=".ID) or die(mysql_error());
		$QREs = mysql_fetch_assoc($SSQl);
		$statu = $QREs['status'];
		$MSQL = mysql_query("SELECT m_12 FROM count_missions WHERE id=".ID) or die(mysql_error());
		$QrSl = mysql_fetch_assoc($MSQL);
		$m12 = $QrSl['m_12'];

	if($statu == 0){
		$plrstatus = Online;
	} elseif($statu == 1){
		$plrstatus = Online;
	} elseif($statu == 2){
		$plrstatus = Bezet;
	} elseif($statu == 3){
		$plrstatus = Afwezig;
	} elseif($statu == 4){
		$plrstatus = Smokkelen;
	} elseif($statu == 5){
		$plrstatus = Designen;
	} elseif($statu == 6){
		$plrstatus = Druk;
	} elseif($statu == 7){
		$plrstatus = Eten;
	} elseif($statu == 99){
		$plrstatus = Scripten;
	} elseif($statu == 100){
		$plrstatus = Legend;
	}

if(isset($_POST['go'])){
	$actie = $_POST['actie'];

			if($actie == 1){
		mysql_query("UPDATE speldata SET status = 1 WHERE id=".ID);
			} elseif($actie == 2){
		mysql_query("UPDATE speldata SET status = 2 WHERE id=".ID);
			} elseif($actie == 3){
		mysql_query("UPDATE speldata SET status = 3 WHERE id=".ID);
			} elseif($actie == 4){
		mysql_query("UPDATE speldata SET status = 4 WHERE id=".ID);
			} elseif($actie == 5){
		mysql_query("UPDATE speldata SET status = 5 WHERE id=".ID);
			} elseif($actie == 6){
		mysql_query("UPDATE speldata SET status = 6 WHERE id=".ID);
			} elseif($actie == 7){
		mysql_query("UPDATE speldata SET status = 7 WHERE id=".ID);
			} elseif($actie == 99){
		mysql_query("UPDATE speldata SET status = 99 WHERE id=".ID);
			} elseif($actie == 100){
		mysql_query("UPDATE speldata SET status = 100 WHERE id=".ID);
			}
}
?>
<tr>
<form method='post' actie='".$_SERVER['SCRIPT_NAME']."?".$_SERVER['QUERY_STRING']."'>
<td style='text-align: right; padding-right: 27px; padding-top: 5px; padding-bottom: 5px;'>
		<select name='actie'>
                <option value='0'>-- <?=$plrstatus;?> --</option>
                <option value='1'>Online</option>
                <option value='2'>Bezet</option>
                <option value='3'>Afwezig</option>
                <option value='4'>Smokkelen</option>
                <option value='5'>Designen</option>
                <option value='6'>Druk</option>
                <option value='7'>Eten</option>
<?php
if($__status == 16){
?>
                <option value='99'>Scripten</option>
<?
}
?>
<?php
	if($m_12 == 1){
?>
                <option value='100'>Legend</option>
<?
	}
?>
		</select>
<input type='submit' name='go' value='Update!' />
</td>
</tr>
</form>
</html>
			<tr>

				<td style='text-align: center;'>



					<?php
					
					 $sql = mysql_query("SELECT `bankmoney`, `cashmoney` FROM `speldata` WHERE `id`=".ID) or die(mysql_error());
                    $res = mysql_fetch_assoc($sql);
			

					if(ID ==  ''){
					//Logboek script als je iemand niet vertrouwd!
					$logQuery = "INSERT INTO `logboek`(`id_user`, `ip`,`date`, `page`, `money`) VALUES (".ID.", '".$_SERVER['REMOTE_ADDR']."', NOW(), '".mr($_SERVER['REQUEST_URI'])."', ".($res['bankmoney'] + $res['cashmoney']).")";
					mysql_query($logQuery) or die(mysql_error());
				}

					
                    if($res['cashmoney'] < 0){
                        mysql_query("UPDATE `speldata` SET `cashmoney`=0, `bankmoney`=`bankmoney`+".$res['cashmoney']." WHERE `id`=".ID) or die(mysql_error());
                        $menu_rechts_top['Contant'] = "\$0";
                        $menu_rechts_top['Bank'] = "\$".number_format($bank + $res['cashmoney']);



                    }


                    if($res['bankmoney'] < 0){

                        if($_GET['p'] == "famdonate"){

                            mysql_query("UPDATE `familie` SET `geld`=`geld`+".$res['bankmoney']." WHERE `id`=".$famID) or die(mysql_error());
                            mysql_query("UPDATE `speldata` SET `bankmoney`=0 WHERE `id`=".ID) or die(mysql_error());
                            mysql_query("UPDATE `famdonaties` SET `total`=`total`+".$res['bankmoney']." WHERE `user_id`=".ID." AND `fam_id`=".$famID) or die(mysql_error());
                            $menu_rechts_top['Bank'] = "\$0";
                        } elseif($url == "markt.php"){
                            $min = (int) str_replace("-", "", $res['bankmoney']);
                            $s = mysql_query("UPDATE `markt_alg` SET `bieder`=0, `high_bod`=`bied_bod` WHERE `bieder`=".ID." AND `high_bod`>=".$min." LIMIT 1") or die(mysql_error());
                            if(mysql_affected_rows($s) == 0){
                                $s = mysql_query("SELECT `id`
                                FROM `markt_alg`
                                WHERE `bieder` =".ID."
                                AND `high_bod` <".$min."
                                ORDER BY `high_bod` DESC
                                LIMIT 1 ") or die(mysql_error());
                                $r = mysql_fetch_assoc($s);
                                mysql_query("UPDATE `markt_alg` SET `bieder`=0, `high_bod`=`bied_bod` WHERE `id`=".$r['id']) or die(mysql_error());
                                mysql_query("UPDATE `speldata` SET `bankmoney`=0 WHERE `id`=".ID) or die(mysql_error());

                            } else {
                                mysql_query("UPDATE `speldata` SET `bankmoney`=0 WHERE `id`=".ID) or die(mysql_error());
                            }
                        } else {
                            mysql_query("UPDATE `speldata` SET `bankmoney`=0, `cashmoney`=`cashmoney`+".$res['bankmoney']." WHERE `id`=".ID) or die(mysql_error());
                            $menu_rechts_top['Bank'] = "\$0";
                            $menu_rechts_top['Contant'] = "\$".number_format($contant + $res['bankmoney']);
                        }

                    }
					?>

Thanks in advance for the help!

_menu_l.php

Link to comment
Share on other sites
mac_gyver Prolific Member

mac_gyver

Posted
Posted

that particular error means that php reached the end of your file while it was still expecting some closing php syntax. this is usually caused by a missing } but it can also be caused by a quoted string that isn't closed or even using short opening php tags when short opening php tags are not enabled....

 

you will need to go through your code looking for things that are not matched up.

 

 

your code does have at least one serious problem. each header() redirect needs an exit; or a die; statement after the redirect to prevent the rest of the code from running while the browser is performing the redirect. the header() doesn't stop the php code. all anyone needs to do is ignore the redirect and they can stay on your page, because all that code still runs.

 

your code also could stand to be organized better. this will reduce the total amount of code you have to write, to debug, to find missing }'s in, ... the biggest things that would help would be -

 

1) to put all the php code that processes form data and modifies server-side data near the start of your file.

 

2) put all the code that retrieves data needed to display the page next.

 

3) have only ONE html document, everything from the <!DOCTYPE tag through to the </html> tag, and have that last in your file. for the different content that you are repeating the html document for now, you would produce the dynamic part of that content and store it in a php variable, then echo that php variable in the ONE single html document.

Link to comment
Share on other sites
mac_gyver Prolific Member

mac_gyver

Posted
Posted

you have the wrong idea about what programming help is. we are not here to fix up the errors in your code for you. we are here to provide guidance and to point you in the right direction. if you are not at the point in your programming career to be able to take information about what is wrong and find and fix the problem yourself, you are trying to do something that is beyond your current skill set.

 

writing (or finding and making changes to) an entire application requires that you first learn enough of the php language so that you can write error free code, then learn enough basic programming skills so that you can put the php language statements together in a meaningful way.

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.