rendered paste body<?php
session_start();
include_once "includes/db_connect.php";
include_once "includes/functions.php";
$username=$_SESSION['username'];
$mysql=mysql_query("SELECT * FROM users WHERE username='$username'");
$fetch=mysql_fetch_object($mysql);
$username=$_SESSION['username'];
$grab = strip_tags($_GET['grab']);
$location=strip_tags($_GET['location']);
if (($grab == "ammo") || ($grab == "Airport") || ($grab == "bank") || ($grab == "casinos") || ($grab == "roulette") || ($grab == "Dealership") || ($grab == "Restu")|| ($grab == "bar")|| ($grab == "shop")){
if ($grab == "ammo"){
$check = mysql_query("SELECT * FROM bf WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE bf SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the ammo hut!";
}}}
elseif ($grab == "bar"){
$check = mysql_query("SELECT * FROM bar WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE bar SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the bar!";
}}}
elseif ($grab == "Airport"){
$check = mysql_query("SELECT * FROM airport WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE airport SET owner='$username', profit='0-0-0-0-0-0' WHERE location='$fetch->location'");
echo "You got the Airport!";
}}}
elseif ($grab == "bank"){
$check = mysql_query("SELECT * FROM bank WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE bank SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the bank!";
}}}
elseif ($grab == "shop"){
$check = mysql_query("SELECT * FROM shop WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE shop SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the shop!";
}}}
if ($grab == "Restu"){
$check = mysql_query("SELECT * FROM rest WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE rest SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the Resturant!";
}}}
if ($grab == "Dealership"){
$check = mysql_query("SELECT * FROM dealership WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE dealership SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the Dealership!";
}}}
////START casinoS
elseif ($grab == "casinos"){
$the_get=$_GET['casino'];
if ($the_get == "Slots" || $the_get == "RPS" || $the_get=="Race"){
$check = mysql_query("SELECT * FROM casinos WHERE owner= '0' AND location='$fetch->location' AND casino='$the_get'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE casinos SET owner='$username', profit='0' WHERE location='$fetch->location' AND casino='$the_get'");
echo "You got the casino!";
}}}}
//////END casinoS
elseif ($grab == "Dealership"){
$check = mysql_query("SELECT * FROM rest WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE dealership SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the Dealership!";
}}}
elseif ($grab == "Restu"){
$check = mysql_query("SELECT * FROM rest WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE rest SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the Restaurant!";
}}}
elseif ($grab == "bank"){
$check = mysql_query("SELECT * FROM bank WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE bank SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the bank!";
}}}
elseif ($grab == "shop"){
$check = mysql_query("SELECT * FROM shop WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE shop SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the shop!";
}}}
elseif ($grab == "roulette"){
$check = mysql_query("SELECT * FROM roulette WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE roulette SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the roulette!";
}}}
elseif ($grab == "bar"){
$check = mysql_query("SELECT * FROM bar WHERE owner= '0' AND location='$fetch->location'");
$num_rows = mysql_num_rows($check);
if ($num_rows != "0"){
if ($fetch->location == $location){
mysql_query("UPDATE bar SET owner='$username', profit='0' WHERE location='$fetch->location'");
echo "You got the bar!";
}}
}
}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style15 {color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; }
.style16 {color: #000000}
.style17 {color: #333333}
.style21 {font-weight: bold; font-size: 12px; font-family: Arial, Helvetica, sans-serif;}
.style22 {color: #FFFFFF}
-->
</style>
</head>
<body>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('United Kingdom');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$roulette = mysql_fetch_object(mysql_query("SELECT * FROM roulette WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Japan');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr bgcolor="#999999" >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#ECE9D8 class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style17">Type</div></td>
<td width="152" class=tip><div align="center" class="style17">Owner </div></td>
<td width="142" class=tip><div align="center" class="style17">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('France');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Usa');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">casino</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino->owner == "0"){ echo "No owner-<a href='?grab=casino&location=$locations[$i]&casino'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino->owner'>$casino->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('China');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr bgcolor="#FFFFFF" >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center" class="style16"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('NorthPole');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">casino</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino->owner == "0"){ echo "No owner-<a href='?grab=casino&location=$locations[$i]&casino'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino->owner'>$casino->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Canada');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Argenitna');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Hampton Land');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center" class="style22"><span class="style21">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center" class="style22"><span class="style21"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center" class="style22"><span class="style21">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center" class="style22"><span class="style21">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Thailand');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('Africa');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<table width="499" height="372" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#000000" bgcolor="#999999">
<!--DWLayoutTable-->
<?php
$locations = array('SouthPole');
$i = 0;
$count = count($locations);
while ($i < $count){
if ($i == "0"){ echo "<tr>"; }
$airport = mysql_fetch_object(mysql_query("SELECT * FROM airport WHERE location='$locations[$i]'"));
$ammo_hut = mysql_fetch_object(mysql_query("SELECT * FROM bf WHERE location='$locations[$i]'"));
$bank = mysql_fetch_object(mysql_query("SELECT * FROM bank WHERE location='$locations[$i]'"));
$casino = mysql_fetch_object(mysql_query("SELECT * FROM casino WHERE location='$locations[$i]'"));
$people_in = mysql_num_rows(mysql_query("SELECT * FROM users WHERE location='$locations[$i]'"));
$resturant = mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$dealership=mysql_fetch_object(mysql_query("SELECT * FROM dealership WHERE location='$locations[$i]'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_slots = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Slots'"));
$rest=mysql_fetch_object(mysql_query("SELECT * FROM rest WHERE location='$locations[$i]'"));
$casino_rps = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='RPS'"));
$casino_race = mysql_fetch_object(mysql_query("SELECT * FROM casinos WHERE location='$locations[$i]' AND casino='Race'"));
$bar = mysql_fetch_object(mysql_query("SELECT * FROM bar WHERE location='$locations[$i]'"));
$shop = mysql_fetch_object(mysql_query("SELECT * FROM shop WHERE location='$locations[$i]'"));
?>
<td width="499" >
<table width="100%" height="304" border="1" cellpadding="1" cellspacing="0" bordercolor="black" class=thinline>
<!--DWLayoutTable-->
<tr >
<td height="27" colspan="3" valign="top" background="includes/grad.jpg"> <div align="center"><?php echo "<center>$locations[$i]</center>"; ?></div></td>
</tr>
<tr bgcolor=#FFFFFF class="style15">
<td width="186" height="9" valign="top" class=tip><div align="center" class="style16">Type</div></td>
<td width="152" class=tip><div align="center" class="style16">Owner </div></td>
<td width="142" class=tip><div align="center" class="style16">Max bet </div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Restaurant</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($rest->owner == "0"){ echo "No owner-<a href='?grab=Restu&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$rest->owner'>$rest->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bank</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($bank->owner == "0"){ echo "No owner-<a href='?grab=bank&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bank->owner'>$bank->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Underground</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($shop->owner == "0"){ echo "No owner-<a href='?grab=shop&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$shop->owner'>$shop->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top" class="style15">Bar</td>
<td>
<div align="center"><span class="style15">
<?php if ($bar->owner == "0"){ echo "No owner-<a href='?grab=bar&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$bar->owner'>$bar->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Dealership</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($dealership->owner == "0"){ echo "No owner-<a href='?grab=Dealership&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$dealership->owner'>$dealership->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Airport</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($airport->owner == "0"){ echo "No owner-<a href='?grab=Airport&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$airport->owner'>$airport->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15">N/A</span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Slots</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_slots->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Slots'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_slots->owner'>$casino_slots->owner</a>"; } ?>
</span> </div></td>
<td width="142"><div align="center"><span class="style15"><? echo "£".makecomma($casino_slots->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">RPS</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_rps->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=RPS'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_rps->owner'>$casino_rps->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_rps->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">roulette</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($roulette->owner == "0"){ echo "No owner-<a href='?grab=roulette&location=$locations[$i]&roulette'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$roulette->owner'>$roulette->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($roulette->maxbet).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Race track</span></td>
<td width="152">
<div align="center"><span class="style15">
<?php if ($casino_race->owner == "0"){ echo "No owner-<a href='?grab=casinos&location=$locations[$i]&casino=Race'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$casino_race->owner'>$casino_race->owner</a>"; } ?>
</span> </div></td>
<td width="142"> <div align="center"><span class="style15"><? echo "£".makecomma($casino_race->max).""; ?></span></div></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="10" valign="top"><span class="style15">Bullet Factory</span></td>
<td>
<div align="center"><span class="style15">
<?php if ($ammo_hut->owner == "0"){ echo "No owner-<a href='?grab=ammo&location=$locations[$i]'>Grab it</a>"; }else{ echo "<a href='profile.php?viewuser=$ammo_hut->owner'>$ammo_hut->owner</a>"; } ?>
</span> </div></td>
<td><div align="center"><span class="style15">N/A</span></div></td>
</tr>
</table></td>
<?php
if ($i == "3"){ echo "</tr>"; }
$i++; } ?>
</table>
<p> </p>
<p> </p>
<p>
<p> </p>
</body>
</html>