Users Threads in Profile [vB3]

Users Threads in Profile
vB3 Port!

Coded by: assassingod
Extras: g-force2k2
Version: 1

Description:
This shows the threads posted by a user in their profile. You can limit
to how many threads you want to be displayed, and private forums are automatically excluded

Don't forget to click in INSTALL button if you use my hack - Thanks!

[turbidblue]

in regards to this,

$forumids = implode ("', '", get_noaccess_forumids()) ;

will that automatically detect forums that some users are not allowed to view? ot do i need to add the forum ids?

if i need to add them, where in that code??

It works fine on my forum, 3.0.3, until i click on my name and view profile from a thread...then i get an error...

any help??

[Logikos]

/me clicks install!

[Logikos]

is there a way to make it in only certain fourmids? seprate with commas?

[assassingod]

Yep, delete

PHP Code:

$forumids = implode ("', '", get_noaccess_forumids()) ; 


and replace

PHP Code:

    WHERE postuserid = '$userinfo[userid]' AND forumid NOT IN ('$forumids') 


with

PHP Code:

    WHERE postuserid = '$userinfo[userid]' AND forumid IN ('x,y,z') 


Then use the forumids you wish to use there, in replacement of x,y,z

[Logikos]

you rock man!!! If i could click the install button twice i would

[assassingod]

Thankss

[Logikos]

Originally Posted by assassingod

Thankss

Theres a slight bug it seems. When i place this code.

PHP Code:

$getthreads = $DB_site->query("
        SELECT threadid,title,dateline
        FROM " . TABLE_PREFIX ."thread
        WHERE postuserid = '$userinfo[userid]' AND forumid IN ('27,28,29,30,31,32,11,5')
        ORDER BY dateline DESC
"); 


It only shows the threads in ID 27. Which is the first on the list. It doesn't grab the rest. Any reason why?

[Logikos]

Any way to do this so just the threads a user starts show up in the profile?

[LizerisCHN]

Originally Posted by Live Wire

Theres a slight bug it seems. When i place this code.

PHP Code:

$getthreads = $DB_site->query("
        SELECT threadid,title,dateline
        FROM " . TABLE_PREFIX ."thread
        WHERE postuserid = '$userinfo[userid]' AND forumid IN ('27,28,29,30,31,32,11,5')
        ORDER BY dateline DESC
"); 


It only shows the threads in ID 27. Which is the first on the list. It doesn't grab the rest. Any reason why?

Your code would need to look like this:

PHP Code:

$getthreads = $DB_site->query("
        SELECT threadid,title,dateline
        FROM " . TABLE_PREFIX ."thread
        WHERE postuserid = '$userinfo[userid]' AND forumid IN ('27','28','29','30','31','32','11','5')
        ORDER BY dateline DESC
"); 


It needs to define each forumid separately.

[Lee Wilde]

Very cool. Installed in minutes, thanks!