AAC Houses on character

[Lais Prad]

Hello, Im trying to make script for show houses on characters (if he are owner of one) but without sucess, someone can help?

gesior acc 2012, tfs 1.3

scrip:

// TESTE
        $house = $SQL->query( 'SELECT `houses`.`name`, `houses`.`town_id`, `houses`.`warnings` FROM `houses` WHERE `houses`.`town_id` = '.$player->getTownID().' AND `houses`.`owner` = '.$player->getId().';' )->fetchAll();
        if(count($house) != 0)
        {
        if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
        $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>House:</TD><TD colspan="2">'.$house[0]['name'].' ('.$towns_list[$player->getTownID()][$house[0]['town_id']].') is paid until '.date("M j Y", $house[0]['warnings']).'</TD></TR>';
        }
        //TESTE

 

[Raggaer]

You can probably get this done on a single query (when you get all the character information) using a LEFT JOIN

 

[Lais Prad]

Bump to hell #updated

 

[Lais Prad]

updated

 

[Lais Prad]

uptodate