$Content .= 'There is currently no spell data...<br>'; } echo Modal('View Spell Data', '<div class="alert alert-info">' . $Content . '</div>', ''); } /* Displays Item View tooltip */ if (isset($_GET['item_view'])) { require_once 'includes/constants.php'; require_once 'includes/alla_functions.php'; require_once 'modules/ItemEditor/constants_ie.php'; // echo '<style></style>'; $QueryResult = mysql_query("SELECT * FROM items WHERE `id` = " . $_GET['item_view'] . ";"); while ($row = mysql_fetch_array($QueryResult)) { // $Content .= BuildSpellInfo($row, 1); echo BuildItemStats($row, 1, 'item_view'); } } /* Displays Spell View tooltip */ if (isset($_GET['spell_view'])) { require_once 'includes/spell.inc.php'; require_once 'includes/constants.php'; require_once 'includes/alla_functions.php'; require_once 'modules/ItemEditor/constants_ie.php'; $QueryResult = mysql_query("SELECT * FROM spells_new WHERE `id` = " . $_GET['spell_view'] . ";"); while ($row = mysql_fetch_array($QueryResult)) { $Content .= BuildSpellInfo($row, 1, 'item_view'); echo $Content; }
$type = isset($_GET['type']) ? mysql_real_escape_string($_GET['type']) : ''; if ($id != "" && is_numeric($id)) { $TooltipData = ""; if ($type == "" || $type == "item") { if ($DiscoveredItemsOnly == TRUE) { $Query = "SELECT * FROM {$tbitems}, discovered_items WHERE {$tbitems}.id='" . $id . "' AND discovered_items.item_id={$tbitems}.id"; } else { $Query = "SELECT * FROM {$tbitems} WHERE id='" . $id . "'"; } $QueryResult = mysql_query($Query) or message_die('item.php', 'MYSQL_QUERY', $Query, mysql_error()); if (mysql_num_rows($QueryResult) == 0) { //exit(); } $item = mysql_fetch_array($QueryResult); // Prints all Item data into formatted tables $TooltipData .= BuildItemStats($item, 1); } elseif ($type == "spell") { $spell = getspell($id); if ($id > 0) { if ($spell) { $TooltipData .= BuildSpellInfo($spell, 1); } else { $TooltipData .= "There is no spell info found"; } } else { $TooltipData .= "There is no spell info found"; } } echo '$ToolTip.registerItem({"tooltip":"<div class=\\"itemtooltip\\">' . $TooltipData . '</div>","id":"' . $id . '"});'; } else { //exit();
echo "<b>" . $num_rows . " " . ($num_rows == 1 ? "item" : "items") . " displayed</b>" . $OutOf . "<br>"; echo "</center>"; echo "<center><table border='{$Tableborder}' cellpadding='5' width='0%'>"; echo "<tr>\n\t\t\t\t\t<th class='menuh'>Icon</th>\n\t\t\t\t\t<th class='menuh'>Item Name</th>\n\t\t\t\t\t<th class='menuh'>Item Type</th>\n\t\t\t\t\t<th class='menuh'>AC</th>\n\t\t\t\t\t<th class='menuh'>HPs</th>\n\t\t\t\t\t<th class='menuh'>Mana</th>\n\t\t\t\t\t<th class='menuh'>Damage</th>\n\t\t\t\t\t<th class='menuh'>Delay</th>\n\t\t\t\t\t<th class='menuh'>Item ID</th>\n\t\t\t\t\t</tr>"; $RowClass = "lr"; for ($count = 1; $count <= $num_rows; $count++) { $TableData = ""; $row = mysql_fetch_array($QueryResult); $TableData .= "<tr valign='top' class='" . $RowClass . "'><td>"; if (file_exists(getcwd() . "/icons/item_" . $row["icon"] . ".gif")) { $TableData .= "<img src='" . $icons_url . "item_" . $row["icon"] . ".gif' align='left'/>"; } else { $TableData .= "<img src='" . $icons_url . "item_.gif' align='left'/>"; } $TableData .= "</td><td>"; CreateToolTip($row["id"], BuildItemStats($row, 1)); $TableData .= "<a href='item.php?id=" . $row["id"] . "' id='" . $row["id"] . "'>" . $row["Name"] . "</a>"; $TableData .= "</td><td>"; $TableData .= $dbitypes[$row["itemtype"]]; $TableData .= "</td><td>"; $TableData .= $row["ac"]; $TableData .= "</td><td>"; $TableData .= $row["hp"]; $TableData .= "</td><td>"; $TableData .= $row["mana"]; $TableData .= "</td><td>"; $TableData .= $row["damage"]; $TableData .= "</td><td>"; $TableData .= $row["delay"]; $TableData .= "</td><td>"; $TableData .= $row["id"];
} print "</ul></td></tr>"; } if ($recipe["nofail"] == 0) { // results fail $query = "SELECT {$tbtradeskillrecipeentries}.*,{$tbitems}.*,{$tbitems}.id AS item_id\n\t\t\t\tFROM {$tbtradeskillrecipe},{$tbtradeskillrecipeentries},{$tbitems}\n\t\t\t\tWHERE {$tbtradeskillrecipe}.id={$tbtradeskillrecipeentries}.recipe_id\n\t\t\t\t AND {$tbtradeskillrecipeentries}.recipe_id={$id}\n\t\t\t\t AND {$tbtradeskillrecipeentries}.item_id={$tbitems}.id\n\t\t\t\t AND {$tbtradeskillrecipeentries}.failcount>0"; $result = mysql_query($query) or message_die('recipe.php', 'MYSQL_QUERY', $query, mysql_error()); if (mysql_num_rows($result) > 0) { print "<tr class=myline height=6><td colspan=2></td><tr>"; print "<tr><td nowrap><b>Items resulting of a <FONT COLOR='#FF0000'> failed combine </FONT></b><ul>"; while ($row = mysql_fetch_array($result)) { CreateToolTip($row["item_id"] * 10, BuildItemStats($row, 1)); print "<img src='" . $icons_url . "item_" . $row["icon"] . ".gif' align='left' width='15' height='15'/>" . "<a href=item.php?id=" . $row["item_id"] . " id=" . $row["item_id"] * 10 . ">" . str_replace("_", " ", $row["Name"]) . "</a> x" . $row["failcount"] . " <br>"; } print "</td></tr>"; } } // components $query = "SELECT {$tbtradeskillrecipeentries}.*,{$tbitems}.*,{$tbitems}.id AS item_id\n\t\t\tFROM {$tbtradeskillrecipe},{$tbtradeskillrecipeentries},{$tbitems}\n\t\t\tWHERE {$tbtradeskillrecipe}.id={$tbtradeskillrecipeentries}.recipe_id\n\t\t\tAND {$tbtradeskillrecipeentries}.recipe_id={$id}\n\t\t\tAND {$tbtradeskillrecipeentries}.item_id={$tbitems}.id\n\t\t\tAND {$tbtradeskillrecipeentries}.iscontainer=0\n\t\t\tAND {$tbtradeskillrecipeentries}.componentcount>0"; $result = mysql_query($query) or message_die('recipe.php', 'MYSQL_QUERY', $query, mysql_error()); if (mysql_num_rows($result) > 0) { print "<tr class=myline height=6><td colspan=2></td><tr>"; print "<tr><td nowrap><b>Components needed : </b><ul>"; while ($row = mysql_fetch_array($result)) { CreateToolTip($row["item_id"] * 100, BuildItemStats($row, 1)); print "<img src='" . $icons_url . "item_" . $row["icon"] . ".gif' align='left' width='15' height='15'/>" . "<a href=item.php?id=" . $row["item_id"] . " id=" . $row["item_id"] * 100 . ">" . str_replace("_", " ", $row["Name"]) . "</a> x " . $row["componentcount"] . " <br>"; } print "</td></tr>"; } print "</table>"; include $includes_dir . "footers.php";
echo "<img src='" . $icons_url . "item_" . $item["icon"] . ".gif' align='left'/>"; } print "<img src='" . $images_url . "spacer_1.png' align='left'/><a href='http://lucy.allakhazam.com/item.html?id=" . $id . "'><img src='" . $images_url . "lucy.png' align='right'/></a>\n"; print " <b>" . $item["Name"] . "</b>"; if ($item["lore"] != "") { print "<br/>(" . $item["lore"] . ") - id : " . $id . "\n"; } else { print "<br/>id : " . $id . "\n"; } print "</td>\n"; print "</tr>\n"; print "<tr valign='top'>\n"; print "<td width='90%'>\n"; print "<table border='{$Tableborder}' width='100%'>\n"; // Prints all Item data into formatted tables print BuildItemStats($item, 0); print "<table border='{$Tableborder}' width='0%' cellpadding='0' cellspacing='0'>"; // Discovered by if ($DiscoveredItemsOnly == TRUE) { $CharName = GetFieldByQuery("char_name", "SELECT char_name FROM {$tbdiscovereditems} WHERE item_id={$id}"); $DiscoveredDate = GetFieldByQuery("discovered_date", "SELECT discovered_date FROM {$tbdiscovereditems} WHERE item_id={$id}"); if ($charbrowser_url) { $DiscoveredBy = "<a href=" . $charbrowser_url . "character.php?char=" . $CharName . ">" . $CharName . "</a>"; } else { $DiscoveredBy = $CharName; } if ($CharName != '') { print "<br><tr><td colspan='2' nowrap='1'><b>Discovered by: </b>{$DiscoveredBy} - " . date("m/d/y", $DiscoveredDate) . "</td></tr>"; } } // places where to forage this item
$ItemType = $dbitypes[$ItemData["itemtype"]]; } } $EquiptmentTable .= "<tr class='" . $RowClass . "'>\n\t\t<td><img src='" . $icons_url . "item_" . $ItemData["icon"] . ".gif' align='left'/>\n\t\t<img src='" . $images_url . "spacer_1.png' align='left'/>\n\t\t</td><td><a href=item.php?id=" . $ItemData["id"] . " id='" . $ItemData["id"] . "'>" . $ItemData["Name"] . "</a></td>\n\t\t<td>" . $ItemType . "</td></tr>"; if ($RowClass == "lr") { $RowClass = "dr"; } else { $RowClass = "lr"; } } $EquiptmentTable .= "</table>"; print "<center>"; if ($ItemsFound > 0) { print $EquiptmentTable; foreach ($ItemsData as $key => $ItemData) { $ToolTips .= CreateToolTip($ItemData["id"], BuildItemStats($ItemData, 1)); } print $ToolTips; } else { print "<br><b>No Items Found</b>"; } print "</center>"; } // end items if ($mode == "spawngroups") { if ($DisplaySpawnGroupInfo == TRUE) { print "</center>"; $query = "SELECT {$tbspawngroup}.*,{$tbspawn2}.x,{$tbspawn2}.y,{$tbspawn2}.z,{$tbspawn2}.respawntime\n\t\t\tFROM {$tbspawn2},{$tbspawngroup}\n\t\t\tWHERE {$tbspawn2}.zone='{$name}'\n\t\t\tAND {$tbspawngroup}.id={$tbspawn2}.spawngroupID\n\t\t\tORDER BY {$tbspawngroup}.name ASC"; $result = mysql_query($query) or message_die('zone.php', 'MYSQL_QUERY', $query, mysql_error()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) {
} if ($C != 1) { $Values .= ", "; $Fields .= ", "; } $Values .= "'" . $value . "'"; $Fields .= "`" . $FV . "`"; $C++; } $Result = $Query . $Fields . ") VALUES (" . $Values . ");"; if (mysql_query($Result)) { echo '<center><h1>Item Saved Successfully!</h1><br>'; $query_result = mysql_query("SELECT * FROM items WHERE id = " . $_POST['id'] . ";"); while ($row = mysql_fetch_array($query_result)) { echo '<div class="alert alert-block alert-warning fade in" style="width:500px">'; echo BuildItemStats($row, 1); echo '</div>'; } echo "<hr><h1>Query Result</h1><br><textarea rows='30' cols='200'> " . $Result . "</textarea></center>"; } else { echo '<h2>ERROR</h2>'; echo '<pre>'; echo mysql_error(); echo '<br><br>'; echo $Result; echo '</pre>'; } LogUserEvent($_SERVER['REMOTE_ADDR'], "Item Save", $Result); } echo '<div id="childstatus"></div>'; echo '<script type="text/javascript" src="cust_assets/eqemu_tooltip.js"></script></body>';