Quick Echo Question

[ZomgStuff]

I was going to make a huge ban mod from this but I'll just release it here because I know I would have loved to have seen this here.

Some serious props to BamaStangGuy for helping me a great deal with this and putting up with my stupidity. BamaStangGuy probably came up with most of this code, I just had the idea. If you want me to remove this I will BamaStangGuy.

php file

PHP Code:

<?php

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

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'ban'); // change this depending on your filename

// ################### 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(
    'BAN',
);

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

);

    

 

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


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

$navbits = array();
$navbits[$parent] = 'Ban Page';

$navbits = construct_navbits($navbits);
// Count the total bans
    $totalbans = $db->query_first_slave("
    SELECT COUNT(userid) AS bans
    FROM userban

    ");
    
//Count the current active bans
    $activebans = $db->query_first_slave("
    SELECT COUNT(userid) AS activebans
    FROM userban
    WHERE usergroupid = 2
    ");
    
//Display banned users
$bannedusersarray  = array();
$bannedusers = $db->query_read("SELECT userid FROM userban");  
$bannedusersarray = $db->fetch_array($bannedusers);  



// Get Latest Bans
 $result_data = $vbulletin->db->query_read("
   SELECT
   ban.userid,
   ban.usergroupid, 
   ban.adminid,
   ban.liftdate,
   ban.reason,
   user.username
   FROM userban AS ban
   LEFT OUTER JOIN user AS user
   ON user.userid = ban.userid
 "); 
  
  while( $data = $db->fetch_array($result_data) )
 {
  $banusername = $data['username'];
  eval('$bannedusers .= "' . fetch_template('BAN_mainbits') . '";');
 }

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





?>

Here is the "BAN" template

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
	<td class="tcat"><center>Here's the banlist. Don't do what these people did.</center></td>
</tr>

<tr>
<div style="margin: 0px auto; margin-top: 20px; margin-bottom: 20px; font-size: 40px; font-weight: bolder; width: 600px; text-align: center;">$activebans[activebans] ACTIVE BANS<br/><small>$totalbans[bans] total bans</small></div>

	<td class="alt1">


<table class="tborder" cellpadding="5" cellspacing="0" width="100%" border="0" align="center">
<tr>
<td class="tcat" colspan="4">Latest Bans</td>
</tr>
<tr>
<td class="thead" width="25%"><center>Username</center></td>
<td class="thead" width="2%">Current Usergroup</td>
<td class="thead" width="25%"><center>Banned By</center></td>
<td class="thead" width="25%"><center>Ban Lift</center></td>
<td class="thead" width="25%"><center>Reason</center></td>

</tr>
$bannedusers
</table>

</td>
</tr>
</table>

$footer
</body>

</html>

and here is BAN_mainbits

<tr>
<td class="alt1" width="25%" align="center"><span class="smallfont">$banusername</span></td>
<td class="alt2" width="25%" align="center"><span class="smallfont">$data[usergroupid]</span></td>
<td class="alt2" width="15%" align="center"><span class="smallfont">$data[adminid]</span></td>
<td class="alt1" width="25%" align="center"><span class="smallfont">$data[liftdate]</span></td>
<td class="alt2" width="25%" align="center"><span class="smallfont">$data[reason]</span></td>
</tr>