search

Czupak / LostArkMarketScan

Experimental tool, capturing screenshots of Market window in Lost Ark and saving results to different outputs.
8 stars 0 forks source link

houston we got a problem #1

Open Djez-Himself opened 2 years ago

Djez-Himself commented 2 years ago

Hello i do know i you are still working on the project, anyway here i am with a noob prob i think. Maybe you can help me to improve ;)

i'll love your project, it's a big inspiration for mine.

error

$ py snap.py [OutSQLite] Creating items [OutSQLite] Creating prices [OutSQLite] Creating crafts [OutSQLite] Creating mats [OutSQLite] Creating prices_history_v Traceback (most recent call last): File "C:\Users\Benoit\Desktop\LostArkScan\LostArkMarketScan-main\snap.py", line 7, in OutSQLite(db_name='snap.db') File "C:\Users\Benoit\Desktop\LostArkScan\LostArkMarketScan-main\snap__init.py", line 17, in init self.setup() File "C:\Users\Benoit\Desktop\LostArkScan\LostArkMarketScan-main\snap\init__.py", line 61, in setup self._db.execute(tables[table]) sqlite3.OperationalError: near "OR": syntax error

Czupak commented 2 years ago

Hey Djez, I've just pushed a commit that should fix this issue. Please pull the changes and let me know if it works. Also, the tables structure has changed a bit, so please remove 'snap.db' before running.

FYI: I stopped playing LA, but I'm still tinkering in this project from time to time. There are several features/components (like UI, snap.py self-calibration for different resolutions) I haven't released, because the code is terrible ;) But, seeing someone's interested in this app, I'll try to clean it up and release it.

Djez-Himself commented 2 years ago

Thx for the answer ! i'll have a look. it's sad you already stop the farming simulator no life game xD.

i'm noob dev so don't worry, if you code is not sexy ;), i just need a bot that scan et export in csv or excel and i'll do math after ;)

See ya