C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\fpdb.py:241: DeprecationWarning: use gtk.UIManager
  self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\GuiBulkImport.py:97: GtkWarning: gtk_file_system_win32_get_parent: assertion `g_path_is_absolute (filename)' failed
  self.chooser.set_filename(self.settings['bulkImport-defaultPath'])
Traceback (most recent call last):
  File "C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\GuiBulkImport.py", line 75, in load_clicked
    (stored, dups, partial, errs, ttime) = self.importer.runImport()
  File "C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\fpdb_import.py", line 159, in runImport
    (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1])
  File "C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\fpdb_import.py", line 231, in import_file_dict
    (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site)
  File "C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\fpdb_import.py", line 360, in import_fpdb_file
    ,self.fdb.cursor, site, category, hand, self.config)
  File "C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\fpdb_parse_logic.py", line 79, in mainParser
    playerIDs   = fpdb_simple.recognisePlayerIDs(cursor, names, siteID)
  File "C:\Users\Bulldozer\Downloads\fpdb\pyfpdb\fpdb_simple.py", line 1405, in recognisePlayerIDs
    cursor.executemany("INSERT INTO Players (name, siteId) VALUES (%s, "+str(site_id)+")", (notfound))
TypeError: not all arguments converted during string formatting

import Hud

aggregate_stats = {"ring": False, "tour": False} # config file!

class HUD_main(object):

$ python
Python 2.5.1 (r251:54863, Jun 15 2008, 18:24:51) 
[GCC 4.3.0 20080428 (Red Hat 4.3.0-8)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import xml.dom.minidom
>>> import pyexpat
>>>

sub get_stats{
	$pName=$_[0];
	$query = "SELECT SUM(HDs),SUM(street0VPI),
            SUM(street0Aggr),SUM(street1seen),SUM(otherRaisedStreet1),
            SUM(foldToOtherRaisedStreet1),SUM(street1Aggr),SUM(street2seen),
            SUM(otherRaisedStreet2),SUM(foldToOtherRaisedStreet2),SUM(street2Aggr),
            SUM(street3seen),SUM(otherRaisedStreet3),SUM(foldToOtherRaisedStreet3),
            SUM(street3Aggr),SUM(wonAtSd),SUM(sawShowdown) FROM hudcache,players 
            WHERE hudcache.playerId=players.id AND players.name='$pName'";	 
	$dbh = DBI->connect("DBI:mysqlPP:fpdb:localhost", "statparser", "statparser");
	$sqlQuery  = $dbh->prepare($query);	 
	$sqlQuery->execute;	

	while (@rawstats = $sqlQuery->fetchrow_array()){
		@stats = (
			($rawstats[1] / $rawstats[0]),		#VPIP(0)
            ($rawstats[2] / $rawstats[0]),		#PFR(1)
            ($rawstats[6]/($rawstats[3] + $rawstats[7] + $rawstats[11]) * 10),#AF
            ($rawstats[16] / $rawstats[3]), 	#WTSD(2)
            ($rawstats[15] / $rawstats[3]),		#WASD(3)
            ($rawstats[0]),                 	#SS(4)
            ($rawstats[5] / $rawstats[4]),  	#prFold1(5)
            ($rawstats[7] / $rawstats[3]),  	#prCall1(6)
            ($rawstats[6] / $rawstats[3]),  	#PrRaise1(7)
            ($rawstats[9] / $rawstats[8]),  	#prFold2(8)
            ($rawstats[11] / $rawstats[7]),  	#prCall2(9)
            ($rawstats[10] / $rawstats[7]),  	#PrRaise2(10)
            ($rawstats[13] / $rawstats[12]), 	#PrFold3(11)
            ($rawstats[16] / $rawstats[11]),  	#prCall3(12)
            ($rawstats[14] / $rawstats[11]))if defined $rawstats[0];
		}
	print "Stats for $pName:\n\nVPIP:$stats[0]\tPFR:$stats[1]\tAF:$stats[2]\nWTSD:$stats[3]\tWASD:$stats[4]\tSample size:$stats[5]
	\n\nFlop Probability triple:\nFold: $stats[6]\tCall: $stats[7]\tRaise: $stats[8]\n
	\nTurn Probability triple:\nFold: $stats[9]\tCall: $stats[10]\tRaise: $stats[11]\n
	\nRiver Probability triple:\nFold: $stats[12]\tCall: $stats[13]\tRaise: $stats[14]\n\n\n" if defined $stats[0];	
    return @stats;
	$sqlQuery->finish();
}

sub autorates {	
	if ($stats[0] < 12) && ($stats[1] > ($stats[0] / 1.5)) && ($stats[3] > 2)){
		$playertype = 'TAGAG';}
		elsif ($stats[0] < 30) && ($stats[1] < ($stats[0] / 2)) && ($stats[3] < 1.5)){
		$playertype = 'DONK';}
		elsif ($stats[0] < 12) && ($stats[1] < ($stats[0] / 2)) && ($stats[3] < 1.5)){
		$playertype = 'NIT';}
		elsif ($stats[0] > 20) && ($stats[1] < ($stats[0] / 1.5)) && ($stats[3] > 2)){
		$playertype = 'LAGAG';}
		elsif ($stats[0] < 10) && ($stats[1] > ($stats[0] / 2)) && ($stats[3] < 2)){
		$playertype = 'ROCK';}
		
}

Aggression:N
ARI_2   1       LP-P:   >= 50%, < 10%, <= 1
1       2       50.00           Vol. Put Money In Pot % is greater than or equal to 50.00
2       3       10.00           Pre-flop Raise % is less than 10.00
15      4       1.00            Aggression Factor - Total is less than or equal to 1.00
ARI_14  2       LP-A:   >= 50%, < 10%, > 1
1       2       50.00           Vol. Put Money In Pot % is greater than or equal to 50.00
2       3       10.00           Pre-flop Raise % is less than 10.00
15      1       1.00            Aggression Factor - Total is greater than 1.00
ARI_12  3       sLP-P:  30% - 50%, < 10%, <= 1.5
1       5       30.00   50.00   Vol. Put Money In Pot % is between 30.00 and 50.00
2       3       10.00           Pre-flop Raise % is less than 10.00
15      4       1.50            Aggression Factor - Total is less than or equal to 1.50
ARI_11  4       sLP-A:  30% - 50%, < 10%, >= 1.5
1       5       30.00   50.00   Vol. Put Money In Pot % is between 30.00 and 50.00
2       3       10.00           Pre-flop Raise % is less than 10.00
15      2       1.50            Aggression Factor - Total is greater than or equal to 1.50
ARI_8   5       LA-P:   >= 50%, >= 10%, <= 1.5
1       2       50.00           Vol. Put Money In Pot % is greater than or equal to 50.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      4       1.50            Aggression Factor - Total is less than or equal to 1.50
ARI_10  6       LA-A:   >= 50%, >= 10%, >= 1.5
1       2       50.00           Vol. Put Money In Pot % is greater than or equal to 50.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      2       1.50            Aggression Factor - Total is greater than or equal to 1.50
ARI_5   7       sLA-P: 30% - 50%, >= 10%, <= 1.5
1       5       30.00   50.00   Vol. Put Money In Pot % is between 30.00 and 50.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      4       1.50            Aggression Factor - Total is less than or equal to 1.50
ARI_4   8       sLA-A: 30% - 50%, >= 10%, >= 1.5
1       5       30.00   50.00   Vol. Put Money In Pot % is between 30.00 and 50.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      2       1.50            Aggression Factor - Total is greater than or equal to 1.50
ARI_9   9       TP-P:  <= 20%, < 10%, <= 1.5
1       4       20.00           Vol. Put Money In Pot % is less than or equal to 20.00
2       3       10.00           Pre-flop Raise % is less than 10.00
15      4       1.50            Aggression Factor - Total is less than or equal to 1.50
ARI_13  10      TP-A:  <= 30%, < 10%, >= 1.5
1       4       30.00           Vol. Put Money In Pot % is less than or equal to 30.00
2       3       10.00           Pre-flop Raise % is less than 10.00
15      2       1.50            Aggression Factor - Total is greater than or equal to 1.50
ARI_6   11      TA-P:  <= 30%, > 10%, <= 1
1       4       30.00           Vol. Put Money In Pot % is less than or equal to 30.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      4       1.00            Aggression Factor - Total is less than or equal to 1.00
ARI_15  12      TA-N:  <= 30%, > 10%, 1 - 2
1       4       30.00           Vol. Put Money In Pot % is less than or equal to 30.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      5       1.00    2.00    Aggression Factor - Total is between 1.00 and 2.00
ARI_3   13      TA-A:  <= 30%, > 10%, >= 1.5
1       4       30.00           Vol. Put Money In Pot % is less than or equal to 30.00
2       2       10.00           Pre-flop Raise % is greater than or equal to 10.00
15      2       1.50            Aggression Factor - Total is greater than or equal to 1.50

Traceback (most recent call last):
  File "C:\Program Files\pyfpdb\fpdb.py", line 465, in <module>
    me = fpdb()
  File "C:\Program Files\pyfpdb\fpdb.py", line 377, in __init__
    self.load_profile()
  File "C:\Program Files\pyfpdb\fpdb.py", line 269, in load_profile
    self.settings['db-password'])
  File "C:\Program Files\pyfpdb\fpdb_db.py", line 54, in connect
    raise FpdbError('Database backend not defined')
NameError: global name 'FpdbError' is not defined

    <supported_databases>
    	<database db_name="fpdb"         db_server="postgres"      db_ip="localhost" db_user="fpdb"   db_pass="" db_type="fpdb">    </database>
    </supported_databases>
    <aux_windows>
    	<aw card_ht="42" card_wd="30" class="Stud_mucked" cols="11" deck="Cards01.png" module="Mucked" name="stud_mucked" rows="8"> </aw>
    </aux_windows>
</FreePokerToolsConfig>

db_server="postgresql"