Easier way to edit Mangos database?

[chrisrulz911]

Well to edit the mangos database to change items etc... ive been doing it manually, going into SQLyog and creating a new row for the item, and having to input all the columns of information manually. Im just wondering if there was a different easier way to do it. Ive tried Mangos Database Handler, but it kept on giving me a configuration error.

 

[THE_Wolfman]

I guess a different or easier way of adding entries to your mangos database, will depend on how you store the original data that you use to populate each new entry.

I work on a number of different 'projects', so on occasion I will have raw data to add, stored in text or CSV files. The data might look like:

1,235,247,0,247,0
or
1 235 247 0 247 0
OR
1,235,247,0,"big stick",0
or
1 235 247 0 'big stick' 0

When this is the case, I tend to use a text parsing tool like

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

to put the data into a SQL usable format, by adding the necessary spaces and brackets etc. giving me:

(1, 235, 247, 0, 247, 0)
OR
(1, 235, 247, 0, "big stick", 0)

and having it place INSERT commands in front of the data and a semicolon at the end, giving me:

INSERT INTO `my_table` VALUES (1, 235, 247, 0, 247, 0);
OR
INSERT INTO `my_table` VALUES (1, 235, 247, 0, "big stick", 0);

Once I have a number of these SQL commands, I can do an import or run them as SQL.

For me this is easier, but I will tell you now that many text replacement tools can take a while to set up to properly handle your data. Basically you will need to get used to another tool, and it may not be worth it for you.

 

[chrisrulz911]

yeah, ur right lol, ur way does seem complicated. Any others?

 

[xenoaurora]

Well to edit the mangos database to change items etc... ive been doing it manually, going into SQLyog and creating a new row for the item, and having to input all the columns of information manually. Im just wondering if there was a different easier way to do it. Ive tried Mangos Database Handler, but it kept on giving me a configuration error.

New hear but what ive found that is awesome for it is mangos mdh. i think you can find it here [SIZE=-1]www.bluesailor.net/MDH.php just message me if you have questions...its pretty simple though.[/SIZE]

 

[chrisrulz911]

Well to edit the mangos database to change items etc... ive been doing it manually, going into SQLyog and creating a new row for the item, and having to input all the columns of information manually. Im just wondering if there was a different easier way to do it. Ive tried Mangos Database Handler, but it kept on giving me a configuration error.

Anything else ?

 

[Yamachi]

Besides MDH, the only way to add new stuff is to do it manually. I'm currently working on a wow.allakhazam xml-to-sql converter, which will make it EXTREMELY easy to add missing items to the DB. At the moment, it only works for Kobold v3, but I'll probably release a MaNGOS-compatible one too.

 

[xmasta]

i had the same problem with the mdh, but i solved it with trying other versions of it. if you dont have the newest rev of mangos, you cant use the newest version of mdh.sometimes it works, but mostly not.but i dont know which rev you have...

 

[Krayhan]

Besides MDH, the only way to add new stuff is to do it manually. I'm currently working on a wow.allakhazam xml-to-sql converter, which will make it EXTREMELY easy to add missing items to the DB. At the moment, it only works for Kobold v3, but I'll probably release a MaNGOS-compatible one too.

That would be great allakhazam xml-to-sql converter, pls let me know by pm when its ready.

Cheers, Krayhan.

 

[narkyvic]

Well if you are adding totally new items then make the items on

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

download it to mangos, copy and paste the script into the query section of sqlyog press ctrl and A then Ctrl F9. that will add the new item. If you want to edit something that you already have in the data base then try using a db editor like quice. Although I would use version quice_1_2_54 as the latest gives me errors when editing quests.


Lol I just saw how old this thread is :S I hope you have managed it by now lol