صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
GasteizkoMargolariak
/
GMWeb
2
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: d6d17f64d1
شاخه‌ها تگ‌ها
GMWeb
/
www
/
index.php

index.php 29 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477 
  1. <?php
    2. 

  2. 	session_start();
    3. 

  3. 	#$proto = $_SERVER['SERVER_PROTOCOL'];
    4. 

  4. 	#$proto = strtolower(substr($_SERVER["SERVER_PROTOCOL"],0,strpos( $_SERVER["SERVER_PROTOCOL"],'/'))).'://';
    5. 

  5. 	$http_host = $_SERVER['HTTP_HOST'];
    6. 

  6. 	include("functions.php");
    7. 

  7. 	$proto = getProtocol();
    8. 

  8. 	$con = startdb();
    9. 

  9. 	
    10. 

  10. 	//Language
    11. 

  11. 	$lang = selectLanguage();
    12. 

  12. 	include("lang/lang_" . $lang . ".php");
    13. 

  13. 	
    14. 

  14. 	$cur_section = $lng['section_home'];
    15. 

  15. ?>
    16. 

  16. <!DOCTYPE html>
    17. 

  17. <html>
    18. 

  18. 	<head>
    19. 

  19. 		<meta content="text/html; charset=utf-8" http-equiv="content-type"/>
    20. 

  20. 		<meta charset="utf-8"/>
    21. 

  21. 		<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1">
    22. 

  22. 		<title><?php echo $lng['index_title'];?></title>
    23. 

  23. 		<link rel="shortcut icon" href="<?php echo "$proto$http_host/img/logo/favicon.ico";?>">
    24. 

  24. 		<!-- CSS files -->
    25. 

  25. 		<style>
    26. 

  26. 			<?php 
    27. 

  27. 				include("css/ui.css"); 
    28. 

  28. 				include("css/index.css");
    29. 

  29. 			?>
    30. 

  30. 		</style>
    31. 

  31. 		<!-- CSS for mobile version -->
    32. 

  32. 		<style media="(max-width : 990px)">
    33. 

  33. 			<?php 
    34. 

  34. 				include("css/m/ui.css"); 
    35. 

  35. 				include("css/m/index.css");
    36. 

  36. 			?>
    37. 

  37. 		</style>
    38. 

  38. 		<!-- Script files -->
    39. 

  39. 		<script type="text/javascript">
    40. 

  40. 			<?php include("script/ui.js"); ?>
    41. 

  41. 		</script>
    42. 

  42. 		<!-- Meta tags -->
    43. 

  43. 		<link rel="canonical" href="<?php echo "$proto$http_host"; ?>"/>
    44. 

  44. 		<link rel="author" href="<?php echo "$proto$http_host"; ?>"/>
    45. 

  45. 		<link rel="publisher" href="<?php echo "$proto$http_host"; ?>"/>
    46. 

  46. 		<meta name="description" content="<?php echo $lng['index_us_content'];?>"/>
    47. 

  47. 		<meta property="og:title" content="<?php echo $lng['index_title'];?>"/>
    48. 

  48. 		<meta property="og:url" content="<?php echo "$proto$http_host"; ?>"/>
    49. 

  49. 		<meta property="og:description" content="<?php echo $lng['index_us_content'];?>"/>
    50. 

  50. 		<meta property="og:image" content="<?php echo "$proto$http_host/img/logo/logo.png";?>"/>
    51. 

  51. 		<meta property="og:site_name" content="<?php echo $lng['index_title'];?>"/>
    52. 

  52. 		<meta property="og:type" content="website"/>
    53. 

  53. 		<meta property="og:locale" content="<?php echo $lang; ?>"/>
    54. 

  54. 		<meta name="twitter:card" content="summary"/>
    55. 

  55. 		<meta name="twitter:title" content="<?php echo $lng['index_title'];?>"/>
    56. 

  56. 		<meta name="twitter:description" content="<?php echo $lng['index_us_content'];?>"/>
    57. 

  57. 		<meta name="twitter:image" content="<?php echo "$proto$http_host/img/logo/logo.png";?>"/>
    58. 

  58. 		<meta name="twitter:url" content="<?php echo"$proto$http_host"; ?>"/>
    59. 

  59. 		<meta name="robots" content="index follow"/>
    60. 

  60. 	</head>
    61. 

  61. 	<body>
    62. 

  62. 		<?php include("header.php"); ?>
    63. 

  63. 		<div id="content">
    64. 

  64. 			<?php
    65. 

  65. 				//Festivals section
    66. 

  66. 				$year = date("Y");
    67. 

  67. 				$q_settings = mysqli_query($con, "SELECT value FROM settings WHERE name = 'festivals';");
    68. 

  68. 				$r_settings = mysqli_fetch_array($q_settings);
    69. 

  69. 				$festivals = $r_settings['value'];
    70. 

  70. 				if ($festivals == 1){
    71. 

  71. 					echo "<div class='section' id='festivales' itemscope itemtype='$protoschema.org/Event'>\n";
    72. 

  72. 					echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    73. 

  73. 					echo "<meta itemprop='name' content='$lng[index_festivals_header] $year'/>\n";
    74. 

  74. 					echo "<meta itemprop='description' content='$lng[index_festivals_header] $year'/>\n";
    75. 

  75. 					echo "<meta itemprop='startDate' content='$year-08-04'/>\n";
    76. 

  76. 					echo "<meta itemprop='endDate' content='$year-08-09'/>\n";
    77. 

  77. 					echo "<meta itemprop='url' content='$proto$http_host/lablanca/'/>\n";
    78. 

  78. 					echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' itemprop='name' content='Vitoria-Gasteiz'/></span>\n");
    79. 

  79. 					echo "<h3 class='section_title'>$lng[index_festivals_header] $year</h3>\n";
    80. 

  80. 					echo "<table class='festival_section_table'><tr>\n";
    81. 

  81. 					
    82. 

  82. 					//Summary
    83. 

  83. 					$q_festivals = mysqli_query($con, "SELECT text_$lang AS text, summary_$lang AS summary, img FROM festival WHERE year = $year;");
    84. 

  84. 					if(mysqli_num_rows($q_festivals)){
    85. 

  85. 						echo "<td><div class='entry' id='festivals_summary'>\n";
    86. 

  86. 						$r_festivals = mysqli_fetch_array($q_festivals);
    87. 

  87. 						if ($r_festivals['img'] != ''){
    88. 

  88. 							echo "<meta itemprop='image' content='$proto$http_host/img/fiestas/$r_festivals[img]'/>\n";
    89. 

  89. 							echo "<img id='festivals_image' alt=' ' src='$proto$http_host/img/fiestas/$r_festivals[img]'/>\n";
    90. 

  90. 						}
    91. 

  91. 						if ($r_festivals['summary'] != ''){
    92. 

  92. 							echo "<span class='entry_title' id='festivals_summary_text'><br/>$r_festivals[summary]</span>\n";
    93. 

  93. 							echo "<br/><br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='$proto$http_host/lablanca/'>$lng[index_festivals_link]</a>\n";
    94. 

  94. 						}
    95. 

  95. 						else{
    96. 

  96. 							echo "<span id='festivals_summary_text'><br/>" . cutText($r_festivals['text'], 300, "$lng[index_read_more]", "$proto$http_host/lablanca/") . "</span>\n";
    97. 

  97. 							//echo "<br/><br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='$proto$http_host/lablanca/'>$lng[index_festivals_link]</a>\n";
    98. 

  98. 						}
    99. 

  99. 						echo "</div></td>\n";
    100. 

  100. 					}
    101. 

  101. 					
    102. 

  102. 					
    103. 

  103. 					//Location
    104. 

  104. 					$q_location = mysqli_query($con, "SELECT lat, lon FROM location WHERE action = 'report' AND dtime > NOW() - INTERVAL 30 MINUTE ORDER BY dtime DESC LIMIT 1;");
    105. 

  105. 					if (mysqli_num_rows($q_location) > 0){
    106. 

  106. 						$r_location = mysqli_fetch_array($q_location);
    107. 

  107. 						echo "<td><div class='entry' id='festival_entry_map'>\n";
    108. 

  108. 						echo "<h3 class='entry_title'>$lng[index_festivals_location]</h3>\n";
    109. 

  109. 						echo "<iframe src='https://www.google.com/maps/embed/v1/place?key=AIzaSyCZHP7t2on_G3eyyoCTfhGAlDx1mJnX7iI&q=$r_location[lat],$r_location[lon]' allowfullscreen></iframe>\n";
    110. 

  110. 						echo "</div>\n";
    111. 

  111. 					}
    112. 

  112. 					
    113. 

  113. 					echo "</tr></table>\n";
    114. 

  114. 					echo "<table class='festival_section_table'><tr>\n";
    115. 

  115. 					
    116. 

  116. 					//GM schedule
    117. 

  117. 					$q_sch_curr = mysqli_query($con, "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, DATE_FORMAT(start, '%Y-%m-%dT%H:%i:00') AS isostart, DATE_FORMAT(end, '%Y-%m-%dT%H:%i:00') AS isoend, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 1 AND start > NOW() - INTERVAL 45 MINUTE AND start < NOW() + INTERVAL 30 MINUTE ORDER BY start LIMIT 1;");
    118. 

  118. 					$q_sch_next = mysqli_query($con, "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, DATE_FORMAT(start, '%Y-%m-%dT%H:%i:00') AS isostart, DATE_FORMAT(end, '%Y-%m-%dT%H:%i:00') AS isoend, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 1 AND start > NOW() AND start < NOW() + INTERVAL 240 MINUTE ORDER BY start LIMIT 1;");
    119. 

  119. 					if (mysqli_num_rows($q_sch_curr) > 0 || mysqli_num_rows($q_sch_next) > 0){
    120. 

  120. 						echo "<td><div class='entry festival_schedule'>\n";
    121. 

  121. 						echo "<h3 class='entry_title'>$lng[index_festivals_gm_schedule]</h3>\n";
    122. 

  122. 					
    123. 

  123. 						if (mysqli_num_rows($q_sch_curr) > 0){
    124. 

  124. 							$r_sch_curr = mysqli_fetch_array($q_sch_curr);
    125. 

  125. 							echo "<div id='festival_event' itemprop='subEvent' itemscope itemtype='http://schema.org/Event'><h4>$lng[index_festivals_schedule_now]</h4>\n";
    126. 

  126. 							echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    127. 

  127. 							echo "<meta itemprop='name' content='$r_sch_curr[title]'/>\n";
    128. 

  128. 							echo "<meta itemprop='startDate' content='$r_sch_curr[isostart]'/>\n";
    129. 

  129. 							if (strlen($r_sch_curr['isoend']) > 0){
    130. 

  130. 								echo "<meta itemprop='endDate' content='$r_sch_curr[isoend]'/>\n";
    131. 

  131. 							}
    132. 

  132. 							echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' content='Vitoria-Gasteiz'/><span>\n");
    133. 

  133. 							echo "<span class='title'>$r_sch_curr[title]\n</span>";
    134. 

  134. 							if (strlen($r_sch_curr["description"]) > 0 && $r_sch_curr["description"] != $r_sch_curr["title"]){
    135. 

  135. 								echo "<br/><span class='description'>$r_sch_curr[description]</span>\n";
    136. 

  136. 								echo "<meta itemprop='description' content='$r_sch_curr[description]'/>\n";
    137. 

  137. 							}
    138. 

  138. 							echo "<table class='location'><tr>\n";
    139. 

  139. 							echo "<td><a target='_blank' href='http://maps.google.com/maps?q=$r_sch_curr[lat],$r_sch_curr[lon]+(My+Point)&z=14&ll=$r_sch_curr[lat],$r_sch_curr[lon]'><img alt=' ' src='$proto$http_host/img/misc/pinpoint.png'/></a></td>\n"; 
    140. 

  140. 							//If name and address are the same, show only name
    141. 

  141. 							if ($r_sch_curr['place'] == $r_sch_curr['address']){
    142. 

  142. 								echo "<td>$r_sch_curr[place]</td></tr></table>\n";
    143. 

  143. 							}
    144. 

  144. 							else{
    145. 

  145. 								echo "<td>$r_sch_curr[place] <span class='address'>- $r_sch_curr[address]</span></td></tr></table>\n";
    146. 

  146. 							}
    147. 

  147. 							echo "</div\n>";
    148. 

  148. 						}
    149. 

  149. 						
    150. 

  150. 						if (mysqli_num_rows($q_sch_next) > 0){
    151. 

  151. 							$r_sch_next = mysqli_fetch_array($q_sch_next);
    152. 

  152. 							echo "<div id='festival_event' itemprop='subEvent' itemscope itemtype='http://schema.org/Event'><h4>$lng[index_festivals_schedule_next]</h4>\n";
    153. 

  153. 							echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    154. 

  154. 							echo "<meta itemprop='name' content='$r_sch_next[title]'/>\n";
    155. 

  155. 							echo "<meta itemprop='startDate' content='$r_sch_next[isostart]'/>\n";
    156. 

  156. 							if (strlen($r_sch_curr['isoend']) > 0){
    157. 

  157. 								echo "<meta itemprop='endDate' content='$r_sch_next[isoend]'/>\n";
    158. 

  158. 							}
    159. 

  159. 							echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' itemprop='name'>Vitoria-Gasteiz</meta></span>\n");
    160. 

  160. 							echo "<span class='title'>$r_sch_next[title] - $r_sch_next[st]\n</span>";
    161. 

  161. 							if (strlen($r_sch_next["description"]) > 0 && $r_sch_next["description"] != $r_sch_next["title"]){
    162. 

  162. 								echo "<br/><span class='description'>$r_sch_next[description]</span>\n";
    163. 

  163. 								echo "<meta itemprop='description' content='$r_sch_next[description]'/>\n";
    164. 

  164. 							}
    165. 

  165. 							echo "<table class='location'><tr>\n";
    166. 

  166. 							echo "<td><a target='_blank' href='http://maps.google.com/maps?q=$r_sch_next[lat],$r_sch_next[lon]+(My+Point)&z=14&ll=$r_sch_next[lat],$r_sch_next[lon]'><img alt=' ' src='$proto$http_host/img/misc/pinpoint.png'/></a></td>\n"; 
    167. 

  167. 							//If name and address are the same, show only name
    168. 

  168. 							if ($r_sch_next['place'] == $r_sch_next['address']){
    169. 

  169. 								echo "<td>$r_sch_next[place]</td></tr></table>\n";
    170. 

  170. 							}
    171. 

  171. 							else{
    172. 

  172. 								echo "<td>$r_sch_next[place] <span class='address'>- $r_sch_next[address]</span></td></tr></table>\n";
    173. 

  173. 							}
    174. 

  174. 							echo "</div\n>";
    175. 

  175. 						}
    176. 

  176. 						echo "</div></td>\n"; //close gm schedule entry;
    177. 

  177. 					}
    178. 

  178. 										
    179. 

  179. 					//city schedule
    180. 

  180. 					$q_sch_curr = mysqli_query($con, "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, DATE_FORMAT(start, '%Y-%m-%dT%H:%i:00') AS isostart, DATE_FORMAT(end, '%Y-%m-%dT%H:%i:00') AS isoend, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 0 AND start > NOW() - INTERVAL 45 MINUTE AND start < NOW() + INTERVAL 30 MINUTE ORDER BY start LIMIT 1;");
    181. 

  181. 					$q_sch_next = mysqli_query($con, "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, DATE_FORMAT(start, '%Y-%m-%dT%H:%i:00') AS isostart, DATE_FORMAT(end, '%Y-%m-%dT%H:%i:00') AS isoend, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 0 AND start > NOW() AND start < NOW() + INTERVAL 240 MINUTE ORDER BY start LIMIT 1;");
    182. 

  182. 					if (mysqli_num_rows($q_sch_curr) > 0 || mysqli_num_rows($q_sch_next) > 0){
    183. 

  183. 						echo "<td><div class='entry festival_schedule' >\n";
    184. 

  184. 						echo "<h3 class='entry_title'>$lng[index_festivals_city_schedule]</h3>\n";
    185. 

  185. 					
    186. 

  186. 						if (mysqli_num_rows($q_sch_curr) > 0){
    187. 

  187. 							$r_sch_curr = mysqli_fetch_array($q_sch_curr);
    188. 

  188. 							echo "<div class='festival_event' itemprop='subEvent' itemscope itemtype='http://schema.org/Event'><h4>$lng[index_festivals_schedule_now]</h4>\n";
    189. 

  189. 							echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    190. 

  190. 							echo "<meta itemprop='name' content='$r_sch_curr[title]'/>\n";
    191. 

  191. 							echo "<meta itemprop='startDate' content='$r_sch_curr[isostart]'/>\n";
    192. 

  192. 							if (strlen($r_sch_curr['isoend']) > 0){
    193. 

  193. 								echo "<meta itemprop='endDate' content='$r_sch_curr[isoend]'/>\n";
    194. 

  194. 							}
    195. 

  195. 							echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' itemprop='name'>Vitoria-Gasteiz</meta></span>\n");
    196. 

  196. 							echo "<span class='title'>$r_sch_curr[title]\n</span>";
    197. 

  197. 							if (strlen($r_sch_curr["description"]) > 0 && $r_sch_curr["description"] != $r_sch_curr["title"]){
    198. 

  198. 								echo "<br/><span class='description'>$r_sch_curr[description]</span>\n";
    199. 

  199. 								echo "<meta itemprop='description' content='$r_sch_curr[description]'/>\n";
    200. 

  200. 							}
    201. 

  201. 							echo "<table class='location'><tr>\n";
    202. 

  202. 							echo "<td><a target='_blank' href='http://maps.google.com/maps?q=$r_sch_curr[lat],$r_sch_curr[lon]+(My+Point)&z=14&ll=$r_sch_curr[lat],$r_sch_curr[lon]'><img alt=' ' src='$proto$http_host/img/misc/pinpoint.png'/></a></td>\n"; 
    203. 

  203. 							//If name and address are the same, show only name
    204. 

  204. 							if ($r_sch_curr['place'] == $r_sch_curr['address']){
    205. 

  205. 								echo "<td>$r_sch_curr[place]</td></tr></table>\n";
    206. 

  206. 							}
    207. 

  207. 							else{
    208. 

  208. 								echo "<td>$r_sch_curr[place] <span class='address'>- $r_sch_curr[address]</span></td></tr></table>\n";
    209. 

  209. 							}
    210. 

  210. 							echo "</div\n>";
    211. 

  211. 						}
    212. 

  212. 						
    213. 

  213. 						if (mysqli_num_rows($q_sch_next) > 0){
    214. 

  214. 							$r_sch_next = mysqli_fetch_array($q_sch_next);
    215. 

  215. 							echo "<div class='festival_event' itemprop='subEvent' itemscope itemtype='http://schema.org/Event'><h4>$lng[index_festivals_schedule_next]</h4>\n";
    216. 

  216. 							echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    217. 

  217. 							echo "<meta itemprop='name' content='$r_sch_next[title]'/>\n";
    218. 

  218. 							echo "<meta itemprop='startDate' content='$r_sch_next[isostart]'/>\n";
    219. 

  219. 							if (strlen($r_sch_curr['isoend']) > 0){
    220. 

  220. 								echo "<meta itemprop='endDate' content='$r_sch_next[isoend]'/>\n";
    221. 

  221. 							}
    222. 

  222. 							echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' itemprop='name'>Vitoria-Gasteiz</meta></span>\n");
    223. 

  223. 							echo "<span class='title'>$r_sch_next[title] - ($r_sch_next[st])\n</span>";
    224. 

  224. 							if (strlen($r_sch_next["description"]) > 0 && $r_sch_next["description"] != $r_sch_next["title"]){
    225. 

  225. 								echo "<br/><span class='description'>$r_sch_next[description]</span>\n";
    226. 

  226. 								echo "<meta itemprop='description' content='$r_sch_next[description]'/>\n";
    227. 

  227. 							}
    228. 

  228. 							echo "<table class='location'><tr>\n";
    229. 

  229. 							echo "<td><a target='_blank' href='http://maps.google.com/maps?q=$r_sch_next[lat],$r_sch_next[lon]+(My+Point)&z=14&ll=$r_sch_next[lat],$r_sch_next[lon]'><img alt=' ' src='$proto$http_host/img/misc/pinpoint.png'/></a></td>\n"; 
    230. 

  230. 							//If name and address are the same, show only name
    231. 

  231. 							if ($r_sch_next['place'] == $r_sch_next['address']){
    232. 

  232. 								echo "<td>$r_sch_next[place]</td></tr></table>\n";
    233. 

  233. 							}
    234. 

  234. 							else{
    235. 

  235. 								echo "<td>$r_sch_next[place] <span class='address'>- $r_sch_next[address]</span></td></tr></table>\n";
    236. 

  236. 							}
    237. 

  237. 							echo "</div\n>";
    238. 

  238. 						}
    239. 

  239. 						echo "</div></td>\n"; //close city schedule entry;
    240. 

  240. 					}
    241. 

  241. 					echo "</tr></table>\n";
    242. 

  242. 					echo "<a class='go_to_section' href='$proto$http_host/lablanca/'>$lng[index_festivals_link]</a><br/>\n";
    243. 

  243. 					echo "</div>\n";
    244. 

  244. 				}
    245. 

  245. 			
    246. 

  246. 				//Upcaming activity section
    247. 

  247. 				$q_activity = mysqli_query($con, "SELECT id, permalink, date, DATE_FORMAT(date, '%Y-%m-%d') AS isodate, title_$lang AS title, text_$lang AS text, price, inscription, people, max_people, city FROM activity WHERE visible = 1 AND date > now() ORDER BY date LIMIT 1;");
    248. 

  248. 				$upcoming_activity_shown = false;
    249. 

  249. 				if (mysqli_num_rows($q_activity) > 0){
    250. 

  250. 					$upcoming_activity_shown = true;
    251. 

  251. 					$r_activity = mysqli_fetch_array($q_activity);
    252. 

  252. 					echo "<div class='section'>\n";
    253. 

  253. 					echo "<h3 class='section_title'>$lng[index_upcoming_activity]</h3>\n";
    254. 

  254. 					echo "<div class='entry' itemscope itemtype='http://schema.org/Event'>\n";
    255. 

  255. 					echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    256. 

  256. 					echo "<meta itemprop='name' content='$r_activity[title]'/>\n";
    257. 

  257. 					echo "<meta itemprop='description' content='$r_activity[text]'/>\n";
    258. 

  258. 					echo "<meta itemprop='startDate endDate' content='$r_activity[isodate]'/>\n";
    259. 

  259. 					echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' itemprop='name' content='$r_activity[city]'/></span>\n");
    260. 

  260. 					echo "<meta itemprop='url' content='$proto$http_host/actividades/$r_activity[permalink]'/>\n";
    261. 

  261. 					echo "<div class='hidden' itemprop='organizer' itemscope itemtype='http://schema.org/Organization'>\n";
    262. 

  262. 					echo "<meta itemprop='legalName' content='Asociaci&oacute;n Cultural Recreativa Gasteizko Margolariak'/>\n";
    263. 

  263. 					echo "<meta itemprop='name' content='Gasteizko Margolariak'/>\n";
    264. 

  264. 					echo "<meta itemprop='logo' content='$proto$http_host/img/logo/logo.png'/>\n";
    265. 

  265. 					echo "<meta itemprop='foundingDate' content='2013-02-03'/>\n";
    266. 

  266. 					echo "<meta itemprop='telephone' content='+34637140371'/>\n";
    267. 

  267. 					echo "</div>\n";
    268. 

  268. 					echo "<div id='upcoming_activity' class='table'><div class='tr'>\n";
    269. 

  269. 					
    270. 

  270. 					//If image, show it
    271. 

  271. 					$q_activity_image = mysqli_query($con, "SELECT image FROM activity_image WHERE activity = $r_activity[id] ORDER BY idx LIMIT 1;");
    272. 

  272. 					if (mysqli_num_rows($q_activity_image) > 0){
    273. 

  273. 						$r_activity_image = mysqli_fetch_array($q_activity_image);
    274. 

  274. 						echo "<div class='td'><div id='upcoming_image'>\n";
    275. 

  275. 						echo "<a href='$proto$http_host/actividades/$r_activity[permalink]'>\n";
    276. 

  276. 						echo "<meta itemprop='image' content='$proto$http_host/img/actividades/$r_activity_image[image]'/>\n";
    277. 

  277. 						echo "<img src='$proto$http_host/img/actividades/miniature/$r_activity_image[image]' alt='$r_activity[title]'/>\n";
    278. 

  278. 						echo "</a>\n";
    279. 

  279. 						echo "</div></div>\n";
    280. 

  280. 					}
    281. 

  281. 					echo "<div class='td'><div id='upcoming_text'>\n";
    282. 

  282. 					echo "<h3 class='entry_title'><a itemprop='url' href='$proto$http_host/actividades/$r_activity[permalink]'>$r_activity[title]</a></h3>\n";
    283. 

  283. 					echo "<p>". cutText($r_activity['text'], 250, "$lng[index_read_more]", "$http_host/actividades/$r_activity[permalink]") . "</p>\n";
    284. 

  284. 					echo "</div></div>\n";
    285. 

  285. 					echo "<div class='td'><div id='upcoming_details'>\n";
    286. 

  286. 					echo "<table>\n";
    287. 

  287. 					echo "<tr><td>\n";
    288. 

  288. 					echo "$lng[index_upcoming_activity_date]</td><td>" . formatDate($r_activity['date'], $lang, false) . "\n";
    289. 

  289. 					echo "</td></tr>\n";
    290. 

  290. 					echo "<tr>\n";
    291. 

  291. 					echo "<td>$lng[index_upcoming_activity_price]</td>";
    292. 

  292. 					if ($r_activity['price'] == 0){
    293. 

  293. 						echo "<td itemprop='offers' itemscope itemtype='http://schema.org/Offer'>$lng[index_upcoming_activity_free]\n";
    294. 

  294. 						echo "<meta itemprop='priceCurrency' content='EUR'/><meta itemprop='price' content='0'/><meta itemprop='url' content='$proto$http_host/actividades/$r_activity[permalink]'/>\n</td>\n";
    295. 

  295. 						echo "</tr><tr>\n";
    296. 

  296. 						echo "<td>$lng[index_upcoming_activity_inscription]</td>";
    297. 

  297. 						if ($r_activity['inscription'] == 1)
    298. 

  298. 							echo "<td>$lng[yes]</td>\n";
    299. 

  299. 						else
    300. 

  300. 							echo "<td>$lng[no]</td>\n";
    301. 

  301. 					}
    302. 

  302. 					else{
    303. 

  303. 						echo "<td itemprop='offers' itemscope itemtype='http://schema.org/Offer'>$r_activity[price] €\n";
    304. 

  304. 						echo "<meta itemprop='priceCurrency' content='EUR'/><meta itemprop='price' content='$r_activity[price]'/></td>\n";
    305. 

  305. 					}
    306. 

  306. 					echo "</tr>\n";
    307. 

  307. 					if ($r_activity['max_people'] > 0){
    308. 

  308. 						echo "<tr><td>$lng[index_upcoming_activity_max_people]</td><td>$r_activity[max_people]</td></tr>\n";
    309. 

  309. 					}
    310. 

  310. 					echo "</table>\n";
    311. 

  311. 					echo "<a href='$proto$http_host/actividades/$r_activity[permalink]'>$lng[index_upcoming_activity_see]</a><br/><br/>\n";
    312. 

  312. 					
    313. 

  313. 					echo "</div></div></div></div>\n";
    314. 

  314. 					echo "</div>\n";//Entry
    315. 

  315. 					echo "<a class='go_to_section' href='$proto$http_host/actividades/'>$lng[index_upcoming_activity_see_all]</a><br/>\n";
    316. 

  316. 					echo "</div>\n";//Section
    317. 

  317. 				}
    318. 

  318. 			?>
    319. 

  319. 			<div class='section' itemscope itemtype='http://schema.org/Organization'>
    320. 

  320. 				<meta itemprop='url' content='<?php echo("$proto$http_host"); ?>'/>
    321. 

  321. 				<h3 class='section_title' itemprop='name'><?php echo($lng['index_us']); ?></h3>
    322. 

  322. 				<div class='entry' id='us'>
    323. 

  323. 					<p itemprop='description'><?php echo($lng['index_us_content']); ?></p>
    324. 

  324. 					<div><img itemprop='logo' src='<?php echo("$proto$http_host/img/logo/GasteizkoMargolariak.png"); ?>'/></div>
    325. 

  325. 				</div>
    326. 

  326. 				<a class='go_to_section' href='<?php echo($proto.$http_host); ?>/nosotros/'><?php echo($lng['index_us_more']) ?></a>
    327. 

  327. 				<br/>
    328. 

  328. 			</div>
    329. 

  329. 			<div id='content_table'>
    330. 

  330. 				<div class='content_row'>
    331. 

  331. 					<div class='content_cell' id='cell_posts'>
    332. 

  332. 						<div class='section' id='latest_posts'>
    333. 

  333. 							<?php
    334. 

  334. 								echo "<h3 class='section_title'>$lng[index_latest_posts]</h3>\n";
    335. 

  335. 								$q_post = mysqli_query($con, "SELECT id, permalink, title_$lang AS title, text_$lang AS text, dtime, DATE_FORMAT(dtime, '%Y-%m-%dT%T') AS isodate FROM post WHERE visible = 1 ORDER BY dtime DESC LIMIT 2;");
    336. 

  336. 								if (mysqli_num_rows($q_post) == 0){
    337. 

  337. 									echo "<div class='entry'><h3 class='entry_title'>$lng[index_no_post]</div>\n";
    338. 

  338. 								}
    339. 

  339. 								else{
    340. 

  340. 									while ($r_post = mysqli_fetch_array($q_post)){
    341. 

  341. 										echo "<div class='entry post' itemscope itemtype='http://schema.org/BlogPosting'>\n";
    342. 

  342. 										echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    343. 

  343. 										echo "<meta itemprop='datePublished dateModified' content='$r_post[isodate]'/>\n";
    344. 

  344. 										echo "<meta itemprop='headline name' content='$r_post[title]'/>\n";
    345. 

  345. 										echo "<meta itemprop='articleBody text' content='$r_post[text]'/>\n";
    346. 

  346. 										echo "<meta itemprop='mainEntityOfPage' content='$proto$http_host'/>\n";
    347. 

  347. 										echo "<div class='hidden' itemprop='author publisher' itemscope itemtype='http://schema.org/Organization'>\n";
    348. 

  348. 										echo "<meta itemprop='legalName' content='Asociaci&oacute;n Cultural Recreativa Gasteizko Margolariak'/>\n";
    349. 

  349. 										echo "<meta itemprop='name' content='Gasteizko Margolariak'/>\n";
    350. 

  350. 										echo "<meta itemprop='logo' content='$proto$http_host/img/logo/logo.png'/>\n";
    351. 

  351. 										echo "<meta itemprop='foundingDate' content='03-02-2013'/>\n";
    352. 

  352. 										echo "<meta itemprop='telephone' content='+34637140371'/>\n";
    353. 

  353. 										echo "<meta itemprop='url' content='$proto$http_host'/>\n";
    354. 

  354. 										echo "</div>\n";
    355. 

  355. 										$q_post_image = mysqli_query($con, "SELECT image FROM post_image WHERE post = $r_post[id] ORDER BY idx LIMIT 1;");
    356. 

  356. 										if (mysqli_num_rows($q_post_image) > 0){
    357. 

  357. 											$r_post_image = mysqli_fetch_array($q_post_image);
    358. 

  358. 											echo "<meta itemprop='image' content='$proto$http_host/img/blog/preview/$r_post_image[image]'/>\n";
    359. 

  359. 											echo "<a href='$proto$http_host/blog/$r_post[permalink]'><img src='$proto$http_host/img/blog/miniature/$r_post_image[image]'/></a>\n";
    360. 

  360. 										}
    361. 

  361. 										echo "<h3 class='entry_title'><a itemprop='url' href='$proto$http_host/blog/$r_post[permalink]'>$r_post[title]</a></h3>\n";
    362. 

  362. 										echo "<p>". cutText($r_post['text'], 100, "$lng[index_read_more]", "$proto$http_host/blog/$r_post[permalink]") . "</p>\n";
    363. 

  363. 										echo "<span>" . formatDate($r_post['dtime'], $lang, false) . "</span>\n";
    364. 

  364. 										echo "</div>\n";
    365. 

  365. 									}
    366. 

  366. 								echo "<a class='go_to_section' href='$proto$http_host/blog/'>$lng[index_see_all_posts]</a><br/>\n";
    367. 

  367. 								}
    368. 

  368. 							?>
    369. 

  369. 						</div>
    370. 

  370. 					</div>
    371. 

  371. 					<div class='content_cell' id='cell_photos'>
    372. 

  372. 						<div class='section' id='latest_photos'>
    373. 

  373. 							<?php
    374. 

  374. 								echo "<h3 class='section_title'>$lng[index_latest_photos]</h3>\n";
    375. 

  375. 								$q_photos = mysqli_query($con, "SELECT id, file, title_$lang AS title, DATE_FORMAT(uploaded, '%Y-%m-%d') AS isodate FROM photo ORDER BY uploaded DESC LIMIT 6;");
    376. 

  376. 								//TODO WHERE approved = 1
    377. 

  377. 								if (mysqli_num_rows($q_photos) == 0){
    378. 

  378. 									echo "<div class='entry'>$lng[index_no_photos]</div>\n";
    379. 

  379. 								}
    380. 

  380. 								else{
    381. 

  381. 									echo "<div class='entry'>\n";
    382. 

  382. 									echo "<table id='table_photos'>\n";
    383. 

  383. 									echo "<tr>\n";
    384. 

  384. 									$i = 0;
    385. 

  385. 									while ($r_photos = mysqli_fetch_array($q_photos)){
    386. 

  386. 										$q_album = mysqli_query($con, "select permalink from album, photo_album WHERE photo = $r_photos[id] AND id = album LIMIT 1;");
    387. 

  387. 										$r_album = mysqli_fetch_array($q_album);
    388. 

  388. 										echo "<td itemscope itemtype='http://schema.org/Photograph'>\n";
    389. 

  389. 										echo "<meta itemprop='datePublished' content='$r_photos[isodate]'/>\n";
    390. 

  390. 										echo "<a href='$proto$http_host/galeria/$r_album[permalink]'>\n";
    391. 

  391. 										echo "<meta itemprop='image' content='http://$http_host/img/galeria/$r_photos[file]'/>\n";
    392. 

  392. 										echo "<img src='$proto$http_host/img/galeria/miniature/$r_photos[file]' alt='$r_photos[title]' /></a></td>\n";
    393. 

  393. 										$i ++;
    394. 

  394. 										if ($i % 2 == 0)
    395. 

  395. 										echo "</tr><tr>";
    396. 

  396. 									}
    397. 

  397. 									echo "</tr>\n";
    398. 

  398. 									echo "</table>\n";
    399. 

  399. 									echo "</div>\n";
    400. 

  400. 									echo "<a class='go_to_section' href='$proto$http_host/galeria/'>$lng[index_see_all_photos]</a><br/>\n";
    401. 

  401. 								}
    402. 

  402. 							?>
    403. 

  403. 						</div>
    404. 

  404. 					</div>
    405. 

  405. 				</div>
    406. 

  406. 			</div>
    407. 

  407. 			<?php
    408. 

  408. 				if ($upcoming_activity_shown == false){
    409. 

  409. 					$q_activity = mysqli_query($con, "SELECT id, permalink, date, DATE_FORMAT(date, '%Y-%m-%d') AS isodate, title_$lang AS title, text_$lang AS text, after_$lang AS after, price, inscription, people, max_people, city FROM activity WHERE visible = 1 ORDER BY date DESC LIMIT 2;");
    410. 

  410. 					if (mysqli_num_rows($q_activity) > 0){
    411. 

  411. 						echo "<div class='section' id='latest_activities'>\n";
    412. 

  412. 						echo "<h3 class='section_title'>$lng[index_latest_activities]</h3>\n";
    413. 

  413. 						while ($r_activity = mysqli_fetch_array($q_activity)){
    414. 

  414. 							echo "<div class='entry' itemscope itemtype='http://schema.org/Event'>\n";
    415. 

  415. 							echo "<meta itemprop='inLanguage' content='$lang'/>\n";
    416. 

  416. 							echo "<meta itemprop='name' content='$r_activity[title]'/>\n";
    417. 

  417. 							echo "<meta itemprop='description' content='$r_activity[text]'/>\n";
    418. 

  418. 							echo "<meta itemprop='startDate endDate' content='$r_activity[isodate]'/>\n";
    419. 

  419. 							echo("<span class='hidden' itemprop='location' itemscope itemtype='http://schema.org/Place'><meta itemprop='address' itemprop='name' content='$r_activity[city]'/><meta itemprop='name' content='$r_activity[city]'/></span>\n");
    420. 

  420. 							echo "<div class='hidden' itemprop='organizer' itemscope itemtype='http://schema.org/Organization'>\n";
    421. 

  421. 							echo "<meta itemprop='legalName' content='Asociaci&oacute;n Cultural Recreativa Gasteizko Margolariak'/>\n";
    422. 

  422. 							echo "<meta itemprop='name' content='Gasteizko Margolariak'/>\n";
    423. 

  423. 							echo "<meta itemprop='logo' content='$proto$http_host/img/logo/logo.png'/>\n";
    424. 

  424. 							echo "<meta itemprop='foundingDate' content='03-02-2013'/>\n";
    425. 

  425. 							echo "<meta itemprop='telephone' content='+34637140371'/>\n";
    426. 

  426. 							echo "<meta itemprop='url' content='$proto$http_host'/>\n";
    427. 

  427. 							echo "</div>\n";
    428. 

  428. 							echo "<h3 class='entry_title'><a itemprop='url' href='$proto$http_host/actividades/$r_activity[permalink]'>$r_activity[title]</a></h3>\n";
    429. 

  429. 							echo "<table class='latest_activity'><tr>\n";
    430. 

  430. 							$q_activity_image = mysqli_query($con, "SELECT image FROM activity_image WHERE activity = $r_activity[id] ORDER BY idx LIMIT 1;");
    431. 

  431. 							if (mysqli_num_rows($q_activity_image) > 0){
    432. 

  432. 								$r_activity_image = mysqli_fetch_array($q_activity_image);
    433. 

  433. 								echo "<td class='latest_activity_image'><a href='$proto$http_host/actividades/$r_activity[permalink]'>\n";
    434. 

  434. 								echo "<meta itemprop='image' content='$proto$http_host/img/actividades/$r_activity_image[image]'/>\n";
    435. 

  435. 								echo "<img src='$proto$http_host/img/actividades/miniature/$r_activity_image[image]' alt='$r_activity[title]'/>\n";
    436. 

  436. 								echo "</a></td>\n";
    437. 

  437. 							}
    438. 

  438. 							//echo "<div class='activity_text'>\n";
    439. 

  439. 							//echo "<p>". cutText($r_activity['text'], 300, "$lng[index_read_more]", "$proto$http_host/actividades/$r_activity[permalink]") . "</p>\n";
    440. 

  440. 							if ($r_activity['after'] == ''){
    441. 

  441. 								echo "<td class='latest_activity_text'>" . cutText($r_activity['text'], 300, "$lng[index_read_more]", "$proto$http_host/actividades/$r_activity[permalink]") . "</td>\n";
    442. 

  442. 							}
    443. 

  443. 							else{
    444. 

  444. 								echo "<td class='latest_activity_text'>" . cutText($r_activity['after'], 300, "$lng[index_read_more]", "$proto$http_host/actividades/$r_activity[permalink]") . "</td>\n";
    445. 

  445. 							}
    446. 

  446. 							echo "</tr></table>\n";
    447. 

  447. 							//echo "</div>\n";
    448. 

  448. 							//echo "</div>\n";
    449. 

  449. 							echo "</div>\n";
    450. 

  450. 						}
    451. 

  451. 						echo "<a class='go_to_section' href='$proto$http_host/actividades/'>$lng[index_upcoming_activity_see_all]</a><br/>\n";
    452. 

  452. 						echo "</div>";
    453. 

  453. 						
    454. 

  454. 					}
    455. 

  455. 				}
    456. 

  456. 				//Festivals section (if no festivals shown on top)
    457. 

  457. 				if ($festivals == 0){
    458. 

  458. 					?>
    459. 

  459. 						<div class='section'>
    460. 

  460. 							<h3 class='section_title'><?php echo($lng['index_festivals_header']); ?></h3>
    461. 

  461. 							<div class='entry'>
    462. 

  462. 							<?php echo (cutText($lng['lablanca_no_content'] . '<br/>' . $lng['lablanca_no_content_2'], 300, "$lng[index_read_more]", "$proto$http_host/lablanca/")); ?>
    463. 

  463. 							</div>
    464. 

  464. 						</div>
    465. 

  465. 					<?php
    466. 

  466. 				}
    467. 

  467. 			?>
    468. 

  468. 		</div>
    469. 

  469. 		<?php
    470. 

  470. 

  471. 			//Footer
    472. 

  472. 			include("footer.php");
    473. 

  473. 			$ad = ad($con, $lang, $lng); 
    474. 

  474. 			stats($ad, $ad_static, "index", "");
    475. 

  475. 		?>
    476. 

  476. 	</body>
    477. 

  477. </html>
    478.