phpBB.de

Code: Alles auswählen

  $sort_order = "DESC";
}

Code: Alles auswählen

$toh_sql1 = '';
$toh_sql2 = '';
$toh_sql3 = '';

Code: Alles auswählen

          case 'time':
                        $order_by = "t.topic_id $sort_order";
                        break;

Code: Alles auswählen

          case 'rating':
                        $order_by = "IF(rating = NULL, 0, rating) $sort_order";
                        $toh_sql1 = ', AVG(rating) AS rating';
                        $toh_sql2 = 'LEFT JOIN ' . RATE_TABLE . ' r ON r.topic_id = t.topic_id '; 
                        $toh_sql3 = 'GROUP BY t.topic_id, u.user_id, u2.user_id';
                        break;

Code: Alles auswählen

$mode_types = array("default", [...] 

Code: Alles auswählen

$mode_types_text[] = 'Bewertung';
$mode_types[] = 'rating';

Code: Alles auswählen

//
// All announcement data, this keeps announcements
// on each viewforum page ...
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username, pt.post_text
        FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2, " . POSTS_TEXT_TABLE . " pt
        WHERE t.forum_id = $forum_id
                AND t.topic_poster = u.user_id
                AND p.post_id = t.topic_last_post_id
                AND p.post_id = pt.post_id
                AND p.poster_id = u2.user_id
                AND t.topic_type = " . POST_ANNOUNCE . "
        ORDER BY $order_by ";

Code: Alles auswählen

pt.post_text

Code: Alles auswählen

$toh_sql1

Code: Alles auswählen

" . POSTS_TEXT_TABLE . " pt

Code: Alles auswählen

$toh_sql2

Code: Alles auswählen

AND t.topic_type = " . POST_ANNOUNCE . "

Code: Alles auswählen

$toh_sql3

Code: Alles auswählen

//
// Grab all the basic data (all topics except announcements)
// for this forum
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
        FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
        WHERE t.forum_id = $forum_id
                AND t.topic_poster = u.user_id
                AND p.post_id = t.topic_first_post_id
                AND p2.post_id = t.topic_last_post_id
                AND u2.user_id = p2.poster_id
                AND t.topic_type <> " . POST_ANNOUNCE . "
                $limit_topics_time
        ORDER BY t.topic_type DESC, $order_by
        LIMIT $start, ".$board_config['topics_per_page'];

Code: Alles auswählen

p2.post_time

Code: Alles auswählen

$toh_sql1

Code: Alles auswählen

" . USERS_TABLE . " u2

Code: Alles auswählen

$toh_sql2

Code: Alles auswählen

$limit_topics_time

Code: Alles auswählen

$toh_sql3

Code: Alles auswählen

//
// All GLOBAL announcement data, this keeps GLOBAL announcements
// on each viewforum page ...
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
   FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
   WHERE t.topic_poster = u.user_id
      AND p.post_id = t.topic_last_post_id
      AND p.poster_id = u2.user_id
      AND t.topic_type = " . POST_GLOBAL_ANNOUNCE . "
   ORDER BY $order_by ";

Code: Alles auswählen

p.post_username

Code: Alles auswählen

$toh_sql1

Code: Alles auswählen

" . USERS_TABLE . " u2

Code: Alles auswählen

$toh_sql2

Code: Alles auswählen

AND t.topic_type = " . POST_GLOBAL_ANNOUNCE . "

Code: Alles auswählen

$toh_sql3