rented house (WEB)

[nuelma123]

I have houses in rented but don't show in web site? why?

    $housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();

 

[Codex NG]

Can you post the sql schema?

 

[nuelma123]

you mean to this?

    $query = $SQL->query("SELECT * FROM `players` ORDER BY `experience` DESC")->fetch();
    $query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
    $housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
    $housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
    $players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
    $accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
    //$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
    $guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();

 

[Shawak]

try this

housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner` <> 0;')->fetch();

 

[Marcus]

I have houses in rented but don't show in web site? why?

    $housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();

I dunno about your website codes.. but owner=1 probably means character with id 1..
And that will display wrong, you should select houses with owner id 1 or greater, like this:

$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`>=1;')->fetch();

 

[Codex NG]

If owner is the pid than you might as well go with what @Shawak recommended or > 0.
This is why I asked for them to post the schema but if it is embedded in the code (which is clever yet dumb) then they'll need to provide a dump of the table.

I don't care what anyone on this forum says there isn't only one way to trouble shoot an issue.

 

[nuelma123]

try this

housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner` <> 0;')->fetch();

Now work
thanks

Free Houses: 1078 Rented Houses: 7