What kind of records do you keep?

[BJNewbeeNoMore]

Stealth - I'm impressed. Looking forward to it.

[rits]

Im currently working on a PHP/MySQL site for logging my results. And i thought, why not add a login feature (and buy a weird domain name) so other could use it and suggest improvements.
I have implemented some google chart APIs for some nice graphical information, but maybe not the best...
If you want to register go for it, just username/password no email or anything. Or you can check it out with user/pass demo/demo.
www.blackjackgametracker.com

demo1.JPGdemo2.JPGdemo3.JPGdemo4.JPG

[RS]

^ See, I was thinking the EXACT same thing as that....make a PHP/MySQL site just for myself, or others if they were interested. But it seems whenever I start working on a project, I get super duper busy. =(


Would be nice if you could enter in time of day of the session (either start or end time).

I can't tell yet, but doesn't seem like it...but it'd be cool if you could....how do you say it.....let's say I played a 6D, DAS, RSA, H17, 75% pen, 5 min, 2x50 max at the Circus Circus on June 18, 2013 and I won $800. Let's say I want to enter the exact same info for June 21, 2013, except the only difference is that I won $350 and it was (obviously) on a different date.


It would also be cool if the player could enter in information about the game he played, like EV or other stuff you can get from CVData or CVCX. So say I made $350 on June 18, 2013 [like I said above] over the course of 3 hours, but my EV is $75/hour...then you could chart what your actual result is (what it already does, or what the pictures show) as well as charting your EV.

And if you can link different games together, like having multiple Circus Circus sessions under the same circumstances (rules, decks, spread, etc.), then it makes it all that much better, so you can do something like, say, chart all of your sessions for ONLY Circus Circus.

If you want help or anything like that, let me know, because I can probably help [at least a little bit], since I know a little bit of PHP and MySQL. Not as much as I should,,,,but I still know some.




PS: If anyone cares, I've started using an Excel spreadsheet and I track my wins, losses, rules played, casino, etc. Also have a little formula (that was annoying as f*ck to try to figure out) that shows me how much I'm ahead, how much I've put into my bankroll (ie: Found $100 on the ground so that goes into my BR, or something like that...not counted as a win), and some other info.

[rits]

Thanks for the input Rollingstoned.
Added a option to copy an existing session, so you don't have to enter all information again
Will update with EV charts and "filter by casino" option this weekend, and comment all the code so others will understand the code if you want to help

[RS]

Sweet. I started working on my own, just for fun (and learning).

The way I'm doing it is there'd be a USERS, CASINOS, GAMES, and SESSIONS table. A user can create a casino (location, property owner, etc.) Then for each casino he can create a game (or mutiple games). A "game" is a set of rules and spread, as well as what the EV is for that game. When a user inputs a new session, he chooses which casino it was, then from there it shows which games are at that casino. He puts in win/loss, date, time, length, heat, expenses, and "extra info".

When viewing all sessions/bankroll over time, he can choose either to view all sessions, all sessions from a specific casino, all sessions from a specific property owner (ie: "all stations casinos" or "all MGM properties", whatever), or all sessions of a specific game of a specific casino. Also would be able to specify over a period of dates, etc.

When viewing the sessions played, it would also show how close he is to actual EV.

Of course, that's all stuff that I just have planned right now, and have only begun creating the database schema, forms, etc.