STOP LOSS AHK REQUEST (Reward)
have you got aliases set up? try using the primary screenname.
i have aliases set up but I also tried it with the primary screen name but it didnt work out.
any other ideas?
any other ideas?
Hello,
i have managed to get the script running as far as to show me the window. but it is not corresponding with the database.
the error logs are as follows:
20080626233048 - An Error Occured:
Input:
\f '\t'
SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = 8
39001 AND g.game_id > 717999;
\q
Output:
psql:20080626233048_stop_loss-v0.2.ahk_4094_in.txt:3: ERROR: syntax error at or near "39001"
LINE 2: 39001 AND g.game_id > 717999;
^
20080626233049 - An Error Occured:
Input:
\f '\t'
SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = 8
39001 AND g.game_id > 717999;
\q
Output:
psql:20080626233048_stop_loss-v0.2.ahk_8526_in.txt:3: ERROR: syntax error at or near "39001"
LINE 2: 39001 AND g.game_id > 717999;
^
do you have any idea what i can do to set it up properly?
I run on Vista.
Regards
Andreas
i have managed to get the script running as far as to show me the window. but it is not corresponding with the database.
the error logs are as follows:
20080626233048 - An Error Occured:
Input:
\f '\t'
SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = 8
39001 AND g.game_id > 717999;
\q
Output:
psql:20080626233048_stop_loss-v0.2.ahk_4094_in.txt:3: ERROR: syntax error at or near "39001"
LINE 2: 39001 AND g.game_id > 717999;
^
20080626233049 - An Error Occured:
Input:
\f '\t'
SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = 8
39001 AND g.game_id > 717999;
\q
Output:
psql:20080626233048_stop_loss-v0.2.ahk_8526_in.txt:3: ERROR: syntax error at or near "39001"
LINE 2: 39001 AND g.game_id > 717999;
^
do you have any idea what i can do to set it up properly?
I run on Vista.
Regards
Andreas
anyone ?
Code:
20080707151738 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'lirarmange'; \q Output: psql:20080707151738_stop_loss-v0.2.ahk_4639_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'lirarmange';
Im using a HEM database, looks like the column name "screen_name" have been changed, but to what?
http://overcards.com/wiki/moin.cgi/S...p_loss_HEM.zip
dave - will this work with pto?
Probably - I can't imagine there is any difference in the name / hand id / money won-lost columns in any PT2 version. I don't have a PTO or PTS so I can't be sure... try it and let us know
aaahh, thanks _dave_
Can you (or someone else) help me write a query to get the total rake for all hands played for "today" or "the last session" in HEM?
This number should be the same number as FT points. And Im tired of refreshing the ironman page to see my points for the day all the time... =)
Can you (or someone else) help me write a query to get the total rake for all hands played for "today" or "the last session" in HEM?
This number should be the same number as FT points. And Im tired of refreshing the ironman page to see my points for the day all the time... =)
He did, so here we are
Download this, extract to a folder.
http://www.overcards.com/wiki/moin.c...s-HEM_TEST.zip
You will need to copy/paste psql.exe (and maybe supportting DLL files) from C:\Program Files\PostgreSQL\8.2\bin - to the script's folder, so it can access databases.
You will need to edit the script with your screenname (sn) instead of mine (case sensitive I think). You may need to change your database name / host, if they are not default.
You may well want to adjust the loss / win / hand numbers also.
*Also - Am I sposed to change both of these???
And you may need / want to set alternative sound effects.
Once you verify it is working properly, it is wise to turn off "show_money" - otherwise this can easy become a tilt magnifier!
All these settings are at the start of the script.
Please report success / failure, and I'll get to adding some more features
Download this, extract to a folder.
http://www.overcards.com/wiki/moin.c...s-HEM_TEST.zip
You will need to copy/paste psql.exe (and maybe supportting DLL files) from C:\Program Files\PostgreSQL\8.2\bin - to the script's folder, so it can access databases.
You will need to edit the script with your screenname (sn) instead of mine (case sensitive I think). You may need to change your database name / host, if they are not default.
You may well want to adjust the loss / win / hand numbers also.
*Also - Am I sposed to change both of these???
And you may need / want to set alternative sound effects.
Once you verify it is working properly, it is wise to turn off "show_money" - otherwise this can easy become a tilt magnifier!
All these settings are at the start of the script.
Please report success / failure, and I'll get to adding some more features
Trying to figure this out:
I have SQL 8.3 for HM and 8.2 for PTO.....
Can this be done? Or is HM gonna have to be a 8.2 DB also?
doesn't matter, any psql.exe will do. If you have more than one version of postgres on your system, this is the time you May need to copy the DLL files also (if the psql.exe gives errors when it tries to load the mismatched DLL versions)
Which DLL files will I want to copy?? 8.2 or 8.3? And I copy ALL of them??
Do I need to change both of these?
Do I need to change both of these?
Code:
# IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: #host all all ::1/128 md5
the ones matching whichever version of psql.exe you copy.
I don't think you need to copy them all, maybe you do. You may not need to copy any!. If you try and run the script, and it gives an error dialog "psql.exe unable to find function XXX in pg_xxx.DLL" or some such, you need that DLL.
If you only have two postgres versions - and the first time you try just with psql copied, and it gives an error - just copy the other one imo.
I don't think you need to copy them all, maybe you do. You may not need to copy any!. If you try and run the script, and it gives an error dialog "psql.exe unable to find function XXX in pg_xxx.DLL" or some such, you need that DLL.
If you only have two postgres versions - and the first time you try just with psql copied, and it gives an error - just copy the other one imo.
I edited the post above.
Change both 'md5' to 'trust'?
Change both 'md5' to 'trust'?
As above is fine - I doubt you are running IPv6 networking yet, so it's setting shouldn't matter.
Are the Win/Loss/Goal all in whole dollar values?
I got rid of all the errors, but this doesn't seem to be working. I assume it should be keeping a count on the GUI?
The only thing that matters is psql.exe is in the same folder as the script. You can have one folder with many scripts in it, and one psql.exe - or separate folders for each script, each with a psql.exe in them. however you like to keep organized.
Are the Win/Loss/Goal all in whole dollar values?
LOL
The text that you have entered is too long (135075 characters). Please shorten it to 100000 characters long.
Code:
20080708184055 - An Error Occured: Input: \f '\t' SELECT game_id FROM game ORDER BY game_id DESC LIMIT 1; \q Output: psql:20080708184054_stop_loss-v0.2.ahk_4782_in.txt:2: ERROR: relation "game" does not exist 20080708184126 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184125_stop_loss-v0.2.ahk_6749_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184126 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184126_stop_loss-v0.2.ahk_7051_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184126 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184126_stop_loss-v0.2.ahk_2714_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184127 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184126_stop_loss-v0.2.ahk_6926_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184127 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184127_stop_loss-v0.2.ahk_6546_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184128 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184127_stop_loss-v0.2.ahk_1329_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184155 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184155_stop_loss-v0.2.ahk_8857_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184156 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184155_stop_loss-v0.2.ahk_5784_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184156 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184156_stop_loss-v0.2.ahk_2750_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184156 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184156_stop_loss-v0.2.ahk_4840_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184157 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184156_stop_loss-v0.2.ahk_2215_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184157 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184157_stop_loss-v0.2.ahk_9901_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184225 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184225_stop_loss-v0.2.ahk_4173_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184226 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184225_stop_loss-v0.2.ahk_3545_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184226 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184226_stop_loss-v0.2.ahk_6994_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184227 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184226_stop_loss-v0.2.ahk_3705_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184227 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184227_stop_loss-v0.2.ahk_6485_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184227 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184227_stop_loss-v0.2.ahk_1843_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184255 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184255_stop_loss-v0.2.ahk_3664_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184256 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184255_stop_loss-v0.2.ahk_5451_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184256 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184256_stop_loss-v0.2.ahk_2360_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184256 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184256_stop_loss-v0.2.ahk_2003_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184257 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184256_stop_loss-v0.2.ahk_1184_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184257 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184257_stop_loss-v0.2.ahk_7697_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184325 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184325_stop_loss-v0.2.ahk_9452_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184326 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184325_stop_loss-v0.2.ahk_1701_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184326 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184326_stop_loss-v0.2.ahk_9308_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184326 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184326_stop_loss-v0.2.ahk_8865_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184327 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184326_stop_loss-v0.2.ahk_9607_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184327 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184327_stop_loss-v0.2.ahk_8334_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184355 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184355_stop_loss-v0.2.ahk_6614_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184356 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184355_stop_loss-v0.2.ahk_5799_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184356 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184356_stop_loss-v0.2.ahk_6885_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184356 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184356_stop_loss-v0.2.ahk_6899_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184357 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184356_stop_loss-v0.2.ahk_2492_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184357 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184357_stop_loss-v0.2.ahk_6122_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184425 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184425_stop_loss-v0.2.ahk_4250_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184426 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184425_stop_loss-v0.2.ahk_2454_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184426 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184426_stop_loss-v0.2.ahk_2807_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184426 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184426_stop_loss-v0.2.ahk_6820_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184427 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184426_stop_loss-v0.2.ahk_2650_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184427 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184427_stop_loss-v0.2.ahk_6844_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184455 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184455_stop_loss-v0.2.ahk_1104_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184456 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184455_stop_loss-v0.2.ahk_5759_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184456 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184456_stop_loss-v0.2.ahk_4864_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184456 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184456_stop_loss-v0.2.ahk_8718_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184457 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184456_stop_loss-v0.2.ahk_8847_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184457 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184457_stop_loss-v0.2.ahk_8193_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184525 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184525_stop_loss-v0.2.ahk_9375_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184526 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184525_stop_loss-v0.2.ahk_1800_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184526 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184526_stop_loss-v0.2.ahk_1323_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184526 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184526_stop_loss-v0.2.ahk_8865_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184527 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184526_stop_loss-v0.2.ahk_6516_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184527 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184527_stop_loss-v0.2.ahk_6260_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184555 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184555_stop_loss-v0.2.ahk_3620_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184556 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184555_stop_loss-v0.2.ahk_4337_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184556 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184556_stop_loss-v0.2.ahk_3690_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184556 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184556_stop_loss-v0.2.ahk_3829_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184557 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184556_stop_loss-v0.2.ahk_6571_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184557 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184557_stop_loss-v0.2.ahk_8248_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184625 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184625_stop_loss-v0.2.ahk_3842_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184626 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184625_stop_loss-v0.2.ahk_7251_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184626 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184626_stop_loss-v0.2.ahk_9778_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184626 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184626_stop_loss-v0.2.ahk_4619_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184627 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184626_stop_loss-v0.2.ahk_3658_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184627 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184627_stop_loss-v0.2.ahk_8880_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184655 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184655_stop_loss-v0.2.ahk_7422_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184656 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184655_stop_loss-v0.2.ahk_4850_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184656 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184656_stop_loss-v0.2.ahk_7183_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184656 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184656_stop_loss-v0.2.ahk_5719_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184657 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184656_stop_loss-v0.2.ahk_2559_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184657 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184657_stop_loss-v0.2.ahk_6690_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184726 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184725_stop_loss-v0.2.ahk_5319_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184726 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184726_stop_loss-v0.2.ahk_1628_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184726 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184726_stop_loss-v0.2.ahk_9777_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184726 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184726_stop_loss-v0.2.ahk_9897_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184727 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184726_stop_loss-v0.2.ahk_6913_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184727 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184727_stop_loss-v0.2.ahk_9769_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184755 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184755_stop_loss-v0.2.ahk_3728_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184756 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184755_stop_loss-v0.2.ahk_6900_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184756 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184756_stop_loss-v0.2.ahk_5210_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184756 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184756_stop_loss-v0.2.ahk_9456_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184757 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184756_stop_loss-v0.2.ahk_7136_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184757 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184757_stop_loss-v0.2.ahk_6593_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184856 - An Error Occured: Input: \f '\t' SELECT game_id FROM game ORDER BY game_id DESC LIMIT 1; \q Output: psql:20080708184855_stop_loss-v0.2.ahk_2296_in.txt:2: ERROR: relation "game" does not exist 20080708184926 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184926_stop_loss-v0.2.ahk_1196_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184926 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184926_stop_loss-v0.2.ahk_2328_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184926 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184926_stop_loss-v0.2.ahk_4950_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184927 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184926_stop_loss-v0.2.ahk_5225_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184927 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184927_stop_loss-v0.2.ahk_3665_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184927 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184927_stop_loss-v0.2.ahk_3447_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184956 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708184956_stop_loss-v0.2.ahk_3481_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708184956 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184956_stop_loss-v0.2.ahk_3709_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184957 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184956_stop_loss-v0.2.ahk_5842_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184957 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184957_stop_loss-v0.2.ahk_3870_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184957 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184957_stop_loss-v0.2.ahk_2343_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708184957 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708184957_stop_loss-v0.2.ahk_8837_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185026 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185026_stop_loss-v0.2.ahk_5336_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185026 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185026_stop_loss-v0.2.ahk_5735_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185026 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185026_stop_loss-v0.2.ahk_5401_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185027 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185026_stop_loss-v0.2.ahk_3765_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185027 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185027_stop_loss-v0.2.ahk_8066_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185027 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185027_stop_loss-v0.2.ahk_2731_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185056 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185056_stop_loss-v0.2.ahk_9651_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185056 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185056_stop_loss-v0.2.ahk_6618_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185057 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185056_stop_loss-v0.2.ahk_1232_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185057 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185057_stop_loss-v0.2.ahk_1265_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185057 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185057_stop_loss-v0.2.ahk_9052_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185057 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185057_stop_loss-v0.2.ahk_3895_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185126 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185126_stop_loss-v0.2.ahk_8157_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185126 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185126_stop_loss-v0.2.ahk_7904_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185126 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185126_stop_loss-v0.2.ahk_6083_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185127 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185126_stop_loss-v0.2.ahk_5905_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185127 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185127_stop_loss-v0.2.ahk_7792_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185127 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185127_stop_loss-v0.2.ahk_7588_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185156 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185156_stop_loss-v0.2.ahk_4361_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185156 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185156_stop_loss-v0.2.ahk_4137_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185157 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185156_stop_loss-v0.2.ahk_2951_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185157 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185157_stop_loss-v0.2.ahk_6545_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185157 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185157_stop_loss-v0.2.ahk_4377_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185157 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185157_stop_loss-v0.2.ahk_5681_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185226 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185226_stop_loss-v0.2.ahk_2345_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185226 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185226_stop_loss-v0.2.ahk_8936_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185226 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185226_stop_loss-v0.2.ahk_5928_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185227 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185226_stop_loss-v0.2.ahk_8541_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185227 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185227_stop_loss-v0.2.ahk_2181_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185227 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185227_stop_loss-v0.2.ahk_7342_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185256 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185256_stop_loss-v0.2.ahk_2338_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185256 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185256_stop_loss-v0.2.ahk_1955_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185257 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185256_stop_loss-v0.2.ahk_4687_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185257 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185257_stop_loss-v0.2.ahk_6870_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185257 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185257_stop_loss-v0.2.ahk_9622_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185257 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185257_stop_loss-v0.2.ahk_8659_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185326 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185326_stop_loss-v0.2.ahk_6526_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185326 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185326_stop_loss-v0.2.ahk_1654_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185326 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185326_stop_loss-v0.2.ahk_8764_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185327 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185326_stop_loss-v0.2.ahk_2288_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185327 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185327_stop_loss-v0.2.ahk_4889_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185327 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185327_stop_loss-v0.2.ahk_2662_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185356 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185356_stop_loss-v0.2.ahk_4037_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185356 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185356_stop_loss-v0.2.ahk_6541_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185356 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185356_stop_loss-v0.2.ahk_3042_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185357 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185356_stop_loss-v0.2.ahk_8244_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185357 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185357_stop_loss-v0.2.ahk_3652_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185357 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185357_stop_loss-v0.2.ahk_7236_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185426 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185426_stop_loss-v0.2.ahk_7907_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185426 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185426_stop_loss-v0.2.ahk_2299_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185426 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185426_stop_loss-v0.2.ahk_2061_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185427 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185426_stop_loss-v0.2.ahk_7307_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185427 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185427_stop_loss-v0.2.ahk_2393_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185427 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185427_stop_loss-v0.2.ahk_9297_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185456 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185456_stop_loss-v0.2.ahk_9607_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185456 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185456_stop_loss-v0.2.ahk_7612_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185456 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185456_stop_loss-v0.2.ahk_7957_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185457 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185456_stop_loss-v0.2.ahk_8047_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185457 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185457_stop_loss-v0.2.ahk_5179_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185457 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185457_stop_loss-v0.2.ahk_8987_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185526 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185526_stop_loss-v0.2.ahk_7522_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185526 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185526_stop_loss-v0.2.ahk_5421_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185526 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185526_stop_loss-v0.2.ahk_8787_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185527 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185526_stop_loss-v0.2.ahk_5420_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185527 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185527_stop_loss-v0.2.ahk_2364_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185527 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185527_stop_loss-v0.2.ahk_1313_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185556 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185556_stop_loss-v0.2.ahk_9900_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185556 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185556_stop_loss-v0.2.ahk_3019_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185556 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185556_stop_loss-v0.2.ahk_8098_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185557 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185556_stop_loss-v0.2.ahk_5223_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185557 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185557_stop_loss-v0.2.ahk_3068_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185557 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185557_stop_loss-v0.2.ahk_6811_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185626 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185626_stop_loss-v0.2.ahk_9933_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185626 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185626_stop_loss-v0.2.ahk_6306_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185627 - An Error Occured: Input: \f '\t' SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185626_stop_loss-v0.2.ahk_2967_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185627 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 0.39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185627_stop_loss-v0.2.ahk_8055_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ...39 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185627 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake > 2 AND g.number_of_players <= 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185627_stop_loss-v0.2.ahk_6949_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 5 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185627 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.site_id = 2 AND g.rake = 3 AND g.number_of_players = 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185627_stop_loss-v0.2.ahk_4399_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... 6 AND g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185656 - An Error Occured: Input: \f '\t' SELECT player_id from players WHERE screen_name = 'ventrasp'; \q Output: psql:20080708185656_stop_loss-v0.2.ahk_4537_in.txt:2: ERROR: column "screen_name" does not exist LINE 1: SELECT player_id from players WHERE screen_name = 'ventrasp'... ^ 20080708185656 - An Error Occured: Input: \f '\t' SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game_id > ; \q Output: psql:20080708185656_stop_loss-v0.2.ahk_5286_in.txt:2: ERROR: syntax error at or near "AND" LINE 1: ... WHERE g.game_id = gp.game_id AND gp.player_id = AND g.game... ^ 20080708185656 - An Error Occured: Inp................
Looks like you are trying to use the PT version on a HM database there.
Edit: You can be sure all the psql.exe stuff is good if you are getting the error logs, at least
Edit: You can be sure all the psql.exe stuff is good if you are getting the error logs, at least
I forgot to go to the attachments page.
For the HEM version, does there need to be a postgres.ahk file, with the DB name, etc?
I just looked at each briefly, and I assume not.
For the HEM version, does there need to be a postgres.ahk file, with the DB name, etc?
I just looked at each briefly, and I assume not.
My HM DB Name is 'HM-May2k8'
post a snippet of the code where you've edited that in - it should be a variable's contents, not a variable's name... I guess you've accidentally deleted something somewhere - and the dialog bove shows two doublequotes at the end... I assume you used the same DB name in the PT version above?
It was a typo, got it now.
Cant get it to work with PTO, and actually, not sure why it works with HM, considering the location of my SQL directory, and the fact that I didn't edit the script accordingly.
D:\PostgreSQL\8.2
What do I need to edit, for PTO???
And why did my HEM version work, w/o me editing the SQL path?
D:\PostgreSQL\8.2
What do I need to edit, for PTO???
And why did my HEM version work, w/o me editing the SQL path?
postgres databases it does not matter where it is on your hard disk - it is all done over IP (127.0.0.1:5432). If there is a postgres path variable in there it probably doesn't do anything if you've copied psql.exe to the script folder.
For PTO, you'll have to enter your database name (likely PTOPGSQL1 or similar) - and if you are not running postgres 8.2 on port 5432, edit that in the script text (search for port and/or 5432).
For PTO, you'll have to enter your database name (likely PTOPGSQL1 or similar) - and if you are not running postgres 8.2 on port 5432, edit that in the script text (search for port and/or 5432).
Feedback is used for internal purposes. LEARN MORE