Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!)

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.

Shattered Sun Soldiers

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:

Vmaps from WoW 2.4.2:

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) ;)

MySQL Input Directory

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.
Upgrade Warning

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!

Comments Navigation « Previous 1 2 3 4 ... 16 Next »

Mod said May 27, 2008 at 2:36 am

oh ok, thanks. i’ll try that

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 2:34 am

no the maps tool not vmaps i beleave the file is called ad.exe

Link to this comment Reply to this comment
Mod said May 27, 2008 at 2:33 am

do you mean the “makevmaps_SIMPLE”?

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 2:29 am

u need to run the map tool again

Link to this comment Reply to this comment
Mod said May 27, 2008 at 2:24 am

ok now i’m finally passed the reaper-x-mangos file, but now when i open mangosd.exe, it works until it gets to:

WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: ./vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
Check existing of map file ‘./maps/0004331.map’: not exist!
Correct *.map files not found in path ‘./maps’ or *.vmap/*vmdir files in ‘./vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

so am i missing a file or something?

Link to this comment Reply to this comment
Mod said May 27, 2008 at 2:04 am

nvm thanks, i think i got it now :)

Link to this comment Reply to this comment
Mod said May 27, 2008 at 2:02 am

i still dont understand what i did wrong. when i go to the reaper-x-mangos.exe it asks me where my files are so i put in to location and then i push 1 for installation. it asks for my username and i just use root. does the password have to be the same as the MySQL password? i’ve been using the words for the database names it gives like when it says “What is your World/Mangos Database Name ? (Most likely “mangos”) i’ll use mangos

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 2:00 am

ok imma try this again since i have had no responses yet

I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?

second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.

also looking for experienced gm’s that can assist me with small fixes and above mentioned questions these gms will get gm access to my server

thanx in advance

Link to this comment Reply to this comment
jalexbivin said May 27, 2008 at 1:57 am

There was a problem with the batch file to extract DBC. Not sure if you caught it yet or not.
On line three it reads:
mpqe /d “.” expansion-local-enUS *.dbc
where it should read:
mpqe /d “.” expansion-locale-enUS.MPQ *.dbc

Hope all is well with the Reaper man!

Alex

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 1:53 am

i had roughly the same issue mine was error in gameobject_template probably sql file formant was updated “there should be 32 fields in sql.”

i tried everything.. had to delete and fresh install database now she works but im wondering hpw to get my custom vendor back up

Link to this comment Reply to this comment
mhs2011 said May 27, 2008 at 1:43 am

Ok i have this problem when upgrading. i had the newest version before this, but it wasnt working. i had the same problem as i do now. and i dont want to restart my whole database.
so when i run mangos.exe i get this error message.
“Loading Items…
Error in item_template table, probably sql file formant was updated (there should be 140 fields in sql.”

Link to this comment Reply to this comment
Dopey said May 27, 2008 at 1:35 am

@ Firane,

Did you get the modified vendors file posted?

@ Oatman,

Any chance we can get the vendors back from the 5472 release? Those vendors are the ones I like with all the trainer vendors included. Tried reinstalling 5472, then the custom vendors, then running all the upgrades to this one, and it kinda worked. MOST of the vendors showed up (oh, and I had to modify the GUIDs for all the vendors). Anyway, thanks again for all the hard work.

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 1:29 am

they have altered allot of them such ass money is now a modify option and to add game objects and or npc it id add after what u want to add for example

.npc add 67868
or .gobject add 757575

money is .modify money 9832749237

allot of it is subcommand based meaning it starts with what u want to do and then has add or delete or move and so on after

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 1:26 am

u can find a list of the commands in the database under the command table

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 1:23 am

can anyone tell me how to get the custom vendors working for this release? and also the portal to shatt doesnt seem tow work ?

Link to this comment Reply to this comment
Hip-Hop said May 27, 2008 at 1:22 am

Oatman please if it is not a problem to you to give us the GM commands of Mangos 5953, cuz some of the ones in 5472 don’t work. (Sorry for the double-post)

Link to this comment Reply to this comment
Hip-Hop said May 27, 2008 at 1:20 am

I’ve made it to take it to work by copying the data from Mangos 5472 CONF files to the 5953 (the mangosd, scriptdev and realmd CONF files) Don’t copy the whole files, just take the specified spots and overwhrite them in the CONF files (5953 Release) I hope I was in any kind of assistance! Good Luck!

Link to this comment Reply to this comment
thyll said May 27, 2008 at 1:19 am

Jas

do you have a working Gm command list?

how can I add money?
Thaks

Link to this comment Reply to this comment
FrostFyre said May 27, 2008 at 1:18 am

great job !

can someone tell me how can i add a special portal to a place that i want ? or can someone tell me how can i make the Shattrath Portal to Thunderbluff to be used by allience to ? Thanks !

Link to this comment Reply to this comment
Jas said May 27, 2008 at 1:13 am

bah – still not allowing me to have more than one character per account, well I can make them, but as soon as I make a second one the log in screen shows no characters:(
also still not able to interact with npc’s and cannot target or attack mobs…

I wiped my db and did a fresh install. Not sure what the problem is if anyone can help I would greatly appreciate it:)

Link to this comment Reply to this comment
Brutus said May 27, 2008 at 1:13 am

Hi Reaper,

First of all good work, its nice to have a good private wow server.

I have some questions.

Im having some little problems in game:

1 In an Instance all the mobs are comming through the walls to kills us. Normaly they don’t ;)

2 When i have a enchant on my weapon and its glowing. When i use that weapon after that the glow is gone. When i re attach my weapon it glows again. Do jou have any clue what this could be?

I think its not my wow installation because some friends ho are also in my server have these problems to.

Hope anyone could help me.

Thanks allot Brutus

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 12:45 am

I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?

second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.

also looking for experienced gm’s that can assist me with small fixes and above mentioned questions these gms will get gm access to my server

thanx in advance

Link to this comment Reply to this comment
Jas said May 27, 2008 at 12:42 am

.npc add “creatureid”

so it will look like

.npc add 16508

(no clue what 16508 is, I just picked a random number)

:)

Link to this comment Reply to this comment
Kyle said May 27, 2008 at 12:39 am

ok HOW DO YOU FREAKING SPAWN NPC’S IN THIS RELEASE!!!!

Link to this comment Reply to this comment
Kyle said May 27, 2008 at 12:30 am

ok i got it to work

Link to this comment Reply to this comment
Kyle said May 27, 2008 at 12:27 am

nope still got it, im trying another link

Link to this comment Reply to this comment
Jas said May 27, 2008 at 12:24 am

you happen to lose your MySQL somehow?

Link to this comment Reply to this comment
Kyle said May 27, 2008 at 12:21 am

ok ive used all the other realeases fin includiong 5931 but this one when i try to use the upgrade feature i get this

‘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.
‘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.

Link to this comment Reply to this comment
Jas said May 27, 2008 at 12:15 am

Kyle,

.addspw is now .npc add (creatureID)
and .npc delete to delete it.

Link to this comment Reply to this comment
elderslayer said May 27, 2008 at 12:07 am

I have a couple diffrent questions first of all my custom vendors are not thier (fresh install) was wondering how to get the vendors back?

second of all im kinda struggling to set up a registration page any assistance on either or both topics would be appriciated.

also looking for experienced gm’s that can assist me with small fixes and above mentioned questions

thanx in advance

Link to this comment Reply to this comment
Kyle said May 27, 2008 at 12:01 am

hey im just updating now but does the .addspw command work in this release ???

Link to this comment Reply to this comment
jhyn said May 26, 2008 at 11:37 pm

hey…
100% work…
now i need add mob “gm command” please…
tnqx ALL!

Link to this comment Reply to this comment
Phen said May 26, 2008 at 11:23 pm

#Talux

The command “.flymode [on/off]” has been changed to “.gm fly [on/off]“

Link to this comment Reply to this comment
Jas said May 26, 2008 at 11:20 pm

Lee BeZaro,

Great to hear:)

Is it just my install that makes the npcs non-interactive? lol

Link to this comment Reply to this comment
Lee BeZaro said May 26, 2008 at 11:18 pm

Jas;

You were right, I found the section on Editing and Mangosd.conf file/s and did what it said and it worked.

Thanks for the help :D
really appiciate it :)

Link to this comment Reply to this comment
Jas said May 26, 2008 at 11:09 pm

Good to hear Thyll:) and no the config editor is not functuional, have to do it manualy.

As for updating from 5472 straight to 5953, I am not sure. I updated from 5472 to 5951 to 5953.. If I am correct the previous updates only allowed upgrade from the most recent, but I could be wrong.

Link to this comment Reply to this comment
thyll said May 26, 2008 at 11:01 pm

Thanks Jas!
now it’s ok!

p.s. the mangos config (option 4) does’nt work?

Link to this comment Reply to this comment
FrostLord said May 26, 2008 at 11:00 pm

Ehi, Oatman, nice so fast a new release!
There’s a thing I’m wondering… the upgrade tool of 5953 version works only from previous 5951 release or from previous reaper-x release (5472) too ?

Link to this comment Reply to this comment
OpticalMouse said May 26, 2008 at 10:56 pm

I updated my MaNGOS from 5472 to this version and None of the quests are working, everything else seems to be perfect though… thoughts?

At first I was getting a ‘gameobject’ error, something about the SQL not having the right number of files or something. So I used that MaNGOS database someone posted.. it let me log in, but like I said quests aren’t working.

Also, my accounts transferred but the characters didn’t. What do I do?

Link to this comment Reply to this comment
Jas said May 26, 2008 at 10:50 pm

no problem, hopefully this works for you:)

Link to this comment Reply to this comment
thyll said May 26, 2008 at 10:49 pm

ok now I try this solution…
thanks again.

Link to this comment Reply to this comment
Jas said May 26, 2008 at 10:48 pm

Lee BeZaro,

Did you edit the mangosconfig, realmdconfig and scriptdevconfig files with your username and password for mysql? You have to do it manually now, since the config editor doesnt work in the batch file.

Link to this comment Reply to this comment
Jas said May 26, 2008 at 10:47 pm

If mysql is running correctly and you are using the same user and password in the reaper exe as you did in the cmd prompt, then you might try redownloading the batchfiles and trying again, not sure:(

Link to this comment Reply to this comment
thyll said May 26, 2008 at 10:44 pm

mysql is set up correctly and is running… the problem is the batch files…I think.

Link to this comment Reply to this comment
Lee BeZaro said May 26, 2008 at 10:42 pm

Maybe this is a simple problem. but howcome when I run mangosd.exe and realmd.exe it says it can’t connect to the database?

Is it someone simple I’m missing?

Link to this comment Reply to this comment
Jas said May 26, 2008 at 10:41 pm

Do me a favor and open up your command prompt.. Start>Run, type in cmd, hit enter, then type:

mysql -u root -p

it should prompt for a password, if so, then enter your password. Then it should say your mySQL version, connection id and such..

This just shows if your mysql is set up correctly :)

If it doesnt, post your error here:)

Link to this comment Reply to this comment
thyll said May 26, 2008 at 10:33 pm

It’s a complete fresh installation, I have format lately my PC.

Link to this comment Reply to this comment
Jas said May 26, 2008 at 10:29 pm

Just in case you do install 6.0, I grabbed Reapers guide for you:)

http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/

Just follow this and it should work swell:)

Link to this comment Reply to this comment
Jas said May 26, 2008 at 10:25 pm

Thyll,

5.0 should work fine, but if you want to uninstall it and install the newest, 6.0 is out.

http://dev.mysql.com/downloads/mysql/6.0.html

Is this install of mySQL 5.0 what you were using previous to the 5953 fresh install of Reaper-X, or is it a fresh install of MySQL as well?

Link to this comment Reply to this comment
thyll said May 26, 2008 at 10:19 pm

thanks Jas…

but I’m sure, the psw is the same used on the mysql installation and for the user I use the standard “root”…
It’s the first time that I have this problem…

maybe I need a different version of the mysq? I use the mysql-5.0.51a..

Link to this comment Reply to this comment