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


Ignore:
Timestamp:
12/08/07 00:04:43 (4 years ago)
Author:
hverton
Message:

update all user queries to include the user_status, to select only active user accounts
removed download bar selection from the download module (should be in the download bars module)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/forum/viewthread.php

    r1081 r1159  
    210210if ($rows != 0) { 
    211211    $result = dbquery( 
    212         "SELECT p.*, u.*, u2.user_name AS edit_name FROM ".$db_prefix."posts p 
     212        "SELECT p.*, u.*, u2.user_name AS edit_name, u2.user_status AS edit_status FROM ".$db_prefix."posts p 
    213213        LEFT JOIN ".$db_prefix."users u ON p.post_author = u.user_id 
    214214        LEFT JOIN ".$db_prefix."users u2 ON p.post_edituser = u2.user_id AND post_edituser > '0' 
     
    227227            $data['user_location'] = "-"; 
    228228            $data['user_sig'] = ""; 
     229            $data['user_status'] = "0"; 
    229230        } 
    230231 
Note: See TracChangeset for help on using the changeset viewer.