Latest x Threads by User

[ry215]

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.

[Hasann]

very nice idea noob installed

[ry215]

very nice idea noob installed

Thanks Hasann! :D

[saadessa]

very nice thank you

[Si?uNoopy]

Nice thanks you !

[Sweeks]

Can this be limited to admin use?
________
Asian american (http://www.++++tube.com/categories/111/american/videos/1)

[yahoooh]

does it show the current new thread for him?
if yes it should be not shown

[aryshi]

great, i like it ;)

[Jasem]

Nice work, thank you!

[dvbusuario]

Show "lastest x threads by forum" ?

It may last for 5 forum topics?

Install & Nominated!

Thank you.

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

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

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]

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 !

[cykelmyggen]

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]

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]

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

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

[rainyleaves]

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 ...

I get same result.
Please fix this problem.

[GokhanT]

very nice thank you :up:

[AteNa]

Thanks ...

[Yonatan]

Great Mod!
But why you use your own $vbphrase instead of default $vbphrase(i.e. - $vbphrase[lxt_views] instead of $vbphrase[views])?

[baghdad4ever]

thanks

is it cause server load in the big forum or not?

[Chadi]

Is it possible to disable the forumdisplay of this mod? I just want the tab in the member's profile for now.

Thanks

[kyrenator]

nice mod!

[mikey1991]

Can this be limited to threads from one forum, say if I post an announcement in announcement forum which is forumid 2, under my first post, would be the "5 latest announcments"

[rinkrat]

I installed it and I think it's outstanding! The only change I had to make was correcting the non-existent word "lastest" to "latest".

[MikesSite]

installed, thanks

[ricardoNJ]

There's a problem.
I have installed the mod "Multiple Account Detection & Prevention" and when this mod send me a advise about any user in a invisible post, per example:

http://img20.imageshack.us/img20/7481/lastx.jpg
"In this example, I'm using another user name, no my Admin name."

Then this notice can see another user with this mod "Latest x Threads by User" :eek:

[meijin]

I have installed this and it works great. However, it would be fantastic if you could have the portion that shows in the thread have an option to default to collapsed and then be able to open if you'd like.

Thanks for your work on this!

[TimberFloorAu]

Brilliant addition:

I have adapted the xml file, by changing lastet to latest.

Excellent work :up:

[Lasthero]

Nice..

[TimberFloorAu]

IS there anyway to set the cookie, for minimizing the last 5 threads by user in threads?

[FIM]

hello, you can find below similar threads ?

example: http://www.amerika-forum.de/daycare-kosten-71421.html, see similar threads

[RTMdotORG]

I have installed this and it works great. However, it would be fantastic if you could have the portion that shows in the thread have an option to default to collapsed and then be able to open if you'd like.

Thanks for your work on this!

to collapse by default,
open the product given...

find:

<tbody id="collapseobj_lastest_x_threads" style="$vbcollapse[collapseobj_lastest_x_threads]">

replace with:

<tbody id="collapseobj_lastest_x_threads" style="$vbcollapse[collapseobj_lastest_x_threads]; display:none">

then reinstall the mod and allow overwrite.:D

hello, you can find below similar threads ?

example: http://www.amerika-forum.de/daycare-kosten-71421.html, see similar threads

It looks like your text is too long, change the length of preview or thread name shorter and it should look better...hard for me to tell with the language on your board what exactly it is.

[yeshoward]

nice and installed, click installed too, BUT

How could I move that bock under "tags" block of thread?

[SnakeV]

How can i move it to other location?

For example i want to put it below the Similar Threads.

Thanks

[zaman_q8]

installed...
it was helpful mods/enhancer

thanks and keep it up:)

[Markets Where]

Very good plugin, how to add a link to the latest poster of each thread? Then we can check the latest poster's threads also.

Thanks.

[Markets Where]

<a href="http://forums.glassesadvisor.com/showthread.php?t=7405" target="_blank">http://forums.glassesadvisor.com/showthread.php?t=7405</a>

I want to move the 5 Latest Threads by smiling under Similar Threads, what to do?
tks.

[donny84]

installs but doesnt show on the forum, any ideas?

[letsjoy]

Really rocks...add more options in it :D

[Capt.Jack]

Very nice mod. Thank you.

I have set the result # to 0 to disable the display on showthread.
I have also excluded all but forumid #39 so that only results from it are displayed. I know there is a way to change the code to include only #39, but this was easy and will do for now.

Now, I would like to set the number of results for the members page to a very high number and paginate the results. Unfortunately, I've worked on this for hours and can't figure it out. Is there someone out there that can help me?

Here is an unedited copy of the plugin which controls the members block:

$blocklist = array_merge($blocklist, array(
'lxt_memberinfo' => array(
'class' => 'lxt_memberinfo',
'title' => $vbphrase['lxt_threads_member'],
'hook_location' => 'profile_left_middle_one'
)
));

