Custom App to Buy and Sell on the Auction House

[t123456]

FFXI.AH.PriceGrabber:
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)

Usage: If you want updated Price Info, Run once a day / Week.

FFXI.AH.Broker:
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.

Command Line:

• 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.

The program is meant to run all the time, and executes every minute (buying and selling). if you update the Pricelist, then restart Broker to use the new values.


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.

EDIT:

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.

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]

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.

[sanon]

Any chance of taking a look at the source for this project? I'd be interested in running this inclusive of my linux server.

Great prog, BTW!

[rezza]

Do we need to do anything special, or set any flags or anything, to have this put stacks of items in the AH? I've noticed after running I have individual items for things, but no stacks (and it appears that the individual items are set at the stack item prices). Do I need to just dump the table and re-run?

[sanon]

Do we need to do anything special, or set any flags or anything, to have this put stacks of items in the AH? I've noticed after running I have individual items for things, but no stacks (and it appears that the individual items are set at the stack item prices). Do I need to just dump the table and re-run?

I experienced the same. I believe what it would need to do is search the item table for the "stack" flag and then add additional auction lines with the flag set. Does everything that I desire, but this.

[altalus]

Yes, and how about adding the new categories also ?

[doghusky1990]

I just encountered a bug... after you sell the item to the ah and after the broker has bought the item, you receive no money in the delievery box... I checked to make sure that it created an entry in the delivery_box table, and it did...
I then restarted the server and check the box and still nothing...
I then send gil from one of my other characters, and my character did receive it...

the only way I found to fix it is to manually change, using a query, the box value in the delivery_box table from 0 to 1...

temp fix... I setup a event schedule through navicats to, every 5mins, change all the box values in delivery_box table from 0 to 1.

[altalus]

Is it me or the app doesn't care about the difference between stacks and individual items ? Silk thread are sold, and bought by the app, at 10k apiece !

[GraveNET]

Is it me or the app doesn't care about the difference between stacks and individual items ? Silk thread are sold, and bought by the app, at 10k apiece !

yes I havent been able to get it to put up stacks either, however you can alter the price via the settings files. I tend to control the items there.

[ca3d00]

Just put this on my server but there seems to be an issue, it's buying the items ok but doesn't seem to be passing the Gil to the selling player.
Is this just a transaction delay thing or has something gone wrong. I'm using the latest build of Darkstar as of the 20th.