vb.org Archive - Miscellaneous Hacks - User's Last XX Threads + Posts in UserCP

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Miscellaneous Hacks - User's Last XX Threads + Posts in UserCP (https://vborg.vbsupport.ru/showthread.php?t=79759)

User's Last XX Threads + Posts in UserCP

Last XX Threads + Posts in UserCP
Author: tnguy3n (Thinh Nguyen)
Support site: http://vbviet.org

Description:
This hack shows user's last X posts + threads in User CP. It's useful for returning users who'r away from the board, and it's give the users a briefing of their posts/threads and where they last discussing.
To change the number of post/thread display in UserCP, replace 5 with your own value in line:
$limit = 5;

Queries: none
File Mod: 1
Template Mod: 1
New template: 4
Installation Time: 4-5 mins

Looks like a very useful hack ..

One small error in the instructions :-

"------------------
FILE MODIFICATION:

1. OPEN .. ???"

Oops, my bad. open usercp.php. ;)
*update 1st post*

Clicked install ..

No problems installing on 3.0.6

Excellent, works 100% in 3.0.7 :)

Clicks Install.

quick install (on 3.03)...only the added templates don't seem to be cached ;)

Quote:

Originally Posted by Nordinho

quick install (on 3.03)...only the added templates don't seem to be cached ;)

thanks for pointing that out. To pre-cache these new templates, in usercp.php,

FIND:

PHP Code:


		
			
    'usercp_reputationbits'

REPLACE WITH:

PHP Code:


		
			
    'usercp_reputationbits',

    'usercp_lastthreads',

    'usercp_lastthreadsbit',

    'usercp_lastposts',

    'usercp_lastpostsbit'

yeee, very nice this hack, thank tnguy3n ;)

~~~~~~~~~~~~~~~~~~~
"Click install"
~~~~~~~~~~~~~~~~~~~

Nice one. Works in 3.0.7
*Clicks install*

thanks, guys. I tested this hack in 3.0.3 + 3.0.5 + 3.0.7, and I assume it would work with other versions of vb3 gold as well.

Clicked Installed :)

Thanks for sharing.

[high]* Zachariah installs
[/high]

:D

glad that you guys find it useful. :)

How about an option to put these on a separate page inside the usercp? Our usercp home frontpage is already kinda cluttered.

Quote:

Originally Posted by nighteyes

How about an option to put these on a separate page inside the usercp? Our usercp home frontpage is already kinda cluttered.

you can follow instructions to modify and add new templates, then doing following additional mod:

1. Open USERCP_SHELL,

FIND:

HTML Code:

<tr>

        <td class="$navclass[attachments]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editattachments">$vbphrase[attachments]</a></td>

</tr>

BELOW, ADD:

HTML Code:

<tr>

        <td class="$navclass[attachments]" nowrap="nowrap"><a class="smallfont" href="usercp.php?$session[sessionurl]do=getlastposts">Your Last Posts</a></td>

</tr>

2. In file modification part, step 2, add this bit of code instead:

PHP Code:


		
			
// last XX posts + threads in UserCP by tnguy3n

if($_REQUEST['do'] == 'getlastposts')

