WoW Mangos 4505, ScriptDev2 136 with Project Silvermoon Rev18

I just uploaded another update to WoW Mangos Emulator, this time i’m using Mangos Revision 4505 plus ScriptDev2 Rev136 and with Project Silvermoon Mangos Database Revision 18. Other than that i also create a small batch script to help you simplify the upgrade process if you’re using my previous Mangos 4488 files, thought i’m quite sure that you can also use it even if you are not using my Mangos 4488 :)

UPDATE : I just uploaded a new Modified version of WoW Mangos 4524 for WoW 2.2 client and WoW 2.1.3 Client … and also i’ve changed the batch script to make things even easier especially to those who’s still having problem with Mangos 4505 and 4488 ;)

UPDATE : Many thanks to Caldaga for telling me that i forgot to include the VMaps Extractor and Assembler into this 4505 Release (although it’s included in my previous 4488 release). So if you’re using this 4505 release (small version or full version) … make sure to download the VMaps Extractor and Assembler too (no wonder there’re some people who’s experiencing VMaps related error message)

# VMaps Extractor and Assembler (143 KB)

As a side note, VMaps is different than Maps. Maps are required for WoW Mangos to work, while VMaps not required except that you want support for line of sight and height calculation (but i’d suggest you to use it too)

And just like before, i uploaded two version of my mangos release. The first version is to those who’s already have Mangos installed and configured, and / or already using another database (SDB for an example). Already familiar with importing each mangos core update manually, and so on … Or it might also be useful to those who’s using slow connection like me and prefer a smaller file size to download

Mirror:

#1. Mangos Revision 4505 with ScriptDev2 Revision 136 | Mediafire

#1. Mangos Revision 4505 with ScriptDev2 Revision 136 | Megaupload

Inside the small version you can find DBC, Maps and VMaps extractor, and also a batch file inside the Backup Directory just in case you want to Backup your important Mangos Character Data or the Realmd table and data

As for the second version, basically is just the same like the above version with the exception this one also included the Project Silvermoon Rev18 database, and also contain a batch script to import the database

Mirror:

#2. Mangos Revision 4505 with ScriptDev2 Revision 136 plus Project Silvermoon DB Rev18 | MediaFire

#2. Mangos Revision 4505 with ScriptDev2 Revision 136 plus Project Silvermoon DB Rev18 | Megaupload

If you’re using my previous Mangos 4488 release, and are not familiar with importing the core update manually, i’d suggest you to get the second version instead :)

As a note, i created the batch script inside to help simplify the upgrade process from Mangos 4488 to Mangos 4505 to those who download my previous full database / without db which mean that it has been tested only with Mangos 4488 only (if you’re using lower version it might or might not work for you) … and i only tested it on Windows XP SP2

And here are the instruction to those who’s going to use the Full Database version :

If you’re upgrading from my previous Mangos 4488 :

1. Extract the archive somewhere in your harddisk, for example C:\reaper-mangos-R4505-full

2. Go to C:\reaper-mangos-R4505-full\Backup and then execute / run backup.bat

3. When prompted if you’re using my previous Mangos release, answer yes .. and then when asked for your mysql bin path, write your Mysql bin path there for example C:\Program Files\MySQL\MySQL Server 5.0\bin if you follow my previous mysql guide and is using the default path

4. Go to C:\reaper-mangos-R4505-full\reaper-eazy-mangos and then run import.bat. When prompted for your MySQL root password, just write your mysql root password there and then continue the rest and wait until it finished

5. Now go back C:\reaper-mangos-R4505-full\Backup and this time you need to run the backup-importer.bat file, and continue the process like before until it finished

6. Now for the last step, you just need to open mangosd.conf and edit the datadir path into the correct datadir path … that’s it … you’re done :)

Guess who is she ?

If you’re installing for the first time (some part copied from my previous wow mangos 4488 guide) :P

1. Copy the ad.exe from MapExtractor Directory into C:\Program Files\World of Warcraft

2. Create new folder called maps, and then run the ad.exe … and wait until this process finished (don’t interrupt it)

3. Copy all files inside VmapExtractAssembler into C:\Program Files\World of Warcraft and run the makevmaps_SIMPLE.bat … and wait again until it finished

4. Copy all files inside DBC Extractor into C:\Program Files\World of Warcraft\Data\enUS … and run the extract.bat … and wait until it finished

5. Move vmaps, maps, and dbc folder from your World of Warcraft installation path into C:\reaper-mangos-R4505-full\data (create folder named data first)

