houston we got a problem

[Djez-Himself]

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]

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]

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