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.
01-11-2005, 07:08 AM
Threaded Mode