Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3

Time for another Mangos release again :) … this time the Mangos revision used is 4602 with ScriptDev2 145, and as a warning that although you can play it using WoW Client version 2.2.x (such as WoW 2.2.0, 2.2.2, and 2.2.3), but it’s still not officially supported, so expect something to behave strange for example, hidden teleport in Orgrimmar when you are using WoW 2.2.x client. Although there’s already a fix for it, but since i prefer to distribute a clean compiled version without adding custom patch (such as database, script, mangos core), i decided not to include it :)

Things to note in this version :

1. I decided not to include the Project Silvermoon Database because Project Silvermoon Database website is down (it has been several days if i remembered it correctly)

2. No custom vendor on GM Island (because this is using Unified Database only, and custom vendor which is available on GM Island can only be found in Project Silvermoon database)

3. As for feeding pet … i’m not to sure on how to test it (seriously, because i never play on official server, though i wish i could play too)

That’s it … and now here are the steps :

Requirements :

Update : Reaper Mangos 4629 with ScriptDev2 150 and Dual Database has been released :)

1. MySQL (link to my previous post on how to install mysql)

2. Mangos + Database :

Optional :

DBC Files extracted from WoW 2.2.3 enUS Client | 2.59 MB (if you prefer the easiest way without extracting the DBC Files first by yourself)

Fresh Installation Guide (follow this if you’re planning on installing Mangos for the first time) :

1. Extract Maps, Vmaps and dbc files from WoW Client

2. Extract the self extracting archive somewhere, or you can just simply run it and choose to extract into the current directory (don’t worry it’ll create the ReaperMangos4602 folder automatically)

3. Run the reaper-x-mangos.bat inside the reaper-eazy-mangos directory / folder, and you’ll be greeted with this screen, and all you have to do is just write the full path to your mysql installation directory (or where mysql.exe and mysqldump.exe can be found) ;)

Reaper Eazy Mangos

4. After finished writing the full path to your mysql installation directory, now you just need to choose option #1 to install the database for you and when prompted for your root password, you just need to write your mysql root password (remember the mysql installation ?) ;)

Database installation

5. After finished with the above process, now you just need to choose option #4, and adjust each option accordingly (the most important thing is your Datadir location)

Mangos Datadir

6. Now you need to go into your World of Warcraft Installation directory and open the realmlist.wtf file using notepad and then change these lines :

set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com

into :

set realmlist 127.0.0.1

7. Now run mangosd.exe and realmd.exe

8. The first thing you should do of course create a new account for you, and this can be done by typing create username password in the mangosd window as shown on below image

Creating Account in mangos

But a normal account can be boring of course, so we need to configure our username to be a GM, and this can be done by simply typing setgm username 3 (the highest level of course, so you can do anything you want in your server) :P … and done :)

Superman

Upgrading from 4577 or below version (note: i only test it from Mangos 4488++ so if you’re using any version lower than 4488, i can’t give you any support)

1. Run the reaper-x-mangos.bat, and then go with option #99 and wait until finished

2. Then choose to backup your database

3. After finished with the backup process now you just need to choose the first option to install the database

4. Now you just need to choose the restore option

5. For the last step you just need to continue with configuring datadir (If you’re using ReaperMangos4577 previously, you just need to copy the previous mangosd.conf and realmd.conf into ReaperMangos4602 directory and done) :)

Sailing

Related Links :

Comments Navigation 1 2 3 ... 5 Next »

Reaper-X said Oct 17, 2007 at 10:54 pm

# simon

actually mangos autosave your character data :) .. but if you prefer to use manual way to save your character data, you can just type .saveall (ingame) or saveall (mangosd window)

# merijn

use the batch file provided (reaper-x-mangos.bat) and choose the option to change your realmlist ip address :)

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 10:53 pm

Been looking round the server as a GM. Used teleport commands – Got killed – appeared in graveyard. Spirit healer invisible and unable to select it. Cannot use ANY gm comands. All say “cannot chat when you are dead”

Any ideas would be appreciated – Thanks :)

Link to this comment Reply to this comment
merijn said Oct 17, 2007 at 10:38 pm

Hi reaper

i have the server running now but how can i change
the server name ?

greetings

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 10:12 pm

Would anyone happen to know of a link to a site that covers basic mangos instructions like server autosaves and that sort of thing?

