• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

PHP domki

Blizny

Blizny

New Member
Joined
Jun 26, 2012
Messages
107
Reaction score
2
Location
Poland / Bydgoszcz
Witam może mi ktoś powiedzieć dlaczego sortuje mi domki w odrwortnej kolejności czyli jak biore by name to leci od z-a a nie od a-z tak samo z cenna + do - najwiecej i najmniej :P nie rozumiem

Code: 
<?PHP
##-- world --##
{
$world_id = 0;
}
##-- town --##
$houses_town = (int) $_POST['town'];
if(count($towns_houses[$world_id]) > 0)
{
foreach($towns_houses[$world_id] as $town_ids => $town_names)
{
if($town_ids == $houses_town)
{
$town_id = $town_ids;
$town_name = $town_names;
}
}
}
##-- owner --##
$houses_owner = (int) $_POST['owner'];
if($houses_owner == 0)
{
$owner_sql = '';
}
elseif($houses_owner == 1)
{
$owner_sql = ' AND owner = 0';
}
elseif($houses_owner == 2)
{
$owner_sql = ' AND owner > 0';
}
##-- order --##
$houses_order = (int) $_POST['order'];
if($houses_order == 0)
{
$order_sql = 'name';
}
elseif($houses_order == 1)
{
$order_sql = 'size';
}
elseif($houses_order == 2)
{
$order_sql = 'rent';
}


##-- List Houses --##
$id = (int) $_GET['show'];
if(empty($id))
{
$main_content.='
';
if($houses_town > 0)
{
$main_content .= '<table border=0 cellspacing=1 cellpadding=4 width=100%>
<tr bgcolor="'.$config['site']['vdarkborder'].'" class=white>
<td colspan=5><b>Available '.$status_name.' in '.$town_name.' on '.$world_name.'</b></td>
</tr>
<tr bgcolor="'.$config['site']['darkborder'].'">
<td width=24%><b>Name</b></td><td width=11%><b>Size</b></td><td width=15%><b>Rent</b></td><td width=30%><b>Status</b></td><td width=20%></td>
</tr>';
$houses_sql = $SQL->query('SELECT * FROM houses WHERE world_id = '.$world_id.' AND town = '.$town_id.''.$owner_sql.''.$status_sql.' ORDER BY '.$order_sql.' DESC')->fetchAll();
$counter = 0;
foreach($houses_sql as $house)
{
if(is_int($counter / 2))
$bgcolor = $config['site']['lightborder'];
else
$bgcolor = $config['site']['darkborder'];
$counter++;
if($house['owner'] == 0)
{
$owner = 'Empty';
}
elseif($house['owner'] > 0)
{
$player = $ots->createObject('Player');
$player->load($house['owner']);
$owner = 'Rented by <a href="?subtopic=characters&name='.urlencode($player->getName()).'">'.$player->getName().'</a>';
}
$main_content .= '<tr bgcolor="'.$bgcolor.'">
<td>'.$house['name'].'</td>
<td>'.$house['size'].' sqm</td>
<td>'.$house['rent'].' gold</td>
<td>'.$owner.'</td>
<td><a href="index.php?menu=domy&show='.$house['id'].'"><image src="'.$layout_name.'/images/buttons/sbutton_view.gif"</a></td>
</tr>';
}
$main_content .= '</table><br>';
}
$main_content.='
<form action="/domy" method="post"/>
<table border="1" cellpadding="0" cellspacing="0" width="100%"/><tr bgcolor="black"/><td>
<table border="0" cellpadding="0" cellspacing="0" width="100%"/><tr bgcolor="black"/>
<td width="100%" align="center"/>
<font color="silver" size="2px"/><b>Domy</b></font></td>
</tr></table></td></tr></table>


<table border="1" cellpadding="0" cellspacing="0" width="100%"/><tr bgcolor="black"/><td>
<table border="0" cellpadding="0" cellspacing="0" width="100%"/><tr bgcolor="black"/>








';
$main_content.='
<td width="33%" align="center"/><font face="Trebuchet MS" size="2px"/><b>Miasto</b></font></td>
<td width="33%" align="center"/><font face="Trebuchet MS" size="2px"/><b>Opcje</b></font></td>
<td width="33%" align="center"/><font face="Trebuchet MS" size="2px"/><b>Opcje zaawansowane</b></font></td>
</tr>

<tr bgcolor="black"/>
';




$main_content.='<td valign=top rowspan=2>';
foreach($towns_houses[$world_id] as $id => $town_n)
{
$main_content.='<input type="radio" name="town" value="'.$id.'" ';
if($houses_town == $id)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>'.$town_n.'</b></font><br>';
}
$main_content.='</td>
<td valign=top>
<input type="radio" name="owner" value="0" ';
if($houses_owner == 0)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>Wszystkie</b></font><br>
<input type="radio" name="owner" value="1" ';
if($houses_owner == 1)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>Wolne</b></font><br>
<input type="radio" name="owner" value="2" ';
if($houses_owner == 2)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>Zajęte</b></font><br>
</td>
<td valign=top rowspan=2>
<input type="radio" name="order" value="0" ';
if($houses_order == 0)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>Alfabetycznie</b></font><br>
<input type="radio" name="order" value="1" ';
if($houses_order == 1)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>Według rozmiaru</b></font><br>
<input type="radio" name="order" value="2" ';
if($houses_order == 2)
$main_content.='checked="checked" ';
$main_content.='>*<font face="Trebuchet MS" size="2px"/><b>Według renty</b></font><br>
</td>
</tr>
<tr bgcolor="'.$config['site']['darkborder'].'">
<td valign=top>
';


{




}
$main_content .= '
</td>
</tr>
<tr>
<td colspan='.$colspan.'>

<br><center>
<input value="Kontynuuj" type="submit" style="width:120px;"/></form>

</td>
</tr>
</table>
</form>
</tr></table></td></tr></table>

';
}












