Roland for some reason it's not SQL'ing my db's right. Not that it really matters whether it works or not. I just double click their name and when the table opens up i look at the limit.

In poker tracker the names of my DB's under that column are....

DB File/DB Name/DSN
"2007 - ALL SITES"
"STARS - 10/20 6 MAX OBSERVED"
etc etc

I tried using PTPGSQL1 etc too and that didn't work.

Also for the hand histories thing? Do i just put the stars
"hand history" folder, or my specific folder where it show's my screen name?

Not sure about this. You want the filename - what does it say?

The last one, where it shows your screen name.

ok heres a pic of what i think you should be seeing?



also any chance of making this thing so that it doesn't steal focus??? i tried using this while playing on stars and i couldnt click on any of the buttons and was timing out everywhere.

Yeah - I would have thought that "STARS - 10/20 6 MAX OBSERVED,STARS - 3/6 NL 6-MAX OBSERVED,STARS 5-10 NL 6-MAX OBSERVED,STARS MAIN" would work. Maybe someone else knows what the problem is?

Nope, can't do it.

Btw, are you sure it's actually not working? Have a look at the file 'tables.txt' (same folder as the script). The results of the query get written there.

Really awesome script. Great job.

Can you explain how to "one click" and add buddies. I think that I am screwing it up somehow.

Hold down the Alt key, then left-click on that little box with the screen name and stack size of the player.
You have to be playing (the script reads the hhs to match a player to the coords you clicked at and Stars doesn't write hhs unless you play).

yea roland the tables.txt file is blank.

creates files with no endings such as this "20070107111033_Stars" ???

oh well this script is still sick. thanks roland.

Oh - that may be that password problem. Have a look at this
post.

hmm they are both under trust already so thats not the problem ill try again in a lil bit.

That should be an error log TXT file, viewable in notepad. The postgres function should delete it if all went well.

If it's not the password thing, I'd wager it is the spaces in your DB names - I never thought about that since I never bother to reneme my DBs, they are all PTPGSQL! etc.

Alteration of the psql function with this changed line I hope will fix it:

<font class="small">Code:</font><hr /><pre>

command := "psql.exe -A -t -h " . host . " -p 5432 -U " . username . " -d """ . database . """ -f " . file1 . " -o " . file2 . " 2&gt; " . file3
</pre><hr />

I just put quotes around the database variable. Seems to cause no problem on my databases, so I guess it should work for ones with spaces in the names

I'll probably make a testing database later and try it out...

dave.

'psql.exe' is not recognized as an internal or external command, operable program or batch file.

i opened up those error logs and got that message. Anyway to rename those DBs? back to PTPGSQL! etc.

dave that command thing you just stuck in the previous post. what exactly am i supposed to do with it?

go to "c:\program files\Postgresql8.0\bin"

copy psql.exe to the same folder as the script. That's the easy way to fix this.

Otherwise add postgres bin directory to your PATH variable, a little more complicated, but thn psql is available in any location.

ok dave i copied the file into the folder. new error log contains this... (im importing hands atm in pokertracker not sure if that is casuing an error)

20070107154722_Stars: Permission denied
psql: warning: extra command-line argument "MAIN" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_7048_in.txt" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_7048_out.txt" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_7048_error.txt" ignored
psql: FATAL: database "STARS" does not exist

Now that is what I'd expect to see because of spaces in the DB names.

open your copy of Roland's Functions (functions.ahk) in notepad, scroll right to the end. IIRC the psql function is the last one in there.

change the line I posted a correction for out a few posts up ( command := psql .... ).

Hopefully fixed it (or at least gives us different errors)

dave.

ok dave.

i copied and pasted that line (i didn't change anything to it, not sure if i should have or not).

Got these errors.

20070107165554_Stars: Permission denied
psql: warning: extra command-line argument "-" ignored
psql: warning: extra command-line argument "10/20" ignored
psql: warning: extra command-line argument "6" ignored
psql: warning: extra command-line argument "MAX" ignored
psql: warning: extra command-line argument "OBSERVED" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_9702_in.txt" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_9702_out.txt" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_9702_error.txt" ignored
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

20070107165555_Stars: Permission denied
psql: warning: extra command-line argument "MAIN" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_2040_in.txt" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_2040_out.txt" ignored
psql: warning: extra command-line argument "Buddy" ignored
psql: warning: extra command-line argument "List.ahk_2040_error.txt" ignored
psql: FATAL: database "STARS" does not exist

Sorry for the mess, I forgot that the postgres function doesn't work out-of-box. I added daves instructions for getting it to work to the documentation and added the double-quotes fix to my functions (please download again if you are having trouble getting the SQL part to work).

v1.04 checks whether a player is hiding from search before adding him to your buddy list.

does this require your stars db to be psql instead of access?

Nice work, Roland.

Would you consider to extend the "add players to your buddy list function" to include 9-max tables?

BTW, the little bubble in the task bar still says 1.02.

any chance someone can convert the code into a downloadable file, so its easier for me to put on? Im a tard at getting scripts to work via copy/paste on forums.

thanks in advance.

Roland et al - I have followed the instructions on the Wiki but still can't get the program to properly show the stakes.

For example:

Player CHO3178 is seated at a 3/6 6max NL table, a limit that I have played with hand histories stored in the database NL MAIN.



The program shows the Stakes as blank:


Player chkdoz7 is seated at a 1/2 6max NL table:



But the program seems to think that he is at a 2/4 6max NL table:




I have set the script to query the following databases:
LIMIT DATAMINE,LIMIT MAIN,NL DATAMINE,NL MAIN

and my PT Database Names are as follows:


Help? Thanks!

Hi.
Can´t really get this to work. When I run the script the following message shows:

Error in #include file "C:...\...\AHK\StarsBuddy\Functions.ahk": The leftmost character above is illegal in an expression.
Spcifically:
Line#
757:}
760:{
764:if activate
765:WinActivate,akh_id%table_id%
766:Postmessage,0x201,0x0001,((
767:Postmessage,0x202,0,((
768:}
---&gt;774:{
The program will exit

I don´t know anything about these things so please help me!

// M

BUMP!

(Reallly need help with this)!!!!