Custom Search
Mangos 4629, ScriptDev2 150 with Silvermoon 18.5 and UDB 0.8 323 support 2.2.3
Posted by Reaper-X Oct 23 2007 1:06 am
Another Mangos release time, and this time i choose to include two database again (Unified Database 0.8.0 Changesets 323 and Project Silvermoon 18.5) unlike my previous Mangos 4602 release so you can choose which database you like best :)
Other than that, in this new release it’ll only support WoW 2.2.3 Client only because Mangos has officially support the 2.2.3 client (which mean there won’t be any er. So to those who are still using the old WoW 2.1.3 client, you’ll need to upgrade your WoW client first into patch 2.2.3 :)
As an important note, if you want to upgrade safely from any previous release (especially from my old 4488, 4505, 4524 release, etc). Make sure to copy the backup file (backup-db.sql and backup-realmd.sql) from the reaper-eazy-mangos directory into somewhere else first, so if anything goes wrong at the upgrade process you can still restore it (although i’ve done everything possible to make sure you don’t lose your character data)
And here are on how to use it :
Requirements :
1. MySQL and it’s install guide
Update : Mangos 4651 has been released … and i’d suggest you to grab the new version instead ;)
2. Reaper Mangos 4629 with the Database (15012 KB) :
Reaper Mangos 4629 | ScriptDev2 150 | UDB 0.8 323 & PSDB 18.5 | RapidshareReaper Mangos 4629 | ScriptDev2 150 | UDB 0.8 323 & PSDB 18.5 | Megaupload
Fresh Installation :
1. Extract the self extracting archive somewhere (or you can also choose to extract to current directory) and don’t worry it’ll automatically create ReaperMangos4629 folder for you :)
2. And then you’ll need to extract Maps, VMaps, and DBC files from your WoW 2.2.3
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 (and no it’s not your mysql.com account password) ;)
5. Now you’ll need to choose option number 99 as shown on below image
6. After finished with the above process, now you just need to choose option #4, and adjust each option accordingly (as a side note, the most important thing is your datadir location)
7. 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
8. The first thing you should do of course run the mangosd.exe and realmd.exe and 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 :)
as a side note, if you can’t choose Blood Elves or Draenei, then you just need to type setbc username 1 at the mangosd window ;)
and here’s a screenshot taken using Unified Database
Upgrading from 4602 Release :
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 (or you can copy the previous mangosd.conf if you’re upgrading from 4577++ and already have the DBC files extracted from WoW 2.2.3) :)
Upgrading from 4577 Release :
1. Run the reaper-x-mangos.bat, and then go with option #98 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. After finished restoring your data, now you just need to choose option #99
6. For the last step you just need to continue with configuring datadir (If you’re using ReaperMangos4577 previously, or you can just simply copy the previous mangosd.conf and realmd.conf) :)
Related Links :
Creating 2 Realmd in Mangos
Mangos GM Commands
Creating Private Server for Lan Party
Just like before if i miss anything just let me know :)
and here’s another screenshot showing nether drake in Silvermoon City
Trackbacks/Pingbacks
- Reaper Mangos Mod 4651, Scriptdev2 151 AHBot with JailPatch and Unified Database » Reaper-X .:[ ID ]:.
- WoW Mangos GM (Game Master) Commands » Reaper-X .:[ ID ]:.
- WoW Mangos GM (Game Master) Commands » Reaper-X .:[ ID ]:.
- Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3 » Reaper-X .:[ ID ]:.
Leave a response
Connect with me
Dan-bulfon,
I don’t know how much knowledge you have about things so I,m gonna type things step for step.
First of all if your using vista, turn user account control off, you do this by going to search which is in start and type: account, go to user account and you see a option there to turn it off.
Also when you don’t have burning crusade you must specify that in the mangosd.conf by opening it with your notepad and turn the line Expansion = 0 into 1.
Also! :(
Best way is to put the three extracted maps in something like this –> c:\wowmaps
Then when you choose option 4 in mangos you type c:\wowmaps
You can also check if MySQL is working by going into the command prompt, and then type mysql -u root -p
If its working you get something like welcome to mysql monitor.
If not then go trough to the config wizard trough start menu.
OK i checked out the ports theyre all 3306 and im still being told that mangosd and realmd cant connect wat do i do i dont even know if i go tthe path to them right anyone got a pic of that part when u gotta do the path would probly help me make sure i did that part right i g2g to school be back later thank u for the help
Hi,
Just wanted to say that mangos 4602 works with VISTA.
Hoooooooray!
thanks joe ill try that after school
yeah…i was only getting like 2615 of the vmap files…i think i know what i did wrong, just not sure
i was kinda confused about the C:wow\data\ thing.. That means i open the drive HP_PAVILION and make a new folder called WoW, then put a folder in that called data right?
as for fixing the vmap problem (just re-extracted it and finally got all the files) the first 2 times i did that..i was being impatient and thought it had froze at the end =\ so i shut them to early..
after which i let it run all the way though and got an error (cant remember what it was called) but i didnt have the Map folder or the DBC folder with it (they were in the WoW/data/ folder)im guessing that was the problem because when i placed them back where they were extracted from and re-ran the vmap file it worked (no errors)
so im all set for now…ill have to put them back in C:\WoW\data and see if the mangosd will run properly =)
great guides BTW…without them id have no idea what im doing XD
i meant the solution, i ahve everything upto date i have all the files where ur guide tells em to put them and nothing is happeneing just an empty map folder, it always says that its habving an error opening the patch files and crap like that
hey, the map extracotr isnt working, i said this before bu got no reply to what i was asking….the ad exe, and the extractor itslef arent working…..i tried all teh ad.exe uve posted and none fo tehm work culd u pls tell me the problem ty
*Meant to say a Acsent Core, lol.
I’m really sorry for late reply because i’ve been sick for the past 4 days (in my local time GMT+7 of course) .. and still not fully recovered yet :(
# Sully
Actually i’ve changed the compilation options this time (which also going to applies to the next release) to make sure it’s working on your machine too :)
# Unfear, and Joe
As Phen said, that if you already created custom items, you’ll need to backup it first (btw i also use custom items as you can see on the screenshot) but i always make sure to backup the custom data
# KompressR
1. Yep, otherwise mangos won’t even run at all because of the new database structure (for example like error in creature_template table) :)
2. Of course, i always make sure to integrate the scriptdev2 :)
# xXWoWXx
if you already created the sql file for that custom item, you just need to type :
mysql -umangos -pmangos -D mangos < your_custom_item_filename.sql
that’s it :)
# WaveMaster
Ah … you’ll need to wait for the vmaps extraction to complete (it’ll take a while depending on your computer specs, from 45 minutes to 2 hours or probably more)
First of all, I would like to thank for the great wwork so far, really helps and makes a rather complicated process easy lol. Secondly, I would like to know whether it would be possible to provide a guide on how to establish a Ascent database using the NCDB Milestone database. I did some some research and aparently it is the best. Just interested lol.
yeah i fixed the problem…though now i seem to be getting a different problem (related to the vmap files) that i posted on that guide
dan make sure you set the port on mysql to i think
its 3306 somehow when i first installed it it was 3307
I need HELP PLZ i got everything done but when i try to run the mangosd.exe and realmd.exe it says cannot connect to database help would be loved very much please and thank you
You have to change the extract.bat like this
@echo off
mpqe /d “.” locale-enGB.MPQ *.dbc
mpqe /d “.” patch-enGB.MPQ *.dbc
mpqe /d “.” patch-enGB-2.MPQ *.dbc
ren DBFilesClient dbc
pause
GL
How do i import custom items?
couple questions.
1. when i tried used the psdb with a previous release i had to apply a bunch of updates from the updates folder to get rid of a bunch of errors. are these updates already integrated when using your installer?
2. is scriptdev also automatically integrated? if not, is it just a matter of importing the scriptdev databases?
thanks.
hey sorry for all the posts in a row i can get the
the objects i added to show up if i edit the game objects table in the database and change the value for animprogress from 0 to 100 for each custom object every time i add a object i get the error message from 2 posts above on the mangos for now i can just keep editing the file thanks a lot if anyone has a solution
oops thats a 2007 not 20007 and by custom objects i mean objects from the game added where i want ex. .lookupitem tree .addgo one of the code that came up for tree then i log on later and its not there and i am sure i am looking in the right spot cause i added a tele
alrite now when i am making custom objects i log on the next day and there gone or the next hour
i think its related to this from mangos “SQL-logging is disabled – Log file for the SQL commands could not be openend: 20007-10-23_logsql.sql”
Thanks for the help
Thanks Phen and sully i will do that next release
for now i just have to rebuild my house:P and my friends houses
i did that and the map extractor isnt working at all
all those are done..on my router and firewall but it still doesnt work
All installation worked fine but when I started WoW I got critical error “Interface.MPQ” not found. Never had this problem with previous releases. Anyone knows where I can find this MPQ file?
i keep getting “This application has failed to start because MSVCR71.dll was not found”
ive re-installed but still get the same thing when i try to run ‘mangosd’ and ‘realmd’
Big Glog (named enemy in SW)
I notice today a whole load of level 70 enemies in Stormwind at the entrance. These appear not to be in “official WOW” nor can I find any mention of them on Project Silvermoon. Yet they are there.
Has anyone else had these? Maybe a Halloween joke?
(Running 4629 Project Silvermoon DBC)
Simon
Hello,
I have a problem with installin data base. When I running 1 option (installation) and when i choosed
witch database to install, it starts to install but… Might i have something with my comp becouse during the installation the progress stops.
showing me many-many numbers. i was waiting 1 hour
but nothing happen. I was playing with mangos 4577 but higher releses make same thing.. allways stop during importation of database..
I dont know what do to couse i had allways 1min database installed.
Any advice?
Thank you so much
Reaper
Very nice job as always, one thing that i ask, can you include the ah bot patch in your next repack. Im sure alot of people not including me would like to have a ah bot for their server.
Thanks,
Jordavious
Joe, Unfear:
If you create custom items, vendors or teleport locations (or anything else) you have to export the relevant data from the database before you update, and re-import it again afterwards.
This is fairly easy if you use a database client like Navicat.
For example, I created custom items: They are stored in the items_template table. I export them into a TXT file, delete all items from it that I did not make, and use the import function on my TXT file after the update is fully finished.
The only challenge is to find out in which table your information is stored so that you can export it, but that only involves a little searching.
I don’t think you can recover your customs if you never backed them up, but I am not exactly an expert.
I hope this helps for the future at least.
Thanks for all your work on this! One question on the upgrade procedure above. I’m currently running 4535. Can I upgrade to 4629 directly, or do I need to go to 4577 first in order to use your batch file above. (Opt 98, then Opt 99)
I’m currently running the 2.1.3 client too, so I’ll have to upgrade that side as well…
Thanks again for your help!
Yeah I have the same problem with the error:0 thing, how do I remove the sql from the 3306 port its using, I suppose it’s caused from the older mangos I used?? How to get that out the way to make way for this new MySQL? Thanks.
all I want to know is how the hell did you get those databases? there huge I know you didnt make them or were they like farmed from the server? I’m interested in these kinds of things. O_o?
you would need to back up the item and vendors table if you dont want them removed when you update (the installer will remove them)
youthink this one might work? i doubt it but i will try this week
yeah i lost all my custom objects and vendor\creature spawns not sure if i did something wrong or if thats going to happen everytime i update to latest version
Everything work nice, but im lost all my custom shops and everything what i made in game. And still GM island is whithout vendors like in Mangos 4602 release.
Any suggestion here?
How should i decide which database to use?
what are the main differences? and Thanks Alot
I installed, and it works! Except for TBC. I’m not able to create and Blood Elf or Dranai characters. I’m also not able to go into outland. It says I need to have TBC installed, which I do. Any ideas? Oh and the allow server to use expansion content is enabled.
Ah! Poor you! Be sure to get well again before you do anything at the computer.
I hope you’ll feel better soon!
Best wishes~!
I know reaper = god but, some issues. I cant make ANY tier vendors on psdb and i cant trade the gladiator gear vendor or this other 1 =P And 1 that’s allied called ” Destiny Tier ” Please help if possible. Thanx =D
Thank you very much everyone :)
# Sully
Try using this one, and let me know ;)
# confused
First you need to make sure that port 3724 isn’t blocked by your firewall, also if you’re behind router, you’ll need to set up some port forwarding rules too especially on port 3724 and 8085 (or any other port you used if 3724 gets blocked);)
# Chris
Ah you’ll need to edit the .bat file inside the dbc extractor and replace the enUS into enGB :)
# Phen
Haven’t tried that one yet but i’ll test it later when i have fully recovered :)
as a last note, i’m really sorry if there are any other questions left unanswered because currently i’m not feeling too well / sick for about 3 days now and need to get some rest
reaper, post the AMD one for me
THANK YOU! REAPER = GOD!
I changed from UDB to Silvermoon and now I do have my weather back! :D
… But the Silvermoon database does not seem to work so well with WoW 2.2.3
On startup and character loadings it gives me scary messages about not finding locations and spells and deleting them.
Well, I simply wanted to update you (or anyone interested) about this. Perhaps people other than me have weather issues too?
Nice work as always.
You totally ROCK :)
great new guide!
Thanks for the update! It all worked out beautifully. <3
But I still don’t have any weather. D:
It is definitely enabled, and I checked the interval too, which should be okay.
The .wchange command does not work.
Now, I am wondering if the weather system has to be started at MaNGOS startup?
It does say it loads the weather definitions, but I can’t see any message like “WORLD: Starting weather system”
Should that be there, though?
It may seem odd to be going on about a detail that does not affect the actual game play but to me these effects contribute about 20% of the fun, so I’d be really extremely happy to learn of a solution.
Many thanks either way!
its me agian ,and im trying this and its not loading up the maps again, it keeps okin for enGB files and i dunno where to change them from plz help
good job reaper very nice :)
hey i just got this latest one and its awesome!:) but i still cant get it online…it never works….i got the no-ip.com thing and its set up in the .bat but when other people try to get on it just says “cant connect”
put link to AMD one plz!