My Stats Stuff.. or .. my "geekdom":

OK, Bill Rini asked for a preview, lets see what I can do here.

This is the input:

----------------------------------------------------

The date.....: />

The time.....: />

The DOW..: />

location......:

limit...........:

duration.....:

winloss......:

game..........:


Insert

Totals Only

LIST CVS RECORDS





Record ID..:

Delete Records

Update Date

Update Time

Update DOW

Update Location

Update Limit

Update Duration

Update WinLoss

Update Game

----------------------------------------------------

OK, on the input stuff, the php stuff that figures out the currect date/time is not working on the Blogger site here. Basically:
value=< ? php echo date("Y-m-d") .. this will put in the correct date in the format 2005-09-12 for today's date. value=< ? php echo date("H:i:00") .. this will put in the current time in the format 12:26:00 for the current time. Notes: must have php loaded on your PC; there is no space between the less-than sign and the question mark, I separated so that the editor would not try to make some kind of html out of it. If the Insert radio button is selected, the action.php form that I send the information to will insert the information that I inputted into the database. If it's Totals Only, then, you guessed it, no insert just totals:

Grand Total	Duration
xxxx.26	xxxx.18

Today's Totals	Duration
xxx.xx	xxx.xx

GAME	LIMIT	$perHOUR	TOTAL_$s	TOTAL_HRS
5cardstud	1/2	-00024.47	-00046.50	1.90
adjust_bonus_re	0.01/0.02	000048.50	000194.00	4.00
adjust_bonus_re	1/2	000020.00	000020.00	1.00
draw	0.05/0.10	000000.22	000001.00	4.50
draw	0.25/0.5	000000.65	000039.50	60.00
draw	0.5/1	000005.03	0000xx.00	xx.50
draw	1/2	000005.84	xxxxxx.45	xx.80
draw	2/4	-00000.59	-00020.00	33.57
draw	3/6	000005.98	000038.10	6.37
draw	5/10	001283.33	000038.50	0.03
draw	tournament	000000.87	000016.00	18.25
Holdem	0.05/0.10	000001.67	000004.19	2.50
Holdem	0.10/0.20	000000.00	000000.00	7.00
Holdem	0.25/0.5	000001.11	000071.20	64.12
Holdem	0.5/1	000000.59	000064.24	107.98

And, oh there's more, no limit stats, tourney stats, stud, stud hi/low, etc.. I didn't include the whole table :p

In the table, I use a Java script that I got from http://javascript.internet.com. This script sorts the table that I create to output the values. The way the script works, I have to pad the table with zeroes so that it sorts correctly! There's prolly a better way.. I just haven't found one yet.

Also, the table that spits out is lifetime, over 2 years ago. That's since I start keeping stats on StatKing (I imported everything from the DB that I had on the other PC).

Since I play better then I did 2 years ago, created a totals only type input that will date range:

from date1...: />
to date1.......: />

from date2...: />
to date2.......: />



As stated in the previous post, I like to see a rolling month and 3 months to see how I'm doing currently. The dates, again, are produced from php:

$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"))
$lastquarter = mktime(0, 0, 0, date("m")-3, date("d"), date("Y"));

...in the value of the form for last month: date("Y-m-d", $lastmonth)
...in the value for quarter: date("Y-m-d", $lastquarter)
...then the current dates is just: date("Y-m-d")

The output (complete with debug statements of the sql query that I use):
-------------------------------------------------------------

DEBUG: query=SELECT location, SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 > '2005-08-12' and dat3 <= '2005-09-12' GROUP BY location

Location	Total	Duration
FullTilt	11.95	4.50
Intertops	xx.70	32.42
Pacific	-8.01	7.88
Paradise	36.50	5.62
PokerRoom	xx.00	xx.40
PokerStars	4.59	21.45
UltimateBet	4.51	18.85

DEBUG: query=SELECT location, game, l1m1t, SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 > '2005-08-12' and dat3 <= '2005-09-12' GROUP BY location, game, l1m1t

