Item Spells!!! -Noob Freindly (like always)

[xpxd]

Hello Welcome To My Third Tut And As Always n00b Freindly

this time i will be showing you how to make items buff you on equip

i will be using a random item to do this

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, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, 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, unk203_1, 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, unk2)
VALUES (85558, 4, 0, -1, "Test Necklace", "Test Necklace", "Test Necklace", "Test Necklace", 9853, 0, 0, 200000, 10000, 2, -1, -1, 1, 1, 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, 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, 1, "Ding Dingy Dang Dongy", 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);  

you can put that in your db and lets start

so find it in your items db and scroll sideways until u find spell1 it probably filled so go to spell 2 if its filled goto spell 3 now find a spell id make it interactive so dont make it like fire ball cause that'll do damage to the characters so

hmmm

lets use this - "Love is IN The Air" id = 27741

so on spell 3 put 27741 and on spelltriger put a 1 then put 0 on the rest there now when you equip Test Necklace You Will Be Buffed with "LOve Is IN The Air"

!!!

[JustJ]

nice guide i could probably use this as i am a item creator heres some rep

[fille]

Faaaaaaaaaaaail

[xpxd]

u have one rep so shut th F*** UP

[dBloc]

Originally Posted by xpxd

u have one rep so shut th F*** UP

No offense, but it was not "n00b friendly". I understood it a little, but what about chance on hits? Or even a Use ability on a weapon to do like 9999 damage? That's what I at least thought this thread was about.

[Hunterplay]

Originally Posted by fille

Faaaaaaaaaaaail

Your the Fail

[meddle]

I recently went through the non-player spells listed on wowhead and found some pretty interesting effects. The ones that could actually be useful are limited... but there are definitely some colorful items that could be made with these.

For example, I put Phasing Stealth (~every 30 seconds you automatically stealth for 8 seconds, no movement speed reduction) "On Equip" on a ring (the one ring to rule them lawl).

I am considering whether it is feasible to create a custom DB with scripted bosses and non-engrish quests. Chances are I'll never get off the ground, since the only real motivation for such a project would be a playerbase, and it takes resources to put that kind of thing together. I have yet to find a private server that actually took the tools available and made something innovative. I mean, you can make consumable tomes that teach Frost Nova. Why do so many servers make custom weapons that are nothing more than 1000dps, 100str, 100agi, etc etc?

At any rate, I want to contribute one last piece of info for anyone who doesn't already know: instead of querying your database manually... search FDE, Flexible Database Editor, and download that. You can connect to your DB with it and it has a very friendly interface for most of your creation needs. (((credit to the author of FDE, who recently updated the program)))