[vietdjclub]

Originally Posted by Taurus1

Sorry, I don't understand what you mean. Where do I find the sql command?

Originally Posted by ravenfaust

im getting an sql error
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT user.username, user.usergroupid, user.email, user.languageid, post.userid, post.postid, post.threadid, post.dateline, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
Where thread.open = 1
AND thread.visible = 1
AND post.visible = 1

AND post.phpkd_vblvb_lastcheck < 1261978529LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5' at line 9
Error Number : 1064


same as above

open file phpkd_vblvb.php in includes/cron folder

find

$posts = $vbulletin->db->query_read("
		SELECT user.username, user.usergroupid, user.email, user.languageid, post.userid, post.postid, post.threadid, post.dateline, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
		FROM " . TABLE_PREFIX . "post AS post
		LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
		LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
		Where thread.open = 1
			AND thread.visible = 1
			AND post.visible = 1
			$cutoff
			" . (($vbulletin->options['phpkd_vblvb_checked_posts'] == 2) ? 'AND post.postid = thread.firstpostid' : '')
			. (($vbulletin->options['phpkd_vblvb_succession_period'] > 0) ? 'AND post.phpkd_vblvb_lastcheck < ' . (TIMENOW - (86400 * $vbulletin->options['phpkd_vblvb_succession_period'])) : '')
		. (($vbulletin->options['phpkd_vblvb_limit'] > 0) ? 'LIMIT ' . intval($vbulletin->options['phpkd_vblvb_limit']) : '')
	);

replace with

$posts = $vbulletin->db->query_read("
		SELECT user.username, user.usergroupid, user.email, user.languageid, post.userid, post.postid, post.threadid, post.dateline, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
		FROM " . TABLE_PREFIX . "post AS post
		LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
		LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
		Where thread.open = 1
			AND thread.visible = 1
			AND post.visible = 1
			$cutoff
			" . (($vbulletin->options['phpkd_vblvb_checked_posts'] == 2) ? 'AND post.postid = thread.firstpostid' : '')
			. (($vbulletin->options['phpkd_vblvb_succession_period'] > 0) ? 'AND post.phpkd_vblvb_lastcheck < ' . (TIMENOW - (86400 * $vbulletin->options['phpkd_vblvb_succession_period'])) : '')
		. (($vbulletin->options['phpkd_vblvb_limit'] > 0) ? ' LIMIT ' . intval($vbulletin->options['phpkd_vblvb_limit']) : '')
	);

save it then reuload to your server