Users Threads in Their Profile

[assassingod]

Users Threads in Their Profile

Coded By: assassingod
Description: This will show the users posted threads in their profile. It also counts the number of threads posted

UPDATED 26/11/2003

vB Version:
2.2.x and 2.3.x

Don't forget the click the install button if you use this!:)

[dnoyeb2002]

Awesome mod assassingod . . . installing it right now on my board. Thanks for the idea!

[NTLDR]

Nice idea, however IMO you really should have some sort of limit on the number of threads, you really don't want to be showing hundreds of threads on the profile page, a counter a say the last X threads would be better.

Also this will get threads that are in private forums, not good ;)

One last thing :P The second query is a waste, why not just increment a variable in with each iteration of the while loop? Much more efficent. Remember query_first to, thats a query were it should be used on to save extra coding :)

[poetic]

ya i tihnk it should be changed to the last 10 threads

[assassingod]

Nice idea, however IMO you really should have some sort of limit on the number of threads, you really don't want to be showing hundreds of threads on the profile page, a counter a say the last X threads would be better.

Also this will get threads that are in private forums, not good ;)

One last thing :P The second query is a waste, why not just increment a variable in with each iteration of the while loop? Much more efficent. Remember query_first to, thats a query were it should be used on to save extra coding :)
Thanks for the info Lee. I'll get to work right away on it:)

[Dean C]

Good lord - i wouldn't reccomend anyone installing this until it has the limit on it - but to be honest if you have a page limit then its the same as searching for all posts. If it's the latest posts then this hack is already made - tough one Steve :)

[assassingod]

Good lord - i wouldn't reccomend anyone installing this until it has the limit on it - but to be honest if you have a page limit then its the same as searching for all posts. If it's the latest posts then this hack is already made - tough one Steve :)
For a temporary fix i'll add a vB option. Then sort out the problems.

And it's just threads posted by that user

[FleaBag]

Give the guy a break, he's 14 and doing his best - when I was 14 I could barely string a HTML page together.

Nice idea mate, if there's a limit on the number of threads I'll gladly install as I know my members will appreciate it.

[assassingod]

Thanks FleaBag:)

I'll get to work on a page navigation feature next (After I stop playing with GD:D)

[g-force2k2]

Nice Job Assassingod.

Here's an edited version that uses a variable to define the amount of threads to show in the user profile using vbulletin options.

Also cut the second query and incremented while using the while loop. Only thing is it won't calculate the total number of threads a user has posted.

And likewise I agree with what NTLDR said about permissions.

Haven't tested it either just coded it.

Regards,
g-force2k2

[assassingod]

Nice Job Assassingod.

Here's an edited version that uses a variable to define the amount of threads to show in the user profile using vbulletin options.

Also cut the second query and incremented while using the while loop. Only thing is it won't calculate the total number of threads a user has posted.

And likewise I agree with what NTLDR said about permissions.

Haven't tested it either just coded it.

Regards,
g-force2k2
Thanks very much g-force:) When I get back from school i'll test and add this to the first post

[assassingod]

Right, you can now set up a default number of threads via vBOptions. I will work on permissions and page navigation.

[assassingod]

You can now exclude forums via vBOptions and you can limit to the number of threads you want to be displayed on a page:)

Working version:)

[Lesane]

Good work 'assassingod', i like it alot. Will install it soon on my forum, thanks.

[assassingod]

Thanks Lesane:D:)

[Floris]

Thanks Lesane:D:)
Nice job my friend :)

[assassingod]

Thanks:)

[zsmom]

Cool! Thanks!

*installed*

[PixelFx]

nice hack :)

[mzlogical]

Nice nice job dude. :)

*clicks install*

[assassingod]

Thanks for the feedback

[Mr L]

Assassingod,

Great work here. I believe you're work is going to be worth watching over the next few months.

Very impressive.

[assassingod]

Thanks for the great feedback:)

[Sophocle]

As usual, an excellent hack. Thank you assassingod.
I've submitted it for french translation to www.vbulletin-fr.com.

[lasto]

is quite good basically as u can see the last threads they made

it does have its uses so i will install it as well

/me clicks install

[lasto]

is the counter global ? so it can be inserted into the postbit so we can see at a glance how many threads a user has started compared to his replies ??

[assassingod]

is the counter global ? so it can be inserted into the postbit so we can see at a glance how many threads a user has started compared to his replies ??
No, but it's a seperate hack that's been released:)

[deaconxgp]

how do you find out the forum id's?

[deaconxgp]

also, i get a database error stating something about the member.php and the table not working.

it says this line

SELECT threadid,title,dateline,forumid
FROM thread
WHERE postuserid = $userinfo[userid] and forumid NOT IN ($excludedforums)
ORDER BY dateline DE

says it doesn't work...the options to set thread limits etc are in my admin panel but nothing shows...

[deaconxgp]

could it be possilbe i ran the query wrong? i copied and pasted the 2 lines listed in the instructions in the phpmyadmin query and clicked Go. that was right wasn't it?

[assassingod]

Update the new vBOptions with the forums you've excluded and how many topics on the user profile you want to be displayed.

[deaconxgp]

i did that and it still displays nothing. keep in mind though that this is all working without my original member.php file. it won't work if i edit the member.php file like the instruction suggest.

[deaconxgp]

solved the problem myself guys :)

i'm getting pretty good at this stuff lol

[deaconxgp]

one other thing. For some reason, the user threads don't appear. It only lists one. It says that the user has 10 threads but only lists one....what could be wrong? I set the amount of threads to be shown as 20....even when I posted a test one it kept showing just one.

[assassingod]

Has this user posted threads in an excluded forum?

[deaconxgp]

nope. I only excluded one forum and then tested by posting threads in other forums...it just shows the count but it doesn't list them. it lists just one thread in the user profile but the # of threads will be correctly displayed in the ( ). so let's say the user has (15) posts..it only lists one in his profile.

[assassingod]

I'll look into this. Has this user had any threads deleted?

[deaconxgp]

Nope. No threads deleted.

[deaconxgp]

this works now! apparently when i upgraded to version 2.3.4 something happened in the process of me reinstalling the hacks that made it work :)

[assassingod]

Good to know.

[DarkSavior]

Works great! Nice piece of work.