Thanks trm your the best!
Printable View
Thanks trm your the best!
Really liking the repack but having trouble getting the ahbot to come back to life. Had it working for a bit a couple of versions ago but not sure what the settings I had then were and it's related to them or what...
My latest attempt has been with AllowTwoSide.Interaction.Auction = 0 and
AuctionHouseBot.EnableSeller = 1
AuctionHouseBot.EnableBuyer = 1
AuctionHouseBot.Account = 7
AuctionHouseBot.GUID = 6
AuctionHouseBot.VendorItems = 0
AuctionHouseBot.LootItems = 1
AuctionHouseBot.OtherItems = 0
AuctionHouseBot.No_Bind = 1
AuctionHouseBot.Bind_When_Picked_Up = 0
AuctionHouseBot.Bind_When_Equipped = 1
AuctionHouseBot.Bind_When_Use = 1
AuctionHouseBot.Bind_Quest_Item = 0
AuctionHouseBot.ItemsPerCycle = 1500
AuctionHouseBot.UseBuyPriceForSeller = 0
AuctionHouseBot.UseBuyPriceForBuyer = 0
Account 7 is a pure ahbot account with a single character guid = 6, account = 7
The auctionhousebot table has alliance and house min/max at 2500/3000 and neutral at 500/1000 everything else default.
I'm not seeing anything in the mangos startup about the ahbot.. just the section on loading auctions, does that mean it's not being loaded at all?
Any help appreciated.. also any info on how often the ahbot is meant to activate and if there is a manual way of forcing a cycle that would also be great to know.
@ Vard;
in the characters DB auctionhousebot table i have my alliance, horde, and neutral all set to min/max the same 1000, pretty sure that the min/max is suppose to be the same and mine works just fine
Hey there, first time user of a repack.
I got he server running and everything right off the install, however it doesn't seem to have AHBot installed... When I go to the database, the character.auctionhousebot table does not exist.
I tried running the accumulative updates, it added the table, but now Mangos won't boot.
WHat exactly is needed on this fresh install to make AHBot run without killing mangos?
@ revel;
in the updates there is an instruction sheet to tell you haow to setup the auction house try reading it and follow the instructions
@ GrandpaJohn
Thanks for the advice - tried with min/max set to 1000 for each but the auction table remains empty. :(
Does the server need to be up for a certain amount of time before the ahbot activates now? From memory when it was working it first populated the auction hour upon boot up and outputted some messages.
@ vard:
make sure that you go into the auctionhousebot table and not the auction table or the auctionhouse table because you are saying auction table they are all 3 in the characters db
@ GrandpaJohn
the auctionhousebot is the table that I have been putting the custom settings, the auction table is the one where I previously had auctions but now since my testing is empty. I don't have an auctionhouse table at all. Just did a new test install of Server_TRM335a + CU_0073 and it didn't create that table. Maybe this is the one that's causing me grief. What is in the auctionhouse table on your server and if it is small is it possible to post a sql dump of structure or structure & data?
Edit: Actually it looks like auctionhouse is the old name of the auction table. Checked the sql structure of the current db at git and it's not there though it's still listed on the wiki. Looks like a recent change. Maybe this is not my problem :|
Edit2: In case it was an issue with the data I brought over from a different repack I tried from scratch but still had no luck. I'm pretty sure the first time I saw it working it populated the auctionhouse right at the startup of mangod. So unless I was mistaken or that has been changed then it's not just cause I am not letting it run long enough.
Can someone tell me if I have missed something with the following steps?
Code:moved previous server directory
extracted Server_TRM335a to c:/server and started up mysql
updated with CU_0073 (replaced manges x64 and executed the sql updates using sqlyog)
moved the dbc/maps/vmaps directories across and started mangosd and reamld (x64)
created an ahbot account (ussing .account create & set addon / set gmlevel)
logged on, created a character, logged in with the character then quit (sqlyog shows it to be character 1, account 5)
Modified mangosd.conf (from the CU_0073 template)
AuctionHouseBot.EnableSeller = 1
AuctionHouseBot.EnableBuyer = 1
AuctionHouseBot.Account = 5
AuctionHouseBot.GUID = 1
set minitems and maxitems to 1000 for alliance, horde and neutral records in auctionhousebot table using sqlyog
restarted mangos but still didn't see any messages about ahbot in the console up
checked using sqlyog and the auction table still not populated
How do you backup all the account information? I need to reinstall my OS and I don't want people to start back over.
Thank You
Easiest way would be to just copy the entire server directory.
Next easiest would be to just copy the MySQL directory (also a lot smaller without the maps, dbc and vmap directories)
Last would be to use sqlyog and use the backup functions there to create sql dumps of the tables.
If you only do a partial backup make sure you reinstall them back to the same version of the server or make sure you know how to update the tables to match a later version.
CT friend just an update about that problem with the rogue...the Pick Pocket ability also does not work...it causes the mobs to attack you :(
Just to let you know :)
Continue your great work :)
AHbot doesn't load anymore in patch 73. reverting back to 72 he works fine. Anyone else having this issue?
Quote:
Originally Posted by junebuggy64
The AHBot was not compiled into 73 - Confirmed
This issues is on the UDB/YTDB forums as a known issue. It hasn't been assigned to be fixed as of yet. I am sure it will need some core side corrections along with database from what I read. Just to let you know it is a known issue.Quote:
Originally Posted by Narcoleptic
Thanks :) and sorry i didn´t know that :( i thought that only the stealth was bugged sorry...
Edit: can you confirm that the training dummy is messed up again...? it was working so fine :(
Ill check that. If it is, I am sure CT just forgot to input a couple of the addin's he has compiled, nothing major.Quote:
Originally Posted by Narcoleptic
I was thinking that I done something wrong with the last update and was about to reinstall just to get the AHBot working again.
@ Vard
In your 2 previous posts it looks like you have the guid and account for the ahbot set wrong. guid 1 should be your admin not your ahbot. double check them then try again.
I just wanted to say i've spent the last week and a half searching for a repack and a guide i can understand (I'm new to this) and this is the first one that only took 10-15 minutes to get up and running and it runs beautifully thanks a ton!
I believe you are incorrect.. They both should be set to the toon you want as your ahbot..Quote:
Originally Posted by wjcb1975
Thanks for ya advice wjcb1975 but from what others say it sounds like the issue is that the ahbot has not been compiled in CU_0073, I'm happy to wait till the next update and give that a go.
The character guid and account are one of the few things that I know have always been set the same way from before when it was working. I understand in some of the later builds of ahbot (the development tree) that you don't even need a dedicated account and character. However not sure if CT is planning to use that or the more stable release. I really don't mind - just be happy to have it back without the effort of compiling it myself :)
Update Available:
Filebeam Mirror:Code:MaNGOS updated to 10636 (required_10629_01_mangos_mangos_string)
Implement server side check combo points req. for spell cast.
Ignore another map target for text emote.
Convert many opcode handlers to ObjectGuid use.
Include non-percent mana cost in EffectDestroyAllTotems mana return.
Correct behavior for completion of quest objectives.
Small comment style fix in mangosd.conf
Small code style cleanup in quest related functions.
Convert Set(Get)ChannelObjectGuid to ObjectGuid way.
Drop function GuidHigh2TypeId
SQL update for prev. commit
Use ObjectGuid for player's selection and unit's target.
Fix logic in FillRaidOrPartyManaPriorityTargets and FillRaidOrPartyHealthPriorityTargets.
Fix bad ban date check.
Implement SPELL_EFFECT_CLEAR_QUEST (139)
Fix quests w/QuestFlags QUEST_FLAGS_AUTO_REWARDED
Make .respawn work correctly with BG event spawns.
Set respawn delay for BG creatures before set dead state.
Add new field RequiredClasses for quest_template.
Fixed MSG_MOVE_HEARTBEAT structure.
Clarify premade groups mode config option.
Properly update objects usable state at GM-mode on/off.
Fixed array access in SCRIPT_COMMAND_TALK loading check.
Simplified trade distance checks, GROUP_UPDATE_FLAG_POSITION flag handling moved out of Map.
YTDB updated to 347 (569_FIX_10625)
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 220 caches (3.3.5a).
CU_0074.zip (17.04 MB)
Mediafire Mirror:
CU_0074.zip (17.04 MB)
http://img87.imageshack.us/img87/1579/consolef.jpg
Thank You for the update is the AHBot working in this release? Or is it me :-)
@ CT:
update 74 executed successfully, no errors, server up and running great keep up your great work bud
Update 0074 Added :D
Thanks Keep Up The Great Work
74 Executed without error, many thanks for your work CT.
great work............. my friend.....thanks.. very nice..
hi ct
i have a question to ask and i say sorry now if this has been answer
my desktop died and now i have to set this repack up on my laptop.
so when i load the main server do i have to load all the update or just the latest
thank you and keep the good work coming top repack
@ aussie:
in the update folder there is an sql called mangos 0000-0074 sql, characters all sql and script dev 2 all sql these are the ones you use for a fresh install of the repack
Can anyone confirm if the AHbot is compiled into this release?
FYI
No fault to Cthulhu Ftagn at all on his great work with this repack but on a side note...
Due to the change to the Mangos DB with the new "RequiredClasses" and "RequiredSkill" columns in the "quest_template" table, the current version of Quice DB tool is not able to properly handle quest data.
I don't see a fix for this (other than the developer of Quice updating this very useful program) but if anyone knows a workaround for this please let me know.
GrandpaJohn
ok thx for the info
i should have know that, having a noobie day lol
There is still no AHbot compiled in 74..
@ junebuggy64:
well when the ahbot gets compiled into mangos, CT will let us know so i would suggest you just be patient and wait
Something must have changed i guess, ct always compiled it.
Update Compiling:
I'm offering another freebie TeamViewer session for speeding up, virus/spyware removal, and cleanup of your computer... if you want to take part, just PM me with your TeamViewer ID and password and we'll get to work on it right away.Code:MaNGOS updated to 10637.
Better totem summon cases selection.
Re compiled AHBOT into source.
Thank You
No need to ask questions about it now. :-)
Update Available:
Filebeam Mirror:Code:MaNGOS updated to 10637.
Better totem summon cases selection.
Re compiled AHBOT into source.
CU_0075.zip (17.09 MB)
Mediafire Mirror:
CU_0075.zip (17.09 MB)
http://img183.imageshack.us/img183/7350/consolek.jpg
@ CT:
update 75 executed successfully, no errors, server up and running great and yay i noticed that the ahbot is working again great work keep up the great work bud
Update 0075 Added :D
Thanks Keep Up The Great Work