I've successfully set up PHP and MySQL and have populated a database using DBUpdater. Thanks, Ben, for the information on this.
The next hurdle of coure is making use of all of this. One of the first things I tried to do was to generate a basic page containing the standings. However, I don't see any useful tables in the database for doing this.
fof_franchise has just the right columns, but doesn't appear to be updated until the end of the season.
fof_teamschedule can derive the information, but the query is pretty large and messy.
Any tips?Your best bet is to do it from fof_teamschedule for the current season. Here's a basic one, run on my IHOF database. (The league is between weeks 4 and 5 of 2019 right now.)
SELECT
cityname,
sum(score>oppscore) AS wins,
sum(oppscore>score) AS losses,
sum(score=oppscore) AS ties,
FROM fof_teamschedule s
JOIN fof_teams t ON t.id = s.teamid
WHERE year=2019 AND week>5 AND week < 23 AND (score>0 OR oppscore>0)
GROUP BY teamid
ORDER BY conference, division, wins DESC, cityname
This returns...
<table border="1" cellpadding="0" cellspacing="1"><tbody> <tr> <th>cityname</th> <th>wins</th> <th>losses</th> <th>ties</th> </tr> <tr> <td>Syracuse</td> <td>4</td> <td>0</td> <td>0</td> </tr> <tr> <td>Boston</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Rochester</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>North Plainfield</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Houston</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Fort Worth</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Vicksburg</td> <td>1</td> <td>2</td> <td>0</td> </tr> <tr> <td>San Antonio</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Georgia</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Orlando</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Tucker</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Conyers</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Gothenburg</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Maassluis</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Bordeaux</td> <td>1</td> <td>2</td> <td>0</td> </tr> <tr> <td>Paris</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Minnesota</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Muscatine</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Michigan</td> <td>1</td> <td>2</td> <td>0</td> </tr> <tr> <td>Chicago</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Asheville</td> <td>4</td> <td>0</td> <td>0</td> </tr> <tr> <td>Miami</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Outer Banks</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Knoxville</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Frederick</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Williamsburg</td> <td>3</td> <td>1</td> <td>0</td> </tr> <tr> <td>Chesapeake</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Brooklyn</td> <td>1</td> <td>2</td> <td>0</td> </tr> <tr> <td>Albuquerque</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Oakland</td> <td>2</td> <td>2</td> <td>0</td> </tr> <tr> <td>Boulder</td> <td>1</td> <td>3</td> <td>0</td> </tr> <tr> <td>Fairbanks</td> <td>0</td> <td>4</td> <td>0</td> </tr></tbody></table>
Note that I'm excluding games in which both teams don't score. It's the easiest way I could think of to keep all the unplayed games in a season from showing up as ties. You *could* pull the current stage from fof_gameinfo and compare it. That's more clean, but it's also more work. As long as there are no scoreless ties (and I've never seen one in any of my SP or MP leagues), this way of doing it works just fine. ;)
With a bit of formatting and the addition of some more stuff to the query, you can eventually get the following data all from that table:
STANDINGS (http://www.younglifenorthdekalb.com/woof/ben/standings.php)