Location	Game	Limit	perHour	Total	Duration
FullTilt	NLHE	0.05/0.10	15.62	1.25	0.08
FullTilt	O8	0.25/0.5	-4.20	-4.20	1.00
FullTilt	PLO8	0.05/0.10	3.21	6.50	2.02
FullTilt	razz	0.25/0.5	-1.71	-1.15	0.67
FullTilt	razz	0.5/1	-22.00	-2.20	0.10
FullTilt	stud hi/low	0.25/0.5	18.65	11.75	0.63
Intertops	Holdem	tournament	10.74	98.50	9.17
Intertops	NLHE	0.10/0.25	13.36	98.26	7.35
Intertops	NLHE	tournament	0.20	2.70	13.25
Intertops	O8	0.5/1	100.92	13.12	0.13
Intertops	stud hi/low	0.5/1	-2.73	-6.88	2.52
Pacific	O8	0.05/0.10	1.09	1.86	1.70
Pacific	O8	0.5/1	-18.28	-5.12	0.28
Pacific	stud hi/low	0.05/0.10	0.88	2.90	3.27
Pacific	stud hi/low	0.25/0.5	-2.90	-7.65	2.63
Paradise	draw	1/2	3.56	15.25	4.28
Paradise	draw	2/4	150.00	19.50	0.13
Paradise	O8	0.5/1	1.45	1.75	1.20
PokerRoom	adjust_bonus_re	0.01/0.02	10.00	10.00	1.00
PokerRoom	adjust_bonus_re	1/2	20.00	20.00	1.00
PokerRoom	draw	1/2	7.03	272.90	38.77
PokerRoom	draw	2/4	31.81	7.00	0.22
PokerRoom	draw	3/6	-38.29	-31.40	0.82
PokerRoom	draw	5/10	1283.33	38.50	0.03
PokerRoom	Holdem	1/2	0.00	0.00	0.57
PokerStars	NLHE	tournament	-1.60	-1.20	0.75
PokerStars	PLO8	0.01/0.02	0.32	0.12	0.37
PokerStars	stud hi/low	0.04/0.08	0.70	9.12	12.90
PokerStars	stud hi/low	0.25/0.5	-0.46	-3.45	7.43
UltimateBet	Holdem	0.05/0.10	3.01	3.41	1.13
UltimateBet	Holdem	0.25/0.5	-1.50	-7.35	4.87
UltimateBet	PLO8	0.01/0.02	0.65	8.45	12.85

DEBUG: query=SELECT game, l1m1t, SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 > '2005-08-12' and dat3 <= '2005-09-12' GROUP BY game, l1m1t

Game	Limit	perHour	Total	Duration
adjust_bonus_re	0.01/0.02	10.00	10.00	1.00
adjust_bonus_re	1/2	20.00	20.00	1.00
draw	1/2	6.69	xx.15	xx.05
draw	2/4	75.71	26.50	0.35
draw	3/6	-38.29	-31.40	0.82
draw	5/10	1283.33	38.50	0.03
Holdem	0.05/0.10	3.01	3.41	1.13
Holdem	0.25/0.5	-1.50	-7.35	4.87
Holdem	1/2	0.00	0.00	0.57
Holdem	2/10	4.40	11.00	2.50
Holdem	2/4	-32.00	-16.00	0.50
Holdem	2/6	-32.00	-48.00	1.50
Holdem	tournament	10.74	98.50	9.17
NLHE	0.05/0.10	15.62	1.25	0.08
NLHE	0.10/0.25	13.36	98.26	7.35
NLHE	2/5	-30.50	-61.00	2.00
NLHE	tournament	0.10	1.50	14.00
O8	0.05/0.10	1.09	1.86	1.70
O8	0.25/0.5	-4.20	-4.20	1.00
O8	0.5/1	6.01	9.75	1.62
PLO8	0.01/0.02	0.64	8.57	13.22
PLO8	0.05/0.10	3.21	6.50	2.02
razz	0.25/0.5	-1.71	-1.15	0.67
razz	0.5/1	-22.00	-2.20	0.10
stud hi/low	0.04/0.08	0.70	9.12	12.90
stud hi/low	0.05/0.10	0.88	2.90	3.27
stud hi/low	0.25/0.5	0.06	0.65	10.70
stud hi/low	0.5/1	-2.73	-6.88	2.52

DEBUG: query=SELECT SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 >= '2005-08-12' and dat3 <= '2005-09-12'

Grand Total	Duration
xxx.68	144.17

DEBUG: query=SELECT location, SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 > '2005-06-12' and dat3 <= '2005-09-12' GROUP BY location

