Reaper Mangos Mod 4651, Scriptdev2 151 AHBot with JailPatch and Unified Database

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

Mangos DB Installation

3. Choose option number 4 to configure the datadir and rate

adjusting mangos data directory

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

Creating account

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

Reaper ahbot configurator

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 :

Auction House Mangos

Adjusting your Reputation :

Set reputation in mangos

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

Comment?

Note: Comment may not appear right away.

109 comments on “Reaper Mangos Mod 4651, Scriptdev2 151 AHBot with JailPatch and Unified Database

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

  2. 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?

  3. 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?

  4. 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!
    [email protected]

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

  6. 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???

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

  8. 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?

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

  10. 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?

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

  12. 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?

  13. 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) :(

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

  15. # 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

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

  17. 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?

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

  19. :(( 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:((?