Canned message edited"); $CANNED_found = 0; }else{ // show edit form $CANNED_id = $_GET["id"]; $result_canned = DATABASE_query("SELECT * FROM ".$DB_prefix."canned WHERE id='$CANNED_id'"); if($get = DATABASE_fetch($result_canned)){ $CANNED_found = 1; $CANNED_department = $get["department"]; if(isset($CANNED_department)){ $result = DATABASE_query("SELECT * FROM ".$DB_prefix."departments WHERE operator='$ADMIN_operator'"); while($find = DATABASE_fetch($result)){ $OPERATOR_dep = $find["department"]; if($OPERATOR_dep == $CANNED_department){ $CANNED_allow = 1; } } } $CANNED_operator = $get["operator"]; if(isset($CANNED_operator)){ if($CANNED_operator == $ADMIN_operator){ $CANNED_allow = 1; } } $CANNED_subject = $get["subject"]; $CANNED_message = $get["message"]; }else{ echo("