class vB_ProfileBlock_lxt_memberinfo extends vB_ProfileBlock
{
var $template_name = 'memberinfo_block_lxt_memberinfo';

function confirm_empty_wrap()
{
return false;
}

function confirm_display()
{
return ($this->block_data['lxt_memberinfo'] != '');
}

function prepare_output($id = '', $options = array())
{
global $stylevar, $db, $vbulletin, $vbphrase;

$lxt_limit_member = $vbulletin->options['lxt_limit_number_member'];
$trimthreadtitle = $vbulletin->options['lxt_trimthreadtitles'];
$excludedforums = '';
if ($vbulletin->options['lxt_exclude_forums'] !== '') {
$excludedforums = ',' . $vbulletin->options['lxt_exclude_forums'];
}

$excludedforums = substr($excludedforums, 1);

if ($excludedforums != "") {
$excludedforums = "AND thread.forumid NOT IN ($excludedforums)";
}

$get_lxts = $db->query_read_slave("
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 " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
LEFT JOIN " . TABLE_PREFIX . "forum as forum ON (thread.forumid = forum.forumid)
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
WHERE thread.visible = '1' AND post.visible = '1' AND thread.open!='10'
AND thread.postuserid = " . intval ($vbulletin->GPC['userid']) . "
$excludedforums
ORDER BY thread.dateline DESC
LIMIT $lxt_limit_member");

if ($db->num_rows($get_lxts))
{
while ($get_lxt = $db->fetch_array($get_lxts)) {

$fperms = fetch_permissions($get_lxt['forumid']);
if (($fperms & $vbulletin->bf_ugp_forumpermissions['canview']) AND
(($fperms & $vbulletin->bf_ugp_forumpermissions['canviewothers']) OR ($vbulletin->userinfo['userid'] != 0 AND $simthread['postuserid'] == $vbulletin->userinfo['userid']))
)
{
if (isset($get_lxt['preview']) AND $vbulletin->options['ltx_threadpreview'] > 0)
{
$get_lxt['preview'] = strip_quotes($get_lxt['preview']);
$get_lxt['preview'] = htmlspecialchars_uni(fetch_trimmed_title(strip_bbc ode($get_lxt['preview'], false, true), $vbulletin->options['ltx_threadpreview']));
}
if ($get_lxt['prefixid'])
{
$get_lxt['prefix_plain_html'] = htmlspecialchars_uni($vbphrase["prefix_$get_lxt[prefixid]_title_plain"]);
$get_lxt['prefix_rich'] = $vbphrase["prefix_$get_lxt[prefixid]_title_rich"];
}
else
{
$get_lxt['prefix_plain_html'] = '';
$get_lxt['prefix_rich'] = '';
}
$get_lxt[musername] = fetch_musername($get_lxt);
$get_lxt[fullthreadtitle] = strip_tags($get_lxt[title]);
if ($trimthreadtitle > 0) {
$get_lxt[titletrimmed] = fetch_trimmed_title($get_lxt[fullthreadtitle], $trimthreadtitle);
}
else {
$get_lxt[titletrimmed] = $get_lxt[fullthreadtitle];
}
$get_lxt[newpost] = ($get_lxt[lastpost] > $vbulletin->userinfo['lastvisit'])? 'new' : 'old';
$get_lxt_forumtitle = strip_tags($vbulletin->forumcache["$get_lxt[forumid]"]['title_clean']);
$get_lxt_startdate = vbdate($vbulletin->options['dateformat'], $get_lxt[dateline]);
$get_lxt_time = vbdate($vbulletin->options['timeformat'], $get_lxt[dateline]);
eval('$lxt_memberinfo_bits .= "' . $vbulletin->templatecache['memberinfo_lxt_bits'] . '";');
}
}
eval('$lxt_memberinfo_out .= "' . fetch_template('memberinfo_lxt') . '";');
}
$db->free_result($get_lxts);

$this->block_data['lxt_memberinfo'] = $lxt_memberinfo_out;
}
}

[inciarco]

How can i move it to other location?

For example i want to put it below the Similar Threads.

Thanks

I Also Had the Same Question.

Thank You ry215 for Sharing this Great Mod. :up:

(Nominated, Of Course). ;)

Perhaps You Can Include the Possibility to Choose to Locate the Code of the "showthread_lxt" Template in the Postbit (as it is by Default), and also in a Location on the "ShowThread" Template, using a Replacing Code like "$similarthreads". ;)

Now, to Place it Under "Similar Threads", (Code $similarthreads in the ShowThread Template):

1.

Disable Plugin "LXT - Postbit Complete".

2.

On Template "showthread_lxt", Delete the First "<br />" at the Beginning of the Code. (That "<br />" adds an Extra Space that is Not Necessary).

3.

Create and Activate a New Plugin:

Name: LXT - Postbit Complete - Under Similar Threads - ShowThread_Complete

Hook: showthread_complete

Code:

