vb.org Archive - Counting Bans Problem

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Counting Bans Problem - Won't Show (https://vborg.vbsupport.ru/showthread.php?t=147989)

Counting Bans Problem - Won't Show

Well I created my own page, /ban.php and I created a template for it.

The problem is, in the php file I have this

Code:

// Count the total bans

    $totalbans = $db->query_first_slave("

    SELECT COUNT(userid)

        FROM userban



    ");

That counts how many bans there have been in the past, not active, but total.

I've run the query in phpmyadmin and it works fine and returns 45.
The problem comes when I'm using my template, I use this

Code:

Total Bans: $totalbans

and it doesn't display a number. What am I doing wrong?

Thanks in advance.

Quote:

Originally Posted by ZomgStuff (Post 1253614)

Well I created my own page, /ban.php and I created a template for it.

The problem is, in the php file I have this

Code:

// Count the total bans

    $totalbans = $db->query_first_slave("

    SELECT COUNT(userid)

        FROM userban



    ");

Code:

Total Bans: $totalbans

and it doesn't display a number. What am I doing wrong?

Thanks in advance.

The code should be

Code:

// Count the total bans

    $totalbans = $db->query_first_slave("

    SELECT COUNT(userid) AS bans

        FROM userban



    ");

The template should reference $totalbans[bans]

The method query_first_slave returns the first row as an array - even if there is only one element.

Ah, didn't work ;-( I tried like 50 different codes last night. Well now I'm glad the code is right but tere is something wrong. It doesn't display the number.

My msn is twolvesfan624@msn.com and aim is twolvesfan369, I think my problem lies with something else. Treat be as a noob to this. I think I'm forgetting a vital step.

By the way I used this tutorial to create a new page.
https://vborg.vbsupport.ru/showthrea...+your+own+page

Edit, so here is my php code

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

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

eval('print_output("' . fetch_template('BAN') . '");');



// Count the total bans

    $totalbans = $db->query_first_slave("

    SELECT COUNT(userid) AS bans

        FROM userban



    ");



 



?>

and 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><h1>BAN LIST</h1></center></td>

</tr>

<tr>

        <td class="alt1">

<center>$vboptions[bbtitle] Ban Statistics</center>

Total Bans: $totalbans[bans]

</td>

</tr>

</table>



$footer

</body>



</html>

Quote:

Originally Posted by ZomgStuff (Post 1253775)

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

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

eval('print_output("' . fetch_template('BAN') . '");');



// Count the total bans

    $totalbans = $db->query_first_slave("

    SELECT COUNT(userid) AS bans

        FROM userban



    ");



 



?>

and 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><h1>BAN LIST</h1></center></td>

</tr>

<tr>

        <td class="alt1">

<center>$vboptions[bbtitle] Ban Statistics</center>

Total Bans: $totalbans[bans]

</td>

</tr>

</table>



$footer

</body>



</html>

You must run the query BEFORE you eval the template. These statements:

Code:

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

eval('print_output("' . fetch_template('BAN') . '");');

Should be the last two in your code. Whenever print_output is called it issues an exit - you never come out of that eval statement and never reach the query.

Quote:

Originally Posted by Michael Morris (Post 1253792)

You must run the query BEFORE you eval the template. These statements:

Code:

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

eval('print_output("' . fetch_template('BAN') . '");');

Should be the last two in your code. Whenever print_output is called it issues an exit - you never come out of that eval statement and never reach the query.

I love you.

Edit:
How can I display an array? IE: Display all the ban id's and say the reason.

for anyone who doesnt know, this is what he wants to do

http://forums.facepunchstudios.com/showbans.php?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (11)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01329 seconds Memory Usage 1,746KB 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 (11)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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: