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.

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

[ry215]

Originally Posted by cykelmyggen

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

cykelmyggen

Join Date: Oct 2006
Location: Europe
Version: 3.8.002
Installed: Apr 2009
Posts: 69
Design: Green Hornet,Fixed

-v3.8.003: Fixed DB Error when view a thread created by a deleted user

[cykelmyggen]

Thanks for the fast DB error fix:up:

[H3C x Nevz]

Great mod - installed. I have a couple questions, though. In the profile, how would you:
- Change the title of the tab from "Latest Threads" to something else?
- Move it to, say, the second tab?
- Search in only certain forums, for example, forumid #26?
Thanks.

[NAZIA]

Thanks for sharing great hack...

[Hasann]

nice mod thought but there is something wrong if you go and check to another members profile you can see your own latest threads at another member profiles

[ry215]

Originally Posted by Hasann

nice mod thought but there is something wrong if you go and check to another members profile you can see your own latest threads at another member profiles

Thanks Hasann!

Fixed

[Honk0815]

Can you deactivatet this on PM system?

Once I get a PM by a member, I read this panel.

The name also be lacking in this field ..

I have a screen ...

[josef1]

thanks,
installed and works fine after upgrading to latest version

but where we can control the location of the latest threads ?? as it shows table after thread starter only while i want to move it to the end of thread page

[sensimilla]

Great idea,thanks.