ArcEmu: Mangos To Arcemu Database Converter - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

Mangos To Arcemu Database Converter Convert UDB, YTDB and all other MaNGOS databases to ArcEmu!

#21 User is offline   Doggie52 

  • arcemu feedback police
  • PipPipPip
  • Group: Members
  • Posts: 297
  • Joined: 09-October 08
  • Gender:Male
  • Location:Sweden
  • Interests:web designing, web programming, wow databases, game- and webservers
  • Server OS:Windows

Posted 30 December 2009 - 05:15 AM

Is there anything you need help with in order to complete this? Where are you right now, have you stalled on anything in particular?
0

#22 User is offline   this_is_junk 

  • Retired Retard
  • Group: Contributor
  • Posts: 2,432
  • Joined: 08-October 08
  • Gender:Male
  • Location:Washington State

Posted 30 December 2009 - 11:49 AM

It needs a smart filter to prevent Event (holiday) spawns from being included.
GAH!!! >_< ...can't...just...stop...working...
0

#23 User is offline   Doggie52 

  • arcemu feedback police
  • PipPipPip
  • Group: Members
  • Posts: 297
  • Joined: 09-October 08
  • Gender:Male
  • Location:Sweden
  • Interests:web designing, web programming, wow databases, game- and webservers
  • Server OS:Windows

Posted 01 January 2010 - 01:03 PM

View Postthis_is_junk, on 30 December 2009 - 11:49 AM, said:

It needs a smart filter to prevent Event (holiday) spawns from being included.

I think those spawns are fairly nice, why not just let UDB/YTDB manage that for us (i.e. they remove them, commit a rev, we get the rev and re-convert)?

I tested the converter with YTDB_0.10.7_R520_MaNGOS_R8828_SD2_R1502_ACID_R301_RuDB_R34, here are a few observations:

  • NPC displayID's are messed up - none show up (instead, they are white, small, checkered boxes)
  • Loads of Undead NPC's spawn in Stormwind, whether that is the spawns being incorrect or perhaps NPC's IDs being incorrect I do not know
  • GameObjects spawns and models are correct


If there is anything in particular you want to test/try out, please don't hesitate to contact me!
0

#24 User is offline   this_is_junk 

  • Retired Retard
  • Group: Contributor
  • Posts: 2,432
  • Joined: 08-October 08
  • Gender:Male
  • Location:Washington State

Posted 01 January 2010 - 01:07 PM

View PostDoggie52, on 01 January 2010 - 01:03 PM, said:

I think those spawns are fairly nice, why not just let UDB/YTDB manage that for us (i.e. they remove them, commit a rev, we get the rev and re-convert)?


If that were the case, I wouldn't care one bit. :P But MaNGOS handles events by way of the game_event* tables. ALL the spawns are in the creature/gameobject tables and using the event tables the server decides which to not show.

Though, I'd advocate ArcEmu's conversion to a functionally similar system. (not c+p, original code to accomplish the same task)

This post has been edited by this_is_junk: 01 January 2010 - 01:10 PM

GAH!!! >_< ...can't...just...stop...working...
0

#25 User is offline   Doggie52 

  • arcemu feedback police
  • PipPipPip
  • Group: Members
  • Posts: 297
  • Joined: 09-October 08
  • Gender:Male
  • Location:Sweden
  • Interests:web designing, web programming, wow databases, game- and webservers
  • Server OS:Windows

Posted 01 January 2010 - 07:48 PM

View Postthis_is_junk, on 01 January 2010 - 01:07 PM, said:

If that were the case, I wouldn't care one bit. :lol: But MaNGOS handles events by way of the game_event* tables. ALL the spawns are in the creature/gameobject tables and using the event tables the server decides which to not show.

Though, I'd advocate ArcEmu's conversion to a functionally similar system. (not c+p, original code to accomplish the same task)

That is very very cool, I must say! Before we start working on such a system we would need to actually have all the NPC's, spawns and GO's somewhere - as it looks right now the /src/scripts/Sql/Events aren't really up-to-date unfortunately!
0

#26 User is offline   Doggie52 

  • arcemu feedback police
  • PipPipPip
  • Group: Members
  • Posts: 297
  • Joined: 09-October 08
  • Gender:Male
  • Location:Sweden
  • Interests:web designing, web programming, wow databases, game- and webservers
  • Server OS:Windows

Posted 02 January 2010 - 04:56 AM

I tracked down the error with the NPC's displayID's. It's in the creature_spawns table, where all values in the displayid column are 0.
In MaNGOS creature table, all values in the modelid column are also 0, which is where the converter gets its values from. In MaNGOS creature_template table, all values in the modelid_A column correspond to those of ArcEmu - I've modified the code and I am attempting to query that table instead. I will post back with updates.
0

#27 User is offline   Helium 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 287
  • Joined: 28-June 09
  • Gender:Male
  • Location:Israel
  • Interests:Invest new things. Develop & improve IFDB. Help Arcemu community. * Space And Technology.& ofc GIRLS.

Posted 02 January 2010 - 08:18 AM

View Postthis_is_junk, on 30 December 2009 - 11:49 AM, said:

It needs a smart filter to prevent Event (holiday) spawns from being included.


Smart Filter:

DELETE FROM `gameobject_spawns` WHERE `entry` IN (187235, 187567, 187194, 181358, 180796, 180798, 178429, 181016, 178437, 180770, 178430, 178433, 178432, 178667, 178805);


This Dose not include all the holdiay objects only festival I think.
But it is easy to track and get the ID of gameobjects in game and add it to this query.
And you are done :blink:
0