Thanks

Link to this comment Reply to this comment
Raptos said Oct 17, 2007 at 9:01 pm

Hey,could you help me with something,everytime i’m running mangosd i get this error:
Loading items…
Error in “item_template” table,probably sql file was updated there should be 138 fields in sql
Please help!

Link to this comment Reply to this comment
KompressR said Oct 17, 2007 at 8:50 pm

sorry, didn’t see walshys post. my bad.

Link to this comment Reply to this comment
KompressR said Oct 17, 2007 at 8:50 pm

execute each core update? I reinstalled WoW and TBC and then installed mangos 4602 fresh. Worked fine the first time with the UDB, but as soon as I updated to the PSDB, I got that error. How do I import each core update untill 4062? (and with what updates do i start? this wasn’t an upgrade it was a fresh install

Link to this comment Reply to this comment
Skreci said Oct 17, 2007 at 6:47 pm

Hey there I need help I can’t make a blood elf or a draenei why I made a bc acc pliz help me ;(

Link to this comment Reply to this comment
Reaper-X said Oct 17, 2007 at 5:15 pm

# Jason

Lol … actually i’m using a modded weapon (dunno what’s the original name of that weapon, but my modded weapon called omega weapon and ultima weapon) that gives you +1000 stats :P

# KompressR

Just as Walshy said, you’ll need to execute / import each core update until 4602 :)

Link to this comment Reply to this comment
WaLshy said Oct 17, 2007 at 3:31 pm

KompressR, what you need to do is apply the update “4594_item_template.sql” in the Mangos/OriginalSQL/Mangos4602/updates folder.

I used the SQLyog program to do it for mine, and it worked fine.

Link to this comment Reply to this comment
WaLshy said Oct 17, 2007 at 2:52 pm

@KrompressR
You should use the SQL Updates in the Core Archive.

“4594_item_template.sql”

Code:
ALTER TABLE `item_template`
ADD COLUMN `minMoneyLoot` int(11) unsigned NOT NULL default ‘0′ AFTER `FoodType`,
ADD COLUMN `maxMoneyLoot` int(11) unsigned NOT NULL default ‘0′ AFTER `minMoneyLoot`;

I used SQLyog to make the changes and it went fine

Link to this comment Reply to this comment
KompressR said Oct 17, 2007 at 2:28 pm

Now I actually have the same problem as will’s second problem… I got my hands on the psdb 18.5, so i took a buncha :REM’s outta reaper-x-mangos.bat, matched the filenames and made it so i could choose the psdb option. the database fnisihed uploading but now i get this error as i boot up mangosd:

Loading Item Random Enchantments Table…
==================================================== 100%
>> Loaded 28361 Item Enchantment definitions

Loading Items…
Error in `item_template` table, probably sql file format was updated (there shou
ld be 140 fields in sql).

Any ideas? Anyone else install the psdb 18.5 db with no errors?

Link to this comment Reply to this comment
Jason said Oct 17, 2007 at 1:58 pm

Hey Reaper,

I’m just curious on what gear you’re using to crit for 23k white dmg. or what gm commands you’re using to crit for that much, any reply would be great thanks.

Jason

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 11:40 am

O.M.G! It’s Worrking. Hm – Well it would be but My graphics card just fizzled on me –

Ah well that is a seperate issue. Mangos seems to be up and runnning. Thank you so much for your help – it must have been like pulling teeth out there. :)

Link to this comment Reply to this comment
KompressR said Oct 17, 2007 at 11:34 am

I have the same problem as will up there, but I had the file it asked for in multiple places on my computer and after reading the Repins post i was about to ask how to register it. However i copied the file into my server folder and ran realmd again and it worked. :)

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 11:31 am

Thanks for the tips. I reinstalled the database (assuming that is what you meant Elliott – you where a little unlcear – or more likely I am too much of a noob to understand the reference)

Made sure I chose option 4 this time and sure enough the config file was there.

Fired up MySQL and tried again. Realmd worked ok. Mangosd. Failed again – I seem to remember getting this probelm before – Cannot remember how I fixed it. Gah

Link to this comment Reply to this comment
Reaper-X said Oct 17, 2007 at 11:09 am

# simon

Yep you’ll need that mangosd.conf file first ;)

