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.

silverwolf · 08-19-2016, 11:57 AM

Anyone? Am I posting this in the wrong forum?

mchris41 · 08-19-2017, 07:22 AM

I can't tell your if this is a supported configuration or not, but I can tell you that using sql reporting over HTML reporting will save you a lot of space on their web server. I have found that the HTML reports as you get deeper into your league can take up to 3 GB on the server where the SQL dB is only a couple hundred Mb.

08-18-2016, 04:41 PM	#1
silverwolf Minors (Double A) Join Date: Sep 2012 Posts: 186	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.

08-19-2016, 11:57 AM	#2
silverwolf Minors (Double A) Join Date: Sep 2012 Posts: 186	Anyone? Am I posting this in the wrong forum?

08-19-2017, 07:22 AM	#3
mchris41 Bat Boy Join Date: Jul 2016 Posts: 14	I can't tell your if this is a supported configuration or not, but I can tell you that using sql reporting over HTML reporting will save you a lot of space on their web server. I have found that the HTML reports as you get deeper into your league can take up to 3 GB on the server where the SQL dB is only a couple hundred Mb.