PHP get_item_name 예제들

예제 #1

파일: nav_menu.php 프로젝트: sleepyycat/WebFramework

function read_dir($dir, &$dir_array, $root, &$html_lines)
{
    global $link_array, $hot_array, $pop_array, $new_tools;
    global $menu_name;
    global $popular_access_dict;
    $dir_list = get_valid_dir($dir);
    if ($root == false && count($dir_list) != 0) {
        array_push($html_lines, "<ul>");
    }
    foreach ($dir_list as $dir2) {
        $path = $dir . "/" . $dir2;
        if (!checkShow($path)) {
            continue;
        }
        $dir_list2 = get_valid_dir($path);
        if (count($dir_list2) == 0) {
            $show_name = get_item_name($path);
            array_push($html_lines, "<li><a href='' name='{$path}'><span class='item'>" . $show_name . "</span></a>");
            $cnt = 0;
            $tip_str = "";
            if (array_key_exists($path, $popular_access_dict["hot"])) {
                $cnt = $popular_access_dict["hot"][$path];
                $tip_str = "点击次数:{$cnt}";
                $show_name = "{$show_name}({$cnt})";
                array_push($link_array[$menu_name], "<a class='btn btn-danger btn-xs' title='hot({$tip_str})' href='{$path}'>{$show_name}</a>");
                array_push($hot_array, "<a class='btn btn-danger btn-xs' title='hot({$tip_str})' href='{$path}'>{$show_name}</a> ");
            } elseif (array_key_exists($path, $popular_access_dict["good"])) {
                $cnt = $popular_access_dict["good"][$path];
                $tip_str = "点击次数:{$cnt}";
                $show_name = "{$show_name}({$cnt})";
                array_push($link_array[$menu_name], "<a class='btn btn-success btn-xs' title='popular({$tip_str})' href='{$path}'>{$show_name}</a>");
                array_push($pop_array, "<a class='btn btn-success btn-xs' title='popular({$tip_str})' href='{$path}'>{$show_name}</a> ");
            } else {
                if (array_key_exists($path, $popular_access_dict["all"])) {
                    $cnt = $popular_access_dict["all"][$path];
                }
                $tip_str = "点击次数:{$cnt}";
                $show_name = "{$show_name}({$cnt})";
                array_push($link_array[$menu_name], "<a class='btn btn-link btn-xs' href='{$path}' title='{$tip_str}'>{$show_name}</a>");
            }
            $filetime = @filectime($path . "/index.html");
            if (file_exists($path . "/index.php")) {
                $filetime = @filectime($path . "/index.php");
            }
            $mtime = date("F d Y H:i:s.", $filetime);
            $new_tools[$filetime] = "<a class='btn btn-info btn-xs' title='hot({$tip_str}, {$mtime})' href='{$path}'>{$show_name}</a> ";
        } else {
            array_push($html_lines, "<li><a href='' class='parent' name='{$path}'><span class='item'>" . get_item_name($path) . "</span></a>");
        }
        $dir_array[$dir2] = array();
        read_dir($path, $dir_array[$dir2], false, $html_lines);
        array_push($html_lines, "</li>");
    }
    if ($root == false && count($dir_list) != 0) {
        array_push($html_lines, "</ul>");
    }
}

예제 #2

파일: show.php 프로젝트: Covert-Inferno/fortissimo

    array_push($criteria, '(v_corpid = ? OR k_corpid = ?)');
    array_push($bind, $corpid, $corpid);
    array_push($args, "corpid={$corpid}");
    array_push($message, "by corp <strong>" . get_corp_name($corpid) . " [" . get_corp_ticker($corpid) . "]</strong>");
}
if (is_numeric($allianceid) && $allianceid > 0) {
    array_push($criteria, '(v_allianceid = ? OR k_allianceid = ?)');
    array_push($bind, $allianceid, $allianceid);
    array_push($args, "allianceid={$allianceid}");
    array_push($message, "by alliance <strong>" . get_alliance_name($allianceid) . "</strong>");
}
if (is_numeric($shipid) && $shipid > 0) {
    array_push($criteria, '(v_shipid = ? OR k_shipid = ?)');
    array_push($bind, $shipid, $shipid);
    array_push($args, "shipid={$shipid}");
    array_push($message, "with a <strong>" . get_item_name($shipid) . "</strong>");
}
if (is_numeric($pilotid) && $pilotid > 0) {
    array_push($criteria, '(v_pilotid = ? OR k_pilotid = ?)');
    array_push($bind, $pilotid, $pilotid);
    array_push($args, "pilotid={$pilotid}");
    array_push($message, "involving pilot <strong>" . get_pilot_name($pilotid) . "</strong>");
}
# reassign the args
$a = implode('&', $args);
$ft->assign('args', $a);
# and criteria messaging
$m = implode(' and ', $message);
# show the last 50 somethings
$ft->message('Recent activity ' . $m . '.');
$ft->title('Recent Activity');

예제 #3

파일: forage.view.tmpl.php 프로젝트: N0ctrnl/peqphpeditor

        <tr bgcolor="#<? echo ($x % 2 == 0) ? "BBBBBB" : "AAAAAA";?>">
          <td align="center" width="5%"><?php 
echo $fgid;
?>
</td>
<?if($zoneid == 0):?>          
          <td align="center" width="10%">All</td>
<?endif;?>
<?if($zoneid != 0):?> 
          <td align="center" width="10%"><?php 
echo getZoneName($zoneid);
?>
</td>
<?endif;?>
          <td align="center" width="20%"><?php 
echo get_item_name($fgiid);
?>
 <span>[<a href="http://lucy.allakhazam.com/item.html?id=<?php 
echo $fgiid;
?>
">lucy</a>]</span></td>
          <td align="center" width="5%"><?php 
echo $level;
?>
</td>
          <td align="center" width="5%"><?php 
echo $chance;
?>
%</td>  
          <td align="right">      
            <a href="index.php?editor=misc&z=<?php 

예제 #4

파일: inventory.player.tmpl.php 프로젝트: Xackery/EQEmuEOC

    foreach ($shared_inventory as $s_inv) {
        extract($s_inv);
        ?>
        <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
          <td>&nbsp;&nbsp;&nbsp;<?php 
        echo $s_inv['slotid'];
        ?>
 - <?php 
        echo $slots[$s_inv['slotid']];
        ?>
</td>
          <td align="center"><?php 
        echo get_item_name($s_inv['itemid']);
        ?>
 (<?php 
        echo $s_inv['itemid'];
        ?>
) - [<a href="http://lucy.allakhazam.com/item.html?id=<?php 
        echo $s_inv['itemid'];
        ?>
" target="_blank">Lucy</a>]</td>
          <td align="right">&nbsp;</td>
        </tr>
<?php 
        $x++;
    }
}
if ($x == 0) {

예제 #5

파일: perso.php 프로젝트: galathil/coolwow2

$rep = mysql_fetch_array($req);
if ($_SESSION['auth'] == "yes" and Securite::bdd($_SESSION['gmlevel']) >= $rep['config_value2']) {
    if ($rep['config_value'] == 1) {
        mysql_connect($characters[1]['host'], $characters[1]['user'], $characters[1]['password']) or die(mysql_error());
        mysql_select_db($characters[1]['db']) or die(mysql_error());
        switch ($_GET['action']) {
            case "editer":
                require_once "../kernel/fonctions.php";
                require_once "../kernel/fonctions_armurerie.php";
                require_once "../kernel/defines/309.php";
                $id = Securite::bdd($_POST['id']);
                $id = Securite::bdd($_GET['id']);
                $reponse = mysql_query("SELECT guid,account,data,name,race,class,position_x,position_y,map,online,totaltime,position_z,zone\tFROM `characters` WHERE `name`='{$id}' OR `guid`='{$id}' ") or die(mysql_error());
                $char = mysql_fetch_row($reponse);
                $char_data = explode(' ', $char[2]);
                echo "\n\t\t\t\t<center>\n\t\t\t\t\t<form method=\"get\" action=\"index.php?module=perso&action=editer_v\" name=\"form\">\n\t\t\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"do_edit_char\" />\n\t\t\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"{$id}\" />\n\t\t\t\t\t\t<table class=\"lined\">\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t    <td colspan=\"8\"><font class=\"bold\"><input type=\"text\" name=\"name\" size=\"14\" maxlength=\"12\" value=\"{$char['3']}\" /> - " . get_player_race($char[4]) . " " . get_player_class($char[5]) . " lvl {$char_data[CHAR_DATA_OFFSET_LEVEL]}</font><br />{$online}</td>\n</tr>\n<tr>\n\t\t\t\t <td colspan=\"8\">" . get_map_name($char[9]) . " - " . get_zone_name($char[12]) . "</td>\n</tr>\n<tr>\n\t\t\t\t <td colspan=\"8\">{$lang_char['guild']}: {$guild_name} | {$lang_char['rank']}: {$guild_rank}</td>\n</tr>\n<tr>\n\t\t\t\t <td colspan=\"8\">{$lang_char['honor_points']}: <input type=\"text\" name=\"honor_points\" size=\"8\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_HONOR_POINTS]}\" />/\n\t\t\t\t <input type=\"text\" name=\"arena_points\" size=\"8\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_ARENA_POINTS]}\" /> - {$lang_char['honor_kills']}: <input type=\"text\" name=\"total_kills\" size=\"8\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_HONOR_KILL]}\" /></td>\n</tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td width=\"2%\"><input type=\"checkbox\" name=\"check[]\" value=\"a0\" /></td><td width=\"18%\">{$lang_item['head']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_HEAD]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_HEAD]) . "</a></td>\n\t\t\t\t    <td width=\"15%\">{$lang_item['health']}:</td><td width=\"15%\"><input type=\"text\" name=\"health\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_HEALTH]}\" /></td>\n\t\t\t\t    <td width=\"15%\">{$lang_item['res_holy']}:</td><td width=\"15%\"><input type=\"text\" name=\"res_holy\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_HOLY]}\" /></td>\n\t\t\t\t    <td width=\"18%\">{$lang_item['gloves']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_GLOVES]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_GLOVES]) . "</a></td><td width=\"2%\"><input type=\"checkbox\" name=\"check[]\" value=\"a9\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a1\" /></td><td>{$lang_item['neck']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_NECK]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_NECK]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['mana']}:</td><td><input type=\"text\" name=\"mana\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_MANA]}\" /></td>\n\t\t\t\t    <td>{$lang_item['res_arcane']}:</td><td><input type=\"text\" name=\"res_arcane\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_ARCANE]}\" /></td>\n\t\t\t\t    <td>{$lang_item['belt']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_BELT]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_BELT]) . "</a></td> <td><input type=\"checkbox\" name=\"check[]\" value=\"a5\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a2\" /></td><td>{$lang_item['shoulder']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_SHOULDER]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_SHOULDER]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['strength']}:</td><td><input type=\"text\" name=\"str\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_STR]}\" /></td>\n\t\t\t\t    <td>{$lang_item['res_fire']}:</td><td><input type=\"text\" name=\"res_fire\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_FIRE]}\" /></td>\n\t\t\t\t    <td>{$lang_item['legs']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_LEGS]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_LEGS]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a6\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a14\" /></td><td>{$lang_item['back']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_BACK]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_BACK]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['agility']}:</td><td><input type=\"text\" name=\"agi\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_AGI]}\" /></td>\n\t\t\t\t    <td>{$lang_item['res_nature']}:</td><td><input type=\"text\" name=\"res_nature\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_NATURE]}\" /></td>\n\t\t\t\t    <td>{$lang_item['feet']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_FEET]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_FEET]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a7\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a4\" /></td><td>{$lang_item['chest']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_CHEST]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_CHEST]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['stamina']}:</td><td><input type=\"text\" name=\"sta\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_STA]}\" /></td>\n\t\t\t\t    <td>{$lang_item['res_frost']}:</td><td><input type=\"text\" name=\"res_frost\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_FROST]}\" /></td>\n\t\t\t\t    <td>{$lang_item['finger']} 1<br /><a href=\"{$item_datasite}{$char_data[380]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_FINGER1]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a10\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a3\" /></td><td>{$lang_item['shirt']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_SHIRT]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_SHIRT]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['intellect']}:</td><td><input type=\"text\" name=\"int\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_INT]}\" /></td>\n\t\t\t\t    <td>{$lang_item['res_shadow']}:</td><td><input type=\"text\" name=\"res_shadow\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_SHADOW]}\" /></td>\n\t\t\t\t    <td>{$lang_item['finger']} 2<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_FINGER2]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_FINGER2]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a11\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a18\" /></td><td>{$lang_item['tabard']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_TABARD]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_TABARD]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['spirit']}:</td><td><input type=\"text\" name=\"spi\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_SPI]}\" /></td>\n\t\t\t\t    <td>{$lang_char['exp']}:</td><td><input type=\"text\" name=\"exp\" size=\"10\" maxlength=\"8\" value=\"{$char_data[CHAR_DATA_OFFSET_EXP]}\" /></td>\n\t\t\t\t    <td>{$lang_item['trinket']} 1<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_TRINKET1]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_TRINKET1]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a12\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a8\" /></td><td>{$lang_item['wrist']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_WRIST]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_WRIST]) . "</a></td>\n\t\t\t\t    <td>{$lang_item['armor']}:</td><td><input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_ARMOR]}\" /></td>\n\t\t\t\t    <td>{$lang_char['melee_ap']}: <input type=\"text\" name=\"attack_power\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_AP]}\" /></td><td>{$lang_char['ranged_ap']}: <input type=\"text\" name=\"range_attack_power\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_RANGED_AP]}\" /></td>\n\t\t\t\t    <td>{$lang_item['trinket']} 2<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_TRINKET2]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_TRINKET2]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a13\" /></td>\n\t\t\t\t  </tr>\n\t\t\t\t  <tr>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a15\" /></td>\n\t\t\t\t    <td colspan=\"2\">{$lang_item['main_hand']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_MAIN_HAND]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_MAIN_HAND]) . "</a></td>\n\t\t\t\t    <td colspan=\"2\"><input type=\"checkbox\" name=\"check[]\" value=\"a16\" />&nbsp;{$lang_item['off_hand']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_OFF_HAND]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_OFF_HAND]) . "</a></td>\n\t\t\t\t    <td colspan=\"2\">{$lang_item['ranged']}<br /><a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_RANGED]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_RANGED]) . "</a></td>\n\t\t\t\t    <td><input type=\"checkbox\" name=\"check[]\" value=\"a17\" /></td>\n<tr>\n<td colspan=\"8\">{$lang_char['block']} : <input type=\"text\" name=\"block\" size=\"5\" maxlength=\"3\" value=\"{$block}\" />% \n| {$lang_char['dodge']}: <input type=\"text\" name=\"dodge\" size=\"5\" maxlength=\"3\" value=\"{$dodge}\" />% \n| {$lang_char['parry']}: <input type=\"text\" name=\"parry\" size=\"5\" maxlength=\"3\" value=\"{$parry}\" />% \n| {$lang_char['crit']}: <input type=\"text\" name=\"crit\" size=\"5\" maxlength=\"3\" value=\"{$crit}\" />%\n| {$lang_char['range_crit']}: <input type=\"text\" name=\"range_crit\" size=\"3\" maxlength=\"14\" value=\"{$range_crit}\" />%</td>\n\t\t\t\t </tr>\n\t\t\t\t <tr>\n<td colspan=\"4\">{$lang_char['gold']}: <input type=\"text\" name=\"money\" size=\"10\" maxlength=\"8\" value=\"{$char_data[CHAR_DATA_OFFSET_GOLD]}\" /></td>\n\t\t\t\t  <td colspan=\"4\">{$lang_char['tot_paly_time']}: <input type=\"text\" name=\"tot_time\" size=\"8\" maxlength=\"14\" value=\"{$char[10]}\" /></td>\n</tr>\n<tr>\n\t\t\t\t\t<td colspan=\"5\">{$lang_char['location']}: \n\t\t\t\t\tX:<input type=\"text\" name=\"x\" size=\"10\" maxlength=\"8\" value=\"{$char[6]}\" />\n\t\t\t\t\tY:<input type=\"text\" name=\"y\" size=\"8\" maxlength=\"16\" value=\"{$char[7]}\" />\n\t\t\t\t\tZ:<input type=\"text\" name=\"z\" size=\"8\" maxlength=\"16\" value=\"{$char[11]}\" />\n\t\t\t\t\tMap:<input type=\"text\" name=\"map\" size=\"8\" maxlength=\"16\" value=\"{$char[8]}\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td colspan=\"3\">{$lang_char['move_to']}:<input type=\"text\" name=\"tp_to\" size=\"24\" maxlength=\"64\" value=\"\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table><br />\n\t\t\t\t<a href=\"index.php?module=perso&action=inventaire&id={$id}\">Voir l'inventaire</a> - \n\t\t\t\t<a href=\"index.php?module=perso&action=monnaie&id={$id}\">Voir les Marques d'honneur</a> - \n\t\t\t\t<a href=\"index.php?module=perso&action=quetes&id={$id}\">Voir les quêtes</a> - \n\t\t\t\t<a href=\"index.php?module=perso&action=talents&id={$id}\">Voir les Talents</a> - \n\t\t\t\t<a href=\"index.php?module=perso&action=skills&id={$id}\">Voir les Compétences</a>\n\t\t\t\t";
                break;
            case "editer_v":
                break;
            case "quetes":
                $id = mysql_real_escape_string(htmlspecialchars($_GET['id'], ENT_QUOTES));
                $retour = mysql_query("SELECT * FROM character_queststatus WHERE guid = {$id} AND ( status = 3 OR status = 1 ) ORDER BY status DESC");
                echo "<p class=\"title\">Les Quêtes</p><br />";
                echo "<table class=\"lined\" width=\"99%\" style='border-collapse: collapse'; width='90%' border='1' cellspacing='1' cellpadding='1'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th width=\"30\">ID</th>\n\t\t\t\t\t\t\t\t<th width=\"30\">Niveau</th>\n\t\t\t\t\t\t\t\t<th width=\"30\">Titre</th>\n\t\t\t\t\t\t\t\t<th width=\"30\">status</th>\n\t\t\t\t\t\t\t</tr>";
                while ($donnees = mysql_fetch_assoc($retour)) {
                    $retour2 = mysql_query("SELECT QuestLevel,title FROM `" . $mangos[1]['db'] . "`.`quest_template` LEFT JOIN `" . $mangos[1]['db'] . "`.`locales_quest` ON `quest_template`.`entry` = `locales_quest`.`entry` WHERE `quest_template`.`entry` ='" . $donnees['quest'] . "'");
                    $donnees2 = mysql_fetch_array($retour2);
                    echo "<tr><td align=\"center\">";
                    echo "<a href=\"http://fr.wowhead.com/?quest=" . $donnees['quest'] . "\">" . $donnees['quest'] . "</a>";
                    echo "</td><td align=\"center\">";
                    echo "" . $donnees2['QuestLevel'] . "";

예제 #6

파일: char_edit.php 프로젝트: BACKUPLIB/minimanager-1

function edit_char(&$sqlr, &$sqlc, &$sqlm)
{
    global $lang_global, $lang_char, $lang_item, $output, $realm_db, $characters_db, $realm_id, $mmfpm_db, $action_permission, $user_lvl, $item_datasite;
    // this page uses wowhead tooltops
    wowhead_tt();
    valid_login($action_permission['delete']);
    if (empty($_GET['id'])) {
        error($lang_global['empty_fields']);
    }
    $sqlm = new SQL();
    $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
    $id = $sqlc->quote_smart($_GET['id']);
    // getting character data from database
    $result = $sqlc->query("\r\n\t\tSELECT account \r\n\t\tFROM `characters` \r\n\t\tWHERE guid = '{$id}'");
    // no point going further if character does not exist
    if ($sqlc->num_rows($result)) {
        //resrict by owner's gmlvl
        $owner_acc_id = $sqlc->result($result, 0, 'account');
        $query = $sqlr->query("\r\n\t\t\tSELECT gmlevel, username \r\n\t\t\tFROM account \r\n\t\t\tWHERE id ='{$owner_acc_id}'");
        $owner_gmlvl = $sqlr->result($query, 0, 'gmlevel');
        $owner_name = $sqlr->result($query, 0, 'username');
        $owner_check = $sqlr->result($query, 0, 'username');
        if ($user_lvl >= $owner_gmlvl) {
            $result = $sqlc->query("\r\n\t\t\t\tSELECT c.guid, c.account, c.name, c.race, c.class, c.level, c.gender, c.online, c.money, c.totaltime,\r\n\t\t\t\t\tc.position_x, c.position_y, c.position_z, c.map, c.zone,\r\n\t\t\t\t\tc.totalHonorpoints, c.totalKills, c.arenaPoints, c.equipmentCache,\r\n\t\t\t\t\tCOALESCE(guild_member.guildid,0) AS guildid, COALESCE(guild_member.rank,0) AS grank\r\n\t\t\t\tFROM characters  c LEFT JOIN guild_member ON c.guid = guild_member.guid \r\n\t\t\t\tWHERE c.guid = '{$id}'");
            $char = $sqlc->fetch_assoc($result);
            $eq_data = explode(' ', $char['equipmentCache']);
            if ($char['online']) {
                $online = "<font class=\"error\">{$lang_char['online']}</font>{$lang_char['edit_offline_only_char']}";
            } else {
                $online = $lang_char['offline'];
            }
            if ($char['guildid']) {
                $query = $sqlc->query("\r\n\t\t\t\t\tSELECT name \r\n\t\t\t\t\tFROM guild \r\n\t\t\t\t\tWHERE guildid ='{$char['guildid']}'");
                $guild_name = $sqlc->result($query, 0, 'name');
                if ($user_lvl > 0) {
                    $guild_name = "<a href=\"guild.php?action=view_guild&amp;error=3&amp;id={$char['guildid']}\" >{$guild_name}</a>";
                }
                if ($char['grank']) {
                    $guild_rank_query = $sqlc->query("\r\n\t\t\t\t\t\tSELECT rname \r\n\t\t\t\t\t\tFROM guild_rank \r\n\t\t\t\t\t\tWHERE guildid ='{$char['guildid']}' AND rid='{$char['grank']}'");
                    $guild_rank = $sqlc->result($guild_rank_query, 0, 'rname');
                } else {
                    $guild_rank = $lang_char['guild_leader'];
                }
            } else {
                $guild_name = $lang_global['none'];
                $guild_rank = $lang_global['none'];
            }
            $output .= "\r\n                        <center>\r\n                            <form method=\"get\" action=\"char_edit.php\" name=\"form\">\r\n                                <input type=\"hidden\" name=\"action\" value=\"do_edit_char\" />\r\n                                <input type=\"hidden\" name=\"id\" value=\"{$id}\" />\r\n                                <table class=\"lined\">\r\n                                    <tr>\r\n                                        <td colspan=\"8\"><font class=\"bold\"><input type=\"text\" name=\"name\" size=\"14\" maxlength=\"12\" value=\"" . $char['name'] . "\" /> - <img src='img/c_icons/" . $char['race'] . "-" . $char['gender'] . ".gif' onmousemove='toolTip(\"" . char_get_race_name($char['race']) . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" /> <img src='img/c_icons/" . $char['class'] . ".gif' onmousemove='toolTip(\"" . char_get_class_name($char['class']) . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" /> - lvl " . char_get_level_color($char['level']) . "</font><br />" . $online . "</td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td colspan=\"8\">" . get_map_name($char['online'], $sqlm) . " - " . get_zone_name($char['zone'], $sqlm) . "</td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td colspan=\"8\">{$lang_char['username']}: <input type=\"text\" name=\"owner_name\" size=\"20\" maxlength=\"25\" value=\"{$owner_name}\" /> | {$lang_char['acc_id']}: {$owner_acc_id}</td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td colspan=\"8\">{$lang_char['guild']}: {$guild_name} | {$lang_char['rank']}: {$guild_rank}</td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td colspan=\"8\">{$lang_char['honor_points']}: <input type=\"text\" name=\"honor_points\" size=\"8\" maxlength=\"6\" value=\"{$char['totalHonorpoints']}\" />/\r\n                                            <input type=\"text\" name=\"arena_points\" size=\"8\" maxlength=\"6\" value=\"{$char['arenaPoints']}\" /> - {$lang_char['honor_kills']}: <input type=\"text\" name=\"total_kills\" size=\"8\" maxlength=\"6\" value=\"{$char['totalKills']}\" />\r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td width=\"2%\"><input type=\"checkbox\" name=\"check[]\" value=\"a0\" /></td><td width=\"18%\">{$lang_item['head']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_HEAD]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_HEAD]) . "</a></td>\r\n                                        <td width=\"18%\">{$lang_item['gloves']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_GLOVES]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_GLOVES]) . "</a></td><td width=\"2%\"><input type=\"checkbox\" name=\"check[]\" value=\"a9\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a1\" /></td><td>{$lang_item['neck']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_NECK]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_NECK]) . "</a></td>\r\n                                        <td>{$lang_item['belt']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_BELT]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_BELT]) . "</a></td> <td><input type=\"checkbox\" name=\"check[]\" value=\"a5\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a2\" /></td><td>{$lang_item['shoulder']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_SHOULDER]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_SHOULDER]) . "</a></td>\r\n                                        <td>{$lang_item['legs']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_LEGS]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_LEGS]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a6\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a14\" /></td><td>{$lang_item['back']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_BACK]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_BACK]) . "</a></td>\r\n                                        <td>{$lang_item['feet']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_FEET]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_FEET]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a7\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a4\" /></td><td>{$lang_item['chest']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_CHEST]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_CHEST]) . "</a></td>\r\n                                        <td>{$lang_item['finger']} 1<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_FINGER1]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_FINGER1]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a10\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a3\" /></td><td>{$lang_item['shirt']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_SHIRT]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_SHIRT]) . "</a></td>\r\n                                        <td>{$lang_item['finger']} 2<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_FINGER2]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_FINGER2]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a11\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a18\" /></td><td>{$lang_item['tabard']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_TABARD]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_TABARD]) . "</a></td>\r\n                                        <td>{$lang_item['trinket']} 1<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_TRINKET1]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_TRINKET1]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a12\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a8\" /></td><td>{$lang_item['wrist']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_WRIST]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_WRIST]) . "</a></td>\r\n                                        <td>{$lang_item['trinket']} 2<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_TRINKET2]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_TRINKET2]) . "</a></td><td><input type=\"checkbox\" name=\"check[]\" value=\"a13\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a15\" /></td>\r\n                                        <td colspan=\"2\">{$lang_item['main_hand']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_MAIN_HAND]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_MAIN_HAND]) . "</a></td>\r\n                                        <td colspan=\"2\"><input type=\"checkbox\" name=\"check[]\" value=\"a16\" />&nbsp;{$lang_item['off_hand']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_OFF_HAND]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_OFF_HAND]) . "</a></td>\r\n                                        <td colspan=\"2\">{$lang_item['ranged']}<br /><a href=\"{$item_datasite}{$eq_data[EQ_DATA_OFFSET_EQU_RANGED]}\" target=\"_blank\">" . get_item_name($eq_data[EQ_DATA_OFFSET_EQU_RANGED]) . "</a></td>\r\n                                        <td><input type=\"checkbox\" name=\"check[]\" value=\"a17\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td colspan=\"4\">{$lang_char['gold']}: <input type=\"text\" name=\"money\" size=\"10\" maxlength=\"8\" value=\"{$char['money']}\" /></td>\r\n                                        <td colspan=\"4\">{$lang_char['tot_paly_time']}: <input type=\"text\" name=\"tot_time\" size=\"8\" maxlength=\"14\" value=\"{$char['totaltime']}\" /></td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td colspan=\"5\">{$lang_char['location']}:\r\n                                            X:<input type=\"text\" name=\"x\" size=\"10\" maxlength=\"8\" value=\"{$char['position_x']}\" />\r\n                                            Y:<input type=\"text\" name=\"y\" size=\"8\" maxlength=\"16\" value=\"{$char['position_y']}\" />\r\n                                            Z:<input type=\"text\" name=\"z\" size=\"8\" maxlength=\"16\" value=\"{$char['position_z']}\" />\r\n                                            Map:<input type=\"text\" name=\"map\" size=\"8\" maxlength=\"16\" value=\"{$char['map']}\" />\r\n                                        </td>\r\n                                        <td colspan=\"3\">{$lang_char['move_to']}:<input type=\"text\" name=\"tp_to\" size=\"24\" maxlength=\"64\" value=\"\" /></td>\r\n                                    </tr>\r\n                                </table>\r\n                                <br />";
            //inventory+bank items
            $query2 = $sqlc->query("\r\n\t\t\t\tSELECT bag, slot, item, item_template \r\n\t\t\t\tFROM character_inventory \r\n\t\t\t\tWHERE guid = '{$id}' \r\n\t\t\t\tORDER BY bag, slot");
            $inv = array();
            $count = 0;
            while ($slot = $sqlc->fetch_row($query2)) {
                if ($slot[0] == 0) {
                    if ($slot[1] >= 23 && $slot[1] <= 62) {
                        $count++;
                        $inv[$count][0] = $slot[3];
                        $inv[$count][1] = $slot[2];
                    }
                } else {
                    $count++;
                    $inv[$count][0] = $slot[3];
                    $inv[$count][1] = $slot[2];
                }
            }
            $output .= "\r\n                                <table class=\"lined\">\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td>{$lang_char['inv_bank']}</td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td height=\"100\" align=\"center\">\r\n\t\t\t\t\t\t\t\t\t\t\t<table>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr align=\"center\">";
            $j = 0;
            for ($i = 1; $i <= $count; $i++) {
                $j++;
                $output .= "\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$inv[$i][0]}\" target=\"_blank\">{$inv[$i][0]}</a>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br />\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"{$inv[$i][1]}\" />\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t</td>";
                if ($j == 15) {
                    $output .= "\r\n\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<tr align=\"center\">";
                    $j = 0;
                }
            }
            $output .= "\r\n                                                </tr>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                                <br />\r\n                                <table class=\"hidden\">\r\n                                    <tr>\r\n                                        <td>";
            makebutton($lang_char['update'], "javascript:do_submit()", 190);
            makebutton($lang_char['to_char_view'], "char.php?id={$id}", 160);
            makebutton($lang_char['del_char'], "char_list.php?action=del_char_form&amp;check%5B%5D={$id}", 160);
            makebutton($lang_global['back'], "javascript:window.history.back()", 160);
            $output .= "\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                                <br />\r\n                            </form>\r\n                        </center>";
            //case of non auth request
        } else {
            error($lang_char['no_permission']);
        }
    } else {
        error($lang_char['no_char_found']);
    }
}

