🇬🇧 English | 🇪🇸 Spanish
AoWoW is a Database tool for World of Warcraft v3.3.5 (build 12340)
It is based upon the other famous Database tool for WoW, featuring the red smiling rocket.
While the first releases can be found as early as 2008, today it is impossible to say who created this project.
This is a complete rewrite of the serverside php code and update to the clientside javascripts from 2008 to something 2013ish.
I myself take no credit for the clientside scripting, design and layout that these php-scripts cater to.
Also, this project is not meant to be used for commercial puposes of any kind!
Audio processing may require lame or vorbis-tools (which may require libvorbis (which may require libogg))
On Linux (debian-based) you can install the requirements with the following command:
sudo apt install php-gd php-xml php-mbstring -y
apt install php-gd php-xml php-mbstring -y
Calculate.Creature.Zone.Area.Data = 1 Calculate.Gameoject.Zone.Area.Data = 1
git clone https://github.com/azerothcore/aowow.git aowow
git clone https://github.com/Sarjuuk/MPQExtractor.git MPQExtractor
Ensure that the account you are going to use has full access on the database AoWoW is going to occupy and ideally only read access on the world database you are going to reference.
Import setup/db_structure.sql
into the AoWoW database mysql -p {your-db-here} < setup/db_structure.sql
Import to your AzerothCore database the table spell_learn_spell
, import it from www-aowow/setup/spell_learn_spell.sql
.
See to it, that the web server is able to write the following directories and their children. If they are missing, the setup will create them with appropriate permissions
cache/
config/
static/download/
static/widgets/
static/js/
static/uploads/
static/images/wow/
datasets/
Extract the following directories from the client archives into setup/mpqdata/
, while maintaining patch order (base mpq -> patch-mpq: 1 -> 9 -> A -> Z). The required paths are scattered across the archives. Overwrite older files if asked to.
.. for every locale you are going to use:
\
/DBFilesClient/ \ /Interface/WorldMap/ \ /Interface/FrameXML/GlobalStrings.lua
.. once is enough (still apply the localeCode though):
\
/Interface/TalentFrame/ \ /Interface/Glues/Credits/ \ /Interface/Icons/ \ /Interface/Spellbook/ \ /Interface/PaperDoll/ \ /Interface/GLUES/CHARACTERCREATE/ \ /Interface/Pictures \ /Interface/PvPRankBadges \ /Interface/FlavorImages \ /Interface/Calendar/Holidays/ \ /Sound/
.. optionaly (not used in AoWoW):
\
/Interface/GLUES/LOADINGSCREENS/
PAY ATTENTION: you have to create a directory in setup/mpqdata/
like enus
(LOWERCASE) containing the data listed above.
For example, you can just copy Interface
and DBFilesClient
directory into setup/mpqdata/enus/
and move Sound
into setup/mpqdata/enus
.
You can use MPQExtractor to extract the data, once you installed it succesfully you can use this bash script to make extract the data in the right order.
WAV-files need to be reencoded as ogg/vorbis
and some MP3s may identify themselves as application/octet-stream
instead of audio/mpeg
.
Note: it will take a long time.
php aowow --setup
.
This should guide you through with minimal input required from your end, but will take some time though, especially compiling the zone-images. Use it to familiarize yourself with the other functions this setup has. Yes, I'm dead serious: Go read the code! It will help you understand how to configure AoWoW and keep it in sync with your world database.
When you've created your admin account you are done.
Q: The Page appears white, without any styles.
A: The static content is not being displayed. You are either using SSL and AoWoW is unable to detect it or STATIC_HOST is not defined poperly. Either way this can be fixed via config php aowow --siteconfig
Probably you need to modify [10] and [15].
For example, if your project is in htdocs/aowow/
(or /var/www/html/aowow
), hence you visit it with http://localhost/aowow/
, you should put:
[10] localhost/aowow
[15] localhost/aowow/static
Q: Fatal error: Can't inherit abstract function \
Q: Some generated images appear distorted or have alpha-channel issues.
Q: How can i get the modelviewer to work?
Q: I'm getting random javascript errors!
Q: Some search results within the profiler act rather strange. How does it work?
prQueue
is run in the background as not to overwhelm the characters database with requests. This also means, some more exotic search queries can't be run agains the characters database and have to use the incomplete/outdated cached profiles of AoWoW.Q: Screenshot upload fails, because the file size is too large and/or the subdirectories are visible from the web!
Q: An Item, Quest or NPC i added or edited can't be searched. Why?
Q: Failed to connect to database.
aowow/config/config.php
, if everything is correct, check if your password has "#" character contained in the password and replace it with the encoded (URL) character correspondent "%23", do the same for special characters if you still get this error.Q: I cannot see the Quick Facts, Console error "Markup.js" not found
tools/filegen/templates/Markup.js.in
into static/js/Markup.js
for permissions reason, as this also other js files can miss, check the permissions issue or copy them manually.Said website with the red smiling rocket, for providing this beautifull website!
Please do not regard this project as blatant rip-off, rather as "We do really liked your presentation, but since time and content progresses, you are sadly no longer supplying the data we need".