[Release] EnclaveDB 2.0 (The right one)

[locksoft]

UPDATE:

I restarded from scratch. I followed this guide:

Next Chapter Community

and installed:
- Appserv
- Navicat
- Ascent 4.0 (it's a noob repack, just need it for the emulator that I don't know to get elsewhere)
- NCDB files from Revision 31: /

I installed Appserv.

then I created two databases:
- wow_ncdb
- wow_world

I put the website files in apache starting dir and correctly configured the httpd.conf (and made it target wow_world db).

I restored the tables in wow_ncdb from the dump file in ncdb svn directory.

I started localhost website and started the conversion of tables, everything was ok.

And now I'm stuck because the guide suggest to use ArcEmu and I've Ascent. Now, I really don't know the difference between these two emulators and I need an advice. if you say ArcEmu is better I'll get it and continue following the guide (but don't know how to compile sources). if not I need some more instruction since I've not the "character" tables in my two db.

thanks again, getting close to the end of tunnel, I hope. :]


update 2 bis:

ok, I think I understood a bit more. I took your logon.sql and I created a new db called wow_login.

then changed ascent-logonserver.conf to

<LogonDatabase Hostname = "localhost"
               Username = "root"
               Password = "ascent"
               Name     = "wow_login"
               Port     = "3306"
               Type     = "1">

and ascent-world.conf to:

<WorldDatabase Hostname = "localhost"
               Username = "root"
               Password = "ascent"
               Name = "wow_world"
               Port = "3306"
               Type = "1">

<CharacterDatabase
               Hostname = "localhost"
               Username = "root"
               Password = "ascent"
               Name = "wow_login"
               Port = "3306"
               Type = "1">

then I started both ascent-logonserver.exe and ascent-world.exe and they seem to work without issues. I'm using the Ascent 4.0 from this post. I don't know if it's Arcemu or another emu, I tried to compile the sources of Arcemu.org but got tons of errors so I gave up.

of course I've not wow client here at office but, not having errors from Ascent, do you think i'm doing correctly? so having all account data on a different db it means I can easily update world in case there will be new databases. or at least it's what I hope, am I doing all correctly?

[locksoft]

ok, all up and working. with ArcEmu because Ascent can't work with the different logon db structure.

trainers and formula work but I've some issues with icons.

I .additem-ed a "Gigantique Bag", the new 22 slot bag (ID 38082). while is "dropping in my inventory" I see the correct icon but once there I only see a question mark. if I put it in a bag slot it becomes invisible. I tried to create or download some bags form wow-vendetta and result is still the same, DisplayID is correct but icon doesn't show.

Then I added this weapon (that's the replica of summer boss, that's not in db) and I see it's icon only when I equip it.

minor issues but I'm just wondering if it's an emu (version 369) or a db problem. so far I only tried Zaeoir's db and not original ncdb so I can't say.

oh, last thing, while I've the LUA script files in the correct directory I noticed that bosses aren't scripted. I tried Prince Malchezaar and some SW bosses and they only melee. am I missing any addon?

thanks again.

[Zaeoir]

I .additem-ed a "Gigantique Bag", the new 22 slot bag (ID 38082). while is "dropping in my inventory" I see the correct icon but once there I only see a question mark. if I put it in a bag slot it becomes invisible. I tried to create or download some bags form wow-vendetta and result is still the same, DisplayID is correct but icon doesn't show.
.

Its bc its a 2.4.3 item. So you dont have the display id yet.

[locksoft]

Its bc its a 2.4.3 item. So you dont have the display id yet.

yes, it's what I was thinking but while you see the small animation of icon dropping in your inventory when you .additem you can see the correct icon. but maybe it's now well addressed by 2.4.2. :]