Custom Search
Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3
Posted by Reaper-X Oct 15 2007 6:47 pm
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 :
Mangos 4602 + Scriptdev2 145 with Unified Database 0.7.5 Changeset 319 | 9.36 MB | MegauploadMangos 4602 + Scriptdev2 145 with Unified Database 0.7.5 Changeset 319 | 9.36 MB | Rapidshare
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) ;)
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 ?) ;)
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)
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
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 :)
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) :)
Related Links :
Trackbacks/Pingbacks
Leave a response
Connect with me
ok, well from what that says it looks like MySql is ready for mangos to connect… you should look and make sure the realmd and mangos databases look like and that they are there… if not you will need to reinstall mangos, but if the databases are there then it might be a bigger problem…
Xp bar vanished.
Hi – I have been testing my server and found that the xp vanished at 70 then reappeared at 71. All good.
However it has done the same thing at 88. Is this normal? Thanks
Here it is:
InnoDB: The first specified data file C:\MySQL InnoDB Datafiles\ibdata1 did not exist:
InnoDB: a new database to be created!
071019 18:15:21 InnoDB: Setting file C:\MySQL InnoDB Datafiles\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
071019 18:15:21 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait…
071019 18:15:21 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071019 18:15:23 InnoDB: Started; log sequence number 0 0
071019 18:15:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.45-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
it seems to me that it can’t connect to the realmd database on the sql server, if i were you i’d rerun the easy-mangos.bat file and reinstall the database after backing up characters….
anyways reaper did you recompile the Ad.exe too or just the mangosd.exe and realmd.exe?
Ok so now everything works even the lan server (sort of) But when i open realmd.exe it still says it’s connecting to 127.0.0.1;3306 and idk what happened when i type in that message in cmd it worked fine but now the realmd isn’t working.. So how do i change it to connect to my server?
So, my realmd.exe file stopped working so i now need a fix for that and the server the error i get is something like:unknown host:127.0.0.1.3306
And the other error for lan connection will be l8r im on my laptop. Please keep me updated i am on pacific time so…
bat yeah about Ad.exe did you recompile that too? cause i need to beable to extract the map files on windows 2000 and I wanna make sure everything will work
i like megaupload but rapidshare works
glad to hear that :) .. as a side note, previously i tried uploading to mediafire, and lots of people complaining they can’t download from it :(
and guess what ? i tested it directly and … i can’t download my own file either from media fire :(
but it seems that most people dont really have problem with rapidshare so i decided to upload it there :D
and btw YAY, it works!! it yelled at me cause i didnt have the maps and vmaps but it still didnt give me a windows error!!!
did you recompile the ad.exe too?? i see it in there but i dont know if its the old one or not
BTW i hate rapidshare lol
ok thanks!
# Sully
Use this one, btw don’t forget this is binary release only that mean you’ll need the 4602 version included in this guide first and replace / overwrite the executable from the original 4602 with this one :)
http://rapidshare.com/files/63898857/ReaperMangos4602BinOnlyNonOPT.rar
hopefully this can help you solve your problem
BTW for anyone who needs the DLL file [MSVCR71.dll] (for win 2000) its here:
http://www.megaupload.com/?d=MI4FOFRF
and ok thanks, i hope it works remember AMD athlon lol… I will keep checking this page (jut put a comment with the link to download it)
it says AT/AT compatiable
its a AMD Athlon 950 MHz processor
hang on i will check the type of AMD chip now
another update:
when i run realmd.exe (before and after i run mangosd.exe) i get the same error as i do when i opened mangosd.exe
The Program realmd.exe has generated errors and will be closed by windows. You will need to restart this program.
# Sully
Actually that dll (MSVCR71.dll) is included with .NET Runtime 1.1 :) that’s why i don’t think its necessary for me to include it
btw it seems from your description, your computer is running AMD 950 which is a Thunderbird (if i remember it correctly) so probably i’ll need to compile a new one for you
as for maps and vmaps, you’ll need at least 2.84 GB
EDIT: btw i’ll post here when i’ve uploaded it :) (you just need to overwrite the executable from the 4602 with this one, because im not include the sql to make uploading process much faster … because well .. erm im using slow connection lol)
ok, i dont have the maps directory or the vmaps directory but i downloaed your DBC directory…
i put it in C:\reapermangos\data
and i got the dll
then i installed mangos (the database stuff)
and tried to run mangosd.exe
it opened and it got to the line that said it was using the DBC files and the release etc.
and i screen came up:
mangosd.exe has created an error, you will need to restart the program.
is this cuase i didnt open realmd.exe first??
let me know what you think!
i got an AMD 950MHz
ok, well thats good…. i had to download a .dll file cause you didnt add it to your pack (win XP has the dll file win 2000 dont)
(btw the dll was for running mangosd.exe and realmd.exe)
i still dont have the maps extracted cause I deleted wow… but I will just extract the maps at a friends house and put em on a DVD — one question, how big are they?
Actually as long as you have .NET 2 and .NET 1.1 installed i think it should be fine :)
btw what is your processor ?
ok, well since i gt windows update, and was updated to the max I have .NET framework 1.1 and 2.0…. 3.0 is for Windows XP only
what should I do?
are yuo for real? ohh god… I just trashed my whole WoW because I was geting errors when I ran wow… so now I got to reinstall it… ok, well cant wait to waste my day again :-).. maybe i can find something to restore files i deleted?
well let me get started installing .net runtime
Followed all the instructions on your site for setting up MySQL, extracting maps etc… Then followed the instructions here…
Just wanted to say WORKED LIKE A CHARM!:)
THANK YOU!
# Merijn
I’ll release new update soon, because mangos has officially support the 2.2.3 client :)
# xXWoWXx
I’d suggest you to take a look at .err file inside your mysql directory, and tell me what’s the error message you see there :)
# Sully
Do you have .NET Runtime installed ? (for the easiest way, try installing .NET Runtime 1.1, .NET 2 Runtime, and .NET Runtime 3) :)
also you’ll need at least 2.87 GB free space ;)
# wow
Actually you can put it anywhere you like, as long as you don’t forget to change the datadir to where maps,vmaps, and dbc directory (and all of it files) can be found :)
Is it ok o put the maps vmaps etc in the Data folder of the World of warcraft?I tried that and it loaded everthing in realmd.exe and mangos.exe and i tried to log on and it said offline.help
****typo, with (in the last sentence) should be when
ok, i finally downloaded it and installed WoW… it took like 5+ hours… what a waste… :-(
I installed wow and connected to a private server just so it could make all its files, ok everything was good, then I copyed ad.exe and the extract bat file thing and opened the batch file (the one that runs ad.exe and makes the maps folder)…
It made the folder and loaded the files, but as soon as it started to proccess the files a windows error came up: Ad.exe has blah blah blah…
i am unhappy….
in case it matters I am on Windows 2000 Pro. with all updates on a 950MHz 512 Ram computer
please explain what I should do, I ran repair.exe like 3 times and it still had an error with I ran ad.exe again :(
please help me
ok well it did stop and says at each line with this */ . does that mean its finished and the installation worked?
Now it wont even let me run my server.. this is being stupid i really hope u can help me SOON!
… it will not let me sign on to mysql and when i try to start a new service it says cannot restart service error 0 so.. help or not.? if u r i need it soon bcause none of that other stuff worked and now it’s just being gay saying i cant log onto mysql. HELP!!!!!! FAST!
OMFG NOW IT WONT EVEN LET ME TYPE MY ROOT PASSWORD TO LOG ONTO MYSQL! HELP ME PLZ!!!
I have just ran the reaper-x-mangos.bat and it says cant connect to mysql server on ‘localhost’ when i try to use the #5 option to set up fro lan party. Help again…
i download the reaper thing and started reaper-mangos.bat and when it asked me for the root password i typed it in (i had to change it to another one) it gives me a bunch of number without stopping.
still won’t work now it says my thing when i type select * from realmlist; then it says that i set my ip to YOUR DESIRED REALM NAME | YOUR LAN IP
HELP!!! and i still get teh same message when i do the ‘harder’ way that u told my it still say incorrect sql please use the manual that came with your mysql version to fix this problem HELP MEEE!!!!!
and since no one posted about it yet, when I extract map files do i need 2.2.3 or can I just use the regular WoW TBC? (like 2.1.3)?? Please, someone post and tell me!
and sorry for the double post but, after I extract the maps and the database files, how big will the maps, vmaps and dbc directories be? cause i am low on space
Hey reaper, nice site… I am in the middle of installing WoW and WoW BC on a computer (so i can extract the maps) then i will delete WoW and set up my server!! (if you can let me know when your going to release the next package, cause I can’t wait!)
DBC Files extracted from WoW 2.2.3 enUS Client rapid link please :(
Hey Reaper can you explain me how I change the ingame message .announce –> system message to .announce my nick ????? thanks :)
reaper how can i ‘put’ silvermoon in my server
i have the newest database but dont know how to use it
greetings
Ty
try following the above step to go into your command prompt first :)
Follow the step to go to command prompt and when you’ve logged in into mysql type this
UPDATE `realmd`.`realmlist` SET `name` = 'YOUR DESIRED REALMD NAME', `address` = 'YOUR LAN IP' WHERE `realmlist`.`id` = 1 LIMIT 1;
but i do n ot know were the sql querry is
# Jordavious
Technically i believe that the system message is considdered a world chat. if that is so then you can only change it in the mangos sorce. and you can only do that by compiling mangos yourself. This might be a difficult task for you if you dont have any experience with programming(c++, vb.net) but there are instructions on how to do that at mangosproject.org, i would explain it to you hear but i dont think reaper-x would appreciate that.
ah … you don’t need to worry about it :)
# Grady
You can see each column description from the itemprototype.h , or if you prefer to see it directly, i just paste the content of itemprototype.h to pastebin ;)
http://pastebin.ca/741889
# xXWoWXx
I’d suggest you to open the reaper-x-mangos.bat directly and then copy paste the sql query used and execute it directly from the command prompt :)
1. Open command prompt
2. type mysql -umangos -pmangos -D realmd
3. and paste the sql query used from the batch file ;)
sorry it took so long i had band practice. My mysql version is 5.0 community free edition 42.0 megabites is the size.