load_photo.php 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
  1. <?php
  2. $http_host = $_SERVER['HTTP_HOST'];
  3. include("../functions.php");
  4. $con = startdb();
  5. $proto = getProtocol();
  6. $server = "$proto$http_host";
  7. //Language
  8. $lang = selectLanguage();
  9. include("../lang/lang_" . $lang . ".php");
  10. //Get photo data
  11. $path = mysqli_real_escape_string($con, $_GET['path']);
  12. $q = mysqli_query($con, "SELECT id, file, permalink, title_$lang AS title, description_$lang AS description, uploaded, size, user, username FROM photo WHERE file = '$path' AND approved = 1");
  13. if (mysqli_num_rows($q) == 0){
  14. exit(0);
  15. }
  16. else{
  17. $r = mysqli_fetch_array($q);
  18. // Get album name
  19. $q_album = mysqli_query($con, "SELECT album.title_$lang AS title FROM album, photo_album WHERE album = album.id AND photo = $r[id]");
  20. $r_album = mysqli_fetch_array($q_album);
  21. ?>
  22. <h3 class='section_title'>
  23. <?php
  24. if (strlen($r['title']) > 0){
  25. echo($r['title']);
  26. }
  27. else{
  28. echo($r_album['title']);
  29. }
  30. ?>
  31. <div id='viewer_close_container'>
  32. <img id='viewer_close' class='pointer' alt=' ' src='<?=$server?>/img/misc/close.png' onClick='closeViewer();'/>
  33. </div>
  34. </h3>
  35. <div id='viewer_container'>
  36. <div id='viewer_table'>
  37. <div class='viewer_row'>
  38. <div class='viewer_cell' id='cell_image'>
  39. <div class='entry' id='photo_data'>
  40. <table>
  41. <tr>
  42. <td class='arrow'>
  43. <img id='viewer_arrow_left' class='viewer_arrow pointer' alt=' ' src='<?=$server?>/img/misc/slid-left.png' onClick='scrollPhoto(-1);'/>
  44. </td>
  45. <td id='image'>
  46. <div id='photo_viewer_image_container'>
  47. <img id='photo_viewer_image' src='/img/galeria/preview/<?=$r['file']?>'/>
  48. </div>
  49. </td>
  50. <td class='arrow'>
  51. <img id='viewer_arrow_right' class='viewer_arrow pointer' alt=' ' src='<?=$server?>/img/misc/slid-right.png' onClick='scrollPhoto(1);'/>
  52. </td>
  53. </tr>
  54. </table>
  55. <!-- Arrows -->
  56. <!--<div id='viewer_controls'>
  57. <img id='viewer_arrow_left' class='viewer_arrow pointer' alt=' ' src='<?=$server?>/img/misc/slid-left.png' onClick='scrollPhoto(-1);'/>
  58. <img id='viewer_arrow_right' class='viewer_arrow pointer' alt=' ' src='<?=$server?>/img/misc/slid-right.png' onClick='scrollPhoto(1);'/>
  59. </div> #viewer_controls -->
  60. <?php
  61. if (strlen($r['description']) > 0){
  62. echo("<span id='photo_description'>$r[description]</span>\n");
  63. }
  64. echo("<span id='photo_date'>" . formatDate($r['uploaded'], $lang) . "</span>\n");
  65. if (strlen($r['username']) > 0){
  66. echo("<span id='photo_user'>$lng[gallery_user]$r[username]</span>\n");
  67. }
  68. ?>
  69. </div> <!-- #photo_data -->
  70. </div> <!-- #cell_image -->
  71. <div class='viewer_cell' id='cell_comments'>
  72. <div id='photo_viewer_details'>
  73. <?php
  74. $q_comment = mysqli_query($con, "SELECT * FROM photo_comment WHERE photo = $r[id];");
  75. $comment_count = mysqli_num_rows($q_comment);
  76. ?>
  77. <div class='entry' id='comments_section'/>
  78. <div id='photo_viewer_comment_counter'>
  79. <?php
  80. switch ($comment_count){
  81. case 0:
  82. echo("<h3 class='entry_title'><meta itemprop='interactionCount' content='0'/>$lng[gallery_comment_count_0]</h3>\n");
  83. break;
  84. case 1:
  85. echo("<h3 class='entry_title'><span itemprop='interactionCount'>1</span> $lng[gallery_comment_count_1]</h3>\n");
  86. break;
  87. default:
  88. echo("<h3 class='entry_title'><span itemprop='interactionCount'>$comment_count</span> $lng[gallery_comment_count_several]</h3>\n");
  89. }
  90. ?>
  91. </div> <!-- #photo_viewer_comment_counter -->
  92. <div id='comment_list'>
  93. <?php
  94. //WARNING: If changes are done here, do the same in comment.php
  95. while ($r_comment = mysqli_fetch_array($q_comment)){
  96. ?>
  97. <div itemprop='comment' itemscope itemtype='http://schema.org/UserComments' id='comment_<?=$r_comment['id']?>' class='comment'>
  98. <span itemprop='creator' class='comment_user'><?=$r_comment['username']?></span>
  99. <span class='comment_date date'><meta itemprop='commentTime' content='<?=$r_comment['isodate']?>'/><?=formatDate($r_comment['dtime'], $lang)?></span>
  100. <p itemprop='commentText' class='comment_text'><?=$r_comment['text']?></p>
  101. <hr class='comment_line'/>
  102. </div>
  103. <?php
  104. }
  105. ?>
  106. </div> <!-- #comment_list -->
  107. <!-- Comment form -->
  108. <div class='comment' id='comment_new'>
  109. <form id='comment_form' method='post' action='/' onsubmit='event.preventDefault();postComment(<?=$r['id']?>, "<?=$lang?>");'>
  110. <textarea id='new_comment_text' name='text' maxlength='1800' onChange='defaultInputBorder(this);' onKeyDown='defaultInputBorder(this);' placeholder='<?=$lng[blog_placeholder_text]?>'></textarea>
  111. <div id='identification_form'>
  112. <br/>
  113. <input id='new_comment_user' name='user' maxlength='50' type='text' placeholder='<?=$lng['blog_placeholder_name']?>' onChange='defaultInputBorder(this);' onKeyDown='defaultInputBorder(this);'/>
  114. <input type='submit' value='<?=$lng['blog_send']?>'/>
  115. </div> <!-- #identification_form -->
  116. </form>
  117. </div> <!-- #comment_new -->
  118. </div> <!-- #comments_section -->
  119. <!-- </div> #cell_details -->
  120. <?php
  121. echo "</div>\n"; //Row
  122. echo "</div></div>\n"; //Container
  123. stats(-1, 0, "photo", "$r[id]");
  124. }
  125. ?>