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

Page 1 of 2 1, 2  Next

View previous topic View next topic Go down

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

Post  Blachex on Sun Jun 06, 2010 2:38 am

How to create and add items for your wow server

VIDEO TUTORIAL

[You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  paulzbor8 on Tue Jul 06, 2010 1:41 pm

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!

paulzbor8
Member
Member

Posts Posts : 5
Reputation Reputation : 0

Back to top Go down

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

Post  Blachex on Tue Jul 06, 2010 4:43 pm

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

_________________
[You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  paulzbor8 on Tue Jul 06, 2010 4:45 pm

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

paulzbor8
Member
Member

Posts Posts : 5
Reputation Reputation : 0

Back to top Go down

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

Post  paulzbor8 on Tue Jul 06, 2010 4:51 pm

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

paulzbor8
Member
Member

Posts Posts : 5
Reputation Reputation : 0

Back to top Go down

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

Post  Blachex on Tue Jul 06, 2010 4:55 pm

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

_________________
[You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  paulzbor8 on Tue Jul 06, 2010 4:59 pm

Nope still getting the same error message.

paulzbor8
Member
Member

Posts Posts : 5
Reputation Reputation : 0

Back to top Go down

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

Post  Blachex on Tue Jul 06, 2010 5:01 pm

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

_________________
[You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  paulzbor8 on Tue Jul 06, 2010 5:05 pm

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

paulzbor8
Member
Member

Posts Posts : 5
Reputation Reputation : 0

Back to top Go down

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

Post  FailZorD on Thu Jul 08, 2010 3:36 pm

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.
avatar
FailZorD
Power User (Special)
Power User (Special)

Posts Posts : 82
Location Location : Athens
Reputation Reputation : 23
Warning :

http://www.lord-kings.co.nr

Back to top Go down

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

Post  bajas2 on Thu Jul 08, 2010 3:55 pm

You have a screenshot of a invalid item?

_________________
World of Warcraft Retail MoD

Ventrilo info:
eurovent1.gameservers.com
4601

avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

EDIT: Pics

Post  FailZorD on Thu Jul 08, 2010 7:13 pm

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.
avatar
FailZorD
Power User (Special)
Power User (Special)

Posts Posts : 82
Location Location : Athens
Reputation Reputation : 23
Warning :

http://www.lord-kings.co.nr

Back to top Go down

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

Post  bajas2 on Thu Jul 08, 2010 10:04 pm

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

_________________
World of Warcraft Retail MoD

Ventrilo info:
eurovent1.gameservers.com
4601

avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

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

Post  Blachex on Thu Jul 08, 2010 10:08 pm

but you executed the SQL file ? F9 ?

_________________
[You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  bajas2 on Thu Jul 08, 2010 10:10 pm

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

_________________
World of Warcraft Retail MoD

Ventrilo info:
eurovent1.gameservers.com
4601

avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

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

Post  FailZorD on Fri Jul 09, 2010 3:34 am

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
avatar
FailZorD
Power User (Special)
Power User (Special)

Posts Posts : 82
Location Location : Athens
Reputation Reputation : 23
Warning :

http://www.lord-kings.co.nr

Back to top Go down

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

Post  Blachex on Fri Jul 09, 2010 3:49 am

If you do everything like I did in the tutorial it should work fine Neutral
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  FailZorD on Fri Jul 09, 2010 4:45 am

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.
avatar
FailZorD
Power User (Special)
Power User (Special)

Posts Posts : 82
Location Location : Athens
Reputation Reputation : 23
Warning :

http://www.lord-kings.co.nr

Back to top Go down

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

Post  Chubby7 on Fri Jul 09, 2010 6:11 am

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.
Neutral Neutral Neutral Plz help me Crying or Very sad
avatar
Chubby7
Member
Member

Posts Posts : 17
Location Location : @Home
Reputation Reputation : 0

Back to top Go down

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

Post  bajas2 on Fri Jul 09, 2010 6:29 am

Chubby7; your database does not have the table 'characters.items'. Try downloading a different database
avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

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

Post  Chubby7 on Fri Jul 09, 2010 4:47 pm

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
avatar
Chubby7
Member
Member

Posts Posts : 17
Location Location : @Home
Reputation Reputation : 0

Back to top Go down

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

Post  Blachex on Fri Jul 09, 2010 6:28 pm

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.
Neutral Neutral Neutral Plz help me Crying or Very sad

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

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  Chubby7 on Fri Jul 09, 2010 6:34 pm

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



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

Posts Posts : 17
Location Location : @Home
Reputation Reputation : 0

Back to top Go down

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

Post  Blachex on Fri Jul 09, 2010 6:59 pm

Then click on dpdb and execute
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

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

Post  Chubby7 on Fri Jul 09, 2010 7:00 pm

Hmm now i got this:

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

(2131 was the entrycode for that item)
avatar
Chubby7
Member
Member

Posts Posts : 17
Location Location : @Home
Reputation Reputation : 0

Back to top Go down

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

Post  Sponsored content


Sponsored content


Back to top Go down

Page 1 of 2 1, 2  Next

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum