Only Show A Specific Users Posts In A Thread

Author: NTLDR
Version: 1.0.0
vB Compatibility: vB3 Gamma, RC1, RC2

Description:

This hack will allow you to only show posts by a specific user on showthread.php.

Usage:
showthread.php?threadid=1&userid=X
showthread.php?threadid=1&username=Y

(i.e add &userid=X for all posts by userid X or &username=Y for all posts by user Y).

File Edits:

In showthread.php find:

PHP Code:

if ($threadedmode == 0)
{ 


Add after:

PHP Code:

    // EDIT ########################################################################
    // get posts by a specific user only
    if (!empty($_REQUEST['userid'])) {
        $usersql = 'AND post.userid = '.intval($_REQUEST['userid']);
        $uidwhere = true;
    } elseif (!empty($_REQUEST['username'])) {
        
        $fetchuserid = $DB_site->query_first("SELECT userid FROM ".TABLE_PREFIX."user WHERE username = '".addslashes($_REQUEST['username'])."'");
        $uidwhere = false;
        
        if (empty($fetchuserid['userid'])) {
            $idname = $vbphrase['user'];
            eval(print_standard_error('error_invalidid'));
        } else {
            $usersql = 'AND post.userid = '.intval($fetchuserid['userid']);
        }

    } else {
        $usersql = '';
        $uidwhere = false;
    }
    // END EDIT #################################################################### 


Find:

PHP Code:

WHERE threadid = $threadid AND visible = 1 $delthreadlimit 


Add after:

PHP Code:

$usersql 


Find (just after the last edit):

PHP Code:

WHERE threadid = $threadid AND visible = 1 


Add after:

PHP Code:

$usersql 


Find:

PHP Code:

$postids = "post.postid IN (0" . $ids . ")"; 


Add after:

PHP Code:

    if (empty($ids) && $uidwhere) {
        $idname = $vbphrase['userid'];
        eval(print_standard_error('error_invalidid'));
    } 


Done!

[high]Please click install if you use this hack[/high]

[Boofo]

How about an install txt file?

[Dark Shogun]

Here is the txt of it.

Dark Shogun

[Boofo]

Thank you, sir.

[gmarik]

This one could be of some use