print '<OPTION VALUE="problemstart">Problem Starts</OPTION>' . "\n"; print '<OPTION VALUE="problemend">Problem Ends</OPTION>' . "\n"; print '</SELECT></TD></TR>' . "\n"; // Search by Location print '<TR><TD VALIGN="top" CLASS="td_label">Location: </TD>' . "\n"; print '<TD><SELECT NAME="frm_location">' . "\n"; print '<OPTION VALUE="" checked>All</OPTION>' . "\n"; get_option_constant("location", "All"); //, $index); print '</SELECT></TD></TR>' . "\n"; // Search by Owner print '<TR><TD VALIGN="top" CLASS="td_label">Owned by: </TD>' . "\n"; print '<TD><SELECT NAME="frm_owner">' . "\n"; print '<OPTION VALUE="" checked>All</OPTION>' . "\n"; //get_option_owner("user", $_SESSION['ticket_username']); // , $index); get_option_owner(get_id_from_user($_SESSION['ticket_username'])); // , $index); print '</SELECT></TD></TR>' . "\n"; // Search Open , Closed, All. print '<TR><TD VALIGN="top" CLASS="td_label">Status: </TD>' . "\n"; print '<TD><INPUT TYPE="radio" NAME="frm_querytype" VALUE="%" CHECKED> All ' . "\n"; print '<INPUT TYPE="radio" NAME="frm_querytype" VALUE="' . $STATUS_OPEN . '"> Open ' . "\n"; print '<INPUT TYPE="radio" NAME="frm_querytype" VALUE="' . $STATUS_CLOSED . '"> Closed' . "\n"; print '</TD></TR>' . "\n"; print '<TR><TD COLSPAN="2"> <hr></TD></TR>' . "\n"; // Order Search result By, ASC or DESC print '<TR ALIGN="LEFT" ><TD COLSPAN="2" CLASS="td_link">Order By: </TD></TR>' . "\n"; print '<TR>' . "\n"; print '<TD><SELECT NAME="frm_ordertype">' . "\n"; print '<OPTION VALUE="t_date">Issue Date</OPTION>' . "\n"; print '<OPTION VALUE="problemstart">Problem Starts</OPTION>' . "\n";
$set_passwd = 1; } } else { if ($_POST['frm_passwd_confirm'] != '') { print '<FONT CLASS="warn">You need to fill in both password fields. Password is not updated.</FONT><BR>'; } } if (!$set_passwd) { $query = "UPDATE user SET info='{$_POST['frm_info']}',email='{$_POST['frm_email']}' WHERE id='{$_POST['frm_id']}'"; } else { $query = "UPDATE user SET passwd=PASSWORD('{$_POST['frm_passwd']}'),info='{$_POST['frm_info']}',email='{$_POST['frm_email']}'\n\t\t\t\t\tWHERE id='{$_POST['frm_id']}'"; } $result = mysql_query($query) or do_error('config.php::profile(update)', 'mysql_query() failed', mysql_error()); print '<B>Your profile has been updated.</B><BR><BR>'; } else { $id = get_id_from_user($_SESSION['ticket_username']); if ($id < 0 or check_for_rows("SELECT id FROM user WHERE id='{$id}'") == 0) { print "Invalid user id '{$id}'."; powered(); // Print "Powered by" and end the HTML page exit; } $query = "SELECT * FROM user WHERE id='{$id}'"; $result = mysql_query($query) or do_error('config.php::profile(get)', 'mysql_query() failed', mysql_error()); $row = mysql_fetch_array($result); print '<FONT CLASS="header">Edit My Information</FONT><BR><BR><TABLE><TR><TD>'; print '<TABLE BORDER="0"> <FORM METHOD="POST" ACTION="config.php?mode=profile&go=true"> <INPUT TYPE="hidden" NAME="frm_id" VALUE="' . $id . '">'; print '<TR><TD CLASS="td_label">New Password:</TD> <TD colspan="2"><INPUT MAXLENGTH="30" SIZE="40" TYPE="password" NAME="frm_passwd"></TD></TR>';