index.php 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180
  1. <?php
  2. session_start();
  3. include("../functions.php");
  4. $con = startdb();
  5. $proto = getProtocol();
  6. $http_host = $_SERVER["HTTP_HOST"];
  7. $server = "$proto$http_host";
  8. //Language
  9. $lang = selectLanguage();
  10. include("../lang/lang_$lang.php");
  11. $cur_section = $lng["section_lablanca"];
  12. //Is festivals enabled in settings?
  13. $q = mysqli_query($con, "SELECT value FROM settings WHERE name = 'festivals';");
  14. if (mysqli_num_rows($q) == 0)
  15. $is_festivals = false;
  16. else{
  17. $r = mysqli_fetch_array($q);
  18. if ($r["value"] == 1){
  19. $is_festivals = true;
  20. }
  21. else{
  22. $is_festivals = false;
  23. }
  24. }
  25. //Get year
  26. $year = date("Y");
  27. if ($_GET["year"] != ''){
  28. $q_year = mysqli_query($con, "SELECT id FROM festival WHERE year = " . mysqli_real_escape_string($con, $_GET["year"]));
  29. if (mysqli_num_rows($q_year) > 0){
  30. $year = $_GET["year"];
  31. $is_festivals = true;
  32. }
  33. }
  34. ?>
  35. <!DOCTYPE html>
  36. <html>
  37. <head>
  38. <meta content='text/html; charset=utf-8' http-equiv='content-type'/>
  39. <meta charset='utf-8'/>
  40. <meta name='viewport' content='width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1'>
  41. <title>
  42. <?php
  43. if ($is_festivals){
  44. ?>
  45. <?=str_replace('#', $year, $lng["lablanca_title"])?>
  46. <?php
  47. }
  48. else{
  49. ?>
  50. <?=$lng["lablanca_no_title"]?>
  51. <?php
  52. }
  53. ?>
  54. - Gasteizko Margolariak
  55. </title>
  56. <link rel='shortcut icon' href='<?=$server?>/img/logo/favicon.ico'>
  57. <!-- CSS files -->
  58. <style>
  59. <?php
  60. include("../css/ui.css");
  61. include("../css/lablanca.css");
  62. ?>
  63. </style>
  64. <!-- CSS for mobile version -->
  65. <style media="(max-width : 990px)">
  66. <?php
  67. include("../css/m/ui.css");
  68. include("../css/m/lablanca.css");
  69. ?>
  70. </style>
  71. <!-- Script files -->
  72. <script type="text/javascript">
  73. <?php
  74. include("../script/ui.js");
  75. include("../script/lablanca.js");
  76. ?>
  77. </script>
  78. <!-- Meta tags -->
  79. <link rel='canonical' href='<?=$server?>/lablanca/'/>
  80. <link rel='author' href="<?=$server?>'/>
  81. <link rel='publisher' href="<?=$server?>'/>
  82. <meta name='description' content='<?=$lng["lablanca_description"]?>'/>
  83. <?php
  84. if ($is_festivals){
  85. ?>
  86. <meta property="og:title" content='<?=str_replace('#', $year, $lng["lablanca_title"])?> - Gasteizko Margolariak'/>
  87. <?php
  88. }
  89. else{
  90. ?>
  91. <meta property="og:title" content='<?=str_replace('#', $year, $lng["lablanca_no_title"])?> - Gasteizko Margolariak'/>
  92. <?php
  93. }
  94. ?>
  95. <meta property='og:url' content='<?=$server?>'/>
  96. <meta property='og:description' content='<?=$lng["lablanca_description"]?>'/>
  97. <meta property='og:image' content='<?=$server?>/img/logo/logo.png'/>
  98. <meta property='og:site_name' content='<?=$lng["lablanca_title"]?>'/>
  99. <meta property='og:type' content='website'/>
  100. <meta property='og:locale' content='<?=$lang?>'/>
  101. <meta name='twitter:card' content='summary'/>
  102. <?php
  103. if ($is_festivals){
  104. ?>
  105. <meta property='twitter:title' content='<?=str_replace('#', $year, $lng["lablanca_title"])?> - Gasteizko Margolariak'/>
  106. <?php
  107. }
  108. else{
  109. ?>
  110. <meta property='twitter:title' content='<?=str_replace('#', $year, $lng["lablanca_no_title"])?> - Gasteizko Margolariak'/>
  111. <?php
  112. }
  113. ?>
  114. <meta name='twitter:description' content='<?=$lng["lablanca_description"]?>'/>
  115. <meta name='twitter:image' content='<?=$server?>/img/logo/logo.png'/>
  116. <meta name='twitter:url' content='<?=$server?>'/>
  117. <meta name='robots' content='index follow'/>
  118. </head>
  119. <body>
  120. <?php
  121. include("../header.php");
  122. ?>
  123. <div id='content'>
  124. <?php
  125. //Include file
  126. if ($is_festivals){
  127. include("fiestas.php");
  128. }
  129. else{
  130. include("nofiestas.php");
  131. }
  132. ?>
  133. <?php
  134. //If the program of previous years exist, show a drop list
  135. $year = date("Y");
  136. if (date("M") <= 8 || (date("M") == 8 && date("D") < 25)){
  137. $year --;
  138. }
  139. if (date("M") <= 8){
  140. $q_years = mysqli_query($con, "SELECT year FROM festival WHERE year != " . date("Y") . " ORDER BY year DESC;");
  141. }
  142. else{
  143. $q_years = mysqli_query($con, "SELECT year FROM festival WHERE year <= " . date("Y") . " ORDER BY year DESC;");
  144. }
  145. if (mysqli_num_rows($q_years) >= 0){
  146. ?>
  147. <br/><br/>
  148. <div class='section' id='past_festivals'>
  149. <h3 class='section_title'><?=$lng["lablanca_past_title"]?></h3>
  150. <div class='entry'>
  151. <ul>
  152. <?php
  153. while ($r_years = mysqli_fetch_array($q_years)){
  154. ?>
  155. <li>
  156. <a href='<?=$server?>/lablanca/<?=$r_years["year"]?>'><?=$lng["lablanca_past_link"]?> <?=$r_years["year"]?></a>
  157. </li>
  158. <?php
  159. }
  160. ?>
  161. </ul>
  162. </div> <!-- .entry -->
  163. </div> <!-- .section -->
  164. <?php
  165. }
  166. ?>
  167. </div> <!-- #content -->
  168. <?php
  169. include("../footer.php");
  170. $ad = ad($con, $lang, $lng);
  171. stats($ad, $ad_static, "fiestas", "");
  172. ?>
  173. </body>
  174. </html>