How do I enter a hand history into a mysql database?
I am planning to write a hud for five card draw, but at the moment I am lol bad
This is how a hand history looks from poker stars. I changed the screenname of the players to player 1 and so on.
PokerStars Hand #abignumber: 5 Card Draw Limit ($0.25/$0.50 USD) - 2015/08/08 0:07:29 CET [2015/08/07 18:07:29 ET]
Table 'Alrami V' 6-max Seat #2 is the button
Seat 1: Player1 ($9.04 in chips)
Seat 2: Player2 ($4.61 in chips)
Seat 3: Player3 ($66.69 in chips)
Seat 4: Hero ($5 in chips)
Seat 5: Player5 ($13.68 in chips)
Seat 6: Player6 ($3.10 in chips)
Player3: posts small blind $0.10
Hero: posts big blind $0.25
*** DEALING HANDS ***
Dealt to Hero [Ts 3c 3d Tc 8s]
Player5: calls $0.25
Player6: calls $0.25
Player1: folds
Player2: folds
Player3: folds
Hero: raises $0.25 to $0.50
Player5: calls $0.25
Player6: calls $0.25
Hero: discards 1 card [8s]
Dealt to Hero [Ts 3c 3d Tc] [2s]
Player5: discards 1 card
Player6: discards 1 card
Hero: checks
Player5: checks
Player6: bets $0.50
Hero: folds
Player5: calls $0.50
*** SHOW DOWN ***
Player6: shows [9h Th Jc Kh Qh] (a straight, Nine to King)
Player5: mucks hand
RAFULIK collected $2.48 from pot
*** SUMMARY ***
Total pot $2.60 | Rake $0.12
Seat 1: Player1 folded before the Draw (didn't bet)
Seat 2: Player2 (button) folded before the Draw (didn't bet)
Seat 3: Player3(small blind) folded before the Draw
Seat 4: Hero (big blind) folded after the Draw
Seat 5: Player5 [8h 8d 5s 6d 5c]
Seat 6: Player6 showed [9h Th Jc Kh Qh] and won ($2.48) with a straight, Nine to King
But how do I get it into some tables? It needs to be automated. I know a little bit c#, python and sql