Tool to populate AH with items

[Desufire]

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?

If you're asking if there's a way to prevent anything 76+ to show on the AH, you'd have to adjust that in the sql I believe. Don't ask me which one, how, or even if it would work.

If you're asking for the AH to just not stock anything 76+, then I suggest using the python AH tool and editing the items.csv to remove all 76+ items from stocking.

[Viper20184]

Yeah I dont want the lvl 76+ stuff showing up at all. I guess I can back it up and try removing stuff and see if it works

[stamcof]

I'm wondering if this tool doesn't work anymore? Keeps hanging at "not responding until it just freezes. I'm pretty sure it worked a few months ago last time i used it. Or i could just be doing something wrong. This tool was great for my personal server and never ran into any issue till yesterday after months of not playing. Any help would be appreciated. Thanks.

[wadski]

i had a problem with it too, same actually on my live server and my personal server it worked fine. ended up using the pystar tool recommend that one highly!

[stamcof]

Ya i have attempted the pystar tool, just don't have the patience to figure it out. One click was so much easier lol.

[CharlieFrost]

Hello all!! I'm back from my absence due to RL issues......................

Comming back I have noticed that AHTool is no longer working it keeps failing to connect to SQL. I have been using this tool for about a year now and know that it did work just a couple of months ago. Upon having my equipment set up again I decided to restart from scratch as I and only solo/ duo this game with my fiancee until I get this configured an public facing. Was looking into the Pystar solution for this and it does not seem to be working. I feel as if the guide is lacking a few steps or is not updated. if anyone has a soultion to populating AH that would be great. As I am only currently running a small server I would like to find a solution. Does anyone have a script, updated version of AHTool, other program that works or to help me with Pystar

[whasf]

Hello all!! I'm back from my absence due to RL issues......................

Comming back I have noticed that AHTool is no longer working it keeps failing to connect to SQL. I have been using this tool for about a year now and know that it did work just a couple of months ago. Upon having my equipment set up again I decided to restart from scratch as I and only solo/ duo this game with my fiancee until I get this configured an public facing. Was looking into the Pystar solution for this and it does not seem to be working. I feel as if the guide is lacking a few steps or is not updated. if anyone has a soultion to populating AH that would be great. As I am only currently running a small server I would like to find a solution. Does anyone have a script, updated version of AHTool, other program that works or to help me with Pystar

Did you make sure you put in your database username & password into the tool?

Server IP: the IP of your MySQL server

[x8jason8x]

Getting an error trying to load the AH:

[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: config = config.yaml
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: verbose = True
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: silent = False
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: hostname = 127.0.0.1
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: database = dspdb
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: username = root
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: password = ????
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: fail = True
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: data = ['items.csv']
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: name = Gryphon
[2018-01-31 16:42:51,503][ 1400][INFO ]: (0x29cb240) Options: force = False
[2018-01-31 16:42:51,503][ 1400][DEBUG]: (0x4924b38) Database: init
[2018-01-31 16:42:51,518][ 1400][DEBUG]: (0x4924208) Manager: init
[2018-01-31 16:42:51,518][ 1400][DEBUG]: (0x4924710) Browser: init
[2018-01-31 16:42:51,518][ 1400][DEBUG]: (0x4924748) Cleaner: init
[2018-01-31 16:42:51,518][ 1400][DEBUG]: (0x4924668) Seller: init
[2018-01-31 16:42:51,518][ 1400][DEBUG]: (0x4924860) Buyer: init
[2018-01-31 16:42:51,518][ 1400][DEBUG]: (0x49246d8) ItemList: init
[2018-01-31 16:42:51,518][ 1400][INFO ]: (0x49246d8) ItemList: loading item data...
[2018-01-31 16:42:51,518][ 1400][INFO ]: (0x49246d8) ItemList: load items.csv
[2018-01-31 16:42:51,518][ 1400][ERROR]: caught unhandled excetion
Traceback (most recent call last):
File "C:\pydarkstar\pydarkstar\logutils.py", line 45, in capture
yield
File "C:\pydarkstar\bin\refill.py", line 21, in <module>
pydarkstar.apps.refill.run.main()
File "C:\pydarkstar\pydarkstar\apps\refill\run.py", line 32, in main
idata = ItemList.from_csv(*opts.data)
File "C:\pydarkstar\pydarkstar\itemlist.py", line 30, in from_csv
obj.loadcsv(f)
File "C:\pydarkstar\pydarkstar\itemlist.py", line 161, in loadcsv
self.add(**kwargs)
File "C:\pydarkstar\pydarkstar\itemlist.py", line 40, in add
i = item.Item(itemid, *args, **kwargs)
File "C:\pydarkstar\pydarkstar\item.py", line 116, in __init__
self.price12 = price12
File "C:\pydarkstar\pydarkstar\item.py", line 229, in price12
raise ValueError('price12 must be positive definite: %d' % self._price12)
ValueError: price12 must be positive definite: 0
[2018-01-31 16:42:51,518][ 1400][INFO ]: exit

[whasf]

raise ValueError('price12 must be positive definite: %d' % self._price12)
ValueError: price12 must be positive definite: 0

do you have something with a negative price?

[x8jason8x]

No, but I just realized that this isn't the tool I used, my mistake.