What table is used to hold the list of users and the usergroups they belong to?

[Frank H. Shaw]

The comma-separated list of numbers coming from the mysql query and parseing the results as a array = what is the best way to parse the resut array so that in the end i can load the comma-separated list of numbers contained in to my own data structire.

Looking at my last posting in this thread you will see i spelled out how am seeing the data now and how i need to see the data.

The following script below produces the following out put which is not really what i want

1
fshaw
6
9,10,11,12,13

This is for the first record and is correct now - but I want to take the comma-separated list of numbers and it is only for the membergroupids' which produced the last line above 9,10,11,12,13 and parse that comma-separated list so that if i was going to print ir out with a echo it would be unstead like this

9
10
11
12
13

The other values are stored and retrieved from my resluts set just fine.

While I have you attension there is one other question beside this one to ask that is how would the best way to find out who is currently logon the system.

I think I have this question answered some where in my notes: But due to my health situation it is some times hard for me to remmber where that informtion is at the monment.

I WILL FROM NOW ON USE THE NEWER FORMAT FOR THE PHP TAGS - WHEN DID THEY CHANGE BY THE WAY?

THANKS

Frank H. Shaw

--------------- Added [DATE]1232906568[/DATE] at [TIME]1232906568[/TIME] ---------------

I still have one question not answered that is the user.userid - That is how to find the currently logon user and if not one logon then he is guest so how do I tell that.

{Please note: I do not need to know who this person is just the fact of being a guest is good enough}.


Here is my script below that created the output I wanted is now correct.

PHP Code:


global $myuser;
$myuser = array();
$myusers = $vbulletin->db->query_read("SELECT userid, username, usergroupid, membergroupids FROM " . TABLE_PREFIX . "user ORDER BY userid");

while ($myuser = $vbulletin->db->fetch_array($myusers))
{

  echo($myuser['userid'] . "<br />");
  echo($myuser['username'] . "<br />");
  echo($myuser['usergroupid'] . "<br />");

  $tags = explode( ',', $myuser['membergroupids'] );
            foreach( $tags as $tag ) {
                  $tag = trim( $tag );
                  echo $tag . '<br />';

            }
 
} 


The script above creates this output below for all the users {Please note: I only show the output for one user.

1
fshaw
6
9
10
11
12
13

From here i can take it from this point.

THANKS
Frank H. Shaw

PS - I still need to know how to find the curent logon user just the user.userid and then I can search the user table and get the rest of the users.