Script: Mark Current Hand
04-01-2013
, 07:17 PM
Quote:
Download:http://www.mediafire.com/?8uabwa26sh0bean
Download the .zip file and unzip it
Place the "markhand" folder under C:\
C:\markhand
Open the folder and right click the markhand.exe and select properties then click the compatibility tab and tick the "run this program as administrator" box and click apply / ok
Load the program and fill in all the options..
Your postgres .bin folder might be in a different place so make sure you point the program to the right folder.
Pokerstars HH Folder: Make sure you select your user name and not just the HH folder
Postgres user name: postgres
Postgres Database: "What ever your database is called"
Click ok when you filled out all the options and it will create a markhand.ini file which will save all your settings so you dont have to fill out the settings again, so make sure you dont move or delete the .ini file.
Start marking hands with what ever hotkey you selected and when you have finished your session click the process .sql hotkey and a command prompt will pop up and it will ask you for your postgres password which is "postgrespass", enter password and hit enter and it will mark all the hands in HM.
In HM2 click the Reports tab, in there click More Reports and select "By HandMarking - Tournament" and your marked hands will be there. ( HM1 I dont know where the option is because I dont use it )
Also instead of having to keep going to C:\markhand folder to load the program just go in the folder and right click the MarkHands.exe and select send to>>>> desktop (create shortcut)
Should work if you follow them instructions it does for me.
Download the .zip file and unzip it
Place the "markhand" folder under C:\
C:\markhand
Open the folder and right click the markhand.exe and select properties then click the compatibility tab and tick the "run this program as administrator" box and click apply / ok
Load the program and fill in all the options..
Your postgres .bin folder might be in a different place so make sure you point the program to the right folder.
Pokerstars HH Folder: Make sure you select your user name and not just the HH folder
Postgres user name: postgres
Postgres Database: "What ever your database is called"
Click ok when you filled out all the options and it will create a markhand.ini file which will save all your settings so you dont have to fill out the settings again, so make sure you dont move or delete the .ini file.
Start marking hands with what ever hotkey you selected and when you have finished your session click the process .sql hotkey and a command prompt will pop up and it will ask you for your postgres password which is "postgrespass", enter password and hit enter and it will mark all the hands in HM.
In HM2 click the Reports tab, in there click More Reports and select "By HandMarking - Tournament" and your marked hands will be there. ( HM1 I dont know where the option is because I dont use it )
Also instead of having to keep going to C:\markhand folder to load the program just go in the folder and right click the MarkHands.exe and select send to>>>> desktop (create shortcut)
Should work if you follow them instructions it does for me.
But I just get this when I click the process .sql hotkey...
05-21-2013
, 03:18 PM
Yeah, entered the wrong name, thanks for the hint.
Tried it again with the correct database name, now there are new errors:
First error said that the database does not exist, though I wrote the name correctly (it's long though, "HEM 1 DB for postgres 9.0", maybe problem came from that?).
Checked name again, tried it again two times, got the same error message for the second try.
For third try I got a different error message:
Translates to: "The command C:\... is either written incorrectly or couldn't be found".
Versions: HEM1; postgreSQL 9.0
Folders set correctly, HEM1 box checked, username and database name set correctly.
Tried it again with the correct database name, now there are new errors:
First error said that the database does not exist, though I wrote the name correctly (it's long though, "HEM 1 DB for postgres 9.0", maybe problem came from that?).
Checked name again, tried it again two times, got the same error message for the second try.
For third try I got a different error message:
Translates to: "The command C:\... is either written incorrectly or couldn't be found".
Versions: HEM1; postgreSQL 9.0
Folders set correctly, HEM1 box checked, username and database name set correctly.
Last edited by LeaksSuck; 05-21-2013 at 03:25 PM.
05-23-2013
, 09:52 AM
I tried both the version in your link and the latest one SCOOOP posted.
Renamed the database now to HEM1DB, still tells me this database does not exist.
Error message:
Database does exist and name is correct:
Settings are correct:
Script is in C:\markhand\
Username "postgres" is also correct.
Maybe it doesn't work with postgresql 9.0 but needs 8.x?
Thanks for taking the time to help me
Renamed the database now to HEM1DB, still tells me this database does not exist.
Error message:
Database does exist and name is correct:
Settings are correct:
Script is in C:\markhand\
Username "postgres" is also correct.
Maybe it doesn't work with postgresql 9.0 but needs 8.x?
Thanks for taking the time to help me
06-08-2013
, 12:38 PM
hello Max1mums,
I can't make this script work.
It didn't work for Zoom hands (I just changed line #284 to read : "game=PokerStars Zoom Hand #")
Then, the psql command returns a probable error which I can't identify :
Here's an example of the temp.txt produced :
Any idea what might be wrong ?
I can't make this script work.
It didn't work for Zoom hands (I just changed line #284 to read : "game=PokerStars Zoom Hand #")
Then, the psql command returns a probable error which I can't identify :
Here's an example of the temp.txt produced :
Code:
insert into hand_markings (marking_id, gamenumber, site_id) select 1, gamenumber, pokersite_id from pokerhands Where gamenumber = 99738676629 and (1, gamenumber) not in (select marking_id, gamenumber from hand_markings); update hand_markings set marking_id = 1 where gamenumber = 99738676629 ; insert into hand_markings (marking_id, gamenumber, site_id) select 1, gamenumber, pokersite_id from pokerhands Where gamenumber = 99738716521 and (1, gamenumber) not in (select marking_id, gamenumber from hand_markings); update hand_markings set marking_id = 1 where gamenumber = 99738716521 ;
Last edited by Michel.be; 06-08-2013 at 12:44 PM.
06-10-2013
, 02:35 AM
After checking the content of the DB in pgAdminIII, I can see the queries execute properly from the script (I tried and execute them also directly in pgAdminIII).
The data is in the table as expected, but for whatever reason do not appear in HEM :
when I check the "Marked hands" checkbox, the hands which were marked from inside HEM do appear, but the hands marked from the script don't appear.
[...]
OK ! I updated to the latest HEM beta, and that fixed it !
Now all marked hands appear
The data is in the table as expected, but for whatever reason do not appear in HEM :
when I check the "Marked hands" checkbox, the hands which were marked from inside HEM do appear, but the hands marked from the script don't appear.
[...]
OK ! I updated to the latest HEM beta, and that fixed it !
Now all marked hands appear
06-19-2013
, 11:36 AM
07-01-2013
, 05:31 PM
Hello.
Everything worked perfectly with 1st attempt with HM1 but I recently switched to HM2 and now getting this error.
Maybe anyone had this error and knows how to fix this?
Thank You.
Everything worked perfectly with 1st attempt with HM1 but I recently switched to HM2 and now getting this error.
Maybe anyone had this error and knows how to fix this?
Thank You.
07-02-2013
, 05:36 AM
I feel bit stupid now
Thank You everything works perfectly
Spoiler:
Thank You
everything works perfectly
07-09-2013
, 07:07 PM
Been trying to get this to work for a while now but can't make it happen.
The script does save a gamefilenumber txt with the hand numbers in it, but it doesn't show up in my HEM DB under marked hands.
When pressing the process sl hotkey I get the following screen:
I'm using the version from post 228
Setting are:
[LogFolder]
postgrespath=C:\postgreSQL\bin
StarsHHPath=C:\Users\xxxx\AppData\Local\PokerStars \HandHistory\xxxx
postgresdb="HoldemManager2"
postgresuser=postgres
FullTiltHHPath=
[Hotkeys]
HK_sql=Q
HK_mark=Shift+Q
[Settings]
HM2=1
Any help would be much appreciated
The script does save a gamefilenumber txt with the hand numbers in it, but it doesn't show up in my HEM DB under marked hands.
When pressing the process sl hotkey I get the following screen:
I'm using the version from post 228
Setting are:
[LogFolder]
postgrespath=C:\postgreSQL\bin
StarsHHPath=C:\Users\xxxx\AppData\Local\PokerStars \HandHistory\xxxx
postgresdb="HoldemManager2"
postgresuser=postgres
FullTiltHHPath=
[Hotkeys]
HK_sql=Q
HK_mark=Shift+Q
[Settings]
HM2=1
Any help would be much appreciated