STHS Forum

Back to the TeamLog and LeagueLog tables. Would it be a good idea to add the actual STHS Day in there that the transaction happened along with the DateTime field? Since STHS is based on a Day system and not the actual date, this to me would seem to have more merit to use.

I believe there should be a conscieous effort in data access and location. When you have a folder with a bunch of XML files, there is no direct linkage between the files and the schedule except for the ID number in the file name. Which then you have to do extra PHP to see if a file exists on the ser...

Simon, I have been playing around with the SQLite file and BLOB fields and I believe it could work quite well. I understand that the XML files are generated on the fly. Since I don't know what your output process is like, I feel I need to ask the question: Is possible that if the option is selected ...

I am still fairly new to SQLite, but if LOBs can be used and can attach the Game XML files to the schedule tables as such, then a 1 file upload feels very possible. This is very exciting to think about

There is merit to that I think, a 1 file upload site, however, Simon you can back me up on this, the complication becomes normailzing tables in the database to house the data properly. There would be tables upon tables upon tables. Simon, just a random thought I have, something I just came up with s...

I agree with Simon that the XML schemas are best for this. And as for load time, its pretty fast. I can load a boxscore page with an XML file in approximately 0.1 seconds which is well below any standard loading time.

Everything else I can come across seems to be working great. Thank you so much for the replies. I would like to get your opinion on something. The LeagueLog and TeamLog tables. There is so much valuable information in there that can really be used in many places on a website. Is there anyway you can...

GoalerInfo Table, the Overall Field doesnt seem to have the right value in it. in the ANHS league Kris Miller is an 87OV where in the DB its showing 69OV

PlayerInfo, and GoalerInfo Tables

Website Schema says fieldname "InjuryDuration", field in DB NumberOfInjury

Tables GoalerProStat and GoalerFarmStat Fieldname is "Shootout" where I think its suppose to be "Shutout"? Alternatively, in the SchedulePro and ScheduleFarm the field says "Shutout" where I believe it should be "Shootout" I hope all these messages are ok, if ...

This is great. I agree its great to have the name in the table. All I meant was that it wasn't showing on your web schema. I would also like to make a suggestion in renaming a fields as well. PlayerPro(Farm)Stat, GoalerPro(Farm)Stat 4 different field names for the penalty shots Goalies: PenalityShot...

VisitorTeamName and HomeTeamName are in the "SchedulePro" table but no listed in your web schema

Table: LeagueGeneral

There is a field for ProScheduleTotalDay But none for FarmScheduleTotalDay. Often this value can be different it is needed to calculate expenses. Could this be added to the next release?

Also the same "Payroll" field for TeamFarmFinance

Hi Simon, AS Steff has mentioned, I have been using the SQLite file to begin building his website, and its working very well. Response time is great, and easy to use. However, I am come across some naming conventions that I believe you need to change. Table: ProTeam Finance 1) On your Schema page(ht...