Show Thread Enhancements - Latest x Threads by User

REQ: https://vborg.vbsupport.ru/showthread.php?t=211325

Description
Show X lastest threads by thread starter below his/her the first post.

Info:
Plugins: 3
Phrases: 22
Template: 5
Setting: 6

Install:
Import Product Via Manage Products
ACP >> Plugins & Products >> Manage Products >> [Add/Import Product]


Settings:
ACP >> vBulletin Options >> vBulletin Options >> Lastest X Thread by User Settings

History:
-v3.8.001: First Release
-v3.8.002: Add Lastest Thread on Memberinfo Tab
-v3.8.003: Fixed DB Error when view a thread created by a deleted user
-v3.8.004: Fixed bug: See your own Lastest Threads at other users' profile tabs.

[qbn720]

Very nice additional feature, I really like it and installed. A suggestion for future updates would be to add to the member profile page as either a tab or just a floating box. Either way, great job and keep up the good work.

[ry215]

Originally Posted by qbn720

Very nice additional feature, I really like it and installed. A suggestion for future updates would be to add to the member profile page as either a tab or just a floating box. Either way, great job and keep up the good work.

Done

Enjoy!

Thanks for using it.

[valdet]

This is a very nice add-on.
In future updates, maybe you can add usergroup permissions.

Also I would suggest that instead of disallow Forum IDs, you have the option to Allow ForumIDs so only few forums could have this feature turned on.

It has lots of potential and I look forward to future releases.

Thanks

[Frank Sinatra]

woa now i feel sexy!

thanks a lot, install and nominated of course.

[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?

[ry215]

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.
Can you Please fix this?

Fixed!

Thanks for your report!

[ahmed-samara]

great work

installed

[Honk0815]

nice thanks

Install and Nominated

[ahmed-samara]

Is possible to change the place ? after for befor signature

thanks again

[WuMing]

Nice ! Thanks !