Tool to populate AH with items

[bluekirby0]

Moved from the old forums (tool made by CipherX)

This tools will populate the AH with all items including stacks of 12 and 99, please report any issues here.
Enjoy!

Please Make sure you have .Net Framework installed version 4

Microsoft .NET Framework 4
http://www.microsoft.com/download/en/de ... x?id=17718

Official v1.0 released
- no longer adds items that have AH group 0
- runs much faster as to the v1.0 Beta version
- separate counters for single items, stacks of 12 and stacks of 99 implemented
- add's item price according to the base sell price in db
- price of 12 and 99 stacks are single base price * 10

v1.1 - updates
- price of 12 stacks is single base price * 10, you save 17% as to buying single items
- price of 99 stacks is single base price * 80, your save 20% as to buying single items
- master price override implemented
- if Single items is checked only single items will override, stack items still be calculated as normal
- if Stack items is checked, all stacks 12 and 99 will also override

v1.2 - updates
- Item Price History will now be added to the AH with every item

v1.2updated - updates
- fixed issue with delivery_box overflow pass 254 items, all items added with tool will now delete from the delivery box, you need r536 or newer rev

v1.3
- mysql port number added so it can be custom and not only 3306 by default

v1.4
- Crafting items will be repopulated now every hour if you leave AHTool running to minimum of 40 items, price works same way as it did before it can be
set to price from DB or you still can use price override. AH Categories that will be restocked are ( Crystals, All Crafting, Other and Beast-made )

v1.5
- added two more AH categories to be repopulated ( Ingredients and Fish )

[msulli1355]

I think I can use this from my laptop that I use my FFXI client on. I don't generally like messing around with Windows. Could someone provide us with a straight .sql file that can be imported directly into the database on the server?

[cipherx]

I think I can use this from my laptop that I use my FFXI client on. I don't generally like messing around with Windows. Could someone provide us with a straight .sql file that can be imported directly into the database on the server?

there is no .sql file with this app it builds the AH dynamically from the DSPDB tables depending what items are allowed to be on AH in first place according to the DSPDB, but you can run this from any PC with .net 4 so your client PC will do fine as long you can access the DSPDB from it. this was done this way as the AH table can grow quick depending how many items of each item you like and also pricing can be dynamic from DSPDB pricing or static.

[PrBlahBlahtson]

Except as msulli1355 mentioned, he'd like to avoid Windows.

I can vaguely think of a way to do this in PHP. Something to the effect of

Code: Select all

$itemid = select itemid from item_basic;
foreach ($itemid) {
    $z = 0;
    do {
        insert into ahtable values;
        $z = $z + 1;
    } while ($z < 7);
}

A lot of pseudo code, but you get the picture.

Not sure how to roll it in purely SQL though.

[msulli1355]

That would be good because if I could write the script for it I could stick it in a cron job that runs every hour. Set it and forget it, like most of the other automated stuff I've got running...

[mvd1987]

i use this tool also and when i check the ah with ah editor it also shows weapons from above 75, they are in the ah on the editor but players cant see it in the ah in the game.


why not??

and how do i fix that??

when i load items in there via ah editor it doesnt show them also.

i use the v 1.5 ah tool and it fills the ah but players can see it.

hope somebody can tell me how to let them show for the players also.

greetings michael

[anglos]

If somebody were to run this, they could turn around and do a SQL dump of the auction house table and provide it if they wish. No script writing necessary, just an export/import.

[samlafeyette]

Works amazingly thank you very much for this tool. I was trying to manually add every item to the auction house using navicat lol. Thank you very much again

[thyris]

Works perfectly, thanks!

[Viper20184]

I guess this is the best place to ask. I want my server to be up to 75. No post 75 stuff on. My AH currently has every item.. but I want to remove the 76+ stuff... do I have to remove it from the SQL database or is there an easy way to do this?