Stars Buddy List AHK Script

[_dave_]

[ QUOTE ]
[ QUOTE ]
someone make a DB with tables matching limits!!

[/ QUOTE ]

Well - I thought about it a bit. I could just write a quick parser that goes through the processed hhs from PT or whatever hhs you have and matches limits to table names. Then we could even combine everbodies data I guess. Shouldn't be too hard.
I'll take a stab at the gui.

[/ QUOTE ]

We can use postgres to get the table names (EDIT: and of course their associated limits) in to an easy to parse AHK variable:

<font class="small">Code:</font><hr /><pre>
#NoEnv
#include postgres.ahk

sql := "SELECT DISTINCT table_name, game_level_desc FROM game g, game_level gl"
sql .= " WHERE g.game_level_id = gl.game_level_id AND g.site_id = 2"
sql .= " ORDER BY table_name ASC"
sql .= ";"
result := psql(sql)


Msgbox, %result%

</pre><hr />

A different method needed for Access DBs tho...

dave.

[tcorbin16]

oooooo you guys are my heros.

[Roland]

Here.

Works pretty well I think. I have a few more ideas, but too tired now.
Oh yeah, stakes don't work yet of course.

[Roland]

[ QUOTE ]
We can use postgres to get the table names

[/ QUOTE ]

Cool.
All we need is an .ini file tableX=$2/$4 etc...

[_dave_]

[ QUOTE ]
[ QUOTE ]
We can use postgres to get the table names

[/ QUOTE ]

Cool.
All we need is an .ini file tableX=$2/$4 etc...

[/ QUOTE ]

I was thinking the script could just look up the stakes via postgres query when it finds a buddy online...

I figure anyone playing for long enough to have a collection of "buddies" will have decent coverage of the table names in the stakes they play at, and a single file will all tablenames/stakes will be large... and can you have spaces in an ini key? I never tried that, I always assumed not (although I see nothing about this on the AHK pages at first glance)

I was wondering about Access - but now I see on the PT forums all three variants can use Postgres [img]/images/graemlins/smile.gif[/img] Anyone using the omaha / stud version attest to stability (or lack thereof)?

dave.

[tcorbin16]

forget access just focus on the postgres lol. anyone who uses acess is oldschool. im going to test this out right now thoguh. thanks guys so far!!

[tcorbin16]

blah... error



thoughts? i am pretty sure i copied and pasted everything correctly.

edit: if you were to delete the junk that comes at the top/beginning of the AHK scripts when you create a new file the error would be located at line 799.

[_dave_]

Tcorbin16,

I have nothing looking like that code section anywhere near lines 813 or 799 in roland's functions.ahk...

Did you update to the latest version?

Maybe try downloading it from the "attachments" page rather than copy/paste (did you try this already)?

dave.

[tcorbin16]

ok dave i fixed the problem. i downloaded the most recent version of AHK. I think mine was outdated which was causing the problem. :-D

[wildzer0]

Holy crap, I had no idea this thread was still around - Roland great job, and thanks for the tip about reading that find player message box, I didn't think it was possible.