'; ?> Edit Group alert('groupname must be unique!');"; } else{ $sql = "Insert INTO mb_group (mb_group_name, mb_group_owner, mb_group_description) VALUES "; $sql.= "($1, $2,$3);"; $v = array($name,$owner_id,$description); $t = array('s','i','s'); $res = db_prep_query($sql,$v,$t); $selected_group = db_insert_id($res,"mb_group","mb_group_id"); } } #update if($action == 'update'){ $sql = "SELECT mb_group_id FROM mb_group WHERE mb_group_name = $1 AND mb_group_id <> $2"; $v = array($name,$selected_group); $t = array('s','i'); $res = db_prep_query($sql,$v,$t); if(db_fetch_row($res)){ echo ""; } else{ $sql = "UPDATE mb_group SET mb_group_name = $1"; $sql.=", mb_group_description = $2"; $sql.=" where mb_group_id = $3"; $v = array($name,$description,$selected_group); $t = array('s','s','i'); $res = db_prep_query($sql,$v,$t); } } if (!isset($name) || $selected_group == 'new'){ $name = ""; $owner_id = $_SESSION["mb_user_id"]; $owner_name = $_SESSION["mb_user_name"]; $description = ""; } /*HTML*****************************************************************************************************/ echo "
"; echo ""; #User echo ""; echo ""; echo ""; echo ""; if(isset($selected_group) && $selected_group != 0){ $sql = "SELECT * FROM mb_group WHERE mb_group_id = $1 ORDER BY mb_group_name "; $v = array($selected_group); $t = array('i'); $res = db_prep_query($sql,$v,$t); if($row = db_fetch_array($res)){ $name = $row["mb_group_name"]; $owner_id = $row["mb_group_owner"]; $description = $row["mb_group_description"]; } $sql = "SELECT mb_user_name FROM mb_user WHERE mb_user_id = $1"; $v = array($owner_id); $t = array('i'); $res = db_prep_query($sql,$v,$t); if($row = db_fetch_array($res)){ $owner_name = $row["mb_user_name"]; } } #name echo ""; echo ""; echo ""; echo ""; #owner echo ""; echo ""; echo ""; echo ""; #description echo ""; echo ""; echo ""; echo ""; echo"
"; echo "Group: "; echo ""; echo ""; echo "
Name:"; echo ""; echo "
Owner: "; echo ""; echo ""; echo "
Description: "; echo ""; echo "
"; if($selected_group == 'new' || !isset($selected_group)){ echo ""; } if($_SESSION["mb_user_id"] == $owner_id && $selected_group != 'new' && $selected_group != '' ){ echo ""; echo ""; } ?>