MaNGOS 6245 (UDB + PSDB), ScriptDev2 r474

Hello everyone! Its Colt45! I am glad to announce that MaNGOS Rev 6245 has been release (finally)! I am terribly sorry to inform you that I do not have a list of new feature that have been added to this release, but I should have a complete one for the next release. So here is the guide:

THIS GUIDE HAS BEEN BASED OFF OF OATMAN’S LAST GUIDE, PLEASE GIVE THE CREDIT TO HIM FOR THE GUIDE!!!

Step 1: Install MySQL using the guide here >>> (MySQL Installation and Configuration)

NOTE: It does NOTmatter which verion of MySQL you get (either 5.0 or 5.1) as long as you do not get any older versions or beta versions!

Step 2: Update your DBC’s, VMAP’s, and MAPS for 2.4.2!

If you already have your DBC’s, Vmaps’s, and Maps from a previous release that uses client 2.4.2 then you DO NOT have to re-extract them. If not then you must follow the Readme.txt files located in the extraction folders.

Step 3: Download Reaper-X-MaNGOS (below are list of mirror to file).

Links updated to the recompressed version (19.49MB) that use 7zip self extracting archive instead of zip compressed file

1. MediaFire Download

2. RapidShare Download

3. FileBeam Download

2.4.2 Maps:

Vmaps from WoW 2.4.2:

Thanks to Davtex for uploading the maps and vmaps files

These files should still be compatible with this release

Custom Vendors Pack for this version

http://filebeam.com/a516a6d8281b96e506df995716381a02

Credits to Firane for creating the Custom Vendors Pack

Updated GM Command List for this version

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
Note: ad.exe included in this version will extract the dbc files and maps files, and so all you have to do is just put the ad.exe into your wow installation directory (for example, C:\program files\World of Warcraft) and run the ad.exe from there. But make sure to delete the maps and dbc directory if exist before running the ad.exe

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 Bin Image

MySQL BIN Image

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.

MaNGOS Batch Menu Image

Mangos batch menu

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

Mangos.exe Image

Mangos EXE

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

Upgrading from 5953 Release:

1. This release still supports your 2.4.2 DBC’s, Maps, and Vmaps, so if you want to re-extract you may but I dont think there is much need.

2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos.

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. (Default is C:\Program Files\MySQL\MySQL Server 5.0\bin)

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.

Update Batch Image

Updated Batch image

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”

In this release your DataDir is pre-set to C:\Reaper_MaNGOS_6245_SD2_474\Data which means that if you extract the folder directly to your C Drive then you will not need to configure your DataDir, but you will still need to set your ROOT and PASSWORDS as shown below!

