Land Listing

*=Our Bonus Programs automatically reduce your effective Tier, the longer you stay and the more land you own. No subscription needed, all Bonuses apply automatically when you qualify for them.

**=Our Properties offer you more prims than a standard parcel of this size would allow. Because this parcel has a primbonus, it is equivalent to a parcel with the shown sqm. Keep this in mind when comparing prices.

*=Our Bonus Programs automatically reduce your effective Tier, the longer you stay and the more land you own. No subscription needed, all Bonuses apply automatically when you qualify for them.

**=Our Properties offer you more prims than a standard parcel of this size would allow. Because this parcel has a primbonus, it is equivalent to a parcel with the shown sqm. Keep this in mind when comparing prices.

<?php
// Load Global variables and settings
include (“../settings.php”);

$db = @mysql_connect($sqlhost, $sqlusername, $sqlpassword);
@mysql_select_db($sqldatabase) or die(“Unable to select database.”);

$query = “SELECT property.propertyID, property.area AS Area, property.maxPrims AS Prims, property.location as Slurl, regions.name AS Region, propertytype.propertytype AS Type, categories.name AS Category ,ROUND(IF(property.purchase>0,property.purchase,IF(categories.priceFix>0,categories.priceFix,property.area*categories.priceSqm*regions.bonus)))AS Purchase, ROUND(IF(property.tierFix>0,property.tierFix,property.maxPrims*categories.tierPrimWeek)) AS Tier FROM property
INNER JOIN regions ON regions.regionID = property.regionID
INNER JOIN propertyType ON propertyType.propertyTypeID = property.propertyTypeID
INNER JOIN categories ON categories.categoryID = property.categoryID WHERE property.status = ‘2′ AND (categories.categoryID = 1 OR categories.categoryID = 4) ORDER BY Area”;
$result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_num_rows($result);
if($num_rows == 0)
{
// There are no parcels available
echo(‘<tr><td colspan=6><p>We are sorry, but there are currently no parcels available. Please contact our <a href=”http://www.lionheartsl.com/index.php/support-and-contact/sales-request/”>Sales Team</a> and ask for a notification on new parcel releases.</p></td></tr>’);
}
elseif($num_rows != 0)
{
// Loop through each result (parcel) pulled from the database and create a table row out of it.
echo (‘
<table align=”center” border=”0″ cellpadding=”2″ cellspacing=”1″ width=”100%” class=”parcelTable”>
<tr bgcolor=”#839cc4″>
<td align=”left”><strong>Zoning<br />Image</strong><br /><div style=”font-size:11px;”>Click to enlarge</div></td>
<td align=”left”><strong>Area<br />Prims<br />Tier<br /></strong></td>
<td align=”left”><strong>Region<br />Type<br />Teleport</strong></td>

</tr>
‘);
for ($i = 0; $i < mysql_num_rows($result); $i++)

{

$row = mysql_fetch_assoc($result); // Put the result for this parcel into an associative array
// Output the actual table row here. Move the $row[fieldName] entries around as needed to format the row.
echo(
‘
<tr align=”center” valign=”center”>
<td align=”center”>’. $row[Category] .’<br /><a title=”‘.$row[Region].’ | ‘.$row[Type].’ | ‘.$row[Area].’ sqm | ‘.$row[Prims].’ Prims | Tier ‘.$row[Tier].’L$/week” href=”http://images.lionheartsl.com/properties/’.$row[propertyID].’.png” rel=”lightbox[Residential]“><img src=”http://images.lionheartsl.com/properties/’.$row[propertyID].’.png” width=”80″ height=”30″></a></td>
<td align=”left”>’ . $row[Area] . ‘ m&sup2;<br />
‘ . $row[Prims] . ‘ Prims<br />
L$’ . $row[Tier] . ‘/week
</td>
<td align=”left”>’. $row[Region].’<br />
‘ . $row[Type] . ‘<br />
<a href=”‘.$row[Slurl].’”>Slurl Map</a>
</td>

</tr>
‘);
}
mysql_close($db); // Close the database connection
// End of php and then end of document
echo(“</table>”);
}
?>