Changeset 1513 in ExiteCMS for trunk/forum/viewthread.php


Ignore:
Timestamp:
07/02/08 20:42:25 (4 years ago)
Author:
hverton
Message:

Changed two INNER queries back to LEFT JOINS, because a user does not always exist (p.e. in case of automatic post)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/forum/viewthread.php

    r1491 r1513  
    262262    $result = dbquery( 
    263263        "SELECT p.*, u.*, u2.user_name AS edit_name, u2.user_status AS edit_status FROM ".$db_prefix."posts p 
    264         INNER JOIN ".$db_prefix."users u ON p.post_author = u.user_id 
     264        LEFT JOIN ".$db_prefix."users u ON p.post_author = u.user_id 
    265265        LEFT JOIN ".$db_prefix."users u2 ON p.post_edituser = u2.user_id AND post_edituser > '0' 
    266266        WHERE p.thread_id='$thread_id' ORDER BY post_sticky DESC, post_datestamp ASC LIMIT $rowstart,".$settings['numofthreads'] 
Note: See TracChangeset for help on using the changeset viewer.