This is an example of what 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 MANGOS;MANGOS to your root DB name, likey it’s just root, and YOUR database (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.

Comments Navigation 1 2 3 ... 6 Next »

Colt45 said Jul 13, 2008 at 6:06 am

@Jimmy
Your need to edit your .conf files! “candy9″ is the test password I used when testing th release, so change that to whatever your MySQL password is.

@Bob
Alright did you extract all your maps, dbcs, and vmaps? If so did you place them all in one folder? Now if you did those thibgs above then open the folder where maps, dbcs, and vmaps are located and look at the top of the window (it should say something C:\Pserver\Data or something like that) copy and paste it into your mangos.conf file where the DataDir line is!

Link to this comment Reply to this comment
Bob said Jul 13, 2008 at 5:30 am

When I try to run mangosd.exe, I get the following message:
2008-07-12 15:28:48 Using configuration file mangosd.conf.
2008-07-12 15:28:48 MaNGOS/0.11.0-SVN (Revision 6245) (Win32,little-endian) (world-daemon)
2008-07-12 15:28:48 to stop.

MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM

2008-07-12 15:28:48 World Database: 127.0.0.1;3306;root;scamper;mangos
2008-07-12 15:28:49 MySQL client library: 5.0.56
2008-07-12 15:28:49 MySQL server ver: 5.0.51b-community-nt
2008-07-12 15:28:49 Character Database: 127.0.0.1;3306;root;scamper;characters
2008-07-12 15:28:49 MySQL client library: 5.0.56
2008-07-12 15:28:49 MySQL server ver: 5.0.51b-community-nt
2008-07-12 15:28:49 Login Database: 127.0.0.1;3306;root;scamper;realmd
2008-07-12 15:28:49 MySQL client library: 5.0.56
2008-07-12 15:28:49 MySQL server ver: 5.0.51b-community-nt
2008-07-12 15:28:49 Realm running as realm ID 1
2008-07-12 15:28:49 Using UDB 0.10.3 (357) for MaNGOS rev. 6240 with SD2 SQL for rev. 473
2008-07-12 15:28:49 Using DataDir C:\Pserver/
2008-07-12 15:28:49 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-07-12 15:28:49 WORLD: VMap data directory is: C:\Pserver/vmaps
2008-07-12 15:28:49 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-07-12 15:28:49 ERROR:Map file ‘C:\Pserver/maps/0004331.map’ is non-compatible version (outdated?). Please, create new using ad.exe program.
2008-07-12 15:28:49 ERROR:Correct *.map files not found in path ‘C:\Pserver/maps’ or *.vmap/*vmdir files in ‘C:\Pserver/vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
Does anybody know how to fix this?

Link to this comment Reply to this comment
be_happy said Jul 13, 2008 at 4:59 am

how do i connect via lan/wi-fi on this server by ip adress or something?

Link to this comment Reply to this comment
Jimmy said Jul 13, 2008 at 4:24 am

does anybody know how to fix this?

Link to this comment Reply to this comment
Jimmy said Jul 13, 2008 at 4:23 am

When I try to run manogsd.exe I get the following: 2008-07-12 14:18:18 Using configuration file mangosd.conf.
2008-07-12 14:18:18 MaNGOS/0.11.0-SVN (Revision 6245) (Win32,little-endian) (world-daemon)
2008-07-12 14:18:18 to stop.

MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM

2008-07-12 14:18:18 World Database: 127.0.0.1;3306;root;candy9;mangos
2008-07-12 14:18:19 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘root’@'localhost’ (using password: YES)

2008-07-12 14:18:19 ERROR:Cannot connect to world database 127.0.0.1;3306;root;candy9;mangos

Link to this comment Reply to this comment
Darkhawk said Jul 13, 2008 at 3:30 am

SQLyog Community Edition is free, it is just the enterprise version that you can purchase.

but there hasn’t been anything I haven’t been able to do with the community edition.

Link to this comment Reply to this comment
Insane said Jul 12, 2008 at 11:45 pm

Just a question, is there a s4 vendor script for this? i still haven’t figured out how to add a custom vendor lol

i have found a few different s4 vendor scripts but none of them works because they were used with different db tables than what this uses

Link to this comment Reply to this comment
Colt45 said Jul 12, 2008 at 9:47 pm

@mhs2011
I am not sure why this happened, but for me it works fine and I personally tested the update on my server and did not have any problems!

@Rikiller
Not sure really, I could release another update right now, but it wouldn’t change much and season 4 would not have been fully added yet.

@Viroun
I am sorry I did not understand the question…

Link to this comment Reply to this comment
viroun said Jul 12, 2008 at 8:45 pm

Hello:
I serch for [map] and [vmap] for my personal server! auther then http://rapidshare.com/files...
thenks

Link to this comment Reply to this comment
bakaslayer said Jul 12, 2008 at 6:38 pm

if i do an upgrade from previous release the ah bot should still work right??

Link to this comment Reply to this comment
Rikiller said Jul 12, 2008 at 5:37 pm

Just a quick question…
You have mentioned that Season 4 will be ready in the next release.. when should we expect that roughly?

Link to this comment Reply to this comment
Darkhawk said Jul 12, 2008 at 2:20 pm

The community edition of SQLyog is free, and it is just the enterprise version that you have to purchase after the trial is over.

Link to this comment Reply to this comment
mhs2011 said Jul 12, 2008 at 1:11 pm

ya, just to let you know, the update also overwrites your database =\
I had so much work done with my server, then i thought the update would NOT over write days of work, but i guess not.
thanks anyway.i guess i have to learn how to compile from now on.

Link to this comment Reply to this comment
Colt45 said Jul 12, 2008 at 10:01 am

@Everyone
Yes sorry about the file size, I could not get my hands on the program needed.

@Forest
Yes I hope so too ;)

@Truz
No SQLyog is not a freeware program and you must buy it or it will expire, but I don’t believe Navicat expires if you get the right download.

Link to this comment Reply to this comment
kevin said Jul 12, 2008 at 8:54 am

@Truz

here you go i just uploaded this just for you lol, have fun

http://rapidshare.com/files/129027707/SQLyog.Enterprise.v6.50.rar

Link to this comment Reply to this comment
Truz said Jul 12, 2008 at 8:17 am

I love you guys great repack…WOTLK???I really would like to have it..on a side note does anyone have a version of SQLyog that won’t expire???

Link to this comment Reply to this comment
Forest said Jul 12, 2008 at 6:56 am

Yeah, I love reaper-x.com’s repack so much. It’s awesome and hope Sunwell will work as good as Black Temple soon.

Link to this comment Reply to this comment
Reaper-X said Jul 12, 2008 at 6:08 am

# bakaslayer

I believe this release is much larger because it use zip compression, i’ll try to recompress it using 7zip :)

Link to this comment Reply to this comment
Bigmarky said Jul 12, 2008 at 5:21 am

ah, found something else, the doors in magister’s terrace (the sundoors) won’t open?

Link to this comment Reply to this comment
Bigmarky said Jul 12, 2008 at 5:11 am

Season 4 sets, woot.
AWESOME THE MOBS ARE IN SUNWELL….but

how do u get felmyst to come down after brutallis… and ya still needs updates to finalize the scripts for sunwell just like in BT when it was finally finished for illidan =D

not complaining just asking

once the scripts are perfected for sunwell this is perfect man thanks

Link to this comment Reply to this comment
Colt45 said Jul 12, 2008 at 4:30 am

Thanks Oatman! =]

Link to this comment Reply to this comment
bakaslayer said Jul 12, 2008 at 4:10 am

why is this release so much larger than previous ones

Link to this comment Reply to this comment
bakaslayer said Jul 12, 2008 at 4:08 am

why is this release so much larger than previous ones??

Link to this comment Reply to this comment
Oatman said Jul 12, 2008 at 4:01 am

Colt, you’re an amazing job :D

I just think you should have added the AH Bot but besides that good work!

Link to this comment Reply to this comment
iotech said Jul 12, 2008 at 3:43 am

All,

I have compiled the changes for Mangos/UDB/ScriptDev2/ACID between ReaperX 5953 and 6245 into one handy place:
http://firedogsweb.game-host.org/reaperx/

Note that these are core changes made to the above products by their developers,and do not include any custom work (such as Firane’s vendor scripts or changes made by the re-packer). I would be happy to include these changes if desired.

Feedback appreciated, flames ignored.

-iotech

Link to this comment Reply to this comment
iotech said Jul 12, 2008 at 3:20 am

@Colt45

Great! Would be handy to know what rev Oatman used on the 5953 release, but I can just do a r1 to r17 log. I am pulling the changelog info out of the SVN commit notes for all four products.

ACID is at http://sd2-acid.svn.sourceforge.net/viewvc/sd2-acid?view=rev&revision=17

I will have a full changelog for all contents posted in about an hour.
-iotech

Link to this comment Reply to this comment
Colt45 said Jul 12, 2008 at 3:15 am

@Iotech
Current ACID is R17, and I will look for a ACID changelog as well.

Link to this comment Reply to this comment
iotech said Jul 12, 2008 at 3:01 am

@Colt45
Thanks! I am also havign issues figuring out ACID revisions used in the prior release and this one. I can do changelog from ACID 0.0.1r1 to current, but what is current?

Thanks for the quick reply above!

iotech

Link to this comment Reply to this comment
Colt45 said Jul 12, 2008 at 2:51 am

@WantRogueBoots
Yes UDB has left out some major items for season 4, etc. We hope this will be fixed in the next release!

@Iotech
UDB 0.10.3 was used in this release.

Link to this comment Reply to this comment
iotech said Jul 12, 2008 at 2:01 am

@Colt45,

I am rounding up changelogs and feature lists for everyone for this release compared to last (5953), but I dont know what version of the UDB you included in this release. Which is it?

Thanks!

Link to this comment Reply to this comment
WantRogueBoots said Jul 12, 2008 at 1:22 am

I do not know if all Brutal sets are working all I know is that Guardian’s Leather Boots is not in this release ^^

Link to this comment Reply to this comment
iotech said Jul 12, 2008 at 1:12 am

@Firane

The last vendor pack created some opportunities for expoloit, for example two of my players found vendors that “sell” items for 0 cost then buy them back for good gold (specifically, these were Gem vendors, but I found others when I investigated by a pair of 10th level characters had arena gear).

Q: Was this what you fixed in the new vendor pack?

Thanks for the work on this, much appreciated!!

Link to this comment Reply to this comment
Yurgeta said Jul 11, 2008 at 11:01 pm

i get the lan setup and stuff, but i dont have one. i dont use a router i just use a normal connection to my isp..

at my dads i had it and it worked no problem..

but at my flat i dont use a router or netwrok so i dont have a lan ip.

Link to this comment Reply to this comment
Colt45 said Jul 11, 2008 at 10:35 pm

@kevin
Thanks for writing that guide out, lol or I would have had too :P but anyways PSDB is just another database, writen in a differant way, but still gets you the same results as UDB, but I have no experience with PSDB nor does Oatman. Reaper is the only one I believe has any experience with it.

@Firane
Hey and ya I understand but I don’t believe many people be using PSDB, so its not a big problem.

Link to this comment Reply to this comment
Firane said Jul 11, 2008 at 10:15 pm

@colt45/reaper/oatman
also included say that the vendors only work with UDB.
I don’t use PSDB so i didn’t feel like converting them to PSBD
unless they already work
in that case i haven’t tried it

Link to this comment Reply to this comment
kevin said Jul 11, 2008 at 9:23 pm

If you want to host on a lan make sure you change the realmlist table address (found in the realmd db) to point to your servers lan ip instead of 127.0.0.1 and add this

localhost

to your \windows\system32\drivers\etc\host file using notepad…for example…

192.168.1.42 localhost

You continue to use localhost everyone else on your lan would change the realmlist.wtf to

set realmlist

e.g. set realmlist 192.168.1.42

If you want to host on the internet get a address from https://www.dyndns.com or http://no-ip.com. This is more secure than giving out your external ip. This goes in your realmlist table address(found in the realmd db) Make sure you ADD to your \windows\system32\drivers\etc\host file the following

e.g.

192.168.1.42 localhost
82.61.204.112 my.game-server.cc

IF YOU HAVE A ROUTER MAKE SURE YOU HAVE PORTS: 8085, 3724 AND 80 OPEN AND FORWARDED TO THE SERVER IP OTHERWISE YOU WILL HAVE PROBLEMS CONNECTING.

I strongly advise against changing 127.0.0.1 entries in the files to your no-ip address as this just adds lag to your server
by forcing the system to translate from the host file for every request and is totally unecessary!

Link to this comment Reply to this comment
kevin said Jul 11, 2008 at 9:16 pm

whats the difference beween Project Silvermoon and the base i was thinking about tring it

Colt45 Item\Creature Packs sounds nice cant wait

Link to this comment Reply to this comment
Yurgeta said Jul 11, 2008 at 9:14 pm

i have a wee problem i cant figure out howto fix can someone help me..

ive setup all my files correctly, my ports are open as ive checked them when running the realm and mangois .exe files. but im unable to connect and so are my friends..

i use a no-ip url and i DO NOT have a router.
so i dont have a lan ip. only an external ip. which is configed for my ip.

all i get it the handshakeing screen it wont go past it..

all the “ip” parts point to my no-ip domain and my site for WoW loads. and shows the server online and stuff.. but for some mental reason we cant connect.

my hosts file in windows says 127.0.0.1 xxxxxxx.servegame.com

if i change it to my IP then the mysql says it cant connect. ive read the guides over and over, and it is setup as it should be.. any idears ?

Link to this comment Reply to this comment
Colt45 said Jul 11, 2008 at 9:07 pm

@Martzy
Yes Sunwell should be spawned

@Anderek
Im not to sure if season 4 is active all though I believe it is.

@Firane
Hey thanks man, but I don’t have the ability to edit posts yet, only the ability to post them so ill let Reaper know and he can change it!

@sab
Reaper-X has been VERY busy with stuff.

@SR2
No I am sorry, but AH bot is not included, I am already working on the next release and am planning on adding it!

Link to this comment Reply to this comment
kein said Jul 11, 2008 at 8:24 pm

great job

oh some of the preist season 4 dont work and
some of the Guardian dont eather

but im loving it cheers keep up the good work

Link to this comment Reply to this comment
Gibsauce said Jul 11, 2008 at 6:45 pm

Thanks much Reaper team! Also thanks for the vendor updates Firane. All works great so far ^_^

Link to this comment Reply to this comment
SR2 said Jul 11, 2008 at 3:23 pm

Have you included the Auction House bot?

Link to this comment Reply to this comment
sab said Jul 11, 2008 at 1:11 pm

I got a question, where is Reaper-x ?
He made always the repacks :P lol.

Link to this comment Reply to this comment
Firane said Jul 11, 2008 at 1:05 pm

just put it in the post and tell ppl to dl that one

Link to this comment Reply to this comment
Firane said Jul 11, 2008 at 1:04 pm

@Colt45
please change this asap
i fixed some bugs and updated a few things
u need to use this one
http://filebeam.com/a516a6d8281b96e506df995716381a02

Link to this comment Reply to this comment
Firane said Jul 11, 2008 at 12:59 pm

hey colt
im checking up on the vendors now
ill let u know if it needs to be updated

Link to this comment Reply to this comment
Anderek said Jul 11, 2008 at 11:44 am

Active*

Link to this comment Reply to this comment
Anderek said Jul 11, 2008 at 11:44 am

Awesome a new release, is season 4 actice? 3rd too!

Link to this comment Reply to this comment
Martzy said Jul 11, 2008 at 11:35 am

Awesome! Thanks Colt, did you guys implement the mobs for Sunwell yet?

Link to this comment Reply to this comment
Colt45 said Jul 11, 2008 at 11:16 am

I understand that there may be some errors with this release but I can guarantee there won’t be any in the next!

Link to this comment Reply to this comment