Addition to Profile: Threads Started

[jenigma]

Hi. This is a request from some of my members -- to be able to view threads started by someone from their profile. Under "Show the last ___ posts of this person",  they'd like an option to "Show the last ____ topics started by this person", with the same selection choices (5, 10, 50, All).

To make it even better, an option to select which boards to look in, for both posts and topics started, would be nice.

Also, I'd like to request that the results for "All", and maybe "50" too, be split up into multiple pages, with something like 25 or 30 posts per page, instead of all on one so that the loading of the page takes forever when the person has a ton of posts.

[Jack.R.Abbit]

While it does sound like a good idea for a mod, until it is written much of what you ask can be accomplished using the advanced search options.  Just not from within the profile as you requested.

-Jack

[jenigma]

I tried that, and no, it unfortunately can't. Searched for topics started by myself and it gave me nothing. Search, for some reason, will not work without typing in a search term.  You can't just list topics started by someone, you must enter a word to be contained in their messages/subjects.

[Spaceman-Spiff]

use the search and enter 1 lettter, like 'e', for example

[Jack.R.Abbit]

use the search and enter 1 lettter, like 'e', for example

 funny....

I guess I forgot that I always search for my name in topics I started... but the letter 'e' seems like a good choice too.

-Jack

[oldiesmann]

Another possibility: search for ' ' (a blank space).

[[Unknown]]

An interesting push on this - what about number of threads started?

-[Unknown]

[jenigma]

Thanks for the tips, guys.

I still would really like this mod though, especially the part about separating "All" into multiple pages. I like Unknown's idea too. That would be a great stat to have in profiles. Another idea: show their number of posts in each board....  to see where they are most active. Maybe in graph form. And show their ratio of posts to topics started in each forum. I know that's getting pretty complicated, but hey if you're gonna wish, wish big, right?

Any takers, for any part of this?

[[Unknown]]

Well, I'll provide some assistance... although i don't feel like making and supporting a mod .

$userID = $ID_MEMBEROfThePersonYouAreViewingsProfile;

// *Should* find the number of posts per board...
SELECT COUNT(t.ID_TOPIC), b.name
FROM topics AS t
  LEFT JOIN boards AS b ON (b.ID_BOARD=t.ID_BOARD)
  LEFT JOIN messages AS m ON (m.ID_TOPIC=t.ID_TOPIC)
WHERE m.ID_MEMBER=$userID
GROUP BY t.ID_BOARD

// Posts started by this user....
SELECT t.ID_TOPIC
FROM topics AS t, messages AS m
WHERE m.ID_MSG=t.ID_FIRST_MSG
  AND m.ID_MEMBER=$userID

// Number of posts started by this user.
SELECT COUNT(t.ID_TOPIC)
FROM topics AS t, messages AS m
WHERE m.ID_MSG=t.ID_FIRST_MSG
  AND m.ID_MEMBER=$userID

I would think it better to do that then store it in the database....

-[Unknown]

[jenigma]

I'm not sure how to use the code you've provided, Unknown. Could you provide a little bit more assistance for the php impaired?



Thanks.  

[jenigma]

Hello?

I need to know where to use this code. In profile.php? And does this code actually display the stats, or do I need separate code for that?

[[Unknown]]

Hello?

I need to know where to use this code. In profile.php? And does this code actually display the stats, or do I need separate code for that?

I just gave you a few queries to help along the way.  This code will actually do nothing....

-[Unknown]