ATTENTION! There is a new release so this is now outdated and unsupported!
Well its finally here! The release that answers everyones questions and fixes everyones bugs! It took me about 8 hours of consistent coding and I believe that it is perfect. The only problem and thing I could not do was get the database updated. Besides that we have updated many things and added many new things as well.
Here is the list of newly added items:
*ScriptDev2 231 Actually Works!
*Auction House Bot Added
*Optional GM Island Vendors in Batch File
*Weather System is now Fixed!
*Lan Feature in Batch Now Works
*Transports Flooding Mangos
*DBC Files Already Included
…And of Course Much More!

REQUIREMENTS:
1. MySQL Database and the Guide on how to Install MySQL
2. World of Warcraft Client version 2.3.2
3. Updated DBC’s, VMAP’s, and MAPS.
DBC’s are already included as part of this release!
4. Mangos Server :
Reaper Mangos 5054 SD2 231 UDB FULL | 17.09 MB | File Beam
Reaper Mangos 5054 SD2 231 UDB FULL | 17.09 MB | Rapidshare
Reaper Mangos 5054 SD2 231 UDB FULL | 17.09 MB | Mega Upload
Instructions Coming Soon
Basically since the installation instruction is just the same as before release, and i’m currently writing on the fresh installation guide so there’s no need to write it everytime there’s a new release available for download :)
in the meantime you can read the previous fresh installation guide :)
Leave a response
#Kezia easiest way i know to set up your realm for online access , download navicat http://www.navicat.net/download.html
install it, then load it , you will need to login to your db through navicat. once there click on the realmd icon (should be grey when you first get in, then click on realmlist. it will show you something like this on a different window. 1(realm name),(your IP(www.whatismyip.com),8085,4,2,1,0,0.02. this is what your realm should look like for others to connect. as for port forwarding. make sure that the forwarded ports are to the computer’s local ip that hosts the server. this should fix it. easiest way i can tell you without going through the dos commands etc. navicat is easier to use bc of the GUI.
/sigh
I did port fowarding it didnt work when I used my public ip as realmlist for me or my friend i have it set as to my domain right now and as for the mysql its set to my domain too..
#Kezia i have mine set up for my public IP http://www.whatismyip.com and both local(on my lan) and people online can connect. if you’ve done everything in the guide make sure you have done your port forwarding (important for online access)
I followed the guide already i can connect but my friend cant my realmlist is set to my host domain and my realmd ( the thing where you do the update command in SQL is edited to my LAN IP adress (but isnt lan for ppl on the same network?
# Kezia http://www.reaper-x.com/2007/07/03/creating-public-server-for-lan-party-setting-up-private-wow-server/
this is an easy step by step on how to.. (not included is port forwarding) but i’ve stated above on how to do port forwarding. Oatman is busy working on the next version.
@Oatman Could you please help me configure my realm so other people can connect via log me in?
@Reaper & Oatman
Upgrade worked great, thank you. Did not have any problems other than some missing GUID’s.
A little confusing on the upgrade instructions as to the install paths, but 5005 was my first install. All the characters seem to be ok without doing any restore.
my yahoo id is WOWn1t3@yahoo.com
#ManuA i had this problem as well once.. run the batch file again extract-map.bat once it finishes replace the maps with the new maps. you’ll have to delete the maps folder in the world of warcraft folder first or it won’t run. this should fix your problem. if it doesn’t i’m on yahoo messanger send me an IM and i’ll transfer the files you are missing to you.
I Keep Getting An Error Message when i open up Mangosd it says:
‘./maps/0004331.map’: not exist!
But when i ran my AD.exe, it had no errors…
#AlexT if you just backed up your characters i think you should be fine to restore them.
I mean to say if you did a clean install on top of the 5005 version with a back up and then restore?
What do you do to get this one working right but don’t want to louse your accounts and settings?
heh, meant to be #Raver
Oatman | Jan 21, 2008 at 10:59 / 10:59 AM | Links to this comments | Reply
#ATTENTION TO ALL THOSE BACKING UP THEIR DATABASE THEN INSTALLING FRESH!!!
This will ruin your database! Unlike the old releases, if you use the backup tool then the fresh install then the restore, it will ruin your database because their are things that you are writing over from the old database an placing it in the new one. You need to go into the Upgrade folder in Reaper-X-Mangos and run the upgrade batch file.
What do you do if you did a clean install?
#Informative
To add honor as a GM you can use the command .honor add xxxxx where xxxxx is the amount of honor you want. That is taken from the GM commands list under the heading at the bottom of the page of Popular Posts
#Raver if you use Quice you can edit the item buy value. current buy value for those items are honor points you can change it with gold… but if you have Quice you can just make your own items =D
Not finding anything else broken in testing but I do get a slew of these messages indicating things missing or out of parity. If anyone with more knowledge of mangos DB than I have can give pointers as to what if anything and how I should work to get these cleaned up, that would be wonderful.
Item (Entry: 21776) not have in `AllowableRace` any playable races (0) and can’t be equipped.
Creature (Entry: 18412) has not aura effect 0 of spell 32332 defined in `auras` field in `creature_template_addon`.
Creature (GUIDLow: 18595) has not aura effect 0 of spell 37744 defined in `auras ` field in `creature_addon`.
Creature (GUIDLow: 39303) has wrong spell 7939 defined in `auras` field in `creature_addon`.
Creature (GUIDLow: 86177) has wrong spell 23973 defined in `auras` field in `creature_addon`.
Creature (GUIDLow: 89112) has wrong spell 25900 defined in `auras` field in `creature_addon`.
Creature (GUIDLow: 89359) has wrong spell 26239 defined in `auras` field in `creature_addon`.
Creature (GUIDLow: 89360) has wrong spell 26240 defined in `auras` field in `creature_addon`.
Table `spell_scripts` has unsupported spell (Id: 8202) without SPELL_EFFECT_SCRIPT_EFFECT (77) or SPELL_EFFECT_SEND_EVENT (61) spell effect
Table `spell_scripts` has unsupported spell (Id: 23254) without SPELL_EFFECT_SCRIPT_EFFECT (77) or SPELL_EFFECT_SEND_EVENT (61) spell effect
SD2: >> Loaded 0 Localized_Texts. DB table `Localized_Texts` is empty.
SD2: >> Loaded 0 EventAI_Scripts. DB table `EventAI_Scripts` is empty.
#Raver: Some of the prices are with tokens you can add as a GM, but honor I’m not sure how to add honor. You could probably find and edit the items to have a gold price instead of honor, but why. If you really want custom ietms make your own items and populate the vendors with those instead. It’s all elbow grease from here I think… =)
I think Ray may have had the answer – missing piece of the puzzle with the realmd realmlist database realm table address field needing an IP other than 127.0.0.1. I think it needs to be lniked to the external IP everyone is using to hit your site and getting forwarded at the router to your local IP in the ipconfig.
Only other thing I’m finding now is boss mobs like Doombringer dropping no loot so DB needs some cleaning and filling but otherwise a very excellent release.
OHH. I HAVE ANOTHER QUESTION: FOR MAKING MY SERVER PUBLIC I SHOULD REPLACE MY LAN IP ADDRESS(127.0.0.1) WITH MY EXTERNAL IP ADDRESS???
OK. The server is working and the vendors are working. BUT I CAN’T BUY SOME THINGS FROM VENDORS WITH GOLD!!! THEY ARE WITH HONOR OR I DON’T KNOW(badge of justice…). PLEASE HELP!!
@Reaper & Oatman
Thanks for this release didnt have any problems with it. all i did was backed up my characters with reaper batch and upgraded and then restored my characters back and everything was still there and i manually config. and it works perfect:)
Thank you
@Truz
use can use RoSpora Build V1.4.4.1 registration page it work with Reapers release.
@Oatman
dont take it personaly but please dont release more rushjobs like you did until now. I know you worke hard for the releases but they just look and feel like done in some kind of hurry (installer not unpack, log data left over, etc) please take your time an do it right (that meanes you do some testing first an then you release it) As stated an the beginning dont take it personaly
helpppppp pleaseeee
Hi,
I get this error when i use mangosd:
SQL ERROR: Table “realmd.realmlist” doesn´t exist
Anyone knows what i should do at this point?
Tnx
@Reaper or Oatman
I was wondering if you guys need any help testing servers and releases you guys bring out. I know you guys are making your own privet server soon to be accessed by any and all who wish, but I was wondering if you need help behind the scenes with testing bugs or making sure the gameplay rides close with the actual blizz servers. Id love to help if there is someway I can, been loving your guides an your releases since the burning crusade ^^
so oatman help it was to late on my part i lost all the back up i think that was my problem and no i cant get it to run should i back up and reinstall the last one before this and then update or what i cant get back in tells me no data see the above under will
I am kind of new at this stuff you guys by far have the BEST website for private servers…I am in the US Navy and I have set this up for the guys while under way. I have 2 questions hopely easy answers:
first can the server be run on a mac??
Second is there a way I can make a HTML account creation where people can send a request to me in a queue while I am away and I can come back and approve the account??
Table `spell_scripts` has unsupported spell (Id: 8202) without SPELL_EFFECT_SCRI
PT_EFFECT (77) or SPELL_EFFECT_SEND_EVENT (61) spell effect
Table `spell_scripts` has unsupported spell (Id: 23254) without SPELL_EFFECT_SCR
IPT_EFFECT (77) or SPELL_EFFECT_SEND_EVENT (61) spell effect
button_scripts :
SD2: >> Loaded 0 Localized_Texts. DB table `Localized_Texts` is empty.
SD2: >> Loaded 0 EventAI_Scripts. DB table `EventAI_Scripts` is empty.
SD2: Loaded 448 Scripts
just updated.. seems ok. except for the errors and the localized texts being empty. where do i get eventai scripts ? :)
Hey
Could anyone post a small tutorial on how to upgrade from 5005 to 5054 ?
On my last upgrade from 4875 to 5005 I kinda screwed the char db and would hate it if it would happen again.
Many thanks.
————–
LOCK TABLES `mail` WRITE
————–
————–
/*!40000 ALTER TABLE `mail` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `mail` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
DROP TABLE IF EXISTS `mail_items`
————–
————–
CREATE TABLE `mail_items` (
`mail_id` int(11) NOT NULL default ‘0′,
`item_guid` int(11) NOT NULL default ‘0′,
`item_template` int(11) NOT NULL default ‘0′,
PRIMARY KEY (`mail_id`,`item_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
————–
————–
LOCK TABLES `mail_items` WRITE
————–
————–
/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
DROP TABLE IF EXISTS `pet_aura`
————–
————–
CREATE TABLE `pet_aura` (
`guid` int(11) unsigned NOT NULL default ‘0′ COMMENT ‘Global Unique Identifier
‘,
`caster_guid` bigint(20) unsigned NOT NULL default ‘0′ COMMENT ‘Full Global Un
ique Identifier’,
`spell` int(11) unsigned NOT NULL default ‘0′,
`effect_index` int(11) unsigned NOT NULL default ‘0′,
`amount` int(11) NOT NULL default ‘0′,
`maxduration` int(11) NOT NULL default ‘0′,
`remaintime` int(11) NOT NULL default ‘0′,
`remaincharges` int(11) NOT NULL default ‘0′,
PRIMARY KEY (`guid`,`spell`,`effect_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=’Pet System’
————–
————–
LOCK TABLES `pet_aura` WRITE
————–
————–
/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
DROP TABLE IF EXISTS `pet_spell`
————–
————–
CREATE TABLE `pet_spell` (
`guid` int(11) unsigned NOT NULL default ‘0′ COMMENT ‘Global Unique Identifier
‘,
`spell` int(11) unsigned NOT NULL default ‘0′ COMMENT ‘Spell Identifier’,
`slot` int(11) unsigned NOT NULL default ‘0′,
`active` int(11) unsigned NOT NULL default ‘0′,
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=’Pet System’
————–
————–
LOCK TABLES `pet_spell` WRITE
————–
————–
/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
DROP TABLE IF EXISTS `pet_spell_cooldown`
————–
————–
CREATE TABLE `pet_spell_cooldown` (
`guid` int(11) unsigned NOT NULL default ‘0′ COMMENT ‘Global Unique Identifier
, Low part’,
`spell` int(11) unsigned NOT NULL default ‘0′ COMMENT ‘Spell Identifier’,
`time` bigint(20) unsigned NOT NULL default ‘0′,
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
————–
————–
LOCK TABLES `pet_spell_cooldown` WRITE
————–
————–
/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
DROP TABLE IF EXISTS `petition`
————–
————–
CREATE TABLE `petition` (
`ownerguid` int(10) unsigned NOT NULL,
`petitionguid` int(10) unsigned default ‘0′,
`name` varchar(255) NOT NULL default ”,
`type` int(10) unsigned NOT NULL default ‘0′,
PRIMARY KEY (`ownerguid`),
UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=’Guild System’
————–
————–
LOCK TABLES `petition` WRITE
————–
————–
/*!40000 ALTER TABLE `petition` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `petition` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
DROP TABLE IF EXISTS `petition_sign`
————–
————–
CREATE TABLE `petition_sign` (
`ownerguid` int(10) unsigned NOT NULL,
`petitionguid` int(11) unsigned NOT NULL default ‘0′,
`playerguid` int(11) unsigned NOT NULL default ‘0′,
`player_account` int(11) unsigned NOT NULL default ‘0′,
PRIMARY KEY (`petitionguid`,`playerguid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=’Guild System’
————–
————–
LOCK TABLES `petition_sign` WRITE
————–
————–
/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */
————–
————–
/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */
————–
————–
UNLOCK TABLES
————–
————–
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */
————–
————–
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */
————–
————–
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */
————–
————–
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */
————–
————–
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
————–
————–
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */
————–
————–
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */
————–
————–
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */
————–
Please wait it’ll take a while to import the database
Press any key to continue . . .
ERROR 1049 (42000): Unknown database ‘c:\wow\dat’
————–
DROP TABLE IF EXISTS `eventai_scripts`
————–
————–
CREATE TABLE `eventai_scripts` (
`id` int(11) unsigned NOT NULL COMMENT ‘Identifier’ AUTO_INCREMENT,
`creature_id` int(11) unsigned NOT NULL default ‘0′ COMMENT ‘Creature Template I
dentifier’,
`event_type` tinyint(5) unsigned NOT NULL default ‘0′ COMMENT ‘Event Type’,
`event_param1` int(11) signed NOT NULL default ‘0′,
`event_param2` int(11) signed NOT NULL default ‘0′,
`event_param3` int(11) signed NOT NULL default ‘0′,
`action1_type` tinyint(5) unsigned NOT NULL default ‘0′ COMMENT ‘Action Type’,
`action1_param1` int(11) signed NOT NULL default ‘0′,
`action1_param2` int(11) signed NOT NULL default ‘0′,
`action1_param3` int(11) signed NOT NULL default ‘0′,
`action2_type` tinyint(5) unsigned NOT NULL default ‘0′ COMMENT ‘Action Type’,
`action2_param1` int(11) signed NOT NULL default ‘0′,
`action2_param2` int(11) signed NOT NULL default ‘0′,
`action2_param3` int(11) signed NOT NULL default ‘0′,
`action3_type` tinyint(5) unsigned NOT NULL default ‘0′ COMMENT ‘Action Type’,
`action3_param1` int(11) signed NOT NULL default ‘0′,
`action3_param2` int(11) signed NOT NULL default ‘0′,
`action3_param3` int(11) signed NOT NULL default ‘0′,
`comment` varchar(255) NOT NULL default ” COMMENT ‘Event Comment’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT=’EventAI Scripts’
————–
————–
DROP TABLE IF EXISTS `localized_texts`
————–
————–
CREATE TABLE `localized_texts` (
`id` int(11) unsigned NOT NULL COMMENT ‘Identifier’ AUTO_INCREMENT,
`locale_0` varchar(255) NOT NULL default ”,
`locale_1` varchar(255) NOT NULL default ”,
`locale_2` varchar(255) NOT NULL default ”,
`locale_3` varchar(255) NOT NULL default ”,
`locale_4` varchar(255) NOT NULL default ”,
`locale_5` varchar(255) NOT NULL default ”,
`locale_6` varchar(255) NOT NULL default ”,
`locale_7` varchar(255) NOT NULL default ”,
`comment` varchar(255) NOT NULL default ” COMMENT ‘Text Comment’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT=’Localized Text’
————–
ERROR 1049 (42000): Unknown database ‘c:\wow\dat’
ERROR 1049 (42000): Unknown database ‘c:\wow\dat’
ERROR 1049 (42000): Unknown database ‘c:\wow\dat’
Done
If you see any error message just let me know
Press any key to continue . . . pleaseee help me with this is as far as i get what am i doing wrong
@Oatman
ETA of when it’s going to get here, Oat? I don’t wanna refresh the page every 5 min. haha
#Oatman,
Ok I am going to wait for the next one anyways, I have upgraded to this 5054 version and i am still missing those things. Anyways thanks you guys for the responses.
#TKMsage,
Ok, well thanks anyway. I think I am going to hold out for the next release and see what happens. Maybe I will get everything back. If not Oh well.
#n1t3,
Thanks for the info :-) My husband says thanks as well.
will guild banks work with the new release?
#Oatman you rock!!
Yeah, that’s what I meant :) Sorry if it was a little confusing
@n1t3
Oh cool, didn’t know that. But it’s still a problem that she doesn’t have all those there by default (like it’s supposed to). Who knows what else she’s missing that she or her husband haven’t noticed, haha.
@Darlin
Ouch! Well what you can try to do is wait out for the next release in a few, download that, and upgrade from there and see if your issues are fixed.
If that doesn’t work we can go from there.
mailbox fix
they are listed as game objects… i’m not sure the command for adding game objects but a neutral one that should work for alliance or horde is “144112″
that is the item code for a neutral mailbox
#TKMsage,
Oh man, my husband isnt happy, he just hit 65 with his characters and I just hit 55, this sucks big time. Is there any way that I could be able to save my characters without losing those? but have a clean install? Did that make sence?
MESSAGE REMOVED DUE TO VIOLATION IN TERM OF SERVICE!
np :)
@Darlin
I know it’ll suck but my best guess is to try a fresh install (clearing all your databases as well) and see if they come up. Something prolly got messed up during the upgrade process or some files didn’t get copied over correctly.
Someone else might have a better solution but from what I’m seeing, that’s all you can really do.