{

$limit = 5;

// get last XX threads

$lastthreads = $DB_site->query("

    SELECT thread.threadid, thread.lastpost, thread.title AS threadtitle, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, forum.forumid, forum.title AS forumtitle, user.userid, user.username

    FROM " . TABLE_PREFIX . "thread AS thread

    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(thread.forumid = forum.forumid)

    LEFT JOIN " . TABLE_PREFIX . "user AS user ON(thread.lastposter = user.username)

    WHERE thread.postuserid = $bbuserinfo[userid]

    AND thread.visible = 1

    ORDER BY thread.dateline DESC

    LIMIT 0, $limit

");

while($lastthread = $DB_site->fetch_array($lastthreads))

{

    $threadtitle = $lastthread['threadtitle'];

    $forumtitle = $lastthread['forumtitle'];

    $forumid = $lastthread['forumid'];

    $dateline = vbdate($vboptions['dateformat'], $lastthread['dateline']);

    $replies = $lastthread['replycount'];

    $views = $lastthread['views'];

    $lastposter = $lastthread['lastposter'];

    $lastpost = vbdate($vboptions['dateformat'], $lastthread['lastpost']);

    eval('$lastthreadsbit .= "' . fetch_template('usercp_lastthreadsbit') . '";');

}

eval('$showlastthreads .= "' . fetch_template('usercp_lastthreads') . '";');



// get last XX posts

$lastposts = $DB_site->query("

    SELECT thread.threadid, thread.title AS threadtitle, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.dateline AS threaddate, thread.views, thread.visible, post.threadid, post.username, post.userid, post.dateline AS lastpostdate, forum.forumid, forum.title AS forumtitle

    FROM " . TABLE_PREFIX . "post AS post

    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON(thread.threadid = post.threadid)

    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)

    WHERE post.userid = $bbuserinfo[userid]

    AND thread.visible = 1

    GROUP BY thread.threadid

    ORDER BY lastpostdate DESC

    

    LIMIT 0, $limit

");

while($lastpost = $DB_site->fetch_array($lastposts))

{

    $threadtitle = $lastpost['threadtitle'];

    $forumtitle = $lastpost['forumtitle'];

    $lastpostedate = vbdate($vboptions['dateformat'], $lastpost['lastpostdate']);

    $replies = $lastpost['replycount'];

    $views = $lastpost['views'];

    $threadby = $lastpost['postusername'];

    $threaddate = vbdate($vboptions['dateformat'], $lastpost['threaddate']);

    eval('$lastpostsbit .= "' . fetch_template('usercp_lastpostsbit') . '";');

}

eval('$showlastposts .= "' . fetch_template('usercp_lastposts') . '";');

}

// end last XX posts + threads in UserCP

I was gonna do this a while ago but I was pointed to the fact that ppl can just subscribe w/o notification by default and have a list of all threads/posts.

but this is is easy to. good stuff.

very very nice .....installed. :banana:

Can you change this in another version for the main page ? ...
as TOP Five Hack ?

and can I changed the language ?, where ?

Quote:

Originally Posted by skokarl

very very nice .....installed. :banana:

Can you change this in another version for the main page ? ...
as TOP Five Hack ?

and can I changed the language ?, where ?

you meant to show user's last posts/threads on forumhome?
If so, open index.php,

ADD THIS QUERY 'somewhere',

PHP Code:


		
			
// last XX posts + threads in UserCP by tnguy3n

$limit = 5;

// get last XX threads

$lastthreads = $DB_site->query("

    SELECT thread.threadid, thread.lastpost, thread.title AS threadtitle, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, forum.forumid, forum.title AS forumtitle, user.userid, user.username

    FROM " . TABLE_PREFIX . "thread AS thread

    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(thread.forumid = forum.forumid)

    LEFT JOIN " . TABLE_PREFIX . "user AS user ON(thread.lastposter = user.username)

    WHERE thread.postuserid = $bbuserinfo[userid]

    AND thread.visible = 1

    ORDER BY thread.dateline DESC

    LIMIT 0, $limit

");

while($lastthread = $DB_site->fetch_array($lastthreads))

{

    $threadtitle = $lastthread['threadtitle'];

    $forumtitle = $lastthread['forumtitle'];

    $forumid = $lastthread['forumid'];

    $dateline = vbdate($vboptions['dateformat'], $lastthread['dateline']);

    $replies = $lastthread['replycount'];

    $views = $lastthread['views'];

    $lastposter = $lastthread['lastposter'];

    $lastpost = vbdate($vboptions['dateformat'], $lastthread['lastpost']);

    eval('$lastthreadsbit .= "' . fetch_template('usercp_lastthreadsbit') . '";');

}

eval('$showlastthreads .= "' . fetch_template('usercp_lastthreads') . '";');



// get last XX posts

$lastposts = $DB_site->query("

    SELECT thread.threadid, thread.title AS threadtitle, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.dateline AS threaddate, thread.views, thread.visible, post.threadid, post.username, post.userid, post.dateline AS lastpostdate, forum.forumid, forum.title AS forumtitle

    FROM " . TABLE_PREFIX . "post AS post

    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON(thread.threadid = post.threadid)

    LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)

    WHERE post.userid = $bbuserinfo[userid]

    AND thread.visible = 1

    GROUP BY thread.threadid

    ORDER BY lastpostdate DESC

    

    LIMIT 0, $limit

");

while($lastpost = $DB_site->fetch_array($lastposts))

{

    $threadtitle = $lastpost['threadtitle'];

    $forumtitle = $lastpost['forumtitle'];

    $lastpostedate = vbdate($vboptions['dateformat'], $lastpost['lastpostdate']);

    $replies = $lastpost['replycount'];

    $views = $lastpost['views'];

    $threadby = $lastpost['postusername'];

    $threaddate = vbdate($vboptions['dateformat'], $lastpost['threaddate']);

    eval('$lastpostsbit .= "' . fetch_template('usercp_lastpostsbit') . '";');

}

eval('$showlastposts .= "' . fetch_template('usercp_lastposts') . '";');

// end last XX posts + threads in UserCP

you can re-use templates. ;)

Then, open FORUMHOME template,
ADD THIS code bit:

Code:

$showlastthreads

<br />

$showlastposts

<br />

and to change the language display,
modify following templates:

HTML Code:

        'usercp_reputationbits',

        'usercp_lastthreads',

        'usercp_lastthreadsbit',

        'usercp_lastposts',

        'usercp_lastpostsbit'

How can I thank YOU ?? :banana:

It's great !!!

Many thanks from Germany,
and sorry for the bad english.

Quote:

Originally Posted by tnguy3n

you meant to show user's last posts/threads on forumhome?

no, not from THE user, the last 5 FROM ALL USERS.. ;)

