Ahbot v12

[Blackvision]

Where is AHBOT items stored ?
I see some insane items with 10000 agility etc.

 

[Jenniy]

The items generated by the AHbot are actually stored in 2 (3) separate locations. (sort of)

The first location would be in the 'character_inventory' table of your character_db, database.
This is however not really correct as that table only actually holds the guids of all the items that any particular character has, as well as where they have it stored (Bags 0-4 (in slot 1-36), helmet, bracers, shirt, ring 1, ring 2, etc.).

There is also, of course, the 'auctionhouse' table (also in character_db) that similarly stores all the Auctions House listings with the relevant entries (item_guid, owner, price, time, etc.) that point, like the inventory database to a third table.

For the items themselves, those are stored in the 'item_instance' table (again in the character database). In here, you'll find some pretty self-explanatory columns.
Among the basics such as 'owner_guid' you'll also find the item's own unique guid that I mentioned in the previous table as well as itemEntry, which references the guids of items located in the world_db 'item_template' table.

For the AHbot specifically; assuming you are running with stock settings, both the account and character guids for the AHbot will be 1 (the first account created, and the first character created in the database). Any item that shows up on the AH is actually owned by character_guid 1 and show up as such in all tables mentioned.

This is about where my knowledge stops, and the rest is more conjecture then definitive facts.

If you want to get into the meta-details of specific numbers on specific items, there is a folder (one of the Data Files folders that you downloaded) that contains a LOT of.db files. You need a custom program to be able to read them, but if you want to look at the exact numeral values of anything/everything - that's where they are located.
I only have my limited experience in poking around these .db files as a reference, but somewhere in there should be the root of the numbers that you are seeing.
There is also the chance that I took this a step too far, and the odd numbers are showing up in the 'item_template' (world) database, and you have no need to even look into a .db file.



