1
Coding / Re: add user to additional member group
« on: September 28, 2008, 03:20:55 am »
I'm not saying that this is the only way to do this, but this is how I handled it.
It seems to work so far.
function onUse()
{
global $db_prefix, $ID_MEMBER, $item_info;
$result = db_query("SELECT additionalGroups
FROM {$db_prefix}members
WHERE ID_MEMBER = {$ID_MEMBER}", __FILE__, __LINE__);
$row = mysql_fetch_assoc($result);
$groups = explode(",",$row['additionalGroups']);
if(!in_array($item_info[1],$groups))
{
if(count($groups) > 1)
$groups[] = $item_info[1];
elseif((count($groups) == 1) AND ($groups[0] != ""))
$groups[] = $item_info[1];
else
$groups[0] = $item_info[1];
$add_grps = implode(",",$groups);
$result = db_query("UPDATE {$db_prefix}members
SET additionalGroups = '{$add_grps}'
WHERE ID_MEMBER = {$ID_MEMBER}", __FILE__, __LINE__);
}
return 'Added Member Group!';
}
It seems to work so far.