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")); } }