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:
Replace With:

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:
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

Nice idea, Mistah Roth! ;)

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)

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!

:D

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 :)

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?

Yes it is collapsible.

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.

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

Good work,

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 :)

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.

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

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

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.

Installed thank you.

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

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

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

This also displays deleted threads.

To Fix, change the query in XML file:

from:
to:

How about an update release with all fixes to include the font fix so the xml can overwrite the exisiting one please?

Nothing yet?

The font issue is an easy one. In the XML
Find all instances of:
Replace with:
Find all instances of:
Replace with:
Reinstall and allow overwrite

I will get those two fixes done, sorry I've been distracted trying to fix another bug that randomly doesn't show posts in really old threads. Trying to get some help with that in a seperate thread.

I'll get those two things fixed up and update it.

kewl beans my friend :)

Going to subscribe to this thread :)

how's this one coming along? i'll install once completed ^_^

edit: installed and it works fine. love it *clicks installed with an excellent*

for the pepole that don't want to sign up for the site and make some posts, I'll provide a screen shot tonight

Installed AGAIN after I had to reinstall forums (unrelated issue).

And I'll tell ya, we REALLY dig this hack.

Most people have been relying on subscribed threads for the sole purpose of reading responses to their posts. But the "latest posts" hack is REALLY REALLY convenient.


I love it. Thanks a bunch!

OH - if anyone wants to see a raw forum screenshot of what the hack looks like (i see the person above stated they'd upload one) you can view a screenshot here:

http://www.mangacult.net/recentposts.jpg


(we're just reinstalling tonight, so don't mind the lack of forum-ness ^_^)

It's very nice, but i think if you change the below code in 'forumhome_recentpostbits':
to
will be more better, however I know that this is only a Beta version and I think you will add more features in next versions.

* Clicks Install *

I would like to allow this mod to only one usergroup. How can I do it?

Installed, works excellent!

Is there a way to make it a link? Like the "New Posts" on NavBar?

How do I make this show for all user groups? Otherwise, good work!

Lovely. Works wonderfully on 3.6.8 - new install - good to go.

Good question. Does anyone use this in any other place on their site?

It seems to work on 3.7.1 P1 that I'm running.

Although, I'd like to do this mod as a navbar link as well. Anyone know how to do this?

I'll be attempting install on new 3.7.2 spl 1 as well this evening. I'll post back if it's all good (security token bug, compatibility with all other forumhome hacks, etc etc) although I don't foresee any problems with the way this product is written.

Great mod, works perfectly thanks. :)

Nice hack, seems to work just fine on 3.6.8. Good work! :)

*clicks install*

Nice hack and works well on 3.6.11 I have just installed on 3 sites no problems!

hi
i want to my user kontrol panel wiev