Need code that links Item ID to the corresponding .blp Icon

[Knuxyl]

Since AoWoW is extremely outdated I have been working on a Wrath of the Lich King website database on and off for about a year. Everything works perfect, but to make it look nice, I'm trying to add icons, but I cannot seem to find a way to easily link each item to it's icon file.

I can convert the .blp just fine, but they are named like
ability_ambush
ui-glyph-rune-13
So i cannot easily connect the Item to the Icon.

The SQL database I'm using does not use icon in the entries so I'm assuming it is WoW that makes the connection.

Is there anywhere that has all these connections?

Btw once I'm done with the database, I'm going to release it to everyone on here with the corresponding server (SunwellCore).

I will probably add an ability to edit the entries if logged into an admin account to make it easier for server configurations.

Thanks!

[Knuxyl]

Here is a video of the site. It is far from complete (coding, not time) but the actual functions are complete. VERY minimal editing for your own server. very optimized and easy to use. I'll include instructions on what to do for your own server.

I don't want to get too far into making it look nice until i can finish the layout, which requires the use of the icons. I have the icons in jpg png w/e, I just really need a way to link them to the icon.

Wowhead's code for this is
_[135274]={"name":"inv_sword_04","icon":"inv_sword_04"};

Is there anyway I can parse every item id in my database to wowhead and grab this value and write to a file? I can probably do a query of all ids in item_template, store it in a array, and then do a foreach (array as value){ and put in the code for go to wowhead.com?id=value but i dont know how to download the page or how to read this value from the file.

As it is, the website I have checks if server is online and if you copy your worldserver.conf to your site directory it will read the rates like experience and such. I don't know if I can use this code to grab the icon variables though.
Help is much appreciated.
Here is the youtube video.

[Knuxyl]

Well I made a script to grab every item icon name from wowhead.

id=17 icon=$WH.ge('ic17').appendChild(Icon.create('inv_chest_samurai', 2, null, 0, 1));id=25 icon=$WH.ge('ic25').appendChild(Icon.create('inv_sword_04', 2, null, 0, 1));
id=35 icon=$WH.ge('ic35').appendChild(Icon.create('inv_staff_08', 2, null, 0, 1));
id=36 icon=$WH.ge('ic36').appendChild(Icon.create('inv_mace_03', 2, null, 0, 1));
id=37 icon=$WH.ge('ic37').appendChild(Icon.create('inv_axe_11', 2, null, 0, 1));
id=38 icon=$WH.ge('ic38').appendChild(Icon.create('inv_shirt_05', 2, null, 0, 1));
id=39 icon=$WH.ge('ic39').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=40 icon=$WH.ge('ic40').appendChild(Icon.create('inv_boots_06', 2, null, 0, 1));
id=43 icon=$WH.ge('ic43').appendChild(Icon.create('inv_boots_01', 2, null, 0, 1));
id=44 icon=$WH.ge('ic44').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=45 icon=$WH.ge('ic45').appendChild(Icon.create('inv_shirt_01', 2, null, 0, 1));
id=47 icon=$WH.ge('ic47').appendChild(Icon.create('inv_boots_05', 2, null, 0, 1));
id=48 icon=$WH.ge('ic48').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=49 icon=$WH.ge('ic49').appendChild(Icon.create('inv_shirt_05', 2, null, 0, 1));
id=51 icon=$WH.ge('ic51').appendChild(Icon.create('inv_boots_04', 2, null, 0, 1));
id=52 icon=$WH.ge('ic52').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=53 icon=$WH.ge('ic53').appendChild(Icon.create('inv_shirt_01', 2, null, 0, 1));
id=55 icon=$WH.ge('ic55').appendChild(Icon.create('inv_boots_09', 2, null, 0, 1));
id=56 icon=$WH.ge('ic56').appendChild(Icon.create('inv_chest_cloth_23', 2, null, 0, 1));
id=57 icon=$WH.ge('ic57').appendChild(Icon.create('inv_chest_cloth_24', 2, null, 0, 1));
id=59 icon=$WH.ge('ic59').appendChild(Icon.create('inv_boots_01', 2, null, 0, 1));
id=60 icon=$WH.ge('ic60').appendChild(Icon.create('inv_chest_leather_09', 2, null, 0, 1));
id=61 icon=$WH.ge('ic61').appendChild(Icon.create('inv_pants_leather_38v2', 2, null, 0, 1));
id=79 icon=$WH.ge('ic79').appendChild(Icon.create('inv_pants_cloth_41v4', 2, null, 0, 1));
id=80 icon=$WH.ge('ic80').appendChild(Icon.create('inv_boots_09', 2, null, 0, 1));
id=85 icon=$WH.ge('ic85').appendChild(Icon.create('inv_shirt_07', 2, null, 0, 1));
id=88 icon=$WH.ge('ic88').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=91 icon=$WH.ge('ic91').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=100 icon=$WH.ge('ic100').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=117 icon=$WH.ge('ic117').appendChild(Icon.create('inv_misc_food_16', 2, null, 0, 20));
id=118 icon=$WH.ge('ic118').appendChild(Icon.create('inv_potion_49', 2, null, 0, 20));
id=119 icon=$WH.ge('ic119').appendChild(Icon.create('inv_shirt_01', 2, null, 0, 1));
id=120 icon=$WH.ge('ic120').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=121 icon=$WH.ge('ic121').appendChild(Icon.create('inv_boots_05', 2, null, 0, 1));
id=127 icon=$WH.ge('ic127').appendChild(Icon.create('inv_shirt_07', 2, null, 0, 1));
id=128 icon=$WH.ge('ic128').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=129 icon=$WH.ge('ic129').appendChild(Icon.create('inv_boots_06', 2, null, 0, 1));
id=138 icon=$WH.ge('ic138').appendChild(Icon.create('inv_chest_leather_04', 2, null, 0, 1));
id=139 icon=$WH.ge('ic139').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=140 icon=$WH.ge('ic140').appendChild(Icon.create('inv_boots_04', 2, null, 0, 1));
id=143 icon=$WH.ge('ic143').appendChild(Icon.create('inv_shield_05', 2, null, 0, 1));
id=147 icon=$WH.ge('ic147').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=148 icon=$WH.ge('ic148').appendChild(Icon.create('inv_shirt_01', 2, null, 0, 1));
id=153 icon=$WH.ge('ic153').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=154 icon=$WH.ge('ic154').appendChild(Icon.create('inv_misc_cape_14', 2, null, 0, 1));
id=156 icon=$WH.ge('ic156').appendChild(Icon.create('inv_pants_02', 2, null, 0, 1));
id=159 icon=$WH.ge('ic159').appendChild(Icon.create('inv_drink_07', 2, null, 0, 20));
id=182 icon=$WH.ge('ic182').appendChild(Icon.create('inv_misc_head_human_01', 2, null, 0, 1));
id=192 icon=$WH.ge('ic192').appendChild(Icon.create('inv_mace_01', 2, null, 0, 1));
id=193 icon=$WH.ge('ic193').appendChild(Icon.create('inv_shirt_black_01', 2, null, 0, 1));
id=194 icon=$WH.ge('ic194').appendChild(Icon.create('inv_pants_12', 2, null, 0, 1));
id=195 icon=$WH.ge('ic195').appendChild(Icon.create('inv_boots_05', 2, null, 0, 1));
id=200 icon=$WH.ge('ic200').appendChild(Icon.create('inv_shirt_02', 2, null, 0, 1));
id=201 icon=$WH.ge('ic201').appendChild(Icon.create('inv_pants_12', 2, null, 0, 1));
id=202 icon=$WH.ge('ic202').appendChild(Icon.create('inv_boots_05', 2, null, 0, 1));
id=203 icon=$WH.ge('ic203').appendChild(Icon.create('inv_gauntlets_21', 2, null, 0, 1));
id=209 icon=$WH.ge('ic209').appendChild(Icon.create('inv_pants_wolf', 2, null, 0, 1));
id=210 icon=$WH.ge('ic210').appendChild(Icon.create('inv_boots_06', 2, null, 0, 1));
id=236 icon=$WH.ge('ic236').appendChild(Icon.create('inv_chest_leather_10', 2, null, 0, 1));
id=237 icon=$WH.ge('ic237').appendChild(Icon.create('inv_pants_06', 2, null, 0, 1));
id=238 icon=$WH.ge('ic238').appendChild(Icon.create('inv_boots_03', 2, null, 0, 1));
id=239 icon=$WH.ge('ic239').appendChild(Icon.create('inv_gauntlets_21', 2, null, 0, 1));
id=285 icon=$WH.ge('ic285').appendChild(Icon.create('inv_chest_chain_09', 2, null, 0, 1));
id=286 icon=$WH.ge('ic286').appendChild(Icon.create('inv_pants_03', 2, null, 0, 1));
id=287 icon=$WH.ge('ic287').appendChild(Icon.create('inv_boots_01', 2, null, 0, 1));
id=414 icon=$WH.ge('ic414').appendChild(Icon.create('inv_misc_food_39', 2, null, 0, 20));
id=422 icon=$WH.ge('ic422').appendChild(Icon.create('inv_misc_food_07', 2, null, 0, 20));
id=537 icon=$WH.ge('ic537').appendChild(Icon.create('inv_misc_monsterscales_02', 2, null, 0, 20));
id=555 icon=$WH.ge('ic555').appendChild(Icon.create('spell_magic_featherfall', 2, null, 0, 20));
id=556 icon=$WH.ge('ic556').appendChild(Icon.create('inv_misc_birdbeck_01', 2, null, 0, 20));
id=647 icon=$WH.ge('ic647').appendChild(Icon.create('inv_sword_19', 2, null, 0, 1));
id=710 icon=$WH.ge('ic710').appendChild(Icon.create('inv_bracer_11', 2, null, 0, 1));
id=711 icon=$WH.ge('ic711').appendChild(Icon.create('inv_gauntlets_27', 2, null, 0, 1));
id=714 icon=$WH.ge('ic714').appendChild(Icon.create('inv_gauntlets_18', 2, null, 0, 1));
id=718 icon=$WH.ge('ic718').appendChild(Icon.create('inv_gauntlets_04', 2, null, 0, 1));
id=719 icon=$WH.ge('ic719').appendChild(Icon.create('inv_gauntlets_114v4', 2, null, 0, 1));
id=720 icon=$WH.ge('ic720').appendChild(Icon.create('inv_gauntlets_05', 2, null, 0, 1));
id=723 icon=$WH.ge('ic723').appendChild(Icon.create('inv_misc_organ_04', 2, null, 0, 200));
id=724 icon=$WH.ge('ic724').appendChild(Icon.create('inv_misc_food_10', 2, null, 0, 20));
id=725 icon=$WH.ge('ic725').appendChild(Icon.create('inv_misc_monsterclaw_04', 2, null, 0, 20));
id=727 icon=$WH.ge('ic727').appendChild(Icon.create('inv_sword_04', 2, null, 0, 1));
id=728 icon=$WH.ge('ic728').appendChild(Icon.create('inv_scroll_03', 2, null, 0, 1));
id=729 icon=$WH.ge('ic729').appendChild(Icon.create('inv_misc_food_16', 2, null, 0, 20));
id=730 icon=$WH.ge('ic730').appendChild(Icon.create('inv_misc_eye_01', 2, null, 0, 20));
id=731 icon=$WH.ge('ic731').appendChild(Icon.create('spell_magic_polymorphpig', 2, null, 0, 20));
id=732 icon=$WH.ge('ic732').appendChild(Icon.create('inv_misc_herb_09', 2, null, 0, 20));
id=733 icon=$WH.ge('ic733').appendChild(Icon.create('inv_misc_bowl_01', 2, null, 0, 20));
id=734 icon=$WH.ge('ic734').appendChild(Icon.create('inv_jewelry_amulet_03', 2, null, 0, 1));
id=735 icon=$WH.ge('ic735').appendChild(Icon.create('inv_jewelry_amulet_03', 2, null, 0, 1));
id=737 icon=$WH.ge('ic737').appendChild(Icon.create('inv_potion_01', 2, null, 0, 1));
id=738 icon=$WH.ge('ic738').appendChild(Icon.create('inv_misc_food_wheat_01', 2, null, 0, 20));
id=739 icon=$WH.ge('ic739').appendChild(Icon.create('inv_misc_food_wheat_02', 2, null, 0, 20));
id=740 icon=$WH.ge('ic740').appendChild(Icon.create('inv_misc_food_wheat_02', 2, null, 0, 20));
id=742 icon=$WH.ge('ic742').appendChild(Icon.create('inv_misc_branch_01', 2, null, 0, 1));
id=743 icon=$WH.ge('ic743').appendChild(Icon.create('inv_tradeskillitem_03', 2, null, 0, 1));
id=744 icon=$WH.ge('ic744').appendChild(Icon.create('inv_drink_01', 2, null, 0, 1));
id=745 icon=$WH.ge('ic745').appendChild(Icon.create('inv_scroll_03', 2, null, 0, 1));
id=748 icon=$WH.ge('ic748').appendChild(Icon.create('inv_scroll_03', 2, null, 0, 1));
id=750 icon=$WH.ge('ic750').appendChild(Icon.create('inv_misc_food_16', 2, null, 0, 20));
id=752 icon=$WH.ge('ic752').appendChild(Icon.create('inv_misc_bandana_03', 2, null, 0, 20));
id=753 icon=$WH.ge('ic753').appendChild(Icon.create('inv_sword_36', 2, null, 0, 1));
id=754 icon=$WH.ge('ic754').appendChild(Icon.create('inv_sword_14', 2, null, 0, 1));
id=755 icon=$WH.ge('ic755').appendChild(Icon.create('inv_misc_candle_01', 2, null, 0, 20));
id=756 icon=$WH.ge('ic756').appendChild(Icon.create('inv_pick_02', 2, null, 0, 1));
id=763 icon=$WH.ge('ic763').appendChild(Icon.create('inv_bracer_08', 2, null, 0, 1));
id=765 icon=$WH.ge('ic765').appendChild(Icon.create('inv_misc_herb_10', 2, null, 0, 200));
id=766 icon=$WH.ge('ic766').appendChild(Icon.create('inv_mace_07', 2, null, 0, 1));
id=767 icon=$WH.ge('ic767').appendChild(Icon.create('inv_staff_08', 2, null, 0, 1));
id=768 icon=$WH.ge('ic768').appendChild(Icon.create('inv_axe_01', 2, null, 0, 1));
id=769 icon=$WH.ge('ic769').appendChild(Icon.create('inv_misc_food_14', 2, null, 0, 200));
id=770 icon=$WH.ge('ic770').appendChild(Icon.create('inv_misc_bone_08', 2, null, 0, 20));
id=771 icon=$WH.ge('ic771').appendChild(Icon.create('inv_misc_bone_04', 2, null, 0, 20));
id=772 icon=$WH.ge('ic772').appendChild(Icon.create('inv_misc_candle_01', 2, null, 0, 20));
id=773 icon=$WH.ge('ic773').appendChild(Icon.create('inv_misc_dust_01', 2, null, 0, 20));
id=774 icon=$WH.ge('ic774').appendChild(Icon.create('inv_misc_gem_emerald_03', 2, null, 0, 200));
id=776 icon=$WH.ge('ic776').appendChild(Icon.create('inv_weapon_shortblade_02', 2, null, 0, 1));
id=777 icon=$WH.ge('ic777').appendChild(Icon.create('inv_misc_monsterfang_01', 2, null, 0, 20));
id=778 icon=$WH.ge('ic778').appendChild(Icon.create('inv_pick_02', 2, null, 0, 1));
id=779 icon=$WH.ge('ic779').appendChild(Icon.create('inv_misc_shell_01', 2, null, 0, 20));
id=780 icon=$WH.ge('ic780').appendChild(Icon.create('inv_misc_monsterscales_02', 2, null, 0, 20));
id=781 icon=$WH.ge('ic781').appendChild(Icon.create('inv_hammer_09', 2, null, 0, 1));
id=782 icon=$WH.ge('ic782').appendChild(Icon.create('inv_misc_bandana_01', 2, null, 0, 20));
id=783 icon=$WH.ge('ic783').appendChild(Icon.create('inv_misc_pelt_wolf_ruin_02', 2, null, 0, 200));
id=785 icon=$WH.ge('ic785').appendChild(Icon.create('inv_jewelry_talisman_03', 2, null, 0, 200));

That is what it has grabbed so far. Of course I need to run some batch editing on it to remove the garbage and add extension, but that shouldn't be a problem.

I'd do this for CATA or MOP but none of the private servers that are open source are really worth it yet that I've experienced.

These batch scripts I made could easily mirror wowheads website with enough time and coding, and WotLK is definitely not my favorite expansion.

Does anyone know of a working battleground/dungeon finder all dungeons all battlegrounds all spells all quests MOP or CATA emulator? If so, I would stop work on this and work on those. I can easily migrate.

[Knuxyl]

Got icons working and loading from .ini file flawlessly.
i need a new way to work with the tabs. i dont like what i have, i cant have defaul one open.

[Knuxyl]

I finished the query for the icon names for the item ids. ill upload the file icons.ini. i tried copy/pase into code block, but for future reference for anyone, pasting in 38,000 lines of code into a forum will lagggggggg.
i'll also upload a video showing what is done so far in a minute.

[Knuxyl]

Here is the youtube video of what is done so far.
If anyone is interested in the code I am using or anything, feel free to ask and I'll share. I'm using very simple php along with very little god forsaken javascript. eventually im getting rid of 1 of the 2 javascripts i have. great language for realtime in webpages, but i hate hate hate the syntax.