Post in this thread for Rev 8 of the WoW_ID.php data file.

Thanks again for the help!

Some of these seems to have been missing.

http://wowroster.net/Forums/viewtopic/p ... html#16419

robojerk wrote:Add to Gems

Code: Select all

'2765' => array
(
'name' => 'Stormy Star of Elune',
'txt'  => '+10 Spell Penetration',
'img'  => 'INV_Jewelcrafting_StarOfElune_03',
),
'2727' => array
(
'name' => 'Teardrop Living Ruby',
'txt'  => '+18 Healing',
'img'  => 'INV_Jewelcrafting_LivingRuby_03',
),
'2741' => array
(
'name' => 'Royal Nightseye',
'txt'  => '+9 Healing Spells and +2 Mana every 5 seconds',
'img'  => 'INV_Jewelcrafting_Nightseye_03',
),
'2733' => array
(
'name' => 'Lustrous Star of Elune',
'txt'  => '+3 Mana every 5 seconds',
'img'  => 'INV_Jewelcrafting_StarOfElune_03',
),

Add to Enchants

Code: Select all

'2937' => '+20 Spell Damage',

I'll add them... thanks

Code: Select all

'2745' => '+46 Healing and +15 Stamina',

'3001' => '+35 Healing and 7 Mana Per 5 sec.', //correced by robojerk

//edit
fixed 3001

Another enchant:

Code: Select all

'2930' => '+20 Healing',


Getting all gems from http://www.wowhead.com/?items=-2

new one (without corrected id !!)

Code: Select all

'30565' => array
(
'name' => 'Assassin\'s Fire Opal',
'txt'  => 'Critical Rating +6 and Dodge Rating +5',
'img'  => 'INV_Jewelcrafting_NobleTopaz_03',
),

Correct tooltip and twice faction (without corrected id !!)

Code: Select all

'27786' => array  //horde
(
'name' => 'Barbed Deep Peridot',
'txt'  => '+3 Stamina, +4 Critical Strike Rating',
'img'  => 'INV_Misc_Gem_DeepPeridot_01',
),
'27809' => array //alliance
(
'name' => 'Barbed Deep Peridot',
'txt'  => '+3 Stamina, +4 Critical Strike Rating',
'img'  => 'INV_Misc_Gem_DeepPeridot_01',
),

added (without corrected id !!)

Code: Select all

'30571' => array
(
'name' => 'Don Rodrigo\'s Heart',
'txt'  => '+8 Strength',
'img'  => 'INV_Misc_Gem_Ruby_01',
),

Correct tooltip (only one with correct id)

Code: Select all

'27820' => array //alliance
(
'name' => 'Notched Deep Peridot',
'txt'  => '+3 Stamina, +4 Spell Critical Strike Rating',
'img'  => 'INV_Misc_Gem_DeepPeridot_03',
),
'2898' => array //horde corrected Subxero
(
'name' => 'Notched Deep Peridot',
'txt'  => '+3 Stamina, +4 Spell Critical Strike Rating',
'img'  => 'INV_Misc_Gem_DeepPeridot_03',
),

A correct id (yes there are 2!! one horde and other alliance)

Code: Select all

'2943' => array // horde
(
'name' => 'Mighty Blood Garnet',
'txt'  => '+14 Attack Power',
'img'  => 'INV_Misc_Gem_Bloodstone_02',
),

And yes like robojerk say 2756 is >> 2765

Enchants:
Addition

Code: Select all

'2997' => '+15 Critical Strike Rating and +20 Attack Power',

Correction

Code: Select all

'3001' => '+35 Healing and 7 Mana Per 5 sec.',

change gem number:
'24047' to '2734' - Brilliant Dawnstone

Code: Select all

'2700' => array //added Yoshette
(
'name' => 'Stormy Azure Moonstone',
'txt'  => '+8 Spell Penetration',
'img'  => 'INV_Misc_Gem_AzureDraenite_02',
),

New Enchant:

Code: Select all

'2648' => '+12 Defense Rating',
'2670' => '+35 Agility',
'2991' => '+15 Defense Rating and +10 Dodge Rating',
'2999' => '+16 Defense Rating and +17 Dodge Rating',


'2831' => array
(
'name' => 'Powerful Earthstorm Diamond',
'txt' => '+18 Stamina & 5% Stun Resist',
'img' => 'INV_Misc_Gem_Diamond_06',
),

Code: Select all

'24054' => array
(
'name' => 'Sovereign Nightseye',
'txt'  => '+4 Strength and +6 Stamina',
'img'  => 'INV_Jewelcrafting_Nightseye_03',
),


This gem aparently has ID 2738

Alliance-side Honor Hold token turnin

Code: Select all

'2921' => array
(
'name' => 'Barbed Deep Peridot',
'txt'  => '+3 Stamina, +4 Critical Strike Rating',
'img'  => 'INV_Misc_Gem_DeepPeridot_01',
),

A new id for a metagem

Code: Select all

'2832' => array
(
'name' => 'Bracing Earthstorm Diamond',
'txt'  => '+26 Healing Spells & 2% Reduced Threat',
'img'  => 'INV_Misc_Gem_Diamond_06',
),

Suggestions for next major version:
-Can be the debug info show like "Bonuses For Equipped Items" with these form without looking 10-20 tooltips on every char its more easy search unknown enchants/gems.
-Or a more useful admin page where get all data from roster and show only unknown enchants/gems id.
-A conversion of wow_id to XML or SQL DB... on xml you can edit better.. on sql you get faster reply, but you need make a system to inject and update all enchant/gem ids at once.

When roster only works with item_ids, enchants_ids and gems_ids the DB size will be very reduced! and can be used on a multilingual guilds with people playing with different language and roster only with one unique.

P.D. when goes finish Rev 8 ?

Still need-

Sovereign Nightseye
item=24054
+4 Strength and +6 Stamina

Subxero wrote:Suggestions for next major version:
-Can be the debug info show like "Bonuses For Equipped Items" with these form without looking 10-20 tooltips on every char its more easy search unknown enchants/gems.
-Or a more useful admin page where get all data from roster and show only unknown enchants/gems id.
-A conversion of wow_id to XML or SQL DB... on xml you can edit better.. on sql you get faster reply, but you need make a system to inject and update all enchant/gem ids at once.

When roster only works with item_ids, enchants_ids and gems_ids the DB size will be very reduced! and can be used on a multilingual guilds with people playing with different language and roster only with one unique.

P.D. when goes finish Rev 8 ?

Great thoughts!

I really thought this project would die out sooner then it is. (Meaning that CP.lua would start grabbing these values with out the need for a WoW_IDs file). So that is why I went with a flat file database rather then making it a MySql or XML

I really like the idea you had about making a central place to update the WoW_IDs without the admin having to replace a file every couple weeks.

About your idea of running the tooltip parser though your entire database at once is a great idea as well. If I create the central database / WoW_IDs I will need to create a control panel of sorts so I will make this using the WoWRoster Addon Framework. When this happens I can add the 'scan all items in db' functionality to the Tool Tip mod.

Anyways thanks for the great ideas for the Tooltip Mod, I will try and get Rev8 of the current WoW_IDs.php out early this week.

It might also be a good idea to sort the enchants not by name (or whatever system is used, didn't seem to be purely by item name and it's very confusing to find anything), but by item ID. This way you can see very fast which item IDs are currently supported and which not (also helps with finding duplicate entries and such...).