Mangos 4577, ScriptDev2 140 with PSDB and UDB work with WoW 2.1.3 to 2.2.3

Another WoW Mangos Release, and this time the WoW Client Supported is from WoW 2.1.3 into 2.2.3, but please note that currently the Mangos team still hasn’t fully support the 2.2.x client yet so you might see various opcodes related message being displayed on your mangosd window. Though it doesn’t really affect the gameplay itself, because i have tested this release with the newly released WoW 2.2.3 and … so far everything is working (unless it’s database related of course)

Anothing thing to note is, if you get various database related error message such as Item (Entry: xxxx) have wrong (not-existed) spell in spellid_1 … and so on when you run the mangosd.exe process, you can just safely ignore that message … because i also get that message but still the mangosd server process is still up and running and i can play just fine ;) … and no … mangosd process isn’t crash even when i talked to city guard in various place :P

As a lasy note, this new release contain two database from Project Silvermoon and Unified Database so you can switch between those two database freely and decided it by yourself which database is good for you

Screenshot taken using Silvermoon DB

WoW Silvermoon

Okay and here are the steps …

Requirements :

Update : Mangos 4602 has been released :)

Fresh Installation :

1. Extracting VMaps, Maps, DBC and configuring it (to make thing easier, i’ve created a separate guide for it)

2. Extract the self extracting 7–zip archive somewhere, or you can choose to extract it in current directory. And you’ll get ReaperMangos4577 Folder

3. Go inside the reaper-eazy-mangos directory and then run the reaper-x-mangos.bat , and you’ll be prompted with this screen :

Mysql directory

All you have to do is just write the full path into your MySQL bin directory (where mysql.exe can be found)

Note : The above step is important, if you don’t write the correct path you’ll get problem later

4. Now you just need to choose option number 1 (Install), and insert your mysql root password when prompted)

Installation Process

5. Now you need to configure which database you’re going to use in your Mangos Installation, in this release i have included Project Silvermoon Database and Unified Database. In below example, i choose the Unified database

Choosing WoW Database to install

As a side note, you don’t need to worry about choosing the correct database because you can always switch it later even if you already created your character with full set equipment. I choose to include 2 database so you can pick which one perform best for you

6. When you’ve finished the above process, now you just need to choose option number 4 to configure your mangos installation

Mangos Config Editing

If you follow my previous post about the Maps, VMaps and DBC extraction guide … you can just simply write C:\wow\data when prompted for your data directory. As for the rest (adjusting the rate) i think it’s self explained :)

7. Go to your WoW installation directory and open the realmlist.wtf file

and change the realmlist into using this one :

set realmlist 127.0.0.1

8. Run mangosd.exe and realmd.exe

9. Create new account as shown like below image for an example :

Creating Account in Mangos

10. Done :)

Switching Database or Upgrading :

1. Run reaper-x-mangos.bat and then choose to backup your character

2. Now choose the first option (Install / Upgrade) and continue with the step until you get back to the main menu

3. Choose the third option (Restore Backup) and you’re done with switching / upgrading database

To those who’s upgrading from my previous release

4. Choose the fourth option (Mangos Config Editor) to adjust your datadirectory, and if you already configured your server to be accessible from LAN then you’ll also need to choose the fifth option to adjust your realmlist again

Here’s a screenshot taken using Unified Database (and yep i almost die there even with Custom Weapon that gives all stats plus 1000 bonus) :P

WoW UDB

Related Link :

Official Project Related Link :

Of course the above already tested with WoW 2.2.3 enUS Client :)

Forgot to tell you this, but just in case you want to try my character that is usually shown on my screenshots, i also included my backup character for you to use :) … all you have to do right after installing the database, just choose the restore backup option

Note: If you choose to restore my character backup directly you’ll lose all your character data

The username to login using my test character is Reaper and password is reaper .. enjoy ;)

Comment?

Note: Comment may not appear right away.

