Custom Search
Reaper Mangos Mod 4651, Scriptdev2 151 AHBot with JailPatch and Unified Database
Posted by Reaper-X Oct 29 2007 11:57 pm
Just as i said before, that i’ve decided to also release Mangos that is using additional patches based on suggestions made by various commenters here :) … And unlike my other release that is designed to those who prefer to stay out of the trouble, this one is designed to those who already know how mangos work and such stuff … so if this is the first time you’re using Mangos, i’d suggest you to grab the normal version instead or if you’re feeling a little bit adventurous, you can try this one ;)
But first as a reminder that this Release only work with WoW 2.2.3 Client, and tested with TBC Expansion Pack installed, but to those who doesn’t have TBC Expansion pack installed, you can disable it by editing the mangosd.conf to disable expansion map
And here’s some information about this first Reaper Mangos Mod release :
1. Using Auction House Bot as suggested by Jordavius, to populates auction house with random items
And to make things easier to those who don’t know how to see their character GUID and their account ID number for the Auction bot purpose and they’re installing for the very first time of this release (i assume that you’re already familiar with mangos although you’re installing for the first time), i’ve created one account and one character (built-in) for the purpose auction house bot that own the items
the character information that is included used for the auction bot use (to those who are going to use the fresh install without modifying anything) :
Account ID : 5
GUID : 2
Username : reaperbot
Password : reaperbot
Important Note : for some people it might cause conflict especially to those who are going to Restore their character backup into this new database because there’s a high chance that you already have a character using the ID and GUID that is included by default and so to those who are going to use character data restored from my normal release or other release (perhaps) make sure to follow the installation steps after the fresh install section :)
2. Using Jail Patch as suggested by J. J. Roddy to make you easier to adjust character reputation to specific faction
3. Using another database name (mangosmod and realmdmod)
4. And i assume that you’ve installed MySQL of course :P
Download Link :
UPDATE : Reaper Mangos MOD 4703 has been released :)
1. Reaper Mangos Mod 4651 SD2 151 AH Bot and JailPatch | 9.48MB | Rapidshare
2. Reaper Mangos Mod 4651 SD2 151 AH Bot and JailPatch | 9.48MB | Megaupload
Fresh Installation (without restoring your character data into this one) :
1. Extract DBC, VMaps and Maps
2. Run the reaper-x-mangos.bat and write your mysql bin directory when prompted and then choose to install the database first
3. Choose option number 4 to configure the datadir and rate
4. Edit realmlist.wtf and replace :
set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com
into :
set realmlist 127.0.0.1
5. Start mangosd.exe and realmd.exe
6. Create new account using these commands :
- create myusername mypassword
- setbc myusername 1
- setgm myusername 3
and login :)
Using Data Restored from my normal Mangos release or other release :
1. Backup using reaper-x-mangos.bat provided with my normal release
2. Copy the backup file (backup-realmd.sql and backup-db.sql) into reaper-eazy-mangos directory in this mangos mod release
3. Choose to install the database and wait until it finished
4. And then choose the fourth option to configure the datadir (don’t use the mangosd.conf from my normal release because there are many changes) and adjust the rate … and then you’ll get the mangosd.conf file for this mangos mod release
5. Now open the mangosd.conf in this release and search for these lines :
# Auction House Bot character data
AuctionHouseBot.Account = 5
AuctionHouseBot.GUID = 2
and replace it with :
# Auction House Bot character data
AuctionHouseBot.Account = 0
AuctionHouseBot.GUID = 0
6. Now choose to restore your backup using reaper-x-mangos.bat in this release
7. Now start the mangosd.exe and realmd.exe process, and create a new account for the Auction Bot purpose, and don’t forget to login at least once using that bot account
8. Now stop the mangosd and realmd process (shutdown your mangos server)
9. The next step is choose the option number 6 in reaper-x-mangos.bat to get your character account ID and GUID for AH Bot purpose as shown on below image for an example :)
from the above image the Character Account ID is 5, while the GUID for that character is 2
10. Now you just need to open mangosd.conf once again and then look for these lines you’ve edited before :
# Auction House Bot character data
AuctionHouseBot.Account = 0
AuctionHouseBot.GUID = 0
And replace it with the value you received from the AH-BOT Configurator (i guess that name is not bad at all) :P
# Auction House Bot character data
AuctionHouseBot.Account = 5
AuctionHouseBot.GUID = 2
The first value is your character account ID while the second value is your character GUID :)
11. Start your mangos and realmd process once again … and done !!! congrats … now you can login with your real character
And here’s some new additional commands for you (GM Only) to use which is available in this release :
1. jail – Syntax: .jail character hours [reason]
To jail character of course :P
2. jailinfo – Syntax: .jailinfo
Shows your jail status
3. unjail – Syntax: .unjail character
Releases character out of the jail
4. pinfo rep | jail – Syntax: .pinfo [$player_name] [rep] | [jail]
Output account information for selected player or player find by player_name. If rep parameter provided show reputation information for player. If jail parameter provided show jail information for player
5. setrep (reputation) – Syntax: .setrep REPID REPVALUE
Sets the REPVALUE of the reputation with the REPID to the REPVALUE. You can use .pinfo rep to get known reputation ids
6. setap – Syntax: .setap VALUE
Sets the arena points to the VALUE (0-999999)
7. sethonor – Syntax: .sethonor VALUE
Sets the honor to the VALUE (0-999999)
8. ahexpire – Syntax: .ahexpire <house id> <player GUID>
ahexpire will expire all the auctions in the requested auction house with the player GUID as the owner
9. ahdelete – Syntax: .ahdelete <house id> <player GUID>
ahdelete will delete all the auctions in the requested auction house with the player GUID as the owner
Auction House Bot Screenshot :
Adjusting your Reputation :
Related Links :
Using 2 Realmd in WoW Mangos
Installing MySQL on Windows
Complete Mangos GM Commands
Setting up WOW Server for LAN or Internet
Installing Web Server for Mangos Registration Page
Trackbacks/Pingbacks
Leave a response
Connect with me
yes i got a question can some1 link the download site’s for this new mangos servar pls
Reaper, do you know how to add custom weapons/items/mobs into the game?
I realy like this page and it whold be fun to try out the life as a GM but i don`t understand how to do this with the downloads and making accounts and that stuff, so i coold need some help
I regards to the netherwing update sql files. I am pretty new at this. Could someone point me in the right direction regarding how to bring these updates into the database?
To caxeman:
If you go into the folder “reaperMangosMod4651″ then “reaper-eazy-mangos” and run the .bat file reaper-x-mangos.bat” choose option 5 and I thinks its the second question which lets you select your realms name.
Hope this helps,
Sh@d0w
hey i got everything finally setup to the point where i can have anyone connect to my server(16+ hrs, lol).
the problem is i want to change the name of my realm from Reaper-X to something else… how?
Hey Reaper-X,
Great work, I got it up and running with no big problem.
Just a few of questions:
1) In the config is there a way to increase the skill exp rate? I have no idea what the command is and couldn’t find a commented one.
2) Can you explain to me how to make an online registration site, so my friends can make an account on the net from their homes, instead of me entering them manually.
3) Is there a way to enter custom items into the games (e.g. “The Sword of A Thousand Truths”), I have seen another server where a GM had that item.
Thanks Your Work Rocks!
Sh@d0w
I am getting these errors every time i try and open my realmd file can anyone help me
2007-11-09 17:14:31 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone`,`allowedSecurityLevel`,`population` FROM `realmlist` WHERE `color` != ‘3′ ORDER BY `name`
2007-11-09 17:14:31 ERROR:query ERROR: Unknown column ‘allowedSecurityLevel’ in ‘field list’
2007-11-09 17:14:31 ERROR:No valid realms specified.
Me and some players are being blocked in the game:(( i mean…we log in…and we can’t do nothing..it is as if we have high latency…and we can’t do nothing..BUT we don’t have latency…i didn’t have this problem before updating to 2.2.3…. what’s the problem???
I’m on the latest patch out right now and cant connect to the realm I made. What am I doing wrong? Do I need to be just on 2.0 or what? I have reaper mangos 4651
There is a fix for the netherwing for project silvermoon there is 3 sql files in the zip i have tested it and it works just fine with reaper-x newest build Reaper Mangos Mod 4651
the link is http://projectsilvermoon.net/index.php?showtopic=6080
you must have a account to access there forums
Is anyone else having a problem with the Mangosd.exe crashing randomly? I cant seem to keep it up and running and I have found some Restarter programs but all they do is lockup the computer!
any suggestions?
reaper i check to see like you said all the files are showing and it is not in there is there a way you could fix it on your end and then i could redown load the ubot mangos again pleasee and ty you for the tech support still cant lan any of the kids
I’m having a problem, I have everything working. When I log in and go to my real it seems fine but then it just keeps coming up with the realm list thing over and over even if you click it. If you click cancel it goes to the area where characters are suposed to be, but none are there and I can not make one, what do i do?
#reaper
argg im using silvermoon and udb but its the same.. mage trainers dont have arcane missile rank 1 T_T
i have the ports needed forwarded for mangos at least it worked before using jsut an ip address… but then with the DNS it only worked on my lan network
reaper for my site create account nessecity i use
use realmd
alter table account I use vachar(32):
for create account in site i no use and site no crate account one message error no possible create
a account tal
are possible i create account and no use that command?
your welcome Jesse :)
as for your question, unfortunately the npcs at gm island is custom made by silvermoon project and this modded version use the unified database (because currently udb is more compatible with this version, and there is no new updated release from silvermoon yet as for now) :(
Hey reaper thanks a lot for the help. I have another question for you, I just installed the modded version of 4651 and it works great, however when I .tele to GM island all the vendors that were previously there are now gone. Bummer. Anyway I was wondering if there was a fix for this??
Thanks again
# Crono
If you’re not using enUS version you’ll need to edit the extract.bat using notepad and change the enUS into your WoW version, like enGB for example
# Silly
are you sure you’ve typed the command correctly ? i just tried it again to make sure and it worked just fine :)
try typing .setrep only
# renato
it seems to me that you’re trying to upgrade from a really old version of mangos that doesn’t use encryption
the solutions to that are :
1. Do a fresh install without restoring your character data
2. Convert the previous character data and also encrypt your password using new mangos encryption
btw if you could tell me which mangos revision you’re running previously i could help you with converting your data :)
# janiks
Unfortunately that’s more related to database problem, i’d suggest you to head over to udbforums.org :)
# elliott
first of all you’ll need to set up port forwarding first before doing anything else (i can’t really tell you how because every router has different configuration page), because that’s the most important thing of all before setting up your realmlist to be accessible from another computer
# will
Yep … the reaper-x-mangos.bat inside the reaper-eazy-mangos directory (if you couldn’t see the file extension try doing these steps)
1. Tools -> Folder Options -> View tab
2. uncheck Hide file extensions for known file types
reaper do you mean it is inside the intalltion some where in the matrix thing i will find the line or no sorry just confused where in the mangos bat it is ty for your help
hey i have a dns: alldaypvp.no-ip.biz but for some reason none of my friends can connect to it.. do you know why??
some trainers lack some skill T_T like mage mage trainers dont have arcane missile rank 1 how to fix this?
hey reaper plz help me i install a mangos and all ok i enter in server my friends enter + i create one site and site account creation ok + i go enter in server no possible i join have a error:ERROR:SQL: INSERT INTO `account`(`username`,`I`,`joindate`) VALUES(’porra’,SHA1(CONCAT(UPPER(’porra’),’:',UPPER(’interesante’))),NOW())
SQL ERROR: Unknown column ‘I’ in ‘field list’
plz u help me?
Reaper, ty for the reply
I have download the version 4651 from the above link you have supplied and follow the steps to upgrade from version 4629.
I can use the command .pinfo to get the listing of reputation. But when I use the command setrep it say command unknow.
Thanks
:(( When i start mangosd.exe it gives me an error : You have outdated DBC files..and if i want to execute the DBC extractor it says that :system cannot find the specified file..what should i do:((?
# ryan
Are you experiencing that problem with this release and using UDB ?
# ppk & Bigdave
Your welcome ppk & Bigdave , glad you like it :)
# will
Actually the bat file is inside the reaper-eazy-mangos directory :)
ok reaper i tryed to find this file but i could not find 1. open reaper-x-mangos.bat
2. locate these line :
echo USE `realmd`;
3. replace it with :
echo USE `realmdmod`;
help me please where i could find it to fix the problem so i could get the lan working again please ty alot
Reaper A word of thanks from a load of our South African wow players with lagg being crazy most of the time setting up your our own private web server was amazing, nway to the guys wondering on how to make this work with GB version and dont have much batch file experience just go and rename your enGB files inside dbc folder to en enUS and run the batch file easy and it works lol. THANKS again Reaper you Rock
Ppl what is
game event 27 “nights” ?
got everything working finally (had some problems with the MySQL config), which by the way, if anyone is getting the ‘Could not connect to MySQL database @ 127.0.0.1′ error, log into your mysql server (mysql -u root -p) and run the ’status’ command. This will tell you which port your MySQL server is configured to (default 3306 but sometimes different), make sure in your mangosd.conf and realmd.conf have the same port listed in the status command. I kept getting this error because the config files were looking for port 3306, but mySQL was setup on port 3308.
anyway~ to the point, Reaper – whenever i run into ogrimmar, and try to go to the auction house area, i get teleported to Azshaara Crater, but not when i run around the back way (left side of bank and around back of windrider tower), any reason why this is happening? I basically cannot get to the auction house or the steps leading up to the windrider (ONLY in orgrimmar)
Mci Thx alot for you help =D
Sorry I forgot to add the config file add it to diskw/usr/local/mysql/bin/ .
http://rapidshare.com/files/67817548/my-small.cnf.html
FATEXA,
the first step is :
1. Extract DBC, VMaps and Maps
if you need help with that go to…
http://www.reaper-x.com/2007/10/10/wow-mangos-map-vmaps-and-dbc-extraction-guide/
I think That would solve your Problem.
Hi all !
For all out there who are interested in a premade ready to use Registration Page ….Witch is Easy
So Easy !
I managed to make one and It is your’s to use.
I’m Sharing it on Rapid share .. * my net is sooo slow…DonE (6986KB)(With a start.bat :))
http://rapidshare.com/files/67808812/MangosRegistration.zip.html
Reaper,
thanks a billion. Your continued excellent work on simplified mangos installations has repeatedly made my life a hell of a lot easier the last few weeks. Your reaper-eazy batch file is simply a fire-and-forget tool – easy and extremely effective. Junst wanted you to know how much I appreciate what you are doing.
Keep up the splendid work!
Bigdave
Or a ready to use Registration (with all the Progs and pages,with a Start.bat :) Ummmm….) like the one I have On the old server.
Hello ppl, i have a litle problem and im noob in this stuff, i open mangosd and give me error,
could not find vmap file, i apreciat any help thx :)
yes i do hav the net runtime 2 i got all 3 installed 1 to 3
i have tryed multipull premade registrations and none of them have worked so far… if you want any suggestions for up coming topics configureing mysql with apache 2.2 and php 5 would be sweet!
Nevermind, I fixed the problem. It turns out the Mangos I was using (4524) was too old to upgrade from, so I had to manually upgrade my data :P Thanks again for the great guides and files, Reaper-X! You helped a bunch of bored and broke college dormies :D
Hey Reaper-X, thanks a bunch for the great releases! I’ve been having a couple problems with this release though…
1) When I lauch mangosd.exe, I get an error saying “unknown column ‘population’ in ‘field list’”.
2) realmd.exe gives me an error saying No valid realms specified.
Any help would be greatly appreciated!
there is no need I’ll just make them play from the Beginning ….. lol
Wit the old server I got a Dir. called “Disc W” and in this Dir. it stores all ht data for the server + apache + Php . and a Start.bat file that makes my life easy :),
here is the Start.bat :
diskw\home\admin\program\pskill.exe Apache.exe
IF NOT ERRORLEVEL 1 goto started
set Disk=%1
IF “%Disk%”==”" set Disk=w
rem create the disk
subst %Disk%: “diskw”
IF ERRORLEVEL 1 goto hint
set apachepath=\usr\local\apache2\
set apacheit=%Disk%:%apachepath%bin\Apache.exe -f %apachepath%conf\httpd.conf -d %apachepath%.
set programit=%Disk%:\home\admin\program\
set closeit=%programit%close.bat %Disk%
%Disk%:
cd \usr\local\php
start /MIN \usr\local\mysql\bin\mysqld-nt.exe –defaults-file=/usr/local/mysql/bin/my-small.cnf
CLS
echo The server is working on the disk %Disk%:\ [http/127.0.0.1/a/]
start /MIN %Disk%:\home\admin\WWW\redirect.html
start /MIN %programit%miniserv.exe “%apacheit%” “%closeit%”
goto end
:hint
CLS
echo The disk %Disk% is busy. Use start.bat [disk letter]
goto pause
:started
CLS
echo ERROR!!!
echo One of the instances of MySQL server is started. Use stop.bat
:pause
echo .
pause
:end
exit
Can I use this somehow to be able to create accounts on my new server ?
actually if you’re restoring database using my batch file it’ll overwrite the bot id so you’ll need to set up account for bot purpose :)
but since you’re moving from a quite old release, there’ll need some adjustment first
if it’s okay with you, you can send the backup file to me (backup first using my batch file and then send it to me just like this guy did) :)
http://forums.reaper-x.com/topic/importing-characters-in-reaper-mangos-4651
I have an old mangos server 3604 Can I insert the players informations and characters from that server into this one ?
Will i have problems with the bot’s ID ?
The client is 2.2.0 , I think :)
Updating now :)
Sorry
# will
Well actually i made a mistake by not changing the realmd to realmdmod in reaper-x-mangos.bat (i’m really sorry i completely forgot about this)
as for the solution :
1. open reaper-x-mangos.bat
2. locate these line :
echo USE `realmd`;
3. replace it with :
echo USE `realmdmod`;
# Silly
Are you using this release or the normal version ? the setrep only available in this release only because it can be considered as mod / non official :)
# Checkmate
Take a look at the about page at the top of this page / every page :)
# Darksun
You can try opening mangosd.conf and look for the AHBot entries there to adjust it to your liking :D
# Mci
Did you extract the DBC files from WoW 2.2.3 client ?
This is the error I get :(
Some required *.dbc files (4 from 39) not found or not compatible:
d:\mangosmod\data/dbc/BankBagSlotPrices.dbc
d:\mangosmod\data/dbc/DurabilityCosts.dbc
d:\mangosmod\data/dbc/DurabilityQuality.dbc
d:\mangosmod\data/dbc/StableSlotPrices.dbc
question about the AH-BOT. is there someway to get this BOT to put in more items on the AH that what it does on it’s own ? as there is not much really that gets onto the AH that one can buy from..
Thanks,
Just wanted to know where to find your email address I have one specific question to ask thanks.