Custom Search
Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!)
Posted by Oatman May 26 2008 10:51 am
Hello Everyone! Here is another one of my releases for the Reaper-X-MaNGOS-WoW Developement Project. In this release I have looked through my previous bugs/errors and have cleaned them out and I am almost positive that they all have been resolved. So if you have any questions comments or concerns please leave us a comment, when you do myself and the community will be glad to assist you!
Updated in this Revision:
- Completely re-done fishing loot template.
- Fishing base skill level table added
- Lots of Black Temple updates
- Loot added for creatures that are mineable and gatherable
- Rewards added for quests with quest flags|512 (Quests like Teron Gorefiend I am!)
- Many quest fixes in general
- 175 fishing holes added (like school of fish) with loot
- Instance loot tables updated:
- Zul’Farrak
- Sunken Temple
- Black Rock Depths
- Dire Maul
- Black Rock Spire
- World drop loot tables for levels 1-34 created (SIGNIFICANT decrease in creature_loot_template size again. All world drop tables are now created. Loot table size before world tables ~950000 rows — after 284594 rows. ~7mB instead of ~22mB)
- Some 2.4.2 related item changes
- L70ETC spawns / event included in the DB (still need the ACID script from the ACID team)
- Fresh Installer Fixed!
- Map/DBC Extractors Fixed!
- ACID Included (Means Extra NPC’s and Such Have Been Scripted)
- MaNGOSD.exe Errors Should Be Fixed!
- Authentication Bug Should Be Fixed!
- Vendors/GM Island Vendors Should Work Again if you Enable them by Going Into the Reaper-X-Mangos.bat File.
- NO MORE EXE’s! I have decided to keep them in Batch format due to complaints about Errors/Trojans.
REQUIREMENTS:
1. MySQL Database and the Guide on how to Install MySQL
2. World of Warcraft Client version 2.4.2
3. Updated DBC’s, VMAP’s, and MAPS Updated for 2.4.2!
DBC’s are already included as part of this release! Also if you already have the 2.4.2 DBC’s, Maps, and VMaps then there is no reason to extract them again.
4. Reaper-Mangos Server :
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | File Beam
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Rapidshare
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Mega Upload
Reaper Mangos 5953 SD2 414 (UDB ONLY) FULL | 16.6 MB | Media Fire
Update:
Davtex from www.blitz.sk have uploaded vmaps and maps extracted from WoW 2.4.2 so to those who have problem perhaps can try downloading the extracted maps and vmaps files by Davtex ;)
2.4.2 Maps:
- http://rapidshare.com/files/120427182/maps.part01.rar
- http://rapidshare.com/files/120427405/maps.part02.rar
- http://rapidshare.com/files/120427402/maps.part03.rar
Vmaps from WoW 2.4.2:
- http://rapidshare.com/files/120495428/vmaps.part01.rar
- http://rapidshare.com/files/120495485/vmaps.part02.rar
- http://rapidshare.com/files/120495478/vmaps.part03.rar
- http://rapidshare.com/files/120495532/vmaps.part04.rar
- http://rapidshare.com/files/120495474/vmaps.part05.rar
- http://rapidshare.com/files/120495501/vmaps.part06.rar
- http://rapidshare.com/files/120495246/vmaps.part07.rar
Thanks to Davtex for uploading the maps and vmaps files
Custom Vendors Pack
http://filebeam.com/ba76aee3d934e0ab9d7e2f7c4d40452a
Credits to Firane for creating the Custom Vendors Pack
DBC and Maps Extractor:
Just in case the included ad.exe (map extractor) and dbc extractor isn’t working for you (like you keep getting message about maps or dbc file is not compatible), you can try using this one:
DBC and Map Extractor (131KB)
That archive just contain only one file (ad.exe) … and all you have to do is just put it into your WoW installation directory (where wow.exe and launcher.exe can be found) … and delete maps and dbc folder there if exist and then run the new ad.exe … and it’ll extract the maps and dbc files automatically (the output will be in maps and dbc directory)
Fresh Install:
Important Note : Fresh installation will overwrite your database
1. First you’ll need to install MySQL
2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
(You can safely ignore the Patch-2, or any not found xxx-2 message)–This only happens if your extracting from patch 2.4.0
3. Run the reaper-x-mangos.bat inside the reaper-x-mangos folder, and you’ll see something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)
4. Selection Option 1 by pressing “1&Prime on the keyboard and pressing enter.
Note: This will wipe out any previous versions of WoW you have in your database.
6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …
Replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
With :
set realmlist 127.0.0.1
and then save it and close realmlist.wtf File.
7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account
By the way, if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :
create username password
to create the account
setgm username 1-3
to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)
8. Finally if you have Burning Crusade client installed and want to be able to create Burning Crusade specific character, all you have to do is just type :
setbc username 1
to enable burning crusade expansion for your account :)
Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.bat to adjust it :)
Upgrading from 5953 Release:
1. Re-extract vmaps, maps and dbc because this version no longer supports the old World of Warcraft 2.3.3 installation and only supports the new 2.4.2 (YOU MAY SKIP RE-EXTRACTING IF YOUR DBC’S, MAPS, AND VMAPS ARE ALREADY FROM A 2.4.2 CLIENT!)
2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos. Next I recommend opening the batch file and backing up your character data. This is optional though.
3. Open the Folder called “Upgrade” and run reaper-x-upgrade.bat.
4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located.
5. Then make sure that you are upgrading from the latest previous version or else you WILL corrupt your database and possibly lose your character data.
Guide on how to Edit Mangos.Conf
Thanks for the Mangosd.conf edit guide Jeremy!
First off make sure that you have your MySQL running before doing anything.
You need to go back into the reaper folder (C:\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos)
And run the batch file called reaper-x-mangos, there is an option there to setup your LAN or IP for use, This new batch file does correctly setup your DB to the IP you enter in this batch file. Once you’ve done that, if you haven’t gone back in to edit the config files in your reaper folder mentioned above, you need to do that, there is a section in there with this.
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”
This is an example of waht it may look like. You need to change this to the path where you put your data folder with the maps, vmaps, and dbc’s.
Second, …
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database – use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database – use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;characters”
Above, you need to change the MANGO;MANGOS to your root DB name, likey it’s just root, and YOUR batabase (DB) password (you should know this)
YOU DO NOT CHANGE THE IP’S here or in the realmd file, ONLY THROUGH THAT BATCH FILE, i mentioned above. (that file does it for you)
Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.
Hope you enjoy this release if you have any questions feel free to post them as a comment below!
Connect with me
thyll,
It looks as though you do not have the correct values for your username and password when you run the reaper exe. The user (usually “root”) and the password are what you setup when you installed MySQL.
hi, I have a problem:
In fresh installation I have this error during the 1 step of the reaper-x-mangos…
error 1045 (28000): acces denied for user ‘-p(password)@localhost using password: NO
mysql: unknown option ‘-D
mysql: unknown option ‘-D
someone can help me?
Hello there,
First I would like to say Thank you for your help on this project, I have been a silent fan as well as user for a long time now.
I currently have 5953 installed and working. Just with a few problems… First, I if I create a second character on the same account, the log in screen shows no characters. if I only have one toon, all is fine…
Second, I cannot attack any of the mobs, anywhere. This means in instances, outside, pre bc as well as bc. Also I cannot interact with any npc’s… no flight path guys, no bankers, no quest givers.. they are there, just cant select them or “talk” to them.
lol other than that.. it seems to be running great:)
Any help would be greatly appreciated:)
Jas
Could you reinstate the .fly command? pwease? :D
oh no config editor :(
Hey Oatman.
I did a fresh install and everything worked fine. But I still get the .0004331map error when starting Mangos. I have tried the new and the old ad.exe. The installation from reaper-x bat worked fine and MySQL and realmd are working fine also. What should I do?
Hi
Can anybody help me plz. Im getting an error of the wow gm island stuff in line 24. Can anybody plz help.
Thx
Evok3r
Hi
I cant get the gm island to work can anybody direct me to a tutorial.It says that there is an error at line 24.
Plz Help
Evok3r
Upgrade successful. :D Thanks, Oatman.
#SGT Mac
You need to be on a GM account.
If you have not done so yet, go to the mangosd.exe prompt and type “setgm YOURACCOUNTNAME 3″ (without quotes and using the name of the account you use).
Then, from inside the game you type “.lookup item Verdigan” If it comes up with more than one result you look through them for the fist, because you need the number given.
Next you type “.additem HEREGOESTHENUMBER” substituting the number you just looked up.
This should put the item into your inventory. :3
Error in item_template table, probably sql file format was updated (there should
be 140 fields in sql). ?
Thanks Freze
I’m RATHER new to SQL so how do I “grant” myself the reward?
#SGT Mac
I find that if a quest is hoplessly glitched and I feel I spent enough time on trying to get it to work, I deserve the reward so I simply grant it to myself. ^^ Just a thought.
Just wanted to say cheers for the hard work Jared! It’s much appreciated on my part, and I got this release working flawlessly first try.
#Phen
Thanks for the rapid response. The last version I had was 2.3.3 before I was given a trial version of WoW , which got me even more addicted. I HOPE that the quests that were glitching on me before were fixed, I would really like to get my hands on Verdigan’s Fist.
I still get this error:
‘mysql’ is not recognized as an internal or external command,
operable program or batch file.
‘mysql’ is not recognized as an internal or external command,
operable program or batch file.
‘mysql’ is not recognized as an internal or external command,
operable program or batch file.
Please wait it’ll take a while to import the database
Press any key to continue . . .
#SGT Mac
As I understand it, you only have to extract them again if you did not already do it for the 2.4.2 version of WoW. (Like, if you installed the release a few days ago you would already have those folders in their correct version. They did not change.)
I’m still having the problems and I cannot figure out how to change my MySQL user nameor fix it, it still says access denied @ 127.0.0.1 for username root, root is the username and I AM using the correct password =( idk
Probably a really stupid question, but…
It says “Upgrading from 5953 Release:”
This IS the 5953 release, no? So do we upgrade from 5953 with this or from 5472?
Just asking before I mess things up. ^^
So, do I HAVE to extract the DBC’s, maps, and VMaps or not? In the fresh installation instructions it says to do so, but in the note before is says not to. And if I don’t have to, would you recommend still doing so? Thanks, and hoping for a speedy recovery for reaper-x.
Excellent work as always Oatman.
Just one question…….Although the sunwell npc’s are not spawned, is it still possible to spawn Kiljaeden’s full loot table? The legendary bow looks awesome hehe.
Oh and is there a replacement for “.addspw”?
Many Thanks
Diesel
Downloading now, and i had no issues with the previous release what i did was installed it fresh then ran the update and it worked flawlessly, except for the vendors and gmisland ofc
*5951 is meant to be 5931, oops!
Hello Oatman,
Thanks so much for the quick update, I didn’t expect that!
I have a small question though – only started playing with this private server stuff recently. My boyfriend and I have been working on a nice lightweight interface (we find it impossible to play with default Blizz interface – but I digress) since I got my server upgraded to 5951. So my question is, would upgrading it to 5953 mess all our work up? I know new WoW patches often mess stuff up, but I have no idea how these upgrades influence these things..
Sorry for the silly question, I really have no clue. :) Thanks again!
I just have to say you are the best! IMHO
Madmax said:
Hello when i try to install the optional GM island vendors i get the fallowing error
error 1136 (21s01) as line 24: column count doesn’t match value at row 1.
I’m having the same error, I think that happens becose in the new SQL Table called npc_vendor there is a new column called ExtendedCost, and the SQL structure of the vendors are build like the old one without that column, I just tried to add it with the mysql query browser steep by steep and just including in the row a ,0), more. And it worked. Lets look the example –>
INSERT INTO `npc_vendor` VALUES (500000,16677,0,0),(500000,16679,0,0); –>[here i get the Column count dosen't match value count at row 1]
Ok thats the old structure, i just changed that –>
INSERT INTO `npc_vendor` VALUES (500000,16677,0,0,0) , (500000,16679,0,0,0); [WooT! it works now!!]
If you see there is a “,0)” more, why that? becose in the new npc_vendor table there is one more column the ExtendedCost. I think that the solution is just to ad that ,0) in each of all the npc_vendor values but… I dont know if there is some “automatizated” way of doinf this… its kinda “hardcore” to do it with your own hand.
reaper gave us a PS only custom vendor and then didn’t give us the PS DB. Ironic?
Well I did a workaround and got a file to load into the UDB for custom vendors so ill put it up for DL on like filebeam in a sec.
i logged and restarted realmd and got this
2008-05-26 00:42:54 ERROR:SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = ‘1′
2008-05-26 00:42:54 ERROR:SQL ERROR: Table ‘mangos.realmlist’ doesn’t exist
2008-05-26 00:46:15 ERROR:SQL: UPDATE realmlist SET color = 2 WHERE id = ‘1′
2008-05-26 00:46:15 ERROR:SQL ERROR: Table ‘mangos.realmlist’ doesn’t exist
2008-05-26 00:46:15 ERROR:SQL: UPDATE characters SET online = 0
2008-05-26 00:46:15 ERROR:SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1′)
2008-05-26 00:46:15 ERROR:SQL ERROR: Table ‘mangos.characters’ doesn’t exist
2008-05-26 00:46:15 ERROR:SQL ERROR: Table ‘mangos.account’ doesn’t exist
2008-05-26 00:46:15 Halting process…
ok all is good i got everything working but the gm island vendors any ideas on how to get that installed..and does anyone have a guide ro anything to make this public so like if my friend across the country wants to connect to it he can style u know what i mean?
did you manually add your password to the config files?
That points to a wrong username or password to access the MySQL database
i’m getting “ERROR 1045 : Access denied for user ‘root’@'localhost’ ”
anyone know how to get over this error? i’ve tried installing older versions, but they give the same error.
i’m using all the default database names
Ooops, forgot the link…
http://projectsilvermoon.net/index.php?showtopic=12566
BTW Oatman,
If you are looking for better instructions for PSDB, there is a new ‘how-to’ post on the PS website. Longer read but better detailed. Maybe this will help you to include PSDB in your future releases.
Keep up the good work, you rock!
Hello when i try to install the optional GM island vendors i get the fallowing error
error 1136 (21s01) as line 24: column count doesn’t match value at row 1
and thats the best part i like… and clue of how to fix this ?
Maybe I’m doing something wrong but after doing a fresh install the GM island vendors aren’t installing properly. It’s telling me that the columns don’t match. Any ideas?
Exactly – it will sort-of look like the vmaps process has finished, but it is quietly going through the split-maps config and making the vmaps folder after the buildings folder has been created. IT TAKES A LONG TIME. Go mow the lawn (or someone else’s if you don’t have one), then take a nap, then come back and it should be done.
i took the realmd and mangosd config files from reaper 5472 and put them in 5931 and it loaded fine
Follow the instructions carefully and it will work fine, a thing many people forget is to WAIT after vmaps_simple is finished (or not) until you get press any key to continue message.
i cant extract any of the maps i can extract the data but not maps my wow client is 2.4.2 fully updated and everything and im trying to do a fresh install anyone got some help for me? im nto fully sure how to do this
I tried yesterday to add Brutal gladiator and the new Guardian parts myself but it didnt work, got some wrong bla bla at row 1 … :<
ok i got it figure out… what is different from this version and old ones is. Like where it ask what data base you like to use (MaNGOS) . I used to just hit enter it would use default with out me halfing to type in anything. Now its not like that. You got to type it in
Sorry but i am still getting this same error when i try to install
ERROR 1045 (28000):access denied for user ‘-p####’@'localhost’ (using password: no/0
mysql: option ‘-D’ requires an argument
Not sure why this repaer version gives me this trouble.. the other ones installed ok. Can you give me the order of the SQL.files and ill just import them
Thank you so much for releasing the rev 5953. how to transfer the old Mangos rev 3462’s database to the new Mangos rev 5472 or higher? Please , help me!
OK LINKS UPDATED!
5953 IS NOW RELEASED!
ENJOY!
#Anderek
Yea I am aware of that and there isn’t any in this release either. Its more of a prep for when its ready.
Also not sure if you know this but there are no mobs in the sunwell raid, i was also having problems with more than one person getting inside of it.
#Anderek
Yep they are on their way!
#Viktor
Yea those are in there yet I believe but they will be in there in a future release for sure. I mainly released this so early because of so many errors and complaints in the previous release.
The only thing your latest needed was s4 and kil’jaeden loots but good job in upgrading :p
Yay first =D, cant wait for the links