Forum Home Enhancements - My Recent Posts on Forumhome

This is my first released hack, so if you have any constructive suggestions or feedback, it'd be greatly appreciated. This is still a beta version of the hack, it doesnt support phrases or have any admin options yet, and needs a bit of optimization, I will add those in a later version.

DESCRIPTION

This adds a table onto your forumhome that shows information the last 5 threads the user has posted in, including the thread title, thread starter, last post date, last post username, replies, views, and what forum it is in.


INSTALL

1) Upload product-recentposts.xml
2) Add the following code to FORUMHOME:

Find:

<!-- what's going on box -->

Replace With:

<!-- recent posts -->
<if condition="$show['recentposts']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center"><tbody>
 <tr>
  <td class="tcat" colspan="6">
   <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_recentposts')"><img id="collapseimg_forumhome_recentposts" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_recentposts].gif" alt="" border="0" /></a>
   My Recent Posts
  </td>
 </tr>
</tbody>
<tbody id="collapseobj_forumhome_recentposts" style="$vbcollapse[collapseobj_forumhome_recentposts]">
<tr class="thead">
            <td width="20"></td>
            <td class="thead" width="40%"><b>Thread</b></td>
            <td class="thead"><b>Last Post</b></td>
            <td class="thead" align="center"><b>Replies</b></td>
            <td class="thead" align="center"><b>Views</b></td>
            <td class="thead" align="right"><b>Forum</b></td>
</tr>
 $recentpostbits
</tbody>
</table>
<!-- /recent posts-->
<br />
</if>
<!-- what's going on box -->

This will place it above the What's Going On? box, you can put this anywhere you like really.

This has only been tested on vb 3.6.4

DEMO / EXAMPLE

http://forums.ffextreme.com/
You will have to register and post to actually see it working unfortunately hehe.


MODIFY NUMBER OF THREADS SHOWN (TEMP)

I will add admin cp options in the next update, but if you want to modify how many threads are shown on the list:

1) Goto the Plugin Manager
2) Click [Edit] for the Recent Posts by You on ForumHome plugin
3) In the text box, find where it says:

PHP Code:

$getposts = $db->query_read("SELECT distinct threadid FROM post WHERE userid = $userid ORDER BY postid DESC LIMIT 5"); 


4) Change the end where it says DESC LIMIT 5, to whatever number you want to show (DESC LIMIT 10 etc)


BUGS / FIXES

0.14 --> Fixed font issues, issues involving deleted threads showing up.
0.13 --> Change font size to smallfont
0.12 --> Changed userid variable to proper variable, added alternating column colours.
0.11 --> Added TABLE_PREFIX to the queries

[KrisP]

Good work,

[perfphysio]

Originally Posted by Tom_S

Nice job..I just would like the font to be sized down

I agree with this one. The font on the rest of my board is smaller than this one. Is there a way that the code can assumen that which is the default already on the board?

Also an ability to colout the backround colour specifically for the title part would also be cool. E.g. my forum has everything with a blue background. To make this stand out it might be nice to add a different colour to the title background for this mod.

nice hack though

[Mistah Roth]

Updated the font size.

I will add the option to excluse forum id's once I create the admincp options for it.

Also the title background colour is just set to match the rest of the layout, theres no real need to make it stand out.

[perfphysio]

thanks, the font is better but still doesn't match the boards default one being used.

[Mistah Roth]

Hmmm its fine for all of the forums I've tested it on, can you show me your forum?

[Mistah Roth]

Okay I've found a bug in the first query of the script, and after working on it for two days I am officially stumped.

The following query:
SELECT distinct threadid FROM ". TABLE_PREFIX . "post WHERE userid = " . $vbulletin->userinfo['userid'] . " ORDER BY postid DESC LIMIT 5

Does not return the last 5 threads posted in. For some reason it skips any older thread. If I remove the distinct from the query, it shows the last 5 posts properly. The problem is we can't have repeats, so DISTINCT is supposed to solve that.

Anyone have any idea whats going wrong? If all else fails I'll just make it so that it filters out doubles with PHP code.... not as efficient as I'd like it though, there should be no reason the query doesnt work.

[kafi]

Installed thank you.

Small font update is not working for me though. Everything is in regular font.

[kafi]

FEATURE REQUEST: add "show all my posts" link/button at the end (somewhere) .-)

[perfphysio]

Originally Posted by Mistah Roth

Hmmm its fine for all of the forums I've tested it on, can you show me your forum?

My board can be seen at http://www.physiochat.com. The header fonts are OK, it is the description of the forum that doesn't match i.e. that last post part and the username, e.g. Today at 01:33 PM, by physiobobGo to last post

[vbuser99]

This also displays deleted threads.

To Fix, change the query in XML file:

from:

SELECT distinct threadid FROM ". TABLE_PREFIX . "post WHERE userid = " . $vbulletin->userinfo['userid'] . " ORDER BY postid DESC LIMIT 5

to:

SELECT distinct b.threadid FROM ". TABLE_PREFIX . "post a, ". TABLE_PREFIX . "thread b WHERE a.userid = " . $vbulletin->userinfo['userid'] . " AND b.visible = 1 AND a.threadid = b.threadid ORDER BY a.postid DESC LIMIT 5