N 82 50 24 / Nat Arem Blog

I have never published this anywhere else, but I figured this is as good a place as any.  There’s one person who no one in the poker world has heard of, but actually had a brief but pivotal role in the creation of thepokerdb.  His name is Richard Reich and he registered in Feb of 2005 on PSCrew, the forum that I used to run a long time ago.  Oddly enough, the email chain started because of a policy that I made regarding profile pictures on the site, but I took a look at his website and saw a technical background in his resume.  I was having technical problems trying to create thepokerdb, so I fired off the following email on Feb 18th, 2005 at 10:22 AM:

Richard,

I took a look at your site and couldn’t help but notice the technical expertise in your background.  I am hoping you might know someone who can help me with this problem that I have…

We are try to implement a cardplayer-like tournament tracking system for stars MTTs — ie., links tournaments & player names and allows one to drill down, but it would only show final table results.  I have a database component for my portal that will allow me to set this up, but I don’t know how to get the data from stars.  We could input it manually, but that would be incredibly time consuming.  If we were forced to do this, we would have to restrict the database to higher buyin tournaments only because of the number of tournaments being run on a daily basis.  Ideally, of course, an application would grab tournament results on its own.  A downgrade, but still better than what we have now, would be a program that grabs the info from a table that is open on the screen.  It would be fine if the program automatically generated an excel file or something like that.  The problem is that I just don’t know how to write such a program.  I’ve tried looking at the packets being sent from stars (using packet sniffer software) and I’m not sure if it is even possible to write such a program.

Do you know how to do this?  Or do you know someone who might know how to do it?

Thanks a lot,

————————-
Nat Arem
aka N 82 50 24
————————-

Only years later do I realize what a noob I sound like.  I had absolutely no idea what I was doing.  Bringing up excel files for storage (LOL) is just a huge joke, but it’s what I understood at the time.  All I knew was that I wanted the data and that once I had the data, I would be able to do cool things with it.  At the time, no one had any idea how much the big tournament players made or even who was really winning in tournaments.  I just didn’t know how to get the data and more importantly, I didn’t have much disposable income to pay someone a lot of money to build a program to get the data.

Lo and behold, I get this response about two hours later:

I don’t know how to do it.  (I just did a little experiment and was surprised by the outcome. I had thought that PS would not email me the results — not the hand history, but the results — of a tournament I was not in.  Wrong.  They will email any tournament’s results to anyone.  That is an essential start.)

Poker Tracker knows how to hit on PS automatically for hand histories for ring game stats, so it might be instructive (or maybe useless!) to try to figure it out.  It requires that the poker room client be running, so it apparently uses some kind of windows application puppet-string manipulation (I am not a Windows guy! :).  If that is in fact the case, then changing that string-pulling to get tournament histories instead of hand histories should be relatively easy.  Certainly easier than doing a direct invasion of the client-server protocol!

You might ask the Poker Tracker folks how they do the automatic hand collection.  Maybe they’ll just tell you.  Alternatively you should ask a Windows god how to sniff the interprocess communication that PT uses to pull the strings on the PS client.  Or maybe the techniques of messing with another app’s menus is well-known?

Moving from the emailed hand histories to a tabular representation of your choice is an exercise in Python, Perl or even C or Java programming.

I don’t know enough to productively help you with the Windows-specific part, but I (and a zillion other people) can help you with the transformation from email tournament results to usable data.

I hope this is helpful to you.

-r

I learned a number of things in that email.  First, I learned that it was pretty hard to actually intercept anything passing back and forth from a poker client and that I might as well give up on that for the time being.  Second, I realized that Richard was right in that I could just use the tournament histories to get the thing built — I hadn’t realized that yet, as dumb as it sounds now.  Third, I started to read up on ways to parse the text data into a database using the regular expressions (Perl) available in php.  I’d never really known about text parsing … I’d just assumed I would use some Excel to MySQL converter, which is obviously really dumb looking back on it.

Of course, it was still a very long road from there.  I did, in fact, email PokerTracker about working on the project with me.  They never responded.  I started getting tournament histories in bulk from PokerStars … at the time, there was no limit to the number of tournament histories that you could request.  I imagine that the activities of myself and some others caused a limit to be put in place later that year.  I then found a business partner who was a php/database expert and he wrote the parser and we took it from there.

But that email from Richard taught me a lot and put me on the right path.  Definitely a huge turning point.