try running the reaper-x-mangos.bat and choose option 4 and adjust it accordingly, and you’ll get that mangosd.conf file :D

# WaLshy

Actually it’s not database related, but it’s scriptdev2 related :)

# Oko

try looking at the src/shared/common.h ;)

# elliott

Patching the source code require you to recompile the code again :)

Link to this comment Reply to this comment
Vedin said Oct 17, 2007 at 11:07 am

I also would like to know where I can find some patches and how to install them so that I can get the scripts running correctly for the instances

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 10:29 am

okay got all the way through DBC, Map and Vmap installation. Got to running Realmd and mangosd. Realmd works fine – Mangosd crashes instantly. Barely blinks on screen a second the is gone. I looked for a Mangosd Config file but there is none. Is this what I need or not?

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 7:38 am

I seem to get a Buildings Folder aswell from “make maps simple.bat” Is that right and should they be moved to the same location?

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 7:36 am

Decided to try from scratch – realised upgrading from 1.0.8 seems crazy.

Am I correct in thinking I put the extracted maps, vmaps and DBC folders in the ReaperMangos4602 folder?

Thanks again for your time and patience

Link to this comment Reply to this comment
elliott said Oct 17, 2007 at 7:08 am

hye on this version does gm island have any venders?? and if not where can i get a patch for it.. and also lol how do you install patchs? i got one from the forms for instances.. but it doesnt tell me how to patch the server.

Link to this comment Reply to this comment
Chris said Oct 17, 2007 at 6:41 am

Great guide. Thanks for the work. My server is up and running with only minor issues that I am working through. It works for clients up through 2.2.3. This last upgrade appears to fixed the pet feeding issue as it is now working for me. Thanks again.

Link to this comment Reply to this comment
elliott said Oct 17, 2007 at 5:48 am

hey, ty for everything its all working well, i’m havening issues getting a site template to work.

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 5:44 am

I should mention my Noob status – so please go slow with instructions :)

Link to this comment Reply to this comment
simon said Oct 17, 2007 at 5:31 am

Hi – I posted a couple of weeks ago and gave up in frustration at being unable to get a server up and running.

Well I am trying again and Have a Mangos 1.0.8 working – obviously this is not much good but I see graphics and all that pretty WOW stuff like a game – now I would like to try to upgrade.

Is there a tutorial on how to do this? Or do I really have to ditch this and start from scratch? I would appreciate any advice you could give me.

Thank you.

Link to this comment Reply to this comment
Xyzy said Oct 17, 2007 at 3:53 am

Pretty much NONE of the scripts/triggers for events work. Mobs only auto-attack, instances in doors don’t open (Shadow Labs just tested); in CoT all three instances are bugged (the buildings in Hillsbrad are on fire to begin with, but I can’t talk to Thrall, Medivh won’t begin opening the portal, and enemies in Hyjal just stand around doing nothing).

Link to this comment Reply to this comment
Roman said Oct 17, 2007 at 2:10 am

Hey. I got this problem too with Mangos 4577 but then I found out it was the program Mysql that did not work correctly. I reinstalled MySQL and re-uesd reaper-x-mangos.bat to reinstall the right data. then it loaded completely. Maybe it will help you too.

Link to this comment Reply to this comment
will said Oct 17, 2007 at 1:48 am

2007-10-16 14:43:46 Using configuration file mangosd.conf.
2007-10-16 14:43:46 MaNGOS daemon /Reaper-X R4577 0.8-SVN http://www.reaper-x.com (Win32)
2007-10-16 14:43:46 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

2007-10-16 14:43:46 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-10-16 14:43:46 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-10-16 14:43:46 Realm running as realm ID 1
2007-10-16 14:43:46 Using UDB 0.7.5 (319) with SD2 calls rev.145
2007-10-16 14:43:46 Using DataDir C:\wow\data/
2007-10-16 14:43:46 WORLD: VMap support included. LineOfSight:1, getHeight:1
2007-10-16 14:43:46 WORLD: VMap data directory is: C:\wow\data/vmaps
2007-10-16 14:43:46 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2007-10-16 14:43:46 Initialize data stores…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Loaded 38 data stores
2007-10-16 14:43:46
2007-10-16 14:43:46 Using Autodetected DBC Locale (0).

