mirror of
https://github.com/Znote/ZnoteAAC.git
synced 2025-04-26 01:09:22 +02:00
824874e390
Guildhalls that have an owner now shows the Guild Name, which you can click to view the guild. Before it would consider the owner to be player id instead of guild id, and load the player which was completely wrong. Not all TFS 0.3 servers support this, so added a check to see if the guild column declaration was available in town data. Also fixed a bug where it tries to load a sub page if you enter without posting selected town data to it. And added town selection to the top of the list.
322 lines
9.6 KiB
PHP
322 lines
9.6 KiB
PHP
<?php
|
|
require_once 'engine/init.php';
|
|
include 'layout/overall/header.php';
|
|
|
|
if ($config['log_ip'])
|
|
znote_visitor_insert_detailed_data(3);
|
|
|
|
if (empty($_POST) === false && $config['ServerEngine'] === 'TFS_03') {
|
|
|
|
/* Token used for cross site scripting security */
|
|
if (isset($_POST['token']) && Token::isValid($_POST['token'])) {
|
|
|
|
$townid = (int)$_POST['selected'];
|
|
$cache = new Cache('engine/cache/houses');
|
|
$array = array();
|
|
if ($cache->hasExpired()) {
|
|
$tmp = fetchAllHouses_03();
|
|
$cache->setContent($tmp);
|
|
$cache->save();
|
|
|
|
foreach ($tmp as $t) {
|
|
if ($t['town'] == $townid) $array[] = $t;
|
|
}
|
|
$array = isset($array) ? $array : false;
|
|
} else {
|
|
$tmp = $cache->load();
|
|
foreach ($tmp as $t) {
|
|
if ($t['town'] == $townid) $array[] = $t;
|
|
}
|
|
$array = isset($array) ? $array : false;
|
|
}
|
|
|
|
// Design and present the list
|
|
if ($array) {
|
|
$guild_support = (isset($array[0]['guild'])) ? true : false;
|
|
?>
|
|
<h2>
|
|
<?php echo ucfirst(town_id_to_name($townid)); ?> house list.
|
|
</h2>
|
|
<div class="well widget">
|
|
<div class="header">
|
|
Town list / houses
|
|
</div>
|
|
<div class="body">
|
|
<form action="houses.php" method="<?php if ($config['ServerEngine'] !== 'TFS_10') echo "post"; else echo "get" ;?>">
|
|
<select name="<?php if ($config['ServerEngine'] !== 'TFS_10') echo "selected"; else echo "id" ;?>">
|
|
<?php
|
|
foreach ($config['towns'] as $id => $name)
|
|
echo '<option value="'. $id .'">'. $name .'</option>';
|
|
?>
|
|
</select>
|
|
<?php Token::create(); ?>
|
|
<input type="submit" value="Fetch houses">
|
|
</form>
|
|
</div>
|
|
</div>
|
|
<table id="housesTable" class="table table-striped">
|
|
<tr class="yellow">
|
|
<th>Name:</th>
|
|
<th>Size:</th>
|
|
<th>Doors:</th>
|
|
<th>Beds:</th>
|
|
<th>Price:</th>
|
|
<th>Owner:</th>
|
|
|
|
</tr>
|
|
<?php
|
|
foreach ($array as $value) {
|
|
echo '<tr>';
|
|
echo "<td>". $value['name'] ."</td>";
|
|
echo "<td>". $value['size'] ."</td>";
|
|
echo "<td>". $value['doors'] ."</td>";
|
|
echo "<td>". $value['beds'] ."</td>";
|
|
echo "<td>". $value['price'] ."</td>";
|
|
if ($value['owner'] == 0)
|
|
echo "<td>None</td>";
|
|
else {
|
|
if ($guild_support && $value['guild'] == 1) {
|
|
$guild_name = get_guild_name($value['owner']);
|
|
echo '<td><a href="guilds.php?name='. $guild_name .'">'. $guild_name .'</a></td>';
|
|
} else {
|
|
$data = user_character_data($value['owner'], 'name');
|
|
echo '<td><a href="characterprofile.php?name='. $data['name'] .'">'. $data['name'] .'</a></td>';
|
|
}
|
|
}
|
|
echo '</tr>';
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
} else {
|
|
echo 'Empty list, it appears no houses are listed in this town.';
|
|
}
|
|
//Done.
|
|
} else {
|
|
echo 'Token appears to be incorrect.<br><br>';
|
|
//Token::debug($_POST['token']);
|
|
echo 'Please clear your web cache/cookies <b>OR</b> use another web browser<br>';
|
|
}
|
|
} else {
|
|
if (empty($_POST) === true && $config['ServerEngine'] === 'TFS_03') {
|
|
?>
|
|
<div class="well widget">
|
|
<div class="header">
|
|
Town list / houses
|
|
</div>
|
|
<div class="body">
|
|
<form action="houses.php" method="<?php if ($config['ServerEngine'] !== 'TFS_10') echo "post"; else echo "get" ;?>">
|
|
<select name="<?php if ($config['ServerEngine'] !== 'TFS_10') echo "selected"; else echo "id" ;?>">
|
|
<?php
|
|
foreach ($config['towns'] as $id => $name)
|
|
echo '<option value="'. $id .'">'. $name .'</option>';
|
|
?>
|
|
</select>
|
|
<?php Token::create(); ?>
|
|
<input type="submit" value="Fetch houses">
|
|
</form>
|
|
</div>
|
|
</div>
|
|
<?php
|
|
} else if ($config['ServerEngine'] === 'TFS_02' || $config['ServerEngine'] == 'OTHIRE') {
|
|
$house = $config['house'];
|
|
if (!is_file($house['house_file'])) {
|
|
echo("<h3>House file not found</h3><p>FAILED TO LOCATE/READ FILE AT:<br><font color='red'>". $house['house_file'] ."</font><br><br>LINUX users: Make sure www-data have read access to file.<br>WINDOWS users: Learn to write correct file path.</p>");
|
|
exit();
|
|
}
|
|
|
|
// Load and cache SQL house data:
|
|
$cache = new Cache('engine/cache/houses/sqldata');
|
|
if ($cache->hasExpired()) {
|
|
$house_query = mysql_select_multi('SELECT `players`.`name`, `houses`.`id` FROM `players`, `houses` WHERE `houses`.`owner` = `players`.`id`;');
|
|
|
|
$cache->setContent($house_query);
|
|
$cache->save();
|
|
} else
|
|
$house_query = $cache->load();
|
|
|
|
$sqmPrice = $house['price_sqm'];
|
|
$house_load = simplexml_load_file($house['house_file']);
|
|
if ($house_query !== false && $house_load !== false) {
|
|
?>
|
|
<h2>House list</h2>
|
|
<table>
|
|
<tr class="yellow">
|
|
<td><b>House</b></td>
|
|
<td><b>Location</b></td>
|
|
<td><b>Owner</b></td>
|
|
<td><b>Size</b></td>
|
|
<td><b>Rent</b></td>
|
|
</tr>
|
|
|
|
<?php
|
|
//execute code.
|
|
foreach($house_query as $row)
|
|
$house_info[(int)$row['id']] = '<a href="characterprofile.php?name='. $row['name'] .'">'. $row['name'] .'</a>';
|
|
|
|
foreach ($house_load as $house_fetch){
|
|
$house_price = (int)$house_fetch['size'] * $sqmPrice;
|
|
?>
|
|
<tr>
|
|
<td><?php echo htmlspecialchars($house_fetch['name']); ?></td>
|
|
<td>
|
|
<?php
|
|
if (isset($config['towns'][(int)$house_fetch['townid']])) echo htmlspecialchars($config['towns'][(int)$house_fetch['townid']]);
|
|
else echo '(Missing town)';
|
|
?>
|
|
</td>
|
|
<td>
|
|
<?php
|
|
if (isset($house_info[(int)$house_fetch['houseid']])) echo $house_info[(int)$house_fetch['houseid']];
|
|
else echo 'None [Available]';
|
|
?>
|
|
</td>
|
|
<td><?php echo $house_fetch['size']; ?></td>
|
|
<td><?php echo $house_price; ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
} else echo '<p><font color="red">Something is wrong with the cache.</font></p>';
|
|
} else if ($config['ServerEngine'] === 'TFS_10') {
|
|
// Fetch values
|
|
$querystring_id = &$_GET['id'];
|
|
$townid = ($querystring_id) ? (int)$_GET['id'] : $config['houseConfig']['HouseListDefaultTown'];
|
|
$towns = $config['towns'];
|
|
|
|
$order = &$_GET['order'];
|
|
$type = &$_GET['type'];
|
|
|
|
// Create Search house box
|
|
?>
|
|
<form action="" method="get" class="houselist">
|
|
<table>
|
|
<tr>
|
|
<td>Town</td>
|
|
<td>Order</td>
|
|
<td>Sort</td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
<select name="id">
|
|
<?php
|
|
foreach ($towns as $id => $name)
|
|
echo '<option value="'. $id .'"' . ($townid != $id ?: ' selected') . '>'. $name .'</option>';
|
|
?>
|
|
</select>
|
|
</td>
|
|
<td>
|
|
<select name="order">
|
|
<?php
|
|
$order_allowed = array('id', 'name', 'size', 'beds', 'rent', 'owner');
|
|
foreach($order_allowed as $o)
|
|
echo '<option value="' . $o . '"' . ($o != $order ?: ' selected') . '>' . ucfirst($o) . '</option>';
|
|
?>
|
|
</select>
|
|
</td>
|
|
<td>
|
|
<select name="type">
|
|
<?php
|
|
$type_allowed = array('desc', 'asc');
|
|
foreach($type_allowed as $t)
|
|
echo '<option value="' . $t . '"' . ($t != $type ?: ' selected') . '>' . ($t == 'desc' ? 'Descending' : 'Ascending') .'</option>';
|
|
?>
|
|
</select>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="3">
|
|
<input type="submit" value="Fetch houses"/>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
<?php
|
|
if(!in_array($order, $order_allowed))
|
|
$order = 'id';
|
|
|
|
if(!in_array($type, $type_allowed))
|
|
$type = 'desc';
|
|
|
|
// Create or fetch data from cache
|
|
$cache = new Cache('engine/cache/houses/houses-' . $order . '-' . $type);
|
|
$houses = array();
|
|
if ($cache->hasExpired()) {
|
|
$houses = mysql_select_multi("SELECT `id`, `owner`, `paid`, `warnings`, `name`, `rent`, `town_id`, `size`, `beds`, `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[] = $h['owner'];
|
|
|
|
if (!empty($playerlist)) {
|
|
$ids = join(',', $playerlist);
|
|
$tmpPlayers = mysql_select_multi("SELECT `id`, `name` FROM players WHERE `id` IN ($ids);");
|
|
|
|
// 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");
|
|
?>
|
|
<table id="housetable">
|
|
<tr class="yellow">
|
|
<th>Name</th>
|
|
<th>Size</th>
|
|
<th>Beds</th>
|
|
<th>Rent</th>
|
|
<th>Owner</th>
|
|
<th>Town</th>
|
|
</tr>
|
|
<?php
|
|
foreach ($houses as $house) {
|
|
if ($house['town_id'] == $townid) {
|
|
?>
|
|
<tr>
|
|
<td><?php echo "<a href='house.php?id=". $house['id'] ."'>". $house['name'] ."</a>"; ?></td>
|
|
<td><?php echo $house['size']; ?></td>
|
|
<td><?php echo $house['beds']; ?></td>
|
|
<td><?php echo $house['rent']; ?></td>
|
|
<?php
|
|
// Status:
|
|
if ($house['owner'] != 0)
|
|
echo "<td><a href='characterprofile.php?name=". $house['ownername'] ."' target='_BLANK'>". $house['ownername'] ."</a></td>";
|
|
else
|
|
echo ($house['highest_bidder'] == 0 ? '<td>None</td>' : '<td><b>Selling</b></td>');
|
|
?>
|
|
<td><?php
|
|
$town_name = &$towns[$house['town_id']];
|
|
echo ($town_name ? $town_name : 'Specify town id ' . $house['town_id'] . ' name in config.php first.');
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
<?php
|
|
} else
|
|
echo "<h1>Failed to fetch data from sql->houses table.</h1><p>Is the table empty?</p>";
|
|
} // End TFS 1.0 logic
|
|
}
|
|
include 'layout/overall/footer.php'; ?>
|