#28 User is offline   Doggie52 

  • arcemu feedback police
  • PipPipPip
  • Group: Members
  • Posts: 297
  • Joined: 09-October 08
  • Gender:Male
  • Location:Sweden
  • Interests:web designing, web programming, wow databases, game- and webservers
  • Server OS:Windows

Posted 02 January 2010 - 09:42 AM

Adding the converted creature_spawns did not work. Some NPC's were spawned wrong, some went walking in the air, many of them were incorrect - it all looked like a mess. However, the Undead spawns in Stormwind were gone!
0

#29 User is offline   this_is_junk 

  • Retired Retard
  • Group: Contributor
  • Posts: 2,432
  • Joined: 08-October 08
  • Gender:Male
  • Location:Washington State

Posted 02 January 2010 - 09:14 PM

View PostHelium, on 02 January 2010 - 08:18 AM, said:

Smart Filter:

DELETE FROM `gameobject_spawns` WHERE `entry` IN (187235, 187567, 187194, 181358, 180796, 180798, 178429, 181016, 178437, 180770, 178430, 178433, 178432, 178667, 178805);


This Dose not include all the holdiay objects only festival I think.
But it is easy to track and get the ID of gameobjects in game and add it to this query.
And you are done :P


Unfortunately, hard coding the numbers means that that is not a viable option.
GAH!!! >_< ...can't...just...stop...working...
0

#30 User is offline   thebillkidy 

  • Newbie
  • Group: Members
  • Posts: 0
  • Joined: 16-April 09
  • Gender:Male

Posted 03 January 2010 - 06:08 AM

well i love this one of the best converters i saw still some work to do but it's great already
0

#31 User is offline   suchASunthan 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 246
  • Joined: 29-November 08
  • Gender:Male
  • Location:Frankfurt
  • Interests:Vcpp, vb, sql, all programmlanguages
    more informations >:-]

Posted 06 January 2010 - 06:50 AM

mhm i think the converter has a poor problems with my apache. i cant execute a poor functions.
This is the error massage:
Fatal error: Maximum execution time of 60 seconds exceeded in ...\v0.3\loot_creatures.php on line 16

this is only one example, ive got more errors before. i edit the php.ini and took the times higher but ive got still this errors. if you dont have the safe mode on, you can edit the times with this function: set_time_limit()

how much time take the whole querry?

@ the rest of all i can say its a very nice work.

LG Sunthan
Koninzidenz begründet keine Korrelation und ist kein Beweis für Kausalität!

coincidence causes no correlation and in´t a argument for causality!

Posted Image
Posted Image
0

#32 User is offline   Doggie52 

  • arcemu feedback police
  • PipPipPip
  • Group: Members
  • Posts: 297
  • Joined: 09-October 08
  • Gender:Male
  • Location:Sweden
  • Interests:web designing, web programming, wow databases, game- and webservers
  • Server OS:Windows

Posted 15 January 2010 - 07:10 PM

The whole query can take as much as 20 minutes to complete, based on what hardware you have.

I solved the execution limit-problem by simply adding, as you mentioned, set_time_limit() to the loop, essentially resetting the time-limit on every turn of the loop - meaning I could run it for virtually as long as I wanted to.
0

#33 User is offline   Artox 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 142
  • Joined: 01-November 08

Posted 06 February 2010 - 03:57 AM

so v0.4 is released bringing working vendors, auctionhouse, trainer spells and some bug fixes.
Posted Image
0

#34 User is offline   tanyarose 

  • Member
  • Pip
  • Group: Members
  • Posts: 52
  • Joined: 19-June 08

Posted 18 March 2010 - 09:25 PM

Good work! :)
0

#35 User is offline   Dindresto 

  • Newbie
  • Group: Members
  • Posts: 8
  • Joined: 07-July 08

Posted 16 May 2010 - 06:10 AM

Does it work with actually UDB releases?
0

#36 User is offline   godstarxxx 

  • Member
  • Pip
  • Group: Members
  • Posts: 23
  • Joined: 22-November 09
  • Gender:Male

Posted 17 May 2010 - 01:30 AM

Is this working with the latest Udb ?


Greetz godstarxxx
0

#37 User is offline   Artox 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 142
  • Joined: 01-November 08

Posted 17 May 2010 - 10:56 AM

View Postgodstarxxx, on 17 May 2010 - 01:30 AM, said:

Is this working with the latest Udb ?


Greetz godstarxxx


It is working with any database that uses mangos structure r9171. I lost track of UDB so I can't tell if they updated since
Posted Image
0

#38 User is offline   pedregon 

  • Member
  • Pip
  • Group: Members
  • Posts: 15
  • Joined: 14-June 08
  • Gender:Male
  • Location:ArcEmu.Org

Posted 17 May 2010 - 09:45 PM

Good Job Artox, I can see you worked really hard on it :blink:
Posted Image
0

#39 User is offline   willemboo 

  • Member
  • Pip
  • Group: Members
  • Posts: 16
  • Joined: 20-June 10
  • Gender:Male

Posted 20 June 2010 - 01:09 PM

View PostArtox, on 17 May 2010 - 10:56 AM, said:

It is working with any database that uses mangos structure r9171. I lost track of UDB so I can't tell if they updated since


Here you go : http://udbforums.kicks-ass.net/

;)
0

#40 User is offline   Artox 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 142
  • Joined: 01-November 08

Posted 24 July 2010 - 02:38 PM

Finally here it is! Version 1.0 arrived. Get it here and Enjoy!

Thank you Doggie52 for packaging this.
Posted Image
0

Share this topic:


  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users