All pastes #255412 Raw Edit

Sans nom

public text v1 · immutable
#255412 ·published 2006-11-22 23:11 UTC
rendered paste body
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;
}