Written in respondse to http://www.mmowned.com/forums/emulat...tom-items.html
Further down you will read how to fix autoshoot for custom items aswell as the enchanting bug; the solution is best suited for funservers but can be applied to 'blizzlike' with slight effort.
Cons:
- In bags, your custom items will not display their given icon. (you do have some options.)
- Requires editing tables in your db.
Pro's:
- Player can enchant his own gear.
- Auto-shoot/attack will work properly.
Guide.. ish:
Below are several links from wowhead; I've listed this in order of 'danger' - as in chance of players obtaining the item from a mob.
You can however, disregard it if you are willing to edited your loottables.
Accordingly; you can change the filter from uncommon to common; or expand it all the way to legendary if your private server hasn't got any reputation vendors, instances and so on - spawned; or if you couldn't care less about people obtaining it in different ways.
In order to achieve this, simply create or use your backup database; drag and drop the tables: items, playercreateinfo_loot and vendors (if I recall properly) select to copy only the structure when prompted - followed by either backing those tables up elsewhere and/or replacing them with the empty ones.
Bows / Guns
Weapons - Items - World of Warcraft
Crossbows / Thrown / Wands
Weapons - Items - World of Warcraft
Armour
Custom armour should work with any replaced item, I however, advice you to use wowhead's filter to find the most fitting piece to replace (ie; plate for plate, head for head, ring for ring ect.)
Armor - Items - World of Warcraft
Now what?
Well you've been handed a bunch of information, but I'll make an example.
I want to make a custom bow.
I use wow-v to find a nice displayid for a bow and give it the according stats.
I've found a grey item to replace; Balanced Long Bow - Item - World of Warcraft (notice the number at the end of this url; 4025)
I start up Navicat.
I go into the tables stated above and remove all according entries; aswell as give my item on wow-v the entry 4025.
I generate the query, execute it on navicat and tada!
There you have your custom bow with working autoshoot, aswell as the ability to apply a scope on it!
Final notes:
As stated above, I've written this in respondse to several posts of different people here - however, my last experience was before Wotlk and since then the server I worked on died; as such, I couldn't look up the exact table names - so if anyone notices I missed a table or such, please correct me. ^^'
I'm also not very imaginative so couldn't really make a FAQ, any questions; fire away! I'll be glad to help.