$name): ?> >

'ID', 'name' => t('common.name'), 'size' => t('house.size'), 'beds' => t('house.beds'), 'rent' => t('house.rent'), 'owner' => t('house.owner')); ?>

>

>

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) { $playerlist = array(); foreach ($houses as $houseRow) if ($houseRow['owner'] > 0) $playerlist[] = (int)$houseRow['owner']; if (!empty($playerlist)) { $placeholders = implode(',', array_fill(0, count($playerlist), '?')); $tmpPlayers = db()->fetchAll("SELECT `id`, `name` FROM players WHERE `id` IN ($placeholders);", $playerlist); $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)): ?>