Mangos-Three item_template and Custom Items

[blacksunseven]

So my Mangos-Three server runs just fine but I've been trying to create custom items. I've used the wow-v tool/website and noticed that it has some columns in its SQL query that don't exist in my mangos.item_table like dmg_min, dmg_max, and a few others. I gave up on using any external tool after discovering this, assuming that the table format was different for mangos-three for some reason than previous mangos cores, and tried doing it by hand. However, even just copying a pre-existing item and giving it a new entry id always results in the same problem - that is, whenever I add it in-game using the .additem command, it appears in my inventory as a question mark and says that it is "retrieving item details."

I could use some help on this.

[khamarr3524]

MaNGOS 3 is not stable and its possible something could be incorrect in the database.

Edit: After review, I can see that the sql for MaNGOS 3 uses mindmg and maxdmg. So you can either do hand written SQL or reformat your database to fit the SQL files.

[blacksunseven]

I'm glad you were able to find the min_dmg column in the database, but I'm afraid I've had no such luck. The database I imported when I set up the server was MaNGOS3_Cata_Rev_3.sql. I've tried even grepping inside this file for the string "min_dmg" and found no results; "mindmg" returns some results but only in mangos.creature_template. What database file did you import for your Mangos 3?

edit: I just looked at MaNGOS3_Cata_Rev_2 for any mention of "min_dmg" and found no results.

[khamarr3524]

Hmm. Like I said, the MaNGOS 3 revision is very unstable however I don't really touch M3. This however https://github.com/mangos/server/blob/master/sql/updates/12112_01_mangos_item_template.sql could answer some questions you may be having. I'm unsure why Salja did this, but I suppose he has his reasons.

[blacksunseven]

Yeah, that is odd and I certainly don't understand it. Makes me curious how items still know what damage values they have. Is this the roadblock I'm running into with custom item creation? I'm pretty shocked that even just duplicating items doesn't work.

[khamarr3524]

For more info on this I would hope for (more probably wait for or PM) Saljia to comment here and explain why this was done.

[Christian Schamara]

Some Opcodes is missing and some other stuff so you have atm the red ?

[blacksunseven]

So the missing opcodes were the reason you needed to drop those columns? Where do items get their damage values from without those columns in item_template? And is there any way to create items for Mangos 3 right now?

[Christian Schamara]

no i drop the colums thats is new struc of dbc files mindmg etc is not more needed on cata

[blacksunseven]

Alright, so without min_dmg, where are the damage values pulled from? I've been trying to create items in the database all day without any success and I think it's got something to do with the change to that table.

Edit: I've answered all my questions finally after finding this video ->

Basically, the answer is yes, you can add custom items to Cata still but it is quite a bit more complicated. Hopefully there will be some way to do this server-side in the future.