EmuCoach Cataclysm v20.0 and MoP Premium 7.1 Repack News

Col_Boltman12278 said:

The Auction house Bot is broken. Bad GUID coded in for the auctioneer (23442) and the character GUID is bad too (279). Only 249 Items appear in the 3 auction houses, horde, Neutral, and alliance. The item cycle refresh is non working probably because of the bad GUIDs of the auctioneer. I was able to at least get the 249 Items to appear by changing the sql fields to 274539 for the auctioneer and 300 for the Emucoach character that was already created. But there should be burst value in world.config to flood the auction house with items then a cycle refresh amount to continue the flow. Im also getting the character GUID overflow crash with the bots and pets. I had to disable their ability to summon pets and then reduce the amount of bots from server default of 300 to 50. I'm really bummed about the auction house tho.

Click to expand...

Extrukistoravon said:

AUCTION HOUSE BOT - SQL Configuration (outside the worldserver.conf)

If you do not have an AH Bot Account yet, create one via worldserver cmd, in the worldserver window after it is running type this and hit enter:

.account create AHBot 1234

You now have a Account named "AHBot" with Password "1234".

Log into it and make a level 1 Character. Login. Logout. proceed.

---

The Auctionhouse Bot must also be configured in the worldserver.conf file.
It had a missmatching GUID for the character to use, after setting it to an existing character on a non player account (used heidi sql to acess the Database) it worked.

Example:
AuctionHouseBot.Account = 3 (this account must exist find it unter SQL DB: MOP--auth--account)
AuctionHouseBot.GUID = 44068 (this GUID must exist find it under SQL DB: MOP--characters--characters look for account you used above in 2nd row, use this guid)

The Account needs 1 Character, the Level does not matter, the faction or race does not matter, it does not need gold or gm level.

---

Item Number and Quality

You need to do more configuration if you want more items or specific perentage of grey to blue to epic.

GUIDE:
Open the Database in for example HeidiSQL
-MOP
--Characters
---auctionhousebot

Change MAXITEMS to whatever maximum items you want on each auctionhouse

---

OPTIONAL % Changes for the # of items per quality level:

TRADEGOODS: Change the corresponding "percentagewhitetradegoods" and "percentagegreentradegoods" to whatever percentage you want to be in the auctionhouse, do this for all of them grey, white, green, blue, purple - caution by adding orange and yellow (default is =0, better keep this way)

ITEMS: Change the corresponding "percentagewhiteitems" and "percentagegreenitems" to whatever percentage you want to be in the auctionhouse, do this for all of them grey, white, green, blue, purple - DO NOT add orange and yellow (default is =0) this will add items that do not belong in the auction house like Kael'thas temporary weapons.

Enjoy.

Click to expand...

SELECT c.guid, c.id, ct.name, c.map, c.position_x, c.position_y
FROM creature c
JOIN creature_template ct ON c.id = ct.entry
WHERE ct.npcflag & 2097152; -- 2097152 is the internal WoW flag for Auctioneers

Loading Item Auctions...
>> Loaded 4400 auction items in 16 ms
Loading Auctions...
>> Loaded 4400 auctions (and 0 deleted as expired) in 7 ms

Click to expand...

Extrukistoravon said:

@Col_Boltman12278

You need 1 AuctionHouseBot. ONLY 1. Do not try to make more!

worldserver.conf
AuctionHouseBot.Account = 3 <<<<<<<<<<< This is your Account ID for the BOT Account
AuctionHouseBot.GUID = 44068 <<<<<<<<<< This is your Character GUID you created with the BOT Account

You need to look both up in the SQL Database as described above.

You can not use my data!
You can not use the previous data!
You can not use anyone else their data!

You MUST find or create your own combination of Account ID and Character GUID as described above. _ Click here_

The GUID __must__ belong to the Account ID you used, or else the server will not find the character because he uses the wrong account.

The Characters Level does not matter, the faction or race does not matter, it does not need gold or gm level. The Auctionhouse bot does post regadless of everything, he can populate the horde auctionhouse if alliance and vice versa. He needs no gold to post or buy auctions.


FIX in SQL for MISSING Auctioneer GUID23442

Ok, i missunderstood and know what you mean. I do not have the scource code. Try to change allready in place Auctioner to the GUID 23442 for example

Auctioneer-jaxon present in Stormwind

You can Filter the Auctioneers with this SQL script. Run in MOP>>WORLD

Code:

SELECT c.guid, c.id, ct.name, c.map, c.position_x, c.position_y
FROM creature c
JOIN creature_template ct ON c.id = ct.entry
WHERE ct.npcflag & 2097152; -- 2097152 is the internal WoW flag for Auctioneers

Replace whatever GUID the Auctioneer has with 23442. At least my error is gone for the moment tho i only seem to have 400 Items online.


Update - after waiting some time:

Click to expand...