234 comments on “Mangos 4577, ScriptDev2 140 with PSDB and UDB work with WoW 2.1.3 to 2.2.3

  1. RazMaTaz, my friend cant even do the pet initial quest with The unified DB. I’m going to try with the Silvermoon one now. The whole pet/minion deal has been kind of weird so far for me.

  2. Anyone else having trouble doing quests with the Unified DB? This is so confusing haha, the Silvermoon one is better than the last version (idk maybe there the same but im doing something defferent) but it still has OP mobs and same gold drops that are a wee bit high for some areas, but atleast more quests are working than the Unified for me.

  3. Hello reaper,

    I got some problems due the server install. if i want to execute batch file with navicat at realmd, it gives this error:

    [Err] 1074 – Column length too big for column ’email’ (max = 255); use BLOB or TEXT instead
    [Msg] Finished – Unsuccessfully

    Could you help me plz???

  4. @reaper-X
    yeah, mysqld-nt.exe is running with 41,000K memory usage, but im going on 10 hrs idling, i think theres still a problem :D

  5. # Meh

    You’ll need to run the batch file provided and choose to install the database first :)

    # Travis

    Which wow version you’re using ?

    # oatman

    If you’ve extracted the maps and dbc from 2.2.2 you don’t need to run it again :)

  6. Okay hate to bother again but I got it running except for the part where I can choose directory s it doesn’t give me a choice. and when I run wow it says it can’t validate my game version what should I do?

  7. Hey Guy, i found that when i put it on free-for-all the loot will come back. IDK if it will work for you but that solved my problem.

    AND i have noticed that some quests are un-doable in 0.7.5, they say i dont have the req, and quest items come w/o charges, etc.

  8. For people that get tele in Org….

    i use MySQL Administrator to edit my data base
    1. go to data base mangos
    2. look for areatrigger_template
    3. hit ctrl and F put in 4801
    follow what i have down below
    make sure it the same that i have below u want to change target NOT trigger

    SQL
    UPDATE areatrigger_template SET target_map=0,target_position_x=0,target_position_y=0,target_position_z=0,target_orientation=0 WHERE id=4801;

  9. kk i have 2 problems. One is that in SFK the guys are walking into walls and stuff. And 2 is that whenever im in a group there is no loot at all. What could the problem be

  10. Heya,i got the server running again,but i made it public and renamed now my mangosd says Error in item_template table,probably sql file format was up dated Could you help me again? :P

  11. # dookie

    Thanks a lot, Glad you like it :D

    # Magnus

    Your welcome, and actually that’s why i choose to include both database so you can decided it by yourself :)

    # Azrael

    Ah you can use the reaper-x-mangos.bat, and when prompted for the datadir, you just need to write it using forward or backslash (i have no problem using them both)

    # James

    That problem can be caused by several reasons :)

    1. You WoW game doesn’t have the expansion pack installed

    2. You didn’t extract the map properly (don’t forget that if you interruped the previous process before you’ll need to redo the whole extraction process by deleting the previously created map files)

    3. You didn’t set the correct datadir (use the reaper-x-mangos.bat)

    # Siggy

    If you’re sure the mysql server process is running (look in the task manager -> process list tab)

    then you just need to wait for the import process to complete, the import process might take 10 minutes – 2 hours or more depending on your computer specs (especially on RAM .. or free memory left) ;)

    # Travis

    You can just simply run the reaper-x-mangos.bat again but this time don’t forget to use the correct path of your mysql.exe :)

  12. Hi I tested the Unified Database 0.7.5 , im running 2,1,3 wow version, and just let me say wow! This has soo much better IMO than the previous silvermoon version i got from 4535. Mobs are no more overpowered, my lock can get soul shards and imp no has working life regen, monster gold drops are inconsistent and not crazy high. I will have to test the silvermoon DB later but first i have some more things to test with the 0.7.5 version.
    Thanks Reaper! once again, you have made my day a little brighter.

  13. Using configuration file mangosd.conf.
    MaNGOS daemon /Reaper-X R4577 0.8-SVN http://www.reaper-x.com (Win32)
    to stop.

    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM http://www.mangosproject.org
    MMMMMM

    Reaper-X R4577 SD2-140 http://www.reaper-x.com

    World Database: 127.0.0.1;3306;mangos;mangos;mangos
    Login Database: 127.0.0.1;3306;mangos;mangos;realmd
    Realm running as realm ID 1
    Using UDB 0.7.5 (316) with SD2 calls rev.137
    SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `accoun
    t`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmchar
    acters`.`realmid` = ‘1’
    Using DataDir C:\wow\data/
    WORLD: VMap support included. LineOfSight:1, getHeight:1
    WORLD: VMap data directory is: C:\wow\data/vmaps
    WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
    s, vmap.ignoreSpellIds
    SQL ERROR: Table ‘realmd.account’ doesn’t exist
    Check existing of map file ‘C:\wow\data/maps/0004331.map’: not exist!
    Correct *.map files not found in path ‘C:\wow\data/maps’ or *.vmap/*vmdir files
    in ‘C:\wow\data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate d
    irectories or correct the DataDir value in the mangosd.conf file.

  14. @ mark, what do you mean is the database running?
    and do you have any idea how to fix my problem? or even what’s going wrong? that would help too.

  15. Hi I hate to bother but I did everything exactly right and when I went to install it never gave me a choice for directory I didn’t pay it any mind and kept going well I loaded up wow and it said that it couldn’t validate game version may be caused by interference of another program or corruption of a file after I enter my accountname and password What should I do oh btw I went to try and install and upgrade my mangos through the comand promt and it said ‘mysql’ is not regonized as an internal or external comand, operable program or a batch file. please help