/templates/comment_paging.php

https://github.com/Ability44/WebMaster · PHP · 116 lines · 88 code · 23 blank · 5 comment · 20 complexity · 0ae92b6c79b49a52b487e7669a4300a1 MD5 · raw file

  1. <?php
  2. // Include the mysql information
  3. include ('../modules/functions.php');
  4. // Grab the Javascript input
  5. $page_num2 = $_GET['page_num'];
  6. $category = $_GET['category'];
  7. $article_id = $_GET['article_id'];
  8. // Calculate the page number
  9. $page_num = ($page_num2 * 5) - 5;
  10. // Grab the comments for that page
  11. $comments = mysql_query("SELECT ko_comments.*, ipb_profile_portal.*, ipb_members.* FROM ko_comments, ipb_profile_portal, ipb_members WHERE ko_comments.article_id = '$article_id' AND ko_comments.status = 'published' AND ipb_profile_portal.pp_member_id = ko_comments.user_id AND ipb_members.member_id = ko_comments.user_id AND ko_comments.article_category = '$category' ORDER BY ko_comments.id DESC LIMIT $page_num, ".$settings['max_page_comments']."");
  12. // Count comments
  13. $comments_c = mysql_query("SELECT ko_comments.*, ipb_profile_portal.*, ipb_members.* FROM ko_comments, ipb_profile_portal, ipb_members WHERE ko_comments.article_id = '$article_id' AND ko_comments.status = 'published' AND ipb_profile_portal.pp_member_id = ko_comments.user_id AND ipb_members.member_id = ko_comments.user_id AND ko_comments.article_category = '$category' ORDER BY ko_comments.id DESC");
  14. $or_comments_count = mysql_num_rows($comments_c);
  15. $comments_count = round(($or_comments_count / $settings['max_page_comments']) + 0.4);
  16. $page_num_max = $page_num + $settings['max_page_comments'];
  17. if ($page_num_max > $or_comments_count){
  18. $page_num_max = $or_comments_count;
  19. $max = true;
  20. }
  21. ?>
  22. <?php if ($page_num == '0'){ ?>
  23. First |
  24. <?php } else { ?>
  25. <a href="#comments"
  26. onclick="comment_paging('1', '<?php echo $category; ?>', '<?php echo $article_id; ?>')">First</a>
  27. |
  28. <?php } ?>
  29. <?php if ($page_num == '0'){ ?>
  30. Previous |
  31. <?php } else { ?>
  32. <a href="#comments"
  33. onclick="comment_paging('<?php echo $page_num2-1; ?>', '<?php echo $category; ?>', '<?php echo $article_id; ?>')">Previous</a>
  34. |
  35. <?php } ?>
  36. <?php echo $page_num+1; ?>
  37. -
  38. <?php echo $page_num_max; ?>
  39. of
  40. <?php echo $or_comments_count; ?>
  41. |
  42. <?php if ($max == TRUE){ ?>
  43. Next |
  44. <?php } else { ?>
  45. <a href="#comments"
  46. onclick="comment_paging('<?php echo $page_num2+1; ?>', '<?php echo $category; ?>', '<?php echo $article_id; ?>')">Next</a>
  47. |
  48. <?php } ?>
  49. <?php if ($max == TRUE){ ?>
  50. Last
  51. <?php } else { ?>
  52. <a href="#comments"
  53. onclick="comment_paging('<?php echo $comments_count; ?>', '<?php echo $category; ?>', '<?php echo $article_id; ?>')">Last</a>
  54. <?php } ?>
  55. <br />
  56. <br />
  57. <ul>
  58. <?php while($comment = mysql_fetch_array( $comments )) { ?>
  59. <li>
  60. <?php if($comment['avatar_type'] == "") { ?> <img
  61. src="/forums/public/style_images/master/profile/default_thumb.png"
  62. alt="User Avatar" title="Avatar" class="left commenter-avatar" />
  63. <?php } elseif($comment['avatar_type'] == "upload") { ?>
  64. <img src="/forums/uploads/<?php echo $comment['avatar_location']; ?>" alt="User Avatar" title="Avatar" class="left commenter-avatar" height="50px" width="50px" />
  65. <?php } else { ?>
  66. <img src="<?php echo $comment['avatar_location']; ?>" alt="User Avatar" title="Avatar" class="left commenter-avatar" height="50px" width="50px" />
  67. <?php } ?>
  68. <h6 class="commenter-name"><span class="right commenter-date"><?php echo date("M jS, Y",$comment['timestamp']); ?></span><a href="/forums/index.php?/user/<?php echo $comment['user_id']; ?>-<?php echo $comment['members_display_name']; ?>"><?php echo $comment['members_display_name']; ?></a></h6>
  69. <p><?php echo $comment['content']; ?></p>
  70. <div class="commenter-options">
  71. <ul class="right">
  72. <div id="display_likes_<?php echo $comment['id']; ?>" style="display:block;">
  73. <li><a title="Like Comment" class="commenter-upvote" onclick="update_likes('<?php echo $comment['id']; ?>', 'likes', <?php echo $comment['likes']; ?>, <?php echo $comment['dislikes']; ?>, '<?php echo $article['article_category']; ?>', '<?php echo $article['article_id']; ?>', '<?php echo $comment['id']; ?>');">Like (<?php echo $comment['likes']; ?>)</a></li>
  74. <li><a title="Dislike Comment" class="commenter-downvote" onclick="update_likes('<?php echo $comment['id']; ?>', 'dislikes', <?php echo $comment['likes']; ?>, <?php echo $comment['dislikes']; ?>, '<?php echo $article['article_category']; ?>', '<?php echo $article['article_id']; ?>', '<?php echo $comment['id']; ?>');">Dislike(<?php echo $comment['dislikes']; ?>)</a></li>
  75. </div>
  76. <div id="thank_you_<?php echo $comment['id']; ?>" style="display:none;">
  77. <li>Please turn Javascript on.</li>
  78. </div>
  79. </ul>
  80. <ul>
  81. <li>
  82. <?php if($comment['flagged'] != '-1') {?>
  83. <form method='post' action='<?php echo $article_title_seo.'-'.$view_id.'.html#message'; ?>'>
  84. <input type="hidden" name="flag_comment" value="<?php echo $comment['id']; ?>" />
  85. <a title="Report Comment" class="commenter-report" href="#" onclick="parentNode.submit()">Report</a>
  86. </form>
  87. <?php } else { echo '&nbsp'; } ?>
  88. </li>
  89. </ul>
  90. </div>
  91. </li>
  92. <?php } ?>
  93. </ul>