[Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

[Stefan30]

Well, one more question ?....
Check out that... i'm already create a new account for AHBot (should the account be GM level 3 or 0 ?) ... after that i create a new character 1 level in game with name: Ahbot -> after that i log in with that character in game and i'm didn't do anything else... just logout with him... the next step what i make it was to open my sqlyog and saw the Account ID and char guid numbers
Check out that pic (Click to enlarge):
ahbot1.jpg
and let you check the mangosd.config it's right on what you said of me before some posts:
ahbot2.jpg
That's right ?? I didn't see the reasen which don't work the bot ;(

---

› See More: [Release] TRM's Cthulhu Ftagn Dual-Database MaNGOS Repack (3.3.5.12340) - 32 & 64-bit

[Stefan30]

For those who want to know what changes have been made from release to update 0021:

Major Changes

MaNGOS 10351 - 10429

Stability enhancement 8MB reserved stack size.
Aspeed, Speed, Flyspeed, Swimspeed updated from 10-255.
For item 50351 and 50706 fixed work in case no offhand weapon. 
Implement support explcitly started timed achievements.
Avoid access to DB at view GM tickets by chat commands.
Use time constants instead of hard coded values for STOP_TIME_FOR_PLAYER 
Correctly clearUnitState at Interrupt of WaypointMovementGenerator for creature.
Drop unneeded groupFlag and rename it properly.
PacketLog.* not used in core some time already so drop it.
A small spoon of changes and cleanup for WaypointMovementGenerator.
Restore triggered auras cleanup at main aura expire after auraholders adding.
Send proper error message at password check fail.
Remove trailing space.
Implement creature_movement_template.
More wide use ObjectGuid in way remove MAKE_NEW_GUID uses.
Restore build with gcc and cleanup includes a bit. 
Implement ACTION_T_MOUNT_TO_ENTRY_OR_MODEL (43) for creature eventAI.
Add portable way for hash specialization adding.
Making sure CreaturesAddon are re-loaded after creature evade.
Use AI function DoCastSpellIfCan for eventAI ACTION_T_CAST
Implement UNORDERED_SET support.
Rename UnorderedMap.h -> UnorderedMapSet.h 
More wide use ObjectGuid in group code.
Implement EFLAG_RANDOM_ACTION
Drop unused team-argument in ChooseDisplayId -function.
Fixes for EFLAG_RANDOM_ACTION
Updated MySQL client libs to 5.1.49
Fixed build at VS90 with TR1
Simplify use Guild::BroadcastEvent 
Avoid double lookup member slot in guild operations.
More wide use ObjectGuid in arena team code.
Finaly drop MAKE_NEW_GUID. 
Implement generic system for racial model selection.
Add missing holiday id<->battleground id definitions for AB
Store guid instaed pointer for first user of GAMEOBJECT_TYPE_SUMMONING_RITUAL
Fixed reset time calculation for some cases.
Traditional post-commit typo fix.
Remove Unit::GetUnit and update it callers.
Correct creature entry selection for raid difficulties.
Fixed quote parsing after optional arg in chat commands. 
Make spawntime arg really optional as before for .gobject add
Typo fixes.
Add several new script calls for InstanceData.
Restore build at Unix after Unit::GetUnit drop. 
Small correction in SetReputation to avoid confusion.
Add script call for InstanceData, OnPlayerDeath
Remove redundant use of this-> in recent implemented script calls.
No debug log output when a certain ability is active.
Send GMTicket to SendGMTicketGetTicket instead text. 
Fixed wrong difficulty selection and possible crash.
Fix mixed up FactionEntry to lookup in SetReputation 
Fixed typo in doc/EventAI.txt
Fixed crash in .aura command for spell without auras. 
Some code style cleanups. 
Use ObjectGuid in packets and fix some uint32 guids cases.
Stricted name check at chat command data loading from 'command' table. 
Additional checks for call assist. 
Restore remove spell affect 58427 after stealth fade. 
Fixed work .learn and other spell commands with unlearned talent shift-link. 
Add -o <outfile> option to genrevision. 
Fix mistake in recent debug log output change (ref 10395) 
Restore work of 47230 and ranks.
Fix wrong sql.
Fix broken sqls for spell_proc_event.
Add a BindIP warning to worldd/realmd config files 
Add some missing class/struct forward declarations and includes.
Constantify some functions in InstanceSave.
Sort triggered spell chains 44203 and 42231 in proper place `spell_chain` data.
Fix 71611 proc and remove check for family name if no spell_proc_event is defined.
Fix Battle/Guardian elixirs stacking.
Merge not-skill linked spell lists in `spell_chain`.
Check redundant single rank spell data in `spell_chain`.
Avoid send stop packet in PointMovementGenerator when unit is not moving.
Correct typo in function name.
Fix 71642 proc conditions.
Load most spell chains data from SkillLineAbility.dbc
Fix 50334 additional targets part.
Add comment in Aura::CanProcFrom
Remove not needed checks from IsNoStackAuraDueToAura
Drop redundant data from `spell_proc_event` after recent spell chain changes. 
Fix line ends.
Some format string fixes.
Improve detection removed ranks for spell in `spell_chain`

ScriptDev2 1778 - 1815

Minor code cleanup for ebon_hold.cpp
Correct two typos in boss_cthun. Patch by zergtmn.
Restore compile after changes in KilledMonsterCredit function. Requires Mangos 10363.
Add the missing .sql update for rev 1780
Update sources with changed ChooseDisplayId -function. Req Mangos 10373
Added support for boss Galdarah in Gundrak. Based on Gelu's work.
Added reworked version of Stratholme instance script. Blame Schmoozerd for any errors inside.
Added long time missing texts for arena event in BRD. Thanks to DaemonCantor.
Code cleanup in old_hillsbrad scripts and also move related gossip texts to database.
Re-design instance_old_hillsbrad
Added basic abilities of boss Drakkari Colossus in Gundrak.
Mortal Strikes proc rate might need adjusting.
Add a few missing texts in old_hillsbrad scripts. Correct a few existing and also added part of end-event.
Added a slightly more reliable way to prevent thrall from proceeding with waypoints before he should. Requires Mangos 10390
Fix r1786 sql, thanks Pandore.
Add more missing texts for old_hillsbrad and implement end event for the escort.
Reset old_hillsbrad escort at respawn.
Add lost call to escortAI JustRespawned, so escort variables are reset properly.
Removed obsolate code for boss Rockmar the Crackler in Slave Pens. Already implemented in ACID.
Reworked instance Gundrak.
Added cleaned up version of DasBlub's cleanup patch. Note: might need additional cleanup.
Added support for quests 5097 and 5098. Patch by virusav.
Might need additional core support.
Added support for quest 12916. Patch by virusav.
Corrected typo in dalaran.cpp. Patch by klark20.
Added support for quest 7603. Patch by Schmoozerd.
Fixed compile after r1798.
Fixed sql files from r1791.
Not check distance to group/player when escort is paused.
Fix crash after login, for the second time!! (ref revision 1267)
Add SetCurrentWaypoint for escortAi.
Can be used for escorts where points may be skipped (or continue from earlier reached) under special circumstances.
Implement relocation of thrall in case escort fail for any reason. Different locations are used, depending on overall progression.
Add missing semicolon in sql.
Some code cleanup, SD2 code style and enclose nested if's in () for readability.
Move some gossip texts to database.
Correct VC100 project file.
Use HandleEmote() also in DoScriptText function.
Move some crusader's gossip to database. Patch by patman.
In addition correct some bad style naming's and add missing for scriptloader.
Let boss_volkhan shatter only once. Patch by rise2.
Make sure cast is ok before yell and emote anything for volkhan shatter.
Add teleports related to quest 12548. Patch by crackm.
Remove some unwanted tabs and whitespace.
Manually reset button at unworthy initiate respawn.

YTDB 338 - 340

UPDATE 562_(10408)
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 130 caches (3.3.5a)

UPDATE 561_(10372)
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 117 caches (3.3.5a)

UPDATE 560_(10344) "Balthalionus"
+ all fixes from forum
+ fix spawn
+ quest scripts
+ mob's gossip menus
+ new templates from WDB
+ update table "*_template" by WDB
+ data from sniffs (templates, spawn)
+ processed 107 caches (3.3.5a)

btw great job about the updates and thanks for all that on you and your team

[CthulhuFtagn]

So, when you click Search at the Armory, what happens?

If, and I'm assuming you didn't read, the ReadmeAHBOT.txt file in the Cumulative Update Pack you would set your min and max items for the Auction House...

Here's my settings:

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Alliance";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Alliance";

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Horde";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Horde";

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Neutral";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Neutral";

I put the Readme files there for a reason.

You should get something like this when you click Search:


And, since I'm actually now CERTAIN you did not bother to read it... I'll post the portion you should have read.

#These are the settings in the Database:
#Each Auctionhouse has it's own set of these

MinItems = 0
#The Minimum number of items you want to keep in the auction houses.
#(default 0 - minimum will be the same as maximum).
#If it is higher than the value of the corresponding maxItems setting,
#it will be set down to match the maxItems setting.

MaxItems = 0
#The Maximum number of items you want to keep in the auction houses.

MinTime = 8
#The minimum number of hours for an auction.

MaxTime = 24
#The maximum number of hours for an auction.

#These must add up to 100 each one is the percentage
#of the auction items that should be trade goods of
#that quality. A value of 0 will disable.

PercentGreyTradeGoods = 0
PercentWhiteTradeGoods = 27
PercentGreenTradeGoods = 12
PercentBlueTradeGoods = 10
PercentPurpleTradeGoods = 1
PercentOrangeTradeGoods = 0
PercentYellowTradeGoods = 0

PercentGreyItems = 0
PercentWhiteItems = 10
PercentGreenItems = 30
PercentBlueItems = 8
PercentPurpleItems = 2
PercentOrangeItems = 0
PercentYellowItems = 0

#MinPrice(Color) is the minimum price adjustment for items. For example the default is 150, which means 150%. So if an item vendors for 1g it would go to auction for a minimum of 1.5g.
#MaxPrice(Color) is the maximum price adjustment for items.
#MinBidPrice(Color) these two control the starting bid as a percent of the buyout price. For example, if MinBidPrice is 30 and MaxBidPrice is 80 the starting bid for the auction will randomly be between 30-80% of the randomly chosen buyout price.
#MaxBidPrice(Color) these two control the starting bid as a percent of the buyout price. For example, if MinBidPrice is 30 and MaxBidPrice is 80 the starting bid for the auction will randomly be between 30-80% of the randomly chosen buyout price.
#MaxStack(Color) is maximum stack size to create for this quality type. A value of zero will disable the maximum stack size for this quality allowing the bot to create stacks (of random size) of items as big as the item type allows.

MinPriceGrey = 100
MaxPriceGrey = 150
MinBidPriceGrey = 70
MaxBidPriceGrey = 100
MaxStackGrey = 0
MinPriceWhite = 150
MaxPriceWhite = 250
MinBidPriceWhite = 70
MaxBidPriceWhite = 100
MaxStackWhite = 0
MinPriceGreen = 800
MaxPriceGreen = 1400
MinBidPriceGreen = 80
MaxBidPriceGreen = 100
MaxStackGreen = 3
MinPriceBlue = 1250
MaxPriceBlue = 1750
MinBidPriceBlue = 75
MaxBidPriceBlue = 100
MaxStackBlue = 2
MinPricePurple = 2250
MaxPricePurple = 4550
MinBidPricePurple = 80
MaxBidPricePurple = 100
MaxStackPurple = 1
MinPriceOrange = 4250
MaxPriceOrange = 5550
MinBidPriceOrange = 80
MaxBidPriceOrange = 100
MaxStackOrange = 0
MinPriceYellow = 5250
MaxPriceYellow = 6550
MinBidPriceYellow = 80
MaxBidPriceYellow = 100
MaxStackYellow = 0

#These are the multipliers that are applied to the vendor price for an item, that determines if AHBot will buy it or not.
#1 means AHBot will pay the same as (or less than) a vendor would pay, 2 means up to twice as much, etc.

BuyerPriceGrey = 1
BuyerPriceWhite = 1
BuyerPriceGreen = 5
BuyerPriceBlue = 12
BuyerPricePurple = 15
BuyerPriceOrange = 20
BuyerPriceYellow = 22

#BuyerBiddingInterval is the time (in minutes) between bids.
#BuyerBidsPerInterval is the number of bids the buyer will make in a cycle

BuyerBiddingInterval = 1
BuyerBidsPerInterval = 1



How to use ahcommands from the console (CLI) or in game with GM level 3 players:
ahbotoptions - will display usage instructions
ahbotoptions help - will display the list of commands

ahexpire - will expire all the auctions in the requested auction house that were created by AHBot.
minitems - will set the minimum number of items in the AH before it starts being filled again.
maxitems - will set the maximum number of items in the AH.
mintime - will set the minimum time (in hours) for auctions to expire.
maxtime - will set the maximum time (in hours) for auctions to expire.
percentages - will set the percentage of each quality in the AH
minprice - will set the minimum price multiplier for auctions.
maxprice - will set the maximum price multiplier for auctions.
minbidprice - will set the minimum starting bid as a percent of the buyout price for auctions.
maxbidprice - will set the maximum starting bid as a percent of the buyout price for auctions.
maxstack - will set the maximum number of items in stacks for auctions. 0 will set the maximum to the maximum for that item type.
buyerprice - will set the bid price multiplier for auctions.
biddinginterval - will set the number of minutes between bids on auctions.
bidsperinterval - will set the number of bids to enter per cycle.

The auction house IDs are:
2 - Alliance
6 - Horde
7 - Neutral

AHBot Originally made by Chris K.
Much thanks to Chris K, grether and Dolomit6!
AHBot Now includes AHBuyer created by Kerbe as a derivative of AHBot, and later modified by Paradox

[Stefan30]

So, when you click Search at the Armory, what happens?

If, and I'm assuming you didn't read, the ReadmeAHBOT.txt file in the Cumulative Update Pack you would set your min and max items for the Auction House...

Here's my settings:

UPDATE auctionhousebot SET minitems = "100" WHERE name = "Alliance";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Alliance";
 
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Horde";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Horde";
 
UPDATE auctionhousebot SET minitems = "100" WHERE name = "Neutral";
UPDATE auctionhousebot SET maxitems = "500" WHERE name = "Neutral";

I put the Readme files there for a reason.

You should get something like this when you click Search:

And, since I'm actually now CERTAIN you did not bother to read it... I'll post the portion you should have read.

Jesus Christ! Dude, you are my GOD ... i told ya i'm a newbie and i need more thorough explaination THANKS MAN !

[CthulhuFtagn]

Not a problem, maybe that'll help others who couldn't get it started right.

[GrandpaJohn]

@CT:

all updates injected successfully server and auctionhouse working great keep up your great work man its appreciated on this end much

[CthulhuFtagn]

Awesome GJ, I will.

[marko94]

MySQL is reporting that my creature_respawn table from mangos DB is marked as broken and needs to be fixed, so I was wondering can anyone who's creature_respawn table isn't broken dump their SQL and share it with me to fix this ?

[CthulhuFtagn]

In SQLYog, click on the creature_respawn table then click Tools > Table Diagnostics then click Repair

[calarus]

So the repack works just fine. For some reason my friend who has the server can log in just fine yet when i go to connect, i get stuck in a loop at the realm selection screen. what would cause this and how can we fix it? thanks