I am trying to get users latest X posted threads from specific forums showing in the user profiles. I have limited PHP Mysql knowledge (but am learning) so was wondering if someone could help me with this please? I'd very much appreciate it

I basically want to display 3 seperate blocks (1 for each forum) showing the latest 5 threads that a user has posted in their profile page:

I could probably do it with 3 querys but am sure it's possible with just one?

Any help is appreciated.

Thanks.

well, just make a query like you normally would to retrieve ALL the threads the user has posted. Then loop it around using "while" statement. No to make sure you stop at 5 threads make 3 variables: Then you have to say which 3 forum id's you want:
Now the names:
Make sure those variables are the same. EG. If I have a forum named fred and another one called george. George's forum id is 2 and fred's is 1 so you should put: Then you need something like: at the end add:
Now you just have to construct 3 templates and put $latest_5_threadsouter somewhere in the template you want it. Oh and by the way a suggested hook location would be: member_complete.

Hope that helped

Regards,
Nick.

ps. this code is untested and I wrote it from memory. It also depends on what you do for the query.

__________________
vB Nova - Great vBulletin Help, Mods & Skins | PicoSphere - Free Image Hosting with No Pop-Ups
---------

Thanks Nick!

Although I'm still a little stuck :alien:

How effecient is it to call 'all' the threads the user has posted? Would it be better to use 3 querys instead that has a limit to 5 per forum? :ermm:

Could you give me an example query too please? (Sorry to be a pain - but I found this on a similar hack and it has a lot more in there that I probably wouldn't have included so have lost confidence! )

It seems I have a lot to learn yet

Any help would be appreciated.

Just to answer your first bit I think it would probably be better to use 1 query for all the data rather than 3 queries for all the necessary data. I really don't know but I would stick with the one query. As for the query you just need something simple. Then in the latest_5_threadsbit you just need to have something like:

That query won't work, there is no table defined in it.

Try ;

oops xD, edited the post.

Thanks Nick, and Paul

So basically.. I have this code as a plugin at member_complete:

Then I have three new templates called:

latest_5_threadsbit_0
latest_5_threadsbit_1
latest_5_threadsbit_3

With the code:

Then another template called latest_5_threadsouter with something as simple as:

And then in the member profile I simply put:

$latest_5_threadsouter

Where I want it to show....right?

...How far off am I? :nervous:

well for the first bit the template remains the same but it is a different variable depending on the forum. The reason for this is because what you just pointed out. Each of the templates have the same code in so why not just use one so you should just have one template: latest_5_threadsbit.

I just relealised a bit of a glitch in my plugin code so give me a few mins to edit my post an rewrite it.
EDIT: Now you need to make 3 templates called latest_5_threadsinner_0, latest_5_threadsinner_1 and latest_5_threadsinner_2.
In latest_5_threadsinner_0 put: In latest_5_threadsinner_1 put: In latest_5_threadsinner_2 put: Then recopy the code I have just edited in my first post.

And the template latest_5_threadsbit should have this code:

Hi Nick.. I'm not sure where I'm going wrong :-/

I have the Plugin code as:

And new templates as:

latest_5_threadsinner_0




latest_5_threadsinner_1



latest_5_threadsinner_2


latest_5_threadsbit

latest_5_threadsouter

And then I place $latest_5_threadsouter where I want them to show in my member profile template... right? But it's not working Any ideas what I'm doing wrong?
Cheers.

Update:

When you click on a last poster username when on the page forumhome - it seems to 'do something', but at the top of the page it says:

Which is the bit:

It returns:

However the links for f1 name here, f2 name here etc are just: http://www.mydomain.co.uk/forumdisplay.php?f= (the forum ID missing)

And the latest 5 threads are repeated (and are from 'any' forum, not just the ones we want from the specific forum).

When you visit a member profile as normal (eg / m ember.php?u=704) none of the hack displays at all (not even the error message)...

Sorry to give you a headache Nick!