I have tested something ....

I have

"WHERE thread.postuserid = $bbuserinfo[userid]
AND thread.visible = 1

deleted ...

and now I thing it's okay.

You should leave:

PHP Code:


		
			
WHERE thread.visible = 1

Or all deleted posts will also show up.

a last question, please..

How can I change the format from Date to Date AND Time ?

This is my dream .... :nervous:

Quote:

Originally Posted by skokarl

a last question, please..

How can I change the format from Date to Date AND Time ?

This is my dream .... :nervous:

For example, to add time to lastposts

PHP Code:


		
			
$threadtime = vbdate($vboptions['timeformat'], $lastpost['threaddate']);

in lastpostlist postbit, ADD:

HTML Code:

at $threadtime

Attempting to install this hack and will click install, if successful.

Followed your instructions and found the first usercp_reputationbits and changed that.

FILE MODIFICATION:

OPEN usercp.php (2 changes),

1. FIND:

'usercp_reputationbits'

REPLACE WITH:

'usercp_reputationbits',
'usercp_lastthreads',
'usercp_lastthreadsbit',
'usercp_lastposts',
'usercp_lastpostsbit'

The issue is the second set. This is what I foundSolution?

$reputation['title'] = substr($reputation['title'], 0, 23) . '...';
}
eval('$reputationcommentbits .= "' . fetch_template('usercp_reputationbits') . '";');
$show['reputation'] = true;

Only the first in the top of the file.

Installed today, works fine.

Thank you very much MarcoH64.

Installed and works fine. 3.07

I am having a little problem with my code. How do I save my page as an image so that I can show you want it is looking like?

can you post screenshot of the page pls?

This is so awesome!!! Granted the subscribe function would fill most members request but I run a city community site in a community where most are not computer friendly and any modifications that make my members feel more comfortable keeps them wanting to learn more.

Thank you again for such a great mod.

PS: I am running it on ver 3.0.7 and installed without a hitch!

great hack....installed :up:

I have a member who last posted in a thread which was then moved to my Private 'Under Review' forum.

The name of this forum shows up in the UserCP...is there a chance you could look into a fix to hide results if the forum isnt available to them?

Hey would one of you guys be willing to help get this working? For some reason my Usercp is completely white. The words and links are there, but the background pic is gone.

awesome hack..........

Quote:

Originally Posted by kall

Was about to install and then I read this; ouch. That's a security issue, I wouldn't want users seeing their posts/threads listed if they don't have access to the forum they've been moved to.

If that's fixed I'm installing this for sure.

Thank you very much for taking the time and trouble to share a working hack.

Happy Holidays!

Peace.

I really like this mod, my users use it a lot. However, with 3.6.4 I can't get it installed and working any longer. Can someone try it, and let me know what I have to modify.
Thanks

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01482 seconds Memory Usage 1,874KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_html_printable (6)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (39)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: