API tools faq
paste
Advertisement
Guest User

dfgdgdg

a guest
Jul 14th, 2010
214
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.28 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <title>VGC Hockey - GM Panel (Game Entry)</title>
  4. <SCRIPT TYPE="text/javascript">
  5. <!--
  6. function popup(mylink, windowname)
  7. {
  8. if (! window.focus)return true;
  9. var href;
  10. if (typeof(mylink) == 'string')
  11. href=mylink;
  12. else
  13. href=mylink.href;
  14. window.open(href, windowname, 'width=550,height=650,scrollbars=yes');
  15. return false;
  16. }
  17. //-->
  18. </SCRIPT>
  19. </head>
  20. <body bgcolor="#d3d3d3">
  21.  
  22. <table width="1000" border="0" align="center">
  23. <tr BACKGROUND="images/table_bg.gif" WIDTH="60" height="30">
  24. <td><center><font color="white" face="verdana"><b>General Manger Control Panel</b></font></center></td>
  25. </tr>
  26. <tr BACKGROUND="images/table_bg.gif" WIDTH="60" height="20">
  27. <td><center><font color="white" face="verdana" size="2"><b>Enter A Game</b></font></center></td>
  28. </tr>
  29. </table>
  30. <br />
  31.  
  32. <center><b><font size="2" color="red">IMPORTANT NOTE</font> - PLEASE PUT (&nbsp;&nbsp;&nbsp;) AROUND THE TEAM ABBREVIATION!</font></b></center>
  33. <br />
  34.  
  35.  
  36. <?php
  37. // Make a MySQL Connection
  38. mysql_connect("65.60.39.59", "projmayh3m_admin", "mayh3misnum1") or die(mysql_error());
  39. mysql_select_db("db_projmay3m") or die(mysql_error());
  40.  
  41. // Retrieve all the data from the "example" table
  42. $result = mysql_query("SELECT * FROM game_stats ORDER BY game_id DESC LIMIT 0,1");
  43.  
  44. while($row = mysql_fetch_array($result))
  45. {
  46. if($row['home'] == 0)
  47. {
  48. echo "<center><b>Last Team: </b>".$row['team_home']."</center>";
  49. }
  50. else
  51. {
  52. echo "<center><b>Last Team: </b>".$row['team_away']."</center>";
  53. }
  54.  
  55. echo "<center><b>Last Game ID: </b>".$row['game_id']."</center>";
  56.  
  57. echo "<br />";
  58. }
  59. ?>
  60.  
  61. <center><font face="verdana" size="2"><A HREF="playerid.php" onClick="return popup(this, 'players')">Click Here For Player ID's</A></font></center>
  62.  
  63.  
  64.  
  65. <form action="/site/admin/insertgame.php" method="post">
  66.  
  67. <br />
  68.  
  69. <table width="500" border="0" align="center">
  70. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  71. <td><center><font color="white" face="verdana" size="2"><b>General Stats</b></font></center></td>
  72. </tr>
  73. </table>
  74.  
  75.  
  76. <table width="300" border="0" align="center">
  77. <tr>
  78. <td><center><b><font face="verdana" size="2">Game ID:</font></b></center></td>
  79. <td><center><input type="text" name="game_id" size="25"></center></td>
  80. </tr>
  81. <tr>
  82. <td><center><b><font face="verdana" size="2">Win:</font></b></center></td>
  83. <td><center><input type="text" name="win" size="25"></center></td>
  84. </tr>
  85. <tr>
  86. <td><center><b><font face="verdana" size="2">Loss:</font></b></center></td>
  87. <td><center><input type="text" name="loss" size="25"></center></td>
  88. </tr>
  89. <tr>
  90. <td><center><b><font face="verdana" size="2">OT Loss:</font></b></center></td>
  91. <td><center><input type="text" name="otl" size="25"></center></td>
  92. </tr>
  93. <tr>
  94. <td><center><b><font face="verdana" size="2">Overtime:</font></b></center></td>
  95. <td><center><input type="text" name="ot" size="25"></center></td>
  96. </tr>
  97. <tr>
  98. <td><center><b><font face="verdana" size="2">Home:</font></b></center></td>
  99. <td><center><input type="text" name="home" size="25"></center></td>
  100. </tr>
  101. <tr>
  102. <td><center><b><font face="verdana" size="2">Date (Month):</font></b></center></td>
  103. <td><center><input type="text" name="date_month" size="25"></center></td>
  104. </tr>
  105. <tr>
  106. <td><center><b><font face="verdana" size="2">Date (Day):</font></b></center></td>
  107. <td><center><input type="text" name="date_day" size="25"></center></td>
  108. </tr>
  109. <tr>
  110. <td><center><b><font face="verdana" size="2">Rank:</font></b></center></td>
  111. <td><center><input type="text" name="rank" size="25"></center></td>
  112. </tr>
  113. </table>
  114.  
  115. <br />
  116.  
  117.  
  118. <table width="500" border="0" align="center">
  119. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  120. <td><center><font color="white" face="verdana" size="2"><b>Game Stats</b></font></center></td>
  121. </tr>
  122. </table>
  123. <table width="400" border="0" align="center">
  124. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  125. <td><center><font color="white" face="verdana" size="2"><b>Home Team</b></font></center></td>
  126. </tr>
  127. </table>
  128. <table width="300" border="0" align="center">
  129. <tr>
  130. <td><center><b><font face="verdana" size="2">Team Name:</font></b></center></td>
  131. <td><center><input type="text" name="team_home" size="25"></center></td>
  132. </tr>
  133. <tr>
  134. <td><center><b><font face="verdana" size="2">Abbreviation:</font></b></center></td>
  135. <td><center><input type="text" name="abbr_home" size="25"></center></td>
  136. </tr>
  137. <tr>
  138. <td><center><b><font face="verdana" size="2">Period 1 Score:</font></b></center></td>
  139. <td><center><input type="text" name="p1_score_home" size="25"></center></td>
  140. </tr>
  141. <tr>
  142. <td><center><b><font face="verdana" size="2">Period 2 Score:</font></b></center></td>
  143. <td><center><input type="text" name="p2_score_home" size="25"></center></td>
  144. </tr>
  145. <tr>
  146. <td><center><b><font face="verdana" size="2">Period 3 Score:</font></b></center></td>
  147. <td><center><input type="text" name="p3_score_home" size="25"></center></td>
  148. </tr>
  149. <tr>
  150. <td><center><b><font face="verdana" size="2">OT Score:</font></b></center></td>
  151. <td><center><input type="text" name="p4_score_home" size="25"></center></td>
  152. </tr>
  153. <tr>
  154. <td><center><b><font face="verdana" size="2">Score:</font></b></center></td>
  155. <td><center><input type="text" name="score_home" size="25"></center></td>
  156. </tr>
  157. <tr>
  158. <td><center><b><font face="verdana" size="2">Shots:</font></b></center></td>
  159. <td><center><input type="text" name="shots_home" size="25"></center></td>
  160. </tr>
  161. <tr>
  162. <td><center><b><font face="verdana" size="2">Hits:</font></b></center></td>
  163. <td><center><input type="text" name="hits_home" size="25"></center></td>
  164. </tr>
  165. <tr>
  166. <td><center><b><font face="verdana" size="2">Faceoffs:</font></b></center></td>
  167. <td><center><input type="text" name="faceoff_home" size="25"></center></td>
  168. </tr>
  169. <tr>
  170. <td><center><b><font face="verdana" size="2">TOA (MIN):</font></b></center></td>
  171. <td><center><input type="text" name="toa_home_min" size="25"></center></td>
  172. </tr>
  173. <tr>
  174. <td><center><b><font face="verdana" size="2">TOA (SEC):</font></b></center></td>
  175. <td><center><input type="text" name="toa_home_sec" size="25"></center></td>
  176. </tr>
  177. <tr>
  178. <td><center><b><font face="verdana" size="2">Penalty Minutes:</font></b></center></td>
  179. <td><center><input type="text" name="pim_home" size="25"></center></td>
  180. </tr>
  181. <tr>
  182. <td><center><b><font face="verdana" size="2">PP Attempts:</font></b></center></td>
  183. <td><center><input type="text" name="ppa_home" size="25"></center></td>
  184. </tr>
  185. <tr>
  186. <td><center><b><font face="verdana" size="2">PP Goals:</font></b></center></td>
  187. <td><center><input type="text" name="ppg_home" size="25"></center></td>
  188. </tr>
  189. </table>
  190.  
  191. <br />
  192.  
  193.  
  194. <table width="500" border="0" align="center">
  195. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  196. <td><center><font color="white" face="verdana" size="2"><b>Game Stats</b></font></center></td>
  197. </tr>
  198. </table>
  199. <table width="400" border="0" align="center">
  200. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  201. <td><center><font color="white" face="verdana" size="2"><b>Away Team</b></font></center></td>
  202. </tr>
  203. </table>
  204. <table width="300" border="0" align="center">
  205. <tr>
  206. <td><center><b><font face="verdana" size="2">Team Name:</font></b></center></td>
  207. <td><center><input type="text" name="team_away" size="25"></center></td>
  208. </tr>
  209. <tr>
  210. <td><center><b><font face="verdana" size="2">Abbreviation:</font></b></center></td>
  211. <td><center><input type="text" name="abbr_away" size="25"></center></td>
  212. </tr>
  213. <tr>
  214. <td><center><b><font face="verdana" size="2">Period 1 Score:</font></b></center></td>
  215. <td><center><input type="text" name="p1_score_away" size="25"></center></td>
  216. </tr>
  217. <tr>
  218. <td><center><b><font face="verdana" size="2">Period 2 Score:</font></b></center></td>
  219. <td><center><input type="text" name="p2_score_away" size="25"></center></td>
  220. </tr>
  221. <tr>
  222. <td><center><b><font face="verdana" size="2">Period 3 Score:</font></b></center></td>
  223. <td><center><input type="text" name="p3_score_away" size="25"></center></td>
  224. </tr>
  225. <tr>
  226. <td><center><b><font face="verdana" size="2">OT Score:</font></b></center></td>
  227. <td><center><input type="text" name="p4_score_away" size="25"></center></td>
  228. </tr>
  229. <tr>
  230. <td><center><b><font face="verdana" size="2">Score:</font></b></center></td>
  231. <td><center><input type="text" name="score_away" size="25"></center></td>
  232. </tr>
  233. <tr>
  234. <td><center><b><font face="verdana" size="2">Shots:</font></b></center></td>
  235. <td><center><input type="text" name="shots_away" size="25"></center></td>
  236. </tr>
  237. <tr>
  238. <td><center><b><font face="verdana" size="2">Hits:</font></b></center></td>
  239. <td><center><input type="text" name="hits_away" size="25"></center></td>
  240. </tr>
  241. <tr>
  242. <td><center><b><font face="verdana" size="2">Faceoffs:</font></b></center></td>
  243. <td><center><input type="text" name="faceoff_away" size="25"></center></td>
  244. </tr>
  245. <tr>
  246. <td><center><b><font face="verdana" size="2">TOA (MIN):</font></b></center></td>
  247. <td><center><input type="text" name="toa_away_min" size="25"></center></td>
  248. </tr>
  249. <tr>
  250. <td><center><b><font face="verdana" size="2">TOA (SEC):</font></b></center></td>
  251. <td><center><input type="text" name="toa_away_sec" size="25"></center></td>
  252. </tr>
  253. <tr>
  254. <td><center><b><font face="verdana" size="2">Penalty Minutes:</font></b></center></td>
  255. <td><center><input type="text" name="pim_away" size="25"></center></td>
  256. </tr>
  257. <tr>
  258. <td><center><b><font face="verdana" size="2">PP Attempts:</font></b></center></td>
  259. <td><center><input type="text" name="ppa_away" size="25"></center></td>
  260. </tr>
  261. <tr>
  262. <td><center><b><font face="verdana" size="2">PP Goals:</font></b></center></td>
  263. <td><center><input type="text" name="ppg_away" size="25"></center></td>
  264. </tr>
  265. </table>
  266.  
  267. <br />
  268.  
  269.  
  270. <table width="500" border="0" align="center">
  271. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  272. <td><center><font color="white" face="verdana" size="2"><b>Player Stats</b></font></center></td>
  273. </tr>
  274. </table>
  275. <table width="700" border="0" align="center">
  276. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  277. <td><center><font color="white" face="verdana" size="2"><b>Player ID</b></font></center></td>
  278. <td><center><font color="white" face="verdana" size="2"><b>Game ID</b></font></center></td>
  279. <td><center><font color="white" face="verdana" size="2"><b>GP</b></font></center></td>
  280. <td><center><font color="white" face="verdana" size="2"><b>Gamertag</b></font></center></td>
  281. <td><center><font color="white" face="verdana" size="2"><b>G</b></font></center></td>
  282. <td><center><font color="white" face="verdana" size="2"><b>A</b></font></center></td>
  283. <td><center><font color="white" face="verdana" size="2"><b>+/-</b></font></center></td>
  284. <td><center><font color="white" face="verdana" size="2"><b>SOG</b></font></center></td>
  285. <td><center><font color="white" face="verdana" size="2"><b>PPG</b></font></center></td>
  286. <td><center><font color="white" face="verdana" size="2"><b>SHG</b></font></center></td>
  287. <td><center><font color="white" face="verdana" size="2"><b>PIM</b></font></center></td>
  288. <td><center><font color="white" face="verdana" size="2"><b>Hits</b></font></center></td>
  289. </tr>
  290. <tr>
  291. <td><center><input type="text" name="playerid_1" size="5"></center></td>
  292. <td><center><input type="text" name="game_id_1" size="5"></center></td>
  293. <td><center><input type="text" name="gp_1" size="5"></center></td>
  294. <td><center><input type="text" name="gamertag_1" size="15"></center></td>
  295. <td><center><input type="text" name="goals_1" size="5"></center></td>
  296. <td><center><input type="text" name="assists_1" size="5"></center></td>
  297. <td><center><input type="text" name="plus_minus_1" size="5"></center></td>
  298. <td><center><input type="text" name="sog_1" size="5"></center></td>
  299. <td><center><input type="text" name="ppg_1" size="5"></center></td>
  300. <td><center><input type="text" name="shg_1" size="5"></center></td>
  301. <td><center><input type="text" name="pim_1" size="5"></center></td>
  302. <td><center><input type="text" name="hits_1" size="5"></center></td>
  303. </tr>
  304. <tr>
  305. <td><center><input type="text" name="playerid_2" size="5"></center></td>
  306. <td><center><input type="text" name="game_id_2" size="5"></center></td>
  307. <td><center><input type="text" name="gp_2" size="5"></center></td>
  308. <td><center><input type="text" name="gamertag_2" size="15"></center></td>
  309. <td><center><input type="text" name="goals_2" size="5"></center></td>
  310. <td><center><input type="text" name="assists_2" size="5"></center></td>
  311. <td><center><input type="text" name="plus_minus_2" size="5"></center></td>
  312. <td><center><input type="text" name="sog_2" size="5"></center></td>
  313. <td><center><input type="text" name="ppg_2" size="5"></center></td>
  314. <td><center><input type="text" name="shg_2" size="5"></center></td>
  315. <td><center><input type="text" name="pim_2" size="5"></center></td>
  316. <td><center><input type="text" name="hits_2" size="5"></center></td>
  317. </tr>
  318. <tr>
  319. <td><center><input type="text" name="playerid_3" size="5"></center></td>
  320. <td><center><input type="text" name="game_id_3" size="5"></center></td>
  321. <td><center><input type="text" name="gp_3" size="5"></center></td>
  322. <td><center><input type="text" name="gamertag_3" size="15"></center></td>
  323. <td><center><input type="text" name="goals_3" size="5"></center></td>
  324. <td><center><input type="text" name="assists_3" size="5"></center></td>
  325. <td><center><input type="text" name="plus_minus_3" size="5"></center></td>
  326. <td><center><input type="text" name="sog_3" size="5"></center></td>
  327. <td><center><input type="text" name="ppg_3" size="5"></center></td>
  328. <td><center><input type="text" name="shg_3" size="5"></center></td>
  329. <td><center><input type="text" name="pim_3" size="5"></center></td>
  330. <td><center><input type="text" name="hits_3" size="5"></center></td>
  331. </tr>
  332. <tr>
  333. <td><center><input type="text" name="playerid_4" size="5"></center></td>
  334. <td><center><input type="text" name="game_id_4" size="5"></center></td>
  335. <td><center><input type="text" name="gp_4" size="5"></center></td>
  336. <td><center><input type="text" name="gamertag_4" size="15"></center></td>
  337. <td><center><input type="text" name="goals_4" size="5"></center></td>
  338. <td><center><input type="text" name="assists_4" size="5"></center></td>
  339. <td><center><input type="text" name="plus_minus_4" size="5"></center></td>
  340. <td><center><input type="text" name="sog_4" size="5"></center></td>
  341. <td><center><input type="text" name="ppg_4" size="5"></center></td>
  342. <td><center><input type="text" name="shg_4" size="5"></center></td>
  343. <td><center><input type="text" name="pim_4" size="5"></center></td>
  344. <td><center><input type="text" name="hits_4" size="5"></center></td>
  345. </tr>
  346. <tr>
  347. <td><center><input type="text" name="playerid_5" size="5"></center></td>
  348. <td><center><input type="text" name="game_id_5" size="5"></center></td>
  349. <td><center><input type="text" name="gp_5" size="5"></center></td>
  350. <td><center><input type="text" name="gamertag_5" size="15"></center></td>
  351. <td><center><input type="text" name="goals_5" size="5"></center></td>
  352. <td><center><input type="text" name="assists_5" size="5"></center></td>
  353. <td><center><input type="text" name="plus_minus_5" size="5"></center></td>
  354. <td><center><input type="text" name="sog_5" size="5"></center></td>
  355. <td><center><input type="text" name="ppg_5" size="5"></center></td>
  356. <td><center><input type="text" name="shg_5" size="5"></center></td>
  357. <td><center><input type="text" name="pim_5" size="5"></center></td>
  358. <td><center><input type="text" name="hits_5" size="5"></center></td>
  359. </tr>
  360. </table>
  361.  
  362. <br /><br /><br />
  363.  
  364. <table width="500" border="0" align="center">
  365. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  366. <td><center><font color="white" face="verdana" size="2"><b>Goalie Stats</b></font></center></td>
  367. </tr>
  368. </table>
  369. <table width="700" border="0" align="center">
  370. <tr BACKGROUND="images/table_bg.gif" WIDTH="100" height="20" align="center">
  371. <td><center><font color="white" face="verdana" size="2"><b>Player ID</b></font></center></td>
  372. <td><center><font color="white" face="verdana" size="2"><b>Game ID</b></font></center></td>
  373. <td><center><font color="white" face="verdana" size="2"><b>GP</b></font></center></td>
  374. <td><center><font color="white" face="verdana" size="2"><b>Gamertag</b></font></center></td>
  375. <td><center><font color="white" face="verdana" size="2"><b>Min</b></font></center></td>
  376. <td><center><font color="white" face="verdana" size="2"><b>W</b></font></center></td>
  377. <td><center><font color="white" face="verdana" size="2"><b>L</b></font></center></td>
  378. <td><center><font color="white" face="verdana" size="2"><b>OTL</b></font></center></td>
  379. <td><center><font color="white" face="verdana" size="2"><b>SA</b></font></center></td>
  380. <td><center><font color="white" face="verdana" size="2"><b>SV</b></font></center></td>
  381. <td><center><font color="white" face="verdana" size="2"><b>GA</b></font></center></td>
  382. <td><center><font color="white" face="verdana" size="2"><b>ENG</b></font></center></td>
  383. <td><center><font color="white" face="verdana" size="2"><b>A</b></font></center></td>
  384. <td><center><font color="white" face="verdana" size="2"><b>SO</b></font></center></td>
  385. <td><center><font color="white" face="verdana" size="2"><b>PIM</b></font></center></td>
  386. </tr>
  387. <tr>
  388. <td><center><input type="text" name="playerid_6" size="5"></center></td>
  389. <td><center><input type="text" name="game_id_6" size="5"></center></td>
  390. <td><center><input type="text" name="gp_6" size="5"></center></td>
  391. <td><center><input type="text" name="gamertag_6" size="15"></center></td>
  392. <td><center><input type="text" name="min_6" size="5"></center></td>
  393. <td><center><input type="text" name="win_6" size="5"></center></td>
  394. <td><center><input type="text" name="loss_6" size="5"></center></td>
  395. <td><center><input type="text" name="otl_6" size="5"></center></td>
  396. <td><center><input type="text" name="sa_6" size="5"></center></td>
  397. <td><center><input type="text" name="sv_6" size="5"></center></td>
  398. <td><center><input type="text" name="ga_6" size="5"></center></td>
  399. <td><center><input type="text" name="eng_6" size="5"></center></td>
  400. <td><center><input type="text" name="so_6" size="5"></center></td>
  401. <td><center><input type="text" name="a_6" size="5"></center></td>
  402. <td><center><input type="text" name="pim_6" size="5"></center></td>
  403. </tr>
  404. </table>
  405.  
  406.  
  407.  
  408.  
  409. <br /><br />
  410. <center><input type="submit" /></center>
  411. </form>
  412.  
  413.  
  414. </body>
  415. </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!