Author Topic: PhillyArena Site development  (Read 11424 times)

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
PhillyArena Site development
« on: March 23, 2009, 06:40:50 PM »
I mentioned a while back that I had started up phillyarena again, and to this point it's just been just a blog.  I've been working on site development of it, as I like to do a lot of statistical data.  Recently I've been working on a lot of the backend scripts to parse boxscore output and put it in my own database, and now I"m beginning to start doing some stuff with the data.

The first part is a "team stats" section where you basically select a player, and select a condition, and it will give you the teams record and stats for when that condition is met, and compare that to when that condition is not met.

http://nba.phillyarena.com/teamstats.php

So, if you select Elton Brand, select "Plays/Doesn't play", it will give you the split of team stats (NOTE: team stats, not play) of when he does play vs when he doesn't play.  Similarly, if you want to see the Sixers record and stats for when Thad makes more than 2 three pointers in a game, you can do so.  Or when Louis Williams plays more than 25 minutes.

Right now you can't search on team results (say, when the Sixers as a team make > 7 three pointers), but that will be coming in the next day or so.  Similarly, right now you can "show game log" and view a game log of the team stats when these conditions are met, but you can't view the players game log.  That as well will be coming shortly.

Right now it's fairly rudimentary, and it's going to change fairly drastically (with new additions and style changes), but feel free to use it if you wish.  Please let me know if anyone has any changes/suggestions/bugs.
« Last Edit: March 23, 2009, 06:49:17 PM by Derek Bodner »

Offline tk76-

  • Hero Member
  • *****
  • Posts: 1426
  • 2Y1- Sixer's 'Logo'
    • View Profile
Re: PhillyArena Site development
« Reply #1 on: March 23, 2009, 06:52:54 PM »
Cool.  So the Sixers are 14-4 when Speights plays 20 or more minutes...

I assume all of the stats are team stats and not stats for the individual?

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #2 on: March 23, 2009, 06:56:48 PM »
Quote
I assume all of the stats are team stats and not stats for the individual?

Correct.

I'll modify that to include the date played and link to the boxscore rather than just the team.

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #3 on: March 24, 2009, 03:37:06 PM »
Added in searchable team stats.

For example, the Sixers are 14-4 when they make 6 three's or more:
http://nba.phillyarena.com/teamstats.php?type=playerstat&playerid=sixers&field=threeptm&operator=greaterequal&inputvalue=6

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #4 on: March 24, 2009, 05:58:34 PM »
Queries are now saved, so you can find get easy-to-use links to link to.

i.e.:
http://nba.phillyarena.com/teamstats/savedquery/16/

Offline tk76

  • Newbie
  • *
  • Posts: 34
    • View Profile
Re: PhillyArena Site development
« Reply #5 on: March 24, 2009, 10:54:00 PM »
Works great.  Thanks for the work.

Easy to find things like:  Sixers are 20-7 when they shoot 34% or better from 3.

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #6 on: April 12, 2009, 09:39:15 AM »
New, fairly minor feature.

Stats (team and player) for last X games:
http://nba.phillyarena.com/last/

(defaults to 5).

so, the stats from the 6 games Thad has been out for:
http://nba.phillyarena.com/last/?last=6

For the last 10:
http://nba.phillyarena.com/last/?last=10

Etc.

(the team stats then compare to the games prior to the last 10).

Lou Will putting up 16.8 ppg during his last 4 in only 26 minutes is impressive.  He's even hitting some three's (1.3 per game at 43.3%)
« Last Edit: April 12, 2009, 10:27:32 AM by Derek Bodner »

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #7 on: April 13, 2009, 09:07:08 PM »
A few more minor things.

There are now pages up there with information on specific opponents:
Example:
http://nba.phillyarena.com/teams/bos/

Has the previous results for games against Boston, what upcoming games are left, how the team has performed against boston this year, as well as how individual players have done against boston, and how boston's players have done against us.

(We don't have a single player averaging more than 15 points per game against boston.  just sad).

I've also added the schedule:
http://nba.phillyarena.com/schedule/

And crazy things, like boxscores:
http://nba.phillyarena.com/games/2008-11-28/boxscore/

(for some reason I had forgotten to actually display the boxscores, even if I was using them in calculations).

As most other portions of the site, the displays will probably change heavily.

Offline PhilasFinest

  • Newbie
  • *
  • Posts: 34
    • View Profile
Re: PhillyArena Site development
« Reply #8 on: June 22, 2009, 05:01:41 PM »
nice work with the site DB...truly some interestng and helpful stats youve accumalated

Offline rickortreat

  • Hero Member
  • *****
  • Posts: 2056
    • View Profile
    • Email
Re: PhillyArena Site development
« Reply #9 on: October 05, 2009, 09:57:22 AM »
This work will be very useful if we can compare last season with the upcoming one.  Specifically I'll be looking for greater offensive efficiency against good teams (like Boston) who make it hard for the Sixers to score. This is where Eddie Jordan's influence should be significant, and proof that the team is moving in the right direction (or not).

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #10 on: November 08, 2009, 07:21:20 PM »
advanced stats game log:
http://nba.phillyarena.com/gamelog/advanced/

(eFG%, offreb and ftrate, to%.  Dean Oliver's Four Factors)
« Last Edit: November 08, 2009, 09:46:04 PM by Derek Bodner »

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #11 on: November 10, 2009, 10:31:40 PM »
Added Salary information:
http://nba.phillyarena.com/salary/

Right now it's no frills, just the Sixers salary information. In short order I plan on adding features, such as estimated draft pick cost added in each year, the total on the bottom to include the minimum amount guaranteed (i.e. all options declined/not picked up), as well as minimum # guaranteed that the sixers control (i.e. only removing what the Sixers can remove themselves, and keeping in player options for the total)

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #12 on: January 04, 2010, 10:32:03 PM »
Rotational data is now up-to-date again:
http://nba.phillyarena.com/rotations/

Offline Derek Bodner

  • Administrator
  • Hero Member
  • *****
  • Posts: 3040
    • AOL Instant Messenger - dbodner22
    • Yahoo Instant Messenger - dabodz
    • View Profile
    • http://www.phillyarena.com
    • Email
Re: PhillyArena Site development
« Reply #13 on: January 08, 2010, 04:24:03 PM »
A couple of minor updates.

I added TS% and eFG% to the boxscores:
http://nba.phillyarena.com/games/2010-01-05/boxscore/

Also, now the main rotations page (before you searched) will show you each unique rotation used, and the pts they've scored, pts the opponents have scored, the overall time the unit has been on the floor, and the per 48 minute averages of all of those.  sorted by time on the floor.

http://nba.phillyarena.com/rotations/

(for those curious, Eddie Jordan has used 295 unique lineups through 34 games)

Offline Reality

  • Hero Member
  • *****
  • Posts: 8738
    • View Profile
    • Email
Re: PhillyArena Site development
« Reply #14 on: January 20, 2010, 12:13:18 PM »
Dabods,
can you direct me to a site that will give similar stats for Spurs?  At least some of them.
Specifically i want to find out how the Spurs stats are with Blair and Duncan on the floor together.