6. Open Mangosd.conf using Wordpad … and then find this line :

DataDir = “I:/WoW/Data”

Change it to :

“C:/reaper-mangos-R4505-full/data” (include the quotes)

7. Go to C:\reaper-mangos-R4505-full\reaper-eazy-mangos and then run the import.bat

8. Open realmlist.wtf file from C:\Program Files\World of Warcraft using Notepad and change the :

set realmlist us.logon.worldofwarcraft.com

into

set realmlist 127.0.0.1

11. Run Mangosd.exe and Realmd.exe (and keep it running)

12. At the Mangosd window type these :

create MyUsername MyPassword

setgm MyUsername 3

to create a test user with MyUsername as username and MyPassword as password, see below image for an example :

Mangos create account

13. Now run the WoW.exe from your World of Warcraft Game Directory, for example C:\Program Files\World of Warcraft\WoW.exe (not the launcher)

and you’re done :)

Fighting against dragon

And now here’s the link for the Mangos Commands

Okay that’s it … if i’m missing something just let me know :)

Note to those who’s changing the database name : If you changed the database name from the default name, you’ll also need to change the db name manually in the backup-importer.bat, and import.bat … i’ll add it for the next release as for now … you need to do it manually (i’m sorry, i completely forgot about it … perhaps that’s because i haven’t sleep since yesterday and too tired to think … beside it’s already morning here lol)

Comment?

Note: Comment may not appear right away.

