Help with is_member_of condition

[misterfade]

I have a custom table setup called 'sellers' and I want to query that table to get all the userid's from there, then match it with the userid's in the vbulletin user table, then see if they're part of specific usergroups.

I figure the easiest option would be to get the sellers userid's and then use it in a loop with is_member_of but what would be the correct syntax?

All I know is the basic:

PHP Code:

is_member_of($vbulletin->userinfo, 1, 2, 3) 


Any help would be appreciated. Thanks.

[Boofo]

if (is_member_of($vbulletin->userinfo, 1, 2, 3))
{
do this
} else {
do that
}

[misterfade]

Sorry, that's not what I mean.

What I'm wondering is if I can use that and at the same time match it with the userid's from my sellers table.

Something like this:

PHP Code:

if ($row['seller_userid'] = (!is_member_of($vbulletin->userinfo, 1, 2, 3))) 


I know that code doesn't make any sense but that's what I'm wondering. Or would I be better off just running a query across both tables to match up?

[Farcaster]

$vbulletin->userinfo contains an array of variables for the user who is viewing the page. Instead, you would need to create a userinfo array for your seller. You could do this by using the fetch_userinfo function (included in functions.php). Example:

PHP Code:

// this is going to add a query for every time you loop through.. not very good.
$seller_userinfo = fetch_userinfo($row['seller_userid']);
if (!is_member_of($seller_userinfo, 1, 2, 3)) {
    // Do this if the seller is not in group 1, 2, or 3
} else {
    // Do this if the seller IS in group 1, 2, 3
} 


Personally though, I would not want to use this implementation because every loop through is going to require an additional query to get the sellers account information. Instead, I'd probably just join to the user table on the seller ID and use a WHERE clause like this:

[sql]WHERE (user.usergroupid IN (1,2,3) OR user.membergroupids IN (1,2,3))[/sql]

You could also use that in a CASE statement in the SQL Query if you want to assign a particular value to a field that your program would read. Like this:

[sql]CASE WHEN (user.usergroupid IN (1,2,3) OR user.membergroupids IN (1,2,3))
THEN 1 ELSE 0 END) AS valid_seller[/sql]

Hope that helps...

[misterfade]

Farcaster,

You're right, that would be a big loop to do, so I'll try a join and see what I can come up with.

Thanks.