It adds one query for each category, forum, subforum and even for forums hidden from the index. If you don't have permission to see a forum (eg. a staff forum), that doesn't add a query.
My forumhome now uses 46 queries in total for staff members, 39 queries for regular members.
Hasann i have installed your previous HTML Markup ..
i uninstalled that before installing this one but i am getting this Database Error
PHP Code:
Database error in vBulletin 3.8.0 Beta 2:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS hasannuser ON (thread.lastposter = hasannuser.username)
LEFT JOIN user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)
WHERE thread.threadid IN (0,6853,6583,4837,1441,3393,2797,1219,1459,1112,1510,1111,1107,856,913,931,948)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Error Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Script : http://xxx/voiceforums/forumdisplay.php?f=9
Referrer : http://xxx/voiceforums/index.php
IP Address : 77.31.9.228
Username : Kareem
Classname : vB_Database
MySQL Version : 5.0.51a-community
i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load
Hasann i have installed your previous HTML Markup ..
i uninstalled that before installing this one but i am getting this Database Error
PHP Code:
Database error in vBulletin 3.8.0 Beta 2:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS hasannuser ON (thread.lastposter = hasannuser.username)
LEFT JOIN user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)
WHERE thread.threadid IN (0,6853,6583,4837,1441,3393,2797,1219,1459,1112,1510,1111,1107,856,913,931,948)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Error Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Script : http://xxx/voiceforums/forumdisplay.php?f=9
Referrer : http://xxx/voiceforums/index.php
IP Address : 77.31.9.228
Username : Kareem
Classname : vB_Database
MySQL Version : 5.0.51a-community
i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load
i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load
Any change of reducing the additional query.
I want to install this mod, but really do not want to have lots of query running on my home page.
Username HTML Markup in Forumdisplay Details »»
About Developer
Visit Web Site
Uses Plugins 
No support by the author.
12-23-2008, 09:14 AM