예제 #7

파일: creature.php 프로젝트: BACKUPLIB/minimanager

function do_insert_update($do_insert)
{
    global $lang_global, $lang_creature, $output, $world_db, $realm_id, $creature_datasite, $item_datasite, $quest_datasite, $lang_id_tab, $spell_datasite, $lang_item, $language, $action_permission, $user_lvl, $locales_search_option;
    wowhead_tt();
    require_once "./scripts/get_lib.php";
    require_once 'libs/item_lib.php';
    $sql = new SQL();
    $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
    // entry only needed on update
    if (!$do_insert) {
        if (!isset($_GET['entry'])) {
            redirect("creature.php?error=1");
        }
        $entry = is_numeric($_GET['entry']) ? $sql->quote_smart($_GET['entry']) : redirect("creature.php?error=8");
        $result = $sql->query("SELECT `entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`,`subname`, `IconName`, `minlevel`, `maxlevel`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`,`dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`,`trainer_race`,`minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`,`type_flags`,`lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName` FROM creature_template WHERE entry = '{$entry}'");
    } else {
        // get new free id
        $result = $sql->query("SELECT max(entry)+1 as newentry from creature_template");
        $entry = $sql->result($result, 0, 'newentry');
        $result = $sql->query("SELECT {$entry} as `entry`, 0 as `difficulty_entry_1`, 0 as `KillCredit1`, 0 as `KillCredit2`, 0 as `modelid1`, 0 as `modelid2`, 0 as `modelid3`, 0 as `modelid4`, 'new creature' as `name`,'' as `subname`, '' as `IconName`, 1 as `minlevel`, 1 as `maxlevel`, 0 as `faction_A`, 0 as `faction_H`, 0 as `npcflag`, 1 as `speed`, 1 as `scale`,0 as `rank`, 1 as `mindmg`, 1 as `maxdmg`, 0 as `dmgschool`, 0 as `attackpower`, 2000 as `baseattacktime`, 0 as `rangeattacktime`, 0 as `unit_flags`,0 as `dynamicflags`, 0 as `family`, 0 as `trainer_type`, 0 as `trainer_spell`, 0 as `trainer_class`,0 as `trainer_race`,0 as `minrangedmg`, 0 as `maxrangedmg`, 0 as `rangedattackpower`, 0 as `type`,0 as `type_flags`,0 as `lootid`, 0 as `pickpocketloot`, 0 as `skinloot`, 0 as `resistance1`, 0 as `resistance2`, 0 as `resistance3`, 0 as `resistance4`, 0 as `resistance5`, 0 as `resistance6`, 0 as`spell1`, 0 as`spell2`, 0 as `spell3`, 0 as `spell4`, 0 as `PetSpellDataId`, 100 as `mingold`, 250 as `maxgold`, '' as `AIName`, 0 as `MovementType`, 1 as `InhabitType`, 0 as `RacialLeader`, 1 as `RegenHealth`, 0 as `equipment_id`, 0 as `mechanic_immune_mask`, 0 as `flags_extra`, '' as `ScriptName`");
        // use id for new creature_template
    }
    if ($mob = $sql->fetch_assoc($result)) {
        $output .= "\r\n                <script type=\"text/javascript\" src=\"libs/js/tab.js\"></script>\r\n                <center>\r\n                <br /><br /><br />\r\n                    <form method=\"post\" action=\"creature.php?action=do_update\" name=\"form1\">\r\n                        <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>\r\n                        <input type=\"hidden\" name=\"entry\" value=\"{$entry}\"/>\r\n                        <input type=\"hidden\" name=\"insert\" value=\"{$do_insert}\"/>\r\n                        <div class=\"jtab-container\" id=\"container\">\r\n                            <ul class=\"jtabs\">\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_creature['general']}</a></li>\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_creature['stats']}</a></li>\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_creature['models']}</a></li>\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_creature['additional']}</a></li>";
        $quest_flag = 0;
        $vendor_flag = 0;
        $trainer_flag = 0;
        if (!$mob['npcflag']) {
            $output .= "";
        } else {
            if ($mob['npcflag'] & 1) {
                $output .= "";
            }
            //gossip
            if ($mob['npcflag'] & 2) {
                $quest_flag = 1;
                $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane6', this)\">{$lang_creature['quests']}</a></li>";
            }
            if ($mob['npcflag'] & 4) {
                $vendor_flag = 1;
                $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_creature['vendor']}</a></li>";
            }
            if ($mob['npcflag'] & 16) {
                $trainer_flag = 1;
                $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane8', this)\">{$lang_creature['trainer']}</a></li>";
            }
        }
        if ($mob['npcflag'] & 128) {
            $vendor_flag = 1;
            $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_creature['vendor']}</a></li>";
        }
        if ($mob['npcflag'] & 16384) {
            $vendor_flag = 1;
            $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_creature['vendor']}</a></li>";
        }
        if ($mob['lootid']) {
            $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane5', this)\">{$lang_creature['loot']}</a></li>";
        }
        if ($mob['skinloot']) {
            $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane9', this)\">{$lang_creature['skin_loot']}</a></li>";
        }
        if ($mob['pickpocketloot']) {
            $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane10', this)\">{$lang_creature['pickpocket_loot']}</a></li>";
        }
        if ($locales_search_option != 0) {
            $output .= "\r\n                                <li><a href=\"#\" onclick=\"return showPane('pane11', this)\">{$lang_creature['locales']}</a></li>";
        }
        $output .= "\r\n                            </ul>\r\n                            <div class=\"jtab-panes\">\r\n                                <div id=\"pane1\">\r\n                                    <br /><br />\r\n                                    <table class=\"lined\" style=\"width: 720px;\">\r\n                                        <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['general']}:</td></tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['entry'], $lang_creature['entry_desc']) . "</td>\r\n                                            <td>\r\n                                                <a href=\"{$creature_datasite}{$entry}\" target=\"_blank\">{$entry}</a>\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                            <td colspan=\"3\">\r\n                                                <input type=\"text\" name=\"name\" size=\"50\" maxlength=\"100\" value=\"{$mob['name']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"subname\" size=\"25\" maxlength=\"100\" value=\"{$mob['subname']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['script_name'], $lang_creature['script_name_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"ScriptName\" size=\"25\" maxlength=\"128\" value=\"{$mob['ScriptName']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['basic_status']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['heroic'], $lang_creature['heroic_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"difficulty_entry_1\" size=\"8\" maxlength=\"3\" value=\"{$mob['difficulty_entry_1']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['min_level'], $lang_creature['min_level_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"minlevel\" size=\"8\" maxlength=\"3\" value=\"{$mob['minlevel']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['max_level'], $lang_creature['max_level_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"maxlevel\" size=\"8\" maxlength=\"3\" value=\"{$mob['maxlevel']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>&nbsp;</td>\r\n                                            <td>\r\n                                                &nbsp;\r\n                                            </td>\r\n                                            <td>&nbsp;</td>\r\n                                            <td>\r\n                                                &nbsp;\r\n                                            </td>";
        if ($mob['RegenHealth']) {
            $RegenHealth = "checked";
        } else {
            $RegenHealth = "";
        }
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['RegenHealth'], $lang_creature['RegenHealth']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"checkbox\" name=\"RegenHealth\" value=\"1\" {$RegenHealth} />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['faction_A'], $lang_creature['faction_A_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"faction_A\" size=\"14\" maxlength=\"10\" value=\"{$mob['faction_A']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['faction_H'], $lang_creature['faction_H_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"faction_H\" size=\"14\" maxlength=\"10\" value=\"{$mob['faction_H']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>";
        $rank = array(0 => "", 1 => "", 3 => "", 2 => "", 4 => "");
        $rank[$mob['rank']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td >" . makeinfocell($lang_creature['rank'], $lang_creature['rank_desc']) . "</td>\r\n                                            <td>\r\n                                                <select name=\"rank\">\r\n                                                    <option value=\"0\" {$rank[0]}>0 - {$lang_creature['normal']}</option>\r\n                                                    <option value=\"1\" {$rank[1]}>1 - {$lang_creature['elite']}</option>\r\n                                                    <option value=\"2\" {$rank[2]}>2 - {$lang_creature['rare_elite']}</option>\r\n                                                    <option value=\"3\" {$rank[3]}>3 - {$lang_creature['world_boss']}</option>\r\n                                                    <option value=\"4\" {$rank[4]}>4 - {$lang_creature['rare']}</option>\r\n                                                </select>\r\n                                            </td>";
        unset($rank);
        $type = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "");
        $type[$mob['type']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td colspan=\"2\">" . makeinfocell($lang_creature['type'], $lang_creature['type_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <select name=\"type\">\r\n                                                    <option value=\"0\" {$type[0]}>0 - {$lang_creature['other']}</option>\r\n                                                    <option value=\"1\" {$type[1]}>1 - {$lang_creature['beast']}</option>\r\n                                                    <option value=\"2\" {$type[2]}>2 - {$lang_creature['dragonkin']}</option>\r\n                                                    <option value=\"3\" {$type[3]}>3 - {$lang_creature['demon']}</option>\r\n                                                    <option value=\"4\" {$type[4]}>4 - {$lang_creature['elemental']}</option>\r\n                                                    <option value=\"5\" {$type[5]}>5 - {$lang_creature['giant']}</option>\r\n                                                    <option value=\"6\" {$type[6]}>6 - {$lang_creature['undead']}</option>\r\n                                                    <option value=\"7\" {$type[7]}>7 - {$lang_creature['humanoid']}</option>\r\n                                                    <option value=\"8\" {$type[8]}>8 - {$lang_creature['critter']}</option>\r\n                                                    <option value=\"9\" {$type[9]}>9 - {$lang_creature['mechanical']}</option>\r\n                                                    <option value=\"10\" {$type[10]}>10 - {$lang_creature['not_specified']}</option>\r\n                                                </select>\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>";
        unset($type);
        $npcflag = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "", 1024 => "", 2048 => "", 4096 => "", 8192 => "", 16384 => "", 65536 => "", 131072 => "", 262144 => "", 524288 => "", 1048576 => "", 2097152 => "", 4194304 => "", 268435456 => "");
        if ($mob['npcflag'] == 0) {
            $npcflag[0] = " selected=\"selected\" ";
        } else {
            if ($mob['npcflag'] & 1) {
                $npcflag[1] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 2) {
                $npcflag[2] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 4) {
                $npcflag[4] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 8) {
                $npcflag[8] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 16) {
                $npcflag[16] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 32) {
                $npcflag[32] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 64) {
                $npcflag[64] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 128) {
                $npcflag[128] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 256) {
                $npcflag[256] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 512) {
                $npcflag[512] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 1024) {
                $npcflag[1024] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 2048) {
                $npcflag[2048] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 4096) {
                $npcflag[4096] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 8192) {
                $npcflag[8192] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 16384) {
                $npcflag[16384] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 65536) {
                $npcflag[65536] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 131072) {
                $npcflag[131072] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 262144) {
                $npcflag[262144] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 524288) {
                $npcflag[524288] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 1048576) {
                $npcflag[1048576] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 2097152) {
                $npcflag[2097152] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 4194304) {
                $npcflag[4194304] = " selected=\"selected\" ";
            }
            if ($mob['npcflag'] & 268435456) {
                $npcflag[268435456] = " selected=\"selected\" ";
            }
        }
        $output .= "\r\n                                            <td rowspan=\"2\">" . makeinfocell($lang_creature['npc_flag'], $lang_creature['npc_flag_desc']) . "</td>\r\n                                            <td colspan=\"2\" rowspan=\"2\">\r\n                                                <select multiple=\"multiple\" name=\"npcflag[]\" size=\"3\">\r\n                                                    <option value=\"0\" {$npcflag[0]}>{$lang_creature['none']}</option>\r\n                                                    <option value=\"1\" {$npcflag[1]}>{$lang_creature['gossip']}</option>\r\n                                                    <option value=\"2\" {$npcflag[2]}>{$lang_creature['quest_giver']}</option>\r\n                                                    <option value=\"4\" {$npcflag[4]}>{$lang_creature['vendor']}</option>\r\n                                                    <option value=\"8\" {$npcflag[8]}>{$lang_creature['taxi']}</option>\r\n                                                    <option value=\"16\" {$npcflag[16]}>{$lang_creature['trainer']}</option>\r\n                                                    <option value=\"32\" {$npcflag[32]}>{$lang_creature['spirit_healer']}</option>\r\n                                                    <option value=\"64\" {$npcflag[64]}>{$lang_creature['guard']}</option>\r\n                                                    <option value=\"128\" {$npcflag[128]}>{$lang_creature['inn_keeper']}</option>\r\n                                                    <option value=\"256\" {$npcflag[256]}>{$lang_creature['banker']}</option>\r\n                                                    <option value=\"512\" {$npcflag[512]}>{$lang_creature['retitioner']}</option>\r\n                                                    <option value=\"1024\" {$npcflag[1024]}>{$lang_creature['tabard_vendor']}</option>\r\n                                                    <option value=\"2048\" {$npcflag[2048]}>{$lang_creature['battlemaster']}</option>\r\n                                                    <option value=\"4096\" {$npcflag[4096]}>{$lang_creature['auctioneer']}</option>\r\n                                                    <option value=\"8192\" {$npcflag[8192]}>{$lang_creature['stable_master']}</option>\r\n                                                    <option value=\"16384\" {$npcflag[16384]}>{$lang_creature['armorer']}</option>\r\n                                                </select>\r\n                                            </td>";
        unset($npcflag);
        $trainer_type = array(0 => "", 1 => "", 2 => "", 3 => "");
        $trainer_type[$mob['trainer_type']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['trainer_type'], $lang_creature['trainer_type_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <select name=\"trainer_type\">\r\n                                                    <option value=\"0\" {$trainer_type[0]}>0 - {$lang_creature['class']}</option>\r\n                                                    <option value=\"1\" {$trainer_type[1]}>1 - {$lang_creature['mounts']}</option>\r\n                                                    <option value=\"2\" {$trainer_type[2]}>2 - {$lang_creature['trade_skill']}</option>\r\n                                                    <option value=\"3\" {$trainer_type[3]}>3 - {$lang_creature['pets']}</option>\r\n                                                </select>\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>";
        unset($trainer_type);
        $family = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => "", 21 => "", 22 => "", 23 => "", 24 => "", 25 => "", 26 => "", 27 => "");
        $family[$mob['family']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['family'], $lang_creature['family_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <select name=\"family\">\r\n                                                    <option value=\"0\" {$family[0]}>0 - {$lang_creature['other']}</option>\r\n                                                    <option value=\"1\" {$family[1]}>1 - {$lang_creature['wolf']}</option>\r\n                                                    <option value=\"2\" {$family[2]}>2 - {$lang_creature['cat']}</option>\r\n                                                    <option value=\"3\" {$family[3]}>3 - {$lang_creature['spider']}</option>\r\n                                                    <option value=\"4\" {$family[4]}>4 - {$lang_creature['bear']}</option>\r\n                                                    <option value=\"5\" {$family[5]}>5 - {$lang_creature['boar']}</option>\r\n                                                    <option value=\"6\" {$family[6]}>6 - {$lang_creature['crocolisk']}</option>\r\n                                                    <option value=\"7\" {$family[7]}>7 - {$lang_creature['carrion_bird']}</option>\r\n                                                    <option value=\"8\" {$family[8]}>8 - {$lang_creature['crab']}</option>\r\n                                                    <option value=\"9\" {$family[9]}>9 - {$lang_creature['gorilla']}</option>\r\n                                                    <option value=\"11\" {$family[11]}>11 - {$lang_creature['raptor']}</option>\r\n                                                    <option value=\"12\" {$family[12]}>12 - {$lang_creature['tallstrider']}</option>\r\n                                                    <option value=\"13\" {$family[13]}>13 - {$lang_creature['other']}</option>\r\n                                                    <option value=\"14\" {$family[14]}>14 - {$lang_creature['other']}</option>\r\n                                                    <option value=\"15\" {$family[15]}>15 - {$lang_creature['felhunter']}</option>\r\n                                                    <option value=\"16\" {$family[16]}>16 - {$lang_creature['voidwalker']}</option>\r\n                                                    <option value=\"17\" {$family[17]}>17 - {$lang_creature['succubus']}</option>\r\n                                                    <option value=\"18\" {$family[18]}>18 - {$lang_creature['other']}</option>\r\n                                                    <option value=\"19\" {$family[19]}>19 - {$lang_creature['doomguard']}</option>\r\n                                                    <option value=\"20\" {$family[20]}>20 - {$lang_creature['scorpid']}</option>\r\n                                                    <option value=\"21\" {$family[21]}>21 - {$lang_creature['turtle']}</option>\r\n                                                    <option value=\"22\" {$family[22]}>22 - {$lang_creature['scorpid']}</option>\r\n                                                    <option value=\"23\" {$family[23]}>23 - {$lang_creature['imp']}</option>\r\n                                                    <option value=\"24\" {$family[24]}>24 - {$lang_creature['bat']}</option>\r\n                                                    <option value=\"25\" {$family[25]}>25 - {$lang_creature['hyena']}</option>\r\n                                                    <option value=\"26\" {$family[26]}>26 - {$lang_creature['owl']}</option>\r\n                                                    <option value=\"27\" {$family[27]}>27 - {$lang_creature['wind_serpent']}</option>\r\n                                                </select>\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['loot']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['loot_id'], $lang_creature['loot_id_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"lootid\" size=\"10\" maxlength=\"10\" value=\"{$mob['lootid']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['skin_loot'], $lang_creature['skin_loot_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"skinloot\" size=\"10\" maxlength=\"10\" value=\"{$mob['skinloot']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['pickpocket_loot'], $lang_creature['pickpocket_loot_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"pickpocketloot\" size=\"10\" maxlength=\"10\" value=\"{$mob['pickpocketloot']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['min_gold'], $lang_creature['min_gold_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"mingold\" size=\"14\" maxlength=\"30\" value=\"{$mob['mingold']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['max_gold'], $lang_creature['max_gold_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"maxgold\" size=\"14\" maxlength=\"30\" value=\"{$mob['maxgold']}\" />\r\n                                            </td>\r\n                                        </tr>";
        unset($family);
        $result1 = $sql->query("SELECT COUNT(*) FROM creature WHERE id = '{$mob['entry']}'");
        $output .= "\r\n                                        <tr>\r\n                                            <td colspan=\"6\">{$lang_creature['creature_swapned']} : " . $sql->result($result1, 0) . " {$lang_creature['times']}.</td>\r\n                                        </tr>\r\n                                    </table>\r\n                                    <br /><br />\r\n                                </div>\r\n                                <div id=\"pane3\">\r\n                                    <br /><br />\r\n                                    <table class=\"lined\" style=\"width: 720px;\">\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['basic_status']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>&nbsp;</td>\r\n                                            <td colspan=\"2\">\r\n                                                &nbsp;\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['speed'], $lang_creature['speed_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"speed_walk\" size=\"8\" maxlength=\"45\" value=\"{$mob['speed_walk']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['damage']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['min_damage'], $lang_creature['min_damage_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"mindmg\" size=\"8\" maxlength=\"45\" value=\"{$mob['mindmg']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['max_damage'], $lang_creature['max_damage_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"maxdmg\" size=\"8\" maxlength=\"45\" value=\"{$mob['maxdmg']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['attack_power'], $lang_creature['attack_power_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"attackpower\" size=\"8\" maxlength=\"10\" value=\"{$mob['attackpower']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['min_range_dmg'], $lang_creature['min_range_dmg_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"minrangedmg\" size=\"8\" maxlength=\"45\" value=\"{$mob['minrangedmg']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['max_range_dmg'], $lang_creature['max_range_dmg_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"maxrangedmg\" size=\"8\" maxlength=\"45\" value=\"{$mob['maxrangedmg']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['ranged_attack_power'], $lang_creature['ranged_attack_power_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"rangedattackpower\" size=\"8\" maxlength=\"10\" value=\"{$mob['rangedattackpower']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['attack_time'], $lang_creature['attack_time_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"baseattacktime\" size=\"8\" maxlength=\"4\" value=\"{$mob['baseattacktime']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['range_attack_time'], $lang_creature['range_attack_time_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"rangeattacktime\" size=\"8\" maxlength=\"4\" value=\"{$mob['rangeattacktime']}\" />\r\n                                            </td>\r\n                                            <td></td>\r\n                                            <td></td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td></td>\r\n                                            <td colspan=\"2\"></td>";
        $dmgschool = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "");
        $dmgschool[$mob['dmgschool']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['dmgschool'], $lang_creature['dmgschool_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <select name=\"dmgschool\">\r\n                                                    <option value=\"0\" {$dmgschool[0]}>0: {$lang_item['physical_dmg']}</option>\r\n                                                    <option value=\"1\" {$dmgschool[1]}>1: {$lang_item['holy_dmg']}</option>\r\n                                                    <option value=\"2\" {$dmgschool[2]}>2: {$lang_item['fire_dmg']}</option>\r\n                                                    <option value=\"3\" {$dmgschool[3]}>3: {$lang_item['nature_dmg']}</option>\r\n                                                    <option value=\"4\" {$dmgschool[4]}>4: {$lang_item['frost_dmg']}</option>\r\n                                                    <option value=\"5\" {$dmgschool[5]}>5: {$lang_item['shadow_dmg']}</option>\r\n                                                    <option value=\"6\" {$dmgschool[6]}>6: {$lang_item['arcane_dmg']}</option>\r\n                                                </select>\r\n                                            </td>";
        unset($dmgschool);
        $output .= "\r\n                                        </tr>\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['spells']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['spell'] . " 1", $lang_creature['spell_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"spell1\" size=\"14\" maxlength=\"11\" value=\"{$mob['spell1']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['spell'] . " 2", $lang_creature['spell_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"spell2\" size=\"14\" maxlength=\"11\" value=\"{$mob['spell2']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['spell'] . " 3", $lang_creature['spell_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"spell3\" size=\"14\" maxlength=\"11\" value=\"{$mob['spell3']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['spell'] . " 4", $lang_creature['spell_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"spell4\" size=\"14\" maxlength=\"11\" value=\"{$mob['spell4']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['resistances']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['resis_holy'], $lang_creature['resis_holy_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"resistance1\" size=\"8\" maxlength=\"10\" value=\"{$mob['resistance1']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['resis_fire'], $lang_creature['resis_fire_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"resistance2\" size=\"8\" maxlength=\"10\" value=\"{$mob['resistance2']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['resis_nature'], $lang_creature['resis_nature_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"resistance3\" size=\"8\" maxlength=\"10\" value=\"{$mob['resistance3']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['resis_frost'], $lang_creature['resis_frost_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"resistance4\" size=\"8\" maxlength=\"10\" value=\"{$mob['resistance4']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['resis_shadow'], $lang_creature['resis_shadow_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"resistance5\" size=\"8\" maxlength=\"10\" value=\"{$mob['resistance5']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['resis_arcane'], $lang_creature['resis_arcane_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"resistance6\" size=\"8\" maxlength=\"10\" value=\"{$mob['resistance6']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                    </table>\r\n                                    <br /><br />\r\n                                </div>\r\n                                <div id=\"pane4\">\r\n                                    <br /><br />\r\n                                    <table class=\"lined\" style=\"width: 720px;\">\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['models']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td colspan=\"2\">" . makeinfocell($lang_creature['modelid_A'], $lang_creature['modelid_A_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"modelid1\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid1']}\" />\r\n                                            </td>\r\n                                            <td colspan=\"2\">" . makeinfocell($lang_creature['modelid_A2'], $lang_creature['modelid_A2_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"modelid2\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid2']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td colspan=\"2\">" . makeinfocell($lang_creature['modelid_H'], $lang_creature['modelid_H_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"modelid3\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid3']}\" />\r\n                                            </td>\r\n                                            <td colspan=\"2\">" . makeinfocell($lang_creature['modelid_H2'], $lang_creature['modelid_H2_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"modelid4\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid4']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                    </table>\r\n                                    <br /><br />";
        $result1 = $sql->query("SELECT * FROM creature_equip_template WHERE entry = '{$mob['equipment_id']}'");
        if ($mobequip = $sql->fetch_assoc($result1)) {
            $output .= "\r\n                                    <br /><br />\r\n                                    <table class=\"lined\" style=\"width: 720px;\">\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['equipment']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['equip_slot'] . " 1", $lang_creature['equip_slot1_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"equipslot1\" size=\"8\" maxlength=\"10\" value=\"{$mobequip['equipentry1']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['equip_slot'] . " 2", $lang_creature['equip_slot2_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"equipslot2\" size=\"8\" maxlength=\"10\" value=\"{$mobequip['equipentry2']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['equip_slot'] . " 3", $lang_creature['equip_slot3_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"equipslot3\" size=\"8\" maxlength=\"10\" value=\"{$mobequip['equipentry3']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                    </table>\r\n                                    <br /><br />\r\n                                </div>";
        } else {
            $output .= "\r\n                                    <br /><br />\r\n                                    <table class=\"lined\" style=\"width: 720px;\">\r\n                                        <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['equipment']}:</td></tr>\r\n                                    </table>\r\n                                    <br /><br />\r\n                                </div>";
        }
        $output .= "\r\n                                <div id=\"pane2\">\r\n                                <br /><br />\r\n                                    <table class=\"lined\" style=\"width: 720px;\">\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['scripts']}:</td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['ai_name'], $lang_creature['ai_name_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"AIName\" size=\"14\" maxlength=\"128\" value=\"{$mob['AIName']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['movement_type'], $lang_creature['movement_type_desc']) . "</td>\r\n                                            <td colspan=\"2\">\r\n                                                <input type=\"text\" name=\"MovementType\" size=\"14\" maxlength=\"24\" value=\"{$mob['MovementType']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr class=\"large_bold\">\r\n                                            <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['other']}:</td>\r\n                                        </tr>";
        $trainer_class = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 7 => "", 8 => "", 9 => "", 11 => "");
        $trainer_class[$mob['trainer_class']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['class'], $lang_creature['class_desc']) . "</td>\r\n                                            <td>\r\n                                                <select name=\"class\">\r\n                                                    <option value=\"0\" {$trainer_class[0]}>0 - {$lang_creature['none']}</option>\r\n                                                    <option value=\"1\" {$trainer_class[1]}>1 - {$lang_id_tab['warrior']}</option>\r\n                                                    <option value=\"2\" {$trainer_class[2]}>2 - {$lang_id_tab['paladin']}</option>\r\n                                                    <option value=\"3\" {$trainer_class[3]}>3 - {$lang_id_tab['hunter']}</option>\r\n                                                    <option value=\"4\" {$trainer_class[4]}>4 - {$lang_id_tab['rogue']}</option>\r\n                                                    <option value=\"5\" {$trainer_class[5]}>5 - {$lang_id_tab['priest']}</option>\r\n                                                    <option value=\"7\" {$trainer_class[7]}>7 - {$lang_id_tab['shaman']}</option>\r\n                                                    <option value=\"8\" {$trainer_class[8]}>8 - {$lang_id_tab['mage']}</option>\r\n                                                    <option value=\"9\" {$trainer_class[9]}>9 - {$lang_id_tab['warlock']}</option>\r\n                                                    <option value=\"11\" {$trainer_class[11]}>11 - {$lang_id_tab['druid']}</option>\r\n                                                </select>\r\n                                            </td>";
        unset($trainer_class);
        $trainer_race = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 10 => "", 11 => "");
        $trainer_race[$mob['trainer_race']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['race'], $lang_creature['race_desc']) . "</td>\r\n                                            <td>\r\n                                                <select name=\"race\">\r\n                                                    <option value=\"0\" {$trainer_race[0]}>0 - {$lang_creature['none']}</option>\r\n                                                    <option value=\"1\" {$trainer_race[1]}>1 - {$lang_id_tab['human']}</option>\r\n                                                    <option value=\"2\" {$trainer_race[2]}>2 - {$lang_id_tab['orc']}</option>\r\n                                                    <option value=\"3\" {$trainer_race[3]}>3 - {$lang_id_tab['dwarf']}</option>\r\n                                                    <option value=\"4\" {$trainer_race[4]}>4 - {$lang_id_tab['nightelf']}</option>\r\n                                                    <option value=\"5\" {$trainer_race[5]}>5 - {$lang_id_tab['undead']}</option>\r\n                                                    <option value=\"6\" {$trainer_race[6]}>6 - {$lang_id_tab['tauren']}</option>\r\n                                                    <option value=\"7\" {$trainer_race[7]}>7 - {$lang_id_tab['gnome']}</option>\r\n                                                    <option value=\"8\" {$trainer_race[8]}>8 - {$lang_id_tab['troll']}</option>\r\n                                                    <option value=\"10\" {$trainer_race[10]}>10 - {$lang_id_tab['bloodelf']}</option>\r\n                                                    <option value=\"11\" {$trainer_race[11]}>11 - {$lang_id_tab['draenei']}</option>\r\n                                                </select>\r\n                                            </td>";
        if ($mob['RacialLeader']) {
            $RacialLeader = "checked";
        } else {
            $RacialLeader = "";
        }
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['RacialLeader'], $lang_creature['RacialLeader_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"checkbox\" name=\"RacialLeader\" value=\"1\" {$RacialLeader} />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['trainer_spell'], $lang_creature['trainer_spell_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"trainer_spell\" size=\"14\" maxlength=\"11\" value=\"{$mob['trainer_spell']}\" />\r\n                                            </td>";
        unset($trainer_race);
        $InhabitType = array(0 => "", 1 => "", 2 => "", 3 => "");
        $InhabitType[$mob['InhabitType']] = " selected=\"selected\" ";
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['inhabit_type'], $lang_creature['inhabit_type_desc']) . "</td>\r\n                                            <td>\r\n                                                <select name=\"InhabitType\">\r\n                                                    <option value=\"0\" {$InhabitType[0]}>0 - {$lang_creature['none']}</option>\r\n                                                    <option value=\"1\" {$InhabitType[1]}>1 - {$lang_creature['walk']}</option>\r\n                                                    <option value=\"2\" {$InhabitType[2]}>2 - {$lang_creature['swim']}</option>\r\n                                                    <option value=\"3\" {$InhabitType[3]}>3 - {$lang_creature['both']}</option>\r\n                                                </select>\r\n                                            </td>";
        unset($InhabitType);
        $output .= "\r\n                                            <td>" . makeinfocell($lang_creature['flags_extra'], $lang_creature['flags_extra_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"flags_extra\" size=\"8\" maxlength=\"11\" value=\"{$mob['flags_extra']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        <tr>\r\n                                            <td>" . makeinfocell($lang_creature['unit_flags'], $lang_creature['flags_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"unit_flags\" size=\"8\" maxlength=\"11\" value=\"{$mob['unit_flags']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['dynamic_flags'], $lang_creature['dynamic_flags_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"dynamicflags\" size=\"8\" maxlength=\"11\" value=\"{$mob['dynamicflags']}\" />\r\n                                            </td>\r\n                                            <td>" . makeinfocell($lang_creature['flag_1'], $lang_creature['flag_1_desc']) . "</td>\r\n                                            <td>\r\n                                                <input type=\"text\" name=\"type_flags\" size=\"8\" maxlength=\"11\" value=\"{$mob['type_flags']}\" />\r\n                                            </td>\r\n                                        </tr>\r\n                                        </table>\r\n                                        <br /><br />\r\n                                    </div>";
        /*****************
           /  LOCALES
           *****************/
        if ($locales_search_option != 0) {
            if ($do_insert) {
                $result_loc = $sql->query("SELECT '' as `name_loc1`, '' as `name_loc2`, '' as `name_loc3`, '' as `name_loc4`, '' as `name_loc5`, '' as `name_loc6`, '' as `name_loc7`, '' as `name_loc8`, '' as `subname_loc1`, '' as `subname_loc2`, '' as `subname_loc3`, '' as `subname_loc4`, '' as `subname_loc5`, '' as `subname_loc6`, '' as `subname_loc7`, '' as `subname_loc8`");
            } else {
                // update
                $result_loc = $sql->query("SELECT `name_loc1`, `name_loc2`, `name_loc3`, `name_loc4`, `name_loc5`, `name_loc6`, `name_loc7`, `name_loc8`, `subname_loc1`, `subname_loc2`, `subname_loc3`, `subname_loc4`, `subname_loc5`, `subname_loc6`, `subname_loc7`, `subname_loc8` FROM `locales_creature` WHERE `entry` = '{$entry}'");
            }
            $loc = $sql->fetch_assoc($result_loc);
            $output .= "\r\n                                    <div id=\"pane11\">\r\n                                        <br /><br />\r\n                                        <table class=\"lined\" style=\"width: 720px;\">\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_1']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc1\" size=\"24\" maxlength=\"128\" value=\"{$loc['name_loc1']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc1\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc1']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_2']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc2\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc2']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc2\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc2']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_3']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc3\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc3']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc3\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc3']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_4']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc4\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc4']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc4\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc4']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_5']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc5\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc5']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc5\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc5']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_6']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc6\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc6']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc6\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc6']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_7']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc7\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc7']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc7\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc7']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_global['language_8']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['name'], $lang_creature['name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"name_loc8\" size=\"24\" maxlength=\"64\" value=\"{$loc['name_loc8']}\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['sub_name'], $lang_creature['sub_name_desc']) . "</td>\r\n                                                <td colspan=\"2\">\r\n                                                    <input type=\"text\" name=\"subname_loc8\" size=\"24\" maxlength=\"64\" value=\"{$loc['subname_loc8']}\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                        <br /><br />\r\n                                    </div>";
        }
        if ($mob['lootid']) {
            $output .= "\r\n                                    <div id=\"pane5\">\r\n                                        <br /><br />\r\n                                        <table class=\"lined\" style=\"width: 720px;\">\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['loot_tmpl_id']}: {$mob['lootid']}</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td colspan=\"6\">";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "\r\n                                                    <table class=\"hidden\" align=\"center\">\r\n                                                        <tr>";
            $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1,condition_value2 FROM creature_loot_template WHERE entry = {$mob['lootid']} ORDER BY ChanceOrQuestChance DESC");
            while ($item = $sql->fetch_row($result1)) {
                $cel_counter++;
                $tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_creature['drop_chance']}: {$item['1']}%<br />{$lang_creature['quest_drop_chance']}: {$item['2']}%<br />{$lang_creature['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_creature['lootcondition']}: {$item['5']}<br />{$lang_creature['condition_value1']}: {$item['6']}<br />{$lang_creature['condition_value2']}: {$item['7']}";
                $output .= "\r\n                                                            <td>";
                $output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
                $output .= "\r\n                                                                <br /><input type=\"checkbox\" name=\"del_loot_items[]\" value=\"{$item['0']}\" />\r\n                                                            </td>";
                if ($cel_counter >= 14) {
                    $cel_counter = 0;
                    $output .= "\r\n                                                        </tr>\r\n                                                        <tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "\r\n                                                            <td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "\r\n                                                        </tr>\r\n                                                    </table>\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['add_items_to_templ']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['loot_item_id'], $lang_creature['loot_item_id_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"item\" size=\"8\" maxlength=\"10\" value=\"\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['loot_drop_chance'], $lang_creature['loot_drop_chance_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['loot_quest_drop_chance'], $lang_creature['loot_quest_drop_chance_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"groupid\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['min_count'], $lang_creature['min_count_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['max_count'], $lang_creature['max_count_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td>" . makeinfocell($lang_creature['lootcondition'], $lang_creature['lootcondition_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['condition_value1'], $lang_creature['condition_value1_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                </td>\r\n                                                <td>" . makeinfocell($lang_creature['condition_value2'], $lang_creature['condition_value2_desc']) . "</td>\r\n                                                <td>\r\n                                                    <input type=\"text\" name=\"condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                        <br />{$lang_creature['check_to_delete']}<br /><br />\r\n                                    </div>";
        }
        if ($quest_flag) {
            $output .= "\r\n                                    <div id=\"pane6\">\r\n                                        <br /><br />\r\n                                        <table class=\"lined\" style=\"width: 720px;\">\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"2\" class=\"hidden\" align=\"left\">{$lang_creature['start_quests']}:</td>\r\n                                            </tr>";
            $deplang = get_lang_id();
            $result1 = $sql->query("SELECT quest FROM creature_questrelation WHERE id = {$mob['entry']}");
            while ($quest = $sql->fetch_row($result1)) {
                $query1 = $sql->query("SELECT QuestLevel,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='{$quest['0']}'");
                $quest_templ = $sql->fetch_row($query1);
                $output .= "\r\n                                            <tr>\r\n                                                <td width=\"5%\">\r\n                                                    <input type=\"checkbox\" name=\"del_questrelation[]\" value=\"{$quest['0']}\" />\r\n                                                </td>\r\n                                                <td width=\"95%\" align=\"left\">\r\n                                                    <a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest_templ[0]}) {$quest_templ['1']}</a>\r\n                                                </td>\r\n                                            </tr>";
            }
            $output .= "\r\n                                            <tr class=\"large_bold\" align=\"left\">\r\n                                                <td colspan=\"2\" class=\"hidden\">{$lang_creature['add_starts_quests']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td colspan=\"2\" align=\"left\">" . makeinfocell($lang_creature['quest_id'], $lang_creature['quest_id_desc']) . " :\r\n                                                    <input type=\"text\" name=\"questrelation\" size=\"8\" maxlength=\"8\" value=\"\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            <tr class=\"large_bold\">\r\n                                                <td colspan=\"2\" class=\"hidden\" align=\"left\">{$lang_creature['ends_quests']}:</td>\r\n                                            </tr>";
            $result1 = $sql->query("SELECT quest FROM creature_involvedrelation WHERE id = {$mob['entry']}");
            while ($quest = $sql->fetch_row($result1)) {
                $query1 = $sql->query("SELECT QuestLevel,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='{$quest['0']}'");
                $quest_templ = $sql->fetch_row($query1);
                $output .= "\r\n                                            <tr>\r\n                                                <td width=\"5%\">\r\n                                                    <input type=\"checkbox\" name=\"del_involvedrelation[]\" value=\"{$quest['0']}\" />\r\n                                                </td>\r\n                                                <td width=\"95%\" align=\"left\">\r\n                                                    <a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest_templ[0]}) {$quest_templ['1']}</a>\r\n                                                </td>\r\n                                            </tr>";
            }
            $output .= "\r\n                                            <tr class=\"large_bold\" align=\"left\">\r\n                                                <td colspan=\"2\" class=\"hidden\">{$lang_creature['add_ends_quests']}:</td>\r\n                                            </tr>\r\n                                            <tr>\r\n                                                <td colspan=\"2\" align=\"left\">" . makeinfocell($lang_creature['quest_id'], $lang_creature['quest_id_desc']) . " :\r\n                                                    <input type=\"text\" name=\"involvedrelation\" size=\"8\" maxlength=\"8\" value=\"\" />\r\n                                                </td>\r\n                                            </tr>\r\n                                            </table>\r\n                                            <br />{$lang_creature['check_to_delete']}<br /><br />\r\n                                        </div>";
        }
        if ($vendor_flag) {
            $output .= "\r\n                                        <div id=\"pane7\">\r\n                                            <br /><br />\r\n                                            <table class=\"lined\" style=\"width: 720px;\">\r\n                                                <tr class=\"large_bold\">\r\n                                                    <td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_creature['sells']}:</td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                </tr>\r\n                                                    <td colspan=\"8\">";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "\r\n                                                        <table class=\"hidden\" align=\"center\">\r\n                                                            <tr>";
            $result1 = $sql->query("SELECT item, maxcount, incrtime, ExtendedCost FROM npc_vendor WHERE entry = {$mob['entry']}");
            while ($item = $sql->fetch_row($result1)) {
                $cel_counter++;
                if (!$item[1]) {
                    $count = "{$lang_creature['unlimited']}";
                } else {
                    $count = $item[1];
                }
                $tooltip = get_item_name($item[0]) . "<br />{$lang_creature['count']} : {$count}<br />{$lang_creature['vendor_incrtime']} : {$item['2']}";
                $output .= "\r\n                                                                <td>";
                $output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
                $output .= "\r\n                                                                    <br />\r\n                                                                    <input type=\"checkbox\" name=\"del_vendor_item[]\" value=\"{$item['0']}\" />\r\n                                                                </td>";
                if ($cel_counter >= 14) {
                    $cel_counter = 0;
                    $output .= "\r\n                                                            </tr>\r\n                                                            <tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "\r\n                                                            </tr>\r\n                                                        </table>\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_creature['add_items_to_vendor']}:</td></tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['vendor_item_id'], $lang_creature['vendor_item_id_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"vendor_item\" size=\"8\" maxlength=\"10\" value=\"\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['vendor_max_count'], $lang_creature['vendor_max_count_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"vendor_maxcount\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['vendor_incrtime'], $lang_creature['vendor_incrtime_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"vendor_incrtime\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['vendor_extended_cost'], $lang_creature['vendor_extended_cost_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"vendor_extended_cost\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table><br />{$lang_creature['check_to_delete']}<br /><br />\r\n                                        </div>";
        }
        if ($trainer_flag) {
            $output .= "\r\n                                        <div id=\"pane8\">\r\n                                            <br /><br />\r\n                                            <table class=\"lined\" style=\"width: 720px;\">\r\n                                                <tr class=\"large_bold\">\r\n                                                    <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['trains']}:</td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td colspan=\"6\">";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "\r\n                                                        <table class=\"hidden\" align=\"center\">\r\n                                                            <tr>";
            $result1 = $sql->query("SELECT spell, spellcost, reqskill, reqskillvalue, reqlevel FROM npc_trainer WHERE entry = {$mob['entry']} ORDER BY reqlevel");
            while ($spell = $sql->fetch_row($result1)) {
                $cel_counter++;
                $tooltip = "{$lang_creature['spell_id']} : {$spell['0']}<br />{$lang_creature['cost']} :  {$spell['1']}(c)<br />{$lang_creature['req_skill']} : {$spell['2']}<br />{$lang_creature['req_skill_lvl']} :  {$spell['3']}<br />{$lang_creature['req_level']} {$spell['4']}";
                $output .= "\r\n                                                                <td>";
                $output .= maketooltip($spell[0], "{$spell_datasite}{$spell['0']}", $tooltip, "info_tooltip");
                $output .= "\r\n                                                                    <br /><input type=\"checkbox\" name=\"del_trainer_spell[]\" value=\"{$spell['0']}\" />\r\n                                                                </td>";
                if ($cel_counter >= 16) {
                    $cel_counter = 0;
                    $output .= "\r\n                                                            </tr>\r\n                                                            <tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "\r\n                                                                <td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "\r\n                                                            </tr>\r\n                                                        </table>\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['add_spell_to_trainer']}:</td></tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['train_spell_id'], $lang_creature['train_spell_id_desc']) . "</td>\r\n                                                    <td colspan=\"3\">\r\n                                                        <input type=\"text\" name=\"trainer_spell\" size=\"40\" maxlength=\"10\" value=\"\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['train_cost'], $lang_creature['train_cost_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"spellcost\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['req_skill'], $lang_creature['req_skill_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"reqskill\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['req_skill_value'], $lang_creature['req_skill_value_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"reqskillvalue\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['req_level'], $lang_creature['req_level_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"reqlevel\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                            <br />{$lang_creature['check_to_delete']}<br /><br />\r\n                                        </div>";
        }
        if ($mob['skinloot']) {
            $output .= "\r\n                                        <div id=\"pane9\">\r\n                                            <br /><br />\r\n                                            <table class=\"lined\" style=\"width: 720px;\">\r\n                                                <tr class=\"large_bold\">\r\n                                                    <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['skinning_loot_tmpl_id']}: {$mob['skinloot']}</td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td colspan=\"6\">";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "\r\n                                                        <table class=\"hidden\" align=\"center\">\r\n                                                            <tr>";
            $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1, condition_value2 FROM skinning_loot_template WHERE entry = {$mob['skinloot']} ORDER BY ChanceOrQuestChance DESC");
            while ($item = $sql->fetch_row($result1)) {
                $cel_counter++;
                $tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_creature['drop_chance']}: {$item['1']}%<br />{$lang_creature['quest_drop_chance']}: {$item['2']}%<br />{$lang_creature['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_creature['lootcondition']}: {$item['5']}<br />{$lang_creature['condition_value1']}: {$item['6']}<br />{$lang_creature['condition_value2']}: {$item['7']}";
                $output .= "\r\n                                                                <td>";
                $output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
                $output .= "\r\n                                                                    <br /><input type=\"checkbox\" name=\"del_skin_items[]\" value=\"{$item['0']}\" />\r\n                                                                </td>";
                if ($cel_counter >= 16) {
                    $cel_counter = 0;
                    $output .= "\r\n                                                            </tr>\r\n                                                            <tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "\r\n                                                                <td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "\r\n                                                            </tr>\r\n                                                        </table>\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['add_items_to_templ']}:</td></tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['loot_item_id'], $lang_creature['loot_item_id_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_item\" size=\"8\" maxlength=\"10\" value=\"\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['loot_drop_chance'], $lang_creature['loot_drop_chance_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['loot_quest_drop_chance'], $lang_creature['loot_quest_drop_chance_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['min_count'], $lang_creature['min_count_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['max_count'], $lang_creature['max_count_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['lootcondition'], $lang_creature['lootcondition_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['condition_value1'], $lang_creature['condition_value1_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['condition_value2'], $lang_creature['condition_value2_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"skin_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                            <br />{$lang_creature['check_to_delete']}<br /><br />\r\n                                        </div>";
        }
        if ($mob['pickpocketloot']) {
            $output .= "\r\n                                        <div id=\"pane10\">\r\n                                            <br /><br />\r\n                                            <table class=\"lined\" style=\"width: 720px;\">\r\n                                                <tr class=\"large_bold\">\r\n                                                    <td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['pickpocketloot_tmpl_id']}: {$mob['pickpocketloot']}</td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td colspan=\"6\">";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "\r\n                                                        <table class=\"hidden\" align=\"center\">\r\n                                                            <tr>";
            $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1, condition_value2 FROM pickpocketing_loot_template WHERE entry = {$mob['pickpocketloot']} ORDER BY ChanceOrQuestChance DESC");
            while ($item = $sql->fetch_row($result1)) {
                $cel_counter++;
                $tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_creature['drop_chance']}: {$item['1']}%<br />{$lang_creature['quest_drop_chance']}: {$item['2']}%<br />{$lang_creature['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_creature['lootcondition']}: {$item['5']}<br />{$lang_creature['condition_value1']}: {$item['6']}<br />{$lang_creature['condition_value2']}: {$item['7']}";
                $output .= "\r\n                                                                <td>";
                $output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
                $output .= "\r\n                                                                    <br /><input type=\"checkbox\" name=\"del_pp_items[]\" value=\"{$item['0']}\" />\r\n                                                                </td>";
                if ($cel_counter >= 16) {
                    $cel_counter = 0;
                    $output .= "\r\n                                                            </tr>\r\n                                                            <tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "\r\n                                                            </tr>\r\n                                                        </table>\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['add_items_to_templ']}:</td></tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['loot_item_id'], $lang_creature['loot_item_id_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_item\" size=\"8\" maxlength=\"10\" value=\"\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['loot_drop_chance'], $lang_creature['loot_drop_chance_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['loot_quest_drop_chance'], $lang_creature['loot_quest_drop_chance_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['min_count'], $lang_creature['min_count_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['max_count'], $lang_creature['max_count_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                                <tr>\r\n                                                    <td>" . makeinfocell($lang_creature['lootcondition'], $lang_creature['lootcondition_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['condition_value1'], $lang_creature['condition_value1_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                    <td>" . makeinfocell($lang_creature['condition_value2'], $lang_creature['condition_value2_desc']) . "</td>\r\n                                                    <td>\r\n                                                        <input type=\"text\" name=\"pp_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" />\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                            <br />{$lang_creature['check_to_delete']}<br /><br />\r\n                                        </div>";
        }
        $output .= "\r\n                                    </div>\r\n                                    </div>\r\n                                    <br />\r\n                                </form>\r\n                                <script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>\r\n                                <table class=\"hidden\">\r\n                                    <tr>\r\n                                        <td>";
        if ($do_insert) {
            if ($user_lvl >= $action_permission['insert'] && $do_insert) {
                makebutton($lang_creature['save_to_db'], "javascript:do_submit('form1',0)", 180);
            }
        } else {
            if ($user_lvl >= $action_permission['insert']) {
                makebutton($lang_creature['save_to_db'], "javascript:do_submit('form1',0)", 180);
            }
            if ($user_lvl >= $action_permission['delete']) {
                makebutton($lang_creature['del_creature'], "creature.php?action=delete&amp;entry={$entry}", 180);
            }
            if ($user_lvl >= $action_permission['delete']) {
                makebutton($lang_creature['del_spawns'], "creature.php?action=delete_spwn&amp;entry={$entry}", 180);
            }
        }
        // scripts/export should be okay without permission check
        makebutton($lang_creature['save_to_script'], "javascript:do_submit('form1',1)", 180);
        $output .= "\r\n                                        </td>\r\n                                    </tr>\r\n                                    <tr>\r\n                                        <td>";
        makebutton($lang_creature['lookup_creature'], "creature.php", 760);
        $output .= "\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </center>";
        $sql->close();
        unset($sql);
    } else {
        $sql->close();
        unset($sql);
        error($lang_creature['item_not_found']);
        exit;
    }
}

예제 #8

파일: mob_dba.php 프로젝트: nickjoker/ro_db

     	<table border="1" cellpadding="0" cellspacing="0">
        <tr>
        <td colspan="2">บอสไอเทม</td><td>เรท</td>
        </tr>
        <tr>
        <?php 
        for ($i = 1; $i < 3; $i++) {
            if ($row['Drop' . $i . 'id'] == 0) {
                continue;
            }
            ?>
        <td><img src="images/item/icons/<?php 
            echo $row['MVP' . $i . 'id'];
            ?>
.png"></td><td><?php 
            echo get_item_name($row['MVP' . $i . 'id']);
            ?>
</td><td><?php 
            echo percent($row['MVP' . $i . 'per']);
            ?>
</td>
        </tr>
        <?php 
        }
        ?>
        </table>
    	</td>
<?php 
    }
    ?>
    </tr>

예제 #9

파일: char_extra.php 프로젝트: BACKUPLIB/minimanager

function char_extra(&$sqlr, &$sqlc, &$sqlw)
{
    global $output, $lang_global, $lang_char, $realm_id, $characters_db, $world_db, $action_permission, $user_lvl, $user_name, $item_datasite;
    // this page uses wowhead tooltops
    wowhead_tt();
    require_once 'core/char/char_security.php';
    $result = $sqlc->query('SELECT account, name, race, class, gender, level
                            FROM characters
                            WHERE guid = ' . $id . ' LIMIT 1');
    if ($sqlc->num_rows($result)) {
        $char = $sqlc->fetch_assoc($result);
        $owner_acc_id = $sqlc->result($result, 0, 'account');
        $result = $sqlr->query('SELECT `username`, `gmlevel` FROM `account` LEFT JOIN `account_access` ON `account`.`id`=`account_access`.`id` WHERE `account`.`id` = ' . $owner_acc_id . ' ORDER BY `gmlevel` DESC LIMIT 1');
        $owner_name = $sqlr->result($result, 0, 'username');
        $owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
        if (empty($owner_gmlvl)) {
            $owner_gmlvl = 0;
        }
        if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
            $output .= '
            <center>
                <div id="tab_content">
                    <h1>' . $lang_char['extra'] . '</h1>
                    <br />';
            require_once 'core/char/char_header.php';
            //---------------Page Specific Data Starts Here--------------------------
            $output .= '
                    <br /><br />
                    <table class="lined" style="width: 450px;">
                        <tr>
                            <th width="15%">' . $lang_char['icon'] . '</th>
                            <th width="15%">' . $lang_char['quantity'] . '</th>
                            <th width="70%">' . $lang_char['name'] . '</th>
                        </tr>';
            $sqlw = new SQL();
            $sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
            $result = $sqlw->query('SELECT entry, description FROM item_template WHERE BagFamily = 8192');
            while ($bag = $sqlw->fetch_assoc($result)) {
                $result_2 = $sqlc->query('SELECT guid as item, itemEntry FROM item_instance WHERE owner_guid = ' . $id . ' AND itemEntry = ' . $bag['entry'] . ' ');
                while ($char = $sqlc->fetch_assoc($result_2)) {
                    $result_3 = $sqlc->query('SELECT count AS item FROM item_instance WHERE guid = ' . $char['item'] . ' ');
                    $items = $sqlc->fetch_row($result_3);
                    $output .= '
                        <tr valign="center">
                            <td>
                                <a style="padding:2px;" href="' . $item_datasite . $char['itemEntry'] . '" target="_blank">
                                    <img src="' . get_item_icon($char['itemEntry'], $sqlm) . '" alt="' . $char['itemEntry'] . '" class="icon_border_0" />
                                </a>
                            </td>
                            <td>
                                ' . $items['0'] . '
                            </td>
                            <td>
                                <span onmousemove="toolTip(\'' . $bag['description'] . '\', \'item_tooltip\')" onmouseout="toolTip()">' . get_item_name($char['itemEntry'], $sqlw) . '</span>
                            </td>
                        </tr>';
                }
            }
            $output .= '
                    </table>';
            unset($bag);
            //---------------Page Specific Data Ends Here--------------------------
            $output .= '
                </div>
            </div>
            <br />';
            require_once 'core/char/char_footer.php';
            $output .= '
            <br />
            </center>';
        } else {
            error($lang_char['no_permission']);
        }
    } else {
        error($lang_char['no_char_found']);
    }
}

예제 #10

파일: sell_item_waste1.php 프로젝트: bruce28/vip

function message()
{
    if ($_GET['MESSG'] > 0) {
        $message = $_GET['MESSG'];
        if ($message == 1) {
            $message = "Item not in stock. Had been already sold";
        }
        if ($message == 2) {
            $message = "Item Add to Transaction system.";
        }
        if ($message == 3) {
            $message = "Waste Item Added";
        }
        //$message="Item";
        if ($message == 4) {
            $message = "We have never had this item in stock";
        }
        if ($message == 5) {
            $message = "Item in stock, but have not yet been tested. Not availible for sales";
        }
        if ($message == 11) {
            $message = "Item sold on Six Bit";
        }
        if ($_GET['qc'] > 0) {
            $qtty_bulk = $_GET['qc'];
            if ($qtty_bulk == 1) {
                $message = "Added " . $qtty_bulk . " random item of " . get_item_name(get_extension($_GET['item_type'])) . " category";
            } else {
                $message = "Added " . $qtty_bulk . " random items of " . get_item_name(get_extension($_GET['item_type'])) . " category";
            }
        }
        echo "<div id='message' style='position: relative; width: 80%;marign: auto;border:4px black;'> ";
        echo "<h4> MESSAGE: </h4>" . $message;
        echo "</div></BR></BR></BR>";
    }
}

예제 #11

파일: sell_item_invoice_waste.php 프로젝트: bruce28/vip

function show_concat_waste($ref_sell, $price_call)
{
    mysql_connect('localhost', 'root', 'krasnal') or die(mysql_error());
    mysql_select_db('dbs3') or die(mysql_error());
    $customer1 = "SELECT waste_barcode.category,waste_barcode.weight,type_item,count(*) as quantity FROM transaction_waste, waste_barcode,item_has_cat Where waste_barcode.idwaste_barcode=transaction_waste.waste_barcode_idwaste_barcode " . "AND Item_has_cat.id_item_cat=waste_barcode.type_item AND ref_sell_number='{$ref_sell}' GROUP BY type_item ORDER By type_item";
    //echo $ref_sell;
    $reuse = array();
    $cust = add_db($customer1);
    $waste_barcode = array();
    $waste_barcode_weight = array();
    //echo "bf fetch";
    while ($rek = mysql_fetch_array($cust, MYSQL_BOTH)) {
        //changed from 1
        $i++;
        //echo " in fetch ";
        //if($tab[$rek["id_test"]]<'1')
        //{
        //here we count unige barcode waste and add to array
        $index = $rek['type_item'];
        // echo " <BR /> ";
        $waste_barcode[$index] += $rek['quantity'];
        $waste_barcode_weight[$index] = $rek['weight'] * $rek['quantity'];
        //echo '<tr>';
        //echo '<td>'.get_item_name($rek['type_item']).'</td>';
        // echo '<td>'.$rek["quantity"].'</td>';
        // echo '<td>'.$rek["category"].'</td>';
        //   echo '<td>'.$rek["pn"].'.</td>';
        //     	echo '<td>1</td>';
        //echo '<td>'.$rek["sum_weight"].'</td>';
        // echo '<td>'.$rek["Name_sub"].'</td>';
        //echo '</tr>';
        $cat = $rek['category'];
        $reuse[$cat] += $rek['weight'] * $rek['quantity'];
        //}
        //$tab[$rek["id_test"]]+=1;
    }
    $waste_barcode[3];
    $waste_barcode_weight[3];
    echo '<form action="sell_item_invoice_waste.php?invoice=1&ref_sell=' . $ref_sell . '" method="POST">';
    $weee_reused_waste_qtty = array();
    global $sum_rec;
    global $qtty_rec;
    global $ind_rec;
    for ($name_cat = 0; $name_cat < 62; $name_cat++) {
        if (($qtty = get_waste_qtty($ref_sell, $name_cat)) > 0) {
            echo "<tr>";
            echo "<td>";
            echo $sum_qtty_recalculate = $qtty + $waste_barcode[$name_cat];
            echo " UNIT </td>";
            echo "<td>";
            echo get_item_name($name_cat);
            echo "</td>";
            // echo '<td>';
            // echo get_weight_qtty($ref_sell, $name_cat)+$waste_barcode_weight[$name_cat];
            //    echo "</td>";
            //    echo "<td>".$name_cat."</td>";
            echo "<td>" . $sum_qtty_recalculate . " x </td>";
            // echo $sum_rec[$name_cat];
            echo "<input type='hidden' name='qtty_rec" . $name_cat . "' value='" . $sum_qtty_recalculate . "'>";
            echo "<td><input type='text' name='price" . $name_cat . "' value='" . $ind_rec[$name_cat] . "' placeholder='Individual price'></td>";
            if ($sum_rec[$name_cat] > 0) {
                echo "<td> <b>Price Set:</b> <BR/>" . $sum_rec[$name_cat] . " Pounds</td>";
            }
            echo "</tr>";
            $sum_qtty = get_weight_qtty($ref_sell, $name_cat);
            +$waste_barcode[$name_cat];
            $cat = get_cat($name_cat);
            $weee_reused_waste_qtty[$cat] += get_weight_qtty($ref_sell, $name_cat);
        } else {
            $customer1 = "SELECT waste_barcode.category,waste_barcode.weight,type_item,count(*) as quantity FROM transaction_waste, waste_barcode,item_has_cat Where waste_barcode.idwaste_barcode=transaction_waste.waste_barcode_idwaste_barcode " . "AND Item_has_cat.id_item_cat=waste_barcode.type_item AND ref_sell_number='{$ref_sell}' AND type_item='{$name_cat}' GROUP BY type_item ORDER By type_item";
            $cust = add_db($customer1);
            while ($rek = mysql_fetch_array($cust, MYSQL_BOTH)) {
                $i++;
                //if($tab[$rek["id_test"]]<'1')
                //{
                //here we count unige barcode waste and add to array
                if ($rek['quantity'] > 0) {
                    $qtty_indiv = $rek["quantity"];
                    $index = $rek['type_item'];
                    $waste_barcode_weight[$index] = $rek['weight'] * $rek['quantity'];
                    // echo " <BR /> ";
                    //$waste_barcode[$index]+=$rek['quantity'];
                    // $waste_barcode_weight[$index]=$rek['weight']*$rek['quantity'];
                    echo '<tr>';
                    echo '<td>' . $rek["quantity"] . ' Unit</td>';
                    echo '<td>' . get_item_name($rek['type_item']) . '</td>';
                    //   echo '<td>'.$waste_barcode_weight[$index]
                    //   .'</td>';
                    //  echo '<td>'.$rek["category"].'</td>';
                    // echo '<td>'.$rek["pn"].'.</td>';
                    //      	echo '<td>1</td>';
                    //echo '<td>'.$rek["sum_weight"].'</td>';
                    // echo '<td>'.$rek["Name_sub"].'</td>';
                    echo "<td>" . $qtty_indiv . " x </td>";
                    echo "<input type='hidden' name='qtty_rec" . $name_cat . "' value='" . $qtty_indiv . "'>";
                    echo "<td><input type='text' name='price" . $name_cat . "' value='" . $ind_rec[$name_cat] . "' placeholder='Individual price'></td>";
                    if ($sum_rec[$name_cat] > 0) {
                        echo "<td> <b>Price Set:</b> <BR/>" . $sum_rec[$name_cat] . " Pounds</td>";
                    }
                    echo '</tr>';
                    //  $cat=$rek['category'];
                    //  $reuse[$cat]+=$rek['weight'] * $rek['quantity'];
                    //}
                }
                //$tab[$rek["id_test"]]+=1;
            }
        }
    }
    global $sum_price;
    global $price_invoice_set;
    if ($sum_price > 0) {
        echo "<tr></tr>";
        echo "<tr><td colspan='4'></td><td> <b>Total value: " . $sum_price . "</b></td></tr>";
        echo "<input type='hidden' name='sum_set' value='" . $sum_price . "'";
        $price_invoice_set = $sum_price;
    }
    echo '<tr><input type="Submit" name="Recalculate" value="Recalculate"></tr>';
    echo '<BR />';
    echo '</form>';
}

예제 #12

파일: tasks.tmpl.php 프로젝트: Xackery/EQEmuEOC

?>
</td>            
             </tr>
              <tr>
               <td align="left" width="35%" colspan="2">Reward:
               <?php 
if (($rewardmethod == 0 || $rewardmethod == 2) && $rewardid > 1000) {
    ?>
          <a href="index.php?editor=items&tskid=<?php 
    echo $id;
    ?>
&id=<?php 
    echo $rewardid;
    ?>
&action=2"><?php 
    echo $rewardid . " - " . get_item_name($rewardid);
    ?>
</a> <span>[<a href="http://lucy.allakhazam.com/item.html?id=<?php 
    echo $rewardid;
    ?>
">lucy</a>]</span></td>
              <?php 
}
?>
 
               <?php 
if ($rewardmethod == 2 && $rewardid < 1001) {
    ?>
          <?php 
    echo $rewardid;
    ?>

예제 #13

파일: invoice_print_waste.php 프로젝트: bruce28/vip

        $customer1 = "SELECT waste_barcode.category,waste_barcode.weight,type_item,count(*) as quantity FROM transaction_waste, waste_barcode,item_has_cat Where waste_barcode.idwaste_barcode=transaction_waste.waste_barcode_idwaste_barcode " . "AND Item_has_cat.id_item_cat=waste_barcode.type_item AND ref_sell_number='{$ref_sell}' AND type_item='{$name_cat}' GROUP BY type_item ORDER By type_item";
        $cust = add_db($customer1);
        while ($rek = mysql_fetch_array($cust, MYSQL_BOTH)) {
            $i++;
            //if($tab[$rek["id_test"]]<'1')
            //{
            //here we count unige barcode waste and add to array
            if ($rek['quantity'] > 0) {
                $index = $rek['type_item'];
                $waste_barcode_weight[$index] = $rek['weight'] * $rek['quantity'];
                // echo " <BR /> ";
                //$waste_barcode[$index]+=$rek['quantity'];
                // $waste_barcode_weight[$index]=$rek['weight']*$rek['quantity'];
                echo '<tr>';
                echo '<td>' . $rek["quantity"] . ' Unit</td>';
                echo '<td>' . get_item_name($rek['type_item']) . '</td>';
                echo '<td>' . $waste_barcode_weight[$index] . '</td>';
                echo '<td>' . $rek["category"] . '</td>';
                // echo '<td>'.$rek["pn"].'.</td>';
                //      	echo '<td>1</td>';
                //echo '<td>'.$rek["sum_weight"].'</td>';
                // echo '<td>'.$rek["Name_sub"].'</td>';
                echo '</tr>';
                //  $cat=$rek['category'];
                //  $reuse[$cat]+=$rek['weight'] * $rek['quantity'];
                //}
            }
            //$tab[$rek["id_test"]]+=1;
        }
    }
}

예제 #14

파일: char_edit.php 프로젝트: brunogcar/minimanager

function edit_char()
{
    global $lang_global, $lang_char, $lang_item, $output, $realm_db, $characters_db, $realm_id, $mmfpm_db, $action_permission, $user_lvl, $item_datasite;
    wowhead_tt();
    valid_login($action_permission['delete']);
    if (empty($_GET['id'])) {
        error($lang_global['empty_fields']);
    }
    $sql = new SQL();
    $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
    $sqlm = new SQL();
    $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
    $id = $sql->quote_smart($_GET['id']);
    $result = $sql->query("SELECT account FROM `characters` WHERE guid = '{$id}'");
    if ($sql->num_rows($result)) {
        //resrict by owner's gmlvl
        $owner_acc_id = $sql->result($result, 0, 'account');
        $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
        $query = $sql->query("SELECT gmlevel,username FROM account WHERE id ='{$owner_acc_id}'");
        $owner_gmlvl = $sql->result($query, 0, 'gmlevel');
        $owner_name = $sql->result($query, 0, 'username');
        $owner_check = $sql->result($query, 0, 'username');
        if ($user_lvl >= $owner_gmlvl) {
            $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
            $result = $sql->query("SELECT guid, account, name, race, class, position_x, position_y, map, online, totaltime, position_z, zone, level, gender, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todaykills, yesterdayKills, health, power1, power2, power3, power4, power5, power6, power7, money, xp FROM `characters` WHERE guid = '{$id}'");
            $char = $sql->fetch_row($result);
            $char_data = explode(' ', $char[2]);
            if ($char[9]) {
                $online = "<font class=\"error\">{$lang_char['online']}</font>{$lang_char['edit_offline_only_char']}";
            } else {
                $online = $lang_char['offline'];
            }
            if ($char_data[CHAR_DATA_OFFSET_GUILD_ID]) {
                $query = $sql->query("SELECT name FROM guild WHERE guildid ='{$char_data[CHAR_DATA_OFFSET_GUILD_ID]}'");
                $guild_name = $sql->result($query, 0, 'name');
                if ($user_lvl > 0) {
                    $guild_name = "<a href=\"guild.php?action=view_guild&amp;error=3&amp;id={$char_data[CHAR_DATA_OFFSET_GUILD_ID]}\" >{$guild_name}</a>";
                }
                if ($char_data[CHAR_DATA_OFFSET_GUILD_RANK]) {
                    $guild_rank_query = $sql->query("SELECT rname FROM guild_rank WHERE guildid ='{$char_data[CHAR_DATA_OFFSET_GUILD_ID]}' AND rid='{$char_data[CHAR_DATA_OFFSET_GUILD_RANK]}'");
                    $guild_rank = $sql->result($guild_rank_query, 0, 'rname');
                } else {
                    $guild_rank = $lang_char['guild_leader'];
                }
            } else {
                $guild_name = $lang_global['none'];
                $guild_rank = $lang_global['none'];
            }
            $block = unpack("f", pack("L", $char_data[CHAR_DATA_OFFSET_BLOCK]));
            $block = round($block[1], 4);
            $dodge = unpack("f", pack("L", $char_data[CHAR_DATA_OFFSET_DODGE]));
            $dodge = round($dodge[1], 4);
            $parry = unpack("f", pack("L", $char_data[CHAR_DATA_OFFSET_PARRY]));
            $parry = round($parry[1], 4);
            $crit = unpack("f", pack("L", $char_data[CHAR_DATA_OFFSET_MELEE_CRIT]));
            $crit = round($crit[1], 4);
            $range_crit = unpack("f", pack("L", $char_data[CHAR_DATA_OFFSET_RANGE_CRIT]));
            $range_crit = round($range_crit[1], 4);
            $output .= "<center>\r\n\t\t\t<form method=\"get\" action=\"char_edit.php\" name=\"form\">\r\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"do_edit_char\" />\r\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"{$id}\" />\r\n\t\t\t\t<table class=\"lined\">\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"8\">\n\t\t\t\t\t\t\t<font class=\"bold\">\n\t\t\t\t\t\t\t<input type=\"text\" name=\"name\" size=\"14\" maxlength=\"12\" value=\"{$char['3']}\" /> - \n\t\t\t\t\t\t\t<img src='img/c_icons/{$char[4]}-{$char[14]}.gif' onmousemove='toolTip(\"" . char_get_race_name($char[4]) . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" /> \n\t\t\t\t\t\t\t<img src='img/c_icons/{$char[5]}.gif' onmousemove='toolTip(\"" . char_get_class_name($char[5]) . "\",\"item_tooltip\")' onmouseout='toolTip()' alt=\"\" /> - lvl " . char_get_level_color($char[13]) . "</font>\n\t\t\t\t\t\t\t<br />{$online}\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"8\">" . get_map_name($char[9], $sqlm) . " - " . get_zone_name($char[12], $sqlm) . "</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"8\">{$lang_char['username']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"owner_name\" size=\"20\" maxlength=\"25\" value=\"{$owner_name}\" /> | {$lang_char['acc_id']}: {$owner_acc_id}\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"8\">{$lang_char['guild']}: {$guild_name} | {$lang_char['rank']}: {$guild_rank}</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"8\">{$lang_char['honor_points']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"honor_points\" size=\"8\" maxlength=\"6\" value=\"{$char[16]}\" />/\r\n\t\t\t\t\t\t\t<input type=\"text\" name=\"arena_points\" size=\"8\" maxlength=\"6\" value=\"{$char[15]}\" /> - {$lang_char['honor_kills']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"total_kills\" size=\"8\" maxlength=\"6\" value=\"{$char[19]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td width=\"2%\">\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a0\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td width=\"18%\">{$lang_item['head']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_HEAD]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_HEAD]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td width=\"15%\">{$lang_item['health']}:</td>\n\t\t\t\t\t\t<td width=\"15%\">\n\t\t\t\t\t\t\t<input type=\"text\" name=\"health\" size=\"10\" maxlength=\"6\" value=\"{$char[22]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td width=\"15%\">{$lang_item['res_holy']}:</td>\n\t\t\t\t\t\t<td width=\"15%\">\n\t\t\t\t\t\t\t<input type=\"text\" name=\"res_holy\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_HOLY]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td width=\"18%\">{$lang_item['gloves']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_GLOVES]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_GLOVES]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td width=\"2%\">\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a9\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a1\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['neck']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_NECK]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_NECK]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['mana']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"mana\" size=\"10\" maxlength=\"6\" value=\"{$char[23]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['res_arcane']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"res_arcane\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_ARCANE]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['belt']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_BELT]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_BELT]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a5\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a2\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['shoulder']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_SHOULDER]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_SHOULDER]) . "</a>\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['strength']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"str\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_STR]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['res_fire']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"res_fire\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_FIRE]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['legs']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_LEGS]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_LEGS]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a6\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a14\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['back']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_BACK]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_BACK]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['agility']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"agi\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_AGI]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['res_nature']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"res_nature\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_NATURE]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['feet']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_FEET]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_FEET]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a7\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a4\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['chest']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_CHEST]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_CHEST]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['stamina']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"sta\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_STA]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['res_frost']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"res_frost\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_FROST]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['finger']} 1<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[380]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_FINGER1]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a10\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a3\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['shirt']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_SHIRT]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_SHIRT]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['intellect']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"int\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_INT]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['res_shadow']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"res_shadow\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_RES_SHADOW]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['finger']} 2<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_FINGER2]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_FINGER2]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a11\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a18\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['tabard']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_TABARD]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_TABARD]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['spirit']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"spi\" size=\"10\" maxlength=\"4\" value=\"{$char_data[CHAR_DATA_OFFSET_SPI]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_char['exp']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"exp\" size=\"10\" maxlength=\"8\" value=\"{$char[31]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['trinket']} 1<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_TRINKET1]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_TRINKET1]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a12\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a8\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_item['wrist']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_WRIST]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_WRIST]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['armor']}:</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_ARMOR]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_char['melee_ap']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"attack_power\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_AP]}\" />\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>{$lang_char['ranged_ap']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"range_attack_power\" size=\"10\" maxlength=\"6\" value=\"{$char_data[CHAR_DATA_OFFSET_RANGED_AP]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>{$lang_item['trinket']} 2<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_TRINKET2]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_TRINKET2]) . "</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a13\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a15\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td colspan=\"2\">{$lang_item['main_hand']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_MAIN_HAND]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_MAIN_HAND]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td colspan=\"2\">\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a16\" />&nbsp;{$lang_item['off_hand']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_OFF_HAND]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_OFF_HAND]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td colspan=\"2\">{$lang_item['ranged']}<br />\n\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$char_data[CHAR_DATA_OFFSET_EQU_RANGED]}\" target=\"_blank\">" . get_item_name($char_data[CHAR_DATA_OFFSET_EQU_RANGED]) . "</a>\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"a17\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\t\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"8\">{$lang_char['block']} : \n\t\t\t\t\t\t\t<input type=\"text\" name=\"block\" size=\"5\" maxlength=\"3\" value=\"{$block}\" />%\r\n\t\t\t\t\t\t\t| {$lang_char['dodge']}: <input type=\"text\" name=\"dodge\" size=\"5\" maxlength=\"3\" value=\"{$dodge}\" />%\r\n\t\t\t\t\t\t\t| {$lang_char['parry']}: <input type=\"text\" name=\"parry\" size=\"5\" maxlength=\"3\" value=\"{$parry}\" />%\r\n\t\t\t\t\t\t\t| {$lang_char['melee_crit']}: <input type=\"text\" name=\"crit\" size=\"5\" maxlength=\"3\" value=\"{$crit}\" />%\r\n\t\t\t\t\t\t\t| {$lang_char['ranged_crit']}: <input type=\"text\" name=\"range_crit\" size=\"3\" maxlength=\"14\" value=\"{$range_crit}\" />%\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"4\">{$lang_char['gold']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"money\" size=\"10\" maxlength=\"8\" value=\"{$char[30]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td colspan=\"4\">{$lang_char['tot_paly_time']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"tot_time\" size=\"8\" maxlength=\"14\" value=\"{$char[10]}\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"5\">{$lang_char['location']}:\r\n\t\t\t\t\t\t\tX:<input type=\"text\" name=\"x\" size=\"10\" maxlength=\"8\" value=\"{$char[6]}\" />\r\n\t\t\t\t\t\t\tY:<input type=\"text\" name=\"y\" size=\"8\" maxlength=\"16\" value=\"{$char[7]}\" />\r\n\t\t\t\t\t\t\tZ:<input type=\"text\" name=\"z\" size=\"8\" maxlength=\"16\" value=\"{$char[11]}\" />\r\n\t\t\t\t\t\t\tMap:<input type=\"text\" name=\"map\" size=\"8\" maxlength=\"16\" value=\"{$char[8]}\" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td colspan=\"3\">{$lang_char['move_to']}: \n\t\t\t\t\t\t\t<input type=\"text\" name=\"tp_to\" size=\"24\" maxlength=\"64\" value=\"\" />\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\n\t\t<br />";
            //inventory+bank items
            $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
            $query2 = $sql->query("SELECT bag,slot,item,item_template FROM character_inventory WHERE guid = '{$id}' ORDER BY bag,slot");
            $inv = array();
            $count = 0;
            while ($slot = $sql->fetch_row($query2)) {
                if ($slot[0] == 0) {
                    if ($slot[1] >= 23 && $slot[1] <= 62) {
                        $count++;
                        $inv[$count][0] = $slot[3];
                        $inv[$count][1] = $slot[2];
                    }
                } else {
                    $count++;
                    $inv[$count][0] = $slot[3];
                    $inv[$count][1] = $slot[2];
                }
            }
            $output .= "<table class=\"lined\">\r\n\t\t\t<tr>\n\t\t\t\t<td>{$lang_char['inv_bank']}</td>\n\t\t\t</tr>\r\n\t\t\t<tr>\n\t\t\t\t<td height=\"100\" align=\"center\">\r\n\t\t\t\t\t<table>\n\t\t\t\t\t\t<tr align=\"center\">";
            $j = 0;
            for ($i = 1; $i <= $count; $i++) {
                $j++;
                $output .= "<td>\n\t\t\t\t\t\t\t\t\t<a href=\"{$item_datasite}{$inv[$i][0]}\" target=\"_blank\">{$inv[$i][0]}</a>\n\t\t\t\t\t\t\t\t\t<br />\n\t\t\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"check[]\" value=\"{$inv[$i][1]}\" />\n\t\t\t\t\t\t\t\t\t</td>";
                if ($j == 15) {
                    $output .= "</tr>\n\t\t\t\t\t\t\t\t\t\t<tr align=\"center\">";
                    $j = 0;
                }
            }
            $output .= "\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>\r\n\t<br />\r\n\t<table class=\"hidden\">\r\n\t\t<tr>\n\t\t\t<td>";
            makebutton($lang_char['update'], "javascript:do_submit()", 190);
            makebutton($lang_char['to_char_view'], "char.php?id={$id}", 160);
            makebutton($lang_char['del_char'], "char_list.php?action=del_char_form&amp;check%5B%5D={$id}", 160);
            makebutton($lang_global['back'], "javascript:window.history.back()", 160);
            $output .= "\n\t\t\t</td>\n\t\t</tr>\r\n\t</table>\n<br />\r\n</form>\n</center>";
            //case of non auth request
        } else {
            $sql->close();
            unset($sql);
            error($lang_char['no_permission']);
            exit;
        }
    } else {
        error($lang_char['no_char_found']);
    }
}

예제 #15

파일: item.edit.tmpl.php 프로젝트: Xackery/EQEmuEOC

  <div class="edit_form" style="width: 300px">
    <div class="edit_form_header">
      Edit Entry: <?php 
echo get_item_name($altcur_item['item_id']);
?>
    </div>
    <div class="edit_form_content">
      <form name="alt_curr_item" method="post" action="index.php?editor=altcur&id=<?php 
echo $altcur_item['id'];
?>
&action=5">
        <table width="100%" cellspacing="0">
          <tr>
            <td width="40%">
              ID:<br/>
              <input type="text" name="entry_id" value="<?php 
echo $altcur_item['id'];
?>
" size="10" disabled="disabled"/>
            </td>
            <td width="60%">
              Item ID:<br/>
              <input type="text" name="item_id" value="<?php 
echo $altcur_item['item_id'];
?>
"/>
            </td>
          </tr>
        </table><br/><br/>
        <center>
          <input type="hidden" name="id" value="<?php 

예제 #16

파일: game_object.php 프로젝트: BACKUPLIB/minimanager-1

function edit()
{
    global $lang_global, $lang_game_object, $output, $world_db, $realm_id, $item_datasite, $go_datasite, $go_type, $quest_datasite;
    wowhead_tt();
    if (!isset($_GET['entry'])) {
        redirect("game_object.php?error=1");
    }
    $sql = new SQL();
    $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
    $entry = $sql->quote_smart($_GET['entry']);
    require_once "./scripts/get_lib.php";
    $deplang = get_lang_id();
    $result = $sql->query("SELECT gameobject_template.`entry`,`type`,`displayId`,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,`faction`,`flags`,`size`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`ScriptName` FROM gameobject_template LEFT JOIN locales_gameobject ON gameobject_template.entry = locales_gameobject.entry WHERE gameobject_template.entry = '{$entry}'");
    if ($go = $sql->fetch_assoc($result)) {
        $output .= "<script type=\"text/javascript\" src=\"libs/js/tab.js\"></script>\r\n   <center>\r\n    <br /><br /><br />\r\n    <form method=\"post\" action=\"game_object.php?action=do_update\" name=\"form1\">\r\n    <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>\r\n    <input type=\"hidden\" name=\"opp_type\" value=\"edit\"/>\r\n    <input type=\"hidden\" name=\"entry\" value=\"{$entry}\"/>\r\n\r\n<div class=\"jtab-container\" id=\"container\">\r\n  <ul class=\"jtabs\">\r\n    <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_game_object['general']}</a></li>\r\n    <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_game_object['datas']}</a></li>";
        if ($go['type'] == 3) {
            $output .= "<li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_game_object['loot']}</a></li>";
        }
        $output .= "<li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_game_object['quests']}</a></li>\r\n  </ul>\r\n  <div class=\"jtab-panes\">";
        $output .= "<div id=\"pane1\"><br /><br />\r\n<table class=\"lined\" style=\"width: 720px;\">\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['general']}:</td></tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['entry'], $lang_game_object['entry_desc']) . "</td>\r\n <td><a href=\"{$go_datasite}{$go['entry']}\" target=\"_blank\">{$go['entry']}</a></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['name'], $lang_game_object['name_desc']) . "</td>\r\n <td ><input type=\"text\" name=\"name\" size=\"25\" maxlength=\"100\" value=\"{$go['name']}\" /></td>\r\n\r\n  <td>" . makeinfocell($lang_game_object['faction'], $lang_game_object['faction_desc']) . "</td>\r\n <td><input type=\"text\" name=\"faction\" size=\"10\" maxlength=\"4\" value=\"{$go['faction']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['type'], $lang_game_object['type_desc']) . "</td>\r\n <td colspan=\"3\"><select name=\"type\">";
        foreach ($go_type as $type) {
            $output .= "<option value=\"{$type['0']}\" ";
            if ($type[0] == $go['type']) {
                $output .= "selected=\"selected\" ";
            }
            $output .= ">({$type['0']}) {$type['1']}</option>";
        }
        $output .= "</select></td>\r\n <td>" . makeinfocell($lang_game_object['displayId'], $lang_game_object['displayId_desc']) . "</td>\r\n <td><input type=\"text\" name=\"displayId\" size=\"10\" maxlength=\"11\" value=\"{$go['displayId']}\" /></td>\r\n\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['flags'], $lang_game_object['flags_desc']) . "</td>\r\n <td><input type=\"text\" name=\"flags\" size=\"10\" maxlength=\"4\" value=\"{$go['flags']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['size'], $lang_game_object['size_desc']) . "</td>\r\n <td><input type=\"text\" name=\"size\" size=\"10\" maxlength=\"25\" value=\"{$go['size']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['script_name'], $lang_game_object['ScriptName_desc']) . "</td>\r\n <td><input type=\"text\" name=\"ScriptName\" size=\"10\" maxlength=\"100\" value=\"{$go['ScriptName']}\" /></td>\r\n</tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['data']}:</td></tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 0", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data0\" size=\"10\" maxlength=\"11\" value=\"{$go['data0']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 1", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data1\" size=\"10\" maxlength=\"11\" value=\"{$go['data1']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 2", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data2\" size=\"10\" maxlength=\"11\" value=\"{$go['data2']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 3", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data3\" size=\"10\" maxlength=\"11\" value=\"{$go['data3']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 4", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data4\" size=\"10\" maxlength=\"11\" value=\"{$go['data4']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 5", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data5\" size=\"10\" maxlength=\"11\" value=\"{$go['data5']}\" /></td>\r\n</tr>\r\n</table><br />";
        $result1 = $sql->query("SELECT COUNT(*) FROM gameobject WHERE id = '{$go['entry']}'");
        $output .= "<tr><td colspan=\"6\">{$lang_game_object['go_swapned']} : " . $sql->result($result1, 0) . " {$lang_game_object['times']}.</td></tr>\r\n\r\n<br />\r\n</div>\r\n\r\n<div id=\"pane2\">\r\n  <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['data']}:</td></tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 6", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data6\" size=\"10\" maxlength=\"11\" value=\"{$go['data6']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 7", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data7\" size=\"10\" maxlength=\"11\" value=\"{$go['data7']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 8", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data8\" size=\"10\" maxlength=\"11\" value=\"{$go['data8']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 9", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data9\" size=\"10\" maxlength=\"11\" value=\"{$go['data9']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 10", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data10\" size=\"10\" maxlength=\"11\" value=\"{$go['data10']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 11", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data11\" size=\"10\" maxlength=\"11\" value=\"{$go['data11']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 12", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data12\" size=\"10\" maxlength=\"11\" value=\"{$go['data12']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 13", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data13\" size=\"10\" maxlength=\"11\" value=\"{$go['data13']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 14", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data14\" size=\"10\" maxlength=\"11\" value=\"{$go['data14']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 15", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data15\" size=\"10\" maxlength=\"11\" value=\"{$go['data15']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 16", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data16\" size=\"10\" maxlength=\"11\" value=\"{$go['data16']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 17", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data17\" size=\"10\" maxlength=\"11\" value=\"{$go['data17']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 18", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data18\" size=\"10\" maxlength=\"11\" value=\"{$go['data18']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 19", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data19\" size=\"10\" maxlength=\"11\" value=\"{$go['data19']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 20", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data20\" size=\"10\" maxlength=\"11\" value=\"{$go['data20']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 21", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data21\" size=\"10\" maxlength=\"11\" value=\"{$go['data21']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 22", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data22\" size=\"10\" maxlength=\"11\" value=\"{$go['data22']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 23", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data23\" size=\"10\" maxlength=\"11\" value=\"{$go['data23']}\" /></td>\r\n</tr>\r\n</table>\r\n<br />\r\n</div>";
        if ($go['type'] == 3) {
            $output .= "<div id=\"pane3\">\r\n  <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n  <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['loot_tmpl_id']}:</td></tr>\r\n<tr>\r\n  <td colspan=\"6\">";
            require_once "scripts/get_lib.php";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "<table class=\"hidden\" align=\"center\"><tr>";
            $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1, condition_value2 FROM gameobject_loot_template WHERE entry = {$go['data1']} ORDER BY ChanceOrQuestChance DESC");
            while ($item = $sql->fetch_row($result1)) {
                $cel_counter++;
                $tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_game_object['drop_chance']}: {$item['1']}%<br />{$lang_game_object['quest_drop_chance']}: {$item['2']}%<br />{$lang_game_object['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_game_object['lootcondition']}: {$item['5']}<br />{$lang_game_object['condition_value1']}: {$item['6']}<br />{$lang_game_object['condition_value2']}: {$item['7']}";
                $output .= "<td>";
                $output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", "{$tooltip}", "item_tooltip", "target=\"_blank\"");
                $output .= "<br /><input type=\"checkbox\" name=\"del_loot_items[]\" value=\"{$item['0']}\" /></td>";
                if ($cel_counter >= 16) {
                    $cel_counter = 0;
                    $output .= "</tr><tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "</td></tr></table>\r\n </td>\r\n</tr>\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['add_items_to_templ']}:</td></tr>\r\n<tr>\r\n<td>" . makeinfocell($lang_game_object['loot_item_id'], $lang_game_object['loot_item_id_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"item\" size=\"8\" maxlength=\"10\" value=\"\" /></td>\r\n<td>" . makeinfocell($lang_game_object['loot_drop_chance'], $lang_game_object['loot_drop_chance_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>\r\n<td>" . makeinfocell($lang_game_object['loot_quest_drop_chance'], $lang_game_object['loot_quest_drop_chance_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>\r\n</tr>\r\n<tr>\r\n<td>" . makeinfocell($lang_game_object['min_count'], $lang_game_object['min_count_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\r\n<td>" . makeinfocell($lang_game_object['max_count'], $lang_game_object['max_count_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\r\n</tr>\r\n<tr>\r\n<td>" . makeinfocell($lang_game_object['lootcondition'], $lang_game_object['lootcondition_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n<td>" . makeinfocell($lang_game_object['condition_value1'], $lang_game_object['condition_value1_desc']) . "</td>\r\n  <td><input type=\"text\" name=\"condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n<td>" . makeinfocell($lang_game_object['condition_value2'], $lang_game_object['condition_value2']) . "</td>\r\n  <td><input type=\"text\" name=\"condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n</tr>\r\n</table><br />{$lang_game_object['check_to_delete']}<br /><br />\r\n</div>";
        }
        $output .= "<div id=\"pane4\">\r\n  <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n  <tr class=\"large_bold\"><td colspan=\"2\" class=\"hidden\" align=\"left\">{$lang_game_object['start_quests']}:</td></tr>";
        $result1 = $sql->query("SELECT quest FROM gameobject_questrelation WHERE id = {$go['entry']}");
        while ($quest = $sql->fetch_row($result1)) {
            $query1 = $sql->query("SELECT QuestLevel, IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as Title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='{$quest['0']}'");
            $quest_templ = $sql->fetch_row($query1);
            $output .= "<tr><td width=\"5%\"><input type=\"checkbox\" name=\"del_questrelation[]\" value=\"{$quest['0']}\" /></td>\r\n          <td width=\"95%\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest_templ[0]}) {$quest_templ['1']}</a></td></tr>";
        }
        $output .= "<tr class=\"large_bold\" align=\"left\"><td colspan=\"2\" class=\"hidden\">{$lang_game_object['add_starts_quests']}:</td></tr>\r\n  <tr><td colspan=\"2\" align=\"left\">" . makeinfocell($lang_game_object['quest_id'], $lang_game_object['quest_id_desc']) . " :\r\n    <input type=\"text\" name=\"questrelation\" size=\"8\" maxlength=\"8\" value=\"\" /></td></tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"2\" class=\"hidden\" align=\"left\">{$lang_game_object['ends_quests']}:</td></tr>";
        $result1 = $sql->query("SELECT quest FROM gameobject_involvedrelation WHERE id = {$go['entry']}");
        while ($quest = $sql->fetch_row($result1)) {
            $query1 = $sql->query("SELECT QuestLevel, IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as Title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='{$quest['0']}'");
            $quest_templ = $sql->fetch_row($query1);
            $output .= "<tr><td width=\"5%\"><input type=\"checkbox\" name=\"del_involvedrelation[]\" value=\"{$quest['0']}\" /></td>\r\n        <td width=\"95%\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest_templ[0]}) {$quest_templ['1']}</a></td></tr>";
        }
        $output .= "<tr class=\"large_bold\" align=\"left\"><td colspan=\"2\" class=\"hidden\">{$lang_game_object['add_ends_quests']}:</td></tr>\r\n  <tr><td colspan=\"2\" align=\"left\">" . makeinfocell($lang_game_object['quest_id'], $lang_game_object['quest_id_desc']) . " :\r\n    <input type=\"text\" name=\"involvedrelation\" size=\"8\" maxlength=\"8\" value=\"\" /></td></tr>\r\n\r\n</table><br />{$lang_game_object['check_to_delete']}<br /><br />\r\n</div>\r\n\r\n</div>\r\n</div>\r\n<br />\r\n</form>\r\n\r\n<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
        $output .= "<table class=\"hidden\">\r\n          <tr><td>";
        makebutton($lang_game_object['save_to_db'], "javascript:do_submit('form1',0)", 180);
        makebutton($lang_game_object['del_go'], "game_object.php?action=delete&amp;entry={$entry}", 180);
        makebutton($lang_game_object['del_spawns'], "game_object.php?action=delete_spwn&amp;entry={$entry}", 180);
        makebutton($lang_game_object['save_to_script'], "javascript:do_submit('form1',1)", 180);
        $output .= "</td></tr><tr><td>";
        makebutton($lang_game_object['lookup_go'], "game_object.php", 760);
        $output .= "</td></tr>\r\n        </table></center>";
        $sql->close();
    } else {
        $sql->close();
        error($lang_game_object['tmpl_not_found']);
        exit;
    }
}

예제 #17

파일: goallist.tmpl.php 프로젝트: Xackery/EQEmuEOC

        <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
          <td align="center" width="5%"><?php 
        echo $v['listid'];
        ?>
</td>
          <td align="center" width="20%"><a href="index.php?editor=items&tskid=<?php 
        echo $id;
        ?>
&id=<?php 
        echo $v['entry'];
        ?>
&action=2"></a><?php 
        echo get_item_name($v['entry']);
        ?>
 <span>[<a href="http://lucy.allakhazam.com/item.html?id=<?php 
        echo $v['entry'];
        ?>
">lucy</a>]</span></td>
          <td align="right">   
            <a onClick="return confirm('Really Delete Entry <?php 
        echo $v['entry'];
        ?>
?');" href="index.php?editor=tasks&tskid=<?php 
        echo $tskid;
        ?>
&lid=<?php 
        echo $v['listid'];
        ?>

예제 #18

파일: index.php 프로젝트: emiedson/sanasol

if ($totalrows >= 1) {
    foreach ($results as $row) {
        $nick = "";
        if ($row->card0 == 254) {
            $char_sign = $db->select("`char`", "char_id='{$row->card2}'", "", "name");
            $nick_just = $char_sign[0]->name;
            $nick = "<span style='color: blue;'>{$nick_just}'s</span> ";
        }
        $row->price = number_format($row->price);
        $row->amount = number_format($row->amount);
        $row->name2 = $row->name;
        $row->name = mb_substr($row->name, 0, 10, "UTF-8") . "...";
        $vvs = "";
        if ($row->card0 == 255 && intval($row->card1 / 1280) > 0) {
            for ($i = 0; $i < intval($row->card1 / 1280); $i++) {
                $vvs .= "Very ";
            }
            $vvs .= "Strong ";
            $vvs = "<span style='color: blue;'>{$vvs}</span> ";
        }
        $item = get_item_name($row->nameid);
        echo "<tr>\n\t\t\t\t\t\t\t<td title=\"{$row->name2}\">{$row->name}</td>\n\t\t\t\t\t\t\t<td>{$row->merchant_name}</td>\n\t\t\t\t\t\t\t<td><span class='mapinfo' data-map='{$row->last_map}' data-x='{$row->last_x}' data-y='{$row->last_y}'>{$row->last_map} {$row->last_x},{$row->last_y}</span></td>\n\t\t\t\t\t\t\t<td><img height='20' src='items_small/{$row->nameid}.png' title='{$item}' /></td>\n\t\t\t\t\t\t\t<td>{$nick}{$vvs}{$item}</td>\n\t\t\t\t\t\t\t<td>{$row->amount}</td>\n\t\t\t\t\t\t\t<td>{$row->price}z</td>\n\t\t\t\t\t\t\t<td>" . refine_lvl($row->refine) . "</td>\n\t\t\t\t\t\t\t<td>" . get_item_name($row->card0) . "</td>\n\t\t\t\t\t\t\t<td>" . get_item_name($row->card1 > 255 && $row->card0 > 255 ? $row->card1 : 0) . "</td>\n\t\t\t\t\t\t\t<td>" . get_item_name($row->card2 > 255 && $row->card0 > 255 ? $row->card2 : 0) . "</td>\n\t\t\t\t\t\t\t<td>" . get_item_name($row->card3) . "</td>\n\t\t\t\t\t\t\t</tr>";
    }
} else {
    echo "<tr><td colspan=\"12\">Nothing was found</td></tr>";
}
?>
					</tbody>
					</table>
					</div>
				</body>					

예제 #19

파일: char_extra_companion.php 프로젝트: BACKUPLIB/Infinity_MaNGOS

function char_companions(&$sqlr, &$sqlc, &$sqlw)
{
    global $output, $lang_global, $lang_char, $realm_id, $characters_db, $world_db, $action_permission, $user_lvl, $user_name, $item_datasite;
    // this page uses wowhead tooltops
    wowhead_tt();
    //==========================$_GET and SECURE=================================
    // id and multi realm security to prevent sql injection
    require_once './include/char/include/char_multi_realm_security.php';
    //==========================$_GET and SECURE end=============================
    // getting character data from database
    $result = $sqlc->query('
		SELECT account, name, race, class, gender, level
		FROM characters
		WHERE guid = ' . $id . ' 
		LIMIT 1');
    // no point going further if character does not exist
    if ($sqlc->num_rows($result)) {
        $char = $sqlc->fetch_assoc($result);
        // we get user permissions first
        $owner_acc_id = $sqlc->result($result, 0, 'account');
        $result = $sqlr->query('
			SELECT gmlevel, username 
			FROM account 
			WHERE id = ' . $char['account'] . '');
        $owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
        $owner_name = $sqlr->result($result, 0, 'username');
        // check user permission
        if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
            // character sub header
            $output .= '
<center>
<div id="tab_content">
	<h1>' . $lang_char['extra'] . '</h1>
	<br />';
            // character menu tab
            require_once './include/char/include/char_header.php';
            // character info
            require_once './include/char/include/char_info.php';
            //---------------Page Specific Data Starts Here--------------------------
            $output .= '
	<h1>' . $lang_char['char_companions'] . '</h1>
	<br />';
            // character extra menu tab
            require_once './include/char/include/char_extra_header.php';
            $output .= '
	<div id="tab_content2">
		<table class="lined" style="width: 450px;">
			<tr>
				<th width="15%">' . $lang_char['icon'] . '</th>
				<th width="15%">' . $lang_char['quantity'] . '</th>
				<th width="70%">' . $lang_char['name'] . '</th>
			</tr>';
            $sqlw = new SQL();
            $sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
            $item = $sqlw->query('
				SELECT entry, description
				FROM item_template
				WHERE BagFamily = 4096');
            while ($template = $sqlw->fetch_assoc($item)) {
                $character = $sqlc->query('
					SELECT item, item_template
					FROM character_inventory
					WHERE guid = ' . $id . ' AND item_template = ' . $template['entry'] . ' ');
                while ($inventory = $sqlc->fetch_assoc($character)) {
                    $instance = $sqlc->query('
						SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", 15), " ", -1) AS UNSIGNED) AS item
						FROM item_instance
						WHERE guid = ' . $inventory['item'] . ' ');
                    $output .= '
			<tr valign="center">
				<td >
					<a style="padding:2px;" href="' . $item_datasite . $inventory['item_template'] . '" target="_blank">
						<img src="' . get_item_icon($inventory['item_template'], $sqlm) . '" alt="' . $inventory['item_template'] . '" class="icon_border_0" />
					</a>
				</td>
				<td>
					' . $instance['item'] . '
				</td>
				<td>
					<span onmousemove="toolTip(\'' . $template['description'] . '\', \'item_tooltip\')" onmouseout="toolTip()">' . get_item_name($inventory['item_template'], $sqlw) . '</span>
				</td>
			</tr>';
                }
            }
            $output .= '
		</table>';
            unset($template);
            unset($inventory);
            unset($item);
            unset($character);
            unset($instance);
            //---------------Page Specific Data Ends Here--------------------------
            $output .= '
	</div>
</div>
<br />';
            require_once './include/char/include/char_ footer.php';
            $output .= '
<br />
</center>';
        } else {
            error($lang_char['no_permission']);
        }
    } else {
        error($lang_char['no_char_found']);
    }
}

예제 #20

파일: index.php 프로젝트: emiedson/sanasol

        echo $this->linkToItem($char->card0, get_item_name($char->card0, $server));
        ?>
		</td>
		<td>
			<?php 
        echo $this->linkToItem($char->card1, get_item_name($char->card1, $server));
        ?>
		</td>
		<td>
			<?php 
        echo $this->linkToItem($char->card2, get_item_name($char->card2 > 255 && $char->card0 != 254 ? $char->card2 : 0, $server));
        ?>
		</td>
		<td>
			<?php 
        echo $this->linkToItem($char->card3, get_item_name($char->card3, $server));
        ?>
		</td>
	</tr>
	<?php 
    }
    ?>
</table>
<?php 
    echo $paginator->getHTML();
} else {
    ?>
<p>Nothing was found on <?php 
    echo htmlspecialchars($server->serverName);
    ?>
. <a href="javascript:history.go(-1)">Go back</a>.</p>

예제 #21

파일: item.php 프로젝트: BACKUPLIB/Infinity_MaNGOS

function edit()
{
    global $lang_global, $lang_item_templ, $lang_item, $lang_item_edit, $output, $world_db, $realm_id, $item_datasite, $lang_id_tab, $quest_datasite, $action_permission, $user_lvl, $creature_datasite;
    wowhead_tt();
    valid_login($action_permission['read']);
    if (!isset($_GET['entry'])) {
        redirect("item.php?error=1");
    }
    $sql = new SQL();
    $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
    $entry = $sql->quote_smart($_GET['entry']);
    $deplang = get_lang_id();
    $result = $sql->query("SELECT `item_template`.`entry`,`class`,`subclass`,`unk0`,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`RandomSuffix`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`TotemCategory`,`socketColor_1`,`socketContent_1`,`socketColor_2`,`socketContent_2`,`socketColor_3`,`socketContent_3`,`socketBonus`,`GemProperties`,`RequiredDisenchantSkill`,`ArmorDamageModifier`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot` FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry WHERE item_template.entry = '{$entry}'");
    if ($result) {
        $item = $sql->fetch_assoc($result);
        require_once "scripts/get_lib.php";
        //$tooltip = get_item_tooltip($entry);
        $output .= "<script type=\"text/javascript\" src=\"libs/js/tab.js\"></script>\n   <center>\n    <br /><br /><br />\n    <form method=\"post\" action=\"item.php?action=do_update\" name=\"form1\">\n    <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>\n    <input type=\"hidden\" name=\"type\" value=\"edit\"/>\n    <input type=\"hidden\" name=\"entry\" value=\"{$entry}\"/>\n\n<div class=\"jtab-container\" id=\"container\">\n  <ul class=\"jtabs\">\n    <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_item_edit['general_tab']}</a></li>\n    <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_item_edit['additional_tab']}</a></li>\n    <li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_item_edit['stats_tab']}</a></li>\n  <li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_item_edit['damage_tab']}</a></li>\n  <li><a href=\"#\" onclick=\"return showPane('pane5', this)\">{$lang_item_edit['spell_tab']}</a></li>\n  <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_item_edit['sock_tab']}</a></li>\n  <li><a href=\"#\" onclick=\"return showPane('pane6', this)\">{$lang_item_edit['req_tab']}</a></li>\n  <li><a href=\"#\" onclick=\"return showPane('pane8', this)\">{$lang_item_edit['info']}</a></li>";
        if ($item['DisenchantID']) {
            $output .= "<li><a href=\"#\" onclick=\"return showPane('pane9', this)\">{$lang_item_edit['disenchant_tab']}</a></li>";
        }
        $output .= "</ul>\n  <div class=\"jtab-panes\">";
        $output .= "<div id=\"pane1\">\n    <br /><br />\n<table class=\"lined\" style=\"width: 720px;\">\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['general']}:</td></tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['entry'], $lang_item_edit['entry_desc']) . "</td>\n <td>";
        //$output .= maketooltip($entry, "$item_datasite$entry", $tooltip, "item_tooltip");
        $output .= "</td>\n <td>" . makeinfocell($lang_item_edit['display_id'], $lang_item_edit['display_id_desc']) . "</td>\n <td><input type=\"text\" name=\"displayid\" size=\"8\" maxlength=\"11\" value=\"{$item['displayid']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['req_level'], $lang_item_edit['req_level_desc']) . "</td>\n <td><input type=\"text\" name=\"RequiredLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['RequiredLevel']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['item_level'], $lang_item_edit['item_level_desc']) . "</td>\n <td><input type=\"text\" name=\"ItemLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['ItemLevel']}\" /></td>\n</tr>\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['names']}:</td></tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['item_name'], $lang_item_edit['item_name_desc']) . "</td>\n <td colspan=\"3\"><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"225\" value=\"{$item['name']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['script_name'], $lang_item_edit['script_name_desc']) . "</td>\n <td colspan=\"3\"><input type=\"text\" name=\"ScriptName\" size=\"30\" maxlength=\"100\" value=\"{$item['ScriptName']}\" /></td>\n</tr>\n\n<tr>\n <td>" . makeinfocell($lang_item_edit['description'], $lang_item_edit['description_desc']) . "</td>\n <td colspan=\"3\"><input type=\"text\" name=\"description\" size=\"30\" maxlength=\"225\" value=\"{$item['description']}\" /></td>\n <td colspan=\"4\"></td>\n</tr>\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['type']}:</td></tr>\n   <tr>";
        $class = array(0 => "", 1 => "", 2 => "", 4 => "", 5 => "", 6 => "", 7 => "", 9 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "");
        $class[$item['class']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['class'], $lang_item_edit['class_desc']) . "</td>\n  <td colspan=\"3\"><select name=\"class\">\n    <option value=\"0\" {$class[0]}>0 - {$lang_item['consumable']}</option>\n    <option value=\"1\" {$class[1]}>1 - {$lang_item['bag']}</option>\n    <option value=\"2\" {$class[2]}>2 - {$lang_item['weapon']}</option>\n    <option value=\"4\" {$class[4]}>4 - {$lang_item['armor']}</option>\n    <option value=\"5\" {$class[5]}>5 - {$lang_item['reagent']}</option>\n    <option value=\"6\" {$class[6]}>6 - {$lang_item['projectile']}</option>\n    <option value=\"7\" {$class[7]}>7 - {$lang_item['trade_goods']}s</option>\n    <option value=\"9\" {$class[9]}>9 - {$lang_item['recipe']}</option>\n    <option value=\"11\" {$class[11]}>11 - {$lang_item['quiver']}</option>\n    <option value=\"12\" {$class[12]}>12 - {$lang_item['quest']}</option>\n    <option value=\"13\" {$class[13]}>13 - {$lang_item['key']}</option>\n    <option value=\"14\" {$class[14]}>14 - {$lang_item['permanent']}</option>\n    <option value=\"15\" {$class[15]}>15 - {$lang_item['misc_short']}</option>\n     </select></td>";
        unset($class);
        $subclass = array(0 => array(0 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => ""), 1 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => ""), 2 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => ""), 4 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => ""), 6 => array(2 => "", 3 => ""), 7 => array(0 => "", 1 => "", 2 => "", 3 => ""), 9 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => ""), 11 => array(2 => "", 3 => ""), 13 => array(0 => "", 1 => ""));
        $subclass[$item['class']][$item['subclass']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['subclass'], $lang_item_edit['subclass_desc']) . "</td>\n  <td colspan=\"3\"><select name=\"subclass\">\n    <option value=\"0\" {$subclass[0][0]}>0 - {$lang_item['none']}</option>\n    <optgroup label=\"Class 0: {$lang_item['consumable']}\">\n    <option value=\"0\" {$subclass[0][0]}>0 - {$lang_item['consumable']}</option>\n    <option value=\"3\" {$subclass[0][3]}>3 - {$lang_item['potion']}</option>\n    <option value=\"4\" {$subclass[0][4]}>4 - {$lang_item['scroll']}</option>\n    <option value=\"5\" {$subclass[0][5]}>5 - {$lang_item['bandage']}</option>\n    <option value=\"6\" {$subclass[0][6]}>6 - {$lang_item['healthstone']}</option>\n    <option value=\"7\" {$subclass[0][7]}>7 - {$lang_item['combat_effect']}</option>\n  <optgroup label=\"Class 1: {$lang_item['bag']}\">\n    <option value=\"0\" {$subclass[1][0]}>0 - {$lang_item['bag']}</option>\n    <option value=\"1\" {$subclass[1][1]}>1 - {$lang_item['soul_shards']}</option>\n    <option value=\"2\" {$subclass[1][2]}>2 - {$lang_item['herbs']}</option>\n    <option value=\"3\" {$subclass[1][3]}>3 - {$lang_item['enchanting']}</option>\n    <option value=\"4\" {$subclass[1][4]}>4 - {$lang_item['engineering']}</option>\n    <option value=\"5\" {$subclass[1][5]}>5 - {$lang_item['gems']}</option>\n    <option value=\"6\" {$subclass[1][6]}>6 - {$lang_item['mining']}</option>\n  <optgroup label=\"Class 2: {$lang_item['weapon']}\">\n    <option value=\"0\" {$subclass[2][0]}>0 - {$lang_item['axe_1h']}</option>\n    <option value=\"1\" {$subclass[2][2]}>1 - {$lang_item['axe_2h']}</option>\n    <option value=\"2\" {$subclass[2][2]}>2 - {$lang_item['bow']}</option>\n    <option value=\"3\" {$subclass[2][2]}>3 - {$lang_item['rifle']}</option>\n    <option value=\"4\" {$subclass[2][4]}>4 - {$lang_item['mace_1h']}</option>\n    <option value=\"5\" {$subclass[2][5]}>5 - {$lang_item['mace_2h']}</option>\n    <option value=\"6\" {$subclass[2][6]}>6 - {$lang_item['polearm']}</option>\n    <option value=\"7\" {$subclass[2][7]}>7 - {$lang_item['sword_1h']}</option>\n    <option value=\"8\" {$subclass[2][8]}>8 - {$lang_item['sword_2h']}</option>\n    <option value=\"10\" {$subclass[2][10]}>10 - {$lang_item['staff']}</option>\n    <option value=\"11\" {$subclass[2][11]}>11 - {$lang_item['exotic_1h']}</option>\n    <option value=\"12\" {$subclass[2][12]}>12 - {$lang_item['exotic_2h']}</option>\n    <option value=\"13\" {$subclass[2][13]}>13 - {$lang_item['fist_weapon']}</option>\n    <option value=\"14\" {$subclass[2][14]}>14 - {$lang_item['misc_weapon']}</option>\n    <option value=\"15\" {$subclass[2][15]}>15 - {$lang_item['dagger']}</option>\n    <option value=\"16\" {$subclass[2][16]}>16 - {$lang_item['thrown']}</option>\n    <option value=\"17\" {$subclass[2][17]}>17 - {$lang_item['spear']}</option>\n    <option value=\"18\" {$subclass[2][18]}>18 - {$lang_item['crossbow']}</option>\n    <option value=\"19\" {$subclass[2][19]}>19 - {$lang_item['wand']}</option>\n    <option value=\"20\" {$subclass[2][20]}>20 - {$lang_item['fishing_pole']}</option>\n  </optgroup>\n  <optgroup label=\"Class 4: {$lang_item['armor']}\">\n    <option value=\"0\" {$subclass[4][0]}>0 - {$lang_item['misc']}</option>\n    <option value=\"1\" {$subclass[4][1]}>1 - {$lang_item['cloth']}</option>\n    <option value=\"2\" {$subclass[4][2]}>2 - {$lang_item['leather']}</option>\n    <option value=\"3\" {$subclass[4][3]}>3 - {$lang_item['mail']}</option>\n    <option value=\"4\" {$subclass[4][4]}>4 - {$lang_item['plate']}</option>\n    <option value=\"5\" {$subclass[4][5]}>5 - {$lang_item['buckler']}</option>\n    <option value=\"6\" {$subclass[4][6]}>6 - {$lang_item['shield']}</option>\n    <option value=\"7\" {$subclass[4][7]}>7 - {$lang_item['libram']}</option>\n    <option value=\"8\" {$subclass[4][8]}>8 - {$lang_item['idol']}</option>\n    <option value=\"9\" {$subclass[4][9]}>9 - {$lang_item['totem']}</option>\n  </optgroup>\n  <optgroup label=\"Class 6: {$lang_item['projectile']}\">\n    <option value=\"2\" {$subclass[6][2]}>2 - {$lang_item['arrows']}</option>\n    <option value=\"3\" {$subclass[6][3]}>3 - {$lang_item['bullets']}</option>\n  </optgroup>\n  <optgroup label=\"Class 7: {$lang_item['trade_goods']}\">\n    <option value=\"0\" {$subclass[7][0]}>0 - {$lang_item['trade_goods']}</option>\n    <option value=\"1\" {$subclass[7][1]}>1 - {$lang_item['parts']}</option>\n    <option value=\"2\" {$subclass[7][2]}>2 - {$lang_item['explosives']}</option>\n    <option value=\"3\" {$subclass[7][3]}>3 - {$lang_item['devices']}</option>\n  </optgroup>\n  <optgroup label=\"Class 9: {$lang_item['recipe']}\">\n    <option value=\"0\" {$subclass[9][0]}>0 - {$lang_item['book']}</option>\n    <option value=\"1\" {$subclass[9][1]}>1 - {$lang_item['LW_pattern']}</option>\n    <option value=\"2\" {$subclass[9][2]}>2 - {$lang_item['tailoring_pattern']}</option>\n    <option value=\"3\" {$subclass[9][3]}>3 - {$lang_item['ENG_Schematic']}</option>\n    <option value=\"4\" {$subclass[9][4]}>4 - {$lang_item['BS_plans']}</option>\n    <option value=\"5\" {$subclass[9][5]}>5 - {$lang_item['cooking_recipe']}</option>\n    <option value=\"6\" {$subclass[9][6]}>6 - {$lang_item['alchemy_recipe']}</option>\n    <option value=\"7\" {$subclass[9][7]}>7 - {$lang_item['FA_manual']}</option>\n    <option value=\"8\" {$subclass[9][8]}>8 - {$lang_item['ench_formula']}</option>\n    <option value=\"9\" {$subclass[9][9]}>9 - {$lang_item['fishing_manual']}</option>\n    <option value=\"10\" {$subclass[9][10]}>10 - {$lang_item['JC_formula']}</option>\n  </optgroup>\n  <optgroup label=\"Class 11: {$lang_item['quiver']}\">\n    <option value=\"2\" {$subclass[11][2]}>2 - {$lang_item['quiver']}</option>\n    <option value=\"3\" {$subclass[11][3]}>3 - {$lang_item['ammo_pouch']}</option>\n  </optgroup>\n  <optgroup label=\"Class 13: {$lang_item['key']}\">\n    <option value=\"0\" {$subclass[13][0]}>0 - {$lang_item['key']}</option>\n    <option value=\"1\" {$subclass[13][1]}>1 - {$lang_item['lockpick']}</option>\n  </optgroup>\n </select></td>\n</tr>\n<tr>";
        unset($subclass);
        $quality = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "");
        $quality[$item['Quality']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['quality'], $lang_item_edit['quality_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"Quality\">\n    <option value=\"0\" {$quality[0]}>0 - {$lang_item['poor']}</option>\n    <option value=\"1\" {$quality[1]}>1 - {$lang_item['common']}</option>\n    <option value=\"2\" {$quality[2]}>2 - {$lang_item['uncommon']}</option>\n    <option value=\"3\" {$quality[3]}>3 - {$lang_item['rare']}</option>\n    <option value=\"4\" {$quality[4]}>4 - {$lang_item['epic']}</option>\n    <option value=\"5\" {$quality[5]}>5 - {$lang_item['legendary']}</option>\n    <option value=\"6\" {$quality[6]}>6 - {$lang_item['artifact']}</option>\n     </select></td>";
        unset($quality);
        $inv_type = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => "", 21 => "", 22 => "", 23 => "", 24 => "", 25 => "", 26 => "");
        $inv_type[$item['InventoryType']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['inv_type'], $lang_item_edit['inv_type_desc']) . "</td>\n    <td colspan=\"2\"><select name=\"InventoryType\">\n    <option value=\"0\" {$inv_type[0]}>0 - {$lang_item['other']}</option>\n    <option value=\"1\" {$inv_type[1]}>1 - {$lang_item['head']}</option>\n    <option value=\"2\" {$inv_type[2]}>2 - {$lang_item['neck']}</option>\n    <option value=\"3\" {$inv_type[3]}>3 - {$lang_item['shoulder']}</option>\n    <option value=\"4\" {$inv_type[4]}>4 - {$lang_item['shirt']}</option>\n    <option value=\"5\" {$inv_type[5]}>5 - {$lang_item['chest']}</option>\n    <option value=\"6\" {$inv_type[6]}>6 - {$lang_item['belt']}</option>\n    <option value=\"7\" {$inv_type[7]}>7 - {$lang_item['legs']}</option>\n    <option value=\"8\" {$inv_type[8]}>8 - {$lang_item['feet']}</option>\n    <option value=\"9\" {$inv_type[9]}>9 - {$lang_item['belt']}</option>\n    <option value=\"10\" {$inv_type[10]}>10 - {$lang_item['gloves']}</option>\n    <option value=\"11\" {$inv_type[11]}>11 - {$lang_item['finger']}</option>\n    <option value=\"12\" {$inv_type[12]}>12 - {$lang_item['trinket']}</option>\n    <option value=\"13\" {$inv_type[13]}>13 - {$lang_item['one_hand']}</option>\n    <option value=\"14\" {$inv_type[14]}>14 - {$lang_item['off_hand']}</option>\n    <option value=\"15\" {$inv_type[15]}>15 - {$lang_item['bow']}</option>\n    <option value=\"16\" {$inv_type[16]}>16 - {$lang_item['back']}</option>\n    <option value=\"17\" {$inv_type[17]}>17 - {$lang_item['two_hand']}</option>\n    <option value=\"18\" {$inv_type[18]}>18 - {$lang_item['bag']}</option>\n    <option value=\"19\" {$inv_type[19]}>19 - {$lang_item['tabard']}</option>\n    <option value=\"20\" {$inv_type[20]}>20 - {$lang_item['robe']}</option>\n    <option value=\"21\" {$inv_type[21]}>21 - {$lang_item['main_hand']}</option>\n    <option value=\"22\" {$inv_type[22]}>22 - {$lang_item['off_misc']}</option>\n    <option value=\"23\" {$inv_type[23]}>23 - {$lang_item['tome']}</option>\n    <option value=\"24\" {$inv_type[24]}>24 - {$lang_item['projectile']}</option>\n    <option value=\"25\" {$inv_type[25]}>25 - {$lang_item['thrown']}</option>\n    <option value=\"26\" {$inv_type[26]}>26 - {$lang_item['rifle']}</option>\n     </select></td>\n\n     <td>" . makeinfocell($lang_item_edit['flags'], $lang_item_edit['flags_desc']) . "</td>\n     <td><input type=\"text\" name=\"Flags\" size=\"10\" maxlength=\"30\" value=\"{$item['Flags']}\" /></td>\n     </tr>\n\n     <tr>\n     <td>" . makeinfocell($lang_item_edit['item_set'], $lang_item_edit['item_set_desc']) . "</td>\n     <td><input type=\"text\" name=\"itemset\" size=\"10\" maxlength=\"30\" value=\"{$item['itemset']}\" /></td>";
        unset($inv_type);
        $bonding = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
        $bonding[$item['bonding']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['bonding'], $lang_item_edit['bonding_desc']) . "</td>\n   <td colspan=\"3\"><select name=\"bonding\">\n    <option value=\"0\" {$bonding[0]}>0 - {$lang_item['no_bind']}</option>\n    <option value=\"1\" {$bonding[1]}>1 - {$lang_item['bop']}</option>\n    <option value=\"2\" {$bonding[2]}>2 - {$lang_item['boe']}</option>\n    <option value=\"3\" {$bonding[3]}>3 - {$lang_item['bou']}</option>\n    <option value=\"4\" {$bonding[4]}>4 - {$lang_item['quest_item']}</option>\n    <option value=\"5\" {$bonding[5]}>5 - {$lang_item['quest_item']}1</option>\n     </select></td>\n\n<td>" . makeinfocell($lang_item_edit['start_quest'], $lang_item_edit['start_quest_desc']) . "</td>\n<td><input type=\"text\" name=\"startquest\" size=\"10\" maxlength=\"30\" value=\"{$item['startquest']}\" /></td>\n\n</tr>\n</table>\n<br />{$lang_item_edit['short_rules_desc']}<br /><br />\n</div>";
        unset($bonding);
        $output .= "<div id=\"pane2\">\n  <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n  <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['vendor']}:</td></tr>\n  <tr>\n   <td>" . makeinfocell($lang_item_edit['buy_count'], $lang_item_edit['buy_count_desc']) . "</td>\n   <td><input type=\"text\" name=\"BuyCount\" size=\"8\" maxlength=\"3\" value=\"{$item['BuyCount']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['buy_price'], $lang_item_edit['buy_price_desc']) . "</td>\n   <td><input type=\"text\" name=\"BuyPrice\" size=\"8\" maxlength=\"30\" value=\"{$item['BuyPrice']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['sell_price'], $lang_item_edit['sell_price_desc']) . "</td>\n   <td><input type=\"text\" name=\"SellPrice\" size=\"8\" maxlength=\"30\" value=\"{$item['SellPrice']}\" /></td>\n   <td></td><td></td>\n  </tr>\n\n  <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['container']}:</td></tr>\n  <tr>\n\n    <td>" . makeinfocell($lang_item_edit['max_count'], $lang_item_edit['max_count_desc']) . "</td>\n    <td><input type=\"text\" name=\"maxcount\" size=\"6\" maxlength=\"5\" value=\"{$item['maxcount']}\" /></td>\n\n    <td>" . makeinfocell($lang_item_edit['stackable'], $lang_item_edit['stackable_desc']) . "</td>\n    <td><input type=\"text\" name=\"stackable\" size=\"6\" maxlength=\"5\" value=\"{$item['stackable']}\" /></td>\n\n    <td>" . makeinfocell($lang_item_edit['bag_family'], $lang_item_edit['bag_family_desc']) . "</td>";
        $bagfamily = array(0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 12 => "");
        $bagfamily[$item['BagFamily']] = " selected=\"selected\" ";
        $output .= "<td><select name=\"BagFamily\">\n    <option value=\"0\" {$bagfamily[0]}>0 - {$lang_item['none']}</option>\n    <option value=\"1\" {$bagfamily[1]}>1 - {$lang_item['arrows']}</option>\n    <option value=\"2\" {$bagfamily[2]}>2 - {$lang_item['bullets']}</option>\n    <option value=\"3\" {$bagfamily[3]}>3 - {$lang_item['soul_shards']}</option>\n    <option value=\"6\" {$bagfamily[6]}>6 - {$lang_item['herbs']}</option>\n    <option value=\"7\" {$bagfamily[7]}>7 - {$lang_item['enchanting']}</option>\n    <option value=\"8\" {$bagfamily[8]}>8 - {$lang_item['engineering']}</option>\n    <option value=\"9\" {$bagfamily[9]}>9 - {$lang_item['keys']}</option>\n    <option value=\"10\" {$bagfamily[10]}>10 - {$lang_item['gems']}</option>\n    <option value=\"12\" {$bagfamily[12]}>12 - {$lang_item['mining']}</option>\n     </select></td>\n  <td>" . makeinfocell($lang_item_edit['bag_slots'], $lang_item_edit['bag_slots_desc']) . "</td>\n  <td><input type=\"text\" name=\"ContainerSlots\" size=\"10\" maxlength=\"3\" value=\"{$item['ContainerSlots']}\" /></td>\n  </tr>\n  <tr>\n\n  <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['materials']}:</td></tr>";
        unset($bagfamily);
        $Material = array(-1 => "", 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "");
        $Material[$item['Material']] = " selected=\"selected\" ";
        $output .= "<tr>\n  <td>" . makeinfocell($lang_item_edit['material'], $lang_item_edit['material_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"Material\">\n    <option value=\"-1\" {$Material[-1]}>-1 - {$lang_item_edit['consumables']}</option>\n    <option value=\"0\" {$Material[0]}>0 - {$lang_item_edit['none']}</option>\n    <option value=\"1\" {$Material[1]}>1 - {$lang_item_edit['metal']}</option>\n    <option value=\"2\" {$Material[2]}>2 - {$lang_item_edit['wood']}</option>\n    <option value=\"3\" {$Material[3]}>3 - {$lang_item_edit['liquid']}</option>\n    <option value=\"4\" {$Material[4]}>4 - {$lang_item_edit['jewelry']}</option>\n    <option value=\"5\" {$Material[5]}>5 - {$lang_item_edit['chain']}</option>\n    <option value=\"6\" {$Material[6]}>6 - {$lang_item_edit['plate']}</option>\n    <option value=\"7\" {$Material[7]}>7 - {$lang_item_edit['cloth']}</option>\n    <option value=\"8\" {$Material[8]}>8 - {$lang_item_edit['leather']}</option>\n     </select></td>";
        unset($Material);
        $PageMaterial = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
        $PageMaterial[$item['PageMaterial']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['page_material'], $lang_item_edit['page_material_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"PageMaterial\">\n    <option value=\"0\" {$PageMaterial[0]}>0 - {$lang_item_edit['none']}</option>\n    <option value=\"1\" {$PageMaterial[1]}>1 - {$lang_item_edit['parchment']}</option>\n    <option value=\"2\" {$PageMaterial[2]}>2 - {$lang_item_edit['stone']}</option>\n    <option value=\"3\" {$PageMaterial[3]}>3 - {$lang_item_edit['marble']}</option>\n    <option value=\"4\" {$PageMaterial[4]}>4 - {$lang_item_edit['silver']}</option>\n    <option value=\"5\" {$PageMaterial[5]}>5 - {$lang_item_edit['bronze']}</option>\n     </select></td>";
        unset($PageMaterial);
        $output .= "<td>" . makeinfocell($lang_item_edit['max_durability'], $lang_item_edit['max_durability_desc']) . "</td>\n  <td><input type=\"text\" name=\"MaxDurability\" size=\"8\" maxlength=\"30\" value=\"{$item['MaxDurability']}\" /></td>\n</tr>\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['RandomProperty']}:</td></tr>\n<tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item_edit['RandomProperty'], $lang_item_edit['RandomProperty_desc']) . "</td>\n   <td colspan=\"2\"><input type=\"text\" name=\"RandomProperty\" size=\"8\" maxlength=\"30\" value=\"{$item['RandomProperty']}\" /></td>\n\n   <td colspan=\"2\">" . makeinfocell($lang_item_edit['RandomSuffix'], $lang_item_edit['RandomSuffix_desc']) . "</td>\n   <td colspan=\"2\"><input type=\"text\" name=\"RandomSuffix\" size=\"8\" maxlength=\"10\" value=\"{$item['RandomSuffix']}\" /></td>\n</tr>\n\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['other']}:</td></tr>\n  <tr>\n   <td>" . makeinfocell($lang_item_edit['area'], $lang_item_edit['area_desc']) . "</td>\n   <td><input type=\"text\" name=\"area\" size=\"8\" maxlength=\"10\" value=\"{$item['area']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['map'], $lang_item_edit['map_desc']) . "</td>\n   <td><input type=\"text\" name=\"Map\" size=\"8\" maxlength=\"10\" value=\"{$item['Map']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['page_text'], $lang_item_edit['page_text_desc']) . "</td>\n   <td><input type=\"text\" name=\"PageText\" size=\"6\" maxlength=\"30\" value=\"{$item['PageText']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['unk0'], $lang_item_edit['unk0_desc']) . "</td>\n   <td><input type=\"text\" name=\"unk0\" size=\"8\" maxlength=\"10\" value=\"{$item['unk0']}\" /></td>\n  </tr>\n  <tr>\n\n    <tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item_edit['disenchant_id'], $lang_item_edit['disenchant_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"DisenchantID\" size=\"10\" maxlength=\"10\" value=\"{$item['DisenchantID']}\" /></td>\n\n   <td colspan=\"2\">" . makeinfocell($lang_item_edit['req_skill_disenchant'], $lang_item_edit['req_skill_disenchant_desc']) . "</td>\n   <td><input type=\"text\" name=\"RequiredDisenchantSkill\" size=\"10\" maxlength=\"10\" value=\"{$item['RequiredDisenchantSkill']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['lock_id'], $lang_item_edit['lock_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"lockid\" size=\"8\" maxlength=\"30\" value=\"{$item['lockid']}\" /></td>\n  </tr>";
        $LanguageID = array(0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 33 => "");
        $LanguageID[$item['LanguageID']] = " selected=\"selected\" ";
        $output .= "<tr>\n  <td>" . makeinfocell($lang_item_edit['lang_id'], $lang_item_edit['lang_id_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"LanguageID\">\n    <option value=\"0\" {$LanguageID[0]}>0 - {$lang_item_edit['other']}</option>\n    <option value=\"1\" {$LanguageID[1]}>1 - Orcish</option>\n    <option value=\"2\" {$LanguageID[2]}>2 - Darnassian</option>\n    <option value=\"3\" {$LanguageID[3]}>3 - Taurahe</option>\n    <option value=\"6\" {$LanguageID[6]}>6 - Dwarvish</option>\n    <option value=\"7\" {$LanguageID[7]}>7 - Common</option>\n    <option value=\"8\" {$LanguageID[8]}>8 - Demonic</option>\n    <option value=\"9\" {$LanguageID[9]}>9 - Titan</option>\n    <option value=\"10\" {$LanguageID[10]}>10 - Thelassian</option>\n    <option value=\"11\" {$LanguageID[11]}>11 - Draconic</option>\n    <option value=\"12\" {$LanguageID[12]}>12 - Kalimag</option>\n    <option value=\"13\" {$LanguageID[13]}>13 - Gnomish</option>\n    <option value=\"14\" {$LanguageID[14]}>14 - Troll</option>\n    <option value=\"33\" {$LanguageID[33]}>33 - Gutterspeak</option>\n     </select></td>";
        unset($LanguageID);
        $sheath = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 7 => "");
        $sheath[$item['sheath']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['sheath'], $lang_item_edit['sheath_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"sheath\">\n    <option value=\"0\" {$sheath[0]}>0 - {$lang_item_edit['other']}</option>\n    <option value=\"1\" {$sheath[1]}>1 - {$lang_item['sword_2h']}</option>\n    <option value=\"2\" {$sheath[2]}>2 - {$lang_item['staff']}</option>\n    <option value=\"3\" {$sheath[3]}>3 - {$lang_item['sword_1h']}</option>\n    <option value=\"4\" {$sheath[4]}>4 - {$lang_item['shield']}</option>\n    <option value=\"5\" {$sheath[5]}>5 - {$lang_item['rod']}</option>\n    <option value=\"7\" {$sheath[7]}>7 - {$lang_item['off_hand']}</option>\n     </select></td>\n\n   <td>" . makeinfocell($lang_item_edit['totem_category'], $lang_item_edit['totem_category_desc']) . "</td>\n   <td><input type=\"text\" name=\"TotemCategory\" size=\"8\" maxlength=\"10\" value=\"{$item['TotemCategory']}\" /></td>\n  </tr>\n\n   </table><br /><br />\n    </div>";
        unset($sheath);
        $output .= "<div id=\"pane3\">\n   <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n  <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['stats']}:</td></tr>\n  <tr>\n\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 1", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type1\">";
        output_status_options($item['stat_type1']);
        $output .= "</select></td>\n\n  <td><input type=\"text\" name=\"stat_value1\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value1']}\" /></td>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 2", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type2\">";
        output_status_options($item['stat_type2']);
        $output .= "</select></td>\n\n   <td><input type=\"text\" name=\"stat_value2\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value2']}\" /></td>\n  </tr>\n <tr>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 3", $lang_item_edit['stat_type_desc']) . "</td>\n  <td><select name=\"stat_type3\">";
        output_status_options($item['stat_type3']);
        $output .= "</select></td>\n\n  <td><input type=\"text\" name=\"stat_value3\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value3']}\" /></td>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 4", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type4\">";
        output_status_options($item['stat_type4']);
        $output .= "</select></td>\n\n   <td><input type=\"text\" name=\"stat_value4\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value4']}\" /></td>\n  </tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 5", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type5\">";
        output_status_options($item['stat_type5']);
        $output .= "</select></td>\n\n   <td><input type=\"text\" name=\"stat_value5\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value5']}\" /></td>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 6", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type6\">";
        output_status_options($item['stat_type1']);
        $output .= "</select></td>\n\n   <td><input type=\"text\" name=\"stat_value6\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value6']}\" /></td>\n  </tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 7", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type7\">";
        output_status_options($item['stat_type7']);
        $output .= "</select></td>\n  <td><input type=\"text\" name=\"stat_value7\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value7']}\" /></td>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 8", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type8\">";
        output_status_options($item['stat_type8']);
        $output .= "</select></td>\n\n   <td><input type=\"text\" name=\"stat_value8\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value8']}\" /></td>\n  </tr>\n<tr>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 9", $lang_item_edit['stat_type_desc']) . "</td>\n  <td><select name=\"stat_type9\">";
        output_status_options($item['stat_type9']);
        $output .= "</select></td>\n  <td><input type=\"text\" name=\"stat_value9\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value9']}\" /></td>\n  <td>" . makeinfocell($lang_item_edit['stat_type'] . " 10", $lang_item_edit['stat_type_desc']) . "</td>\n   <td><select name=\"stat_type10\">";
        output_status_options($item['stat_type10']);
        $output .= "</select></td>\n\n   <td><input type=\"text\" name=\"stat_value10\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value10']}\" /></td>\n  </tr>\n\n  <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['resis_armor']}:</td></tr>\n   <tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item['armor'], $lang_item_edit['armor_desc']) . "</td>\n   <td><input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"30\" value=\"{$item['armor']}\" /></td>\n\n   <td colspan=\"2\">" . makeinfocell($lang_item['block'], $lang_item_edit['block_desc']) . "</td>\n   <td><input type=\"text\" name=\"block\" size=\"10\" maxlength=\"30\" value=\"{$item['block']}\" /></td>\n   </tr>\n   <tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item['res_holy'], $lang_item_edit['res_holy_desc']) . "</td>\n   <td><input type=\"text\" name=\"holy_res\" size=\"10\" maxlength=\"30\" value=\"{$item['holy_res']}\" /></td>\n\n   <td colspan=\"2\">" . makeinfocell($lang_item['res_fire'], $lang_item_edit['res_fire_desc']) . "</td>\n   <td><input type=\"text\" name=\"fire_res\" size=\"10\" maxlength=\"30\" value=\"{$item['fire_res']}\" /></td>\n   </tr>\n   <tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item['res_nature'], $lang_item_edit['res_nature_desc']) . "</td>\n   <td><input type=\"text\" name=\"nature_res\" size=\"10\" maxlength=\"30\" value=\"{$item['nature_res']}\" /></td>\n\n   <td colspan=\"2\">" . makeinfocell($lang_item['res_frost'], $lang_item_edit['res_frost_desc']) . "</td>\n   <td><input type=\"text\" name=\"frost_res\" size=\"10\" maxlength=\"30\" value=\"{$item['frost_res']}\" /></td>\n   </tr>\n   <tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item['res_shadow'], $lang_item_edit['res_shadow_desc']) . "</td>\n   <td><input type=\"text\" name=\"shadow_res\" size=\"10\" maxlength=\"30\" value=\"{$item['shadow_res']}\" /></td>\n\n   <td colspan=\"2\">" . makeinfocell($lang_item['res_arcane'], $lang_item_edit['res_arcane_desc']) . "</td>\n   <td><input type=\"text\" name=\"arcane_res\" size=\"10\" maxlength=\"30\" value=\"{$item['arcane_res']}\" /></td>\n   </tr>\n\n    </table><br /><br />\n    </div>";
        $output .= "<div id=\"pane4\">\n     <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n  <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_properties']}:</td></tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['delay'], $lang_item_edit['delay_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"delay\" size=\"10\" maxlength=\"11\" value=\"{$item['delay']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ranged_mod'], $lang_item_edit['ranged_mod_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"RangedModRange\" size=\"10\" maxlength=\"40\" value=\"{$item['RangedModRange']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['armor_dmg_mod'], $lang_item_edit['armor_dmg_mod_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"ArmorDamageModifier\" size=\"10\" maxlength=\"40\" value=\"{$item['ArmorDamageModifier']}\" /></td>";
        $ammo_type = array(0 => "", 2 => "", 3 => "");
        $ammo_type[$item['ammo_type']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['ammo_type'], $lang_item_edit['ammo_type_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"ammo_type\">\n    <option value=\"0\" {$ammo_type[0]}>0 - {$lang_item['none']}</option>\n    <option value=\"2\" {$ammo_type[2]}>2 - {$lang_item['arrows']}</option>\n    <option value=\"3\" {$ammo_type[3]}>3 - {$lang_item['bullets']}</option>\n     </select></td>\n</tr>\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_damage']}:</td></tr>\n<tr>";
        unset($ammo_type);
        $output .= "<td>" . makeinfocell($lang_item_edit['damage_type'] . " 1", $lang_item_edit['damage_type_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"dmg_type1\">";
        output_dmgtype_options($item['dmg_type1']);
        $output .= "</select></td>\n\n   <td>" . makeinfocell($lang_item_edit['dmg_min_max'], $lang_item_edit['dmg_min_max_desc']) . "</td>\n   <td colspan=\"4\"><input type=\"text\" name=\"dmg_min1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min1']}\" /> - <input type=\"text\" name=\"dmg_max1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max1']}\" /></td>\n\n</tr>\n<tr>\n  <td>" . makeinfocell($lang_item_edit['damage_type'] . " 2", $lang_item_edit['damage_type_desc']) . "</td>\n   <td colspan=\"2\"><select name=\"dmg_type2\">";
        output_dmgtype_options($item['dmg_type2']);
        $output .= "</select></td>\n\n   <td>" . makeinfocell($lang_item_edit['dmg_min_max'], $lang_item_edit['dmg_min_max_desc']) . "</td>\n   <td colspan=\"4\"><input type=\"text\" name=\"dmg_min2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min2']}\" /> - <input type=\"text\" name=\"dmg_max2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max2']}\" /></td>\n\n</tr>\n</table><br /><br />\n    </div>";
        $output .= "<div id=\"pane5\">\n     <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n<tr>\n   <td colspan=\"2\">{$lang_item_edit['item_spell']} 1</td>\n   <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellid_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_1']}\" /></td>";
        $spelltrigger_1 = array(0 => "", 1 => "", 2 => "", 4 => "");
        $spelltrigger_1[$item['spelltrigger_1']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n   <td><select name=\"spelltrigger_1\">\n    <option value=\"0\" {$spelltrigger_1[0]}>0: {$lang_item['spell_use']}</option>\n    <option value=\"1\" {$spelltrigger_1[1]}>1: {$lang_item['spell_equip']}</option>\n    <option value=\"2\" {$spelltrigger_1[2]}>2: {$lang_item['spell_coh']}</option>\n    <option value=\"4\" {$spelltrigger_1[4]}>4: {$lang_item['soul_stone']}</option>\n    </select></td>\n   <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcharges_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_1']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_1']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategory_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_1']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategorycooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_1']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellppmRate_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_1']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n   <td colspan=\"2\">{$lang_item_edit['item_spell']} 2</td>\n   <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellid_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_2']}\" /></td>";
        unset($spelltrigger_1);
        $spelltrigger_2 = array(0 => "", 1 => "", 2 => "", 4 => "");
        $spelltrigger_2[$item['spelltrigger_2']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n   <td><select name=\"spelltrigger_2\">\n    <option value=\"0\" {$spelltrigger_2[0]}>0: {$lang_item['spell_use']}</option>\n    <option value=\"1\" {$spelltrigger_2[1]}>1: {$lang_item['spell_equip']}</option>\n    <option value=\"2\" {$spelltrigger_2[2]}>2: {$lang_item['spell_coh']}</option>\n    <option value=\"4\" {$spelltrigger_2[4]}>4: {$lang_item['soul_stone']}</option>\n    </select></td>\n   <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcharges_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_2']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_2']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategory_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_2']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategorycooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_2']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellppmRate_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_2']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n   <td colspan=\"2\">{$lang_item_edit['item_spell']} 3</td>\n   <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellid_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_3']}\" /></td>";
        unset($spelltrigger_2);
        $spelltrigger_3 = array(0 => "", 1 => "", 2 => "", 4 => "");
        $spelltrigger_3[$item['spelltrigger_3']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n   <td><select name=\"spelltrigger_3\">\n    <option value=\"0\" {$spelltrigger_3[0]}>0: {$lang_item['spell_use']}</option>\n    <option value=\"1\" {$spelltrigger_3[1]}>1: {$lang_item['spell_equip']}</option>\n    <option value=\"2\" {$spelltrigger_3[2]}>2: {$lang_item['spell_coh']}</option>\n    <option value=\"4\" {$spelltrigger_3[4]}>4: {$lang_item['soul_stone']}</option>\n    </select></td>\n   <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcharges_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_3']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_3']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategory_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_3']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategorycooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_3']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellppmRate_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_3']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n   <td colspan=\"2\">{$lang_item_edit['item_spell']} 4</td>\n   <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellid_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_4']}\" /></td>";
        unset($spelltrigger_3);
        $spelltrigger_4 = array(0 => "", 1 => "", 2 => "", 4 => "");
        $spelltrigger_4[$item['spelltrigger_4']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n   <td><select name=\"spelltrigger_4\">\n    <option value=\"0\" {$spelltrigger_4[0]}>0: {$lang_item['spell_use']}</option>\n    <option value=\"1\" {$spelltrigger_4[1]}>1: {$lang_item['spell_equip']}</option>\n    <option value=\"2\" {$spelltrigger_4[2]}>2: {$lang_item['spell_coh']}</option>\n    <option value=\"4\" {$spelltrigger_4[4]}>4: {$lang_item['soul_stone']}</option>\n    </select></td>\n   <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcharges_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_4']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_4']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategory_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_4']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategorycooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_4']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellppmRate_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_4']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n   <td colspan=\"2\">{$lang_item_edit['item_spell']} 5</td>\n   <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellid_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_5']}\" /></td>";
        unset($spelltrigger_4);
        $spelltrigger_5 = array(0 => "", 1 => "", 2 => "", 4 => "");
        $spelltrigger_5[$item['spelltrigger_5']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n   <td><select name=\"spelltrigger_5\">\n    <option value=\"0\" {$spelltrigger_5[0]}>0: {$lang_item['spell_use']}</option>\n    <option value=\"1\" {$spelltrigger_5[1]}>1: {$lang_item['spell_equip']}</option>\n    <option value=\"2\" {$spelltrigger_5[2]}>2: {$lang_item['spell_coh']}</option>\n    <option value=\"4\" {$spelltrigger_5[4]}>4: {$lang_item['soul_stone']}</option>\n    </select></td>\n   <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcharges_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_5']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_5']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategory_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_5']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellcategorycooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_5']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n   <td><input type=\"text\" name=\"spellppmRate_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_5']}\" /></td>\n</tr>\n\n</table>\n    </div>";
        unset($spelltrigger_5);
        $output .= "<div id=\"pane6\">\n    <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n   <tr>";
        $AllowableClass = array(-1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "", 1024 => "");
        if ($item['AllowableClass'] == -1) {
            $AllowableClass[-1] = " selected=\"selected\" ";
        } else {
            if ($item['AllowableClass'] & 1) {
                $AllowableClass[1] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 2) {
                $AllowableClass[2] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 4) {
                $AllowableClass[4] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 8) {
                $AllowableClass[8] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 16) {
                $AllowableClass[16] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 32) {
                $AllowableClass[32] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 64) {
                $AllowableClass[64] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 128) {
                $AllowableClass[128] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 256) {
                $AllowableClass[256] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 512) {
                $AllowableClass[512] = " selected=\"selected\" ";
            }
            if ($item['AllowableClass'] & 1024) {
                $AllowableClass[1024] = " selected=\"selected\" ";
            }
        }
        $output .= "<td>" . makeinfocell($lang_item_edit['allow_class'], $lang_item_edit['allow_class_desc']) . "</td>\n   <td><select multiple=\"multiple\" name=\"AllowableClass[]\" size=\"5\">\n    <option value=\"-1\" {$AllowableClass[-1]}>-1 - {$lang_item_edit['all']}</option>\n    <option value=\"1\" {$AllowableClass[1]}>1 - {$lang_id_tab['warrior']}</option>\n    <option value=\"2\" {$AllowableClass[2]}>2 - {$lang_id_tab['paladin']}</option>\n    <option value=\"4\" {$AllowableClass[4]}>4 - {$lang_id_tab['hunter']}</option>\n    <option value=\"8\" {$AllowableClass[8]}>8 - {$lang_id_tab['rogue']}</option>\n    <option value=\"16\" {$AllowableClass[16]}>16 - {$lang_id_tab['priest']}</option>\n    <option value=\"32\" {$AllowableClass[32]}>32 - FUTURE_1</option>\n    <option value=\"64\" {$AllowableClass[64]}>64 - {$lang_id_tab['shaman']}</option>\n    <option value=\"128\" {$AllowableClass[128]}>128 - {$lang_id_tab['mage']}</option>\n    <option value=\"256\" {$AllowableClass[256]}>256 - {$lang_id_tab['warlock']}</option>\n    <option value=\"512\" {$AllowableClass[512]}>512 - FUTURE_2</option>\n    <option value=\"1024\" {$AllowableClass[1024]}>1024 - {$lang_id_tab['druid']}</option>\n     </select></td>";
        unset($AllowableClass);
        $AllowableRace = array(-1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "");
        if ($item['AllowableRace'] == -1) {
            $AllowableRace[-1] = " selected=\"selected\" ";
        } else {
            if ($item['AllowableRace'] & 1) {
                $AllowableRace[1] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 2) {
                $AllowableRace[2] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 4) {
                $AllowableRace[4] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 8) {
                $AllowableRace[8] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 16) {
                $AllowableRace[16] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 32) {
                $AllowableRace[32] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 64) {
                $AllowableRace[64] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 128) {
                $AllowableRace[128] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 256) {
                $AllowableRace[256] = " selected=\"selected\" ";
            }
            if ($item['AllowableRace'] & 512) {
                $AllowableRace[512] = " selected=\"selected\" ";
            }
        }
        $output .= "<td>" . makeinfocell($lang_item_edit['allow_race'], $lang_item_edit['allow_race_desc']) . "</td>\n   <td><select multiple=\"multiple\" name=\"AllowableRace[]\" size=\"5\">\n    <option value=\"-1\" {$AllowableRace[-1]}>-1 - {$lang_item_edit['all']}</option>\n    <option value=\"1\" {$AllowableRace[1]}>1 - {$lang_id_tab['human']}</option>\n    <option value=\"2\" {$AllowableRace[2]}>2 - {$lang_id_tab['orc']}</option>\n    <option value=\"4\" {$AllowableRace[4]}>4 - {$lang_id_tab['dwarf']}</option>\n    <option value=\"8\" {$AllowableRace[8]}>8 - {$lang_id_tab['nightelf']}</option>\n    <option value=\"16\" {$AllowableRace[16]}>16 - {$lang_id_tab['undead']}</option>\n    <option value=\"32\" {$AllowableRace[32]}>32 - {$lang_id_tab['tauren']}</option>\n    <option value=\"64\" {$AllowableRace[64]}>64 - {$lang_id_tab['gnome']}</option>\n    <option value=\"128\" {$AllowableRace[128]}>128 - {$lang_id_tab['troll']}</option>\n    <option value=\"256\" {$AllowableRace[256]}>256 - {$lang_id_tab['draenei']}</option>\n    <option value=\"512\" {$AllowableRace[512]}>512 - {$lang_id_tab['bloodelf']}</option>\n     </select></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['req_skill'], $lang_item_edit['req_skill_desc']) . "</td>\n   <td><input type=\"text\" name=\"RequiredSkill\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkill']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['req_skill_rank'], $lang_item_edit['req_skill_rank_desc']) . "</td>\n   <td><input type=\"text\" name=\"RequiredSkillRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkillRank']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['req_spell'], $lang_item_edit['req_spell_desc']) . "</td>\n   <td><input type=\"text\" name=\"requiredspell\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredspell']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['req_honor_rank'], $lang_item_edit['req_honor_rank_desc']) . "</td>\n   <td><input type=\"text\" name=\"requiredhonorrank\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredhonorrank']}\" /></td>\n</tr>\n<tr>\n   <td>" . makeinfocell($lang_item_edit['req_rep_faction'], $lang_item_edit['req_rep_faction_desc']) . "</td>\n   <td><input type=\"text\" name=\"RequiredReputationFaction\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredReputationFaction']}\" /></td>";
        unset($AllowableRace);
        $RequiredReputationRank = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "");
        $RequiredReputationRank[$item['RequiredReputationRank']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['req_rep_rank'], $lang_item_edit['req_rep_rank_desc']) . "</td>\n      <td><select name=\"RequiredReputationRank\">\n    <option value=\"0\" {$RequiredReputationRank[0]}>0 - {$lang_item_edit['hated']}</option>\n    <option value=\"1\" {$RequiredReputationRank[1]}>1 - {$lang_item_edit['hostile']}</option>\n    <option value=\"2\" {$RequiredReputationRank[2]}>2 - {$lang_item_edit['unfriendly']}</option>\n    <option value=\"3\" {$RequiredReputationRank[3]}>3 - {$lang_item_edit['neutral']}</option>\n    <option value=\"4\" {$RequiredReputationRank[4]}>4 - {$lang_item_edit['friendly']}</option>\n    <option value=\"5\" {$RequiredReputationRank[5]}>5 - {$lang_item_edit['honored']}</option>\n    <option value=\"6\" {$RequiredReputationRank[6]}>6 - {$lang_item_edit['reverted']}</option>\n    <option value=\"7\" {$RequiredReputationRank[7]}>7 - {$lang_item_edit['exalted']}</option>\n     </select></td>\n</tr>\n<tr>\n   <td colspan=\"2\">" . makeinfocell($lang_item_edit['req_city_rank'], $lang_item_edit['req_city_rank_desc']) . "</td>\n   <td colspan=\"2\"><input type=\"text\" name=\"RequiredCityRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredCityRank']}\" /></td>\n</tr>\n\n   </table><br /><br />\n    </div>";
        unset($RequiredReputationRank);
        $output .= "<div id=\"pane7\">\n    <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n<tr>";
        $socketColor_1 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
        $socketColor_1[$item['socketColor_1']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['socket_color'] . " 1", $lang_item_edit['socket_color_desc']) . "</td>\n      <td><select name=\"socketColor_1\">\n        <option value=\"0\" {$socketColor_1[0]}>0: {$lang_item['none']}</option>\n        <option value=\"1\" {$socketColor_1[1]}>1: {$lang_item['socket_meta']}</option>\n        <option value=\"2\" {$socketColor_1[2]}>2: {$lang_item['socket_red']}</option>\n        <option value=\"4\" {$socketColor_1[4]}>4: {$lang_item['socket_yellow']}</option>\n        <option value=\"8\" {$socketColor_1[8]}>8: {$lang_item['socket_blue']}</option>\n      </select></td>\n   <td>" . makeinfocell($lang_item_edit['socket_content'] . " 1", $lang_item_edit['socket_content_desc']) . "</td>\n   <td><input type=\"text\" name=\"socketContent_1\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_1']}\" /></td>\n</tr>\n<tr>";
        unset($socketColor_1);
        $socketColor_2 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
        $socketColor_2[$item['socketColor_2']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['socket_color'] . " 2", $lang_item_edit['socket_color_desc']) . "</td>\n      <td><select name=\"socketColor_2\">\n        <option value=\"0\" {$socketColor_2[0]}>0: {$lang_item['none']}</option>\n        <option value=\"1\" {$socketColor_2[1]}>1: {$lang_item['socket_meta']}</option>\n        <option value=\"2\" {$socketColor_2[2]}>2: {$lang_item['socket_red']}</option>\n        <option value=\"4\" {$socketColor_2[4]}>4: {$lang_item['socket_yellow']}</option>\n        <option value=\"8\" {$socketColor_2[8]}>8: {$lang_item['socket_blue']}</option>\n      </select></td>\n\n   <td>" . makeinfocell($lang_item_edit['socket_content'] . " 2", $lang_item_edit['socket_content_desc']) . "</td>\n   <td><input type=\"text\" name=\"socketContent_2\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_2']}\" /></td>\n</tr>\n<tr>";
        unset($socketColor_2);
        $socketColor_3 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
        $socketColor_3[$item['socketColor_3']] = " selected=\"selected\" ";
        $output .= "<td>" . makeinfocell($lang_item_edit['socket_color'] . " 3", $lang_item_edit['socket_color_desc']) . "</td>\n      <td><select name=\"socketColor_3\">\n        <option value=\"0\" {$socketColor_3[0]}>0: {$lang_item['none']}</option>\n        <option value=\"1\" {$socketColor_3[1]}>1: {$lang_item['socket_meta']}</option>\n        <option value=\"2\" {$socketColor_3[2]}>2: {$lang_item['socket_red']}</option>\n        <option value=\"4\" {$socketColor_3[4]}>4: {$lang_item['socket_yellow']}</option>\n        <option value=\"8\" {$socketColor_3[8]}>8: {$lang_item['socket_blue']}</option>\n      </select></td>\n\n   <td>" . makeinfocell($lang_item_edit['socket_content'] . " 3", $lang_item_edit['socket_content_desc']) . "</td>\n   <td><input type=\"text\" name=\"socketContent_3\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_3']}\" /></td>\n</tr>\n\n<tr>\n   <td>" . makeinfocell($lang_item_edit['socket_bonus'], $lang_item_edit['socket_bonus_desc']) . "</td>\n   <td><input type=\"text\" name=\"socketBonus\" size=\"15\" maxlength=\"10\" value=\"{$item['socketBonus']}\" /></td>\n\n   <td>" . makeinfocell($lang_item_edit['gem_properties'], $lang_item_edit['gem_properties_desc']) . "</td>\n   <td><input type=\"text\" name=\"GemProperties\" size=\"15\" maxlength=\"10\" value=\"{$item['GemProperties']}\" /></td>\n</tr>\n\n   </table><br /><br />\n    </div>";
        $output .= "<div id=\"pane8\">\n    <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n  <tr class=\"large_bold\"><td colspan=\"5\" class=\"hidden\" align=\"left\">{$lang_item_edit['dropped_by']}: {$lang_item_edit['top_x']}</td></tr>\n  <tr>\n    <th width=\"1%\">ID</th>\n    <th width=\"35%\">{$lang_item_edit['mob_name']}</th>\n    <th width=\"10%\">{$lang_item_edit['mob_level']}</th>\n    <th width=\"25%\">{$lang_item_edit['mob_drop_chance']}</th>\n    <th width=\"25%\">{$lang_item_edit['mob_quest_drop_chance']}</th>\n  </tr>";
        $result2 = $sql->query("SELECT entry,ChanceOrQuestChance,`groupid` FROM creature_loot_template WHERE item = {$item['entry']} ORDER BY `groupid`,ChanceOrQuestChance DESC LIMIT 5");
        while ($info = $sql->fetch_row($result2)) {
            $result3 = $sql->query("SELECT creature_template.entry,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,maxlevel FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE lootid = {$info[0]} LIMIT 1");
            while ($mob = $sql->fetch_row($result3)) {
                $output .= "<tr><td>";
                if ($user_lvl >= $action_permission['delete']) {
                    $output .= "<a class=\"tooltip\" href=\"creature.php?action=edit&amp;entry={$mob['0']}&amp;error=4\" target=\"_blank\">{$mob['0']}</a>";
                } else {
                    $output .= "{$mob['0']}";
                }
                $output .= "</td>\n          <td><a class=\"tooltip\" href=\"{$creature_datasite}{$mob['0']}\" target=\"_blank\">{$mob['1']}</a></td>\n          <td>{$mob['2']}</td>\n          <td>{$info['1']}%</td>\n          <td>{$info['2']}%</td></tr>";
            }
        }
        $result2 = $sql->query("SELECT creature_template.entry,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,maxlevel FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE creature_template.entry IN (SELECT entry FROM npc_vendor WHERE item = {$item['entry']}) ORDER BY maxlevel DESC LIMIT 5");
        if ($sql->num_rows($result2)) {
            $output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['sold_by']}: {$lang_item_edit['limit_x']}</td></tr>";
            while ($mob = $sql->fetch_row($result2)) {
                $output .= "<tr>\n        <td width=\"10%\">";
                if ($user_lvl >= $action_permission['delete']) {
                    $output .= "<a class=\"tooltip\" href=\"creature.php?action=edit&amp;entry={$mob['0']}&amp;error=4\" target=\"_blank\">{$mob['0']}</a>";
                } else {
                    $output .= "{$mob['0']}";
                }
                $output .= "\n        <td width=\"10%\">{$mob['2']}</td>\n        <td width=\"80%\" colspan=\"2\" align=\"left\">\n          <a class=\"tooltip\" href=\"{$creature_datasite}{$mob['0']}\" target=\"_blank\">{$mob['1']}</a></td>\n        </td></tr>";
            }
        }
        $result2 = $sql->query("SELECT quest_template.entry,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as title,QuestLevel FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE ( SrcItemId = {$item['entry']} OR ReqItemId1 = {$item['entry']} OR\n              ReqItemId2 = {$item['entry']} OR ReqItemId3 = {$item['entry']} OR ReqItemId4 = {$item['entry']} OR RewItemId1 = {$item['entry']} OR\n              RewItemId2 = {$item['entry']} OR RewItemId3 = {$item['entry']} OR RewItemId4 = {$item['entry']} ) ORDER BY QuestLevel DESC");
        if ($sql->num_rows($result2)) {
            $output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['involved_in_quests']}:</td></tr>";
            while ($quest = $sql->fetch_row($result2)) {
                $output .= "<tr><td width=\"20%\">id: {$quest['0']}</td>\n        <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest['2']}) {$quest['1']}</a></td></tr>";
            }
        }
        $result2 = $sql->query("SELECT quest_template.entry,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as title,QuestLevel FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE ( RewChoiceItemId1 = {$item['entry']} OR RewChoiceItemId2 = {$item['entry']} OR\n              RewChoiceItemId3 = {$item['entry']} OR RewChoiceItemId4 = {$item['entry']} OR RewChoiceItemId5 = {$item['entry']} OR RewChoiceItemId6 = {$item['entry']} )\n              ORDER BY QuestLevel DESC");
        if ($sql->num_rows($result2)) {
            $output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['reward_from_quest']}:</td></tr>";
            while ($quest = $sql->fetch_row($result2)) {
                $output .= "<tr><td width=\"20%\">id: {$quest['0']}</td>\n        <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest['2']}) {$quest['1']}</a></td></tr>";
            }
        }
        $output .= "</tr></table><br /><br />\n    </div>";
        if ($item['DisenchantID']) {
            $output .= "<div id=\"pane9\">\n  <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n  <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_item_edit['disenchant_templ']}: {$item['DisenchantID']}</td></tr>\n  <tr><td colspan=\"6\">";
            $cel_counter = 0;
            $row_flag = 0;
            $output .= "<table class=\"hidden\" align=\"center\"><tr>";
            $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount,lootcondition,condition_value1, condition_value2 FROM disenchant_loot_template WHERE entry = {$item['DisenchantID']} ORDER BY ChanceOrQuestChance DESC");
            while ($item = $sql->fetch_row($result1)) {
                $cel_counter++;
                $tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_item_edit['drop_chance']}: {$item['1']}%<br />{$lang_item_edit['quest_drop_chance']}: {$item['2']}%<br />{$lang_item_edit['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_item_edit['lootcondition']}: {$item['5']}<br />{$lang_item_edit['condition_value1']}: {$item['6']}<br />{$lang_item_edit['condition_value2']}: {$item['7']}";
                $output .= "<td>";
                $output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
                $output .= "<br /><input type=\"checkbox\" name=\"del_de_items[]\" value=\"{$item['0']}\" /></td>";
                if ($cel_counter >= 16) {
                    $cel_counter = 0;
                    $output .= "</tr><tr>";
                    $row_flag++;
                }
            }
            if ($row_flag) {
                $output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
            }
            $output .= "</td></tr></table>\n </td>\n</tr>\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_item_edit['add_items_to_templ']}:</td></tr>\n<tr>\n<td>" . makeinfocell($lang_item_edit['loot_item_id'], $lang_item_edit['loot_item_id_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_item\" size=\"8\" maxlength=\"10\" value=\"\" /></td>\n<td>" . makeinfocell($lang_item_edit['loot_drop_chance'], $lang_item_edit['loot_drop_chance_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>\n<td>" . makeinfocell($lang_item_edit['loot_quest_drop_chance'], $lang_item_edit['loot_quest_drop_chance_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>\n</tr>\n<tr>\n<td>" . makeinfocell($lang_item_edit['min_count'], $lang_item_edit['min_count_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\n<td>" . makeinfocell($lang_item_edit['max_count'], $lang_item_edit['max_count_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\n</tr>\n<tr>\n<td>" . makeinfocell($lang_item_edit['lootcondition'], $lang_item_edit['lootcondition_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\n<td>" . makeinfocell($lang_item_edit['condition_value1'], $lang_item_edit['condition_value1_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\n<td>" . makeinfocell($lang_item_edit['condition_value2'], $lang_item_edit['condition_value2_desc']) . "</td>\n  <td><input type=\"text\" name=\"de_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\n</tr>\n</table>\n</div>";
        }
        $output .= "</div>\n</div>\n<br />\n</form>\n\n<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
        unset($socketColor_3);
        $output .= "\n          <table class=\"hidden\">\n            <tr>\n              <td>";
        if ($user_lvl >= $action_permission['delete']) {
            makebutton($lang_item_edit['del_item'], "item.php?action=delete&amp;entry={$entry}\" type=\"wrn", 180);
        }
        $output .= "\n              </td>\n              <td>";
        if ($user_lvl >= $action_permission['update']) {
            makebutton($lang_item_edit['update'], "javascript:do_submit('form1',0)\" type=\"wrn", 180);
        }
        $output .= "\n              </td>\n              <td>";
        if ($user_lvl >= $action_permission['insert']) {
            makebutton($lang_item_edit['export_sql'], "javascript:do_submit('form1',1)", 180);
        }
        $output .= "\n              </td>\n              <td>";
        makebutton($lang_global['back'], "javascript:window.history.back()", 130);
        $output .= "\n              </td>\n              <td>";
        makebutton($lang_item_edit['new_search'], "item.php", 130);
        $output .= "\n              </td>\n            </tr>\n          </table>\n        </center>\n";
    } else {
        error($lang_item_edit['item_not_found']);
        exit;
    }
}

예제 #22

파일: loot.tmpl.php 프로젝트: Xackery/EQEmuEOC

        if ($v['type'] == 3) {
            ?>
          <td align="center" width="18%"><a href="index.php?editor=items&z=<?php 
            echo $currzone;
            ?>
&zoneid=<?php 
            echo $currzoneid;
            ?>
&npcid=<?php 
            echo $npcid;
            ?>
&id=<?php 
            echo $v['type_data'];
            ?>
&action=2"><?php 
            echo get_item_name($v['type_data']);
            ?>
 <span>[<a href="http://lucy.allakhazam.com/item.html?id=<?php 
            echo $v['type_data'];
            ?>
">lucy</a>]</span>
<?php 
        }
        ?>
    
<?php 
        if ($v['type'] == 2) {
            ?>
   
          <td align="center" width="18%">Any</td>  
<?php 

예제 #23

파일: universe.php 프로젝트: Covert-Inferno/fortissimo

function get_top10($which, $whichwhat, $what)
{
    global $ft;
    $t10 = $ft->dbh->_select_rows_as_objects('SELECT * FROM tbl:favorites WHERE type = ? ' . 'AND var1 = ? AND ftype = ? ORDER BY var3 DESC LIMIT 10', array($which, $whichwhat, $what));
    $out = array();
    foreach ($t10 as $row) {
        $val = "value undefined";
        if ($what == 'weapon') {
            $val = get_item_name($row->var2);
        } elseif ($what == 'pilot') {
            $val = get_pilot_name($row->var2) . ' [' . get_corp_ticker(get_pilot_corpid($row->var2)) . ']';
        } elseif ($what == 'system') {
            $val = get_system_name($row->var2);
        } elseif ($what == 'ship_killed' || $what == 'ship_lost' || $what == 'ship_flown') {
            $val = get_item_name($row->var2);
        }
        array_push($out, array($val, $row->var3));
    }
    return $out;
}

예제 #24

파일: doors.tmpl.php 프로젝트: Xackery/EQEmuEOC

</td> 
<?php 
        if ($v['keyitem'] < 1) {
            ?>
  
          <td align="center" width="3%"><?php 
            echo $v['keyitem'];
            ?>
</td> 
<?php 
        }
        if ($v['keyitem'] > 0) {
            ?>
  
          <td align="center" width="3%"><?php 
            echo get_item_name($v['keyitem']);
            ?>
 <span>[<a href="http://lucy.allakhazam.com/item.html?id=<?php 
            echo $v['keyitem'];
            ?>
">lucy</a>]</span></td>
<?php 
        }
        ?>
          <td align="center" width="3%"><?php 
        echo $v['opentype'];
        ?>
</td> 
          <td align="center" width="7%"><?php 
        echo $v['dest_zone'];
        ?>

예제 #25

파일: npc.pet.tmpl.php 프로젝트: Xackery/EQEmuEOC

">
          <td align="center" width="5%"><?php 
        echo $v['slot'];
        ?>
</td>
          <td align="center" width="20%"><a href="index.php?editor=items&z=<?php 
        echo $currzone;
        ?>
&zoneid=<?php 
        echo $currzoneid;
        ?>
&id=<?php 
        echo $v['item_id'];
        ?>
&action=2"><?php 
        echo get_item_name($v['item_id']);
        ?>
</a> <span>[<a href="http://lucy.allakhazam.com/item.html?id=<?php 
        echo $v['item_id'];
        ?>
">lucy</a>]</span></td>
          <td align="right">      
            <a href=index.php?editor=npc&z=<?php 
        echo $currzone;
        ?>
&zoneid=<?php 
        echo $currzoneid;
        ?>
&npcid=<?php 
        echo $npcid;
        ?>

예제 #26

파일: invoice_print_waste1.php 프로젝트: bruce28/vip

function small_barcodes_waste($ref_sell)
{
    $sql_waste = "select Barcode_waste,site,type_item from waste_barcode INNER JOIN transaction_waste ON waste_barcode.idwaste_barcode=transaction_waste.waste_barcode_idwaste_barcode\r\n WHERE ref_sell_number='" . $ref_sell . "' order by idwaste_barcode DESC";
    $result = mysql_query($sql_waste) or die(mysql_error());
    global $SITE_REFERENCE_SEARCH;
    global $SITE_DETAILS;
    echo '<table>';
    while ($rek = mysql_fetch_array($result)) {
        echo '<tr>';
        echo '<td>+';
        echo $rek[0];
        echo '</td>';
        echo '<td>';
        echo 'Untested item';
        echo '</td>';
        echo '<td>';
        if ($SITE_REFERENCE_SEARCH == 1) {
            // $stime = microtime();
            //     $stime = explode(" ",$stime);
            //    $stime = $stime[1] + $stime[0];
            echo site_communicate($site_token = get_barcodes_from_db($rek[0]));
            //    $sstime = microtime();
            //    $sstime = explode(" ",$sstime);
            //    $sstime = $sstime[1] + $sstime[0];
            //    $totaltime = ($sstime - $stime);
            //   echo $totaltime;
        } else {
            if ($SITE_REFERENCE_SEARCH == 2) {
            } else {
            }
        }
        echo '</td>';
        if ($SITE_DETAILS == 1 and $SITE_REFERENCE_SEARCH != 0) {
            echo '<td>';
            if (get_site_id_waste_bar($rek[0]) == 18) {
                echo "GRR WD257DL";
            } else {
                if (!empty($site_token)) {
                    echo site_origins($site_token);
                } else {
                    echo site_origins($rek[1]);
                }
                //echo site_origins(get_barcodes_from_db($rek[0])); //here that should be changes since it connect db wit 2 circulization set
            }
            echo '</td>';
        }
        echo '<td>';
        echo get_item_name($rek[2]);
        echo '</td>';
        echo "</tr>";
    }
    echo '</table>';
}

예제 #27

파일: parser.php 프로젝트: Covert-Inferno/fortissimo

 function reverse_ids()
 {
     if (!is_null($this->pilot_id)) {
         $this->pilot = get_pilot_name($this->pilot_id);
     }
     if (!is_null($this->alliance_id)) {
         $this->alliance = get_alliance_name($this->alliance_id);
     }
     if (!is_null($this->corp_id)) {
         $this->corp = get_corp_name($this->corp_id);
         $this->corp_ticker = get_corp_ticker($this->corp_id, 1);
     }
     if (!is_null($this->ship_id)) {
         $this->ship = get_item_name($this->ship_id);
     }
     if (!is_null($this->group_id)) {
         $this->group = get_group_name($this->group_id);
     }
     if (!is_null($this->weapon_id)) {
         $this->weapon = get_item_name($this->weapon_id);
     }
 }

예제 #28

파일: index.php 프로젝트: emiedson/sanasol

        $sth->execute();
        $item = $sth->fetchAll();
    }
    $itemsearch = array();
    foreach ($item as $search_id) {
        $itemsearch[] = $search_id->id;
    }
    $items = implode(",", $itemsearch);
    if (count($itemsearch) >= 1) {
        $search_info = "<b>Perhaps you were looking for:</b> ";
        $i = 0;
        foreach ($itemsearch as $id) {
            if ($i > 10) {
                break;
            }
            $searchitems[] = $this->linkToItem($id, get_item_name($id, $server));
            $i++;
        }
        $search_info .= implode(", ", $searchitems);
        $sqlpartial .= "where v.`nameid` in ({$items})";
    }
}
$sql = "SELECT count(*) AS total FROM {$server->charMapDatabase}.`vending_stat` AS v {$sqlpartial}";
$sth = $server->connection->getStatement($sql);
$sth->execute($bind);
$sortable = array('shop', 'owner', 'nameid', 'amount', 'price', 'refine', 'card0', 'card1', 'card2', 'card3');
$paginator = $this->getPaginator($sth->fetch()->total);
$paginator->setSortableColumns($sortable);
$col = "v.*";
$sql = $paginator->getSQL("SELECT {$col} FROM {$server->charMapDatabase}.`vending_stat` AS v {$sqlpartial}");
$sth = $server->connection->getStatement($sql);

예제 #29

파일: rewards.php 프로젝트: BACKUPLIB/Infinity_MaNGOS

function show_reward_item(&$sqlm, &$sqlw)
{
    global $output, $lang_global, $lang_rewards, $mmfpm_db, $world_db, $realm_id, $action_permission, $user_lvl, $item_datasite;
    // this page uses wowhead tooltops
    wowhead_tt();
    $output .= '
<center>
	<div id="tab_content">
		<div id="tab">
			<ul>
				<li><a href="rewards.php">INFO</a></li>
				<li><a href="rewards.php?action=char_select">SELECT CHAR</a></li>
				<li><a href="rewards.php?action=show_reward_gold">GOLD</a></li>
				<li  id="selected"><a href="rewards.php?action=show_reward_item">ITEM</a></li>
			</ul>
		</div>
		<div id="tab_content2">
			<table class="lined" style="width: 450px;">
				<tr>';
    if ($user_lvl >= $action_permission['delete']) {
        $output .= '
					<th width="1%">' . $lang_global['delete'] . '</th>
					<th width="1%">' . $lang_global['edit'] . '</th>';
    }
    $output .= '
					<th width="15%">item</th>
					<th width="69%">name</th>
					<th width="10%">quantity</th>
					<th width="10%">points</th>
				</tr>';
    // main data that we need for this page
    $sqlm = new SQL();
    $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
    $result = $sqlm->query('SELECT item, quantity, points FROM mm_reward_item');
    while ($items = $sqlm->fetch_assoc($result)) {
        $output .= '
				<tr valign="middle">';
        if ($user_lvl >= $action_permission['delete']) {
            $output .= '
					<td><a href="rewards.php?action=delete_reward_item&amp;item=' . $items['item'] . '"><img src="img/aff_cross.png" alt="" /></a></td>
					<td><a href="rewards.php?action=edit_reward_item&amp;item=' . $items['item'] . '"><img src="img/edit.png" alt="" /></a></td>';
        }
        $output .= '
					<td>
						<a style="padding:2px;" href="' . $item_datasite . $items['item'] . '" target="_blank">
							<img src="' . get_item_icon($items['item'], $sqlm, $sqlw) . '" class="' . get_item_border($items['item'], $sqlw) . '" alt="' . $items['item'] . '" />
						</a>
					</td>
					<td>
						' . get_item_name($items['item'], $sqlw) . '
					</td>
					<td>
						' . $items['quantity'] . '
					</td>
					<td>
						' . $items['points'] . '
					</td>
				</tr>';
    }
    $output .= '
			</table>
		</div>
	</div>
	<br />';
    $output .= '
		<table class="hidden">
			<tr>
				<td>';
    if ($user_lvl >= $action_permission['insert']) {
        makebutton('Add Item', 'rewards.php?action=add_reward_item', 130);
        $output .= '
				</td>';
    }
    $output .= '
		</table>
</center>';
    unset($items);
}

예제 #30

파일: altcur.items.tmpl.php 프로젝트: Xackery/EQEmuEOC

    foreach ($altcur_items as $item) {
        ?>
      <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
        <td align="center" width="15%"><?php 
        echo $item['id'];
        ?>
</td>
        <td align="center" width="20%"><?php 
        echo $item['item_id'];
        ?>
</td>
        <td align="center" width="45%"><?php 
        echo get_item_name($item['item_id']);
        ?>
</td>
        <td align="left" width="10%"><a href="http://lucy.allakhazam.com/item.html?id=<?php 
        echo $item['item_id'];
        ?>
" target="_blank">Lucy</a></td>
        <td align="right"><a href="index.php?editor=altcur&id=<?php 
        echo $item['id'];
        ?>
&action=4"><img src="images/edit2.gif" width="13" height="13" border="0" title="Edit Entry"></a>&nbsp;<a onClick="return confirm('Really delete this entry?');" href="index.php?editor=altcur&id=<?php 
        echo $item['id'];
        ?>
&action=6"><img src="images/remove3.gif" border="0" title="Delete Entry"></a></td>
      </tr>
<?php