'img/shopimg/icons/category_service.gif', 'Mount' => 'img/shopimg/icons/category_mount.jpg', 'Pet' => 'img/shopimg/icons/category_pet.jpg', 'Gold' => 'img/shopimg/icons/category_gold.webp', 'Stuff' => 'img/shopimg/icons/category_stuff.jpg', 'Set' => 'img/shopimg/icons/category_stuff.jpg' ]; // Categories that should show tooltips $tooltip_categories = ['Mount', 'Pet', 'Stuff', 'Set']; // Exact site_items columns needed by generateTooltip() - avoids "SELECT *" // (column list verified against the actual site_items schema). $tooltip_fields = 'entry, name, description, Quality, Flags, ItemLevel, RequiredLevel, SellPrice, MaxDurability, ' . 'class, subclass, InventoryType, bonding, AllowableClass, dmg_min1, dmg_max1, delay, armor, ' . 'holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, ' . 'socketColor_1, socketColor_2, socketColor_3, socketBonus, ' . 'spellid_1, spelltrigger_1, spellid_2, spelltrigger_2, spellid_3, spelltrigger_3, spellid_4, spelltrigger_4, spellid_5, spelltrigger_5, ' . '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'; // Render tooltips inline: tell item_tooltip.php to emit its

: :
log in to purchase items.')); ?>
$category_items): ?>

<?php echo str_replace('{name}', htmlspecialchars($item['name']), translate('shop_item_image_alt', '{name}')); ?> 0): ?> Limited Stock

:

prepare("SELECT {$tooltip_fields} FROM site_items WHERE entry = ?"); if ($stmt_tooltip) { $stmt_tooltip->bind_param("i", $item['sit_entry']); $stmt_tooltip->execute(); $result_tooltip = $stmt_tooltip->get_result(); if ($tooltip_data = $result_tooltip->fetch_assoc()) { echo generateTooltip($tooltip_data); } $stmt_tooltip->close(); } else { error_log("Failed to prepare tooltip query for entry " . (int)$item['sit_entry'] . ": " . $site_db->error); } ?>
0): ?> 0): ?>
:

Information

Message

close(); $char_db->close(); ?>