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

[projectego]

Nice idea, Mistah Roth!

[ChurchMedia]

Nice hack. Needs a little tweaking. The query needs TABLE_PREFIX added before "post". Also, the variable you use ($userid) should be $bbuserinfo[userid]. I think that should fix it up. I'll install it just as soon as you've debugged it. I love the idea!

Keep up the great work!

[Mistah Roth]

Originally Posted by ChurchMedia

Nice hack. Needs a little tweaking. The query needs TABLE_PREFIX added before "post". Also, the variable you use ($userid) should be $bbuserinfo[userid]. I think that should fix it up. I'll install it just as soon as you've debugged it. I love the idea!

Keep up the great work!

I added the TABLE_PREFIX to the queries, thanks. I originally tried using bbuserinfo[userid] and it returns a NULL value in the hook (I'm not sure why)

[ChurchMedia]

Sorry -- I should have known better. I haven't been coding enough!! You need to use $vbulletin->userinfo['userid']. So your query should look like this:

PHP Code:

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


The way you had it written it wasn't bringing up my posts. I don't know whose posts those were. Also, I took out your "if ($userid)" statement and inserted an "<if condition="bbuserinfo[userid]> (your template code) </if>" instead. I can send you my altered version if you want to see it. There was also a broken image on the thread status icon. I just fixed it to forum_old.gif.

Sorry for messing around with your hack. Nothing personal. I think it's an excellent idea and I probably couldn't have written it from scratch. So, great job! Installed and I love it!

[redtailboa]

I like the idea, but is it collapsible? I couldnt tell from the pic..

If not, how about a option to allow the user to enable/disable it? i only ask this because large forums can get crowded, and some people prefer to turn things like this off while others like these options

[Mistah Roth]

Originally Posted by ChurchMedia

Sorry -- I should have known better. I haven't been coding enough!! You need to use $vbulletin->userinfo['userid']. So your query should look like this:

The way you had it written it wasn't bringing up my posts. I don't know whose posts those were. Also, I took out your "if ($userid)" statement and inserted an "<if condition="bbuserinfo[userid]> (your template code) </if>" instead. I can send you my altered version if you want to see it. There was also a broken image on the thread status icon. I just fixed it to forum_old.gif.

Sorry for messing around with your hack. Nothing personal. I think it's an excellent idea and I probably couldn't have written it from scratch. So, great job! Installed and I love it!

I fixed the userid issue, should work properly now thanks for pointing that out. I kept the if ($vbulletin->userinfo['userid']) in because theres no need to run all those queries if the user isn't logged on, also the userid will be NULL if the user isnt logged in, which will cause a database error.

And like I said, its my first released hack and the first time i've ever used the plugin / hook system, so I'll leave it in Beta until im sure all the little bugs are fixed, and I can add functionality to it. Thanks a lot for the support.

And what image was broken and how did you fix it?

Originally Posted by redtailboa

I like the idea, but is it collapsible? I couldnt tell from the pic..

If not, how about a option to allow the user to enable/disable it? i only ask this because large forums can get crowded, and some people prefer to turn things like this off while others like these options

Yes it is collapsible.

[ChurchMedia]

Great! I'm glad it worked out. I like feeling useful every once and a while . Just for future reference, the IF statements in the templates don't create queries, so you can use them without worrying about that.

Again, very nice hack.

Cheers,

Tim

[Mistah Roth]

Originally Posted by ChurchMedia

Great! I'm glad it worked out. I like feeling useful every once and a while . Just for future reference, the IF statements in the templates don't create queries, so you can use them without worrying about that.

Again, very nice hack.

Cheers,

Tim

What I meant was, without the if statement in the Plugin to stop the script from running if the user is not logged in, it will try to execute the queries with a NULL value userid.

[Tom_S]

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