hasExpired()) { $houses = db()->fetchAll(" SELECT `id`, `owner`, `paid`, `warnings`, `name`, `rent`, `town_id`, `size`, `beds`, " . houseSelect(array('bid','bid_end','last_bid','highest_bidder')) . " FROM `houses` ORDER BY {$order} {$type}; "); if ($houses !== false) { // Fetch player names $playerlist = array(); foreach ($houses as $h) if ($h['owner'] > 0) $playerlist[] = (int)$h['owner']; if (!empty($playerlist)) { $placeholders = implode(',', array_fill(0, count($playerlist), '?')); $tmpPlayers = db()->fetchAll("SELECT `id`, `name` FROM players WHERE `id` IN ($placeholders);", $playerlist); // Sort $tmpPlayers by player id $tmpById = array(); foreach ($tmpPlayers as $p) $tmpById[$p['id']] = $p['name']; for ($i = 0; $i < count($houses); $i++) if ($houses[$i]['owner'] > 0) $houses[$i]['ownername'] = $tmpById[$houses[$i]['owner']]; } $cache->setContent($houses); $cache->save(); } } else $houses = $cache->load(); if ($houses !== false || !empty($houses)) { // Intialize stuff //data_dump($houses, false, "House data"); ?> ". $house['ownername'] .""; else echo ($house['highest_bidder'] == 0 ? '' : ''); ?>
". $house['name'] .""; ?> NoneSelling
". t('houses.fetch_failed') ."

". t('houses.empty') ."

"; } theme_close(); ?>