Python AH Buyer / Seller / ffxiah.com scrubber

[Lucious_Llama]

The only thing that needs to be running for the broker is the mysql database server, which starts automatically when you log into Windows.
It should be set up and populated using the darkstar server setup guide (https://wiki.dspt.info/index.php/Building_the_Server)

Also, I should mention that running the scrub script is only needed when you want to create the items.csv from the prices listed currently on ffxiah.com.
It sounded like you did that before and it finished just fine. Just make sure the items.csv it produced is in the place you have told the broker.

As to why python can not find pydarkstar correctly, I am at a loss. The purpose of the PYTHONPATH line is to let python know where to find pydarkstar.

Code: Select all

set PYTHONPATH=%PYTHONPATH%;"C:\Users\FFXI Server\Desktop\Server Tools\Auction House\pydarkstar"

I think having spaces in the directory names is throwing it off. You could try surrounding the entire expression with quotes:

Code: Select all

set PYTHONPATH="%PYTHONPATH%;C:\Users\FFXI Server\Desktop\Server Tools\Auction House\pydarkstar"

Or you could remove the spaces from your directories, but I'm guessing you have other tools that may already be setup with the current configuration. They may need updated as well.

Code: Select all

# OLD
C:\Users\FFXI Server\Desktop\Server Tools\Auction House\pydarkstar

# NEW
C:\Users\FFXIServer\Desktop\ServerTools\AuctionHouse\pydarkstar

Code: Select all

set PYTHONPATH="%PYTHONPATH%;C:\Users\FFXIServer\Desktop\ServerTools\AuctionHouse\pydarkstar"

[Crosine]

Working now fantastic! Thanks Llama this is an excellent tool to add to my server arsenal.

[Lucious_Llama]

Glad it is working.

[Desufire]

Hey Llama, got an issue on friends pc. We recently moved the server to his PC because I'll be moving soon and my PC has been acting up. I went with your on site instructions using anaconda because he runs win8 and I didn't feel like editing Path variables again. All installs went smoothly but the makebin creates the bin folder with only the alter batch. Scrub and broker are a no go.

I did try to just bypass the trouble by transferring the pydarkstar I have set up on my PC. But, that didn't work of course.

[Lucious_Llama]

Odd. You can try running it a second time, that would do no harm. If that doesn't work, just copy the alter.bat it made. Rename it to broker.bat, and then open it up in notepad. Change any occurrence of the word alter to broker. That should work.

[Desufire]

Odd. You can try running it a second time, that would do no harm. If that doesn't work, just copy the alter.bat it made. Rename it to broker.bat, and then open it up in notepad. Change any occurrence of the word alter to broker. That should work.

Yeah, I ran the makebin like 5 times out of frustration. My brain has been fried from recent personal crap and I find it hard to think of easy solutions to fix things atm.

I tthought about it and I think MySQL may have installed Python 3.4 as a requirement. I'm gonna try uninstalling conda fully and Python. Then just install conda and see how that goes. I think Python is for workbench which I don't use anyways.

[Lucious_Llama]

I've slowly been trying to make it work on Python 2 and 3; That's in the development branch. But it is probably more of headache because I've changed too many other things.

Anaconda is nice enough to let you install many versions of python at the same time, and switch between them as needed.
http://conda.pydata.org/docs/using/envs.html

Code: Select all

conda create -n py27 python=2.7
activate py27

[Desufire]

Yay! More homework! Thanks teach! /endsarcasm

[Desufire]

I uninstalled all forms of python and conda. Then I only installed Conda and made it the primary Python and had it add the Path during install. Everything worked from there so my guess is, if you install Mysql and it makes you install Python 3+ before you go through the process of using this tool, you'll run into issues.

[TeoTwawki]

Python is not at all a MySql requirement. there are optional compenents that are FOR python, and if you try to install said components the installer will tell you that the "required" python was found for them. Its their fault for wording it stupidly in their setup, but that's the truth of it: not required for MySql itself.