Announcement

Collapse
No announcement yet.

OSFL Stats Issues

Collapse
X
Collapse
 
  • Page of 7
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 3 4 5 6 7 template Next
  • #46
    Originally Posted by elprez98
    Hey Ben. I don't think the past game logs are working. I was trying to look at my past log for NLB vs. Bal, 2010 Div. Playoff and getting an error.

    HERE.........
    The link is the word "here" and it sends me to the address below.

    http://www.gstelmack.com/woof/html/log2010231029.html


    Baltimore Bulldogs - BLB since '84
    - Porter Champs: '92, '93, '97, '98, '01, '03, '06, '08, '12
    - Playoffs: '92, '93, '97, '98, '99, '01, '03, '06, '08, '12, '13, '14, '15, '16
    - Brewmaster's Cup: '01

    Comment

    • #47
      Originally posted by elprez98 View Post
      The link is the word "here" and it sends me to the address below.

      http://www.gstelmack.com/woof/html/log2010231029.html
      That doesn't help me. What page is sending you to that bad link? That's what I need to know.

      Comment

      • #48
        Marquee Matchup Screens

        When I go down to previous matchups between the two teams, I try to look at the game logs and it sends me to the gstelmack address.


        Baltimore Bulldogs - BLB since '84
        - Porter Champs: '92, '93, '97, '98, '01, '03, '06, '08, '12
        - Playoffs: '92, '93, '97, '98, '99, '01, '03, '06, '08, '12, '13, '14, '15, '16
        - Brewmaster's Cup: '01

        Comment

        • #49
          Not sure if this is a know issue... but the first three years appear to be doubled on some players. Here is "The Jiz"

          <TABLE style="BORDER-COLLAPSE: collapse" borderColor=#590418 width="100%" bgColor=#590418 border=3><TBODY><TR><TD><CENTER>PASSING</CENTER></TD></TR></TBODY></TABLE>
          <CENTER><TABLE style="BORDER-COLLAPSE: collapse" borderColor=#590418 cellSpacing=1 cellPadding=1 width="100%" border=3><TBODY><TR><TH bgColor=#8c9899><CENTER>YEAR</CENTER></TD><TH bgColor=#8c9899><CENTER>TEAM</CENTER></TD><TH bgColor=#8c9899><CENTER>G</CENTER></TD><TH bgColor=#8c9899><CENTER>GS</CENTER></TD><TH bgColor=#8c9899><CENTER>CMP</CENTER></TD><TH bgColor=#8c9899><CENTER>ATT</CENTER></TD><TH bgColor=#8c9899><CENTER>CMP%</CENTER></TD><TH bgColor=#8c9899><CENTER>YDS</CENTER></TD><TH bgColor=#8c9899><CENTER>YPA</CENTER></TD><TH bgColor=#8c9899><CENTER>YPC</CENTER></TD><TH bgColor=#8c9899><CENTER>TD</CENTER></TD><TH bgColor=#8c9899><CENTER>INT</CENTER></TD><TH bgColor=#8c9899><CENTER>1DN</CENTER></TD><TH bgColor=#8c9899><CENTER>SKD</CENTER></TD><TH bgColor=#8c9899><CENTER>YDS</CENTER></TD><TH bgColor=#8c9899><CENTER>RTG</CENTER></TD><TH bgColor=#8c9899><CENTER>SCORE</CENTER></TD><TH bgColor=#8c9899><CENTER>RNK</CENTER></TD></TR><TR><TD bgColor=#ffffff><CENTER>2006</CENTER></TD><TD bgColor=#ffffff><CENTER></CENTER></TD><TD bgColor=#ffffff><CENTER>26</CENTER></TD><TD bgColor=#ffffff><CENTER>26</CENTER></TD><TD bgColor=#ffffff><CENTER>456</CENTER></TD><TD bgColor=#ffffff><CENTER>706</CENTER></TD><TD bgColor=#ffffff><CENTER>64.6%</CENTER></TD><TD bgColor=#ffffff><CENTER>4280</CENTER></TD><TD bgColor=#ffffff><CENTER>6.06</CENTER></TD><TD bgColor=#ffffff><CENTER>9.39</CENTER></TD><TD bgColor=#ffffff><CENTER>26</CENTER></TD><TD bgColor=#ffffff><CENTER>14</CENTER></TD><TD bgColor=#ffffff><CENTER>234</CENTER></TD><TD bgColor=#ffffff><CENTER>32</CENTER></TD><TD bgColor=#ffffff><CENTER>198</CENTER></TD><TD bgColor=#ffffff><CENTER>85.2</CENTER></TD><TD bgColor=#ffffff><CENTER>765.7</CENTER></TD><TD bgColor=#ffffff><CENTER>10</CENTER></TD></TR><TR><TD bgColor=#e7e7e7><CENTER>2007</CENTER></TD><TD bgColor=#e7e7e7><CENTER></CENTER></TD><TD bgColor=#e7e7e7><CENTER>32</CENTER></TD><TD bgColor=#e7e7e7><CENTER>32</CENTER></TD><TD bgColor=#e7e7e7><CENTER>650</CENTER></TD><TD bgColor=#e7e7e7><CENTER>1094</CENTER></TD><TD bgColor=#e7e7e7><CENTER>59.4%</CENTER></TD><TD bgColor=#e7e7e7><CENTER>6610</CENTER></TD><TD bgColor=#e7e7e7><CENTER>6.04</CENTER></TD><TD bgColor=#e7e7e7><CENTER>10.17</CENTER></TD><TD bgColor=#e7e7e7><CENTER>30</CENTER></TD><TD bgColor=#e7e7e7><CENTER>28</CENTER></TD><TD bgColor=#e7e7e7><CENTER>348</CENTER></TD><TD bgColor=#e7e7e7><CENTER>60</CENTER></TD><TD bgColor=#e7e7e7><CENTER>370</CENTER></TD><TD bgColor=#e7e7e7><CENTER>75.2</CENTER></TD><TD bgColor=#e7e7e7><CENTER>800.3</CENTER></TD><TD bgColor=#e7e7e7><CENTER>12</CENTER></TD></TR><TR><TD bgColor=#ffffff><CENTER>2008</CENTER></TD><TD bgColor=#ffffff><CENTER></CENTER></TD><TD bgColor=#ffffff><CENTER>32</CENTER></TD><TD bgColor=#ffffff><CENTER>32</CENTER></TD><TD bgColor=#ffffff><CENTER>676</CENTER></TD><TD bgColor=#ffffff><CENTER>1110</CENTER></TD><TD bgColor=#ffffff><CENTER>60.9%</CENTER></TD><TD bgColor=#ffffff><CENTER>6980</CENTER></TD><TD bgColor=#ffffff><CENTER>6.29</CENTER></TD><TD bgColor=#ffffff><CENTER>10.33</CENTER></TD><TD bgColor=#ffffff><CENTER>36</CENTER></TD><TD bgColor=#ffffff><CENTER>24</CENTER></TD><TD bgColor=#ffffff><CENTER>380</CENTER></TD><TD bgColor=#ffffff><CENTER>42</CENTER></TD><TD bgColor=#ffffff><CENTER>276</CENTER></TD><TD bgColor=#ffffff><CENTER>80.8</CENTER></TD><TD bgColor=#ffffff><CENTER>1,213.8</CENTER></TD><TD bgColor=#ffffff><CENTER>8</CENTER></TD></TR></TBODY></TABLE></CENTER>
          The Great One!

          Too many rings to count.

          Comment

          • #50
            Originally posted by Clay View Post
            Not sure if this is a know issue... but the first three years appear to be doubled on some players. Here is "The Jiz"

            <table style="border-collapse: collapse;" width="100%" bgcolor="#590418" border="3" bordercolor="#590418"><tbody><tr><td><center>PASSING</center></td></tr></tbody></table>
            <center><table style="border-collapse: collapse;" width="100%" border="3" bordercolor="#590418" cellpadding="1" cellspacing="1"><tbody><tr><th bgcolor="#8c9899"><center>YEAR</center></th><th bgcolor="#8c9899"><center>TEAM</center></th><th bgcolor="#8c9899"><center>G</center></th><th bgcolor="#8c9899"><center>GS</center></th><th bgcolor="#8c9899"><center>CMP</center></th><th bgcolor="#8c9899"><center>ATT</center></th><th bgcolor="#8c9899"><center>CMP%</center></th><th bgcolor="#8c9899"><center>YDS</center></th><th bgcolor="#8c9899"><center>YPA</center></th><th bgcolor="#8c9899"><center>YPC</center></th><th bgcolor="#8c9899"><center>TD</center></th><th bgcolor="#8c9899"><center>INT</center></th><th bgcolor="#8c9899"><center>1DN</center></th><th bgcolor="#8c9899"><center>SKD</center></th><th bgcolor="#8c9899"><center>YDS</center></th><th bgcolor="#8c9899"><center>RTG</center></th><th bgcolor="#8c9899"><center>SCORE</center></th><th bgcolor="#8c9899"><center>RNK</center></th></tr><tr><td bgcolor="#ffffff"><center>2006</center></td><td bgcolor="#ffffff"><center></center></td><td bgcolor="#ffffff"><center>26</center></td><td bgcolor="#ffffff"><center>26</center></td><td bgcolor="#ffffff"><center>456</center></td><td bgcolor="#ffffff"><center>706</center></td><td bgcolor="#ffffff"><center>64.6%</center></td><td bgcolor="#ffffff"><center>4280</center></td><td bgcolor="#ffffff"><center>6.06</center></td><td bgcolor="#ffffff"><center>9.39</center></td><td bgcolor="#ffffff"><center>26</center></td><td bgcolor="#ffffff"><center>14</center></td><td bgcolor="#ffffff"><center>234</center></td><td bgcolor="#ffffff"><center>32</center></td><td bgcolor="#ffffff"><center>198</center></td><td bgcolor="#ffffff"><center>85.2</center></td><td bgcolor="#ffffff"><center>765.7</center></td><td bgcolor="#ffffff"><center>10</center></td></tr><tr><td bgcolor="#e7e7e7"><center>2007</center></td><td bgcolor="#e7e7e7"><center></center></td><td bgcolor="#e7e7e7"><center>32</center></td><td bgcolor="#e7e7e7"><center>32</center></td><td bgcolor="#e7e7e7"><center>650</center></td><td bgcolor="#e7e7e7"><center>1094</center></td><td bgcolor="#e7e7e7"><center>59.4%</center></td><td bgcolor="#e7e7e7"><center>6610</center></td><td bgcolor="#e7e7e7"><center>6.04</center></td><td bgcolor="#e7e7e7"><center>10.17</center></td><td bgcolor="#e7e7e7"><center>30</center></td><td bgcolor="#e7e7e7"><center>28</center></td><td bgcolor="#e7e7e7"><center>348</center></td><td bgcolor="#e7e7e7"><center>60</center></td><td bgcolor="#e7e7e7"><center>370</center></td><td bgcolor="#e7e7e7"><center>75.2</center></td><td bgcolor="#e7e7e7"><center>800.3</center></td><td bgcolor="#e7e7e7"><center>12</center></td></tr><tr><td bgcolor="#ffffff"><center>2008</center></td><td bgcolor="#ffffff"><center></center></td><td bgcolor="#ffffff"><center>32</center></td><td bgcolor="#ffffff"><center>32</center></td><td bgcolor="#ffffff"><center>676</center></td><td bgcolor="#ffffff"><center>1110</center></td><td bgcolor="#ffffff"><center>60.9%</center></td><td bgcolor="#ffffff"><center>6980</center></td><td bgcolor="#ffffff"><center>6.29</center></td><td bgcolor="#ffffff"><center>10.33</center></td><td bgcolor="#ffffff"><center>36</center></td><td bgcolor="#ffffff"><center>24</center></td><td bgcolor="#ffffff"><center>380</center></td><td bgcolor="#ffffff"><center>42</center></td><td bgcolor="#ffffff"><center>276</center></td><td bgcolor="#ffffff"><center>80.8</center></td><td bgcolor="#ffffff"><center>1,213.8</center></td><td bgcolor="#ffffff"><center>8</center></td></tr></tbody></table></center>
            That's actually an issue that I think is server-related. After each game, we run a script that puts the stats into a custom table. It usually takes only 20-30 seconds, but it's taking much longer in this league, and sometimes even timing out. I'm guessing that Aaron ran it, but it was taking long, and then I ran it too. It ended up writing two lines for the players that hadn't processed yet. I'm re-running it right now. (It clears out the table and then rewrites it.) So it should be fixed in the next 20-30 minutes or so. It only takes 15-20 seconds when I run it from my server on other leagues. I'll probably just move it other there and see if it gets faster.

            Comment

            • #51
              He's fixed now (lower player ids process first). Others may be a while longer.

              Comment

              • #52
                I'm hoping to have us moved over to our new server within the next 3 weeks so hopefully that helps. I'm guessing there's also a performance hit from having the database on a remote server.

                Comment

                • #53
                  Originally posted by Andrew View Post
                  I'm hoping to have us moved over to our new server within the next 3 weeks so hopefully that helps. I'm guessing there's also a performance hit from having the database on a remote server.
                  Could well be. Will the new server have remote access ability?

                  Comment

                  • #54
                    Originally posted by Ben E Lou View Post
                    Could well be. Will the new server have remote access ability?
                    Yes, it should. Might make sense to move the DB over when we re-locate. I'll keep you in the loop.

                    Comment

                    • #55
                      Big problem with the 2006-2008 stats. Check out Heflin's stats:


                      http://www.simgamingnetwork.com/osfl...?playerid=1150

                      Comment

                      • #56
                        Originally posted by aholbert View Post
                        Big problem with the 2006-2008 stats. Check out Heflin's stats:


                        http://www.simgamingnetwork.com/osfl...?playerid=1150
                        This happened once before. I think Ben can fix it real easy.
                        The Great One!

                        Too many rings to count.

                        Comment

                        • #57
                          So can Aaron. If you ever see that, just wait a bit and re-run the write stats script.

                          Comment

                          • #58
                            Originally posted by Ben E Lou View Post
                            So can Aaron. If you ever see that, just wait a bit and re-run the write stats script.
                            Thanks Ben. Good to know.

                            Comment

                            • #59
                              http://www.simgamingnetwork.com/osfl/ben/drafthistory.php

                              Draft history page is acting up.


                              Baltimore Bulldogs - BLB since '84
                              - Porter Champs: '92, '93, '97, '98, '01, '03, '06, '08, '12
                              - Playoffs: '92, '93, '97, '98, '99, '01, '03, '06, '08, '12, '13, '14, '15, '16
                              - Brewmaster's Cup: '01

                              Comment

                              • #60
                                Got some doubled stats again:

                                http://www.simgamingnetwork.com/osfl...p?playerid=716

                                I know this is a simple fix.
                                The Great One!

                                Too many rings to count.

                                Comment

                                Previous 1 2 3 4 5 6 7 template Next
                                Working...
                                X