MyBB - Auto Counting Additional Stats

[ThistleProse 8]

Hi, I'm having a Day, lol

 

I was wondering if I could get a little more help with using this guide?

 

I'm having a failure at figuring out how to make it work. I've tried looking at similar guides but yeah. I'm just failing. x.x

 

Anyone with the time to help would be so appreciated

 

❤️

 

 

[Morrigan 1,826]

I've looked at this thread a dozen times. Unfortunately, without an example its hard to assist with why its not working. The guide is pretty clear.

[ThistleProse 8]

I really don't understand it and I know there is like, one thing I'm missing to make it all click into place and I feel dumb as dirt. But I simply cannot get it to work.

 

I have the php:

 

$countquery = $db->fetch_field(
	$db->query("
		SELECT COUNT(*) as countquery
		FROM ".TABLE_PREFIX."users
		WHERE ".TABLE_PREFIX."users.usergroup IN (10,11,12,13,14)
	"), 'countquery');

 

I'm putting it inside <?php code here ?> like so

 

Then I'm shoving the code above into its own template, as I have the PHP in Templates enabled.

Save.

 

Then I call the template into the index template via the following:  <template census> 

(which works with various other templates, so I know that's not the issue)

 

When I load the page up, its dead: 

 

If I remove the <?php ?> portion, so its just text, it is called forth and makes my page ugly:

 

'

 

So it is working. But it isn't. And I'll be damned if I can figure out what on earth I'm doing wrong :(

 

I'm running:

MyBB 1.8.24

PHP 7.1.33

[c.widow 123]

Hi!

 

I've been off the earth for a while but I'm here to help if needed still.

 

The only thing I can think is possibly the code itself is being a pain about format. Try

<?
$countquery = $db->fetch_field(
	$db->query("
		SELECT COUNT(*) as countquery
		FROM ".TABLE_PREFIX."users
		WHERE ".TABLE_PREFIX."users.usergroup IN (10,11,12,13,14)
	"), 'countquery');
?>

 

If you have further questions please contact my discord Tay#8632 directly. Once we sort out the issue here I can post the fix here so if others have it as well they can figure it out. :)

 

@ThistleProse