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!

[assassingod]

You havent defined one of the variables (The exluded forums one)

[NuclioN]

I've defined the variables but the error remains so i've removed the line to see why the error is showing up. I use table prefix so the 'SELECT threadid,title,dateline
FROM thread'

was not working. I've added the prefix before 'thread' and now it's working.

[assassingod]

Ah yes, I forgot that - thanks for reminding me.

[g-force2k2]

Originally Posted by assassingod

// Coming Soon:
Thread Permissions (No need to manually exclude forums!)

assassingod you can use my permissions code from one of my hacks.

The function:

PHP Code:

function get_noaccess_forumids (  )
{
    global $forumcache, $bbuserinfo ;

    $_naforumids = array (  ) ;
    $_naforumids[] = 0 ;
    foreach ( $forumcache AS $forumid => $farray ) :
        if ( ! ( $farray['permissions']["$bbuserinfo[usergroupid]"] & CANVIEW ) ) :
            $_naforumids[] = $forumid ;
        endif ;
    endforeach ;

    return $_naforumids ;
} 


It use the forumcache to run through user permissions so it doesn't require a query to check which users can access which forums, though it doesn't run a check on the access masks it does do the forum permissions.

Then in the member.php? im guessing add:

PHP Code:

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


This takes the forums which users have no access to and sets it up for the sql statement.

Then in the WHERE section of the sql statement add:

PHP Code:

thread.forumid NOT IN ( '$forumids' ) 


Cheers,
g-force2k2

[assassingod]

Thanks very much g-force! I'll test this out right away

[MGM]

assassingod... does that code work properly and correctly? let us know :P

/me clicks Install to know when the new version is released

also: does this show the person's latest threads or just random threads?

MGM out

[AutomatikStudio]

I'm getting the same database error NuclioN got.

[assassingod]

AutomatikStudio;
Have defined the $excluded variable? and do you have a table prefix?

[AutomatikStudio]

Originally Posted by assassingod

AutomatikStudio;
Have defined the $excluded variable? and do you have a table prefix?

I ended up just putting "0" in the excluded variable and it's fine now.

[assassingod]

Originally Posted by AutomatikStudio

I ended up just putting "0" in the excluded variable and it's fine now.

I'll add that as default.

MGM;
This shows the latest threads.