vBulletin Dev/Staff Tracker

[AshenTemper]

I have it at home (at the office right now). It was written ages ago for me by a community member that I used when I worked at a few different mmo sites/companies.

I can upload it tonight (or make a mod of it) since it was created for me to use publicly (and free of charge). The original guy was going to update it for me but he's unfamiliar with vB4.

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

Forgot I had attached it when I was emailing him recently about it. Here is the code for it:

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

?>

Note that these are the variables I would like to make config options:

AND user.usergroupid = 10
AND forum.forumid NOT IN(3,12,13,14,17,19,20,21,22)

Should I add it as a mod? Unsure how much 3x is used these days...