Python AH Buyer / Seller / ffxiah.com scrubber

[Lucious_Llama]

Here is an items.csv created today.

I also changed added this to the repository, as well as changed the code to try 10 times before letting a url request crash the scrubber.

[tabitaru]

!

[tabitaru]

!

[Lucious_Llama]

Updated this for python 3.

[Airking]

I need some help with this. I am trying to run the clear.bat to clear the AH before I start up the broker. I tried following the guide on the website but I can't seem to get this to work correctly. I am not familiar with python at all so I am probably doing stuff wrong. I have Anaconda installed and ran the updates\installs that I was told to. I edited the config so that it connects with mysql.

When I try to run clear.bat I get the following error:

C:\Anaconda3\python.exe: Error while finding spec for 'pydarkstar.apps.clear.run' (<class 'ImportError'>: No module named 'pydarkstar')

Any help would be appreciated.

[Lucious_Llama]

Can you post the contents of clear.bat? Open it up in a text editor.

[Airking]

After some messing around I think I got it working.

Code: Select all

@ECHO OFF
set PYTHONPATH="%PYTHONPATH%;F:\pydarkstar"
python -m pydarkstar.apps.clear.run %*

I ended up having to copy the pydarkstar directory into my Anaconda directory. After that I was was able to run clear.bat and it did actually clear the auction house. I am currently restocking and attempting to use the broker to see if I actually set it up right.

I did notice that I had to change the None to python in each .bat in order for them to work. That was confusing and took some time to figure out.

[Lucious_Llama]

Odd that it said "None", I will fix that. You are right it should of said "python".

The line containing F:\pydarkstar is telling python where to look for pydarkstar. Fix that path and the bat script will work anywhere you put it.

[Airking]

I see. Thanks for the help! I got it all working now.

[B_Type13X2]

If my goal is to set up this ah tool and have it only populate items up to lvl 75 I need to use Navicat or someother tool to set up a database for pydarkstar the sameway I did for the server set up and then do a mysql query to delete those items I don't want from the ah via quoting nesstea " delete from auction_house where itemid in (select itemid from item_armor where level >75) " correct?