Chucksta

Differing settings between Two and the other cores [quote=Olion]There is an annoying difference in EventAI action definitions. Zero: ACTION_T_SET_STAND_STATE = 47, // StandState, unused, unused ACTION_T_CHANGE_MOVEMENT = 48, // MovementType, WanderDistance, unused ACTION_T_SUMMON_UNIQUE = 49, // CreatureId, Target, SpawnId ACTION_T_EMOTE_TARGET = 50, // EmoteId, TargetGuid Two: ACTION_T_SUMMON_UNIQUE = 47, // CreatureId, Target, SpawnId ACTION_T_SET_STAND_STATE = 48, // StandState, unused, unused ACTION_T_CHANGE_MOVEMENT = 49, // MovementType, WanderDistance, unused I suppose it would be better to unify it throughout the cores, or else this will not be the last ACID/EAI problem of such type.[/quote] Basically, Two needs to be changed to how Zero and One are set up. Besides the server core, there will also be a number of database entries that will need changing:

List of issues and fixes for the area This is just a means for me to record the issues and findings within Eastern Plaguelands: -- [SIZE=3]Tyr's Hand[/SIZE] -- Deaded totured peeps @ odd angle [COLOR="#0000FF"]UPDATE creature SET position_x=1594.56, position_y=-5313.1, position_z=69.84, orientation=3.1 WHERE guid = 53036; UPDATE creature SET position_x=1598.14, position_y=-5314.94, position_z=70.0242, orientation=3.13426 WHERE guid = 84825; UPDATE creature SET position_x=1603.62, position_y=-5306.68, position_z=70.045, orientation=4.9 WHERE guid = 86149;[/COLOR] -- [SIZE=3]Light's Hope Chapel[/SIZE] [COLOR="#0000FF"]DELETE FROM gossip_menu WHERE entry IN (96, 97, 98, 99, 100, 101);[/COLOR] -- no chit chat -- Korfax, Champion of the Light [COLOR="#0000FF"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (96, 8415, 0, 0); UPDATE gossip_menu_option SET action_menu_id=96 WHERE menu_id=7099 and id=1;[/COLOR] -- Rohan The Assassin [COLOR="#0000FF"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (97, 8409, 0, 0); UPDATE gossip_menu_option SET action_menu_id= 97 WHERE menu_id=7101 and id=1;[/COLOR] -- Huntsman Leopold [COLOR="#0000FF"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (98, 8408, 0, 0); UPDATE gossip_menu_option SET action_menu_id= 98 WHERE menu_id=7102 and id=1;[/COLOR] -- Archmage Angela Dosantos [COLOR="#0000FF"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (99, 8414, 0, 0); UPDATE gossip_menu_option SET action_menu_id= 99 WHERE menu_id=7096 and id=1;[/COLOR] -- Miranda [COLOR="#0000FF"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (100, 8499, 0, 0); INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (100, 8500, 0, 0); INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (100, 8502, 0, 0); INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (100, 8503, 0, 0); UPDATE gossip_menu_option SET action_menu_id=269 WHERE menu_id=3461 and id=2;[/COLOR] -- Rayne [COLOR="#0000FF"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (101, 8416, 0, 0); UPDATE gossip_menu_option SET action_menu_id= 101 WHERE menu_id=7104 and id=1; [/COLOR] [SIZE=3]-- Jackanory Time -- ==========[/SIZE] -- Archmage Angela Dosantos -- [url]http://wow.gamepedia.com/Angela_Dosantos[/url] DELETE FROM gossip_menu WHERE entry IN (86, 87, 88, 89, 90, 91, 92, 93, 94, 95); DELETE FROM gossip_menu_option WHERE menu_id IN (86, 87, 88, 89, 90, 91, 92, 93, 94); -- It is said that Kel'Thuzad seeks the legendary Atiesh, greatstaff of the Guardian. -- Yes, the very staff once held by Medivh. -- What is Atiesh? UPDATE gossip_menu_option SET action_menu_id=86 WHERE menu_id=7096 and id=0; -- Like Kel'Thuzad, I too was once a mage of the Kirin Tor. And like Kel'Thuzad, I seek the legendary Atiesh, greatstaff of the Guardian. Our fates are intertwined as such, . -- What Guardian? I don't understand any of this. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (86, 8388, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (86, 0, 0, 'What Guardian? I don\t understand any of this.', 1, 1, 87, 0, 0, 0, 0, '', 0); -- Progeny of Aegwynn, he that would be the last Guardian of Tirisfal... Medivh.. -- Please continue. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (87, 8389, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (87, 0, 0, 'Please continue.', 1, 1, 88, 0, 0, 0, 0, '', 0); -- It is a story of legend and one that I do not have the time nor the inclination to retell. Just know that Medivh was the last of the Guardians. The greatstaff of Atiesh was a focal point of his power and a focal point of corruption. -- What corruption? INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (88, 8390, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (88, 0, 0, 'What corruption?', 1, 1, 89, 0, 0, 0, 0, '', 0); -- The corruption of a fallen titan. The corruption of the Destroyer. After all, the staff was forged from the seed of hate. That is, of course, what has brought me here... -- Please continue. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (89, 8391, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (89, 0, 0, 'Please continue.', 1, 1, 90, 0, 0, 0, 0, '', 0); -- After the fall of Karazhan, the Kirin Tor dispatched an assembly of mages to search the tower and seize all items of import... for the purposes of "research." It was then that the fabled staff was discovered and brought back to Dalaran. -- Please continue. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (90, 8392, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (90, 0, 0, 'Please continue.', 1, 1, 91, 0, 0, 0, 0, '', 0); -- What followed were a series of tragic events, leading to the death of every Kirin Tor mage that came into contact with Atiesh. -- You see, it was an artifact with sentience. A sentience granted to it by Sargeras... -- What? INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (91, 8393, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (91, 0, 0, 'What?', 1, 1, 92, 0, 0, 0, 0, '', 0); -- -- After the deaths, the Six decided that the best course of action was to seal the staff behind impenetrable barriers of magic and appoint a watcher: A guardian of the staff... I would be that watcher. -- This is disturbing. Please continue. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (92, 8394, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (92, 0, 0, 'This is disturbing. Please continue.', 1, 1, 93, 0, 0, 0, 0, '', 0); -- There is not much more to tell. Dalaran was nearly wholly destroyed by Archimonde, the staff lost, presumably shattered by the barrier's fail-safe mechanisms. -- There are those that believe the staff to be the cause of Archimonde's reprisal. -- Please, tell me more. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (93, 8395, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (93, 0, 0, 'Please, tell me more.', 1, 1, 94, 0, 0, 0, 0, '', 0); -- After the fall of Dalaran, I took my leave from the Kirin Tor. I spent years watching over Atiesh, only to have my purpose amongst the Kirin Tor taken away from me in one fell swoop. I would find the staff, though it might take a lifetime. That is how I came to join the Argent Dawn and why I am here now. -- Is there anything else? INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (94, 8396, 0, 0); INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, condition_id) VALUES (94, 0, 0, 'Is there anything else?', 1, 1, 95, 0, 0, 0, 0, '', 0); -- I have tracked the various fragments of the staff across this world and in doing so, discovered Kel'Thuzad's plans to reform the staff. He has already collected several of the staff's fragments - which are being held by his most trusted lieutenants. -- I cannot emphasize enough the importance of keeping the greatstaff of the Guardian out of Kel'Thuzad's grasp. Frankly, I do not know what the result would be, other than a catastrophe of epic proportion. INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (95, 8397, 0, 0);

List of start up errors and fixes I will build the list of fixes here for the errors that are currently appearing in the log files. [CENTER]ERRORS / FIXED [COLOR="#B22222"]25[/COLOR] / [COLOR="#008000"]25[/COLOR][/CENTER] Antz implemented a number of updates that fixed a hell of a lot of errors :D -- ScriptDev2 ---------------- [COLOR="#0000FF"]UPDATE gameobject_template SET ScriptName='go_gordunni_trap' WHERE entry=144050; UPDATE gameobject_template SET ScriptName='go_pirate_treasure' WHERE entry=142194; UPDATE gameobject_template SET ScriptName='go_inconspicuous_landmark' WHERE entry=142189; UPDATE creature_template SET ScriptName='boss_netherspite' WHERE Entry=17367; UPDATE creature_template SET ScriptName='boss_netherspite' WHERE Entry=17368; UPDATE creature_template SET ScriptName='boss_netherspite' WHERE Entry=17369;[/COLOR] -- EventAI ------------- -- scripting done by SD2 [COLOR="#0000FF"]UPDATE creature_template SET AIName='' WHERE Entry=5764;[/COLOR] -- incorrect value used, 48 should be used for stand state (was set to 47) [COLOR="#0000FF"]UPDATE creature_ai_scripts SET action1_type=48 WHERE id=840003; UPDATE creature_ai_scripts SET action1_type=48 WHERE id=1029903; UPDATE creature_ai_scripts SET action1_type=48 WHERE id=454207;[/COLOR] -- World Database ---------------------- -- Developer items (Martin ...) [COLOR="#0000FF"]UPDATE item_template SET displayid=7016, sheath=3, DisenchantID=0 WHERE entry=17; UPDATE item_template SET dmg_type2=0, sheath=3, DisenchantID=0 WHERE entry=192;[/COLOR] -- unused entries [COLOR="#0000FF"]DELETE FROM gossip_menu WHERE entry IN (8671, 8685, 8689, 8690, 8691, 8706, 8707, 8708, 8709);[/COLOR] -- entry 6535 unused + text_id 7737 and 7738 -- need to locate which core these are from, if any .... looking like Cata [SIZE=3][COLOR="#800080"]-- COPY OF REMOVED RECORDS[/COLOR][/SIZE] -- =========================== -- *** [COLOR="#FF8C00"]To Be Used If The Records Are To Go Back Into The WOTLK/Three Database[/COLOR] *** -- -- 6535 (gossip_menu entries) -- '6535', '7737', '0', '1801' -- '6535', '7738', '0', '1802' -- [COLOR="#FF0000"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (6535, 7738, 0, 1802);[/COLOR] -- [COLOR="#FF0000"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (6535, 7737, 0, 1801);[/COLOR] -- 7737 npc_text record entry: -- '7737', 'The ashes from the burning wickerman radiate magical power.', NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0' -- 7738 npc_text record entry: -- '7738', 'The ashes from the burning wickerman radiate magical power. You have already applied the ashes to your face.', NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0' -- [COLOR="#FF0000"]INSERT INTO npc_text (ID, text0_0, lang0, prob0, em0_0, em0_1, em0_2, em0_3, em0_4, em0_5, lang1, prob1, em1_0, em1_1, em1_2, em1_3, em1_4, em1_5, lang2, prob2, em2_0, em2_1, em2_2, em2_3, em2_4, em2_5, lang3, prob3, em3_0, em3_1, em3_2, em3_3, em3_4, em3_5, lang4, prob4, em4_0, em4_1, em4_2, em4_3, em4_4, em4_5, lang5, prob5, em5_0, em5_1, em5_2, em5_3, em5_4, em5_5, lang6, prob6, em6_0, em6_1, em6_2, em6_3, em6_4, em6_5, lang7, prob7, em7_0, em7_1, em7_2, em7_3, em7_4, em7_5) VALUES (7738, 'The ashes from the burning wickerman radiate magical power. You have already applied the ashes to your face.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);[/COLOR] -- [COLOR="#FF0000"]INSERT INTO npc_text (ID, text0_0, lang0, prob0, em0_0, em0_1, em0_2, em0_3, em0_4, em0_5, lang1, prob1, em1_0, em1_1, em1_2, em1_3, em1_4, em1_5, lang2, prob2, em2_0, em2_1, em2_2, em2_3, em2_4, em2_5, lang3, prob3, em3_0, em3_1, em3_2, em3_3, em3_4, em3_5, lang4, prob4, em4_0, em4_1, em4_2, em4_3, em4_4, em4_5, lang5, prob5, em5_0, em5_1, em5_2, em5_3, em5_4, em5_5, lang6, prob6, em6_0, em6_1, em6_2, em6_3, em6_4, em6_5, lang7, prob7, em7_0, em7_1, em7_2, em7_3, em7_4, em7_5) VALUES (7737, 'The ashes from the burning wickerman radiate magical power.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);[/COLOR] -- =================================== [SIZE=3][COLOR="#800080"]-- END OF COPY OF REMOVED RECORDS[/COLOR][/SIZE] -- [url]http://www.wowhead.com/quest=29376/a-time-to-build-up[/url] -- [COLOR="#B22222"][SIZE=3]Cata[/SIZE][/COLOR] !!!! [COLOR="#0000FF"]DELETE FROM gossip_menu WHERE entry = 6535; DELETE FROM npc_text WHERE id IN (7737, 7738);[/COLOR] -- Copy of records made above, just-in-case they do belong in WOTLK, but judging by the link, they are Cata

Possible incorrect setting for mana of creatures You can ignore this :) I'm compiling a list of fixes for creatures in the database who currently have mana (MinLevelMana / MaxLevelMana), but possibly should not. This has been realised after applying a fix where mana users were not regenerating their mana (fix not PR'd at this time) Currently 371 records affected. The result will be either the mana setting being set to 0 (do not use mana), or the regenerate setting being set to 2 (they use mana). --------- PR has been made that sets all Warrior and Rogue classes to regen health only and removes the mana settings. It also sets Paladin and Wizzard classes to regen both health and mana.

Fixes for the logged errors at server start up I will build the list of fixes here for the errors that are currently appearing in the log files. [CENTER][SIZE=3]ERRORS / FIXED[/SIZE] [SIZE=3][COLOR="#FF0000"]1675[/COLOR] / [COLOR="#008000"]1675[/COLOR][/SIZE][/CENTER] -- Corrections were made to the update scripts in World/Updates/Rel20 -- scriptdev2-errors.log [COLOR="#0000FF"]UPDATE creature_template SET ScriptName = 'npc_onyxian_warder' WHERE Entry = 12129; UPDATE creature_template SET ScriptName = 'boss_netherspite' WHERE Entry IN (17367, 17368, 17369);[/COLOR] -- world-database.log Currently working on a a tool that can be used to populate the creature_template_classlevelstats table. Antz has a revert that may kill off a good number of these errors, so I will hold off from looking into any more of them until that has been applied, other than the above mentioned tool :D 1186 errors killed by Antz ----------------------------------------------------- Empty creature_item_template table ----------------------------------------------------- UPDATE creature_template SET RegenerateStats=1 WHERE UnitClass IN (1, 4); UPDATE creature_template SET RegenerateStats=2 WHERE UnitClass IN (2, 8); UPDATE creature SET curhealth=8352 WHERE guid=45758; UPDATE creature SET curhealth=8613 WHERE guid IN (45760, 45812); UPDATE creature SET curhealth=2699 WHERE guid=45818; -- invalid level UPDATE creature_template SET MinLevel=75, MaxLevel=75 WHERE Entry=23703; UPDATE creature_template SET MinLevel=75, MaxLevel=75 WHERE Entry=23808; UPDATE creature_template SET MinLevel=75, MaxLevel=75 WHERE Entry=24109; -- max level UPDATE creature_template SET MaxLevel=69 WHERE Entry=21860; UPDATE creature_template SET MaxLevel=60 WHERE Entry=14302; UPDATE creature_template SET MinLevel=25, MaxLevel=27 WHERE Entry=10760; UPDATE creature_template SET MaxLevel=73 WHERE Entry=15936; UPDATE creature_template SET MaxLevel=69 WHERE Entry=19799; UPDATE creature_template SET MaxLevel=68 WHERE Entry=19821; -- change of spell IDs UPDATE dbscripts_on_creature_death SET datalong = 10072 WHERE id IN (15355, 15338, 15264); UPDATE dbscripts_on_creature_death SET datalong = 10061 WHERE id IN (15340, 15277); -- incorrect class UPDATE creature_template SET UnitClass = 1 WHERE entry IN (17416, 17626, 17814, 23186, 25546); UPDATE creature_template SET UnitClass = 2 WHERE entry IN (18327, 20319, 20537, 20691, 22166, 22300, 25545, 25565, 25576, 25579); UPDATE creature_template SET UnitClass = 8 WHERE entry IN (18319, 18499, 18934, 18994, 18995, 20322, 20525, 20697, 20868, 21062, 21104, 21136, 21139, 21148, 22168, 21535, 21593, 23185); -- MoP introduced creature! DELETE FROM creature_template WHERE entry IN (17396); DELETE FROM creature_template_spells WHERE entry IN (17396); -- non existent zone DELETE FROM game_graveyard_zone WHERE id=969 AND ghost_zone=3459; -- not linked to correct loot entry UPDATE gameobject_template SET data1=3239 WHERE entry=3239; DELETE FROM gameobject_loot_template WHERE entry = 2483; UPDATE item_template SET displayid=7016, sheath=3 WHERE entry=17; -- unused entries - direct copy of Vanilla, but not used in TBC -- ======= Copied Rows ======= -- -- '7278', '11', '2', '8', '21330', '27', '0' -- '7371', '11', '2', '8', '21322', '27', '0' -- '8217', '11', '2', '8', '21331', '27', '0' -- '11362', '11', '2', '8', '21329', '27', '0' -- '18714', '11', '2', '8', '31162', '27', '0' -- '19319', '11', '2', '8', '21712', '27', '0' -- '34100', '11', '2', '8', '21712', '27', '0' DELETE FROM creature_item_template WHERE entry IN (7278, 7371, 8217, 11362, 18714, 19319, 34100); ============================================================================================================== [SIZE=3][COLOR="#008000"]More fixes -------------[/COLOR][/SIZE] -- Missing weapon entries for creatures DELETE FROM creature_item_template WHERE entry = 23051; INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (23051, 2, 7, 1, 24925, 13, 0); UPDATE creature_equip_template SET equipentry1=23051, equipentry2=23051, equipentry3=0 WHERE entry=5029; -- entry unused as creatures are equipped via another means DELETE FROM creature_equip_template WHERE entry = 5030; UPDATE creature_template SET EquipmentTemplateId = 0 WHERE entry = 16679; DELETE FROM creature_equip_template WHERE entry IN (23889, 28023, 32826, 31083, 29626, 23907, 24038, 1219); -- missing entry for Flight Master's weapon INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (23889, 2, 2, 2, 36600, 15, 0); -- missing entry for axe throwers at portal INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (28023, 2, 16, 1, 38576, 25, 0); -- missing weapon entry for Sanctum Defender INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (32826, 2, 2, 2, 43383, 15, 0); -- missing weapon entry for Val'zareq the Conqueror INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (31083, 2, 2, 2, 43386, 15, 0); UPDATE item_template SET name='Monster - Bow, Val\'zareq\'s' WHERE entry=31083; -- missing weapon entry for Netherstorm Agent INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (29626, 2, 3, 1, 44573, 26, 0); UPDATE item_template SET name='Monster - Gun, Draenei A01' WHERE entry=29626; -- missing weapon entry for Blade of Argus - [COLOR="#FF0000"] INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (23907, 4, 6, 1, 36637, 14, 4); UPDATE item_template SET name='Monster - Shield, Draenei A02 Purple' WHERE entry=23907; -- missing weapon entry for Gatewatcher Aendor - [COLOR="#FF0000"] INSERT INTO creature_item_template (entry, class, subclass, material, displayid, inventory_type, sheath_type) VALUES (24038, 4, 6, 1, 36726, 14, 4); UPDATE item_template SET name='Monster - Shield, Blood Elf A01' WHERE entry=24038; -- missing entry INSERT INTO creature_equip_template (entry, equipentry1, equipentry2, equipentry3) VALUES (1219, 13061, 0, 0); -- non existent entry was set for weapon ID UPDATE creature_template SET EquipmentTemplateId=5244 WHERE Entry=14733;