Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Serverside Modding => Topic started by: Devwaza on January 08, 2013, 10:47:13 pm

Title: [QUESTION] WMV character to mysql database?
Post by: Devwaza on January 08, 2013, 10:47:13 pm

Well, I was wondering if there is a way to select a character in Modelviewer, equip it with weapons and gear, and then somehow make the character design become a "entry id" for me to use in TrinityCore Manager's database editor?

Since I'm pretty new to all of this, I can't really elaborate but hopefully someone understands what it is that I'm trying to acomplish here.

Best regards

Title: Re: [QUESTION] WMV character to mysql database?
Post by: Ascathos on January 08, 2013, 10:53:57 pm

You don't add character displayinformation (As in: what defines it) into your mysql database.

Title: Re: [QUESTION] WMV character to mysql database?
Post by: Steff on January 09, 2013, 12:56:03 am

For Trinity you need 2 DBCs and 4 MySQL Entrys

DBCs
CreatureDisplayInfo.dbc
CreatureDisplayInfoExtra.dbc
 
MySQL
creature_template
creature
creature_model_info
creature_equip_template

I write in the moment a tool doing it. It is integrated in the Maruum web Interface.

viewtopic.php?f=61&t=3220 (http://modcraft.io/viewtopic.php?f=61&t=3220" onclick="window.open(this.href);return false;)

Title: Re: [QUESTION] WMV character to mysql database?
Post by: Ascathos on January 09, 2013, 11:01:28 am

Quote from: "Steff"

For Trinity you need 2 DBCs and 4 MySQL Entrys

DBCs
CreatureDisplayInfo.dbc
CreatureDisplayInfoExtra.dbc
 
MySQL
creature_template
creature
creature_model_info
creature_equip_template

I write in the moment a tool doing it. It is integrated in the Maruum web Interface.

viewtopic.php?f=61&t=3220 (http://modcraft.io/viewtopic.php?f=61&t=3220" onclick="window.open(this.href);return false;)

Quote from: "Devwaza"

[...] equip it with weapons and gear, and then somehow make the character design become a "entry id"[...]

He talks about DBC work, which is not related to the SQL (editing wise).

Title: Re: [QUESTION] WMV character to mysql database?
Post by: Steff on January 09, 2013, 12:58:26 pm

Yes and I simple gave overview what he msut do all to get it work :) Even if he will use an DB editor for MySQL ;)

Title: Re: [QUESTION] WMV character to mysql database?
Post by: Devwaza on January 09, 2013, 01:58:58 pm

Quote from: "Steff"

Yes and I simple gave overview what he msut do all to get it work :) Even if he will use an DB editor for MySQL ;)

Well, actually I did not even know that there was any dbc editing necessary. For a long time ago when i used a repack called "ac web ultimate repack", I only used a db editor. So, i guess creating a character and exporting it in some format or something like that cannot result in a custom npc with any tool there is yet?

Would be one hell of a way to create npcs though, like designing the npc in modelviewer -> export to object file, load in a tool, and fill in the npc properties -> done  ;)

Title: Re: [QUESTION] WMV character to mysql database?
Post by: Steff on January 10, 2013, 12:23:20 am

Yes it is.