OOTP Developments Forums - View Single Post - Real-Time Sim Box Scores and Reports in SQL

silverwolf · 08-18-2016, 04:41 PM

For an online league using the option to store reports on the server in SQL format, is there a way for real-time sims to ever show box scores?

What I see for actual OOTP behavior during the sim is:

- Periodically upload HTML for the sim
- Also upload HTML box scores to a box_scores directory

But because the reports are in SQL, and use .htaccess and a PHP file to query the HTML from the database, when you click on the link in the real-time sim page for the box score, you get a blank page. Same question for real-time game logs.

Is this just not a supported configuration?

By the way, what's the point of storing the reports in SQL? My instinct says it's way more load on a web server to execute PHP which does an SQL query to get some static HTML than it is to just store the HTML files on the server.

08-18-2016, 04:41 PM	#1
silverwolf Minors (Double A) Join Date: Sep 2012 Posts: 187	Real-Time Sim Box Scores and Reports in SQL For an online league using the option to store reports on the server in SQL format, is there a way for real-time sims to ever show box scores? What I see for actual OOTP behavior during the sim is: - Periodically upload HTML for the sim - Also upload HTML box scores to a box_scores directory But because the reports are in SQL, and use .htaccess and a PHP file to query the HTML from the database, when you click on the link in the real-time sim page for the box score, you get a blank page. Same question for real-time game logs. Is this just not a supported configuration? By the way, what's the point of storing the reports in SQL? My instinct says it's way more load on a web server to execute PHP which does an SQL query to get some static HTML than it is to just store the HTML files on the server.