The Arcive of vBulletin Modifications Site.

ZomgStuff · #1 05-24-2007, 10:12 PM

Well refer to this page.
http://www.zomgstuff.net/forum/ban.php

Here is my template

Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle]</title>
$headinclude
</head>
<body>
$header

$navbar

<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">

$bannedusersarray


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

$footer
</body>

</html>

here is my php file

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 all the data from the "example" table
$result = mysql_query("SELECT * FROM userban") ;
echo "<table border='1'>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result ))
 {
	echo "<tr>";
	echo "<td>";
	echo $row['userid'];
	echo "</td><td>";
	echo $row['usergroupid'];
	echo "</td><td>";
	echo $row['adminid'];
	echo "</td><td>";
	echo $row['bandate'];
	echo "</td><td>";
	echo $row['liftdate'];
	echo "</td><td>";
	echo $row['reason'];
	echo "</td><td>";
}
echo "</table>";

echo "</table>";


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





?>

How can I get that stuff to print into the vBulletin stuff, not insert it infront of it?

Or do you know a better way to do this?

Dismounted · #2 05-25-2007, 09:09 AM

Stuff it all into a variable.

PHP Code:


			
$data .= 'Whatever';

sonichero · #3 05-25-2007, 12:12 PM

and then put the variable into the template.....

You should never have a <td> in a PHP...

You should make a separate template, like $infractionbits.

ZomgStuff · #4 05-25-2007, 06:43 PM

Aight, thanks guys!~

sonichero · #5 05-25-2007, 07:10 PM

can you please share the code with me? I want to release it as a hack that will include infractions and warnings as well.

PM it to me, please. Much appreciated.

ZomgStuff · #6 05-26-2007, 08:44 PM

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

Code:

<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

Code:

<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>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06289 seconds Memory Usage 4,714KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (4)bbcode_code (2)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (6)post_thanks_postbit_info (6)postbit (6)postbit_onlinestatus (6)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/functions_amr.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: