API tools faq
paste
Advertisement
Guest User

gameform

a guest
Jun 29th, 2010
265
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.84 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <title>VGC Hockey - GM Panel (Game Entry)</title>
  4. </head>
  5. <body bgcolor="#d3d3d3">
  6.  
  7. <table width="1000" border="0" align="center">
  8. <tr BACKGROUND="images/table_bg.gif" WIDTH="60" height="30">
  9. <td><center><font color="white" face="verdana"><b>General Manger Control Panel</b></font></center></td>
  10. </tr>
  11. <tr BACKGROUND="images/table_bg.gif" WIDTH="60" height="20">
  12. <td><center><font color="white" face="verdana" size="2"><b>Enter A Game</b></font></center></td>
  13. </tr>
  14. </table>
  15. <br />
  16.  
  17. <center><b><font size="2"<font color="red">IMPORTANT NOTE</font> - PLEASE PUT (&nbsp;&nbsp;&nbsp;) AROUND THE TEAM ABBREVIATION!</font></b></center>
  18. <br />
  19.  
  20.  
  21. <?php
  22. // Make a MySQL Connection
  23. mysql_connect("sql307.byethost10.com", "b10_5696492", "stock42") or die(mysql_error());
  24. mysql_select_db("b10_5696492_eashl") or die(mysql_error());
  25.  
  26. // Retrieve all the data from the "example" table
  27. $result = mysql_query("SELECT * FROM game_stats ORDER BY game_id DESC LIMIT 0,1");
  28.  
  29. while($row = mysql_fetch_array($result))
  30. {
  31. if($row['home'] == 0)
  32. {
  33. echo "<center><b>Last Team: </b>".$row['team_home']."</center>";
  34. }
  35. else
  36. {
  37. echo "<center><b>Last Team: </b>".$row['team_away']."</center>";
  38. }
  39.  
  40. echo "<center><b>Last Game ID: </b>".$row['game_id']."</center>";
  41.  
  42. echo "<br />";
  43. }
  44. ?>
  45.  
  46.  
  47. <table width='250' align='center' border='0'>
  48. <tr>
  49. <td><font face="verdana" size="2"><b>Gamertag</b></font></td>
  50. <td><center><font face="verdana" size="2"><b>Player ID</b></font></center></td>
  51. </tr>
  52.  
  53. <?php
  54. $result = mysql_query("SELECT * FROM roster");
  55. while($row = mysql_fetch_array($result))
  56. {
  57. {
  58. echo "<tr><td>";
  59. echo $row['gamertag'];
  60. echo "</td><td>";
  61. echo "<center>".$row['playerid']."</center>";
  62. echo "</td></tr>";
  63. }
  64.  
  65. }
  66. ?>
  67. </table>
  68. <br /><br />
  69.  
  70. <table width="500" border="0" align="center">
  71. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  72. <td><center><font color="white" face="verdana" size="2"><b>Game Stats</b></font></center></td>
  73. </tr>
  74. </table>
  75.  
  76.  
  77.  
  78. <form action="/site/insertgame.php" method="post">
  79. <table width="500" border="0" align="center">
  80. <tr>
  81. <td><center><b><font face="verdana" size="2">Game ID <input type="test" name="game_id" size="25"></font></b></center></td>
  82. </tr>
  83. </table>
  84. <table width="500" border="0" align="center">
  85. <tr>
  86. <td><center><b><font face="verdana" size="2">Away Team <br /> <input type="text" name="team_away" size="25"> Abbreviation<br /> <input type="text" name="abbr_away" size="25"></font></b></center></td>
  87. <td></td>
  88. <td><center><b><font face="verdana" size="2">Home Team <br /> <input type="text" name="team_home" size="25"> Abbreviation<br /> <input type="text" name="abbr_home" size="25"></font></b></center></td>
  89. </table>
  90.  
  91. <br />
  92.  
  93. <table width="500" border="0" align="center">
  94. <tr>
  95. <td><center><input type="text" name="score_away" size="25"></center></td>
  96. <td><center><font face="verdana" size="2"><b>Goals</font></b></center></center></td>
  97. <td><center><input type="text" name="score_home" size="25"></center></td>
  98. </tr>
  99. <tr>
  100. <td><center><input type="text" name="shots_away" size="25"></center></td>
  101. <td><center><font face="verdana" size="2"><b>Shots</font></b></center></center></td>
  102. <td><center><input type="text" name="shots_home" size="25"></center></td>
  103. </tr>
  104. <tr>
  105. <td><center><input type="text" name="hits_away" size="25"></center></td>
  106. <td><center><b><font face="verdana" size="2">Hits</font></b></center></center></td>
  107. <td><center><input type="text" name="hits_home" size="25"></center></td>
  108. </tr>
  109. <tr>
  110. <td><center><input type="text" name="faceoff_away" size="25"></center></td>
  111. <td><center><b><font face="verdana" size="2">Faceoffs</font></b></center></center></td>
  112. <td><center><input type="text" name="faceoff_home" size="25"></center></td>
  113. </tr>
  114. <tr>
  115. <td><center><input type="text" name="toa_away_min" size="25"></center></td>
  116. <td><center><b><font face="verdana" size="2">Time on Attack (MIN)</font></b></center></center></td>
  117. <td><center><input type="text" name="toa_home_min" size="25"></center></td>
  118. </tr>
  119. <tr>
  120. <td><center><input type="text" name="toa_away_sec" size="25"></center></td>
  121. <td><center><b><font face="verdana" size="2">Time on Attack (SEC)</font></b></center></center></td>
  122. <td><center><input type="text" name="toa_home_sec" size="25"></center></td>
  123. </tr>
  124. <tr>
  125. <td><center><input type="text" name="pim_away" size="25"></center></td>
  126. <td><center><b><font face="verdana" size="2">Penalty Minutes</font></b></center></center></td>
  127. <td><center><input type="text" name="pim_home" size="25"></center></td>
  128. </tr>
  129. <tr>
  130. <td><center><input type="text" name="ppa_away" size="25"></center></td>
  131. <td><center><b><font face="verdana" size="2">Penalty Attempts</font></b></center></center></td>
  132. <td><center><input type="text" name="ppa_home" size="25"></center></td>
  133. </tr>
  134. <tr>
  135. <td><center><input type="text" name="ppg_away" size="25"></center></td>
  136. <td><center><b><font face="verdana" size="2">Penalty Goals</font></b></center></center></td>
  137. <td><center><input type="text" name="ppg_home" size="25"></center></td>
  138. </tr>
  139. </table>
  140.  
  141. <br /><br />
  142.  
  143. <table width="500" border="0" align="center">
  144. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  145. <td><center><font color="white" face="verdana" size="2"><b>Player Stats</b></font></center></td>
  146. </tr>
  147. </table>
  148. <table width="700" border="0" align="center">
  149. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  150. <td><center><font color="white" face="verdana" size="2"><b>Player ID</b></font></center></td>
  151. <td><center><font color="white" face="verdana" size="2"><b>Game ID</b></font></center></td>
  152. <td><center><font color="white" face="verdana" size="2"><b>Gamertag</b></font></center></td>
  153. <td><center><font color="white" face="verdana" size="2"><b>G</b></font></center></td>
  154. <td><center><font color="white" face="verdana" size="2"><b>A</b></font></center></td>
  155. <td><center><font color="white" face="verdana" size="2"><b>+/-</b></font></center></td>
  156. <td><center><font color="white" face="verdana" size="2"><b>SOG</b></font></center></td>
  157. <td><center><font color="white" face="verdana" size="2"><b>PPG</b></font></center></td>
  158. <td><center><font color="white" face="verdana" size="2"><b>SHG</b></font></center></td>
  159. <td><center><font color="white" face="verdana" size="2"><b>PIM</b></font></center></td>
  160. <td><center><font color="white" face="verdana" size="2"><b>Hits</b></font></center></td>
  161. </tr>
  162. <tr>
  163. <td><center><input type="text" name="playerid" size="5"></center></td>
  164. <td><center><input type="text" name="gameid" size="5"></center></td>
  165. <td><center><input type="text" name="gamertag" size="15"></center></td>
  166. <td><center><input type="text" name="goals" size="5"></center></td>
  167. <td><center><input type="text" name="assist" size="5"></center></td>
  168. <td><center><input type="text" name="plus_minus" size="5"></center></td>
  169. <td><center><input type="text" name="sog" size="5"></center></td>
  170. <td><center><input type="text" name="ppg" size="5"></center></td>
  171. <td><center><input type="text" name="shg" size="5"></center></td>
  172. <td><center><input type="text" name="pim" size="5"></center></td>
  173. <td><center><input type="text" name="hits" size="5"></center></td>
  174. </tr>
  175. <tr>
  176. <td><center><input type="text" name="playerid" size="5"></center></td>
  177. <td><center><input type="text" name="gameid" size="5"></center></td>
  178. <td><center><input type="text" name="gamertag" size="15"></center></td>
  179. <td><center><input type="text" name="goals" size="5"></center></td>
  180. <td><center><input type="text" name="assist" size="5"></center></td>
  181. <td><center><input type="text" name="plus_minus" size="5"></center></td>
  182. <td><center><input type="text" name="sog" size="5"></center></td>
  183. <td><center><input type="text" name="ppg" size="5"></center></td>
  184. <td><center><input type="text" name="shg" size="5"></center></td>
  185. <td><center><input type="text" name="pim" size="5"></center></td>
  186. <td><center><input type="text" name="hits" size="5"></center></td>
  187. </tr>
  188. <tr>
  189. <td><center><input type="text" name="playerid" size="5"></center></td>
  190. <td><center><input type="text" name="gameid" size="5"></center></td>
  191. <td><center><input type="text" name="gamertag" size="15"></center></td>
  192. <td><center><input type="text" name="goals" size="5"></center></td>
  193. <td><center><input type="text" name="assist" size="5"></center></td>
  194. <td><center><input type="text" name="plus_minus" size="5"></center></td>
  195. <td><center><input type="text" name="sog" size="5"></center></td>
  196. <td><center><input type="text" name="ppg" size="5"></center></td>
  197. <td><center><input type="text" name="shg" size="5"></center></td>
  198. <td><center><input type="text" name="pim" size="5"></center></td>
  199. <td><center><input type="text" name="hits" size="5"></center></td>
  200. </tr>
  201. <tr>
  202. <td><center><input type="text" name="playerid" size="5"></center></td>
  203. <td><center><input type="text" name="gameid" size="5"></center></td>
  204. <td><center><input type="text" name="gamertag" size="15"></center></td>
  205. <td><center><input type="text" name="goals" size="5"></center></td>
  206. <td><center><input type="text" name="assist" size="5"></center></td>
  207. <td><center><input type="text" name="plus_minus" size="5"></center></td>
  208. <td><center><input type="text" name="sog" size="5"></center></td>
  209. <td><center><input type="text" name="ppg" size="5"></center></td>
  210. <td><center><input type="text" name="shg" size="5"></center></td>
  211. <td><center><input type="text" name="pim" size="5"></center></td>
  212. <td><center><input type="text" name="hits" size="5"></center></td>
  213. </tr>
  214. <tr>
  215. <td><center><input type="text" name="playerid" size="5"></center></td>
  216. <td><center><input type="text" name="gameid" size="5"></center></td>
  217. <td><center><input type="text" name="gamertag" size="15"></center></td>
  218. <td><center><input type="text" name="goals" size="5"></center></td>
  219. <td><center><input type="text" name="assist" size="5"></center></td>
  220. <td><center><input type="text" name="plus_minus" size="5"></center></td>
  221. <td><center><input type="text" name="sog" size="5"></center></td>
  222. <td><center><input type="text" name="ppg" size="5"></center></td>
  223. <td><center><input type="text" name="shg" size="5"></center></td>
  224. <td><center><input type="text" name="pim" size="5"></center></td>
  225. <td><center><input type="text" name="hits" size="5"></center></td>
  226. </tr>
  227. </table>
  228.  
  229. <br /><br /><br />
  230.  
  231. <table width="500" border="0" align="center">
  232. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  233. <td><center><font color="white" face="verdana" size="2"><b>Goalie Stats</b></font></center></td>
  234. </tr>
  235. </table>
  236. <table width="700" border="0" align="center">
  237. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  238. <td><center><font color="white" face="verdana" size="2"><b>Player ID</b></font></center></td>
  239. <td><center><font color="white" face="verdana" size="2"><b>Game ID</b></font></center></td>
  240. <td><center><font color="white" face="verdana" size="2"><b>GP</b></font></center></td>
  241. <td><center><font color="white" face="verdana" size="2"><b>Gamertag</b></font></center></td>
  242. <td><center><font color="white" face="verdana" size="2"><b>SA</b></font></center></td>
  243. <td><center><font color="white" face="verdana" size="2"><b>SV</b></font></center></td>
  244. <td><center><font color="white" face="verdana" size="2"><b>GA</b></font></center></td>
  245. <td><center><font color="white" face="verdana" size="2"><b>ENG</b></font></center></td>
  246. <td><center><font color="white" face="verdana" size="2"><b>A</b></font></center></td>
  247. <td><center><font color="white" face="verdana" size="2"><b>SO</b></font></center></td>
  248. <td><center><font color="white" face="verdana" size="2"><b>PIM</b></font></center></td>
  249. <td><center><font color="white" face="verdana" size="2"><b>TOI</b></font></center></td>
  250. </tr>
  251. <tr>
  252. <td><center><input type="text" name="player_id" size="5"></center></td>
  253. <td><center><input type="text" name="game_id" size="5"></center></td>
  254. <td><center><input type="text" name="gp" size="5"></center></td>
  255. <td><center><input type="text" name="gamertag" size="15"></center></td>
  256. <td><center><input type="text" name="sa" size="5"></center></td>
  257. <td><center><input type="text" name="sv" size="5"></center></td>
  258. <td><center><input type="text" name="ga" size="5"></center></td>
  259. <td><center><input type="text" name="eng" size="5"></center></td>
  260. <td><center><input type="text" name="so" size="5"></center></td>
  261. <td><center><input type="text" name="a" size="5"></center></td>
  262. <td><center><input type="text" name="pim" size="5"></center></td>
  263. <td><center><input type="text" name="toi" size="5"></center></td>
  264. </tr>
  265. </table>
  266.  
  267.  
  268.  
  269.  
  270. <br /><br />
  271. <center><input type="submit" /></center>
  272. </form>
  273.  
  274.  
  275. </body>
  276. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!