[cykelmyggen]

Originally Posted by Honk0815

nice addon...

And i Found 1 Bug...

If I wanna open / view a thread which was created by a person who is deleted, the server reads an SQL ERROR.

Datenbankfehler in vBulletin 3.8.2:

Invalid SQL:

			SELECT
				thread.threadid, thread.title, thread.lastpost, thread.forumid, 
				thread.replycount, thread.lastposter, thread.dateline, thread.prefixid,
                IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, 
				thread.visible, user.username, user.userid, user.usergroupid, 
				IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, 
				forum.title_clean as forum_title, post.pagetext AS preview, post.allowsmilie, post.postid 
				FROM thread AS thread
				LEFT JOIN user AS user ON (user.username = thread.lastposter)
				LEFT JOIN forum as forum ON (thread.forumid = forum.forumid)
				LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
				WHERE thread.visible = '1' AND post.visible = '1' AND thread.open!='10'
				AND thread.postuserid IN ()
				AND thread.forumid NOT IN (0) 
				ORDER BY thread.dateline DESC 
				LIMIT 5;

MySQL-Fehler  : 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 ')
				AND thread.forumid NOT IN (0) 
				ORDER BY thread.dateline DESC 
				L' at line 13

Can you Please fix this?

I'm getting this one too. Hopefully this issue will be fixed on this great plugin:up: