album.php 5.4 KB

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