DATABASE: New Ideas Thread

[Guest]

Yup. That was it. And yup, it's displaying twice. I'll need to think through the best way to avoid that annoying issue without breaking something else in the code.

[bmerryman]

I don't see a way to see more than the top 10 in the almanac /record book section. As the league matures, it would be nice to keep tabs on active players that are climbing the ladder. Certainly not a big deal since it's something I can do within the game itself but might be a nice add-on.

Also, under the fumbles section, I've always thought it would be nice to see who had/has the LEAST fumbles per touches. You'd have to have a qualifying number of touches but that would be an interesting, and for me, more meaningful stat.

[Guest]

I don't see a way to see more than the top 10 in the almanac /record book section. As the league matures, it would be nice to keep tabs on active players that are climbing the ladder. Certainly not a big deal since it's something I can do within the game itself but might be a nice add-on.

Heh. I built that a couple of days ago for WOOF, and I'm planning on porting it over here this weekend.
http://www.younglifenorthdekalb.com/...bookcareer.php
(Click on any category to see the top 100 in that category.)

Also, under the fumbles section, I've always thought it would be nice to see who had/has the LEAST fumbles per touches. You'd have to have a qualifying number of touches but that would be an interesting, and for me, more meaningful stat.

Good idea. Easy to do in terms of pulling the stats. A bit of a pain in terms of making it look right on that page. I'll put it on the list.

[Guest]

Milestone implementation is set up on the home page now. The league is too young to have many, though. Here's how it looks in a league that has moved more quickly. (WOOF is three games per week.

MILESTONE WATCH: http://www.younglifenorthdekalb.com/.../milestone.php
MILESTONES REACHED: http://www.younglifenorthdekalb.com/...nebreakers.php

[bmerryman]

Milestone implementation is set up on the home page now. The league is too young to have many, though. Here's how it looks in a league that has moved more quickly. (WOOF is three games per week.

MILESTONE WATCH: http://www.younglifenorthdekalb.com/.../milestone.php
MILESTONES REACHED: http://www.younglifenorthdekalb.com/...nebreakers.php

I really like that addition because FOF doesn't provide any of that type of push info.

[Guest]

Oh. Here are the Milestones:

<table border="1" cellpadding="0" cellspacing="1"><tbody><tr><th>id</th> <th>name</th> <th>milestone</th> <th>close</th> <th>title</th></tr> <tr> <td>1</td> <td>passyards</td> <td>40000</td> <td>1000</td> <td>Passing Yards</td></tr> <tr> <td>2</td> <td>passyards</td> <td>50000</td> <td>1000</td> <td>Passing Yards</td></tr> <tr> <td>3</td> <td>passyards</td> <td>60000</td> <td>1000</td> <td>Passing Yards</td></tr> <tr> <td>4</td> <td>tdpasses</td> <td>300</td> <td>12</td> <td>TD Passes</td></tr> <tr> <td>5</td> <td>tdpasses</td> <td>400</td> <td>12</td> <td>TD Passes</td></tr> <tr> <td>6</td> <td>tdpasses</td> <td>500</td> <td>12</td> <td>TD Passes</td></tr> <tr> <td>7</td> <td>rushingyards</td> <td>10000</td> <td>500</td> <td>Rushing Yards</td></tr> <tr> <td>8</td> <td>rushingyards</td> <td>15000</td> <td>500</td> <td>Rushing Yards</td></tr> <tr> <td>9</td> <td>rushtd</td> <td>100</td> <td>10</td> <td>Rushing TDs</td></tr> <tr> <td>10</td> <td>receivingyards</td> <td>10000</td> <td>500</td> <td>Receiving Yards</td></tr> <tr> <td>11</td> <td>receivingyards</td> <td>15000</td> <td>500</td> <td>Receiving Yards</td></tr> <tr> <td>12</td> <td>receivingtds</td> <td>100</td> <td>10</td> <td>Receiving TDs</td></tr> <tr> <td>13</td> <td>tackles</td> <td>1000</td> <td>50</td> <td>Tackles</td></tr> <tr> <td>14</td> <td>tackles</td> <td>1500</td> <td>50</td> <td>Tackles</td></tr> <tr> <td>15</td> <td>sacks</td> <td>100</td> <td>10</td> <td>Sacks</td></tr> <tr> <td>16</td> <td>sacks</td> <td>150</td> <td>10</td> <td>Sacks</td></tr> <tr> <td>17</td> <td>sacks</td> <td>200</td> <td>10</td> <td>Sacks</td></tr> <tr> <td>18</td> <td>ints</td> <td>50</td> <td>5</td> <td>Interceptions</td></tr> <tr> <td>19</td> <td>points</td> <td>1000</td> <td>50</td> <td>Points</td></tr> <tr> <td>20</td> <td>points</td> <td>1500</td> <td>50</td> <td>Points</td></tr> <tr> <td>21</td> <td>points</td> <td>2000</td> <td>50</td> <td>Points</td></tr></tbody></table>

[bmerryman]

So, on average, a player appears on the watch list about 8-16 games prior to eclipsing the Milestone.

[Guest]

So, on average, a player appears on the watch list about 8-16 games prior to eclipsing the Milestone.

It'll vary, and it will heavily depend on whether the player is still in his prime, but overall I think it's less than that. For example, an aging WR approaching 10,000 yards might only be getting 50-80 yards per game, so he'd be on the list 6-10 weeks. But a WR in his prime approaching that milestone might only be there for 3 weeks. My general goal was to show when a guy was 3-4 very good games away from a milestone. It's easy to see a QB getting 1,000 yards in three weeks, for example.

If people feel like they want them on the list longer than that, it's easy to change that.

[bmerryman]

Yes. I noticed that after I posted. The Rushing/Receiving TDs, Sacks, and INTs will in most cases take longer. Are you thinking about adding anything else?
Yards from scrimmage
All purpose
Streaks

[Guest]

I don't see a way to see more than the top 10 in the almanac /record book section. As the league matures, it would be nice to keep tabs on active players that are climbing the ladder. Certainly not a big deal since it's something I can do within the game itself but might be a nice add-on.

This is now implemented.

http://www.simgamingnetwork.com/osfl/ben/recordbookcareer.php

Click on any stats category to see the top 100.

[Lintyfresh85]

I'd just like to point out... you might want to fix the sack stats... they're reading as 750 instead of 75.0

http://www.simgamingnetwork.com/osfl...p?record=sacks

[Guest]

I'd just like to point out... you might want to fix the sack stats... they're reading as 750 instead of 75.0

http://www.simgamingnetwork.com/osfl...p?record=sacks

Please put fixes in the fix thread. I check that more often. I just happened to be in this thread shortly after you posted. I don't check this one every day.

[Clay]

Would it be possible for a RETIRED player to appear differently on like Leaderboards? Maybe italics, an asterisk or with a (R) or something? Just a thought.

[bmerryman]

Is there any way to pull seasonal average starting field position from the database? I know the stock html game summary shows it but I've often wondered how I am doing on a seasonal basis.

[Guest]

Is there any way to pull seasonal average starting field position from the database? I know the stock html game summary shows it but I've often wondered how I am doing on a seasonal basis.

No time soon. That's only in the pbp data. There's a long-term project underway to get the pbp data via DBUpdater. Once that is completed, I could do that. Until then, though, it can't happen.

As for retired players, I have them italicized on one of the career reports and its child reports:

http://www.simgamingnetwork.com/osfl...bookcareer.php

(Note the FG leader.) The main issue in this league is that we don't move quickly enough for many of our leaders to be retired.