2007-10-16 14:43:46 Cleaning up instances…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Initialized 0 instances, deleted 0 old instances
2007-10-16 14:43:46 Packing instances…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Instance numbers remapped, next instance id is 1
2007-10-16 14:43:46 Loading Game Object Templates…
2007-10-16 14:43:46 >> Loaded 12991 game object templates
2007-10-16 14:43:46
2007-10-16 14:43:46 Loading Spell Chain Data…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Loaded 1904 spell chain records
2007-10-16 14:43:46 Loading Spell Learn Skills…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Loaded 42 spell learn skills + found in DBC 74
2007-10-16 14:43:46 Loading Spell Learn Spells…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Loaded 42 spell learn spells + found in DBC 5930
2007-10-16 14:43:46 Loading Spell Proc Event conditions…
2007-10-16 14:43:46
2007-10-16 14:43:46 >> Loaded 850 spell proc event conditions
2007-10-16 14:43:46 Loading Aggro Spells Definitions…
2007-10-16 14:43:46 >> Loaded 56 aggro generating spells
2007-10-16 14:43:46
2007-10-16 14:43:46 Loading NPC Texts…
2007-10-16 14:43:47
2007-10-16 14:43:47 >> Loaded 3522 npc texts
2007-10-16 14:43:47 Loading Item Random Enchantments Table…
2007-10-16 14:43:47
2007-10-16 14:43:47 >> Loaded 28408 Item Enchantment definitions
2007-10-16 14:43:47 Loading Items…
2007-10-16 14:43:47 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 138 fields in sql).

well i got past that file problem now i get this any suggestions oh and ty on the advise

Link to this comment Reply to this comment
stitches said Oct 17, 2007 at 12:56 am

I have a similar problem to Oko’s login loop, although I am using the windows version from this guide.

I get as far as Oko where you have to choose a realm language & type, but I get recommended Reaper-X realm and then I also get stuck at the realm list. Selecting the Reaper-X realm again brings up “Logging into game server” and then it gives up, returning to the realm list.

Thanks for any help.

Link to this comment Reply to this comment
Repins said Oct 16, 2007 at 9:56 pm

hey will i had that problem a while back and they way that i fixed it was like this: I tried to Register MSVCR71.DLL and it wouldn’t work then I found the same type of file but only in lowercase letters and lowercase ext. and it worked. Sorry I can’t remember where I found the file but you can try to rename it in all lowercase and then register it.. Hope that helps.

Link to this comment Reply to this comment
Oko said Oct 16, 2007 at 9:07 pm

Scrap my previous message, solution was found on http://www.mangos-fae.info/ ‘Realm Looping’ is caused by having the incorrect IP in the realmd.realmlist table. ( Ooppss )

Oko

Link to this comment Reply to this comment
will said Oct 16, 2007 at 8:38 pm

Reaper help please just tryed to do a clean installation and i get this application has failed to start because msvcr71.dll was not found re-installing the application may fix it this happens when i try to bring up mangosd.exe and i have redone it all 7 times still same thing please help

Link to this comment Reply to this comment
WaLshy said Oct 16, 2007 at 7:41 pm

Does anyone know of a fully working Database? With all / most bosses scripted right?

Thx in advanced

Link to this comment Reply to this comment
mapisto said Oct 16, 2007 at 6:49 pm

Thanks a lot Reaper-X that solved it :)

Link to this comment Reply to this comment
Oko said Oct 16, 2007 at 6:41 pm

Hello there,

I have your compiled windows version running nicely. However I grabbed r4602 from the SVN repository and built it for Linux. At first I got “Unable to validate game version” but resolved this with a simple fix to src/realmd/AuthSocket.cpp (validating any game version).

Now I get so far as to choose a realm language & type, get recommended MaNGOS realm and then i get stuck at the realm list. Selecting the MaNGOS realm again brings up “Logging into game server” and then it gives up, returning to the realm list.

Are there any specific patches / changes you do to your source tree before building it for windows?

Thanks

Oko

Link to this comment Reply to this comment
Reaper-X said Oct 16, 2007 at 6:34 pm

# mapisto

Did you choose to upgrade realmd first ? (option number 99) because there’re several changes made into the realmd database :)

Link to this comment Reply to this comment
mapisto said Oct 16, 2007 at 5:59 pm

