Program to view Open Raise % by position?

[NL Newbie]

mehh [img]/images/graemlins/frown.gif[/img] Maybe i should convert to MYSQL, standard PT format wont let me run these cool appz huh?

[Mr_Snood]

You mean you have installed PostgreSQL 8.2. on a different port than "5432"?

Are you unable to change back to 5432,
or do you need a guide how to do that?

[gball]

I double-click the SQL.exe, but nothing happens, not even error message?

[marand]

[ QUOTE ]
You mean you have installed PostgreSQL 8.2. on a different port than "5432"?

Are you unable to change back to 5432,
or do you need a guide how to do that?

[/ QUOTE ]

I have postgre8.2 on port 5433 since I followed the guide at PT when I upgraded to the new SQL version. I have now uninstalled my old postgresql version so only using 8.2.

How do I change it to use port 5432 for all my databases?

[MasterLJ]

The top % of hands is always debatable, which is why a graphical hand range will never be 100% accurate.

[Mr_Snood]

Here are soe quote's on how to change the port:
[ QUOTE ]
Our House,

The postgresql.conf file is just a plain old text file. Open it in notepad, wordpad, etc then look for this section near the top...

[ QUOTE ]
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '192.168.100.90' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port = 5432
max_connections = 100
....


[/ QUOTE ]

Then change the port from 5433 to 5432 and restart the PSQL service.

[/ QUOTE ]

You can find the postgresql.conf (and all other things) by going to "Start"->"All Programs"->"PostgreSQL"->"Configuration Files" ....

[ QUOTE ]
That worked, Perc. Thank you! I needed to take some of the other steps from my earlier post.

A few things to note (for others who need to do this):

- Stop the PostgreSQL service
- Change the port# to 5432 in the postgresql.conf file
- Remove the PostgreSQL settings in PokerTracker and add them again under port# 5432
- Go to the ODBC datasources (System DSN tab) and edit all of the unicode databases and the unicode test port so that they are also at port# 5432
- Enter the PGAdminIII tool from the start menu (under PostgreSQL) and change the properties of the 8.1/8.2 Database Server so it works from port# 5432
- Restart the PostgreSQL service

** If PokerAceHUD doesn't update stats correctly (mine didn't), then just close BOTH PAHUD and PokerTracker, run the registry editor from my above post, and reopen them.

That should do it.

[/ QUOTE ]

[Mr_Snood]

Hmmmmm. Hard to say.

The SQL.exe need to access the internet,
because the trial period is saved online...
As I said i have written this tool few weeks/months ago
and was not sure wether it will advance to a real project or not...

Back to your problem:
Is maybe the firewall blocking it?

[dfan]

This information is something I've wanted for a long time so I was happy to read about your app. So I downloaded, unzipped, and ran SQL.exe. It started ok, and I went to options and added a couple of my PT SQL db's. They did seem to be added OK (BTW am I supposed to check the box under active? I tried it both ways, in any case). However when I type in my own username in the box at the upper left and click Add there is no data in the table that appears. I am getting data though on other users.

Any ideas, suggestions?

[Mr_Snood]

Hm weird.

You can query your DB(s) for other player but not for yourself?
Sounds as if you search for the wrong playername,
but i guess you know your own screenname [img]/images/graemlins/smile.gif[/img].

Im not familiar with all those PT "alias" stuff.
Did you recently changed your screenname or use the alias stuff?

Usually the name which is displayed under "ring gameplayer stats" in PT is what you have to enter in the SQL-App.

Edit: Oh and "yes" you have to check the box under "active" otherwise the database will not be used.
It is only in there to ease the switch between databases...

[bhudson]

Snood, what's CR if CT?

(very nice btw)

(and I have the same problem - none of my screennames show up, everyone else is fine. Weird.)