Appendix: Query String Generation

/**
 * Updates the NFL team stats table with the linescore tag info
 *
 * @param   string   $TeamCode          the ST team id code
 * @param   integer  $Qtr4              Points Team Scored During 4th Quarter
 * @return  string   update query
 */
function qsStatNflLinescore($TeamCode, $Qtr4) {
    return "UPDATE STP_StatsNFLTeam SET Scored4Q=$Qtr4 "
           . "WHERE TeamCode=$TeamCode";
}


/**
 * Updates NFL player stats with recovered dstat info
 *
 * @param   string   $PlayerCode        the ST player id code
 * @param   integer  $P_PuntYds         Total Punting Yards
 * @return  string   update query
 */
function qsStatNflGamePlayerD($PlayerCode, $P_PuntYds) {
    return "UPDATE STP_StatsNFLPlayer SET PuntYard=$P_PuntYds "
           . "WHERE PlayerCode=$PlayerCode";
}