Getting started...

[4BOLTMAIN]

Im totally new to the private server thing. I just downloaded Zellcorps repack and set up a server on my lan to mess with.

With Heidisql I copy the item Foror's crate row in the item_template.

After I copy the row...
I set the item id to 9000 (not used)
I name the item Bag of Holding
I set the displayid to Bag of Fishing Treasures (2591, the blue one)
I enter a new description "The one and only."
I then created a new row in the npc-vendor section for a vendor to sell the item for 0 gold.

I am also trying to do this with a mace. I pick one out, copy the row then I change stuff to my liking (str, sta, damage, and speed) and once again add this item to the vendor. With this mace i didnt change the displayid.

Why do my 2 items look like a BOOK O_o (The visual when I ctrl-click the mace it shows a blue and white checkered box on my characters hand)

Obviously theres a simple explanation but I cant find it.

EDIT.....

Forgot to mention that I did delete my cache folder to see if that would fix the display but it didnt.

If I just make a copy of Garfrosts 2 ton hammer and only change the entry id, it still shows as a book in the vendor.

[wowmachackerz]

the blue and white checkered box appears when the object does not have a valid display ID, try and change the display ID of the weapon to something which you know works, you can find some display ID'S online, just google them. Hope this helps

[4BOLTMAIN]

the blue and white checkered box appears when the object does not have a valid display ID, try and change the display ID of the weapon to something which you know works, you can find some display ID'S online, just google them. Hope this helps

Thank you for the reply. I have tried 2 repacks... first one was zellcorps and the second one was Pryd.

I am not educated on Mysql at all but what I am trying to do seems simple... copy the row and edit the stats, save, add the id# to the vendor, then restart server. I even went as far as restarting the pc. This does not work on both repacks I have tried. I can get the item to show in the vendors inventory but wrong icon and visual. I have tried HeidiSQL and SQLyog, same result from both.

EDIT.....

This is the first time I have used any of this software, Im thinking its something totally stupid that Im not doing in the database software but like I said... I edit then save. Is there something else I need to do when copying and editing the rows?

[wowmachackerz]

it might be a problem on how you are putting the item into the database, google "wow-v" and download any of the weapons of there as a SQL Batch file, (there is an option for it) and then right click on the database where your items are and then click "execute batch file," browse for the recently downloaded weapon and try that out, also, you may be putting the items in the wrong database but it is unlikely. Hope this helps!

[4BOLTMAIN]

I tried from wow-v at first but I get the same icon and visual when I imported the file so I figured I would try and copy a row and see what that did.

Like I said... Ive never messed with MySQL or database manager programs before but I can catch on fairly fast.

I am editing the world/item_template for the item and for the vendor I edit the world/npc_vendor. The vendor part works fine but the item is bugged.

Heres exactly what I am doing in HeidiSQL....

I find an item in the item_template. I copy the row and assign a new id#. I click the green check (Post(Ctrl+Enter)). Then I go to the npc_vendor table and enter a new row referencing the new id# to a vendor. Once again I click the green check and then restart my authserver and worldserver. I am not restarting MySQL, I leave that running.

I tried SQLyog also with the same results. I am rather fond of HeidiSQL but I am open to suggestions if there is a better program to get me where I am going.

Thank you again for the reply.

[wowmachackerz]

hmm,thats really odd, ok, try restarting the mysql window and see if that does anything, i'm just a bit concerned that when you reset the mysql. it would reset the database and everything would be reset. try resetting the server ingame while not resetting the world or login server. theres a command but i forgot it sos. also. try instead of editting a item.make a completely new row in the item table. and finally. try to add the item ingame using the .additm command and see if u get the same display problem then. hope this helps and reply back with any problems!

[4BOLTMAIN]

Ive been really busy... I downloaded the source from Trinity and compiled it myself... first time... so yeah it took me a little bit but I started from scratch and got it going. But anyway it seems when I import a file from wow-v and use the number 9000 or 9001 the icon defaults to a book, but if I start the id# at 60000 the icon and display are fine... however, in my bag I get the red ? and "Must have melee weapon equipped" error. This is really wierd cause I went into my db, changed the id of an item from 9000 to 90000 and then it displays the correct icon and I am able to equip it... however now I still have the red ? when the item is in my bag and the melee weapon error. (I wont be using 90000 or higher for any items I just was curious about the book thing.)

I totally ditched the old databases and went with a fresh install of MySql 5.5.8 so I dont have a window where I can type commands. When I add or copy a row and then reference the item to the vendor I try the 'reload all' command but it doesnt reload the item_template. What I do is just restart the world server and then the item shows in the vendor. If there is a command for that I dont know it and I dont see it in the list of commands for trinity.

I took 2 items... Reins of the Voilet Proto Drake and Reins of the Green Proto Drake I copied the row for the green drake but created a new row for the violet drake and then entered in all the data manually. I removed the requirements on both (lvl 70, Riding 300 etc.) then added both to the vendor. The Violet one said Use:NULL so I wasnt able to add that to my collection but the green one worked. I then deleted the Violet one, made a copy of it and, of course, that one worked.

So... now that we have the book/cube problem solved (still bothers me that 9000 id # does that though) now theres the red ? icon and the 'requires melee weapon' bug. I will do some looking and post what I find.

[Facerolling]

The reason why it is defaulting to a book icon is because that is within the DBC files under the entry of 9000.

The "requires melee weapon" "bug" is also due to the DBC files enforcing only the IDs marked as weapons in it to be treated as weapons.
The easiest way to bypass the "Requires melee weapon" bug, just modify a pre-existing weapon, you can even change the display ID but it will have the default icon instead of the new display icon

For example:

I edit the item "Worn Shortsword" to have +90 stamina and to look like Anathamea and to be called "Herpaderp"

The sword will be usable, it will look like Anamathea in the world, on the character equip screen it will be called Herpaderp and have +90 stamina but the icon will still be the worn shortsword's icon.

Hope this helps.

[4BOLTMAIN]

The reason why it is defaulting to a book icon is because that is within the DBC files under the entry of 9000.

The "requires melee weapon" "bug" is also due to the DBC files enforcing only the IDs marked as weapons in it to be treated as weapons.
The easiest way to bypass the "Requires melee weapon" bug, just modify a pre-existing weapon, you can even change the display ID but it will have the default icon instead of the new display icon

For example:

I edit the item "Worn Shortsword" to have +90 stamina and to look like Anathamea and to be called "Herpaderp"

The sword will be usable, it will look like Anamathea in the world, on the character equip screen it will be called Herpaderp and have +90 stamina but the icon will still be the worn shortsword's icon.

Hope this helps.

Yeah that makes a lot of sense. Is there any way to edit this dbc file to correct this problem?

[The-Eradicator]

Yeah that makes a lot of sense. Is there any way to edit this dbc file to correct this problem?

Yes, but it requires all players to download a client patch.

A better option is to create items using unused item IDs from the DBCs. Search on MMOwned and you should find several lists of them.

[4BOLTMAIN]

I now have it figured out. I did some more research and I was able to create a sword that has no bugs or a ? icon.

I downloaded a DBC editor and opened the file item.dbc then did a search for 44609. (Frostmourne visual) That number was referenced to the id # 33350. I then checked my item_template to see if that number was being used and it wasnt so I made a 2h sword and set the id to 33350. Works perfect.

I really appreciate all the help I have received. Now I am not going to sleep for days!!!!