Improved online scripts for reports

[Andreas Raht]

I improved the PHP scripts which unpack the report files to the MySQL database. They unpack it to multiple tables now and they also update only records where the report data has changed. That should help to reduce problems with huge report databases.

All you need to do is:

• delete the existing reports table from the MySQL database on your web server
• unzip and copy the attached scripts to the /online_scripts folder on your computer, replacing the original script files index.php and unpackreports.php
• Have fun!

On the first run it will create the tables and import all reports. On all following runs it will only update records where the report content changed.
Obviously there will always be changes on each report page because there's a timestamp at the bottom of each page. To get rid of the timestamp, remove the [%VERSION] token from the page_bottom_line.tpl template (you'll find the template files inside the folder /templates).


Please give us some feedback here. Thanks!

[Recte44]

I've always found this method very confusing and difficult to setup. Is it really that hard? Why can't I figure it out?

[strzepeksc]

fails to work

[Andreas Raht]

Originally Posted by strzepeksc

fails to work

Works for me. Could you give some more information please? Did you use the old scripts and did they work?

[Andreas Raht]

Originally Posted by Recte44

I've always found this method very confusing and difficult to setup. Is it really that hard? Why can't I figure it out?

Yes, it is. You have to setup a MySQL database and you have to enter the correct connection info on the dialog in OOTP. If one of the several things you need to do is not 100% correct, then it will fail. For admins, programmers or just talented DIY guys it will work. But it's not trivial.

[captaincoop17]

Does this speed up the time it takes to generate all the reports? Or does this just speed up the upload process?

[Andreas Raht]

Originally Posted by captaincoop17

Does this speed up the time it takes to generate all the reports? Or does this just speed up the upload process?

Report creation speed and upload speed is the same, but the number of files on the server is almost zero instead of some 10,000 files.

[captaincoop17]

I've managed to get the new scripts installed, but removing the timestamp is causing an error in OOTP?

Can you post the page_bottom_line.tpl template file as well?

[byzeil]

The new scripts seem to be working as advertised.

But I am noticing something, and not sure if it was happening before, but some player pages seem to be getting cut off at the bottom. I'm seeing many players cut off and many not.

You can go to this team page and select different players and you should see what I am talking about. Check the first 2 pitchers, Rivera (not cut off) and Blackburn (cut off). On pitcher Ocura only the final link to the OOTPD site is cut off.

Also, there is a league date at the top of each page, in the header I guess, won't that cause all generated pages to be different even though the report may not have changed?

[Andreas Raht]

Originally Posted by byzeil

The new scripts seem to be working as advertised.

But I am noticing something, and not sure if it was happening before, but some player pages seem to be getting cut off at the bottom. I'm seeing many players cut off and many not.

You can go to this team page and select different players and you should see what I am talking about. Check the first 2 pitchers, Rivera (not cut off) and Blackburn (cut off). On pitcher Ocura only the final link to the OOTPD site is cut off.

Also, there is a league date at the top of each page, in the header I guess, won't that cause all generated pages to be different even though the report may not have changed?

Thank you! Yes, you're right, there was a bug in the unpack script. I updated the attachment in the opening post with the new script. Please download, unpack and copy to your server. Then delete the report tables from the database (important!) and import the reports again.

Yes, the league date will have to be removed from the header, too. Edit the templates which names start with "page_header_" and remove the line that contains the [%Date], for example:

PHP Code:

<div style="text-align:center; color:#FFFFFF; padding-top:4px;">[%DATE]</div> 


[Andreas Raht]

Originally Posted by captaincoop17

I've managed to get the new scripts installed, but removing the timestamp is causing an error in OOTP?

Can you post the page_bottom_line.tpl template file as well?

This is the original page_bottom_line.tpl:

PHP Code:

<!-- OOTP IGNORE START PAGE BOTTOM --><table cellspacing="0" cellpadding="0" align="center" width="968px">    <tr>        <td style="padding-top:10px; font-size:11px; text-align:center;">            [%POWERED_BY]        </td>    </tr>    <tr>        <td style="padding-top:2px; font-size:11px; text-align:center;">            [%VERSION]        </td>    </tr>    </table><!-- OOTP IGNORE END PAGE BOTTOM --> 


Remove the [%VERSION] This is the edited template:

PHP Code:

<!-- OOTP IGNORE START PAGE BOTTOM --><table cellspacing="0" cellpadding="0" align="center" width="968px">    <tr>        <td style="padding-top:10px; font-size:11px; text-align:center;">            [%POWERED_BY]        </td>    </tr>    <tr>        <td style="padding-top:2px; font-size:11px; text-align:center;">            [%VERSION]        </td>    </tr>    </table><!-- OOTP IGNORE END PAGE BOTTOM --> 


[byzeil]

Originally Posted by Andreas Raht

This is the original page_bottom_line.tpl:

PHP Code:

<!-- OOTP IGNORE START PAGE BOTTOM --><table cellspacing="0" cellpadding="0" align="center" width="968px">    <tr>        <td style="padding-top:10px; font-size:11px; text-align:center;">            [%POWERED_BY]        </td>    </tr>    <tr>        <td style="padding-top:2px; font-size:11px; text-align:center;">            [%VERSION]        </td>    </tr>    </table><!-- OOTP IGNORE END PAGE BOTTOM --> 


Remove the [%VERSION] This is the edited template:

PHP Code:

<!-- OOTP IGNORE START PAGE BOTTOM --><table cellspacing="0" cellpadding="0" align="center" width="968px">    <tr>        <td style="padding-top:10px; font-size:11px; text-align:center;">            [%POWERED_BY]        </td>    </tr>    <tr>        <td style="padding-top:2px; font-size:11px; text-align:center;">    </td>    </tr>    </table><!-- OOTP IGNORE END PAGE BOTTOM --> 


the edited version that you posted still has the 'version' in it.

[Andreas Raht]

Originally Posted by byzeil

the edited version that you posted still has the 'version' in it.

Fixed. Thanks!

[captaincoop17]

Still getting this error when loading a saved game or trying to view any reports in game.

Also prevents the game from simming and I have to force quit.

[Andreas Raht]

Originally Posted by captaincoop17

Still getting this error when loading a saved game or trying to review any reports in game.

Also prevents the game from simming and I have to force quit.

The game cannot fnd or cannot open the file in the templates folder. Did you restart OOTP? Is the file still there and has the proper name?

[captaincoop17]

Originally Posted by Andreas Raht

The game cannot fnd or cannot open the file in the templates folder. Did you restart OOTP? Is the file still there and has the proper name?

Yes, restarted OOTP multiple times. File is still in the same place and has the same name.

[byzeil]

Originally Posted by captaincoop17

Yes, restarted OOTP multiple times. File is still in the same place and has the same name.

FYI I have implemented the changes, including altering the templates as suggested, and everything is working OK.

It looks like something went wrong when you altered the template file.

[captaincoop17]

Originally Posted by byzeil

FYI I have implemented the changes, including altering the templates as suggested, and everything is working OK.

It looks like something went wrong when you altered the template file.

Can someone post the template file then?

[motnagoh79]

where are the reports located that need to be deleted?

[byzeil]

Originally Posted by motnagoh79

where are the reports located that need to be deleted?

It is the 'reports' table in your MYSQL database. Only applies if you are loading your reports into MYSQL. The script updates your reports in MYSQL. If you are just uploading your reports as HTML this script really don't do anything for you.