Hallowed Wands

[nvragain]

Ok so I made a server..3.1.3 Aspire Hearthstone...and i cant seem to get the Hallowed wands working in the dbc? I am setting up for my Halloween event and need them to be working. Any help on this? Can anyone share a .sql with me?

Hallowed Wand - Leper Gnome - Item - World of Warcraft

So since halloween is comin up..anyone have ideas for any events?

[Padlockcode]

Happy Halloween

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, 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, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, RandomSuffixId, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill)
VALUES (99998, 0, 8, -1, "Leper Transformation Wand", "Leper Transformation Wand", "Leper Transformation Wand", "Leper Transformation Wand", 7292, 6, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 24713, 0, 10, 10000, 1141, 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, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[SupernovaHH]

i just made an NPC for this. Here ill post the script and sql below for you, it works 100%

Spirit Halloween Costume Vendor

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('900110', "Spirit Halloween", "Halloween Costumes", '', '0', '10', '0', '1', '0', '0', '20020', '20022', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('900110', '80', '80', '35', '63000', '63000', '36000', '1', '0', '100', '0', '3000', '4000', '0', '0', '0', '0', '500000', '8000', '0', '0', '0', '0', '0', '0', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

Spirit Halloween Lua script to make it work

function On_Gossip_Talk2(unit, event, player)
unit:GossipCreateMenu(3544, player, 0)
unit:GossipMenuAddItem(2, "|cFF008080Pirate Costumes", 7000, 0)
unit:GossipMenuAddItem(2, "|cFF0000FFNinja Costumes", 7001, 0)
unit:GossipMenuAddItem(2, "|cFF008080Leper Gnome Costumes", 7002, 0)
unit:GossipMenuAddItem(2, "|cFF0000FFGhost Costumes", 7003, 0)
unit:GossipMenuAddItem(2, "|cFF008080Bat Costume", 7004, 0)
unit:GossipMenuAddItem(2, "|cFF0000FFSkeleton Costume", 7005, 0)
unit:GossipMenuAddItem(2, "|cFF008080Wisp Costume", 7006, 0)
unit:GossipMenuAddItem(2, "BONUS!|cFF0000FFRabbit Costume", 7015, 0)
unit:GossipMenuAddItem(2, "BONUS!|cFF0000FFFrog Costume", 7016, 0)
unit:GossipSendMenu(player)
end

function On_Gossip_Select2 (unit, event, player, id, intid, code)

if(intid == 7000) then
unit:GossipCreateMenu(3543, player, 0)
unit:GossipMenuAddItem(1, "Undead Male Pirate", 7007, 0)
unit:GossipMenuAddItem(1, "Human Female Pirate", 7008, 0)
unit:GossipSendMenu(player)
end

if(intid == 7001) then
unit:GossipCreateMenu(3543, player, 0)
unit:GossipMenuAddItem(1, "Human Male Ninja", 7009, 0)
unit:GossipMenuAddItem(1, "Human Female Ninja", 7010, 0)
unit:GossipSendMenu(player)
end

if(intid == 7002) then
unit:GossipCreateMenu(62, player, 0)
unit:GossipMenuAddItem(1, "Male Leper Gnome", 7011, 0)
unit:GossipMenuAddItem(1, "Female Leper Gnome", 7012, 0)
unit:GossipSendMenu(player)
end

if(intid == 7003) then
unit:GossipCreateMenu(3543, player, 0)
unit:GossipMenuAddItem(1, "Male Ghost", 7013, 0)
unit:GossipMenuAddItem(1, "Female Ghost", 7014, 0)
unit:GossipSendMenu(player)
end

if(intid == 7004) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24732, player)
unit:GossipSendMenu(player)
end

if(intid == 7005) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24723, player)
unit:GossipSendMenu(player)
end

if(intid == 7006) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24740, player)
unit:GossipSendMenu(player)
end

if(intid == 7007) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24708, player)
unit:GossipSendMenu(player)
end

if(intid == 7008) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24709, player)
unit:GossipSendMenu(player)
end

if(intid == 7009) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24711, player)
unit:GossipSendMenu(player)
end

if(intid == 7010) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24710, player)
unit:GossipSendMenu(player)
end

if(intid == 7011) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24712, player)
unit:GossipSendMenu(player)
end

if(intid == 7012) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24713, player)
unit:GossipSendMenu(player)
end

if(intid == 7013) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24735, player)
unit:GossipSendMenu(player)
end

if(intid == 7014) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24736, player)
unit:GossipSendMenu(player)
end

if(intid == 7015) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(61716, player)
unit:GossipSendMenu(player)
end

if(intid == 7016) then
unit:GossipCreateMenu(3543, player, 0)
unit:FullCastSpellOnTarget(24753, player)
unit:GossipSendMenu(player)
end

end

RegisterUnitGossipEvent(900110, 1, "On_Gossip_Talk2")
RegisterUnitGossipEvent(900110, 2, "On_Gossip_Select2")

This NPC applies a costume for you, if you want him to have more costumes PM me on mmowned with what you want and ill do it for you