bezit.php

Time 4 Crime online

?>
<TR>
    <TD class=mainTxt>Den Haag</TD>
    <TD class=mainTxt><? echo $aantal5; ?></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal->owner}"><? echo $aantal->owner; ?></A></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal1->owner}"><? echo $aantal1->owner; ?></A></TD>
    <TD class=mainTxt>$<? echo $aantal1->price; ?></TD>
    <TD class=mainTxt><? echo $aantal2->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal3->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal4->owner; ?></TD>
</TR>
<?
    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Rotterdam' AND `type`='trainstation'");
    $aantal = mysql_fetch_object($select);
$aantal->owner = ($aantal->owner == "unowned") ? "<b><a href=\"take.php?t=trainstation&c=Illinois\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal->owner}\">$aantal->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Rotterdam' AND `type`='bulletfactory'");
    $aantal1 = mysql_fetch_object($select);
$aantal1->owner = ($aantal1->owner == "unowned") ? "<b><a href=\"take.php?t=bulletfactory&c=Illinois\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal1->owner}\">$aantal1->owner</a>";
$aantal1->owner = ($aantal1->owner == " ") ? "<b>State Owned</b>" : "$aantal1->owner";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Rotterdam' AND `type`='roulette'");
    $aantal2 = mysql_fetch_object($select);
$aantal2->owner = ($aantal2->owner == "unowned") ? "<b><a href=\"take.php?t=roulette&c=Illinois\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal2->owner}\">$aantal2->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Rotterdam' AND `type`='slot'");
    $aantal3 = mysql_fetch_object($select);
$aantal3->owner = ($aantal3->owner == "unowned") ? "<b><a href=\"take.php?t=slot&c=Illinois\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal3->owner}\">$aantal3->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Rotterdam' AND `type`='racetrack'");
    $aantal4 = mysql_fetch_object($select);
$aantal4->owner = ($aantal4->owner == "unowned") ? "<b><a href=\"take.php?t=racetrack&c=Illinois\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal4->owner}\">$aantal4->owner</a>";

    $select = mysql_query("SELECT * FROM `[users]` WHERE `City`='Rotterdam' AND `activated`='1' AND `health`>'0' AND `level`>'0'");
    $aantal5 = mysql_num_rows($select);
?>
<TR>
    <TD class=mainTxt>Rotterdam</TD>
    <TD class=mainTxt><? echo $aantal5; ?></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal->owner}"><? echo $aantal->owner; ?></A></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal1->owner}"><? echo $aantal1->owner; ?></A></TD>
    <TD class=mainTxt>$<? echo $aantal1->price; ?></TD>
    <TD class=mainTxt><? echo $aantal2->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal3->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal4->owner; ?></TD>
</TR>
<?PHP
    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Bergen op Zoom' AND `type`='trainstation'");
    $aantal = mysql_fetch_object($select);
$aantal->owner = ($aantal->owner == "unowned") ? "<b><a href=\"take.php?t=trainstation&c=Louisiana\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal->owner}\">$aantal->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Bergen op Zoom' AND `type`='bulletfactory'");
    $aantal1 = mysql_fetch_object($select);
$aantal1->owner = ($aantal1->owner == "unowned") ? "<b><a href=\"take.php?t=bulletfactory&c=Louisiana\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal1->owner}\">$aantal1->owner</a>";
$aantal1->owner = ($aantal1->owner == " ") ? "<b>State Owned</b>" : "$aantal1->owner";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Bergen op Zoom' AND `type`='roulette'");
    $aantal2 = mysql_fetch_object($select);
$aantal2->owner = ($aantal2->owner == "unowned") ? "<b><a href=\"take.php?t=roulette&c=Louisiana\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal2->owner}\">$aantal2->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Bergen op Zoom' AND `type`='slot'");
    $aantal3 = mysql_fetch_object($select);
$aantal3->owner = ($aantal3->owner == "unowned") ? "<b><a href=\"take.php?t=slot&c=Louisiana\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal3->owner}\">$aantal3->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Bergen op Zoom' AND `type`='racetrack'");
    $aantal4 = mysql_fetch_object($select);
$aantal4->owner = ($aantal4->owner == "unowned") ? "<b><a href=\"take.php?t=racetrack&c=Louisiana\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal4->owner}\">$aantal4->owner</a>";

    $select = mysql_query("SELECT `id` FROM `[users]` WHERE `City`='Bergen op Zoom' AND `activated`='1' AND `health`>'0' AND `level`>'0'");
    $aantal5 = mysql_num_rows($select);
?>
<TR>
    <TD class=mainTxt>Bergen op Zoom</TD>
    <TD class=mainTxt><? echo $aantal5; ?></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal->owner}"><? echo $aantal->owner; ?></A></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal1->owner}"><? echo $aantal1->owner; ?></A></TD>
    <TD class=mainTxt>$<? echo $aantal1->price; ?></TD>
    <TD class=mainTxt><? echo $aantal2->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal3->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal4->owner; ?></TD>
</TR>
<?PHP
    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Venlo' AND `type`='trainstation'");
    $aantal = mysql_fetch_object($select);
$aantal->owner = ($aantal->owner == "unowned") ? "<b><a href=\"take.php?t=trainstation&c=Pennsylvania\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal->owner}\">$aantal->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Venlo' AND `type`='bulletfactory'");
    $aantal1 = mysql_fetch_object($select);
$aantal1->owner = ($aantal1->owner == "unowned") ? "<b><a href=\"take.php?t=bulletfactory&c=Pennsylvania\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal1->owner}\">$aantal1->owner</a>";
$aantal1->owner = ($aantal1->owner == " ") ? "<b>State Owned</b>" : "$aantal1->owner";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Venlo' AND `type`='roulette'");
    $aantal2 = mysql_fetch_object($select);
$aantal2->owner = ($aantal2->owner == "unowned") ? "<b><a href=\"take.php?t=roulette&c=Pennsylvania\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal2->owner}\">$aantal2->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Venlo' AND `type`='slot'");
    $aantal3 = mysql_fetch_object($select);
$aantal3->owner = ($aantal3->owner == "unowned") ? "<b><a href=\"take.php?t=slot&c=Pennsylvania\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal3->owner}\">$aantal3->owner</a>";

    $select = mysql_query("SELECT * FROM `[buildings]` WHERE `City`='Venlo' AND `type`='racetrack'");
    $aantal4 = mysql_fetch_object($select);
$aantal4->owner = ($aantal4->owner == "unowned") ? "<b><a href=\"take.php?t=racetrack&c=Pennsylvania\">Take Over!</a></b>" : "<a href=\"profile.php?x={$aantal4->owner}\">$aantal4->owner</a>";

    $select = mysql_query("SELECT * FROM `[users]` WHERE `City`='Venlo' AND `activated`='1' AND `health`>'0' AND `level`>'0'");
    $aantal5 = mysql_num_rows($select);
?>
<TR>
    <TD class=mainTxt>Venlo</TD>
    <TD class=mainTxt><? echo $aantal5; ?></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal->owner}"><? echo $aantal->owner; ?></A></TD>
    <TD class=mainTxt><A href="profile.php?x={$aantal1->owner}"><? echo $aantal1->owner; ?></A></TD>
    <TD class=mainTxt>$<? echo $aantal1->price; ?></TD>
    <TD class=mainTxt><? echo $aantal2->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal3->owner; ?></TD>
    <TD class=mainTxt><? echo $aantal4->owner; ?></TD>
</TR>
</table></center>
</body>

</html>