function user_is_in_group($groupname) {
global $db,$user_data;
if (empty($groupname)) return false;
$request = "select group_id from ".TABLE_GROUP." where group_name like '".mysql_real_escape_string($groupname)."' limit 1";
$result = $db->sql_query($request);
if ( list($group_id) = $db->sql_fetch_row($result) ) {
$request="SELECT count(*)"
." FROM ".TABLE_USER_GROUP
." WHERE user_id='".intval($user_data["user_id"])."' AND group_id='".$group_id."'";
$result = $db->sql_query($request);
list($isingroup) = $db->sql_fetch_row($result);
if ($isingroup=1) return true;
}
return false;
}