";
exit;
}
$maintMode="on";
if( (isset($maintMode)) && ($_SESSION['MemberNumber'] <> (1241 or 1446) ) ) {
//echo(" Member Number is [ ". $_SESSION['MemberNumber']. " ] ");
echo "System is currently down for maintenance. Please try again later. ";
exit;
}
$url = "index.php";
unset ($auth);
if ($trace) {
echo "TRACE is turned on ";
echo "Authorization verified ";
}
$title = " - Profile Editor";
include_once("inc_prof_variables.php");
if ($trace) {echo "mode = [$mode] ";}
//if ($trace) {echo "";}
if ($mode == "") {$mode="main";}
if ($trace) {echo "option is set to [$option] ";}
if ($trace) {echo "mode is set to [$mode] ";}
/* create additional styles and scripts that get pulled in by the head section */
$head="
"; /* End of head insert */
include("head.html"); /* includes and opens and
Query = [$query] ";
$query_results=mysql_query($query);
$match_results=mysql_num_rows($query_results);
if ($match_results > 0) {
$alert="Profile ".$Userid." Net Number could not be changed - Number $newNumb is already in use!";
alert($alert);
echo "
Profile $Userid can not be added because it already exists.
" ;
} else {
if ($trace) {echo '';}
$query="Update $tablename set membernumber=$newNumb where membernumber=$MemberNumber";
include("write_to_profile_log.php");
if ($trace) echo " Query will be "$query" ";
if(! mysql_query($query)) {
echo " ERROR UPDATING DATABASE Please notify the webmaster. ";
exit;
} else {
Alert ("Net Number $MemberNumber has been changed to $newNumb");
}
}
$mode="search";
}
if ($mode == "change") { // ### Change Member Number and continue with mainscreen ###
if ($trace) alert("This is the change member number section");
echo ("
");
} // Close of Change
if ($mode == "update") { // ### update the record and continue with main screen ###
include "inc_profile_update.php";
$mode="search";
} // Close of Update
if($EditBtn == "Delete") { // ### delete the record and continue with main screen ###
open_db();
$query="delete from $tablename WHERE MemberNumber = '$MemberNumber'";
alert("Writing to Profile Log");
include("write_to_profile_log.php");
$results=mysql_query($query);
if (!$results) {
alert($Userid." could NOT be deleted");
} else {
alert($Userid." has been deleted");
}
$mode="search";
} // Close of Delete
if(($mode == "main") or ($mode == "search") ) { // ############### The Main Screen ###################
if ($trace) {echo "Eentering main screen process ";}
// ########## continue with main screen ###########
//if ($trace) {echo '';}
if ($trace) {echo "Preparing to display main screen";}
?>
Search works with any series of consecutive characters - even partial name or User-ID. NOTE: Spaces are ignored - use a single string of consecutive characters.
confirm("Preparing to display search results")';}
if ($trace) {echo "Search Text was [$txtSearch]
";}
$txtSearch=(trim($txtSearch));
If ($Button=='View All Profiles') {
if ($trace) {echo "Will display all Profiles ";}
$query= "select * from $tablename order by $Sort";
}
else {
$txtSearch = str_replace(" ", "", $txtSearch);
if ($trace) {echo "Will search for [$txtSearch] ";}
// $query= "select * from $tablename where (concat(Userid,' ',LName,' ',FName) like '%".$txtSearch."%') order by $Sort";
// $query= "select * from $tablename where Userid like '%".$txtSearch."%' or LName like '%".$txtSearch."%' or FName like '%".$txtSearch."%' or MemberNumber = '$txtSearch' order by $Sort";
// $query= "select * from $tablename where (concat(Userid,LName,FName,SP_Userid,SP_FName) like '%".$txtSearch."%' or SP_LName like '%".$txtSearch."%') or MemberNumber = '$txtSearch' order by $Sort";
$query= "select * from $tablename where (FName like '%$txtSearch%' ) or (SP_FName like '%$txtSearch%') or (LName like '%$txtSearch%' ) OR (Userid like '%$txtSearch%' ) OR (Membernumber like '%$txtSearch%' ) OR (AccountNumber like '%$txtSearch%' ) order by $Sort";
// if ($txtSearch+1 > 1) $query="select * from $tablename where membernumber = $txtSearch";
}
if ($trace) {echo "Query will be [$query] ";}
require_once'inc_profile_read.php';
if ($match_results<1 ) {echo "\"$txtSearch\" was not found in the Member Profiles Database. ";}
echo"Number of matching records=[$match_results] ";
?>
\n";
// Now add last update info to bottom of table
$query="select max(ChangedDate) FROM $tablename";
$query_results=mysqli_query($link,$query);
//echo "query results= [ $query_results ] ";
$match_results=mysqli_num_rows($query_results);
//echo "match results= [ $match_results ] ";
$row=mysqli_fetch_array($query_results);
echo "Database last update time: $row[0]";
echo "";
}
elseif ($mode == "Edit") { // ############ Edit a user profile ############
// if ($trace) {echo '';}
if ($trace) {echo "Displaying edit screen. ";}
$query= "select * from $tablename where membernumber = $MemberNumber";
include "inc_profile_read.php";
include "inc_profile_table.php";
} // end of if $screen == edit
?>