::reinstallhmandsql::
(
Vista:  Turn off UAC - http://www.holdemmanager.net/faq/afm....aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL.  Once you get those installed you can add exceptions to the firewall.  If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171


Before you uninstall HM:

I want to re-install Holdem Manger without losing all of my settings and preferences. Can this be done?

You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file.  I usually just copy my entire \Holdem Manager directory.  

I would also make sure you manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

How do I export or import hands into and from Holdem Manager?


Make sure you copy that folder as well as the other stuff I mentioned.

This helps to insure that if anything goes wrong with the backup/restore, you can manually import the exported files to rebuild.




For uninstalling SQL please follow these steps:

-Uninstall PostgreSQL from the Windows Control Panel.  

- manually delete the Program Files\Postgresql folders
- run the command - start > run > cmd >


	
PHP Code:
	

		
			
net user postgres /delete 



		
	
- reboot.
- install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using these directions and postgresql.zip version.

http://www.holdemmanager.net/faq/afm...aspx?faqid=176 


Logging:

I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips


To turn off logging, follow these instructions.  This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With..  > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.


	
PHP Code:
	

		
			
------------------------------------------------------------------------------# ERROR REPORTING AND LOGGING#------------------------------------------------------------------------------# - Where to Log -log_destination = 'stderr'        # Valid values are combinations of                    # stderr, csvlog, syslog and eventlog,                    # depending on platform.  csvlog                    # requires logging_collector to be on.# This is used when logging to stderr:logging_collector = off        # Enable capturing of stderr and csvlog 



		
	
File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.

*edit:
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


Now you should be ready to do a bulk Import From Folder

Make sure you have the latest HM Beta installed:

HM > Import From Folder > point at your exported text files folder you made earlier.

\RVG Software\Holdem Manager\HandHistoryExport_YourDataBaseName


When reinstalling HM, install the full setup, then the latest beta patch and finally your config folder if you want to use your previous hud configs.  

1) Make a backup of your C:\Program Files\RVG Software\Holdem Manager\Config folder, and other important files mentioned earlier.
2) Uninstall HM with Revo Uninstaller
3) Go to Program Files and delete the RVG Software directory, or the equivalent for Vista
4) Reboot your computer
5) Install the complete setup of HM: http://rvgsoftware.fileburst.com/holdemmanager.zip
7) Download the latest patch HM: http://rvgsoftware.fileburst.com/HmBetaUpdate.exe
8) Test if it for a while and see if it work
9) Close down Holdem Manager and copy the config folder from step 1 and copy and overwrite it to your C:\Program Files\RVG Software\Holdem Manager\Config folder, and import any notes and hands/database.
10) Test if it works again for a while
)

;
; AutoHotkey Version: 1.x
; Language:       English
; Platform:       Win9x/NT
; Author:         A.N.Other <myemail@nowhere.com>
;
; Script Function:
;	Template script (you can customize this template by editing "ShellNew\Template.ahk" in your Windows folder)
;

#NoEnv  ; Recommended for performance and compatibility with future AutoHotkey releases.
SendMode Input  ; Recommended for new scripts due to its superior speed and reliability.
SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.
#SingleInstance, force
#Persistent
Menu, Tray, Add, Show_Gui
FileRead, temp, %A_scriptname%
pos:=InStr(temp, "HOTSTRINGS:", CaseSensitive = False, StartingPos = 650) + 10
StringTrimLeft, HotStringList, temp, %pos%
GuiBuild()
return
GuiBuild() {
global
StringTrimLeft, hlist, hotstringlist, 4
StringReplace, hlist, hlist, ::, §, all
StringReplace, hlist, hlist, `r,, all
StringReplace, hlist, hlist, `n,, all
StringSplit, list, hlist, §
Gui, color, 555444
Gui, +toolwindow
Gui, font, s10 w725, Tahoma
Gui, add, text, , Add hotstring:
Gui, add, edit, w150 vNewAbb, 
Gui, add, text, , Full phrase:
Gui, add, edit, W250 vNewPhrase
Gui, add, button, gAdd, &Add
Gui, add, text, , Right click to delete entry
Gui, add, ListView, BackgroundSilver sort x10 w250 h325, Hotstring|Phrase
c1:=1
c2:=2
x:=list0/2
Loop %x%
{
f1:=list%c1%
f2:=list%c2%
LV_Add("", f1, f2)
LV_ModifyCol(Sort) 
c1:=c1+2
c2:=c2+2
}
;Gui, add, button, gDisplay, &Display abbreviations
Gui, add, button, gRunBkgr, &Run in background
Gui, add, button, gClose, &Close and Exit

Gui, show,, Notes & Chat abbreviations
}

GuiClose:
ExitApp 


Show_Gui:
Gui,  show
return

Add:
Gui, submit, nohide
HotstringList:=HotstringList . "::" . NewAbb . "::" . NewPhrase . "`r`n"
FileDelete, %A_Scriptname%
StringLeft, script, temp, %pos%
FileAppend, %script%, %A_Scriptname%
FileAppend, %HotstringList%, %A_Scriptname%
reload
return

GuiContextMenu:
if A_GuiEvent = RightCLick
{
LV_GetText(c1Text, A_EventInfo,1) 
LV_GetText(c2Text, A_EventInfo,2)
MsgBox, 1,Delete entry?, Delete entry`r%c1text% = %c2text% ?
}
ifmsgbox OK
{
delstring:="::" . c1text . "::" . c2text . "`r`n"
;msgbox %delstring%
StringReplace, hotstringlist, hotstringlist, %delstring%,, all

FileDelete, %A_Scriptname%
StringLeft, script, temp, %pos%
FileAppend, %script%, %A_Scriptname%
FileAppend, %HotstringList%, %A_Scriptname%
reload
return
}

ifmsgbox Cancel
return
RunBkgr:
Gui, hide
return

Close:
Process, Close, hotstrings.ahk
~^!q::
ExitApp
return

ExitApp
return

;====HOTSTRINGS: