Very bad optimization, this mod generates big load! This mod should go to trash...

Nice hack. Btw, may i have the theme of your forum?

it works fine for 3.7.4 thx ;)

who are you?

if not working please uninstall it

Thank you!

People should know that installing this mod can cause high load and lay off from shared hosting... You ignored my pm so how can I have enough respect for you...

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,15 10,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



Hassann :o

when i click on my forums Database errors shows up :s
i have removed all files and uninstalled the ( product-username_html_markup.xml )

but No Gain same error :o

can you please tell whats wrong :(

something's wrong with ( functions_forumlist.php )

Working on 3.7.4 with no problems,apprciated:up:

did you installed this hack ?
https://vborg.vbsupport.ru/showthread.php?t=199568

Reserved

is there a way to have it work on vBa CMPS..??
thank you..

I would like to appear colored nicks in the results of the search

I have vBExperience installed and in the statistic list, can this be added too?

thanks jejeje

Worked perfectly without problems, thank you ^^

thanks...great mod

Great for readibility thx :)

S?per. Teşekk?rler hasann. Sorunsuz ?alıştı.