265 comments on “WoW Mangos 4505, ScriptDev2 136 with Project Silvermoon Rev18

  1. ran into anouther error but figured it out and am sharing a tip. when coping the data directory info do not copy the ” befor eand after type them in manualy. make sure to include them but do not past them actualy spend the time to type the stupid ” in will save you a headack or 2

  2. ok yea the importer was currupted re downloaded then extracted just the importer file and replaced the old one and now the importer is doing a lot more also to all other following this procces do not change any settings in the importer as sugest above as it will couse the importer to not work right best of luck all and think I got at least this step working right will keap posted. thanks for the great guid reaper

  3. wish my problem could be fixed so easaly the import file worked fine for me but didn’t fix the prob. might there be something wrong with the import file perhps some form of curuption or anything? is there a way to check and make sure that the import program worked properaly?

  4. Nevermind my post above, after some tinkering and re-reading I realized I had just forgotten to run the import.bat file, so pretty simple indeed. Server works great =)

  5. Hi Reaper, excellent work; the amount of info and feedback here are extrordinary. I hate to add to the overwhelming list of questions, but I was wondering if you might know what this problem was.

    Despite doing everything exactly according to the walkthrought, I’m having an issue identical to Star.

    Everything works perfectly until step 11. When I try to start mangosd.exe I get this error:

    2007-10-24 02:03:13 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-10-24 02:03:13 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@’localhost’ (using password: YES)

    2007-10-24 02:03:13 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos

    And when I try to open realmd.exe I get this error:

    2007-10-24 02:30:39 Using configuration file realmd.conf.
    2007-10-24 02:30:39 MaNGOS realm daemon /0.8-SVN (Win32)
    2007-10-24 02:30:39 to stop.

    2007-10-24 02:30:39 Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-10-24 02:30:39 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@’localhost’ (using password: YES)

    2007-10-24 02:30:39 ERROR:Cannot connect to database

    I too am using your pack of mangos 4505 with wow version 2.1.3 on a windows XP sp2 machine.

    I would guess its probably something simple, but that said I still haven’t been able to figure it out, so any help would be greatly appreciated. Thanks in advance, and again, thanks greatly for working so hard to put together such a knowledge base.

  6. also in DataDir is it supposed to look like this or without the datadir = as you guid wasn’t exactly specific on that

    # Data directory setting.
    # Important: DataDir needs to be quoted, as it is a string which may
    # contain space characters.
    DataDir = “C:/reaper-mangos-R4505-full/data”

  7. Install sql install mangos got everything to work up to the running the mongosd.exe and realmd.exe and then I get this error

    World Database: 127.0.0.1;3306;mangos;mangos;mangos
    Could not connect to MySQL database at 127.0.0.1: Can’t connect to MySQL server on ‘127.0.0.1′

    Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos

    I checked task manager and mysql.exe is in the processes list I am using windows xp operating system. any help you can give me would be much apretiated. Thanks in advance.

    PS: am also planning on setting the server up to be used primarily on a router secondarily allowing 1 internet user don’t know if that information matters in this instence but am tring to give you all the info possible.

    PSS: am setting it up to use the burning crusades in case that matters also.

  8. bahh need to be able to delete are replies anyhows reaper you wanna delete my last to posts neither of them actualy sent out the way they were ment to…. go fig anyhows great guide

  9. ok so evidently it don’t post up here when it’s compleate so instea here it is and how to make it work.

    echo Reaper-X Quick and Dirty import tool for Mangos
    echo.
    set user=root
    echo What is your root password ?
    set /p pass=
    echo.
    echo Where is your MySQL BIN path ?
    echo (for example C:\Program Files\MySQL\MySQL Server 5.0\bin)
    echo.
    set /p mysqldir=
    set mysqlpath=”%mysqldir%”
    path=%mysqlpath%
    set myoption=-v
    mysql -u%user% -p%pass% %myoption% < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\drop_mysql.sql”
    mysql -u%user% -p%pass% %myoption% < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\create_mysql.sql”
    mysql -u%user% -p%pass% %myoption% -D realmd < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\realmd.sql”
    echo.
    echo Please wait it’ll take a while to import the database
    echo.
    mysql -u%user% -p%pass% -D mangos at the end or each line that has 1 in it so that the code is closed if that made much sence

  10. ok found out my problem thanks reaper-x also going to fix post that would otherwise have helped tons.

    Korny | Sep 26, 2007 at 3:41 / 3:41 AM | Links to this comments | Reply

    @kahilan

    I had the same problem but after putting C:\reaper-mangos-R4505-full\reaper-eazy-mangos\
    in front of the sql scripts within the “Import.bat” file it worked like a charm.

    Copy and replace all content in the Import.bat filewith the following, save and run it:

    @echo off

    echo Reaper-X Quick and Dirty import tool for Mangos
    echo.
    set user=root
    echo What is your root password ?
    set /p pass=
    echo.
    echo Where is your MySQL BIN path ?
    echo (for example C:\Program Files\MySQL\MySQL Server 5.0\bin)
    echo.
    set /p mysqldir=
    set mysqlpath=”%mysqldir%”
    path=%mysqlpath%
    set myoption=-v
    mysql -u%user% -p%pass% %myoption% < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\drop_mysql.sql”
    mysql -u%user% -p%pass% %myoption% < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\create_mysql.sql”
    mysql -u%user% -p%pass% %myoption% -D realmd < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\realmd.sql”
    echo.
    echo Please wait it’ll take a while to import the database
    echo.
    mysql -u%user% -p%pass% -D mangos < “C:\reaper-mangos-R4505-full\reaper-eazy-mangos\mangos.sql”
    echo.
    echo If you get any error message just let me know
    echo.

    pause

    This was almost correct but he left out the closing brackets wich generated a difrent error heres the corrected version so others can simply copy and past hope it helps someone.

    @echo off

    echo Reaper-X Quick and Dirty import tool for Mangos
    echo.
    set user=root
    echo What is your root password ?
    set /p pass=darkstar
    echo.
    echo Where is your MySQL BIN path ?
    echo (for example C:\Program Files\MySQL\MySQL Server 5.0\bin)
    echo.
    set /p mysqldir=C:\Program Files\MySQL\MySQL Server 5.0\bin
    set mysqlpath=”%mysqldir%”
    path=%mysqlpath%
    set myoption=-v
    mysql -u%user% -p%pass% %myoption%
    mysql -u%user% -p%pass% %myoption%
    mysql -u%user% -p%pass% %myoption% -D realmd
    echo.
    echo Please wait it’ll take a while to import the database
    echo.
    mysql -u%user% -p%pass% -D mangos
    echo.
    echo If you get any error message just let me know
    echo.

    pause

  11. I have 2 questions. 1. How do i get Mangos Database Manager to work with this Database? 2. How do I set it up to let other people play on my server? Thank you for your help and time.

  12. # FreezingFlames

    Well if you’re using 4524++ (im if not wrong because i completely forgot when i include my batch file lol)

    you need to adjust your realmlist ip address to your ip address

    then adjust some port forwarding especially on 3724 and 8085

    and you’re done ;)

    though on some people they need to change the realmd port into other values

  13. Nevermind, i got it to work :D Okay but i have a different question now :) what do i need to change in order for other people to play?

  14. lol i put a typo because i don’t know how to copy text from command propt :D so when i said “files in ‘C:?reaper-mangos-R4505-full/data/vmaps’. ” i meant “files in ‘C:/reaper-mangos-R4505-full/data/vmaps’. ”

    sorry :D

  15. Okay, i’ve followed your guid, but i didn’t do the vmaps thingy cuz megaupload wouldn’t let me download it and also because you said it wasn’t necesary. So, when i ran the mangosd.exe it gave me this message

    Could not find vmap files ‘C:/reaper-mangos-R4505-full/data/vmaps/00_43_31.vmdir’
    Correct *.map files could not be found in path ‘C:/reaper-mangos-R4505-full/data/maps’ or *.vmap/*vmdir files in ‘C:?reaper-mangos-R4505-full/data/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file

    what should i do?

  16. # Jason

    What is your operating system ? i only test that batch file in Windows XP, although someone saying that he’s using Vista and it also worked there :)

    # Adinos

    DBC files are different than the vmaps and maps file :) … so you need to extract the vmaps and maps too

    # Infernal Demon

    Did you choose the first option to install the database ? btw try using the 4577 version instead :)

  17. having trouble getting the import msbatch file to work give error

    Reaper-X Quick and Dirty import tool for Mangos

    What is your root password ?
    xxxxxxxxxx

    Where is your MySQL BIN path ?
    (for example C:\Program Files\MySQL\MySQL Server 5.0\bin)

    C:\Program Files\MySQL\MySQL Server 5.0\bin
    The filename, directory name, or volume lable syntax is incorrect.
    The filename, directory name, or volume lable syntax is incorrect.
    The filename, directory name, or volume lable syntax is incorrect.

    Please wait it’ll take a while to import the database

    The filename, directory name, or volume lable syntax is incorrect.

    If you get any error message just let me know

    Press any key to continue . . .

    I tried all the things I could find within the other questions on this subject but to no use. what I love to know is a couple things one what exactly this step is doing or rather how I will know when it works correctly. Also is there a way to manualy skip this step?
    I have msn messenger and use the e-mail addy included in this reply for my username in case that method of reaching me is easyer

  18. umm… i’m having trouble w/ the dbc files. i have copied the dbc extractor into the data folder and let it finish extracting everything. when it is finally finished the folder w/ the dbc files is only 44.2 mb….i try to run the mangosd.exe and it runs and finds all the maps and vmaps and starts on the dbc files and then gets and says “Error loading ‘playercreateinfo’ table or table is empty”. any suggestions on what to do?

  19. # Troy

    Im really sorry but i havent tried using Tompack or any other repack myself so it’d better for yout to ask the Tompack author directly :)

    # Infernal Demon

    Could you tell me which mangos version you’re using ? and are you upgrading your mangos or doing a fresh install ?

  20. Hi Reaper, I’m having a little trouble with my server. Here it is the problem:

    >> Loaded 1914 spell chain records

    Loading Spell Learn Skills…
    =Spell 3386 listed in ‘spell:learn_skill’ not exist= 34%
    ======================================100%
    >> Loaded 44 spell learn skills + found in DBC 74

    Loading Spell Learn Spells…
    ======================================100%
    >> Loaded 40 spell learn spells + found in DBC 5930

    Loading Spell Proc Event conditions…
    SQL: SELECT ‘entry’ , ‘SchoolMask’ , ‘Category’ , ‘SkillID’ , ‘SpellFamilyName’ , ‘SpellFamilyMask’ , ‘procFlags’ , ‘ppmRate’ FROM ‘spell_proc_event’
    query ERROR: Unknown column ‘SpellFamilyName’ in ‘field list’
    =========================================100%
    >> Loaded 0 spell proc event conditions

    Loading Aggro Spells Definitions…
    =========================================100%
    >> Loaded 101 aggro generating spells

    Loading NPC Texts…
    =========================================100%
    >> Loaded 3687 npc texts

    Loading items…
    Error in ‘item_template’ table, probably sql file format was updated

  21. ended up having a DB error and having to reinstall WoW. Instead of installing MySQL from the website, I’m currently using Tompack. Which is a compository of everything I need. The only issue is that black temple isn’t spawned and hyjal is yah, well screwed. Any advice on how to fix this issue. Update procedures maybe. Thx

  22. # Troy

    Try using my extracted DBC version … btw if you’re running WoW 2.2.0, then you can just ignore that error message, but if you’re using WoW 2.2.2 (which is just released today), then you need to upgrade into my mangos 4535 release ;)

    # Michael

    Your welcome, glad you’re able to run your mangos server :D

  23. Seballe Either you didn’t include the bin dir of MySQL in you path during the MySQL setup, like you were supposed to, or during the run of the import.bat file you didn’t actually write the path down (you probably thought that it would default to the one included in the parenthesis). In the second case write down the path.