| 75 | // echo "<br>"; | = | 75 | // echo "<br>"; |
| 76 | // echo "</pre>"; | 76 | // echo "</pre>"; | |
| 77 | if ($status == "OT Final") { | 77 | if ($status == "OT Final") { | |
| 78 | $ot = "Y"; } | 78 | $ot = "Y"; } | |
| 79 | else { | 79 | else { | |
| 80 | $ot = "N"; } | 80 | $ot = "N"; } | |
| 81 | $result = ""; | <> | 81 | |
| 82 | $sql="select * from ".$football->prefix."schedule where gameid = ".$gameid; | = | 82 | $sql="select * from ".$football->prefix."schedule where gameid = ".$gameid; |
| 83 | $rs = $football->dbQuery($sql); | 83 | $rs = $football->dbQuery($sql); | |
| 84 | $row=mysql_fetch_array($rs); | 84 | $row=mysql_fetch_array($rs); | |
| 85 | $gametime = $row['gametime']; | 85 | $gametime = $row['gametime']; | |
| 86 | $spread = $row['spread']; | 86 | $spread = $row['spread']; | |
| 87 | $vscore = $row['vscore']; | +- | ||
| 88 | $hscore = $row['hscore']; | |||
| 89 | $result = $row['result']; | |||
| 90 | $otr = $row['ot']; | |||
| 91 | = | 87 | ||
| 92 | if ($result != "") { | +- | ||
| 93 | $awayscore = $vscore; | |||
| 94 | $homescore = $hscore; | |||
| 95 | $ot = $otr; | |||
| 96 | if ($otr == "Y") { | |||
| 97 | $status = "OT Final"; | |||
| 98 | } else { | |||
| 99 | $status = "Final"; | |||
| 100 | } | |||
| 101 | } | |||
| 102 | $sql="insert into `".$football->prefix."currentscores` (gameid, game, gametime, week, vid, hid, vscore, hscore, spread, status, ot, lastck) values ('".$gameid."', '".$game."', '".$gametime."', '".$week1."', '".$away."', '".$home."', '".$awayscore."', '".$homescore."', '".$spread."', '".$status."', '".$ot."', '".$ts."');"; | = | 88 | $sql="insert into `".$football->prefix."currentscores` (gameid, game, gametime, week, vid, hid, vscore, hscore, spread, status, ot, lastck) values ('".$gameid."', '".$game."', '".$gametime."', '".$week1."', '".$away."', '".$home."', '".$awayscore."', '".$homescore."', '".$spread."', '".$status."', '".$ot."', '".$ts."');"; |
| 103 | $rs = $football->dbQuery($sql); | 89 | $rs = $football->dbQuery($sql); | |
| 104 | } | 90 | } | |
| 105 | $sql = "unlock table $tab_name"; | 91 | $sql = "unlock table $tab_name"; | |
| 106 | $result = mysql_query($sql); | 92 | $result = mysql_query($sql); | |
| 107 | ?> | 93 | ?> |