/espn3/build_all_database.php

https://github.com/phikai/boxee-espn3 · PHP · 247 lines · 176 code · 38 blank · 33 comment · 0 complexity · c6693bc4e20524328d16aa9e1fb93f6c MD5 · raw file 

    

  1. <?php
    2. 

  2. 

  3. //MySQL Connection Information
    4. 

  4. include('/home/phikai/boxee.thinkonezero.com/mysql_connect.inc.php');
    5. 

  5. 

  6. //MySQL Connection
    7. 

  7. mysql_connect($server,$username,$password);
    8. 

  8. @mysql_select_db($database) or die("Unable to select database");
    9. 

  9. mysql_query("SET time_zone = '-5:00';");
    10. 

  10. 

  11. 

  12. //Set XML Errors Off
    13. 

  13. //libxml_use_internal_errors(true);
    14. 

  14. libxml_use_internal_errors(false);
    15. 

  15. 

  16. //Set endDate for Greater Feed Accuracy
    17. 

  17. $endDate = date('Ymd');
    18. 

  18. 

  19. /*===============BEGIN LIVE DATABASE CREATION==================*/
    20. 

  20. 

  21. //Set URL for Live Feed
    22. 

  22. $livefeed = 'http://sports-ak.espn.go.com/espn3/feeds/live?endDate='.$endDate;
    23. 

  23. 

  24. //Get the XML Source of ESPN3 Live Feed
    25. 

  25. $xml = file_get_contents($livefeed);
    26. 

  26. $enc = mb_detect_encoding($xml);
    27. 

  27. $xml = mb_convert_encoding($xml, 'UTF-8', $enc);
    28. 

  28. $e3_live_xml = new SimpleXMLElement($xml);
    29. 

  29. unset($xml);
    30. 

  30. unset($enc);
    31. 

  31. 

  32. //Live Event Handling
    33. 

  33. foreach($e3_live_xml->event as $event) {
    34. 

  34. 	foreach($event as $event_id) {
    35. 

  35. 		$event_id_num = $event['id'];
    36. 

  36. 		$raw['idnum'] = trim($event_id_num);
    37. 

  37. 	}
    38. 

  38. 	unset($event_id);
    39. 

  39. 	foreach($event->name as $event_name) {
    40. 

  40. 		$raw['event'] = trim($event_name);
    41. 

  41. 	}
    42. 

  42. 	unset($event_name);
    43. 

  43. 	foreach($event->league as $event_league) {
    44. 

  44. 		$raw['league'] = trim($event_league);
    45. 

  45. 	}
    46. 

  46. 	unset($event_league);
    47. 

  47. 	foreach($event->sport as $event_sport) {
    48. 

  48. 		$raw['sport'] = trim($event_sport);
    49. 

  49. 	}
    50. 

  50. 	unset($event_sport);
    51. 

  51. 	foreach($event->startTime as $event_time) {
    52. 

  52. 		$time = trim($event_time);
    53. 

  53. 		$raw['date'] = date('Y-m-d', strtotime($time));
    54. 

  54. 		$raw['time'] = date('H:i:s', strtotime($time));
    55. 

  55. 	}
    56. 

  56. 	unset($event_time);
    57. 

  57. 	foreach($event->thumbnail->large as $event_thumb) {
    58. 

  58. 		$raw['thumb'] = trim($event_thumb);
    59. 

  59. 	}
    60. 

  60. 	unset($event_thumb);
    61. 

  61.    	
    62. 

  62.   //Sanitize the Variables before MySQL Query
    63. 

  63. 	foreach($raw as $key => $val){
    64. 

  64. 		$safe[$key] = mysql_real_escape_string($val);
    65. 

  65. 	}
    66. 

  66.    	
    67. 

  67. 	//MySQL Query for Each Item
    68. 

  68. 	$query = "INSERT INTO e3_live(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}')";
    69. 

  69. 	mysql_query($query);
    70. 

  70. 

  71. }
    72. 

  72. 

  73. //Unset XML to Free Memory
    74. 

  74. unset($e3_live_xml);
    75. 

  75. 

  76. //Unset $livefeed to redo with no EndDate (related to a bug in getting items)
    77. 

  77. unset($livefeed);
    78. 

  78. 

  79. /*===============BEGIN LIVE DATABASE 2nd CREATION==================*/
    80. 

  80. 

  81. //Set URL for Live Feed
    82. 

  82. $livefeed = 'http://sports-ak.espn.go.com/espn3/feeds/live';
    83. 

  83. 

  84. //Get the XML Source of ESPN3 Live Feed
    85. 

  85. $xml = file_get_contents($livefeed);
    86. 

  86. $enc = mb_detect_encoding($xml);
    87. 

  87. $xml = mb_convert_encoding($xml, 'UTF-8', $enc);
    88. 

  88. $e3_live_xml = new SimpleXMLElement($xml);
    89. 

  89. unset($xml);
    90. 

  90. unset($enc);
    91. 

  91. 

  92. //Live Event Handling
    93. 

  93. foreach($e3_live_xml->event as $event) {
    94. 

  94. 	foreach($event as $event_id) {
    95. 

  95. 		$event_id_num = $event['id'];
    96. 

  96. 		$raw['idnum'] = trim($event_id_num);
    97. 

  97. 	}
    98. 

  98. 	unset($event_id);
    99. 

  99. 	foreach($event->name as $event_name) {
    100. 

  100. 		$raw['event'] = trim($event_name);
    101. 

  101. 	}
    102. 

  102. 	unset($event_name);
    103. 

  103. 	foreach($event->league as $event_league) {
    104. 

  104. 		$raw['league'] = trim($event_league);
    105. 

  105. 	}
    106. 

  106. 	unset($event_league);
    107. 

  107. 	foreach($event->sport as $event_sport) {
    108. 

  108. 		$raw['sport'] = trim($event_sport);
    109. 

  109. 	}
    110. 

  110. 	unset($event_sport);
    111. 

  111. 	foreach($event->startTime as $event_time) {
    112. 

  112. 		$time = trim($event_time);
    113. 

  113. 		$raw['date'] = date('Y-m-d', strtotime($time));
    114. 

  114. 		$raw['time'] = date('H:i:s', strtotime($time));
    115. 

  115. 	}
    116. 

  116. 	unset($event_time);
    117. 

  117. 	foreach($event->thumbnail->large as $event_thumb) {
    118. 

  118. 		$raw['thumb'] = trim($event_thumb);
    119. 

  119. 	}
    120. 

  120. 	unset($event_thumb);
    121. 

  121.    	
    122. 

  122.   //Sanitize the Variables before MySQL Query
    123. 

  123. 	foreach($raw as $key => $val){
    124. 

  124. 		$safe[$key] = mysql_real_escape_string($val);
    125. 

  125. 	}
    126. 

  126.    	
    127. 

  127. 	//MySQL Query for Each Item
    128. 

  128. 	$query = "INSERT INTO e3_live(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}')";
    129. 

  129. 	mysql_query($query);
    130. 

  130. 

  131. }
    132. 

  132. 

  133. //Unset XML to Free Memory
    134. 

  134. unset($e3_live_xml);
    135. 

  135. 

  136. /*===============BEGIN REPLAY DATABASE CREATION==================*/
    137. 

  137. 

  138. //Get the XML Source of ESPN3 Replay Feed
    139. 

  139. $xml = file_get_contents('http://sports-ak.espn.go.com/espn3/feeds/replay');
    140. 

  140. $enc = mb_detect_encoding($xml);
    141. 

  141. $xml = mb_convert_encoding($xml, 'UTF-8', $enc);
    142. 

  142. $e3_replay_xml = new SimpleXMLElement($xml);
    143. 

  143. unset($xml);
    144. 

  144. unset($enc);
    145. 

  145. 

  146. //Replay Event Handling
    147. 

  147. foreach($e3_replay_xml->event as $event) {
    148. 

  148. 	foreach($event as $event_id) {
    149. 

  149. 		$event_id_num = $event['id'];
    150. 

  150. 		$raw['idnum'] = trim($event_id_num);
    151. 

  151. 	}
    152. 

  152. 	unset($event_id);
    153. 

  153. 	foreach($event->name as $event_name) {
    154. 

  154. 		$raw['event'] = trim($event_name);
    155. 

  155. 	}
    156. 

  156. 	unset($event_name);
    157. 

  157. 	foreach($event->league as $event_league) {
    158. 

  158. 		$raw['league'] = trim($event_league);
    159. 

  159. 	}
    160. 

  160. 	unset($event_league);
    161. 

  161. 	foreach($event->sport as $event_sport) {
    162. 

  162. 		$raw['sport'] = trim($event_sport);
    163. 

  163. 	}
    164. 

  164. 	unset($event_sport);
    165. 

  165. 	foreach($event->startTime as $event_time) {
    166. 

  166. 		$time = trim($event_time);
    167. 

  167. 		$raw['date'] = date('Y-m-d', strtotime($time));
    168. 

  168. 		$raw['time'] = date('H:i:s', strtotime($time));
    169. 

  169. 	}
    170. 

  170. 	unset($event_time);
    171. 

  171. 	foreach($event->thumbnail->large as $event_thumb) {
    172. 

  172. 		$raw['thumb'] = trim($event_thumb);
    173. 

  173. 	}
    174. 

  174. 	unset($event_thumb);
    175. 

  175.    	
    176. 

  176.   //Sanitize the Variables before MySQL Query
    177. 

  177. 	foreach($raw as $key => $val){
    178. 

  178. 		$safe[$key] = mysql_real_escape_string($val);
    179. 

  179. 	}
    180. 

  180.    	
    181. 

  181. 	//MySQL Query for Each Item
    182. 

  182. 	$query = "INSERT INTO e3_replay(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}') ON DUPLICATE KEY UPDATE event='{$safe['event']}', league='{$safe['league']}', sport='{$safe['sport']}', time='{$safe['time']}', thumb='{$safe['thumb']}'";
    183. 

  183. 	mysql_query($query);
    184. 

  184. 

  185. }
    186. 

  186. 

  187. //Unset XML to Free Memory
    188. 

  188. unset($e3_replay_xml);
    189. 

  189. 

  190. /*===============BEGIN UPCOMING DATABASE CREATION==================*/
    191. 

  191. 

  192. //Get the XML Source of ESPN3 Upcoming Feed
    193. 

  193. $xml = file_get_contents('http://sports-ak.espn.go.com/espn3/feeds/upcoming');
    194. 

  194. $enc = mb_detect_encoding($xml);
    195. 

  195. $xml = mb_convert_encoding($xml, 'UTF-8', $enc);
    196. 

  196. $e3_upcoming_xml = new SimpleXMLElement($xml);
    197. 

  197. unset($xml);
    198. 

  198. unset($enc);
    199. 

  199. 

  200. //Upcoming Event Handling
    201. 

  201. foreach($e3_upcoming_xml->event as $event) {
    202. 

  202. 	foreach($event as $event_id) {
    203. 

  203. 		$event_id_num = $event['id'];
    204. 

  204. 		$raw['idnum'] = trim($event_id_num);
    205. 

  205. 	}
    206. 

  206. 	unset($event_id);
    207. 

  207. 	foreach($event->name as $event_name) {
    208. 

  208. 		$raw['event'] = trim($event_name);
    209. 

  209. 	}
    210. 

  210. 	unset($event_name);
    211. 

  211. 	foreach($event->league as $event_league) {
    212. 

  212. 		$raw['league'] = trim($event_league);
    213. 

  213. 	}
    214. 

  214. 	unset($event_league);
    215. 

  215. 	foreach($event->sport as $event_sport) {
    216. 

  216. 		$raw['sport'] = trim($event_sport);
    217. 

  217. 	}
    218. 

  218. 	unset($event_sport);
    219. 

  219. 	foreach($event->startTime as $event_time) {
    220. 

  220. 		$time = trim($event_time);
    221. 

  221. 		$raw['date'] = date('Y-m-d', strtotime($time));
    222. 

  222. 		$raw['time'] = date('H:i:s', strtotime($time));
    223. 

  223. 	}
    224. 

  224. 	unset($event_time);
    225. 

  225. 	foreach($event->thumbnail->large as $event_thumb) {
    226. 

  226. 		$raw['thumb'] = trim($event_thumb);
    227. 

  227. 	}
    228. 

  228. 	unset($event_thumb);
    229. 

  229.    	
    230. 

  230.   //Sanitize the Variables before MySQL Query
    231. 

  231. 	foreach($raw as $key => $val){
    232. 

  232. 		$safe[$key] = mysql_real_escape_string($val);
    233. 

  233. 	}
    234. 

  234.    	
    235. 

  235. 	//MySQL Query for Each Item
    236. 

  236. 	$query = "INSERT INTO e3_upcoming(fulldate, date, event_id, event, league, sport, time, thumb) VALUES(NOW(), DATE('{$safe['date']}'), '{$safe['idnum']}', '{$safe['event']}', '{$safe['league']}', '{$safe['sport']}', '{$safe['time']}', '{$safe['thumb']}') ON DUPLICATE KEY UPDATE event='{$safe['event']}', league='{$safe['league']}', sport='{$safe['sport']}', time='{$safe['time']}', thumb='{$safe['thumb']}'";
    237. 

  237. 	mysql_query($query);
    238. 

  238. 

  239. }
    240. 

  240. 

  241. //Unset XML to Free Memory
    242. 

  242. unset($e3_upcoming_xml);
    243. 

  243. 

  244. //MySQL Connection Close
    245. 

  245. mysql_close();
    246. 

  246. 

  247. ?>
    248.