Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

My Recent Posts & My Recent Threads

There seems to be a problem with the 2 mentions links above at the bottom of the Latest Active Forum Threads panel.

The code calls for "Limit 100" posts or threads...
CodeDownload  
ORDER BY tp.post_datestamp DESC LIMIT 100"



When you open up either of those links, they only show 20 posts or threads.....
This site also does not show them when I click on my recent posts or threads and I know I have more than 20.

I believe there is something wrong with the "makepagenav" clause.....
The makepagnav code is there but it is not working...
CodeDownload  
if ($rows > 20) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 20, $rows, 3)."\n</div>\n";



My version 6 works properly but version 7 does not....

Has anyone noticed this before?
Is everyone blind here?

Or don't you just want to acknowledge that the "My Recent Posts" and "My Recent Threads" isn't working properly even on this site...

Try it... Click on your recent posts or threads....
There is no makepagenav at the bottom. All you get is your first 20 posts or threads instead of 100 which is also 5 pages....

Acknowledge the problem.......
I just thought it didn't show more since others were too old.

But I guess you are right, if there are more than 20 posts/threads a page navigator should appear at the bottom.

Well, I also think this is a problem the dev team should acknowledge. However, I have also reported a very irritating problem which they haven't answered. So I guess they are busy with something else :)

Don't forget they are doing this on their free time, so we don't really have the right to push them :)
Thanks for the feedback...

Yes, and we are pointing out the problems for FREE also...
We are helping them and the community too.

All they need to do is acknowledge that they notice the problem...

How hard is it to click on "My Recent Posts" only to see no page nav at the bottom?
and then acknowledge it?

Looks like you and I are the only one acknowledging this problem...
Thanks again.....
use the Roadmap / Bugtracker to report bugs, then you can follow the work on the bug
Aha, ok!

I have reported my issue there. I'm sure Joe will do that too ;)

Hope that it's ok that I submit the issue and just link to the thread I have started in the forum?

Quote

mojkan wrote:
Hope that it's ok that I submit the issue and just link to the thread I have started in the forum?

Yes, it's ok :)
Issue has been noted.
Thanks Nick....

Now I can rest.... :)

I did post it in the Roadmap / Bugtracker too....

I have tried inserting other codes that I know work but still have not been able to figure it out myself... This new $_GET ['rowstart'] etc. stuff is really getting to me.

I have many files I need to change to get everything working the way it was in version 6..... Infusions, <img src>, Tables that are really there but version 7 doesn't think so.....
This is not a simple upgrade for me but 7 does look good and promises to be more secure.
Nick and crew has fixed the "My Recent Threads" and "My Recent Posts" available in the SVN.
Or view it here:
http://www.php-fusion.co.uk/infusions...item_id=58

I want to give others a tip here on these Recent Post and Recent Threads..
The above links show the last 100 posts or threads that YOU made...
If you want to put a link in the users "profile.php" that shows ALL the posts and threads that a particular user makes, here is the code I use for all_posts.php that I tweaked:
CodeDownload  
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: my_posts.php
| Author: Nick Jones (Digitanium)
| Modified by Joe Kriz to show All User Posts
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../../maincore.php";
require_once THEMES."templates/header.php";

if (!iMEMBER) { redirect("../../index.php"); }

add_to_title($locale['global_200'].$locale['global_042']);

$result = dbquery(
   "SELECT tp.forum_id, tp.post_author, tf.forum_access
   FROM ".DB_POSTS." tp
   INNER JOIN ".DB_FORUMS." tf ON tp.forum_id=tf.forum_id
   WHERE ".groupaccess('tf.forum_access')." AND post_author='".$_GET['lookup']."'"
);
$rows = dbrows($result);
if ($rows) {
   if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
   $result = dbquery(
      "SELECT tp.forum_id, tp.thread_id, tp.post_id, tp.post_author, tp.post_datestamp,
      tf.forum_name, tf.forum_access, tt.thread_subject
      FROM ".DB_POSTS." tp
      INNER JOIN ".DB_FORUMS." tf ON tp.forum_id=tf.forum_id
      INNER JOIN ".DB_THREADS." tt ON tp.thread_id=tt.thread_id
      WHERE ".groupaccess('tf.forum_access')." AND tp.post_author='".$_GET['lookup']."'
      ORDER BY tp.post_datestamp DESC LIMIT ".$_GET['rowstart'].",20"
   );
   $i=0;
   opentable("All posts by this member");
   echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl-border'>\n<tr>\n";
   echo "<td width='1%' class='tbl2' style='white-space:nowrap'><strong>".$locale['global_048']."</strong></td>\n";
   echo "<td width='100%' class='tbl2'><strong>".$locale['global_044']."</strong></td>\n";
   echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><strong>".$locale['global_049']."</strong></td>\n";
   echo "</tr>\n";
   while ($data = dbarray($result)) {
      if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl2"; }
      echo "<tr>\n";
      echo "<td width='1%' class='".$row_color."' style='white-space:nowrap'>".trimlink($data['forum_name'], 30)."</td>\n";
      echo "<td width='100%' class='".$row_color."'><a href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."&amp;pid=".$data['post_id']."#post_".$data['post_id']."' title='".$data['thread_subject']."'>".trimlink($data['thread_subject'], 40)."</a></td>\n";
      echo "<td align='center' width='1%' class='".$row_color."' style='white-space:nowrap'>".showdate("forumdate", $data['post_datestamp'])."</td>\n";
      echo "</tr>\n";
      $i++;
   }
   echo "</table>\n";
   closetable();
   if ($rows > 20) { echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 20, $rows, 3)."\n</div>\n"; }
} else {
   opentable("All posts by this member");
   echo "<div style='text-align:center'><br />\n".$locale['global_054']."<br /><br />\n</div>\n";
   closetable();
}

require_once THEMES."templates/footer.php";
?>


For myself and my almost 11,000 users, it is an easy way to see all the users posts...
Enjoy...........
Just noticed I cannot add an attachment...

I tried on my test site of version 7 and there is no option to allow attachments even though there is an option for attachment size...

Further investigation is needed on my part for this....
Thanks for above code! So that file is all you need to change in order to make the page navigation to see all of a users posts and threads? Thanks a lot! Will use it!

About the file attachment. You specify in forum settings in content administration. Edit a forum like when you put moderators, there you will find option to allow attachment and who is allowed to attach :)
mojkan,

Thanks for the tip on the attachments....
I found them thanks to you...
They weren't in their old spot in the admin panel...

I guess attachments are not turned ON in this section of the forums and that is why I can't attach a photo here of the profile.php panel that I tweaked to include the "View All Posts by this member"

Quote

Joe Kriz wrote:
mojkan,

Thanks for the tip on the attachments....
I found them thanks to you...
They weren't in their old spot in the admin panel...

I guess attachments are not turned ON in this section of the forums and that is why I can't attach a photo here of the profile.php panel that I tweaked to include the "View All Posts by this member"


Nope, it's not turned on :) Why don't you put it in the mods forum? www.phpfusion-mods.com. There you can add pics and even a RAR-packed file/infusion.
Thread Information
Author
Replies
14 posts
Views
3,370 times
Last Post
Last updated on 11 years ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Falk, Joe Kriz, Basti, mojkan, SiteMaster