How to add House in the character information?

[lenidas]

How can I add house in the character information?
for example like there:
Tibia - Free Multiplayer Online Role Playing Game - Community

House:	Radiant Plaza 3 (Yalahar) is paid until Jun 01 2010

but without "paid until..."

 

[lenidas]

bump

 

[stefanhaan]

Make a query by wich u join houses table and players table by their ids if there are no rows he owns no house, if there is 1 row retrieve the data and display it in a way u like

Still make the query yourself.

 

[ond]

@UP isn't he requesting help?

 

[hodleo]

he's no scripter <...>

 

[lenidas]

Make a query by wich u join houses table and players table by their ids if there are no rows he owns no house, if there is 1 row retrieve the data and display it in a way u like

Still make the query yourself.

I requsted for it...

 

[lenidas]

bump

 

[lenidas]

bump

 

[lenidas]

bump

 

[Jano]

$houses = $SQL->query('SELECT houses.name AS name FROM houses WHERE houses.owner IN (SELECT players.id FROM players WHERE players.account_id = ' . $player->getAccount() . ');');

foreach($houses as $k=>$house)
{
    $main_content .= "
    <TR BGCOLOR=\"".$config['site'][($k % 2 == 1 ? 'light' : 'dark').'border']."\">
        <TD>
            House:
        </TD>
        <TD>
            ".$house['name']."
        </TD>
    </TR>";
}

 

[lenidas]

Thanks, Almost good But look I have 2 characters on 1 account (name: Yulps and Bezik) and on page (characters.php) i see that Yulps owns house "Harbour Place 1 (Shop)" and Bezik owns this house too.
It's not true:

You see an open door.
It belongs to house 'Harbour Place 1 (Shop)'. Yulps owns this house.

Can someone fix it? query to sql should download info from player, not from whole account.
Also could someone add query to get town ID(town name) where house is located?
Like here:
Tibia - Free Multiplayer Online Role Playing Game - Community

House:	Central Circle 4 [B](Edron)[/B]

Thanks in advance

 

[Jano]

$houses = $SQL->query('SELECT houses.name AS name, houses.town AS town FROM houses WHERE houses.owner = ' . $player->getId() . ' LIMIT 1;');

foreach($houses as $k=>$house)
{
    $main_content .= "
    <TR BGCOLOR=\"".$config['site'][($k % 2 == 1 ? 'light' : 'dark').'border']."\">
        <TD>
            House:
        </TD>
        <TD>
            " . $house['name'] . " (" . $towns_list[0][$house['town']] . ")
        </TD>
    </TR>";
}