This program will connect to http://www.ffxiah.com and return active prices from the Bahamut Server.
It stores the information in PriceList.xml
It Requires HTMLAgilityPack.DLL to run (from Codeplex)
Settings (in FFXI.AH.PriceGrabber.exe.config)
- Web_Links - List of the diffrent item types.
Web_FFXIAHURL - URL to connect to.
ErrorMode - set to 0, if there is a problem, exit out. 1 will cancel that item type but continue.
OutputFileName - the File to save that fun stuff to. (Default: PriceList.xml)
This Program serves two jobs. First it will add items from the PriceList to the auction house. Secondly it will buy items that are cheaper than the price history and put the money in your delivery box.
It Requires MySql.Data.dll
Settings (in FFXI.AH.Broker.exe.Config)
- PriceList - The List of Items (and Buy/Sell Prices) to sell in the auction House. Created with PriceGrabber.
PriceListOptional - Some items have a value of 0 for the price. the system will ignore this items. Add them here with a good price to sell those items.
PriceCutoff - Min Gil to sell the item. Meaning if the Price is less than PriceCutoff, do not try to put it in the Auction House.
MySQL_ConnectionString - This is where you put your relevant MySql info. port 3306 is assumed. If you need it changed, let me know.
MySQL_AuctionTable - the Auction House table in SQL.
MaxItemCount - I should have named this different but oh well. This is the number of Items that the AuctionMoogle [:)] will keep in the auction house at any given time. So if somebody buys something, the program will add it back in up to the max number.
SellerName - the name of the Seller.
- once - Will only run once and then exit.
dump - will delete everything in the auction_house table and start from fresh. this is good to do if its your first run.
Note: if you ran the other auction program, use the dump command or else the delivery box for that auction sender will get full and I don't know if it will cause an error.
Thanks! Updated the app. Funny thing is there is a setting for the connection string, but dumb me forgot to remove the dspdb in the code on a few tables.whasf wrote:Great thanks! It looks like you hardcoded "dspdb" as the database name though, that could cause problems. May want to move that out into the config file for people that have their db named differently.