Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
User's Last XX Threads + Posts in UserCP Details »»
User's Last XX Threads + Posts in UserCP
Version: 1.00, by tnguy3n tnguy3n is offline
Developer Last Online: Sep 2010 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.0.7 Rating:
Released: 04-10-2005 Last Update: Never Installs: 37
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 04-11-2005, 12:22 PM
uae's Avatar
uae uae is offline
 
Join Date: Jul 2002
Location: Irvine, California
Posts: 312
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Clicked Installed

Thanks for sharing.
Reply With Quote
  #13  
Old 04-11-2005, 03:26 PM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[high]* Zachariah installs
[/high]

Reply With Quote
  #14  
Old 04-11-2005, 04:15 PM
tnguy3n's Avatar
tnguy3n tnguy3n is offline
 
Join Date: May 2003
Location: U of I, Iowa
Posts: 846
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

glad that you guys find it useful.
Reply With Quote
  #15  
Old 04-11-2005, 07:53 PM
nighteyes's Avatar
nighteyes nighteyes is offline
 
Join Date: Oct 2001
Posts: 130
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How about an option to put these on a separate page inside the usercp? Our usercp home frontpage is already kinda cluttered.
Reply With Quote
  #16  
Old 04-11-2005, 09:49 PM
tnguy3n's Avatar
tnguy3n tnguy3n is offline
 
Join Date: May 2003
Location: U of I, Iowa
Posts: 846
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 
Reply With Quote
  #17  
Old 04-13-2005, 12:08 AM
ImportPassion ImportPassion is offline
 
Join Date: Mar 2002
Location: Gilbert, AZ
Posts: 605
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #18  
Old 04-20-2005, 03:10 PM
skokarl skokarl is offline
 
Join Date: Apr 2005
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ?
Reply With Quote
  #19  
Old 04-21-2005, 01:42 AM
tnguy3n's Avatar
tnguy3n tnguy3n is offline
 
Join Date: May 2003
Location: U of I, Iowa
Posts: 846
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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'
Reply With Quote
  #20  
Old 04-21-2005, 09:21 AM
skokarl skokarl is offline
 
Join Date: Apr 2005
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How can I thank YOU ?? :banana:

It's great !!!

Many thanks from Germany,
and sorry for the bad english.
Reply With Quote
  #21  
Old 04-21-2005, 10:10 AM
skokarl skokarl is offline
 
Join Date: Apr 2005
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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..
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:24 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04783 seconds
  • Memory Usage 2,364KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (3)bbcode_html
  • (2)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete