Question about $templatesused...

[cirisme]

What's the easiest way to tell if a template is being called that is not on the templatesused list?

[Boofo]

Look in the php file. ;)

[cirisme]

Hehehehe, I was hoping for a log or something. Oh well. ;)

[rake]

use explain=1 on pages. Look for a query like SELECT * FROM template WHERE title IN (blah,blahblah,blahblah) ;)

[Boofo]

Or you could do that. ;)

[filburt1]

You can also very easily modify gettemplate to echo the names of uncached templates when they're eval'ed. That's what I do on my test board to make sure $templatesused is correct.

[Boofo]

How would you do that? I'd like to try it.

[filburt1]

I don't have a reference vB2 functions.php ATM but if you have my embed PHP tags in templates hack installed, find:

if (isset($templatecache[$templatename]))
{
$toreturn = $templatecache[$templatename];
}
else
{
$template = $DB_site->query_first("SELECT template FROM template
WHERE title = \"" . addslashes($templatename) . "\"
AND (templatesetid = -1 OR templatesetid = $templatesetid)
ORDER BY templatesetid DESC LIMIT 1");
$toreturn = $template['template'];
$templatecache[$templatename] = $toreturn;
}

Replace with:

if (isset($templatecache[$templatename]))
{
$toreturn = $templatecache[$templatename];
}
else
{
echo "Template <b>$templatename</b> wasn't cached!<br>";
$template = $DB_site->query_first("SELECT template FROM template
WHERE title = \"" . addslashes($templatename) . "\"
AND (templatesetid = -1 OR templatesetid = $templatesetid)
ORDER BY templatesetid DESC LIMIT 1");
$toreturn = $template['template'];
$templatecache[$templatename] = $toreturn;
}

[Boofo]

Here's what I have for that code:

if (isset($templatecache[$templatename])) {
$template=$templatecache[$templatename];
} else {
$gettemp=$DB_site->query_first("SELECT template FROM template WHERE title='".addslashes($templatename)."' AND (templatesetid=-1 OR templatesetid=" . intval($templatesetid). ") ORDER BY templatesetid DESC LIMIT 1");
$template=$gettemp[template];
$templatecache[$templatename]=$template;
}

[filburt1]

Then right above that query, add:

echo "<b>$templatename</b> isn't cached!<br>";

[Boofo]

How can I make this so it only shows the un-cached templates for the admin only?

Thank you for the code, by the way. I am finding a few spots where I must have missed a few templates. ;)

[Tigga]

Something like this should work...

if ($bbuserinfo['usergroupid']=='6') {
echo "<b>$templatename</b> isn't cached!<br>";
}

[Boofo]

Thanks, Tigga. ;) That's what I had but I wanted to make sure it wouldn't mess anything up with the "} else {" right above it.

LOL filburt, you are gonna love this one. Take a look at your file cannedtext.php and you'll notice that you have $templateused instead of $templatesused in both spots. ;)

[Erwin]

Good tip, filburt1. :) Should release it as a mini-hack.

[Erwin]

Just confirming, the code should end up looking like this:


if (isset($templatecache[$templatename])) {
$template=$templatecache[$templatename];
} else {
if ($bbuserinfo['userid']=='1') {
echo "<b>$templatename</b> isn't cached!<br>";
}
$gettemp=$DB_site->query_first("SELECT template FROM template WHERE title='".addslashes($templatename)."' AND (templatesetid=-1 OR templatesetid=" . intval($templatesetid). ") ORDER BY templatesetid DESC LIMIT 1");
$template=$gettemp[template];
$templatecache[$templatename]=$template;
}

[filburt1]

Are you sure $bbuserinfo is in the global scope there?

[Erwin]

It's not, but I've added it. Is that the right place to put the echo bit?

[Erwin]

I assume it is since it works...

[Boofo]

And I also found out the hard way that you have to add $bbuserinfo to the global statement right above it or it won't work. ;)