Fehler: nur ein Ergebnis

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • Fehler: nur ein Ergebnis

    Hi!

    Ich habe folgendes Problem mit dem Code:

    Quellcode

    1. <?php
    2. $sql2 = "SELECT * FROM ".$praefix."_board WHERE board_cat_id = ".$row['cat_id']." ORDER BY board_order ASC";
    3. $result2 = new Query($sql2) or die(mysql_error());
    4. $numrows = $result2->numRows();
    5. if ($numrows == 0) {
    6. $nothing = 0;
    7. }
    8. else {
    9. while($row2 = $result2->fetch()) {
    10. if (!isset($_SESSION["user_id"])) {
    11. $see_board = 0;
    12. }
    13. else {
    14. $use2_sql = "SELECT * FROM ".$praefix."_user WHERE user_id = ".$_SESSION["user_id"];
    15. $use2_query = new Query($use2_sql);
    16. $usw2_row = $use2_query->fetch();
    18. $user_rank = "SELECT * FROM ".$praefix."_rank WHERE rank_id = ".$usw2_row["user_rank"];
    19. $user_query = new Query($user_rank);
    20. $user_row = $user_query->fetch();
    22. $see_board = $user_row["rank_see_board"];
    23. }
    24. if ($row2["board_status"] == 1 or $see_board == 1) {
    25. $sql3 = "SELECT
    26. a.`thread_title`,
    27. a.`thread_date`,
    28. a.`thread_autor`,
    29. a.`thread_status`,
    30. a.`thread_id`,
    31. b.`user_name`,
    32. b.`user_id`,
    33. (SELECT c.`post_date` FROM `".$praefix."_post` AS c WHERE c.`post_thread_id` = a.`thread_id` ORDER BY c.`post_date` DESC LIMIT 1) AS `date`
    34. FROM
    35. `".$praefix."_thread` AS a
    36. LEFT JOIN
    37. `".$praefix."_user` AS b
    38. ON
    39. a.`thread_autor` = b.`user_name`
    40. WHERE
    41. a.`thread_board_id` = '".mysql_real_escape_string($row2['board_id'])."'
    42. ORDER BY
    43. `date` DESC,
    44. a.`thread_date` DESC
    45. LIMIT
    46. 1";
    47. $result3 = new Query($sql3);
    48. $row3 = $result3->fetch();
    50. $sql5 = "SELECT * FROM ".$praefix."_post WHERE post_thread_id = ".$row3['thread_id'];
    51. $result5 = new Query($sql5);
    52. $num5 = $result5->numRows();
    53. if ($num5 != 0) {
    54. if (strlen($row3['thread_title']) > 25) {
    55. $thread_post = "SELECT * FROM ".$praefix."_post WHERE post_thread_id = ".$row3["thread_id"]." ORDER BY `post_date` DESC LIMIT 1";
    56. $thread_query = new Query($thread_post);
    57. $thread_row = $thread_query->fetch();
    59. $post_autor = "SELECT * FROM ".$praefix."_user WHERE user_name = '".$thread_row["post_autor"]."'";
    60. $post_query = new Query($post_autor);
    61. $post_row = $post_query->fetch();
    63. $smarty->assign("userid",$post_row["user_id"]);
    64. $smarty->assign("boardautor",$post_row["user_name"]);
    66. $threadtitel = "Re: ".substr($row3['thread_title'],0,17)."...";
    67. }
    68. else {
    69. $sql6 = "SELECT * FROM ".$praefix."_thread WHERE thread_board_id = ".$row2['board_id'];
    70. $result6 = new Query($sql6) or die(mysql_error());
    71. $numRow6 = $result6->numRows();
    72. if ($numRow6 == 0) {
    73. $threadtitel = "";
    75. $smarty->assign("userid" ,'');
    76. $smarty->assign("boardautor",'');
    77. }
    78. else {
    79. $thread_post = "SELECT * FROM ".$praefix."_post WHERE post_thread_id = ".$row3["thread_id"]." ORDER BY `post_date` DESC LIMIT 1";
    80. $thread_query = new Query($thread_post);
    81. $thread_row = $thread_query->fetch();
    83. $post_autor = "SELECT * FROM ".$praefix."_user WHERE user_name = '".$thread_row["post_autor"]."'";
    84. $post_query = new Query($post_autor);
    85. $post_row = $post_query->fetch();
    87. $smarty->assign("userid",$post_row["user_id"]);
    88. $smarty->assign("boardautor",$post_row["user_name"]);
    90. $threadtitel = "Re: ".$row3['thread_title'];
    91. }
    92. }
    93. }
    94. else {
    95. $smarty->assign("userid",$row3["user_id"]);
    96. $smarty->assign("boardautor",$row3["user_name"]);
    97. if (strlen($row3['thread_title']) > 25) {
    98. $threadtitel = substr($row3['thread_title'],0,18)."...";
    99. }
    100. else {
    101. $threadtitel = $row3['thread_title'];
    102. }
    103. }
    106. $sql_100 = "SELECT * FROM ".$praefix."_thread WHERE thread_board_id = ".$row2['board_id'];
    107. $result_100 = new Query($sql_100) or die(mysql_error());
    108. $num_rows10 = $result_100->numRows();
    110. if ($num_rows10 == 0) {
    111. $smarty->assign("on_closed_off",'<img src="images/nopost.gif" alt="Nichts neues" />');
    112. }
    113. else {
    114. if ($row3['thread_status'] == 1) {
    115. $smarty->assign("on_closed_off",'<img src="images/closed.gif" alt="Gesperrt" />');
    116. }
    117. else {
    118. if (!isset($_SESSION["user_id"])) {
    119. $smarty->assign("on_closed_off",'<img src="images/off.gif" alt="Nichts neues" />');
    120. }
    121. else {
    122. $sql4 = "SELECT * FROM ".$praefix."_unread_topic WHERE unread_user_id = ".$_SESSION["user_id"];
    123. $result4 = new Query($sql4) or die(mysql_error());
    124. $row4 = $result4->fetch();
    125. $numRow4 = $result4->numRows();
    127. if ($row4["unread_thread_id"] != $row3["thread_id"]) {
    128. if ($row3['thread_status'] == 2) {
    129. $smarty->assign("on_closed_off",'<img src="images/thread_offAlert.gif" alt="Wichtiges Thema" />');
    130. }
    131. elseif ($row3['thread_status'] == 3) {
    132. $smarty->assign("on_closed_off",'<img src="images/thread_offAttachment.gif" alt="Ankündigung" />');
    133. }
    134. elseif ($row3['thread_status'] == 4) {
    135. $smarty->assign("on_closed_off",'<img src="images/off.gif" alt="Nichts neues" />');
    136. }
    137. }
    138. else {
    139. if ($row3['thread_status'] == 2) {
    140. $smarty->assign("on_closed_off",'<img src="images/thread_onAlert.gif" alt="Wichtiges Thema" />');
    141. }
    142. elseif ($row3['thread_status'] == 4) {
    143. $smarty->assign("on_closed_off",'<img src="images/on.gif" alt="Neu" />');
    144. }
    145. elseif ($row3['thread_status'] == 3) {
    146. $smarty->assign("on_closed_off",'<img src="images/thread_onAttachment.gif" alt="Ankündigung" />');
    147. }
    148. }
    149. }
    150. }
    151. }
    152. // und so weiter
    153. ?>
    Alles anzeigen


    Also:
    Es wird nur ein ungelesenes Thema angezeigt. Egal welches Forum.
    Aber der Themenstatus: Ankündigung, Wichtig oder Normal wird angezeigt.

    Hat jemand eine lösung?