Querying Usergroups Then Array Help?

[paul41598]

Right I did. In newthread template I have $der2 for example.

Then this is part of the code from earlier.

$usergroupdata = array();
while ($usergroup = $vbulletin->db->fetch_array($usergroups))
{
 $usergroupdata[$usergroup['usergroupid']] = $usergroup['title'];
$der2 = $usergroup['title'];
eval('$der .= "' . fetch_template('jon') . '";');
}

But see I need the title and ID from each usergroup. The ID would get associated with the checkbox name or value I'm guessing. Then the usergroup title would just be listed to each checkbox

oh and the template jon I have:

<label for="usergroups">
<input type="checkbox" name="" value="" id="" tabindex="1" />$der2
</label>

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



Hmm, changed it around cuz I found some issues with my code (idiot) doh.

newthread form complete hook

$usergroupdata = array();
while ($usergroup = $vbulletin->db->fetch_array($usergroups))
{
 //Assign group title to $grouptitle variable
 $usergroupdata[$usergroup['title']] = $usergroup['title'];
 $grouptitle = $usergroupdata[$usergroup['title']];

 //Assign group ID to $groupID variable
 $usergroupdata[$usergroup['usergroupid']] = $usergroup['usergroupid'];
 $groupID= $usergroupdata[$usergroup['usergroupid']];

eval('$der .= "' . fetch_template('jon') . '";');
}

Jon template:

<label for="usergroups">
<input type="checkbox" name="groupID" value="$groupID" id="" tabindex="1" />$grouptitle
</label>

newthread post complete hook

$vbulletin->input->clean_array_gpc('p', array('groupID' => TYPE_ARRAY));

echo $vbulletin->GPC['groupID'];

At least its displaying so far.


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

I think I got it to display all ID's that I check!

My newthread post complete hook was wrong. This works. Maybe you can double check to make sure its written correctly though. Also, what if I needed to get all email address from users associated with each checkbox. Wouldnt' I just do a left join on that original query?

$vbulletin->input->clean_array_gpc('p', array('groupID' => TYPE_ARRAY));

foreach ($vbulletin->GPC['groupID'] AS $id)
{
    echo $id . " ";
}

[Dismounted]

You're making it so complicated...

PHP Code:

while ($usergroup = $vbulletin->db->fetch_array($usergroups))
{
    eval('$der .= "' . fetch_template('jon') . '";');
} 


<label for="usergroups">
<input type="checkbox" name="groupID" value="$usergroup[usergroupid]" id="" tabindex="1" />$usergroup[title]
</label>

[paul41598]

lol, ya I always do it seems

So if I'm trying to pull all email address who are IN those $usergroupids

$usergroups = $vbulletin->db->query_read("
    SELECT usergroup.usergroupid, usergroup.title, user.email
    FROM " . TABLE_PREFIX . "usergroup AS usergroup, user AS user
    WHERE usergroup.usergroupid IN ($usergroupids)

");

I tried the LEFT join on the user table, no good. Can you point me in the right direction of what I'm missing here?

UPDATE: ( 9:33pm)
Ok I've been working on this. Instead of the query going in the form complete, I'm putting it in there newthread post complete: Here is my updated code. It wont work though.

$vbulletin->input->clean_array_gpc('p', array('groupID' => TYPE_ARRAY));

foreach ($vbulletin->GPC['groupID'] AS $id)
{
$ids = $id;
}

$usergroups2 = $vbulletin->db->query_read("
    SELECT email
    FROM " . TABLE_PREFIX . "user
    WHERE usergroupid IN ($ids)
");

while ($usergroups3 = $vbulletin->db->fetch_array($usergroups2))
{
//send to my email to test if subject line is parsing variables
vbmail("my_email_was_here.net", $usergroups3['email'], $message);
}

[DJ29Joesph]

Funny, I am kinda trying to do the same thing.. I want a page that shows the second membergroupids 'id' and tells me the title.

Johns Membergroup Ids is: 12, 31

I want it to pick up '31' and tell me the title for '31'. Any Ideas