global $vbulletin, $db;
if ($vbulletin->options['lxt_enable']) {

$lxt_limit = $vbulletin->options['lxt_limit_number'];
$trimthreadtitle = $vbulletin->options['lxt_trimthreadtitles'];
$excludedforums = '';
if ($vbulletin->options['lxt_exclude_forums'] !== '') {
$excludedforums = ',' . $vbulletin->options['lxt_exclude_forums'];
}

$excludedforums = substr($excludedforums, 1);

if ($excludedforums != "") {
$excludedforums = "AND thread.forumid NOT IN ($excludedforums)";
}

$get_lxts = $db->query_read_slave("
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 " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
LEFT JOIN " . TABLE_PREFIX . "forum as forum ON (thread.forumid = forum.forumid)
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
WHERE thread.visible = '1' AND post.visible = '1' AND thread.open!='10'
AND thread.postuserid IN (".$thread['postuserid'].")
$excludedforums
ORDER BY thread.dateline DESC
LIMIT $lxt_limit");

if ($db->num_rows($get_lxts))
{
while ($get_lxt = $db->fetch_array($get_lxts)) {

$fperms = fetch_permissions($get_lxt['forumid']);
if (($fperms & $vbulletin->bf_ugp_forumpermissions['canview']) AND
(($fperms & $vbulletin->bf_ugp_forumpermissions['canviewothers']) OR ($vbulletin->userinfo['userid'] != 0 AND $simthread['postuserid'] == $vbulletin->userinfo['userid']))
)
{
if (isset($get_lxt['preview']) AND $vbulletin->options['ltx_threadpreview'] > 0)
{
$get_lxt['preview'] = strip_quotes($get_lxt['preview']);
$get_lxt['preview'] = htmlspecialchars_uni(fetch_trimmed_title(strip_bbc ode($get_lxt['preview'], false, true), $vbulletin->options['ltx_threadpreview']));
}
if ($get_lxt['prefixid'])
{
$get_lxt['prefix_plain_html'] = htmlspecialchars_uni($vbphrase["prefix_$get_lxt[prefixid]_title_plain"]);
$get_lxt['prefix_rich'] = $vbphrase["prefix_$get_lxt[prefixid]_title_rich"];
}
else
{
$get_lxt['prefix_plain_html'] = '';
$get_lxt['prefix_rich'] = '';
}
$get_lxt[fullthreadtitle] = strip_tags($get_lxt[title]);
$get_lxt[musername] = fetch_musername($get_lxt);
if ($trimthreadtitle > 0) {
$get_lxt[titletrimmed] = fetch_trimmed_title($get_lxt[fullthreadtitle], $trimthreadtitle);
}
else {
$get_lxt[titletrimmed] = $get_lxt[fullthreadtitle];
}
$get_lxt[newpost] = ($get_lxt[lastpost] > $vbulletin->userinfo['lastvisit'])? 'new' : 'old';
$get_lxt_forumtitle = strip_tags($vbulletin->forumcache["$get_lxt[forumid]"]['title_clean']);
$get_lxt_startdate = vbdate($vbulletin->options['dateformat'], $get_lxt[dateline]);
$get_lxt_time = vbdate($vbulletin->options['timeformat'], $get_lxt[dateline]);
eval('$lxt_bits .= "' . $vbulletin->templatecache['showthread_lxt_bits'] . '";');
}
}
$threadstart = $thread['postusername'];
eval('$similarthreads .= "' . fetch_template('showthread_lxt') . '";');
}
$db->free_result($get_lxts);
}

4.

That's it, the Location is Adjusted by the Following Line in the Code:

eval('$similarthreads .= "' . fetch_template('showthread_lxt') . '";');


Notice the $similarthreads in the Code. ;)


My Best Regards.

:)

[farazfaraz]

yes yes
nice

[haytham]

Thanks installed but only showing on profile page although that is not bad.

[chikkoo]

I installed this mod long back, I liked it very much. But I would appreciate if we could select the forums in the Member profile.

I want to display only 4-5 forums, but want to display it forumwise.

Can someone help me, how to modify this?

[chikkoo]

Very nice Mod....

Similar to Forums Excluded option, can we have Forums Included option???

I have 165 forums in my board, but I want to show only 10 forum contents. With the forums excluded i have to exclude 155 forums. It is better if I could mention only 10 forums, if you introduce the Forum Included feature.

[letsjoy]

Is this works with vb 4.x ?
Thanks :)

[Knele]

It doesn't work on 4.1.4

[muratcan25]

Thank You :)

[Compleo]

Hello,

Is this mod also available in the admin login section as administrator? (example by 'show user details' in admin CP.

Thanks.

[mapleleaffans]

Very nice add on! Thank you!

[Hellmaster]

Thank you, but...

How to reduce the "Forum" title at member profile? Should add an option like "Length of FORUM Title" as "Length of Thread Title"

[letipro]

please update to vbb4. thank

[www.nofal]

Good Work

[4nawadir.com]

Good Job Bro ...

5 Stars + MOTM <3

- Arabic Version Attached :-)

[b65ran]

Do we have have an update for vb4 ?

[al2thero]

thanks a lot

[b65ran]

Do we have a vb4 version for this one ?

[webmastersitesi]

vbulletin 4.2 exists?