Custom Search
Reaper Mangos 4651, ScriptDev2 151 with Project Silvermoon and Unified Database
Posted by Reaper-X Oct 29 2007 10:26 pm
Time for another Mangos release again :D … and this time, instead of creating one mangos release, i have decided to also release my other compiled mangos release which is using Auction House Bot and Jail Patch that is designed to those who love to try out something new in their mangos server or in other words, a more experienced mangos user :)
but let’s keep that aside shall we ? because i’m going to write that one on that post release and in this post i’m only going to give you some intruction on how to get your private wow server running using the pure / clean compiled mangos without any additional patches included
As a note this release uses Project Silvermoon Database Revision 18.5 (Not updated except for the core update) and Unified Database 0.8.1 Revision 325 (Updated) and only work with WoW 2.2.3 Client and tested with WoW 2.2.3 with TBC Expansion Pack installed, so if you’re not using TBC expansion pack, you’ll need to disable the expansion pack in mangosd.conf in order to work with your WoW 2.2.3 :)
Just like before, here are the steps :
Requirements :
1. MySQL and it’s guide on how to install it properly
2. Mangos with Database
Update: Reaper Mangos 4703 has been released
Reaper Mangos 4651 with Scriptdev2 151 Dual Database Reaper Mangos 4651 with Scriptdev2 151 Dual Database | 14.4 MB | Rapidshare 14.4 MB | RapidshareReaper Mangos 4651 with Scriptdev2 151 Dual Database Reaper Mangos 4651 with Scriptdev2 151 Dual Database | 14.4 MB | Megaupload
Optional (if you don’t have these installed already) :
- .NET Runtime – For maximum compatibility with any programs in the future, i recommend you to install .NET Runtime 1.1, .NET Runtime 2.0 and .NET Runtime 3.0 (and don’t forget to read the requirements over at Microsoft website) ;)
Mangos Fresh Install :
Important Note : Below steps is designed to those who are installing mangos for the first time or upgrading from Reaper Mangos 4629, if you’re upgrading from 4602 and below you’ll need to upgrade the character table and realmd first using the menu provided on reaper eazy mangos
Not too Important Note : The screenshots used below is not updated but the installation process is still the same of course :) and oh one more thing, i assume that you’ve extracted the self extracting archive ;)
1. Extract the DBC Files, Maps, and VMaps from your world of warcraft client
2. Run the reaper-x-mangos.bat inside the reaper-eazy-mangos directory / folder, and you’ll be see something like this, and then all you have to do is just write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)
3. Now you just need to choose option number 1 to install the database as shown on below image, and when prompted for your mysql root password, don’t forget to write the correct password … and then when prompted to choose the database, feel free to choose the Project Silvermoon database or Unified Database so you can compare it :)
4. After finished with the database installation, now you need to choose option number 4 (required or else you’ll see the mangosd.exe close immediately when you run it) to adjust the datadir and adjust the exp rate, and drop rate :)
5. Now after finished with all the above process, you’ll need to go inside your World of Warcraft installation directory (for example C:\Program Files\World of Warcraft) and then open the realmlist.wtf using notepad and …
replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
with :
set realmlist 127.0.0.1
save it and close realmlist.wtf file
6. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating username of course :D by typing create username password inside the mangosd window as shown on below image as an example … followed by typing setbc username 1 … so you can choose Blood Elv and Draenei
lastly you just need to type setgm username 3 so you’ll have the GM Power, and … done !!! congrats … now all you have to do is just login using the username you’ve created before ;)
Upgrading from 4629 Release / switching between silvermoon database and unified database :
1. Choose to backup your character first
2. Choose to install the new database
3. Choose the restore option to restore your character and … done :D
Note : Since i don’t really know how many people are still using my old release :( , i assume that most people already upgraded into my previous 4629 release
and here’s my character screenshot
And just in case you didn’t see my previous post, here’s a screenshot of my character riding Nether Drake (note: this is taken using the Unified Database)
and fishing :P
Related Links :
MySQL Installation
Mangos Commands for GM
Setting up Private WOW Server for LAN or Internet
Installing Apache Web Server for Mangos Registration Page
Trackbacks/Pingbacks
Leave a response
Connect with me
ughhh idk why but when i run the reaper x mangos batch file thing and in it when i put in my mysql thing it gives me some options but theres also opttion 98 and 99 :O so plz PLz what do i do and idk if this will hapen but it hapened twice so i think it will hapen again what do i do if when i run mangosd and realmd it doesnt connect?
An example could be this:
Old mangosd.conf
# Max level that can reached by player for expirience (in range from 1 to 255).
# Change not recommended
# Default: 70
MaxPlayerLevel = 70
New mangosd.conf
# The maximum level that can be reached for players by experience (in the range of 1 to 255).
# Changing the default is not recommended, due to a bug when reaching level 88.
# Default: 70
MaxPlayerLevel = 70
This does not make any differense to the game. As every line edited was after a ‘#’.
If the ‘MaxPlayerLevel = 70′ had been edited to something like ‘MaxPlayerExpLevel = 70′ then it would change everything and make your old .conf file useless.
Thanks for reading my reply, Muskar.
Actually, I do not know if there is changes in the .conf files as I have only seen one release so far.
Try matching the new ones with the old. If there is any difference at all [except for the comments (comments is signalled by a '#' and means that everything AFTER that symbol in the CURRENT LINE, is not a part of the code, but only a message to the reader.)], then you can’t overwrite it.
If that is the case, you will have to open the old and the new .conf files on the same time and manually add all the data that is still used to the values that you used in the old .conf file.
If that isn’t the case, you can just overwrite it and play on =)
I tried copying my old Mangosd.config file over the newer one and the MaNGOS loads okay.
Is this right or have I made an error in doing so?
Thanks for the reply.
A follow up question. As I am using the new Mangosd.exe and realmd.exe can I use my old config files?
sorry for my browser, didn’t see your respond Reaper-X >.<
Well, lets attempt to help the last guy out then q:
#Rappe
1. So did it work to change the realmlist name or did it return some kind of error? (you input the realmname and IP-adress and then the output should show that it is changed).
2.The .setskill command works in this way:
.setskill #id #value
To find the skill ID, type .lookupskill
Then one or a few more skills should be showed depending on your search.
An example could be setting enchanting skill to 375:
.setskill 333 375
I think it is.
#simon
As far as I know, mangosd.exe loads all the objects, maps, scripts etc. etc. from the directory you inputted when installing the DB. If the mangosd.exe is in fact changed to load more files (as the DB has more files), then your previous mangosd.exe wont do the trick – UNLESS, of course, mangosd.exe only opens a file within the database that comes with the new patch, that redirects to the files to load.
In other words, it’s safest to use the new one, but is not necessarily needed. I would recommend you to use the new ones.
And why wouldn’t you do so?
1.I did
2.didn’t know it excisted
3.ok, np
4.yes i gave my realmlist to him cause he didn’t foudn it in hes wow map.
# Overlord
Try running it on different date to see if its working or not :)
# simon
Hello simon, of course you’ll need to use the new mangosd.exe and realmd.exe or you just end up using the old version ;)
# Will
put this in your mangos directory :)
http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71
# Rappe
1. You can use the reaper-x-mangos.bat included and choose option number 5 :)
2. have you tried using the .setsk command ?
3. haven’t tested it yet (since i never go into battleground)
4. Have you changed the realmlist ip address to your public ip address, and your friend also use the same realmlist address you used ?
I finally got into my server but:
1.World name is reaper-x, how to change?
2.I can’t update my skills higher then lvl24 :s
3.I can’t join the battleground.
4.My friend couldn’t get into the world, he logged in then he clicked okay to select reaper-x as world and then he says the screen jumps back on the world select :s
anyone can help?
When i try to start Mangosd.exe and realmd.exe i get a message saying “This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem.” I have downloaded manogs multiple times and still dont have MSVCR71.dll . Am i doing something wrong? where can i get it?
Hi – constantly impressed with the speed updates are implemented.
My question relates to updating 4629 to 4651.
Ran ReaperMangos4651.exe
Opened ReaperMangos4651\Reaper-easzy-mangos and ran reaper-x-mangos.bat
Backed up characters.
Installed database
Restored characters.
Do I need to use the realmd.exe & mangosd.exe that came with this update (4651) or can I continue using those that came with 4629?
Thanks for your continued support.
When I try to connect at WoW it says “unable to connect” but I chaned the realmlist and everything works fine :s
I cant get the Gurubashi Arena Event run. But the Hallows end event works and I have put it on the same time. Please help!
David T.@ ok, but what are the commands to up the rep? i dont understand
# Joe
Which database you are using ? if it’s the Unified database, you won’t see anything at GM Island :)
# KompressR
The core update mean the mangos update, and i always include the mangos core update on my release (you can see it in OriginalSQL directory) :)
# SiegeLink
Reaper-X, If I write a f.a.q about all the beginner problems would you consider putting it on this bloq?
Also when I reported a bug on the UDB forum they told me that it was a core bug, does that mean mangos?
Of course, because it’ll be helpful to everyone, just send it to my email address (btw full credits of course will be given to you) :)
Yep, if it’s related to core that mean mangos and that mean you’ll need to visit mangos forum directly ;)
Antar, Mat,
If you think you’ve done everything that is suggested in above posts by me and others.
Then maybe your on windows vista, which in that case try the UDB and not silvermoon.
none of the NPC’s at gmisland are loading for me. Any thoughts?
PLEASE HELP! When I run mangosd.exe it says
“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;manos”
Please please help. it also says that when i try and run the realmd.exe
Hello, when i run mangosd.exe it halts when Loading NPC texts, if i run it again it sometimes halts while loading items.
What could be the problem?
Tnx
it doesn’t matter what your patchlist server is; you won’t be connecting to the patch servers anyway. have you changed the server address in the database as well as in the realmlist.wtf file?
Stepback,
If you would like me to talk you trough it then pls give me your Yahoo mess or hotmail msn adress. I prefer yahoo.
o well it didnt work…cries*
SiegeLink~
set realmlist 127.0.0.1
“set patchlist 127.0.0.1″
Oh so maybe thats it. Thanks, I will try now ^>^
Stepback,
I,m doing a wild guess here, maybe you allready know this…
Click: mangosd.exe wait until it finishes.
Click: realmd.exe wait until it finishes.
leave the windows open.
In the mangosd window type: create StepBack StepForward
Then start WoW and use Name:Stepback and Password:StepForward to log in.
Also,
This is what realmlist.wtf must look like:
set realmlist 127.0.0.1
set patchlist 127.0.0.1
SiegeLink~
Yes, it is that file that i changed but, wouldn’t change the list in the game(or send me to the server).
Thank you. Need more info…just ask.
Stepback,
“other WoW list”
Do you mean that after you reopen the file it changed back into:
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
Maybe read only in the property’s of the file is on, You never know :)
That’s probarly not the case so could you be a bit more specific?
HI, I have a problem with the realmlist. I put the set “realmlist 127.0.0.1″ but, it still gives me the other WoW list. I think that is the only problem i got so any tips would be nice.
Alex, and others :)
I,m assuming that you gave the right data path for your maps which can be cheked by going trough the tutorial created by Reaper-X above carefully.
If you don’t have the burning crusade expansion pack installed then you must change expansion 1 to 0 in mangosd.conf
For reference here’s the number of files that are in my maps, so you can check if you extracted everything. (I have burning crusade, so that means more files)
DBC:176
maps:3492
vmaps:3299
Also please (next time) read trough some of the other posts above since most of these questions have been answerd more then once.
Ok i got threw that part but now when i try to start mangosd it says it cant locate vmap…
so what did i do wrogn now
Ok at part 3 after i typed my password it says “Mysql” isnt an external or internal blah blah blah… program. So what do i do so i can fix that
hey i noticed you said the silvermoon database only had the core update… which update is that, and where would i find the other updates?
I tried to put my server on lan but i couldn’t play and I got a error. then I got the connection thing whit mangosd what Alex said, and now I’m having the account_banned and old_unique things etc… :s help Reaper-X
Here’s what I did for rep (horde side + scryer)
update mangos.character_reputation set standing=x, flags=z where faction=y
flag is 17 for most everything I think, except where noted
Code Name Max Rep
(x) (y)
21 Booty Bay 42999
92 Gelkis Clan Centaur ?
93 Magram Clan Centaur ?
59 Thorium Brother51hood 42999
349 Ravenholdt 42999
369 Gadgetzan 42999
76 Orgrimmar 42999
530 Darkspear Trolls 42999
81 Thunder Bluff 42999
68 Undercity 42999
947 Thrallmar 42999
935 The Sha’tar 42999
729 Frostwolf Clan 42999
749 Hydraxian Waterlords 42999
889 Warsong Outriders 42999
510 The Defilers 42999
911 Silvermoon City 42999
922 Tranquillien 42999
932 The Aldor -3581 flag 3
933 The Consortium 42999
941 The Mag’har 43499
967 The Violet Eye 42999
942 The Cenarion Exped’n 42999
989 Keepers of Time 42999
1011 Lower City 42999
576 Timbermaw Hold 39499
934 The Scryers 39499
470 Ratchet 42499
529 Argent Dawn 42799
970 Sporeggar 45499
1015 Netherwing 84999
1038 Ogri’la ?
This will put you at exalted with everyone, except for Timbermaw. I found a wierd problem with rep on that faction. If you are at 14,999 of 21,000 revered and you add say 6000 points (which should put you to 1 of 1000 exalted instead you go to 1,399 of 1,000 exalted for some wierd reason.. if you take the 400 points off to go back to 1 of 1000, you drop back to 14,999 of 21,000 revered again… I can’t explain the behaviour.
I suppose you could mess with the numbers for the offending faction one rep point at a time and see what happens.
Also, the change doesn’t take effect until you log the character back in…
Hope that helps out…
Another great release Reaper… a couple of dumb questions maybe you can answer real quick :) I’ve searched all over the place and can’t find the answers.
1. How do you change the time shown in the server. My server time is several hours off the local time here
2. Can you rename a user’s login account. I tried the obvious method of changing the field in the realmd table but it just results in failed logins until I change it back. If it can’t be renamed, can the chars be exported somehow, a new login created, and the chars re-imported?
Thanks. DT
Says samething when i start realmd
Ok everytime i try to log in MySQL it saysCoult not connectto mySQL database at 127.0.0.1:access denied using password (password:YES)
Cannot connect to 127.0.0.1;mangos;mangos;mangos
Reaper-X can you help me please
anybody else getting the ‘outdated dbc files’ problem when they run mangosd.exe?
Reaper-X,
If I write a f.a.q about all the beginner problems would you consider putting it on this bloq?
Also when I reported a bug on the UDB forum they told me that it was a core bug, does that mean mangos?
But please cant you make a guide how to make Custom objects and so with Navicat or some program. Becose if you make a guide with Navicat I just download navicat follow your instructions and bang clear :D ….
omg I’ve got the acc ban thing back :s can anyone just send me the mangos and realmd database maps?
(give a link or something)
Reaper, Can you post a tutorial??? I dont know how to translate the quests and NPCs.
I have this files (traductions): items.sql, Npcs.sql, quests.sql…
done found it thanks to SiegeLink.
started to read the comments cause noone reacts and i probally overseen hes post :p
ooh forgot to say when. I’m getting that when i run the mangosd.exe.
the post about the banned acc etc i fixed but the 1 about mangosd.exe (my latest 1) not help pls :S
omg I’m getting:
Realm running as realm ID1
Using Rev 19 PSDB.
Using Datadir E:\WoW\data\
WORLD: VMap support included. LineOfSight:1, getHeight:1
WORLD: VMap data directory is E:\WoW\data\vmaps
WORLD: VMap config keys are: vmap.enableKos, vmap.enableHeight, vmpa.ignoreMapIds, vmap.ignoreSpellIds
Check existing of map file ‘E:\WoW\data\maps’: not exist!
Correct *.map files not found in path ‘E:\WoW\data\maps’ or *.vmap/*vmdir files in ‘E:\WoW\data\vmaps’. Please place *.map/*.vmap/*vmdir files in appropriate directories or correct DataDir value in the mangosd.conf file
I think I have some problems: I forgot to patch, now I did I extracted everything, but if I turn on the reaper-x-mangos is says path… all ok then the password I type it enter and then choose 1 and then I get some things whit old_unique and acc banned… but I still get the choose of the 2 databases so iI choose 1 of them and then it says please wait it’ll take a while o import the database
press any key to continue…
is that normal or what? cause i looked in the directorys and there are files in the mangos and realmd maps but I don’t knwo its all of them :S
ooh ok thanks for letting me know :)
I’m not looking in every map so i didn’t knew it was there :p
Sorry to double-post, but i just read up and noticed that i didn’t need to re-extract the maps, vmaps, etc. oops. :P But i’m still getting that ‘outdated’ error. Any ideas?
hey, I’m having a little bit of trouble with upgrading to this release. i was using 4577 before, and i’ve extracted it, installed the db, and run all the batch files to update the maps, vmaps, and dbc files. unfortunately, when i run mangosd.exe, i get a message saying that my dbc files are outdated. i ran the new extraction files from the 4651 release, but it still doesn’t work. where have i gone wrong?
ohh, i see it now lol…. the thing is its not my server, i am a developer on the server, and as much as the owner would change it for me he rather wouldnt :-(
is there a way to do it in the database??
-Reaper, if there isnt i think it would be a good thing to add to the next release (unmodded)