apickard
09-08-2011, 07:00 PM
I'm sure someone else has run into a situation where this may be useful and possibly even found a solution.
I have a TC Broadcast with Livetext 2.1 on a laptop. All graphics for a football game come from the laptop. All 90+ players have a lower third prebuilt with some basic stats. Each lower third's page number is the kids jersey number. We fill in the blank pages in between with the important scoreboard and replay sponsor ad. Using a properly programmed XKeys keypad, it is EXTREMELY easy to recall a players lower third for display while in replay for a closeup shot of the player making play when replay is done. Now, I HATE updating the stats every week. Assuming (due to lack of knowledge on my part) that datalink will force an update call to a database when the page is loaded, is it possible to send a variable such as the LT page number in a query to the SQL call? This would allow me to have 90+ pages in LT but with nothing but variables in the pages. As the page was requested, the SQL would look something like this: "SELECT rush_yards FROM stats WHERE num = %LT_page_num %" and would populate the lower third with the up to date stats, even the tackle he just made.
If there is an easier way to do what I am doing, please let me know. Also, just like most there is almost a zero budget for other software.
Thanks for any input provided.
** I uploaded a screen shot of my screen for a better example. It does not have the actual stats in now but we are wanting to pull them from our stat system the way I described. We currently have scores uploading live to digital billboards around the city from the system so I know its possible. **
I have a TC Broadcast with Livetext 2.1 on a laptop. All graphics for a football game come from the laptop. All 90+ players have a lower third prebuilt with some basic stats. Each lower third's page number is the kids jersey number. We fill in the blank pages in between with the important scoreboard and replay sponsor ad. Using a properly programmed XKeys keypad, it is EXTREMELY easy to recall a players lower third for display while in replay for a closeup shot of the player making play when replay is done. Now, I HATE updating the stats every week. Assuming (due to lack of knowledge on my part) that datalink will force an update call to a database when the page is loaded, is it possible to send a variable such as the LT page number in a query to the SQL call? This would allow me to have 90+ pages in LT but with nothing but variables in the pages. As the page was requested, the SQL would look something like this: "SELECT rush_yards FROM stats WHERE num = %LT_page_num %" and would populate the lower third with the up to date stats, even the tackle he just made.
If there is an easier way to do what I am doing, please let me know. Also, just like most there is almost a zero budget for other software.
Thanks for any input provided.
** I uploaded a screen shot of my screen for a better example. It does not have the actual stats in now but we are wanting to pull them from our stat system the way I described. We currently have scores uploading live to digital billboards around the city from the system so I know its possible. **