Location	Total	Duration
24h	-38.00	11.20
FullTilt	18.20	24.22
Intertops	xx.75	43.03
Pacific	-3.20	28.75
Paradise	72.25	16.82
PartyPoker	0.50	0.72
PokerRoom	xx.50	xx.93
PokerStars	2.36	46.40
Rio	-363.00	33.58
UltimateBet	5.37	21.35

DEBUG: query=SELECT location, game, l1m1t, SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 > '2005-06-12' and dat3 <= '2005-09-12' GROUP BY location, game, l1m1t

Location	Game	Limit	perHour	Total	Duration
24h	PLdraw	0.25/0.5	-3.33	-37.00	11.10
24h	PLdraw	0.5/1	-10.00	-1.00	0.10
FullTilt	NLHE	0.05/0.10	15.62	1.25	0.08
FullTilt	NLHE	tournament	6.25	12.50	2.00
FullTilt	O8	0.25/0.5	-4.20	-4.20	1.00
FullTilt	PLO	0.05/0.10	-10.44	-15.35	1.47
FullTilt	PLO8	0.05/0.10	0.49	3.90	7.92
FullTilt	PLO8	0.25/0.5	-3.16	-0.95	0.30
FullTilt	razz	0.25/0.5	-0.37	-2.55	6.85
FullTilt	razz	0.5/1	9.39	10.05	1.07
FullTilt	stud	0.25/0.5	-0.67	-0.55	0.82
FullTilt	stud hi/low	0.10/0.25	5.00	1.25	0.25
FullTilt	stud hi/low	0.25/0.5	5.20	12.85	2.47
Intertops	Holdem	tournament	10.74	98.50	9.17
Intertops	NLHE	0.10/0.25	13.36	98.26	7.35
Intertops	NLHE	tournament	1.94	42.70	21.98
Intertops	O8	0.5/1	100.92	13.12	0.13
Intertops	stud hi/low	0.5/1	-0.64	-2.83	4.40
Pacific	Holdem	0.05/0.10	0.78	0.26	0.33
Pacific	O8	0.05/0.10	1.00	3.33	3.30
Pacific	O8	0.25/0.5	-3.25	-8.19	2.52
Pacific	O8	0.5/1	-18.28	-5.12	0.28
Pacific	PLO8	0.05/0.10	-1.80	-0.45	0.25
Pacific	stud	0.05/0.10	-0.34	-1.49	4.35
Pacific	stud hi/low	0.05/0.10	1.07	8.12	7.58
Pacific	stud hi/low	0.25/0.5	0.03	0.34	10.13
Paradise	draw	1/2	1.35	18.25	13.43
Paradise	draw	2/4	112.50	56.25	0.50
Paradise	O8	0.5/1	1.45	1.75	1.20
Paradise	stud	0.5/1	-3.75	-4.50	1.20
Paradise	stud hi/low	0.5/1	1.04	0.50	0.48
PartyPoker	Holdem	0.5/1	0.69	0.50	0.72
PokerRoom	adjust_bonus_re	0.01/0.02	10.00	10.00	1.00
PokerRoom	adjust_bonus_re	1/2	20.00	20.00	1.00
PokerRoom	draw	1/2	10.05	xx.65	xx.55
PokerRoom	draw	2/4	-37.50	-30.00	0.80
PokerRoom	draw	3/6	-38.29	-31.40	0.82
PokerRoom	draw	5/10	1283.33	38.50	0.03
PokerRoom	Holdem	0.5/1	4.41	0.75	0.17
PokerRoom	Holdem	1/2	0.00	0.00	0.57
PokerStars	NLHE	tournament	-1.60	-1.20	0.75
PokerStars	PLO8	0.01/0.02	0.32	0.12	0.37
PokerStars	PLO8	tournament	-11.00	-11.00	1.00
PokerStars	stud	0.05/0.10	0.97	0.34	0.35
PokerStars	stud hi/low	0.04/0.08	0.65	18.17	27.85
PokerStars	stud hi/low	0.05/0.10	2.52	0.63	0.25
PokerStars	stud hi/low	0.25/0.5	-0.32	-4.90	15.08
PokerStars	stud hi/low	1/2	0.26	0.20	0.75
Rio	mixed	5/10	-40.00	-120.00	3.00
Rio	NLHE	1/2	-52.35	-323.00	6.17
Rio	NLHE	2/5	63.76	234.00	3.67
Rio	NLHE	tournament	8.61	140.00	16.25
Rio	O8	10/20	-94.57	-331.00	3.50
Rio	stud hi/low	20/40	37.00	37.00	1.00
UltimateBet	Holdem	0.05/0.10	3.01	3.41	1.13
UltimateBet	Holdem	0.25/0.5	-1.50	-7.35	4.87
UltimateBet	PLO	0.01/0.02	-1.60	-0.80	0.50
UltimateBet	PLO8	0.01/0.02	0.68	10.11	14.85

