Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-819

sql statement mistake

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • None
    • 3.0.x
    • Viewing posts
    • None
    • PHP Environment:
      Database:

      in viewtopic.php, the following line appears:

      $sql = 'SELECT COUNT(p.post_id) AS prev_posts
      		FROM ' . POSTS_TABLE . " p
      		WHERE p.post_approved = 1
      			AND p.topic_id = {$topic_data['topic_id']}
      			" . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p.post_approved = 1' : '') . "
      			AND " . (($sort_dir == 'd') ?  "p.post_id >= $post_id" : "p.post_id <= $post_id");

            Acyd Burn Meik Sievertsen [X] (Inactive)
            arod-1 arod-1 [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: