drneau.com

drneau · Posted: Tue Jun 03, 2008 8:51 pm Post subject: Player information presentation

I'm going back and forth on how to best do this.

Implementing the standard tournament.
There are a LOT of parameters that I'll be making available for a tournament player, including (ready)?
- AddOnCount (total)
- AddOnCount per AddInOption
- AddOnExpense
- BountyExpense
- BountyNetGain
- BountyRevenue
- BuyInCount
- BuyInExpense
- BuyInOption (which one did they buy?)
- ChipCount
- Finish
- HasBeenPaid
- HasPaid
- KnockoutCount
- ManualPoints
- MethodPoints
- NumberInSpot (are they tied with anyone)
- PlaceRevenue
- Present
- PrimaryExpense
- PrimaryNetGain
- PrimaryRevenue
- RebuyCount (overall)
- RebuyCount (per rebuy option)
- RebuyExpense
- Seated
- SeatNumber
- SecondaryExpense
- SecondaryRevenue
- SecondaryNetGain
- SideBetExpense
- SideBetNetGain
- SideBetRevenue
- TableName
- TextAward
- TotalExpense
- TotalNetGain
- TotalRevenue
- State
- Address1
- Address2
- Age
- Audio
- Birthday
- City
- County
- DisplayName
- DisplayNamePattern
- Email
- FirstName
- FullName
- ID
- Image
- LastName
- NickName
- Phone1Number
- Phone1Type
- Phone2Number
- Phone2Type
- Phone3Number
- Phone3Type
- Phone4Number
- Phone4Type
- State
- ZipPostalCode

Whew...there may be more than that, but anyway...

In v2, I had all info about a player in one table and you had the ability to select sets of columns to view.

I was starting to go down that route, but then decided one mega table might not be the way to go...

So instead, I was thinking of having multiple tables, each with a different purpose.

- The Roster: This panel's goal is to populate the roster and show you everyone's state. The lower half of the panel will be the player database the the upper half will be the roster. Both will be visible. Adding players to the roster from the database will be as simple as clicking the "Add" button, and removing will be as simple as the "remove". Actions available here will be: Create New Player, Add From DB, Remove From Roster, Edit Properties, Buy-In, Add-On, Rebuy, Eliminate, Select All, Seat, UnSeat. Detailed financial information will not be shown. Add-on and Rebuy Counts will be displayed in the table, then if you want detail you can either look at the player properties or look at...

- Player Financial Data: This will be all the detailed financial data in table form. Only roster players will be visible.

- Ranking/Standings: blah blah blah

Thoughts?
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau

MaxPower · Posted: Wed Jun 04, 2008 6:17 am Post subject:

I like what I've seen so far in the V3 player database - the fact that you can add personalized sounds and avatars is outstanding! The idea of having one large table might get unweilding, but might help out processing speed (i dunno, I'm not a DB expert here).

Another thing may be that I'd like to have all that info in one place, in case I get the itch to customize the data to integrate easily in a web site...

What does one mega table with multiple views not buy you that multiple tables do?

One thing I was thinking about, many people have multiple emails, much like phone numbers (one for work, one for home, one for porn sites), so maybe have the ability to add multiple (no more than two>) email addresses?

Here's one more thing - The avatars - can they be integrated in the Seating Chart overlay? That way, a people can look for either their name or their face.... Just an idea...

Max
Laying under the table and dreaming...
_________________
Oh, Yeah! Check out the all new TheMiddleClassBlog.com for all of us that aren't exactly "High Rollers"!

drneau · Posted: Wed Jun 04, 2008 6:37 am Post subject:

drneau · Posted: Thu Jun 05, 2008 6:13 am Post subject:

Figured out a better way to handle the table in code so that it isn't so overwhelming, and actually easy to add new attributes.

I'm thinking it'll turn into something like Outlook where you have your Inbox and you can apply views and filters.

I'll have many views/filters predefined for quick change between them

And *maybe* give you the ability to save multiple views of your own, but don't get too excited.
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau

drneau · Posted: Thu Jun 05, 2008 12:06 pm Post subject:

http://drneau.com/BB/viewtopic.php?t=1334
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau