last 10 posts in users profile like Wluke has

[SgtSling]

?
Anyone know how this is done for 2.21?

[nafae]

i wish i did, thats a good feature

[amykhar]

It's cake.

in member.php find:

PHP Code:

 $userinfo[avatarurl]=getavatarurl($userinfo[userid]);
  if ($userinfo[avatarurl]=="") {
    $userinfo[avatarurl]="images/clear.gif";
  } 


add after:

PHP Code:


$postsArray= $DB_site->query("Select threadid, title from thread where  postuserid='$userid ORDER BY threadid LIMIT 10'");
if (!$postsArray)
     $recentPosts = "none";
else {
 while ($getRecentPosts=$DB_site->fetch_array($postsArray)) {
       $recentPosts .="<a href='$bburl/showthread.php?threadid=" . $getRecentPosts[threadid] ."'>$getRecentPosts[title]</a><br>\n";
  }
} 


Then, simply add the $recentPosts variable in your getinfo template. Formatting is up to you.



NOTE: Check the variables and formatting very carefully. I modified something similar that I did on the fly and have not tested this exact code.

[SgtSling]

this appeared to work.. but for some reason it listed 100 posts.. instead of ten

Also the sort by call

For some reason it posted all the threads started by this user, instead of the last 10 posts

Can you look at this some more?
Thanks

[amykhar]

OOPS. I read it wrong. I thought you wanted the last 10 threads. Posts are:

Select threadid, title from post where  userid='$userid' ORDER BY postid DESC LIMIT 10'

Amy

[SgtSling]

I tired that a few times.. and this is what I got

Database error in vBulletin 2.2.1:

Invalid SQL: Select threadid, title from post where userid='2462' ORDER BY postid DESC LIMIT 10'
mysql error: You have an error in your SQL syntax near ''' at line 1

mysql error number: 1064

Date: Saturday 01st of December 2001 01:03:03 PM
Script: http://www.dlrarmy.com/forums/forums...fo&userid=2462
Referer: http://www.dlrarmy.com/forums/index.php?



I am using this code

PHP Code:

 $postsArray= $DB_site->query("Select threadid, title from post where  userid='$userid' ORDER BY postid DESC LIMIT 10'");
if (!$postsArray)
     $recentPosts = "none";
else {
 while ($getRecentPosts=$DB_site->fetch_array($postsArray)) {
       $recentPosts .="<a href='$bburl/showthread.php?threadid=" . $getRecentPosts[threadid] ."'>$getRecentPosts[title]</a><br>\n";
  }
} 


[amykhar]

Let me get back to you on this one. The version of my board didn't have to worry about viewing permissions, etc. because I restricted it to a given set of forums.

Amy

[SgtSling]

thanks!

Please do!

[amykhar]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=32852" target="_blank">https://vborg.vbsupport.ru/showt...threadid=32852</a>