DEBUG: query=SELECT game, l1m1t, SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 > '2005-06-12' and dat3 <= '2005-09-12' GROUP BY game, l1m1t

Game	Limit	perHour	Total	Duration
adjust_bonus_re	0.01/0.02	10.00	10.00	1.00
adjust_bonus_re	1/2	20.00	20.00	1.00
draw	1/2	9.08	xx.90	xx.98
draw	2/4	20.19	26.25	1.30
draw	3/6	-38.29	-31.40	0.82
draw	5/10	1283.33	38.50	0.03
Holdem	0.05/0.10	2.49	3.67	1.47
Holdem	0.25/0.5	-1.50	-7.35	4.87
Holdem	0.5/1	1.42	1.25	0.88
Holdem	1/2	0.00	0.00	0.57
Holdem	2/10	4.40	11.00	2.50
Holdem	2/4	-32.00	-16.00	0.50
Holdem	2/6	-1.66	-5.00	3.00
Holdem	tournament	10.74	98.50	9.17
mixed	5/10	-40.00	-120.00	3.00
NLHE	0.05/0.10	15.62	1.25	0.08
NLHE	0.10/0.25	13.36	98.26	7.35
NLHE	1/2	-52.35	-323.00	6.17
NLHE	2/5	37.03	247.00	6.67
NLHE	tournament	4.73	194.00	40.98
O8	0.05/0.10	1.00	3.33	3.30
O8	0.25/0.5	-3.51	-12.39	3.52
O8	0.5/1	6.01	9.75	1.62
O8	10/20	-94.57	-331.00	3.50
PLdraw	0.25/0.5	-3.33	-37.00	11.10
PLdraw	0.5/1	-10.00	-1.00	0.10
PLO	0.01/0.02	-1.60	-0.80	0.50
PLO	0.05/0.10	-10.44	-15.35	1.47
PLO8	0.01/0.02	0.67	10.23	15.22
PLO8	0.05/0.10	0.42	3.45	8.17
PLO8	0.25/0.5	-3.16	-0.95	0.30
PLO8	tournament	-11.00	-11.00	1.00
razz	0.25/0.5	-0.37	-2.55	6.85
razz	0.5/1	9.39	10.05	1.07
stud	0.05/0.10	-0.24	-1.15	4.70
stud	0.25/0.5	-0.67	-0.55	0.82
stud	0.5/1	-3.75	-4.50	1.20
stud hi/low	0.04/0.08	0.65	18.17	27.85
stud hi/low	0.05/0.10	1.11	8.75	7.83
stud hi/low	0.10/0.25	5.00	1.25	0.25
stud hi/low	0.25/0.5	0.29	8.29	27.68
stud hi/low	0.5/1	-0.47	-2.33	4.88
stud hi/low	1/2	0.26	0.20	0.75
stud hi/low	20/40	37.00	37.00	1.00

DEBUG: query=SELECT SUM(winloss), SUM(duration/60) FROM stats2 WHERE dat3 >= '2005-06-12' and dat3 <= '2005-09-12'

Grand Total	Duration
xxx.37	xxx.22

---------------------------------------

This last table, shows the Grand Totals for the time period inputted. Plus it breaks it down by room and game/limit, so that I can see how well I do at the different locations. Then also breaks down just by game, so that I can see how well I do at each game, at each limit.

Eventually, I want to work something in there about the times and day-of-week as well. Already, intuitively, I know that I don't do well on Sundays, so I don't play. I'd like the DB to be able to tell me this time of information at some point so that I know what days and times I make the most money, so that I can concentrate my playing then. I just haven't gotten that far yet ;)

Posted by Glenn