Location: PHPKode > projects > Simuland > world/location/changeland/3.inc
<p>this is the default section which will list all the types of buildings avaible</p>
<p>commerce (type 3)<br>
  list types<br>
  in sub sections add a check for building above current level of player
//get info of user to check for level
$userms = mysql_query("SELECT * FROM usr WHERE usr='$user'");
$userm = mysql_fetch_array($userms);
$typem = mysql_query("SELECT * FROM buildingtype WHERE type='$btype'");
<table width="600" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000">
  <tr align="center"> 
    <td width="37">ID</td>
    <td width="251">Name</td>
    <td width="106">Level Required</td>
    <td width="96">Cost</td>
    <td width="96">Build?</td>
while ($type = mysql_fetch_array($typem)){
  <tr align="center"> 
    <td width="37"><?echo $type[0];?></td>
    <td width="251"><?echo $type[2];?></td>
    <td width="106"><?echo $type[6];?></td>
    <td width="96">$<?echo $type[7];?></td>
    <td width="96"><a href="/world/location/changeland2.php?&town=<?echo $town;?>&vert=<?echo $vert;?>&horz=<?echo $horz;?>&btype=<?echo $type[0];?>">Build 
Return current item: Simuland