[Jim O]

Nope. Those queries return lots of data.

For instance:


select * from vb_template where templateid = 8110:

8110 11 memberlist_resultsbit <tr align=\"center\"> <td class=\"alt1Active\" align=\"$stylevar[left]\" id=\"u$userinfo[userid]\"> <a href=\"member.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl'] . "u=$userinfo[userid]\">$userinfo[musername]</a> ".(($show['usertitlecol']) ? ("<div class=\"smallfont\">$userinfo[usertitle]</div>") : (""))." </td> <!-- show awards --> ".(($vbulletin->options['aw_memberlist']) ? ("<td class=\"$bgclass\">$userinfo[userawards] ".(($userinfo[num_awards]) ? ("<div nowrap> <a href=\"member.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl'] . "u=$userinfo[userid]#award\">$vbphrase[total_awards]: $userinfo[num_awards]</a></div>") : (""))." </td>") : (""))." <!-- /show awards --> ".(($show['emailcol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">".(($show['emaillink']) ? ("<a href=\"sendmessage.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl'] . "do=mailmember&amp;u=$userinfo[userid]\" target=\"_blank\" rel=\"nofollow\"><img src=\"$stylevar[imgdir_button]/email.gif\" alt=\"email.gif\" title=\"" . construct_phrase("$vbphrase[click_here_to_email_x]", "$userinfo[username]") . "\" border=\"0\" /></a>") : (""))."&nbsp;".(($show['pmlink']) ? ("<a href=\"private.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl'] . "do=newpm&amp;u=$userinfo[userid]\" target=\"_blank\" rel=\"nofollow\"><img src=\"$stylevar[imgdir_button]/sendpm.gif\" alt=\"sendpm.gif\" title=\"" . construct_phrase("$vbphrase[send_private_message_to_x]", "$userinfo[username]") . "\" border=\"0\" /></a>") : (""))."</td>") : (""))." ".(($show['imicons'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[icqicon] $userinfo[aimicon] $userinfo[msnicon] $userinfo[yahooicon] $userinfo[skypeicon]</td>") : (""))." ".(($show['homepagecol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">".(($show['homepagelink']) ? ("<a href=\"$userinfo[homepage]\" target=\"_blank\"><img src=\"$stylevar[imgdir_button]/home.gif\" alt=\"home.gif\" title=\"" . construct_phrase("$vbphrase[visit_xs_homepage]", "$userinfo[username]") . "\" border=\"0\" /></a>") : ("&nbsp;"))."</td>") : (""))." ".(($show['searchcol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">".(($show['searchlink']) ? ("<a href=\"search.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl'] . "do=finduser&amp;u=$userinfo[userid]\" rel=\"nofollow\"><img src=\"$stylevar[imgdir_button]/find.gif\" alt=\"find.gif\" title=\"" . construct_phrase("$vbphrase[find_all_posts_by_x]", "$userinfo[username]") . "\" border=\"0\" /></a>") : ("&nbsp;"))."</td>") : (""))." ".(($show['datejoinedcol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[datejoined]</td>") : (""))." ".(($show['postscol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[posts]</td>") : (""))." ".(($show['lastvisitcol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[lastvisit]</td>") : (""))." ".(($show['reputationcol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[reputationdisplay]</td>") : (""))." ".(($show['avatarcol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">".(($show['avatar']) ? ("<img src=\"$avatarurl\" border=\"0\" $avwidth $avheight alt=\"" . construct_phrase("$vbphrase[xs_avatar]", "$userinfo[username]") . "\" hspace=\"4\" vspace=\"4\" />") : ("&nbsp;"))."</td>") : (""))." ".(($show['profilepiccol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[profilepic]</td>") : (""))." ".(($show['birthdaycol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[birthday]</td>") : (""))." ".(($show['agecol'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">$userinfo[age]</td>") : (""))." ".(($show['customfields']) ? ("$customfields") : (""))." ".(($show['usergroup'] AND exec_switch_bg()) ? ("<td class=\"$bgclass\">".(($show['hideleader']) ? ("&nbsp;") : ("<input type=\"checkbox\" name=\"deletebox[$userinfo[userid]]\" value=\"yes\" />"))."</td>") : (""))." </tr> <tr align="center"> <td class="alt1Active" align="$stylevar[left]" id="u$userinfo[userid]"> <a href="member.php?$session[sessionurl]u=$userinfo[userid]">$userinfo[musername]</a> <if condition="$show['usertitlecol']"><div class="smallfont">$userinfo[usertitle]</div></if> </td> <!-- show awards --> <if condition="$vbulletin->options['aw_memberlist']"><td class="$bgclass">$userinfo[userawards] <if condition="$userinfo[num_awards]"><div nowrap> <a href="member.php?$session[sessionurl]u=$userinfo[userid]#award">$vbphrase[total_awards]: $userinfo[num_awards]</a></div></if> </td></if> <!-- /show awards --> <if condition="$show['emailcol'] AND exec_switch_bg()"><td class="$bgclass"><if condition="$show['emaillink']"><a href="sendmessage.php?$session[sessionurl]do=mailmember&amp;u=$userinfo[userid]" target="_blank" rel="nofollow"><img src="$stylevar[imgdir_button]/email.gif" alt="email.gif" title="<phrase 1="$userinfo[username]">$vbphrase[click_here_to_email_x]</phrase>" border="0" /></a></if>&nbsp;<if condition="$show['pmlink']"><a href="private.php?$session[sessionurl]do=newpm&amp;u=$userinfo[userid]" target="_blank" rel="nofollow"><img src="$stylevar[imgdir_button]/sendpm.gif" alt="sendpm.gif" title="<phrase 1="$userinfo[username]">$vbphrase[send_private_message_to_x]</phrase>" border="0" /></a></if></td></if> <if condition="$show['imicons'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[icqicon] $userinfo[aimicon] $userinfo[msnicon] $userinfo[yahooicon] $userinfo[skypeicon]</td></if> <if condition="$show['homepagecol'] AND exec_switch_bg()"><td class="$bgclass"><if condition="$show['homepagelink']"><a href="$userinfo[homepage]" target="_blank"><img src="$stylevar[imgdir_button]/home.gif" alt="home.gif" title="<phrase 1="$userinfo[username]">$vbphrase[visit_xs_homepage]</phrase>" border="0" /></a><else />&nbsp;</if></td></if> <if condition="$show['searchcol'] AND exec_switch_bg()"><td class="$bgclass"><if condition="$show['searchlink']"><a href="search.php?$session[sessionurl]do=finduser&amp;u=$userinfo[userid]" rel="nofollow"><img src="$stylevar[imgdir_button]/find.gif" alt="find.gif" title="<phrase 1="$userinfo[username]">$vbphrase[find_all_posts_by_x]</phrase>" border="0" /></a><else />&nbsp;</if></td></if> <if condition="$show['datejoinedcol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[datejoined]</td></if> <if condition="$show['postscol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[posts]</td></if> <if condition="$show['lastvisitcol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[lastvisit]</td></if> <if condition="$show['reputationcol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[reputationdisplay]</td></if> <if condition="$show['avatarcol'] AND exec_switch_bg()"><td class="$bgclass"><if condition="$show['avatar']"><img src="$avatarurl" border="0" $avwidth $avheight alt="<phrase 1="$userinfo[username]">$vbphrase[xs_avatar]</phrase>" hspace="4" vspace="4" /><else />&nbsp;</if></td></if> <if condition="$show['profilepiccol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[profilepic]</td></if> <if condition="$show['birthdaycol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[birthday]</td></if> <if condition="$show['agecol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[age]</td></if> <if condition="$show['customfields']">$customfields</if> <if condition="$show['usergroup'] AND exec_switch_bg()"><td class="$bgclass"><if condition="$show['hideleader']">&nbsp;<else /><input type="checkbox" name="deletebox[$userinfo[userid]]" value="yes" /></if></td></if> </tr> template 1205805209 Jim O 3.7.0 Beta 6 vbulletin

select * from vb_template where templateid = 13045

13045 -1 WHOSONLINE $stylevar[htmldoctype] <html xmlns=\"http://www.w3.org/1999/xhtml\" dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\"> <head> $headinclude ".(($show['refresh']) ? (" ".((is_browser('mozilla')) ? (" <script type=\"text/javascript\"> <!-- var myvar = \"\"; var timeout = $refreshtime; function exec_refresh() { var timerID = setTimeout(\"exec_refresh();\", 100); if (timeout > 0) { timeout -= 1; } else { clearTimeout(timerID); window.location=\"online.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl_js'] . "order=$sortorder&sort=$sortfield&pp=$perpage&page =$pagenumber$refreshargs_js\"; } } exec_refresh(); //--> </script> ") : (" <meta http-equiv=\"refresh\" content=\"" . $GLOBALS['vbulletin']->options['WOLrefresh'] . ";url=online.php?" . $GLOBALS['vbulletin']->session->vars['sessionurl'] . "order=$sortorder&amp;sort=$sortfield&amp;pp=$perp age&amp;page=$pagenumber$refreshargs\" /> "))." ") : (""))." <title>" . $GLOBALS['vbulletin']->options['bbtitle'] . " - $vbphrase[whos_online]</title> </head> <body> $header $navbar ".(($pagenav) ? (" <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"margin-bottom:3px\"> <tr valign=\"bottom\"> <td align=\"$stylevar[right]\">$pagenav</td> </tr> </table> ") : (""))." <table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\" id=\"woltable\"> <tr> <td class=\"tcat\" colspan=\"$colspan\"><div class=\"smallfont\"> <span style=\"float:$stylevar[right]\"> <a href=\"$reloadurl\"><strong>$vbphrase[reload_this_page]</strong></a> </span> <strong>" . construct_phrase("$vbphrase[x_members_and_y_guests]", "$numbervisible", "$numberguests") . "</strong><br />" . construct_phrase("$vbphrase[most_users_ever_online_was_x_y_at_z]", "$recordusers", "$recorddate", "$recordtime") . " </div></td> </tr> <tr> <td class=\"thead\"> <span style=\"float:$stylevar[right]\"> <a href=\"$sorturl".((!$show['sorturlnoargs']) ? ("&amp;") : (""))."order=desc&amp;sort=time&amp;pp=$perpage&am p;page=$pagenumber\">$vbphrase[last_activity]</a> $sortarrow[time] </span> <a href=\"$sorturl".((!$show['sorturlnoargs']) ? ("&amp;") : (""))."order=asc&amp;sort=username&amp;pp=$perpage &amp;page=$pagenumber\">$vbphrase[username]</a> $sortarrow[username] </td> <td class=\"thead\"><a href=\"$sorturl".((!$show['sorturlnoargs']) ? ("&amp;") : (""))."order=asc&amp;sort=location&amp;pp=$perpage &amp;page=$pagenumber\">$vbphrase[location_temp]</a> $sortarrow[location]</td> ".(($show['ip']) ? ("<td class=\"thead\">$vbphrase[ip_address]</td>") : (""))." ".(($GLOBALS['vbulletin']->options['showimicons']) ? ("<td class=\"thead\" align=\"center\">$vbphrase[instant_messaging]</td>") : (""))." </tr> $onlinebits </table> ".(($show['ajax_resolve']) ? (" <script type=\"text/javascript\" src=\"clientscript/vbulletin_ajax_wolresolve.js?v=" . $GLOBALS['vbulletin']->options['simpleversion'] . "\"></script> <script type=\"text/javascript\"> <!-- vB_AJAX_WolResolve_Init('woltable'); //--> </script> ") : (""))." <br /> <table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\"> <tr> <td class=\"alt1\" align=\"center\"> <form action=\"online.php\" method=\"get\"> <input type=\"hidden\" name=\"s\" value=\"" . $GLOBALS['vbulletin']->session->vars['sessionhash'] . "\" /> <input type=\"hidden\" name=\"sortfield\" value=\"$sortfield\" /> <input type=\"hidden\" name=\"sortorder\" value=\"$sortorder\" /> <div class=\"fieldset\" style=\"margin:0px\"> ".(($GLOBALS['vbulletin']->options['WOLguests']) ? (" $vbphrase[display]: <select name=\"who\"> <option value=\"all\" $whoselected[0]>$vbphrase[all]</option> <option value=\"members\" $whoselected[1]>$vbphrase[members]</option> <option value=\"guests\" $whoselected[2]>$vbphrase[guests]</option> ".(($GLOBALS['vbulletin']->options['enablespiders']) ? (" <option value=\"spiders\" $whoselected[3]>$vbphrase[search_bots]</option> ") : (""))." </select> &nbsp; &nbsp; ") : (""))." ".(($show['ip']) ? (" $vbphrase[user_agent]: <select name=\"ua\"> <option value=\"1\" $uaselected[1]>$vbphrase[yes]</option> <option value=\"0\" $uaselected[0]>$vbphrase[no]</option> </select> &nbsp; &nbsp; ") : (""))." $vbphrase[per_page]: <input type=\"text\" class=\"bginput\" style=\"font-size:11px\" name=\"pp\" value=\"$perpage\" size=\"2\" /> &nbsp; &nbsp; <input type=\"submit\" class=\"button\" value=\"$vbphrase[display]\" accesskey=\"s\" /> </div> </form> </td> </tr> </table> ".(($pagenav) ? (" <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"margin-top:3px\"> <tr valign=\"top\"> <td align=\"$stylevar[right]\">$pagenav</td> </tr> </table> ") : (""))." <br /> <!-- icons and forum jump --> <table cellpadding=\"0\" cellspacing=\"2\" border=\"0\" width=\"100%\"> <tr valign=\"bottom\"> <td width=\"100%\"> <table cellpadding=\"2\" cellspacing=\"0\" border=\"0\"> <col align=\"center\"></col> <tr> <td><strong>+</strong></td> <td class=\"smallfont\">&nbsp; $vbphrase[user_is_on_your_contact_list]</td> </tr> ".(($show['hidden']) ? (" <tr> <td><strong>*</strong></td> <td class=\"smallfont\">&nbsp; $vbphrase[user_is_invisible_to_others]</td> </tr> ") : (""))." ".(($show['badlocation']) ? (" <tr> <td><img src=\"$stylevar[imgdir_statusicon]/wol_lockedout.gif\" alt=\"$vbphrase[viewing_forum_closed]\" /></td> <td class=\"smallfont\">&nbsp; $vbphrase[viewing_forum_closed]</td> </tr> <tr> <td><img src=\"$stylevar[imgdir_statusicon]/wol_nopermission.gif\" alt=\"$vbphrase[viewing_no_permission_message]\" /></td> <td class=\"smallfont\">&nbsp; $vbphrase[viewing_no_permission_message]</td> </tr> <tr> <td><img src=\"$stylevar[imgdir_statusicon]/wol_error.gif\" alt=\"$vbphrase[viewing_error_message]\" /></td> <td class=\"smallfont\">&nbsp; $vbphrase[viewing_error_message]</td> </tr> ") : (""))." </table> </td> <td> $forumjump </td> </tr> </table> <!-- / icons and forum jump --> $footer </body> </html> $stylevar[htmldoctype] <html xmlns="http://www.w3.org/1999/xhtml" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]"> <head> $headinclude <if condition="$show['refresh']"> <if condition="is_browser('mozilla')"> <script type="text/javascript"> <!-- var myvar = ""; var timeout = $refreshtime; function exec_refresh() { var timerID = setTimeout("exec_refresh();", 100); if (timeout > 0) { timeout -= 1; } else { clearTimeout(timerID); window.location="online.php?$session[sessionurl_js]order=$sortorder&sort=$sortfield&pp=$perpage&page= $pagenumber$refreshargs_js"; } } exec_refresh(); //--> </script> <else /> <meta http-equiv="refresh" content="$vboptions[WOLrefresh];url=online.php?$session[sessionurl]order=$sortorder&amp;sort=$sortfield&amp;pp=$perpa ge&amp;page=$pagenumber$refreshargs" /> </if> </if> <title>$vboptions[bbtitle] - $vbphrase[whos_online]</title> </head> <body> $header $navbar <if condition="$pagenav"> <table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-bottom:3px"> <tr valign="bottom"> <td align="$stylevar[right]">$pagenav</td> </tr> </table> </if> <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" id="woltable"> <tr> <td class="tcat" colspan="$colspan"><div class="smallfont"> <span style="float:$stylevar[right]"> <a href="$reloadurl"><strong>$vbphrase[reload_this_page]</strong></a> </span> <strong><phrase 1="$numbervisible" 2="$numberguests">$vbphrase[x_members_and_y_guests]</phrase></strong><br /><phrase 1="$recordusers" 2="$recorddate" 3="$recordtime">$vbphrase[most_users_ever_online_was_x_y_at_z]</phrase> </div></td> </tr> <tr> <td class="thead"> <span style="float:$stylevar[right]"> <a href="$sorturl<if condition="!$show['sorturlnoargs']">&amp;</if>order=desc&amp;sort=time&amp;pp=$perpage&amp;pa ge=$pagenumber">$vbphrase[last_activity]</a> $sortarrow[time] </span> <a href="$sorturl<if condition="!$show['sorturlnoargs']">&amp;</if>order=asc&amp;sort=username&amp;pp=$perpage&amp ;page=$pagenumber">$vbphrase[username]</a> $sortarrow[username] </td> <td class="thead"><a href="$sorturl<if condition="!$show['sorturlnoargs']">&amp;</if>order=asc&amp;sort=location&amp;pp=$perpage&amp ;page=$pagenumber">$vbphrase[location_temp]</a> $sortarrow[location]</td> <if condition="$show['ip']"><td class="thead">$vbphrase[ip_address]</td></if> <if condition="$vboptions['showimicons']"><td class="thead" align="center">$vbphrase[instant_messaging]</td></if> </tr> $onlinebits </table> <if condition="$show['ajax_resolve']"> <script type="text/javascript" src="clientscript/vbulletin_ajax_wolresolve.js?v=$vboptions[simpleversion]"></script> <script type="text/javascript"> <!-- vB_AJAX_WolResolve_Init('woltable'); //--> </script> </if> <br /> <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center"> <tr> <td class="alt1" align="center"> <form action="online.php" method="get"> <input type="hidden" name="s" value="$session[sessionhash]" /> <input type="hidden" name="sortfield" value="$sortfield" /> <input type="hidden" name="sortorder" value="$sortorder" /> <div class="fieldset" style="margin:0px"> <if condition="$vboptions['WOLguests']"> $vbphrase[display]: <select name="who"> <option value="all" $whoselected[0]>$vbphrase[all]</option> <option value="members" $whoselected[1]>$vbphrase[members]</option> <option value="guests" $whoselected[2]>$vbphrase[guests]</option> <if condition="$vboptions['enablespiders']"> <option value="spiders" $whoselected[3]>$vbphrase[search_bots]</option> </if> </select> &nbsp; &nbsp; </if> <if condition="$show['ip']"> $vbphrase[user_agent]: <select name="ua"> <option value="1" $uaselected[1]>$vbphrase[yes]</option> <option value="0" $uaselected[0]>$vbphrase[no]</option> </select> &nbsp; &nbsp; </if> $vbphrase[per_page]: <input type="text" class="bginput" style="font-size:11px" name="pp" value="$perpage" size="2" /> &nbsp; &nbsp; <input type="submit" class="button" value="$vbphrase[display]" accesskey="s" /> </div> </form> </td> </tr> </table> <if condition="$pagenav"> <table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-top:3px"> <tr valign="top"> <td align="$stylevar[right]">$pagenav</td> </tr> </table> </if> <br /> <!-- icons and forum jump --> <table cellpadding="0" cellspacing="2" border="0" width="100%"> <tr valign="bottom"> <td width="100%"> <table cellpadding="2" cellspacing="0" border="0"> <col align="center"></col> <tr> <td><strong>+</strong></td> <td class="smallfont">&nbsp; $vbphrase[user_is_on_your_contact_list]</td> </tr> <if condition="$show['hidden']"> <tr> <td><strong>*</strong></td> <td class="smallfont">&nbsp; $vbphrase[user_is_invisible_to_others]</td> </tr> </if> <if condition="$show['badlocation']"> <tr> <td><img src="$stylevar[imgdir_statusicon]/wol_lockedout.gif" alt="$vbphrase[viewing_forum_closed]" /></td> <td class="smallfont">&nbsp; $vbphrase[viewing_forum_closed]</td> </tr> <tr> <td><img src="$stylevar[imgdir_statusicon]/wol_nopermission.gif" alt="$vbphrase[viewing_no_permission_message]" /></td> <td class="smallfont">&nbsp; $vbphrase[viewing_no_permission_message]</td> </tr> <tr> <td><img src="$stylevar[imgdir_statusicon]/wol_error.gif" alt="$vbphrase[viewing_error_message]" /></td> <td class="smallfont">&nbsp; $vbphrase[viewing_error_message]</td> </tr> </if> </table> </td> <td> $forumjump </td> </tr> </table> <!-- / icons and forum jump --> $footer </body> </html> template 1212145003 Jelsoft 3.7.2 vbulletin

So these are some fairly standard templates it would seem.

I do have styles that are unavailable for users to select, but enabling them, flushing the cache and looking again made no difference on the empties. Like I said, all template caches appear to be empty.