##-- Show House --##
else
{
$house = $SQL->query('SELECT * FROM houses WHERE id = '.$id.'')->fetch();
if($house['doors'] == 0)
$door = '1 door';
else
$door = $house['doors'] + 1 .' doors';
if($house['beds'] == 0)
$bed = '1 bed';
else
$bed = $house['beds'].' beds';
if($house['owner'] > 0)
{
$player = $ots->createObject('Player');
$player->load($house['owner']);
if($house['paid'] > 0)
$paid = ' and paid until <b>Feb 08 2011, 23:58:43'.date("M j Y, H:i:s", $house['paid']).' CET</b>';
$owner = '<br>The house is currently rented by <a href="?subtopic=characters&name='.urlencode($player->getName()).'">'.$player->getName().'</a>'.$paid.'.';
}
$main_content .= '<table border=0 cellspacing=1 cellpadding=4 width=100%>
<tr>
<td></td>
<td>
<b>'.$house['name'].'</b><br><br>
This house is located in <b>'.$towns_houses[$house['world_id']][$house['town']].'</b>.<br>
It has '.$door.' and '.$bed.' on size of <b>'.$house['size'].' square meters</b>.<br>
The weekly rent is <b>'.$house['rent'].' gold</b> and will be debited to the bank account on <b>'.$world_name.'</b>.<br>
'.$owner.'
</td>
</tr>
<tr>
<td colspan=2></td>
</tr>
</table>';
}
?>
 
Zamień:
Code: 
$houses_sql = $SQL->query('SELECT * FROM houses WHERE world_id = '.$world_id.' AND town = '.$town_id.''.$owner_sql.''.$status_sql.' ORDER BY '.$order_sql.' DESC')->fetchAll();
Na:
Code: 
$houses_sql = $SQL->query('SELECT * FROM houses WHERE world_id = '.$world_id.' AND town = '.$town_id.''.$owner_sql.''.$status_sql.' ORDER BY '.$order_sql.' ASC')->fetchAll();
A na przyszłość polecam:
Kurs PHP
 
Back
Top