[Artox]

 __  __       _   _  ____  ___  ____    _        
|  \/  | __ _| \ | |/ ___|/ _ \/ ___|  | |_ ___  
| |\/| |/ _` |  \| | |  _| | | \___ \  | __/ _ \ 
| |  | | (_| | |\  | |_| | |_| |___) | | || (_) |
|_|  |_|\__,_|_| \_|\____|\___/|____/   \__\___/ 
                                                 
    _             _____                 
   / \   _ __ ___| ____|_ __ ___  _   _ 
  / _ \ | '__/ __|  _| | '_ ` _ \| | | |
 / ___ \| | | (__| |___| | | | | | |_| |
/_/   \_\_|  \___|_____|_| |_| |_|\__,_|

==================================
MaNGOS to ArcEmu Database Converter
release v1.0

by Artox
==================================

==================================
General information
==================================

The MaNGOS to ArcEmu Converter is a PHP tool/script that will convert an instance of any MaNGOS database (such as UDB, YTDB, etc.)
to the ArcEmu database structure.
In essence, using this tool you can ensure you're running the latest and greatest database around with the most complete sets
of items, NPCs, spawns and gameobjects available for WoW private servers.

==================================
Instructions for usage
==================================

All necessary instructions are inside the included README.txt !

download

[this_is_junk]

ArcEmu reads database fields by index and MaNGOS uses a different order, did you adjust the field positions?

[Artox]

this_is_junk, on 22 November 2009 - 01:38 PM, said:

ArcEmu reads database fields by index and MaNGOS uses a different order, did you adjust the field positions?

I took arcemu structure files to create db and then I just used insert queries for the data so I dont think this problem would appear

[this_is_junk]

Excellent.

The previous MaNGOS to ArcEmu project completely forgot about that and just went about renaming the columns.

[kreegoth]

So this converts UDB Db to a Arcemu useable one?
How complete it Udb? i mean do the majority of quests work? Are all Npc values and such correct, most Db's still have alot of errors for Northrend is this one any different?

[this_is_junk]

Last I checked UDB was 3.1.3. Their forums have gone down, so...

[Artox]

kreegoth, on 24 November 2009 - 01:00 PM, said:

So this converts UDB Db to a Arcemu useable one?
How complete it Udb? i mean do the majority of quests work? Are all Npc values and such correct, most Db's still have alot of errors for Northrend is this one any different?

Kreegoth I haven't tested the quality of the resulting db yet so I have no idea about the answers to those questions but in case the conversion done by my converter is correct they should work just as on any server using udb

this_is_junk, on 24 November 2009 - 02:37 PM, said:

Last I checked UDB was 3.1.3. Their forums have gone down, so...

and this_is_junk: udbforums are now on http://udbforums.kicks-ass.net

[KFL]

Creature conversion is not proper now. When i find time i'll change it, same as gameobject converter.

[Alia Erenel]

We should really all try to push this project forward. Where do I sign ?

[Artox]

just post patches if you find a bug/error and are able to fix it. I should be happy to apply them

[kreegoth]

Im not familiar with Mangos emu or Udb for that matter.

But I modified the Creature converter to work for the Trinity DB i had downloaded ( 3.22 ).. I dont know if their the same if they arent same or even similar then sorry but figured id post incase it was helpful

It only requires being ran on the Trinity world DB and then running the last few Sqls that have to do with creatures names or Proto. I believe they are the ones that add Questitem columns to end of names and Summonguard to end of proto.

DROP TABLE IF EXISTS `creature_names`;

CREATE TABLE `creature_names` (
  `entry` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL,
  `subname` varchar(100) NOT NULL,
  `info_str` varchar(500) NOT NULL,
  `Flags1` int(10) unsigned default '0',
  `type` int(10) unsigned default '0',
  `family` int(10) unsigned default '0',
  `rank` int(10) unsigned default '0',
  `unk4` int(10) unsigned default '0',
  `spelldataid` int(10) unsigned default NULL,
  `male_displayid` int(30) NOT NULL,
  `female_displayid` int(30) NOT NULL,
  `male_displayid2` int(30) NOT NULL default '0',
  `female_displayid2` int(30) NOT NULL default '0',
  `unknown_float1` float NOT NULL default '1',
  `unknown_float2` float NOT NULL default '1',
  `flags_extra` int(4) unsigned default NULL,
  `leader` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

INSERT INTO creature_names
SELECT entry, name,  '', '', type_flags, type, family, rank, 0, PetSpellDataId, modelid1, modelid2,
modelid3, modelid4, unk16, unk17, flags_extra, racialleader FROM creature_template;

/* Subname */
UPDATE creature_names, creature_template
SET
creature_names.subname = creature_template.subname
WHERE
creature_names.entry = creature_template.entry AND creature_template.subname != '';

/* Info_str */
UPDATE creature_names, creature_template
SET
creature_names.info_str = creature_template.iconname
WHERE
creature_names.entry = creature_template.entry AND creature_template.iconname != '';

DROP TABLE IF EXISTS `creature_spawns`;

CREATE TABLE `creature_spawns` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `entry` int(30) NOT NULL,
  `map` int(30) NOT NULL,
  `position_x` float NOT NULL,
  `position_y` float NOT NULL,
  `position_z` float NOT NULL,
  `orientation` float NOT NULL,
  `movetype` int(30) NOT NULL default '0',
  `displayid` int(30) unsigned NOT NULL default '0',
  `faction` int(30) NOT NULL default '14',
  `flags` int(30) NOT NULL default '0',
  `class` int(30) NOT NULL default '0',
  `bytes1` int(30) NOT NULL default '0',
  `bytes2` int(30) NOT NULL default '0',
  `emote_state` int(30) NOT NULL default '0',
  `npc_respawn_link` int(30) NOT NULL default '0',
  `channel_spell` int(30) NOT NULL default '0',
  `channel_target_sqlid` int(30) NOT NULL default '0',
  `channel_target_sqlid_creature` int(30) NOT NULL default '0',
  `standstate` int(10) NOT NULL default '0',
  `mountdisplayid` int(10) unsigned NOT NULL default '0',
  `slot1item` int(10) unsigned NOT NULL default '0',
  `slot2item` int(10) unsigned NOT NULL default '0',
  `slot3item` int(10) unsigned NOT NULL default '0',
  `CanFly` smallint(3) NOT NULL default '0',
  `phase` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spawn System';

INSERT INTO `creature_spawns`
SELECT
guid, id, map, position_x, position_y, position_z, orientation, MovementType, modelid, 
0, 0, 0, 0, 0, 0, equipment_id, 0, 0, 0, 0, 0, 0, 0, 0, 0, phasemask 
FROM creature;

UPDATE creature_spawns, creature_template
SET
creature_spawns.npc_respawn_link = creature_template.equipment_id
WHERE
creature_spawns.entry = creature_template.entry AND creature_spawns.npc_respawn_link = 0;

UPDATE creature_spawns, creature_equip_template
SET
creature_spawns.slot1item = creature_equip_template.equipentry1,
creature_spawns.slot2item = creature_equip_template.equipentry2,
creature_spawns.slot3item = creature_equip_template.equipentry3
WHERE
creature_spawns.npc_respawn_link = creature_equip_template.entry;

UPDATE creature_spawns, creature_template_addon
SET
creature_spawns.mountdisplayid = creature_template_addon.mount,
creature_spawns.bytes1 = creature_template_addon.bytes1,
creature_spawns.bytes2 = creature_template_addon.bytes2,
creature_spawns.emote_state = creature_template_addon.emote
WHERE
creature_spawns.entry = creature_template_addon.entry;

UPDATE creature_spawns, creature_addon
SET
creature_spawns.mountdisplayid = creature_addon.mount,
creature_spawns.bytes1 = creature_addon.bytes1,
creature_spawns.bytes2 = creature_addon.bytes2
/*creature_spawns.emote_state = creature_addon.emote*/
WHERE
creature_spawns.id = creature_addon.guid;

UPDATE creature_spawns, creature_template
SET
creature_spawns.npc_respawn_link = 0
WHERE
creature_spawns.entry = creature_template.entry;

ALTER TABLE creature_spawns CHANGE npc_respawn_link gender int(30) NOT NULL default '0';

UPDATE creature_spawns, creature_template
SET
creature_spawns.class = creature_template.unit_class,
creature_spawns.faction = creature_template.faction_a,
creature_spawns.flags = creature_template.unit_flags
WHERE
creature_spawns.entry = creature_template.entry;

ALTER TABLE creature_spawns ADD temp int(30) unsigned NOT NULL default '0' AFTER phase;

UPDATE creature_spawns, creature_template
SET
creature_spawns.temp = creature_template.modelid1
WHERE
creature_spawns.entry = creature_template.entry AND creature_spawns.displayid = 0;

UPDATE creature_spawns, creature_model_info
SET
creature_spawns.displayid = creature_model_info.modelid
WHERE
creature_spawns.temp = creature_model_info.modelid AND creature_spawns.displayid = 0;

ALTER TABLE creature_spawns DROP COLUMN temp;

UPDATE creature_spawns, creature_model_info
SET
creature_spawns.gender = creature_model_info.gender
WHERE
creature_spawns.displayid = creature_model_info.modelid;

UPDATE creature_spawns 
SET
CanFly = 1 
WHERE 
entry IN (21648, 21657, 21801, 22274);

/* This query will remove spawned festival npcs. If you wish to left them remove it before executing that file */
DELETE FROM creature_spawns
WHERE
id IN (Select guid FROM game_event_creature);

/* Channel system - set it on your own. */
/* Bytes1 contains standstateinfo */

DROP TABLE IF EXISTS `creature_proto`;

CREATE TABLE `creature_proto` (
  `entry` int(30) unsigned NOT NULL default '0',
  `minlevel` int(30) unsigned NOT NULL,
  `maxlevel` int(30) unsigned NOT NULL,
  `faction` int(30) unsigned NOT NULL default '0',
  `minhealth` int(30) unsigned NOT NULL,
  `maxhealth` int(30) unsigned NOT NULL,
  `mana` int(30) unsigned NOT NULL default '0',
  `scale` float NOT NULL default '0',
  `npcflags` int(30) unsigned NOT NULL default '0',
  `attacktime` int(30) unsigned NOT NULL default '0',
  `attacktype` int(4) NOT NULL default '0',
  `mindamage` float NOT NULL default '0',
  `maxdamage` float NOT NULL default '0',
  `can_ranged` int(11) unsigned NOT NULL default '0',
  `rangedattacktime` int(30) unsigned NOT NULL default '0',
  `rangedmindamage` float unsigned NOT NULL default '0',
  `rangedmaxdamage` float unsigned NOT NULL default '0',
  `respawntime` int(30) unsigned NOT NULL default '0',
  `armor` int(30) unsigned NOT NULL default '0',
  `resistance1` int(30) unsigned NOT NULL default '0',
  `resistance2` int(30) unsigned NOT NULL default '0',
  `resistance3` int(30) unsigned NOT NULL default '0',
  `resistance4` int(30) unsigned NOT NULL default '0',
  `resistance5` int(30) unsigned NOT NULL default '0',
  `resistance6` int(30) unsigned NOT NULL default '0',
  `combat_reach` float NOT NULL default '0',
  `bounding_radius` float NOT NULL default '0',
  `auras` longtext NOT NULL,
  `boss` int(11) unsigned NOT NULL default '0',
  `money` int(30) NOT NULL default '0',
  `invisibility_type` int(30) unsigned NOT NULL,
  `death_state` int(30) unsigned NOT NULL,
  `walk_speed` float NOT NULL default '2.5',
  `run_speed` float NOT NULL default '7',
  `fly_speed` float NOT NULL default '14',
  `extra_a9_flags` int(30) NOT NULL default '0',
  `spell1` int(30) NOT NULL default '0',
  `spell2` int(30) NOT NULL default '0',
  `spell3` int(30) NOT NULL default '0',
  `spell4` int(30) NOT NULL default '0',
  `spell_flags` int(30) NOT NULL default '0',
  `modImmunities` int(30) unsigned NOT NULL default '0',
  `isTrainingDummy` int(10) unsigned NOT NULL default '0',
  `guardtype` int(10) UNSIGNED DEFAULT '0' NOT NULL,
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

INSERT INTO 
`creature_proto`
SELECT 
entry, minlevel, maxlevel, faction_a, minhealth, maxhealth, maxmana, scale, npcflag, 
baseattacktime, dmgschool, mindmg, maxdmg, 0, rangeattacktime, minrangedmg, maxrangedmg,
0, armor, resistance1, resistance2, resistance3, resistance4, resistance5,
resistance6, 0, 0, 0, rank, maxgold, 0, 0, (2.5*speed), (7*speed), (14*speed), 0, spell1, 
spell2, spell3, spell4, 0, mechanic_immune_mask, 0, 0 FROM creature_template;

UPDATE `creature_proto` 
SET 
boss = 0
WHERE boss != 3;

UPDATE `creature_proto` 
SET 
boss = 1
WHERE boss = 3;

UPDATE creature_proto, creature_template_addon
SET creature_proto.auras = creature_template_addon.auras
WHERE ( creature_proto.entry = creature_template_addon.entry ) AND creature_template_addon.auras != NULL;

UPDATE creature_proto, creature
SET 
creature_proto.respawntime = (creature.spawntimesecs*1000),
creature_proto.death_state = creature.deathstate
WHERE creature_proto.entry = creature.id;

UPDATE `creature_proto` 
SET 
`isTrainingDummy` = '1' 
WHERE `entry` IN 
('32542','32546','32666','31144','31146','32545','32541','32667','30527','32543','32547');

UPDATE `creature_proto` 
SET
`guardtype` = '1' 
WHERE entry IN 
(68,1423,1756,15858,15859,16864,20556,18948,18949,1642,3296,15852,15853,15854,18950,5624,18971,16432,16733,18815,3084,16221,17029,16222,727,5595,12996);

UPDATE `creature_proto` 
SET 
`guardtype` = '2' 
WHERE `entry` IN 
(3502,4624,15088,9460,11102,16378,15184,11822,11190,17855,18099,18101,18102,20484,20485,22494,23636,23721,26253,24994);

/* male_dispalyid is always bigger than 0 */
UPDATE creature_proto, creature_model_info, creature_names
SET 
creature_proto.combat_reach = creature_model_info.combat_reach, 
creature_proto.bounding_radius = creature_model_info.bounding_radius 
WHERE 
(creature_proto.entry = creature_names.entry) AND
(creature_names.male_displayid  = creature_model_info.modelid);

ALTER TABLE `creature_proto` ADD `modimmunitiesnew` INT( 30 ) UNSIGNED NOT NULL DEFAULT '0';

UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 1 WHERE modimmunities & 1 AND modimmunitiesnew != modimmunitiesnew | 1;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 2 WHERE modimmunities & 2 AND modimmunitiesnew != modimmunitiesnew | 2;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 4 WHERE modimmunities & 16 AND modimmunitiesnew != modimmunitiesnew | 4;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 256 WHERE modimmunities & 4 AND modimmunitiesnew != modimmunitiesnew | 256;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 1024 WHERE modimmunities & 32 AND modimmunitiesnew != modimmunitiesnew | 1024;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 8 WHERE modimmunities & 64 AND modimmunitiesnew != modimmunitiesnew | 8;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 128 WHERE modimmunities & 131072 AND modimmunitiesnew != modimmunitiesnew | 128;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 16 WHERE modimmunities & 128 AND modimmunitiesnew != modimmunitiesnew | 16;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 16 WHERE modimmunities & 256 AND modimmunitiesnew != modimmunitiesnew | 16;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 32 WHERE modimmunities & 512 AND modimmunitiesnew != modimmunitiesnew | 32;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 1024 WHERE modimmunities & 1024 AND modimmunitiesnew != modimmunitiesnew | 1024;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 32 WHERE modimmunities & 2048 AND modimmunitiesnew != modimmunitiesnew | 32;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 32 WHERE modimmunities & 4096 AND modimmunitiesnew != modimmunitiesnew | 32;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 32 WHERE modimmunities & 8192 AND modimmunitiesnew != modimmunitiesnew | 32;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 64 WHERE modimmunities & 65536 AND modimmunitiesnew != modimmunitiesnew | 64;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 32 WHERE modimmunities & 2097152 AND modimmunitiesnew != modimmunitiesnew | 32;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 4096 WHERE modimmunities & 33554432 AND modimmunitiesnew != modimmunitiesnew | 4096;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 32 WHERE modimmunities & 524288 AND modimmunitiesnew != modimmunitiesnew | 32;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 256 WHERE modimmunities & 536870912 AND modimmunitiesnew != modimmunitiesnew | 256;
UPDATE creature_proto SET modimmunitiesnew = modimmunitiesnew + 512 WHERE entry IN ( SELECT entry FROM Creature_template WHERE flags_extra & 256);

UPDATE creature_proto SET modimmunities = modimmunitiesnew;

ALTER TABLE `creature_proto` DROP `modimmunitiesnew`;

/* This requires creature_spawns table! */
UPDATE creature_proto, creature_spawns
SET 
creature_proto.can_ranged = 1
WHERE ( creature_proto.entry = creature_spawns.entry ) AND creature_spawns.slot3item != 0;

/* Missing data - extra_a9_flags, invisibility_type( whydb - always 0 ), spell_flags( whydb - always 0 )*/
/* Flying speed - should be 14? */

[Artox]

v0.2 is here bringing gameobjects, loots and basic playercreateinfo support!

[BLooD_LorD]

i think its better to use YTDB instead of UDB...

[this_is_junk]

MaNGOS manages event spawns in the world database.

Those creature and gameobject spawns are in the database normally, the event manager will enable or disable them as needed.

[Shauren]

no way. i once looked at YTDB, it had much crap in it

[BLooD_LorD]

Shauren, on 08 December 2009 - 01:43 PM, said:

no way. i once looked at YTDB, it had much crap in it

mmm, yea it has some crap

[this_is_junk]

Here, a WhyDb with UDB creature and gameobject spawns.

[BLooD_LorD]

this_is_junk, on 08 December 2009 - 02:06 PM, said:

Here, a WhyDb with UDB creature and gameobject spawns.

mmm, thx

[Artox]

So a new version has just arrived. v0.3. It brings you working trainers as well as fixed Quests and a few bugfixes by this_is_junk to creature_spawns.

[Navid]

Good work .