creating items

[Dimes]

I don't know where else to search. I've searched in SQL and database files but I cant find where I could add items. please help

 

[TheOne14]

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

gl.

 

[Dimes]

thanks but where can I find the Item ID? Like its model #

 

[Bloodshed2007]

To view the content, you need to sign in or register

replace the 12345 with itemid....scroll down and look for the displayid>####<displayid something like that

 

[Dimes]

ok when I make the SQL file what do I do with it?

 

[Bloodshed2007]

1. Extract the .sql files from the zip folder.
2. Open up SQLYog or Navicat.
3. Right-click on your database name.
4. Select execute from batch file.
5. Click the '...' button.
6. Select the .sql file
7. Execute that file!
8. ENJOY

 

[liquifigh]

Wow I was looking for this! Thanks for the links.

 

[Dimes]

I get a bunch of errors cause my tables in item_template are different.

 

[2EZ]

If you are willing to spend some time without those easy tools, you can just enter a new row in the items database, pick a high (unused) entrynumber and start playing with your tablestats (comparing tables with existing item's). Tools are GREAT, but if they don't match your table structure... this is the alternative.

When you've added new items and you can't seem to find them on your server, try emptying your cache folder in the WoW directory.