album.php 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. <?php
  2. session_start();
  3. $http_host = $_SERVER["HTTP_HOST"];
  4. include("../functions.php");
  5. $con = startdb();
  6. $proto = getProtocol();
  7. $server = "$proto$http_host";
  8. //Language
  9. $lang = selectLanguage();
  10. include("../lang/lang_$lang.php");
  11. $cur_section = $lng["section_gallery"];
  12. //Get album
  13. $perm = mysqli_real_escape_string($con, $_GET["perm"]);
  14. $q = mysqli_query($con, "SELECT id, permalink, title_$lang AS title, description_$lang AS description, user, open, dtime FROM album WHERE permalink = '$perm';");
  15. if (mysqli_num_rows($q) == 0){
  16. header("Location: /galeria/");
  17. exit (-1);
  18. }
  19. else{
  20. $r = mysqli_fetch_array($q);
  21. $id = $r["id"];
  22. ?>
  23. <!DOCTYPE html>
  24. <html>
  25. <head>
  26. <meta content='text/html; charset=utf-8" http-equiv="content-type'/>
  27. <meta charset="utf-8"/>
  28. <meta name='viewport' content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1">
  29. <title><?=$r["title"]?> - Gasteizko Margolariak</title>
  30. <link rel="shortcut icon" href="<?php echo "$server/img/logo/favicon.ico";?>">
  31. <!-- CSS files -->
  32. <style>
  33. <?php
  34. include("../css/ui.css");
  35. include("../css/galeria.css");
  36. ?>
  37. </style>
  38. <!-- CSS for mobile version -->
  39. <style media="(max-width : 990px)">
  40. <?php
  41. include("../css/m/ui.css");
  42. include("../css/m/galeria.css");
  43. ?>
  44. </style>
  45. <!-- Script files -->
  46. <script type="text/javascript">
  47. <?php
  48. include("../script/ui.js");
  49. include("../script/galeria.js");
  50. ?>
  51. </script>
  52. <!-- Meta tags -->
  53. <link rel='canonical' href='<?=$server?>/galeria/<?=$perm?>'/>
  54. <link rel='author' href='<?=$server?>'/>
  55. <link rel='publisher' href='<?=$server?>'/>
  56. <meta name='description' content='<?=strip_tags($r["description"])?>'/>
  57. <meta property='og:title' content='<?=$r["title"]?> - Gasteizko Margolariak'/>
  58. <meta property='og:url' content='<?=$server?>/galeria/<?=$perm?>'/>
  59. <meta property='og:description' content='<?=strip_tags($r["description"])?>'/>
  60. <meta property='og:image' content='<?=$server?>/img/logo/logo.png'/>
  61. <meta property='og:site_name' content='Gasteizko Margolariak'/>
  62. <meta property='og:type' content='website'/>
  63. <meta property='og:locale' content='<?=$lang?>'/>
  64. <meta name='twitter:card' content='summary'/>
  65. <meta name='twitter:title' content='<?=$r["title"]?> - Gasteizko Margolariak'/>
  66. <meta name='twitter:description' content='<?=strip_tags($r["description"]) ?>'/>
  67. <meta name='twitter:image' content='<?=$server?>/img/logo/logo.png'/>
  68. <meta name='twitter:url' content='<?=$server?>/galeria/<?=$perm?>'/>
  69. <meta name='robots' content='index follow'/>
  70. </head>
  71. <body onLoad="populatePhotos();" onkeypress="keyDown(event);">
  72. <?php
  73. include("../header.php");
  74. ?>
  75. <div id='content'>
  76. <div class='section' id='album' itemscope itemtype='https://schema.org/ImageGallery'>
  77. <div class='hidden' itemprop='author creator' itemscope itemtype='http://schema.org/Organization'>
  78. <meta itemprop='legalName' content='Asociaci&oacute;n Cultural Recreativa Gasteizko Margolariak'/>
  79. <meta itemprop='name' content='Gasteizko Margolariak'/>
  80. <meta itemprop='logo' content='$server/img/logo/logo.png'/>
  81. <meta itemprop='foundingDate' content='03-02-2013'/>
  82. <meta itemprop='telephone' content='+34637140371'/>
  83. <meta itemprop='url' content='<?=$server ?>'/>
  84. </div>
  85. <h3 class='section_title' itemprop='name' id='album_title'><?=$r["title"]?></h3>
  86. <?php
  87. if ($r["description"] != ''){
  88. ?>
  89. <div class='entry' id='album_header'>
  90. <?=$r["description"]?>
  91. </div>
  92. <?php
  93. }
  94. //Photos of the album
  95. $q_photo = mysqli_query($con, "SELECT id, file, permalink, title_$lang AS title, description_$lang AS description, photo.dtime AS dtime, uploaded, width, height, size, user, username FROM photo, photo_album WHERE photo_album.photo = id AND album = $r[id] AND approved = 1 ORDER BY photo.dtime DESC;");
  96. while ($r_photo = mysqli_fetch_array($q_photo)){
  97. ?>
  98. <div class='entry photo'>
  99. <div class='photo_container'>
  100. <img class='pointer photo_img' path='<?=$r_photo["file"]?>' onClick='showPhotoByPath("<?=$r_photo["file"]?>");' src='<?=$server?>/img/galeria/miniature/<?=$r_photo["file"]?>'/>
  101. </div>
  102. <meta itemprop='image' content='<?=$server?>/img/galeria/view/<?=$r_photo["file"]?>'/>
  103. <?php
  104. if (strlen($r_photo["title"]) > 0 ){
  105. ?>
  106. <h3 class='entry_title'>
  107. <a onClick='showPhotoByPath("<?=$r_photo["file"]?>");'><?=$r_photo["title"]?></a>
  108. </h3>
  109. <?php
  110. }
  111. if (strlen($r_photo["description"]) > 0 ){
  112. ?>
  113. <span class='photo_description'><?=cutText($r_photo["description"], 50)?></span>
  114. <?php
  115. }
  116. //Count comments
  117. $q_comments = mysqli_query($con, "SELECT id FROM photo_comment WHERE photo = $r_photo[id];");
  118. ?>
  119. <span class='comment_counter'><?=mysqli_num_rows($q_comments)?><img src='<?=$server?>/img/misc/comment.png' alt=' '/></span>
  120. </div> <!-- entry photo -->
  121. <?php
  122. }
  123. ?>
  124. </div>
  125. </div>
  126. <div id='screen_cover' onClick="closeViewer();">
  127. </div>
  128. <div id='photo_viewer' class='section'>
  129. </div>
  130. <?php
  131. include("../footer.php");
  132. $ad = ad($con, $lang, $lng);
  133. stats($ad, $ad_static, "galeria", "$id");
  134. ?>
  135. </body>
  136. </html>
  137. <?php
  138. }
  139. ?>