Custom Search
Reaper Mangos 5054 – Easy WoW Private Server for WoW 2.3.2 -Critical Update-
Posted by Reaper-X Jan 20 2008 9:09 am
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 :)
Trackbacks/Pingbacks
Leave a response
Connect with me
#TKMsage,
BTW thank you for the reply.
#TKMsage,
You wouldnt know how I would be able to get the mailboxes and anvils and forges back?. There are quite a few quests that didnt work either in 5005 and this one (5054). I had them in 4875 and when I upgraded to 5005 and this one they were gone.
#jackslade go into the C:\mangos\reaper-eazy-mangos\Upgrade folder and upgrade using the batch program there.
#Rocko np man anytime
managed to get external connections going by adding my external IP to the realmlist table in the realmd database as explained here http://www.reaper-x.com/2007/07/03/creating-public-server-for-lan-party-setting-up-private-wow-server/
The only issue I see now is when I get home I won’t be able to connect from inside my network. I’ll troubleshoot that when I come to it.
whats the process in upgrading from 5005 to 5054? How do you import the updates sql tables?
@Darlin
Just logged in really quick and Mailboxes are there for me, same with forges, etc.
And you’d have to be specific with which quests so I can check it out.
#Rocko: I did a #1 fresh db load and then simply applied the step #7 to add apply the vendor SQL.
I just finished updating 5005 with 5054 and it updated fine, BUT there are still issues. Mailboxes are still missing and so are the anvils and forges. Also some of the quest items(triggers and such) are missing as well. Is anyone else missing these items as well?
@n1t3
Thank man got it:)
wish i can select them all once to change them all lol
#Ffs Died – get Quice it will do all of that for you. upload items etc. best program i’ve seen for editing and making items,creatures,etc.
@Colt45
If you’re using SQLyog or any other program to connect to MySQL open it up, then go press the “+” next to “realmd” to open up the list. Click on “realmlist” and make sure you select the “Table Data” tab. The first line you’ll see your server name (Default MaNGOS) then the address. Since you want other people to connect to your server, make sure you got your WAN IP there or your no-ip address in there.
Once thats done save and close it, then go to: “C:\Windows\System 32\drivers\etc” and open up your hosts file with notepad. You should already see:
localhost 127.0.0.1
and some other IP’s depending on what your system sets. At the bottom add:
127.0.0.1 “Your WAN IP here”
without the quotes. Save and close and have them try to connect again.
no nothing except realmd, and mangosd. i checked all the processes while i was running wow to make sure there wasnt anything running that took up any bandwidth …no luck with that either = /
Ok i did everything right i ran all the scripts and mangosd.exe and realmd.exe are running without error. I used the Mangos bat to configure my server for LAN use and it wont let me connect on other computers! Please I need some help!! Anone?
and i just created a lot of weapons, but how do i put the in the game.. i got the sql file and the code but how do i put it in the game so i can use em?
Do you have any internet related programs running? For example emule bitlord… downloading something? youtube? if so turn em off..
#rocko go into creature tab and lookup “vendor” when you go in to edit the creature look for the “npc flag” click on the … next to that field and it will give you a list… select vendor from the list, then upload the script. oh you will have to restart your server for the changes to take.
I’m having problems playing my own server on the same computer. I keep getting 2k+++++ latency while playing. At the same time my friend halfway across the country is getting upwards of around 100ms. Any answers?
I’ve tried connecting using 127.0.0.1 , my Lan ip and my public ip i get the same extremely high latency a solution would greatly be appreciated =)
@n1t3
i have quice but how do u change them to be use as vendors again?
on a side note you can change this value using Quice (link given above from Jakalth) it’s really useful and easy to use in my opinion. btw thanks for the link it helped. easy fix.
the vendors #’s 50001-500078 if you are having problems with these vendors (not the ones in the batch for GM island) they are labled as spirit healers which is why you only get a talk icon on them. just a note
@Informative
how did u get the vendors to even work?
cause everytime i .addspw a vendor its just not leting me open the vendor up to see whats in it
I linked to teh new DB from access odbc and using this query I got this mismatched items list:
Hope it helps. Perhaps we could get the SQL for the missing items?
SELECT npc_vendor.entry,npc_vendor.item FROM npc_vendor Where npc_vendor.item NOT IN (Select entry from item_template ) ;
vendor missing
entry item
19539 20284
100008 192
100008 33338
500063 6343
500101 13460
500101 32764
500101 32765
500101 32766
500101 32767
#steveo: I just type .Tele GMISLAND
It’s full of vendors now. I’m trying to debug the few missing items and find out what they are or replace them missing items with stubs of some sort to prevent the invalid item on vendor errors.
Maybe I missed something or perhaps doing the clean install instead of an upgrade will sometimes leave you missing a few tiny pieces. Not sure yet.
Gonna come back to the outside router can;t get from realm to chr screen issue after I get it running 100% cleanly.
forgot to mention that each time i try to teleport there, it closes and says wow has encountered a critical error and must close.
this is great, got everything working..now i have one question…how can i get to program/designer island?
Gmisland works yay!
Here are some more mangosd error messages – I think these are saying not all items on the GMIsland vendors exist in the items table probably..
WORLD: unknown spell id 34084
WORLD: unknown spell id 34084
action: 5
Vendor 100008 have in item list non-existed item 192
Vendor 100008 have in item list non-existed item 33338
informative I’ll take any suggestions I can get :-)
I have tried pretty much all you suggested except removing the router completely. Not really an option for me.
Please let me know how it goes when you reinstall SQL ticking the ‘allow remote access’ part. I’m going to try a few more things from my end but have exhausted all my options I belive.
Quick question…
Do we post here if we find ingame bugs or issues or email someone specific….???
Let me know, I got a couple of things to mention.
@Giff: I know suggestions coming from someone who still can’t get it to work either may seem curious (but I did have it working at one point by taking the router out of the chain entirely which I considered a non-solution). Oddly turning off the router firewall entirely doesn’t fix it either which makes me think it’s not port forwarding.
One thing I suspected and may yet be true is on the root password in the “MySQL Server Instance Config Wizard” I forgot to check off the allow remote access to the Root checkbox under where you type in the root password. That may have caused part of the problem trying a full reinstall with that selected this time.
#informative
I’ve forwarded just those 2 ports as well. You getting the same problem I am?
Do we need to forward anything else besides ports 8085 and 3724? I forward those to my static PC IP which looks like 192.168.1.180 or whatever.
All looks good except for this on mine.
Any ideas?
Creature (GUIDLow: 89384) has wrong spell 26248 defined in `auras` field in `cre
ature_addon`.
Creature (GUIDLow: 89385) has wrong spell 26250 defined in `auras` field in `cre
ature_addon`.
Creature (GUIDLow: 89386) has wrong spell 26249 defined in `auras` field in `cre
ature_addon`.
@Tim_C
You’re welcome
@Ffs Died
From what I could understand from Wow Vendetta you gotta download a program. Check around the forums, or make a new topic. they’re all pretty nice
Hi again guys.
I have just updated my server with 5054 and all went extremely well, but still unable to get people to connect from external sources.
I have added the correct port forwarding, have a dns entry pointing to my external ip. Added the entries into the hosts file for external and internal ip’s but still just bounces people back to the realm selection screen. I was unable to fix this in 5005 and was hoping 5054 might be different. Also running SQL 5.1 community in case you wanted to know.
Any help appreciated.
Giff
Hey i made an item on WoW Vendetta and i got the notepad with the code thingy inside it… now where do i place to notepad or where do i put in the code so it gets put in the game?
@Matron Thanks that worked :)
I have 1 other issue I cant seem to get working. Everyone and their mom can connect to my server public. I can connect to it fine as well. But my wife on the same router as me cannot connect. Any Ideas?
@Tim_C you may have GM mode on, just type .gm off that should fix it
Got 5054 up and running. My problem is that me and the map on my mini map do not load up. Any ideas on how to fix?
For some reason Mobs dont aggro to me and I can attack them but they don’t die … they are yellow to me.
@Rocko
Ah, okay, sorry bout that, if you find anything out let me know, I might be interested in learning that as well ;)
bug report #… something… can’t target any of the bosses in the theatre event
@Deg31
those are for GM vendors on GM island to show which is working fine but Mangos program it self also shows newer vendors added to the game which ID are from 50001-500078 i bleave im trying to activate one for the main city ie SW or org
@Rocko
Run the reaper-x-mangos batch and select 7 i think for the vendors…
*if i remember correctly thats how i did it*
I just finished updating 5005 with 5054 and it updated fine, BUT there are still issues. Mailboxes are still missing and so are the anvils and forges. Is anyone else missing these items as well?
Nero, are you not able to inject it using SQLyog or Navicat?
feared in tempest keep and i dropped out of the ship…
had to .die myself to get everything back.. it was funny but a bug.
i see that this version has Vendors added to the database was wonderin how u get the new vendors to show up ? like whats the command or something ?
Informative–>
You have your ports forwarded right?
When I want new items I usually jsut go here to grab new items.
http://wow-v.com/item.php?id=5216
Biggest problem I run into is the people from outside hitting the server get to the realm screen and then can’t get to the character screen. Has anyone solved this problem and have a good analysis of what the blockage is? I had it working once by putting the machine directly on the modem not through a router and turning off the machines firewall but thats not a viable solution.