Search Posts By Usergroups

[Zantox]

Hey Everyone,

I'm looking for a "Staff Post Tracker" or "Dev Tracker", but not one likethis mod.

I've been searching around for awhile, and I'm trying to find one thats not going to cost a big chunk of change. I'm sure theres some other people looking for one as well.

I've found these 2 simple modifications to search.php, but didn't really have much success with them as they were designed for vB 3.6

PHP Code:

if ($vbulletin->GPC['searchuser'] == 'devtracker') { $userids = '1,5,10,43'; } 


Or:

PHP Code:

 if ( $vbulletin->GPC['searchuser'] == 'devtracker' )
      {
         $aDevGroups = Array ( 1, 2, 3 );
         $q = 'SELECT posts, userid, username FROM `' . TABLE_PREFIX . 'user` where usergroupid IN ( ' . implode ( ',', $aDevGroups ) . ') ';
         foreach ( $aDevGroups as $nDevGroup )
            $q .= ' OR concat( membergroupids,"," ) LIKE "%' . $nDevGroup . ',%"';
      }
      else 


I've been hoping for a plugin, template modification, or full out mod that can basically perform the same thing as a search.php search, but simply displaying the posts of a usergroup.

And I'm sure it can't be too hard, I just can't seem to wrap my head around it for some reason

[ozzy47]

What is wrong with the Staff Tracker mod you linked to?

[Zantox]

The Modification simply displays a small status icon type image in the postbit that shows if a member of a paticular usergroup posted in that thread, then allows you to jump staff posts.

What I need is a single page that shows all posts (like when you click Find Latest Posts on a profile), but it displays for multiple users (being the staff usergroups), showing posts in all forums that aren't private.

--------------- Added [DATE]1389939838[/DATE] at [TIME]1389939838[/TIME] ---------------

Does anyone else have any ideas about this?

--------------- Added [DATE]1389939944[/DATE] at [TIME]1389939944[/TIME] ---------------

I guess this is an example of what I'm looking for:
http://www.swtor.com/community/devtracker.php

--------------- Added [DATE]1389944837[/DATE] at [TIME]1389944837[/TIME] ---------------

I've also found this, which is a devtracker.php script for vBulletin 3.8. It is "supposedly" what's on the SWTOR website. But it is missing 2 template files. I tried installation on a 4.2 vBulletin and got a database error about invalid sql...

Any help appreciated.

PHP Code:

<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'DevTracker');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array(
        'devtracker','dev_post'
);

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################





// #############################################################################
// draw navbar
if ($page=="" || $page==0)
$page=1;

$pmin = ($page-1) * 30;
$pmax = $page * 30;

$navbits = array();
$navbits[''] = "Dev Tracker";
$navbits = construct_navbits($navbits);
$dev_posts = $db->query_read('SELECT post_parsed.pagetext_html AS posttext, post.userid AS userid, post.postid, post.threadid, post.username AS username, thread.title AS title, forum.forumid, forum.title as forum_name, post.dateline AS dateline
FROM post, post_parsed, user, thread, forum
WHERE post.userid = user.userid
AND post.threadid = thread.threadid
AND post.postid = post_parsed.postid
AND thread.forumid = forum.forumid
AND user.usergroupid = 10
AND forum.forumid NOT IN(3,12,13,14,17,19,20,21,22)
ORDER BY post.dateline DESC
LIMIT '.$pmin.', '.$pmax);
$count = 0;
while ($dev_post = $db->fetch_array($dev_posts))
{
  if ($count % 2 == 0){
    $alt_type = "alt1";
  } else {
    $alt_type = "alt2";
  }
$dev_post[posttext] = str_replace('<td class="alt2" style="border:1px inset">','<td class="alt2" style="font-size:10px ;border:1px inset">',$dev_post[posttext]);
$date_posted = date("m-d-Y", $dev_post[dateline]);
$time_posted = date("h:i A", $dev_post[dateline]);
eval('$stuff .= "' . fetch_template('dev_post') . '";');
$count++;
}

$pages = $count % 30;
$page_text = "";
for ($i = 1; $i < $pages; $i++){
  $page_text .= "$i ";
}

//$stuff .= "<br/>Page: $page_text";

eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('devtracker') . '");');

?>

[Zantox]

(Edit: Nevermind)