Member post request

[Sin City]

i know there is a hack that tells what each user's "favorite" forum to post in.... but i searched and did not find quite what i was looking for

i was wondering if someone could make a hack which allows admins and smods to see what each forum a person has posted in

like it will show their name and divide up their posts and threads created by forum... for example:

Bob

Sports
Threads - 3
Posts - 45

Music
Threads - 6
Posts - 145

hope i made it clear enough what i am looking for

[Sin City]

shameless bump

[Sin City]

:surprised: must...put...back...on...top

[FWF]

that would be a very useful hack.

[Tekton]

Well, for the threads.... query the thread table and grab all threads by the user (postusername or postuserid), and then do a while that sorts them all by the forumid. Then you should have the number for each (of threads at least), and then grab the highest one and then query that forumid to the forum table if you want it's name.

Sorry for not writing that out in actual code, but it'd be something like that. For posts in forum, it'd be another step(s) added on due to having to search for the threadid's that each post belonged to and then matching those to a forum each time.

[Sin City]

cool... i guess i'll mess around and see if it works, thanks

[Andreas]

Threads (started by this user):
[sql]SELECT forumid, COUNT( threadid ) AS threads FROM thread WHERE postuserid = 1234 GROUP BY forumid ORDER BY forumid ASC LIMIT 0, 30[/sql]

Posts:
[sql]SELECT thread.forumid AS forumid, COUNT( post.postid ) AS posts FROM post LEFT JOIN thread ON ( thread.threadid = post.threadid ) WHERE post.userid = 1234 GROUP BY thread.forumid ORDER BY forumid ASC[/sql]

Another aproach
[sql]
SELECT thread.forumid AS forumid, COUNT( post.postid ) AS posts, SUM(IF(thread.postuserid = 1234 AND thread.firstpostid = post.postid, 1, 0) ) AS threads FROM post LEFT JOIN thread ON ( thread.threadid = post.threadid ) WHERE post.userid = 1234 GROUP BY thread.forumid ORDER BY forumid ASC
[/sql]

This should give you both figures in one query.

I've attached a quick'n'dirty ACP script that might do what you want.

[Sin City]

awesome KirbyDE.... you are the man ... thank you

[Sin City]

ok i uploaded the .php file KirbyDE set up for me into my admincp folder... but in order to see it in my admincp i'd need to edit the index.php file... i looked in the actual file and i have somewhat of an idea of what i'd need to imput, but if someone could tell me the coding to put into it, that'd be greatly appreciated... thanks in advance

[Marco van Herwaarden]

Just go to the url: www.myboard.com/admincp/postlookup.php