How to edit database to add an item from sql ?

[random_dude]

Hey guys, sorry if this is a dumb question but I've been searching for a while. So I downloaded a ready to play server, specifically this one
http://www.ownedcore.com/forums/worl...er-repack.html (WoW mangos zero 0.19 1.12.x Server Repack)
Now how do I add an item? I created one using online creator and it's a sql file. I figured I have to open the database inside my mangos folder but the files are in frm and myd format so what program do I need to open them? If its mysql I have to install please tell me which one I need cause I'm really lost at this. I tried some free version and it asked me to setup a server for me, but do I even need a server if I already have my wow emulator working? I only really need to edit my database. Its all so confusing

[Nadromar]

You'll need to use a program like HeidiSQL to import the file into the mangos_world database.

[random_dude]

Alright thanks, I managed to open the database in Heidisql using root/mangos password. I figured I should be editing the item_template table. But I can't paste my item there cause there are incopatible columns or something. Guess it's because my server is vanilla 1.12.1 and the table structure is different. And my item was made on wow-v online by the way. So I'm currently trying to fill out the columns by hand figuring out what they stand for. No idea if it will work. I wonder if there is a simpler way like an item creator working with vanilla? That would be great

[Nadromar]

The tool you used to create the item doesn't support this version of cmangos.

I'm working on a tool to create items & more for TrinityCore.
It's not intended for cmangos but i've slightly modified it so item creator does work cmangos vanilla a while ago.
You can download it here.

But again, it's barely tested on cmangos so if you run into an issue, let me know and i'll fix it asap.
Just make sure you change the emulator under Settings > Select emulator.

Alternatively you can create a new item manually in the database using this link to figure out what all the columns mean.

[random_dude]

Yay! so far it seems to work. Thanks a lot
It did have a problem with this unknown column 'socketBonus',even though I did not add any sockets. I deleted those entries in the sql just in case and tried again and it went fine.
Also theres a minor cosmetic glitch which shows stats duplicated in a weird way when you mouse over your item in the game, but that may be my fault cause I did kinda go over the top with stats like adding 99999 health etc. And I havent done any other testing yet so not complaining
Now I should be able to kick some old naxxramas or world bosses with that. Haven't really played vanilla ever

[Nadromar]

Thanks for letting me know, I'll look into fixing those issues.

[random_dude]

Hey, just got back to making items. Here's what I found out. Health regen and mana regen per 5 sec (stat_id 43 & 46 I believe) didn't work for me. mangosd gave a warning in red text that it didnt even recognize those id's. I looked up an existing item with mana regen and indeed it appears to be a spell not stat, I even chcked that on wowhead to make sure. I had to work around by adding over9000 Spirit instead to keep the regen up.
+ Mana results in weird description in game like I said, but frankly I only added huge amounts like 10-30k and didnt bother to see if its the same with normal amounts. Health works just fine though, I added 30k.
Thats all for now

edit. now that i think about it, there prbly wasn't even the + mana mod in the actual game in the first place. i think spell consumption scales along with mana pool or something, not sure though. in fact I havent played wow in about 3 years and my main has always been a rogue.

[Nadromar]

Indeed, I'll add a way to remove incompatible things from the form later on.
For example, quest arena point reward is also incompatible with vanilla, but it will simply be ignored on vanilla.
I'll also ensure you can't make stats bigger than their supported max value.

Currently working on supporting quests for cmangos zero, it's basically done but I wanna throw in a few more features tomorrow before I release the new build.