<?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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</p>

<p>&nbsp;</p>

<p>

<p>&nbsp; </p>

</body>

</html>