phpBB.de

Code: Alles auswählen

$sort_by_types = array($lang['Sort_Time'], $lang['Sort_Post_Subject'], [...]

Code: Alles auswählen

$sort_by_types[] = 'Bewertung'; // ADDED BY order by rating

Code: Alles auswählen

        //
        // Look up data ...
        //
        if ( $search_results != '' )
        {

Code: Alles auswählen

          // BEGIN order by rating
                if ( $sort_by == 8 )
                {
                        $toh_sql1 = ', AVG(rating) AS rating';
                        $toh_sql2 = 'LEFT JOIN ' . RATE_TABLE . ' r ON r.topic_id = t.topic_id ';
                        $toh_sql3 = ' GROUP BY ' . ( ( $show_results == 'posts' ) ? 'p.post_id' : 't.topic_id' );
                }
                else
                {
                        $toh_sql1 = '';
                        $toh_sql2 = '';
                        $toh_sql3 = '';
                }
                // END order by rating

Code: Alles auswählen

                        $sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid
                                FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
                                WHERE p.post_id IN ($search_results)
                                        AND pt.post_id = p.post_id
                                        AND f.forum_id = p.forum_id
                                        AND p.topic_id = t.topic_id
                                        AND p.poster_id = u.user_id";

Code: Alles auswählen

u.user_sig_bbcode_uid

Code: Alles auswählen

 $toh_sql1

Code: Alles auswählen

POSTS_TEXT_TABLE . " pt

Code: Alles auswählen

 $toh_sql2

Code: Alles auswählen

// ADDED  $toh_sql1 AND  $toh_sql2 BY order by rating

Code: Alles auswählen

                        $sql = "SELECT t.*, f.forum_id, f.forum_name, 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, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
                                WHERE t.topic_id IN ($search_results)
                                        AND t.topic_poster = u.user_id
                                        AND f.forum_id = t.forum_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";

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

// ADDED  $toh_sql1 AND  $toh_sql2 BY order by rating

Code: Alles auswählen

$sql .= " ORDER BY ";

Code: Alles auswählen

$sql .= $toh_sql3 . " ORDER BY "; // ADDED  . $toh_sql3 BY order by rating

Code: Alles auswählen

                        case 7:
                                $sql .= 't.topic_replies';
                                break

Code: Alles auswählen

                        // BEGIN order by rating
                        case 8:
                                $sql .= 'IF(rating = NULL, 0, rating)';
                                break;
                        // END order by rating

Code: Alles auswählen

$toh_sql3 = 'GROUP BY ' . ( ( $show_results == 'posts' ) ? 'p.post_id' : 't.topic_id' );

Code: Alles auswählen

$toh_sql3 = ' GROUP BY ' . ( ( $show_results == 'posts' ) ? 'p.post_id' : 't.topic_id' );