[Easy5s.net]

Originally Posted by kh99

Actually now that I've looked at some more code, I think you can piggy back it on another query so you don't have to add one. To try that, create a new plugin using hook cache_ordered_forums and code like this:

$counter_select .= ', thread.dateline AS lastthreaddateline ';
$tachyjoin .= ' LEFT JOIN ' . TABLE_PREFIX . 'thread AS thread ON(lastthreadid = thread.threadid)';

and then you should be able to use $forum['lastthreaddateline'] in your plugin (but I haven't tried it at all).

I have to try and error

Database error in vBulletin 4.2.0:

Invalid SQL:


				SELECT subscribeforumid, forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, thread.threadid, thread.field6 AS field6, thread.field7 AS field7, thread.dateline AS lastthreaddateline , user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
					user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
					
				FROM forum AS forum
				LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 1)
				
				LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
				LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
				 LEFT JOIN thread AS thread ON (thread.threadid=forum.lastthreadid) LEFT JOIN thread AS thread ON(lastthreadid = thread.threadid);

MySQL Error   : Not unique table/alias: 'thread'
Error Number  : 1066
Request Date  : Wednesday, January 23rd 2013 @ 12:31:43 AM
Error Date    : Wednesday, January 23rd 2013 @ 12:31:43 AM
Script        : http://localhost/forum.php
Referrer      : http://localhost/showthread.php?t=571&p=815
IP Address    : 123.19.70.155
Username      : Admin
Classname     : vB_Database
MySQL Version : 5.3.8-MariaDB

Stack Trace:

#0 vB_Database->halt() called in [path]\includes\class_core.php on line 426
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 473
#2 vB_Database->query_read_slave() called in [path]\includes\functions.php on line 4901
#3 cache_ordered_forums() called in [path]\forum.php on line 594

and use code

PHP Code:

"SELECT lastthreaddateline FROM " . TABLE_PREFIX . "thread WHERE threadid = " . $forum['lastthreadid'] 


Unknown column 'lastthreaddateline' in 'field list'