Pathway Of The Damned¶ ↑

Changelog V1, Release¶ ↑

: Last updated/tested with ArcEmu mysql update: 2012-01-31_02-35_killing_spree

A rough detail of the work that has gone into this database. Pathway returns as a database only, previously it had a patched ArcEmu with compiler optimizations enabled and two patches, as well as a custom client.

The custom client is now Marforius-Client(found on github, complete), now that ArcEmu has switched to CMake (some of) the compiler optimizations are now standard on release. The patches are no longer applied, and a custom ArcEmu is no longer provided. (You can still find the maintenance update on the ArcEmu forums, however.)

General history (Pre v1):¶ ↑

NCDB 102, taken as base.
NCDB updated with TOM_RUS cache parser (And a collection of tools at the time that were handy, most notably a wowhead parser for items and creature/object names)
Various scripts were implemented, around the same time as LuaHypArc was committed.
UDB data was taken, eventually overwritten around the same time I rebased PotD on TDB.
Pathway (the project) was formed after cleaning the mess of a database I made with a collection of scripts made for deleting nonexistent data or creatures/objects without proto entries. (Now included on the forums in the maintenance update patch)
Imported massive amounts of data from retail caches(some 100,000+ entries), using DPDB’s(Dirt Poor DataBase) team’s caches, my own playing and questing, and various contributions from helpful members on ArcEmu’s IRC.
Added more scripts to Pathway, notably in boredom I added various controller (gossip) NPCs for weather.
Continued to import caches from retail
Artox rewrote cache parser for speed, and more flexibility in another language(Java).
Added a patched version of ArcEmu, a custom client, and a import/export batch tool.
Imported data into Pathway from TDB (again), notably quests that were being parsed incorrectly were fixed, as were legendary items that were incorrectly scaling.
Lua scripts were rewritten after talking to Paroxysm. Since then they have not been changed.
Pathway was then closed after a long period of inactivity.
Pathway returns in 2012 as what it is now on Github.

The next work when I have time to go into this database is parsing old wowhead archives for gossips, as parsers previously didn’t supply the linkup data and many gossips are sitting in that table without being applied to NPCs.

New updates will be listed here, when they happen

To get the latest version of Pathway of the Damned ¶ ↑

Compile ArcEmu as normal
Import the latest character/login structures
Import the file in the winrar archive “world-database-export” to your world database
Update the file if need be after reading this file, determining the last time PotD was updated by looking at the header of this file.
Move the /scripts/ folder to your ArcEmu ROOT folder.
After correctly being updated, if need be - You would then be ready to run ArcEmu with PotD.

: I recommend HeidiSQL as your SQL GUI tool of choice. It’s much faster then Navicat and free, now that Navicat doesn’t offer a lite (free) version. Plus HeidiSQL can actually handle large files, and standard SQL comment instructions that Navicat CANNOT handle. As its what I export the database with, I do not recommend using Navicat with Pathway what-so-ever!

Updating PotD¶ ↑

Obtain the latest “world-database-export” from this github repository and decompress this file.
Select your WORLD database in HeidiSQL, and execute. Any customizations will have to be redone to Pathway if you made any.
Clear your MySql cache, and client cache (if any major changes were made), or make sure that ArcEmu was shutdown with the shutdown command and not “ctrl+c”.
You are now up to date. As always make sure that you are keeping ArcEmu up to date as well, as it’s most likely the last commit that changed “world-database-export” also updated it to latest ArcEmu database structures.

Information¶ ↑

Original Project Post: arcemu.org/forums/index.php?showtopic=22205

Irc: irc.freenode.net #arcemu (or talk to Marforius)

Misc¶ ↑

I will continue to compress the world export because otherwise it is massive, and I don’t like bloating up my repository with an otherwise 190~MB file that could be compressed to less then 20MBs.

Please report any bugs, missing data, or otherwise on the Github tracker at github.com/Marforius/Pathway-of-the-Damned/issues.

refuge89 / pathway-of-the-damned Goto Github PK