Thanks Richard.

Nat :: May.13.2008 :: General :: No Comments »

[YouTube video used to be here…]

Possibly the best video in the history of YouTube?

Adam Junglen took this video earlier today… I promptly ordered that he go to an electronics store and buy a card reader so he could unload it onto his computer and put it on YouTube.

Well worth it, right?

UPDATE: Jeff made Adam delete it.

Nat :: May.10.2008 :: General :: 5 Comments »

I’ve been a little unhappy with the blog lately. Since the “Website Success” posts that I made, I feel like it’s been a little boring around here — for me and almost certainly for you. I don’t blog just to blog, I do it because I like it and I (think) some people like to read it. So I thought about what I’ve been doing differently and I realized that I haven’t done much picture posting in awhile. Pictures are usually entertaining, so I picked out a few that are relevant to recent happenings in my life.

First of all, here are some pics of my condo here in Costa Rica. It’s a pretty standard 2br/2ba place. But I put a pool table in the living room area because it seems like I never use those types of areas. I know it’s conventional to put a couch and table in there, but I decided that I just don’t care what most people do. I wanted something that I would enjoy and I think people are just as entertained sitting around a pool table in chairs as they are sitting on couches. Of course, I still need more/better chairs, but that’s just a matter of time…

You can also see the kitchen a little bit there. It’s got some pretty nice/modern appliances, so I’m happy with it. I haven’t been doing much cooking lately, but I’d like to start doing more at some point. It’s definitely healthier and I’ve been struggling to eat well lately with all of the eating out. It’s time that I bear down a bit and get back to a home-cooked healthy lifestyle. Since I don’t have any problem with eating healthy when I’m at home, it’s a pretty simple formula… all that being said, it’s just a matter of finding a balance, I love eating out down here. The food in Costa Rica is terrific in my opinion.

Anyway, moving on, here is a picture of the master bedroom. It’s still very plain, but I like the mattress a lot. I’m waiting on a lot of stuff that I want to put in here. The random artwork and stick holder (or whatever it is) came with the place, so I’ve just left them there for now. My new MacBook Pro is on the bed … that’s one of my favorite technology purchases ever. I absolutely love the thing and if it wasn’t for some development reasons, I think I would completely transition away from Windows and only run OS X without even putting Windows on the Mac. As it is, I don’t know if I’ll ever buy any piece of non-Apple laptop/desktop hardware for a long time to come.

So this condo is my new home. One thing that came with moving was that I had to sell a ton of my stuff. It just didn’t make sense to keep things like monitors, TVs, DVD players, gaming systems and all sorts of other stuff that I won’t want whenever I return to the US. I’ll just want to replace all of it then anyway, so I just held a massive sale of goods on craigslist. For the most part, I sold everything that I really wanted to get rid of. However, just recently, I sold the “big ticket” item which represented my last major stateside asset that I couldn’t reasonably keep while living in Costa Rica. My car. A basically brand new Infiniti G37 6MT. It was so sad to sell it… Here it is back in late September / early October when I first bought it.

I really had mixed feelings about selling it. I’d never driven anything like it — it was really an incredible car. But when I was only going to be in the states for a few weeks a year and I was going to be in different spots all of the time, it just didn’t make any sense at all to keep it. Even though I took a sizable four figure loss on the car, I still had to sell it. I hope the guy who bought it takes good care of it and enjoys it. Whenever I return to the US, I hope to get another one or something like it.

So yea, moving to a poorer country means that I had to give up some of my toys. It’s just impossible to drive a car like that here because the roads absolutely tear it up. It would be destroyed very quickly. Not to mention the inevitable bumper benders (driving here is a lot different than in the states) and the near complete lack of support for Infiniti parts, it was just retarded to bring the car down here and take a huge import tax hit. But, I got to keep one of my toys. The prize of my watch collection: my Breitling Super Avenger.

A few years ago, I got really into watches. I love them because you can spend a lot of money on them and enjoy them, but they don’t really lose a ton of value over time. Most of the cost is recoverable if you decide that you want to trade the watch out for a different one. That sort of flexibility isn’t available for a lot of expensive things, so watches make a lot of sense to me. Not to mention that I like wearing nice watches.

Anyway, that concludes the return of the picture post. I’ll try to keep the blog interesting going forward. Anything that people want to see or hear about?

Nat :: May.10.2008 :: General :: 3 Comments »