vb.org Archive - Search Posts By Usergroups

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') . '");');



?>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01261 seconds Memory Usage 1,751KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: