vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   need a little help with member.php (https://vborg.vbsupport.ru/showthread.php?t=32852)

Mutt 12-01-2001 02:47 PM
I could use a little help. I'm playing around with member.php to change a the profile page. I'd like to list the last 10-20 posts made by a member instead of just the last one. I'm only changing the 'get last post' section. The following code works and you just need to stick $TheLastPosts into the getinfo template to display the list. Here's the problem. If you made several posts in one thread, you'll have several links to differnet parts of the same thread. once a thread is listed, I don't want it to be listed again. I've been trying to find a simple way to weed out the dups, but nothing is working out perfect. Help me out guys. :) thanks

PHP Code:
// get last posts
  $totalposts=$userinfo[posts];
  if ($userinfo[posts]!=0 and $userinfo[lastpost]!=0) {
    $lastpostdate=vbdate($dateformat,$userinfo[lastpost]);
    $lastposttime=vbdate($timeformat,$userinfo[lastpost]);
    $getlastposts=$DB_site->query("SELECT thread.threadid,thread.title,thread.forumid,postid,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='$userid' ORDER BY post.dateline DESC LIMIT 20");
    while ($getlastpost=$DB_site->fetch_array($getlastposts)) {
      $getperms=getpermissions($getlastpost[forumid]);
      if ($getperms[canview]) {
        $theposttitle=$getlastpost[title];
        $thepostdate=vbdate($dateformat,$getlastpost[dateline]);
        $lastposttime=vbdate($timeformat,$getlastpost[dateline]);
        $theposturl="showthread.php?s=$session[sessionhash]&postid=$getlastpost[postid]#post$getlastpost[postid]";
        $TheLastPosts.="<a href=\"$theposturl\">$theposttitle</a> : $thepostdate $lastposttime<br>";
      }
    }
  } else {
    $lastpostdate="Never";
  } 

Admin 12-01-2001 02:58 PM
Use GROUP BY:
Code:
SELECT thread.threadid,thread.title,thread.forumid,postid,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='$userid' GROUP BY thread.threadid ORDER BY post.dateline DESC LIMIT 20

Mutt 12-01-2001 05:57 PM
wow, that was quick

thanks so much. that did the trick.


All times are GMT. The time now is 10:22 PM.

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.01834 seconds
  • Memory Usage 1,723KB
  • 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
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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