Ascent / ArcEmu Compiles + Database problem 2.4.3

[gillisrofl]

Hello MMOwned! :wave:

Parts of this thread:

- First words
- Story and what I have done
- Detailed Information and Main Problem
- The Request / Question
- Etc Questions

***** First words *****

First of all I want to say that this site has been of great help for me as I have worked with my server. If you can answer my question and I will finally be able to finish my server, I will definitely contribute to MMOwned! Probably not by donations since I am poor atm, but surely make a 2.4.3 guide for those who went through the same trouble as me.

I don't know if I can +Rep yet, but if I can, I will do for the one who can help me out on this one!

I hope I can get some help, even though this is my very first post on MMOwned! And I hope I don't appear as a lecher to you!

***** Story and what I have done. *****

Alright so back about a month ago I decided to make a 2.4.3 ArcEmu server.

First off I started normally, looked up a compile guide and started. However, little did I know about revisions and versions, and I soon found myself in trouble. So I thought: "Why do I even need to do this?", and searched up a repack instead. It went well and I started building up the server. However, it would take three weeks until I understood the problem with repacks: The missing core.

So I set up for a big search journey on google, learned about revision, other emulators, compiling and etc. Finally I managed to compile a ArcEmu core. After going through even more trouble I managed to set it up. However, as I tried to connect it with my old database (which name is unknown to me), it failed due to missing columns and other bugs.
I thought it was natural so I looked up other databases and came across WhyDB, NCDB, and Milestone. And this is where my current problem lies. All the versions I have tried for 2.4.3 gives me major errors in the world start-up and crashes and so on. I decided to compile a ascent and try them out, but with similar effect to ArcEmu. What is wrong here? The databases? Or the Compiles?

Anyhow I have searched for at least three days now with no result. I have experimented with different versions but with no result.

***** Detailed Information and Main Problem *****

I've tried three different ArcEmu cores:

https://arcemu.svn.sourceforge.net/svnroot/arcemu/trunk/

- Revision 1545 (Currently deleted)
- Revision 1562
- Revision 1568 (Though this one seemed to be WOTLK so I removed it directly)

And Ascent from this SVN:

svn://svn.ascentemulator.net/ascent

Since there was no Revision here, I compiled what I found inside the Ascent compile folder at
DownloadMap\tags\2.4.3\
However, this map did not have any SQL structures for databases which is usually found at
DownloadMap\tags\2.4.3\sql
However, the ArcEmu logon / character structure I used in the earlier repack seems to work just fine with Ascent.


What I did with all these compiles was to make my own repack of it, by copying the bin\release\ files and folders and the configs at scripts. So this is currently what my own Repacks looks like inside:

ArcEmu Rev 1562


Ascent 2.4.3



As you can see in ArcEmu I took in some earlier stuff in the Repack I had before like "Sun++ SQLS", "Updates" where I found the structures, "UniversalTeleNPC", "libmySQL.dll" and "libeay32.dll". The "collision.dll" files are the ones from the compiled cores, and not copies.


The world Databases I have tried are the following:

- WhyDB (SVN Revision:" http://svn.xp-dev.com/svn/whydb-users/2.4.3/ ")
- WhyDB Revision 270 (Found here SVN: " WhyDB - Revision 270: / ")
- Milestone 0.3.0 (Found at: Descargar Utimas versiones ABD, NCDB, Arcemu, Ascent, Whydb, etc [Para Server de WoW] Gratis, Gratis Juegos, Juegos descarga directa, Juegos Gratis, Noticias)
- Milestone 0.2.3 (Found at same web-site)
- NCDB Revision 33
- My old 2.4.3 Database (That worked in his repack)


As I said before, all of these gives me the same results. Major errors like missing column in creature_spawn table or have a wrong column, invaild format in trainer table (major), other errors that it can't load due to errors in tables (not major though).
As for ArcEmu-world, it always crashes, and for Ascent the server starts up. But this is ONLY if I remove my "scripts" folder where I have my previous custom LUA scripts. Otherwise it crashes on that. However, the major errors are still there.


***** The Request / Question *****

Alright so to sum this up, I want someone here to help me find the correct ArcEmu (or Ascent) version for 2.4.3 to compile (if I already haven't), and the correct and working Database(s).
However, if you spot something I did wrong as I explained in this thread, I want you to tell me how I can correct it and make it work.
Either how, what I want to come to is a startup without errors and working server.
Remember that what I want most is to resolve the problem with ArcEmu and not Ascent since it's an ArcEmu server that I want. However, help with Ascent is welcome!
If there is some information I didn't write that you need please ask me!

Also, please try to put detail into your answer so I can understand. For example revision number, path to this and that, versions, name or download links or etc. I think you get it ^^.

***** Etc Questions *****

- How do I get information out of my Dump Crash files?
- Why does ascent-world crash with custom LUA scripts?


*************

~ Gillisrofl

[W@WAdict]

Well, Ascent was a good server in it's day, but had it's share of bugs, it is old now, and some of the newer versions like ArcEmu (a derivative of Ascent) had fixed some of these bugs.

I have not tried to play with a 2.4.3 server in a while, but if I remember WhyDB was a great database for 2.4.3

I see you tried revision 1562 of ArcEmu, what is the problem with it exactly?

SourceForge.net Repository - [arcemu] Index of /tags/2_4_3

If I can be of help, you can contact me on MSN wow_adict at hotmail.

Let me know if I can help in any way.

[gillisrofl]

Yes thanks W@WAdict. I will add you to tomorrow and ask you for help

The problem exactly is that, the ArcEmu (Rev 1562) that I downloaded and compiled from my SVN I posted above, won't work together with the Databases I have been trying. As I described above:

All the versions I have tried for 2.4.3 gives me major errors in the world start-up and crashes and so on. I decided to compile a ascent and try them out, but with similar effect to ArcEmu. What is wrong here? The databases? Or the Compiles?

As I said before, all of these gives me the same results. Major errors like missing column in creature_spawn table or have a wrong column, invaild format in trainer table (major), other errors that it can't load due to errors in tables (not major though).
As for ArcEmu-world, it always crashes, and for Ascent the server starts up. But this is ONLY if I remove my "scripts" folder where I have my previous custom LUA scripts. Otherwise it crashes on that. However, the major errors are still there.

Anyhow, your SVN address is different from the one I used and compiled, so I will put that on download and have it compiled over the night and PM you in msn tomorrow.

[gillisrofl]

Hey wow@addict I still haven't seen you online in msn... would be great if we could set up a time for it. As for me, I am free the whole day today!

On the other hand, would really appreciate help from other people with this one!

*Side note*
Got a problem with wow@addict's revision he gave me for 2.4.3. Within the win folder, that VC90 solution is unrecognized version, and won't open when I click it. I tried opening it manually with visual studio exe, and it worked. However, I get 7 failed when I build the solution. I will try out some more stuff and then edit this post with more info on this problem... but I would be more happy if someone could find a working Database for me!