Hey
Thanks a lot to Reaper-X for all your work and dedication
I just have this little problem with this version. I backed up, installed, and restored, upgrading from version 4535. now, mangosd.exe is working just fine but when I try to work ralmd.exe it gives me the following error:
Database: 127.0.0.1;3306;mangos;mangos;realmd
SQL: SELECT `id`, `name`, `address`, `port`, `icon`, `color`, `timezone`, `allowedSecurityLevel`, `population` FROM `realmlist` WHERE `color` != `3` ORDER BY `name`
query ERROR: Unknown column `allowedSecurityLevel` in `field list`
No valid realms specified.

Please please help me out…

Link to this comment Reply to this comment
Demig0d said Oct 16, 2007 at 4:20 pm

Actually those don’t work because they have not been scripted yet. Void Reaver was working a bit more like intended already, there still are some wrong flags in the arcane orb target definitions, they have a dumb model and you nearly always resist their damage, althought they are marked to be lvl 70 in the DB but they appear as lvl 1 creatures. He also enrages after 10 minutes, that was kinda hilarious to experience.

Link to this comment Reply to this comment
Xyzy said Oct 16, 2007 at 9:25 am

Not to mention, I couldn’t finish Taretha’s diversion; the barrels were in the flaming houses, but lighting them did nothing.

Link to this comment Reply to this comment
Xyzy said Oct 16, 2007 at 9:25 am

Most things on the server seem to be functioning well, but I am having problems with instances, especially the Caverns of Time. In Old Hillsbrad, the internment camp is in flames from the start. In Hyjal Summit, there are no waves of enemies; they just stand there. And in the caverns themselves, those two little children who give the quests are not there (though the swirly purple design is).

Link to this comment Reply to this comment
Reaper-X said Oct 16, 2007 at 8:34 am

# Nick

Well … actually i already included it with different name :) , try using the batch file and then choose the fourth option to adjust datadir and drop rate ;)

# Sanctus

Probably but im not to sure about creating custom maps though, i think mangosproject website should give you some information about it :)

# metaltildea

Unfortunately it’s impossible for me to upload large files (100MB+) such as maps and vmaps :( (even 10MB file takes 30 minutes to complete)

btw actually you just need to wait until all the vmaps gets extracted properly (check the vmaps extraction guide so you know how it’ll looks like when vmaps extraction finished) :)

# Repins

Your welcome Repins, glad you like it :)

# RazMaTaz & Jared

Thanks for the link to the backup site of PSDB ;)

i just downloaded the 18.5 release but still wondering should i include it in this one or include it on the next release ?

Link to this comment Reply to this comment
Repins said Oct 16, 2007 at 7:26 am

Hey Reaper I just wanna say thanks for takin the time do post all the how to’s and things… I’ve been tryin for weeks to make a private stable server and your guides have become a life saver! thanks again and please keep up the good work!!!!

Link to this comment Reply to this comment
Jared said Oct 16, 2007 at 3:51 am

I use silvermoon, but oh well its good that he got this for others :) I’ll see if I can find the new database for project silvermoon and tell reaper cause they have backup sites.

Link to this comment Reply to this comment
metaltildea said Oct 16, 2007 at 3:44 am

sorry i forgot to post this before but i can never seem to get my vmaps completely so could you post a download for them already extracted?

Link to this comment Reply to this comment
metaltilfra said Oct 16, 2007 at 2:59 am

thanks reaper i though u were going to stop at 4590 but u went up anyway and I’m glad you chose to use the unified db it’s much more functional than the silvermoon one’s

Link to this comment Reply to this comment
Sanctus said Oct 16, 2007 at 2:21 am

Hello there,

Do you know how I can build a real Mod for WoW. With Custom Maps and Systems?

Learning how to develop to ScriptDev2 will do the trick?

Thanks and regards…

SKristies

Link to this comment Reply to this comment
RazMaTaz said Oct 16, 2007 at 1:16 am

Offical PSDB Backup Site
ps.eamped.com

Link to this comment Reply to this comment
Nick said Oct 15, 2007 at 10:40 pm

Sorry to imform you this but you have forgotten
mangosd.conf again just like in the rev4575

Link to this comment Reply to this comment
siegelink said Oct 15, 2007 at 7:26 pm

Hi,

I do play on the official servers, so if you have to know certain thing’s (like pet feeding) pls ask.

Link to this comment Reply to this comment