CAUTION: I highly recommend against modifying any values you see in the .db files as it's rather akin to modifying the registry on your computer or, put another way, like poking the engine of your car with a big metal stick.
(also, anything you do modify will need manual syncing back to your wow client, and that's an entirely different kettle of fish that is outside the scope of this question!)

 

[Blackvision]

The items generated by the AHbot are actually stored in 2 (3) separate locations. (sort of)

The first location would be in the 'character_inventory' table of your character_db, database.
This is however not really correct as that table only actually holds the guids of all the items that any particular character has, as well as where they have it stored (Bags 0-4 (in slot 1-36), helmet, bracers, shirt, ring 1, ring 2, etc.).

There is also, of course, the 'auctionhouse' table (also in character_db) that similarly stores all the Auctions House listings with the relevant entries (item_guid, owner, price, time, etc.) that point, like the inventory database to a third table.

For the items themselves, those are stored in the 'item_instance' table (again in the character database). In here, you'll find some pretty self-explanatory columns.
Among the basics such as 'owner_guid' you'll also find the item's own unique guid that I mentioned in the previous table as well as itemEntry, which references the guids of items located in the world_db 'item_template' table.

For the AHbot specifically; assuming you are running with stock settings, both the account and character guids for the AHbot will be 1 (the first account created, and the first character created in the database). Any item that shows up on the AH is actually owned by character_guid 1 and show up as such in all tables mentioned.

This is about where my knowledge stops, and the rest is more conjecture then definitive facts.

If you want to get into the meta-details of specific numbers on specific items, there is a folder (one of the Data Files folders that you downloaded) that contains a LOT of.db files. You need a custom program to be able to read them, but if you want to look at the exact numeral values of anything/everything - that's where they are located.
I only have my limited experience in poking around these .db files as a reference, but somewhere in there should be the root of the numbers that you are seeing.
There is also the chance that I took this a step too far, and the odd numbers are showing up in the 'item_template' (world) database, and you have no need to even look into a .db file.



CAUTION: I highly recommend against modifying any values you see in the .db files as it's rather akin to modifying the registry on your computer or, put another way, like poking the engine of your car with a big metal stick.
(also, anything you do modify will need manual syncing back to your wow client, and that's an entirely different kettle of fish that is outside the scope of this question!)

Looked through the db you are mentioning, and seached by name for a specific item, nothing showed up.
Tho after seeing what the ahbot puts up for sale, im hesitating using it.
And not even sure how to adjust price setting, looked for some SQL files from other people, but it doesn't look like anyone has it.

 

[Jenniy]

I mentioned several databases in my post; did you search through all of them, or only a/some particular one(s)? If you are searching by item name it will likely only show up in 'item_template' table in the world_db, not in the tables I mentioned in the char_db. If you have looked there and still can't find reference to the item by name, there are two possibilities; First, you can use the '.lookup item [item name] command in game to look for the Item ID that way (which can then be used to find the relevant entr(ies) in the various tables) or; Second, the item you are trying to find might just be lootgen (ex. Bandit boots of the Eagle, Bards trousers of Agility, etc.) which can't be found by looking up it's name because the name itself is generated to match the stats that are (semi)-randomly assigned to the gear item when it is created (usually when looting corpses or similar activities).

The Auction House Bot is fairly simple in implementation, it will just look through the 'item_template' table(s) (possibly including .db files, but I still can't confirm this) and grab any random items that fit within the defined configuration. Some of the junk that spawns from the ahBot implementation can be mitigated by adjusting values set in the worldserver.conf file, and (partially) the 'auctionhousebot' table. (Disabling any gear items at level one and any grey/white gear items, for example, would go a long way toward getting rid of unwarranted and/or broken gear in the AH. (Make sure to clean out the Auction House after changing these settings - they won't affect items already listed there!))

Adjusting prices for the ahBot, separate from the 'what spawns' in the worldserver.conf, is done via the 'auctionhousebot' table in the char_db. This table will act as the second half of the config that seems missing from the .conf file, allowing for adjustments in how many items you want listed at once, what percentage of the items listed should be at each rarity level, (make sure to keep them balanced at 100% total!) and adjusting price ranges for each of the different item rarities. (The numbers for setting price (named minprice[color] and maxprice[color]) are also percentages based on the item's base value. You can't, say, set copper ore specifically to sell for 10gp each while keeping all other prices at their default value.)

There's not really anything in the way of an .SQL file that could be of use in this regard, as all the Auction House Bot configuration is subject to tweaking by each server admin to find the proper balance for their setup. There are also only a handful of configuration options which doesn't generally warrant a .SQL script for mass edits of it.

If you are curious to what some of the tables and columns withing them do/mean, I've found this to be a very helpful guild for finding my way around the Trinity databases: TrinityCore Collaboration Platform
Unfortunately, the 'auctionhousebot' table is noticeably absent from the documentation, but it does have its own wiki somewhere (on github?) that I don't have a ready link to right now.

 

[Blackvision]

[MENTION=28161]Jenniy[/MENTION]
I tried to lookup some QA items from AH only to get No items Found!

 

[Puck - EU]

[MENTION=8085]Blackvision[/MENTION] that doesn't suprise me most are random enchants applied to 'basic items' so searching for something like 'falchion of the eagle' wouln't bring anything up. like Jenniy said above the only way to set price and numbers of blue items etc is in the database. - though regarding finding an item with +10000 agility this probably shouldn't be happening so i would assume something is wrong with the random enchants table (i do know they have had problems with this before - especially showing errors in the worldserver). My advice would be to try and familiaris yourslef with the ACbot database table etc and wait for it to be fixed in a new version.

 

[Blackvision]

[MENTION=8085]Blackvision[/MENTION] that doesn't suprise me most are random enchants applied to 'basic items' so searching for something like 'falchion of the eagle' wouln't bring anything up. like Jenniy said above the only way to set price and numbers of blue items etc is in the database. - though regarding finding an item with +10000 agility this probably shouldn't be happening so i would assume something is wrong with the random enchants table (i do know they have had problems with this before - especially showing errors in the worldserver). My advice would be to try and familiaris yourslef with the ACbot database table etc and wait for it to be fixed in a new version.

Yes, i do get a lot og errors in the worldserver. Most if them regarding enchants.
Been chatting with ExO and some major fixes are being made.