[Tutorial]How to Create and Add Items To your WoW Server

Hi Blachex,

I'm having trouble with adding the item to my server. I start everything up good but when i press f9 i get an error message that usually says something like...

[Window Title]
Error

[Content]
SQL Error (1109): Unknown table 'items' in information_schema

[OK]

Occasionally it may replace 'items with characters or name2.

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, 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, itemstatscount) VALUES (987076, 4, 0, -1, "Necklace of The Devil", "Necklace of The Devil", "Necklace of The Devil", "Necklace of The Devil", 9852, 6, 0, 666666666, 66666666, 2, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 666, 3, 666, 4, 666, 5, 666, 6, 666, 7, 666, 12, 666, 13, 666, 14, 666, 15, 666, 0, 0, 0, 0, 0, 0, 0, 666, 666, 666, 666, 666, 6/* large SQL query, snipped at 2,000 characters */
/* SQL Error (1109): Unknown table 'items' in information_schema */

This was the last error i got could you please look it over and tell me if im doing something wrong and how to fix it thanks!

You downloaded other version of your item (There are ArcEmu < , ArcEmu > , Mangos , Ascent...) , depends on your emulator

Oh ok thankyou i was pretty sure i downloaded the right one but ill try again.

Nope i tried all of the other ones and i even tried the same one again but thankyou for the help anyways.

or , before you execute the file be sure you click on WORLD database

Nope still getting the same error message.

As I see : Unknown table 'items' in information_schema , can't find table items then you executed it in other database (not world)

or you have different emulator

Oh ok thankyou very much from what i understood u meant make sure arcemu-world was running ok thankyou its working now!

Blachex i appriciate your help that you have done to me and i would like to ask you a last thing. When i open MySQL and HeidiSQL and trying to add some items, are succesful and some of the vendors are too. But when i restart MySQL by closing and open it again, doing the steps as the tutorial... in-game the items are invalid. I have double check the ID's and they are correct. But it appears to be invalid in-game.
Thank you for reading my message, and I appriciate it.

You have a screenshot of a invalid item?

What do you really mean? Screenshot from the game...yeah give me a sec will upload.


As you all can see its added properly. I had no errors but just the in-game message. Did everything like Blachex posted on the tutorial.
Thanks for reading and answering my Post.

I can't see anything wrong, but i see that you use the new 3.3.5 repack. That can be the problem.. since the the patch is so new it have some problems, try your items in a repack with a earlier patch

but you executed the SQL file ? F9 ?

AND restarted server (including mysql) i've forgotten that too many times

I did exexute it from the Blue Mark like Play Buttom... Ok will check too.
----------------------------------------------------
Yeah like i said i did execute but thats the answer...
If it is possible log on Skype so we can have a chat and help me...or...
We can use Teamviewer so you can do the moves to my PC.
Thank you again. Just tell me Skype name is: Alex-Simitis

EDIT By Blachex : Don't double-post

If you do everything like I did in the tutorial it should work fine

Sorry about it...
But if you can really help can you use the Teamviewer?
I really need that help and fast.
EDIT:
Ok now i am really angry... Your item from:
[You must be registered and logged in to see this link.] worked like magic and mine from wow-v.com are damn invalid... Followed your Tutorial and added yours and mine in the same time with different ID ofc... You spawned in my inventory... But when i tried mine it just doesnt spaw...invalid
EDIT:
Here is my item: [You must be registered and logged in to see this link.]

Thanks again.

Hey i get an error adding items to HeidiSQL:

/* SQL Error (1146): Table 'characters.items' doesn't exist */

This is happening when I press F9.
Plz help me fixing this.
I got ArcEmu 3474 3.3.5a (12340)
And yes i got the ArcEmu > v2801.
Plz help me

Chubby7; your database does not have the table 'characters.items'. Try downloading a different database

Can you link me plz?
I got ArcEmu for 3.3.5a version.
IDK where to download something else.
This tutorials rock. But I need the right database to follow this. :S
Maybe you know a database for me? :$ :W

Chubby7 wrote:Hey i get an error adding items to HeidiSQL:

/* SQL Error (1146): Table 'characters.items' doesn't exist */

This is happening when I press F9.
Plz help me fixing this.
I got ArcEmu 3474 3.3.5a (12340)
And yes i got the ArcEmu > v2801.
Plz help me

Maybe you didn't selected the WORLD database (When you login to db, before pressing F9 be sure you click on WORLD db)

I don't even got a world database...



Im using ArcEmu 3.3.5a (12340)
Maybe you know a better one?

Then click on dpdb and execute

Hmm now i got this:

/* SQL Error (1062): Duplicate entry '2131' for key 1 */

(2131 was the entrycode for that item)