ThistleProse 8 Share Posted July 23, 2020 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 ❤️ Link to comment Share on other sites More sharing options...
Admin Morrigan 1,826 Admin Share Posted August 11, 2020 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. Profile set made by myself and original Artwork by Fae Merriman, my daughter. Link to comment Share on other sites More sharing options...
ThistleProse 8 Author Share Posted August 24, 2020 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 Link to comment Share on other sites More sharing options...
c.widow 123 Share Posted September 1, 2020 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 Link to comment Share on other sites More sharing options...
Recommended Posts