function edit_realm(&$sqlr)
{
global $output, $lang_global, $lang_realm, $server, $action_permission, $user_lvl;
valid_login($action_permission['update']);
if (empty($_GET['id'])) {
redirect('realm.php?error=1');
}
$id = $sqlr->quote_smart($_GET['id']);
if (is_numeric($id)) {
} else {
redirect('realm.php?error=1');
}
if ($realm = $sqlr->fetch_assoc($sqlr->query('
SELECT realmlist.id AS rid, name, address, port, icon, timezone,
(SELECT SUM(numchars)
FROM realmcharacters
WHERE realmid = rid) as sum
FROM realmlist WHERE id =' . $id . ''))) {
$output .= '
<center>
<fieldset class="half_frame">
<legend>' . $lang_realm['edit_realm'] . '</legend>
<form method="get" action="realm.php" name="form">
<input type="hidden" name="action" value="doedit_realm" />
<input type="hidden" name="id" value="' . $id . '" />
<table class="flat">
<tr>
<td>' . $lang_realm['id'] . '</td>
<td>' . $realm['rid'] . '</td>
</tr>
<tr>
<td>' . $lang_realm['name'] . '</td>
<td><input type="text" name="new_name" size="40" maxlength="32" value="' . $realm['name'] . '" /></td>
</tr>
<tr>
<td>' . $lang_realm['address'] . '</td>
<td><input type="text" name="new_address" size="40" maxlength="32" value="' . $realm['address'] . '" /></td>
</tr>
<tr>
<td>' . $lang_realm['port'] . '</td>
<td><input type="text" name="new_port" size="40" maxlength="5" value="' . $realm['port'] . '" /></td>
</tr>
<tr>
<td>' . $lang_realm['icon'] . '</td>
<td>
<select name="new_icon">';
unset($id);
foreach (get_icon_type() as $icon) {
$output .= '
<option value="' . $icon[0] . '" ';
if ($realm['icon'] == $icon[0]) {
$output .= '
selected="selected" ';
}
$output .= '
>' . $icon[1] . '</option>';
}
unset($icon);
$output .= '
</select>
</td>
</tr>
<tr>
<td>' . $lang_realm['timezone'] . '</td>
<td>
<select name="new_timezone">';
foreach (get_timezone_type() as $zone) {
$output .= '
<option value="' . $zone[0] . '" ';
if ($realm['timezone'] == $zone[0]) {
$output .= '
selected="selected" ';
}
$output .= '
>' . $zone[1] . '</option>';
}
unset($zone);
$output .= '
</select>
</td>
</tr>';
if (isset($server[$realm['rid']]['game_port'])) {
$output .= '
<tr>
<td>' . $lang_realm['status'] . '</td>
<td>' . (test_port($server[$realm['rid']]['addr'], $server[$realm['rid']]['game_port']) ? $lang_realm['online'] : $lang_realm['offline']) . '</td>
</tr>
<tr>
<td>' . $lang_realm['tot_char'] . '</td>
<td>' . $realm['sum'] . '</td>
</tr>';
} else {
$output .= '
<tr>
<td colspan="2">' . $lang_realm['conf_from_file'] . '</td>
</tr>';
}
$output .= '
<tr>
<td>';
if ($user_lvl >= $action_permission['delete']) {
makebutton($lang_realm['delete'], 'realm.php?action=del_realm&id=' . $realm['rid'] . '" type="wrn', 130);
}
unset($realm);
$output .= '
</td>
<td>';
makebutton($lang_realm['update'], 'javascript:do_submit()', 130);
makebutton($lang_global['back'], 'realm.php" type="def', 130);
$output .= '
</td>
</tr>
</table>
</form>
</fieldset>
<br /><br />
</center>';
} else {
error($lang_global['err_no_result']);
}
}
function edit_realm()
{
global $output, $server, $action_permission, $user_lvl, $sql;
valid_login($action_permission["update"]);
$result = $sql["char"]->query("SELECT COUNT(*) FROM characters");
$sum = $sql["char"]->fetch_row($result);
$sum = $sum[0];
if (empty($_GET["id"])) {
redirect("realm.php?error=1");
}
$id = $sql["mgr"]->quote_smart($_GET["id"]);
if (!is_numeric($id)) {
redirect("realm.php?error=1");
}
if ($realm = $sql["mgr"]->fetch_assoc($sql["mgr"]->query('SELECT `Index` AS rid, Name AS name, External_Address AS address, Port AS port, Icon AS icon, Color AS color, Timezone AS timezone
FROM config_servers WHERE `Index`=' . $id . ''))) {
$output .= '
<div class="half_frame fieldset_border center">
<span class="legend">' . lang("realm", "edit_realm") . '</span>
<form method="get" action="realm.php" id="form">
<div>
<input type="hidden" name="action" value="doedit_realm" />
<input type="hidden" name="id" value="' . $id . '" />
</div>
<table class="flat center">
<tr>
<td>' . lang("realm", "id") . '</td>
<td>' . $realm["rid"] . '</td>
</tr>
<tr>
<td>' . lang("realm", "name") . '</td>
<td><input type="text" name="new_name" size="40" maxlength="32" value="' . $realm["name"] . '" /></td>
</tr>
<tr>
<td>' . lang("realm", "address") . '</td>
<td><input type="text" name="new_address" size="40" maxlength="32" value="' . $realm["address"] . '" /></td>
</tr>
<tr>
<td>' . lang("realm", "port") . '</td>
<td><input type="text" name="new_port" size="40" maxlength="5" value="' . $realm["port"] . '" /></td>
</tr>
<tr>
<td>' . lang("realm", "icon") . '</td>
<td>
<select name="new_icon">';
unset($id);
foreach (get_icon_type() as $icon) {
$output .= '
<option value="' . $icon[0] . '" ' . ($realm["icon"] == $icon[0] ? 'selected="selected" ' : '') . '>' . $icon[1] . '</option>';
}
unset($icon);
$output .= '
</select>
</td>
</tr>
<tr>
<td>' . lang("realm", "color") . '</td>
<td><input type="text" name="new_color" size="40" maxlength="3" value="' . $realm["color"] . '" /></td>
</tr>
<tr>
<td>' . lang("realm", "timezone") . '</td>
<td>
<select name="new_timezone">';
foreach (get_timezone_type() as $zone) {
$output .= '
<option value="' . $zone[0] . '" ' . ($realm["timezone"] == $zone[0] ? 'selected="selected" ' : '') . '>' . $zone[1] . '</option>';
}
unset($zone);
$output .= '
</select>
</td>
</tr>';
if (isset($server[$realm["rid"]]['game_port'])) {
$output .= '
<tr>
<td>' . lang("realm", "status") . '</td>
<td>' . (test_port($server[$realm["rid"]]['addr'], $server[$realm["rid"]]['game_port']) ? '<img src="img/up.gif" alt="" />' : '<img src="img/down.gif" alt="" />') . '</td>
</tr>
<tr>
<td>' . lang("realm", "tot_char") . '</td>
<td>' . $sum . '</td>
</tr>';
} else {
$output .= '
<tr>
<td colspan="2">' . lang("realm", "conf_from_file") . '</td>
</tr>';
}
$output .= '
<tr>
<td>';
if ($user_lvl >= $action_permission["delete"]) {
makebutton(lang("realm", "delete"), 'realm.php?action=del_realm&id=' . $realm["rid"] . '" type="wrn', 130);
}
unset($realm);
$output .= '
</td>
<td>';
makebutton(lang("realm", "update"), 'javascript:do_submit()', 130);
makebutton(lang("global", "back"), 'realm.php" type="def', 130);
$output .= '
</td>
</tr>
</table>
</form>
</div>
<br />
<br />';
} else {
error(lang("global", "err_no_result"));
}
}
