0 ) { $track_url = $_POST['newtrack']; //*** set species *** $reg_species = $species_selected; if ( !empty($_POST['new_species'])) { $reg_species = $_POST['new_species']; } //*** set revision *** $reg_revision = $revision_selected; if ( !empty($_POST['new_revision'])) { $reg_revision = $_POST['new_revision']; } //*** set optparam *** $optparam=""; if ( !empty($_SESSION['optparam']) ) { $optparam = $_SESSION['optparam']; } $tracks = array(); exec_regist_track_from_url( $track_url,$tracks,$reg_species,$reg_revision,$optparam,$admin); unset($_SESSION['optparam']); $auth = TRUE; } //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //********************************************* // Upload Track //********************************************* else if ( isset($_POST['upload_easytrackfile_btn']) ) { $htmlSID = htmlspecialchars(SID); $uploadfile = ""; $uploadfile = $utgb_uploaded_easytrack_dir."/".$_FILES['upload_easytrackfile_path']['name']; if (move_uploaded_file($_FILES['upload_easytrackfile_path']['tmp_name'], $uploadfile)) { $cmd = "chmod 644 $uploadfile"; shell_exec(escapeshellcmd($cmd)); $tracks = array(); exec_regist_track_from_uploadfile( $uploadfile,$tracks,$species_selected,$revision_selected,$admin ); } else { $msg = "Fail to move uoloaded file to 'uploaded_easytrack' directory."; show_error_message($msg); } $auth = TRUE; } //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //************************************************ // Delete / Modify on user list //************************************************ else if ( isset($_POST['tracklist']) ) { foreach ( $_POST as $key => $val ) { if( preg_match( '/^(\d+)-delete$/', $key, $match ) ) { $delete_uid = $match[1]; break 1; } else if( preg_match( '/^(\d+)-modify$/', $key, $match ) ) { $modify_uid = $match[1]; break 1; } else if( preg_match( '/^(\d+)-apply$/', $key, $match ) ) { $apply_uid = $match[1]; break 1; } } // delete if ( isset($delete_uid) ) { $sql = "SELECT NAME FROM USERS WHERE UID=".$delete_uid; $res = pg_query( $hDB_trackinformation, $sql ); $name = pg_fetch_result( $res, 0, 'name' ); pg_query( $hDB_trackinformation,'BEGIN' ); $sql_history = "DELETE FROM HISTORY WHERE UID=".$delete_uid; $sql_track = "DELETE FROM TRACK WHERE UID=".$delete_uid; $sql_track = "DELETE FROM TRACKORDER WHERE UID=".$delete_uid; $sql_users = "DELETE FROM USERS WHERE UID=".$delete_uid; $res_history = pg_query( $hDB_trackinformation, $sql_history ); $res_track = pg_query( $hDB_trackinformation, $sql_track ); $res_users = pg_query( $hDB_trackinformation, $sql_users ); if ( pg_result_status($res_history) == PGSQL_COMMAND_OK && pg_result_status($res_track) == PGSQL_COMMAND_OK && pg_result_status($res_users) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT'); show_message("Deleted user '$name' and $name's tracks."); } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); show_error_message("Can not delete user '$name'."); } } // modify Ë apply else if ( isset($apply_uid) ) { $sql = "SELECT NAME FROM USERS WHERE UID=".$apply_uid; $res = pg_query( $hDB_trackinformation, $sql ); $name = pg_fetch_result( $res, 0, 'name' ); $e_mail = $_POST['edit_e_mail']; $authority = $_POST['edit_authority']; $sql = "UPDATE USERS SET E_MAIL='$e_mail',AUTHORITY='$authority' WHERE UID=$apply_uid"; $res = pg_query( $hDB_trackinformation, $sql); if ( pg_result_status($res) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT'); show_message("Modified user '$name'."); } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); show_error_message("Can not modify user '$name'."); } } } //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //************************************************ // Change Public/Private of Track List //************************************************ else if (isset( $_POST["btn_tracklist_apply"]) ) { $species = $_POST['select_species']; $revision = $_POST['select_revision']; $sql_1 = "SELECT DISTINCT NAME FROM TRACK WHERE SPECIES='$species' AND REVISION='$revision'"; $res_1 = pg_query($hDB_trackinformation, $sql_1); pg_query( $hDB_trackinformation, 'BEGIN' ); //*** Public ©¨ Private *** for ( $i = 0; $i < pg_num_rows($res_1) ; $i++ ) { $track_name = pg_fetch_result( $res_1, $i, 'name' ); $chk_name = "chk_".convertExceptTrackName($track_name); $radio_name = "radio_".convertExceptTrackName($track_name); $order_str = ""; if ( isset($_POST[$chk_name]) ) { $sql_2 = "SELECT TID,UID FROM TRACK WHERE SPECIES='$species' AND REVISION='$revision' AND NAME='".pg_escape_string($track_name)."'"; $res_2 = pg_query($hDB_trackinformation, $sql_2); for ( $j = 0; $j < pg_num_rows($res_2) ; $j++ ) { $tid = pg_fetch_result( $res_2, $j, 'tid' ); if ( isset($_POST[$radio_name]) ) { if ( $_POST[$radio_name] == $tid ) { $sql_3 = "UPDATE TRACK SET EXHIBIT='public' WHERE TID=".$_POST[$radio_name]; } else { $sql_3 = "UPDATE TRACK SET EXHIBIT='private' WHERE TID=$tid"; } } $res_3 = pg_query($hDB_trackinformation, $sql_3); if ( pg_result_status($res_3) == PGSQL_COMMAND_OK ) { } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); $msg = "Cannot change public/private...."; show_error_message($msg); break 1; } } } else { $sql_4 = "SELECT TID FROM TRACK WHERE SPECIES='$species' AND REVISION='$revision' AND NAME='".pg_escape_string($track_name)."'"; $res_4 = pg_query($hDB_trackinformation, $sql_4); for ( $j = 0; $j < pg_num_rows($res_4) ; $j++ ) { $tid = pg_fetch_result( $res_4, $j, 'tid' ); $sql_5 = "UPDATE TRACK SET EXHIBIT='private' WHERE TID=".$tid; $res_5 = pg_query($hDB_trackinformation, $sql_5); if ( pg_result_status($res_5) == PGSQL_COMMAND_OK ) { } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); $msg = "Cannot change public/private...."; show_error_message($msg); break; } } } } pg_query( $hDB_trackinformation, 'COMMIT' ); //-------------------------------------------------------------------------- // 2005.5.18 t.shishiki add $order_str_ary = array(); foreach ( $_POST as $key => $value ) { if( preg_match( '/^chk_([^ ]+)/', $key, $match ) ) { $trackname = $match[1]; $order_str_ary[] = $trackname; } } $order_str = pg_escape_string(join(':',unconvertExceptTrackName($order_str_ary)) ); $sql_update = "UPDATE TRACKORDER SET ORDER_STR='$order_str' WHERE SPECIES='$species' AND REVISION='$revision' AND UID IS NULL"; pg_query( $hDB_trackinformation, 'BEGIN'); $res_update = pg_query( $hDB_trackinformation, $sql_update ); if ( pg_result_status( $res_update ) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT'); } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); } //-------------------------------------------------------------------------- $auth = TRUE; } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //****************************** // Add option attribute //****************************** else if (isset( $_POST["btn_optparam_add"]) ) { // Empty Check if ( empty($_POST['optparam_key']) || empty($_POST['optparam_val']) ) { $msg = "Cannnot add option attribute because 'key' or 'value' is empty..."; show_error_message($msg); } else { $key = $_POST['optparam_key']; $value = $_POST['optparam_val']; $_SESSION['optparam'][$key] = $value; } } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //*********************************** // remove option attribute element //*********************************** else if( isset($_POST['btn_optparam_remove']) ) { foreach ( $_POST as $key => $val ) { if( preg_match( '/^chk_optparam_([^ ]+)/', $key, $match ) ) { $optparam_key = $match[1]; unset($_SESSION['optparam'][$optparam_key]); } } } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //******************************** // reset option attribute element //******************************** else if (isset($_POST['btn_optparam_reset']) ) { unset($_SESSION['optparam']); } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //******************************** // modify display parameter //******************************** else if (isset($_POST['btn_disparam_apply']) ) { $disparam = array(); $disparam['species'] = $_POST['disparam_species']; $disparam['revision'] = $_POST['disparam_revision']; $disparam['target'] = $_POST['disparam_target']; $disparam['start'] = $_POST['disparam_start']; $disparam['end'] = $_POST['disparam_end']; $disparam['width'] = $_POST['disparam_width']; $sql_update = "UPDATE DISPARAM SET SPECIES='".$disparam['species']."', REVISION='".$disparam['revision']."', TARGET='".$disparam['target']."', START_POSITION='".$disparam['start']."', END_POSITION='".$disparam['end']."', WIDTH='".$disparam['width']."' WHERE DID=1"; pg_query( $hDB_trackinformation, 'BEGIN' ); $res_update = pg_query( $hDB_trackinformation, $sql_update ); if ( pg_result_status($res_update) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT' ); } else { pg_query( $hDB_trackinformation, 'ROLLBACK' ); } } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //******************************** // OTHERS //******************************** else { foreach ( $_POST as $key => $value ) { //******************************** // up //******************************** if( preg_match( '/^btn_up_([^ ]+)/', $key, $match ) ) { $track_name = unconvertExceptTrackName($match[1]); $sql_trackorder = "SELECT * FROM TRACKORDER WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND UID IS NULL"; $res_trackorder = pg_query( $hDB_trackinformation, $sql_trackorder ); if ( pg_num_rows($res_trackorder) == 1 ) { $order_str = pg_fetch_result( $res_trackorder, 0, 'order_str' ); $toid = pg_fetch_result( $res_trackorder, 0, 'toid' ); $order_str_ary = explode( ':', $order_str ); foreach ( $order_str_ary as $i => $order_track_name ) { if ( $order_track_name == $track_name ) { $pos = $i; break; } } if ( $pos != 0 ) { $tmp_track_name = $order_str_ary[$pos-1]; $order_str_ary[$pos-1] = $track_name; $order_str_ary[$pos] = $tmp_track_name; $new_order_str = join(":",$order_str_ary); $sql_update = "UPDATE TRACKORDER SET ORDER_STR='".pg_escape_string($new_order_str)."' WHERE TOID=$toid"; pg_query( $hDB_trackinformation, 'BEGIN'); $res_update = pg_query( $hDB_trackinformation, $sql_update ); if ( pg_result_status($res_update) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT'); } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); } } } else { $msg = "Cannot 'up' $track_name..."; show_error_message($msg); } } //******************************** // down //******************************** if( preg_match( '/^btn_down_([^ ]+)/', $key, $match ) ) { $track_name = unconvertExceptTrackName($match[1]); $sql_trackorder = "SELECT * FROM TRACKORDER WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND UID IS NULL"; $res_trackorder = pg_query( $hDB_trackinformation, $sql_trackorder ); if ( pg_num_rows($res_trackorder) == 1 ) { $order_str = pg_fetch_result( $res_trackorder, 0, 'order_str' ); $toid = pg_fetch_result( $res_trackorder, 0, 'toid' ); $order_str_ary = explode( ':', $order_str ); foreach ( $order_str_ary as $i => $order_track_name ) { if ( $order_track_name == $track_name ) { $pos = $i; break; } } if ( $pos != (count($order_str_ary)-1) ) { $tmp_track_name = $order_str_ary[$pos+1]; $order_str_ary[$pos+1] = $track_name; $order_str_ary[$pos] = $tmp_track_name; $new_order_str = join(":",$order_str_ary); $sql_update = "UPDATE TRACKORDER SET ORDER_STR='".pg_escape_string($new_order_str)."' WHERE TOID=$toid"; pg_query( $hDB_trackinformation, 'BEGIN'); $res_update = pg_query( $hDB_trackinformation, $sql_update ); if ( pg_result_status($res_update) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT'); } else { pg_query( $hDB_trackinformation, 'ROLLBACK'); } } } else { $msg = "Cannot 'up' $track_name..."; show_error_message($msg); } } //******************************** // drop //******************************** if( preg_match( '/^btn_drop_([^ ]+)/', $key, $match ) ) { $tid = $match[1]; $sql_select_track = "SELECT * FROM TRACK WHERE TID=".$tid; $res_track = pg_query( $hDB_trackinformation, $sql_select_track ); $track = array(); $track['tid'] = $tid; $track['name'] = pg_fetch_result( $res_track, 0, 'name' ); $track['kind'] = pg_fetch_result( $res_track, 0, 'kind' ); $track['url'] = pg_fetch_result( $res_track, 0, 'data_location' ); $track['uid'] = pg_fetch_result( $res_track, 0, 'uid' ); // DROP CACHE DB if ( $track['url'] == "cache" ) { switch ($track['kind']) { case "gene": $DB_NAME = "cachegene_".$track['name']."_".$species_selected."_".$revision_selected; break; case "graph": $DB_NAME = "cachegraph_".$track['name']."_".$species_selected."_".$revision_selected; break; case "color": $DB_NAME = "cachecolor_".$track['name']."_".$species_selected."_".$revision_selected; break; default: show_error_message("Cannot drop '".$track['name']." because 'Track Type' is unknown."); break; } global $utgb_postgre_install_dir; global $utgb_cachedb_public_host; global $utgb_cachedb_insert_host; global $ld_path_str; # from public_host $command = $ld_path_str."dropdb -U postgres -h $utgb_cachedb_public_host $DB_NAME"; $result = shell_exec(escapeshellcmd($command)); # from insert_host if ( $utgb_cachedb_insert_host != "" ) { $command = $ld_path_str."dropdb -U postgres -h $utgb_cachedb_insert_host $DB_NAME"; $result = shell_exec(escapeshellcmd($command)); } } //*********** UPDATE TRACKINOFORMATION START *************** pg_query( $hDB_trackinformation, 'BEGIN'); // delete from history $sql_delete_history = "DELETE FROM HISTORY WHERE TID=".$tid; $res_delete_history = pg_query( $hDB_trackinformation, $sql_delete_history ); // delete from trackorder $sql_select_trackorder = "SELECT * FROM TRACKORDER WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND UID IS NULL"; $res_trackorder = pg_query( $hDB_trackinformation, $sql_select_trackorder ); if ( pg_num_rows($res_trackorder) == 1 ) { $toid = pg_fetch_result($res_trackorder,0,'toid'); $order_str_ary = explode(":",pg_fetch_result($res_trackorder,0,'order_str')); foreach ( $order_str_ary as $i => $track_name ) { if ( $track_name == $track['name'] ) { $remove_pos = $i; break; } } array_splice( $order_str_ary, $remove_pos, 1 ); $order_str = implode( ":", $order_str_ary ); $sql_update_trackorder = "UPDATE TRACKORDER SET ORDER_STR='".pg_escape_string($order_str)."' WHERE TOID=".$toid; $res_update_trackorder = pg_query( $hDB_trackinformation, $sql_update_trackorder ); } else { show_error_message("Cannot drop track because 'order_str' does not exist."); } // delete from track $sql_delete_track = "DELETE FROM TRACK WHERE TID=".$tid; $res_delete_track = pg_query( $hDB_trackinformation, $sql_delete_track ); if ( pg_result_status($res_delete_history) == PGSQL_COMMAND_OK && pg_result_status($res_update_trackorder) == PGSQL_COMMAND_OK && pg_result_status($res_delete_track) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT' ); } else { show_error_message("Cannot drop track."); pg_query( $hDB_trackinformation, 'ROLLBACK' ); } //*********** UPDATE TRACKINOFORMATION END *************** } //******************************** // remove //******************************** if( preg_match( '/^btn_remove_([^ ]+)/', $key, $match ) ) { $track_name = unconvertExceptTrackName($match[1]); $sql_select_trackorder = "SELECT * FROM TRACKORDER WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND UID IS NULL"; $res_trackorder = pg_query( $hDB_trackinformation, $sql_select_trackorder ); if ( pg_num_rows($res_trackorder) == 1 ) { $toid = pg_fetch_result($res_trackorder,0,'toid'); $remove_str = pg_fetch_result( $res_trackorder, 0,'remove_str'); if ( is_null($remove_str) || empty($remove_str) ) { $new_remove_str = $track_name; } else { $remove_str_ary = explode(":",$remove_str); $remove_str_ary[] = $track_name; $new_remove_str = implode( ":", $remove_str_ary ); } pg_query( $hDB_trackinformation, 'BEGIN' ); $sql_update_trackorder = "UPDATE TRACKORDER SET REMOVE_STR='".pg_escape_string($new_remove_str)."' WHERE TOID=".$toid; $res_update_trackorder = pg_query( $hDB_trackinformation, $sql_update_trackorder ); if ( pg_result_status( $res_update_trackorder ) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT' ); } else { pg_query( $hDB_trackinformation, 'ROLLBACK' ); } } else { show_error_message("Cannot remove track because record does not exist in trackorder table."); } } //******************************** // unremove //******************************** if( preg_match( '/^btn_unremove_([^ ]+)/', $key, $match ) ) { $unremove_track_name = unconvertExceptTrackName($match[1]); $sql_select_trackorder = "SELECT * FROM TRACKORDER WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND UID IS NULL"; $res_trackorder = pg_query( $hDB_trackinformation, $sql_select_trackorder ); if ( pg_num_rows($res_trackorder) == 1 ) { $toid = pg_fetch_result($res_trackorder,0,'toid'); // modify remove_str $remove_str_ary = explode( ":",pg_fetch_result( $res_trackorder, 0,'remove_str') ); foreach ( $remove_str_ary as $i => $remove_track_name ) { if ( $remove_track_name == $unremove_track_name ) { $unremove_pos = $i; break; } } array_splice( $remove_str_ary, $unremove_pos, 1 ); $new_remove_str = implode( ":", $remove_str_ary ); // modify order_str $order_str_ary = explode( ":",pg_fetch_result( $res_trackorder, 0,'order_str') ); foreach ( $order_str_ary as $i => $order_track_name ) { if ( $order_track_name == $unremove_track_name ) { $unremove_pos = $i; break; } } array_splice( $order_str_ary, $unremove_pos, 1 ); $order_str_ary[] = $unremove_track_name; $new_order_str = implode( ":", $order_str_ary ); // execute update pg_query( $hDB_trackinformation, 'BEGIN' ); $sql_update_trackorder = "UPDATE TRACKORDER SET REMOVE_STR='".pg_escape_string($new_remove_str)."', ORDER_STR='".pg_escape_string($new_order_str)."' WHERE TOID=".$toid; $res_update_trackorder = pg_query( $hDB_trackinformation, $sql_update_trackorder ); if ( pg_result_status( $res_update_trackorder ) == PGSQL_COMMAND_OK ) { pg_query( $hDB_trackinformation, 'COMMIT' ); } else { pg_query( $hDB_trackinformation, 'ROLLBACK' ); } } else { show_error_message("Cannot remove track because record does not exist in trackorder table."); } } } } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // // O U T P U T H T M L // ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// print("

Operation of Administrator

"); //*********************************** // displar parameter //*********************************** $sql_select_disparam = "SELECT * FROM DISPARAM"; $res_select_disparam = pg_query( $hDB_trackinformation, $sql_select_disparam ); $disparam = array(); if ( pg_num_rows($res_select_disparam) == 1 ) { $disparam['species'] = pg_fetch_result( $res_select_disparam,0,'species' ); $disparam['revision'] = pg_fetch_result( $res_select_disparam,0,'revision' ); $disparam['target'] = pg_fetch_result( $res_select_disparam,0,'target' ); $disparam['start'] = pg_fetch_result( $res_select_disparam,0,'start_position' ); $disparam['end'] = pg_fetch_result( $res_select_disparam,0,'end_position' ); $disparam['width'] = pg_fetch_result( $res_select_disparam,0,'width' ); } print "

display parameter

species
revision
target
start
end
width

"; print ""; print ""; print(""); print ""; //*********************************** // track list //*********************************** print("

track list

"); // Select Species,Revision print("

"); print(""); print(""); print(""); print(""); print(""); print(""); print(""); // 2005.5.18 add & modify by t.shishiki -------------------------------------------------- print ""; print ""; print(""); print(""); print("

species	"); print ""; #print (""); print("	revision	"); print(""); print("	exhibit	"; print ""; print "

"); //********************* // Make track list //********************* switch ( $exhibit_selected ) { case "All": $sql_track = "SELECT * FROM TRACK WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' ORDER BY TID"; break; case "Public": $sql_track = "SELECT * FROM TRACK WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND EXHIBIT='public' ORDER BY TID"; $sql_trackorder = "SELECT * FROM TRACKORDER WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND UID IS NULL"; break; case "Private": $sql_track = "SELECT * FROM TRACK WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' AND EXHIBIT='private' ORDER BY TID"; break; default: $sql_track = "SELECT * FROM TRACK WHERE SPECIES='$species_selected' AND REVISION='$revision_selected' ORDER BY TID"; break; } $res_track_list = pg_query($hDB_trackinformation, $sql_track); $track_list_hash = array(); for ( $i = 0; $i < pg_num_rows($res_track_list); $i++ ) { $tid = pg_fetch_result($res_track_list, $i, 'tid'); $track_name = pg_fetch_result($res_track_list, $i, 'name'); $track_exhibit = pg_fetch_result($res_track_list, $i, 'exhibit'); $track_user_id = pg_fetch_result($res_track_list, $i, 'uid'); $track_comment =pg_fetch_result($res_track_list, $i, 'comment'); if($track_user_id == '') { $track_user_name = ''; }else { $sql = "SELECT * FROM users WHERE uid=$track_user_id;"; $res_temp = pg_query($hDB_trackinformation, $sql); $track_user_name = pg_escape_string(pg_fetch_result($res_temp, 0, 'name')); } $track = array(); $track['tid'] = $tid; $track['exhibit'] = $track_exhibit; $track['user_id'] = $track_user_id; $track['comment'] = $track_comment; $track['user_name'] = $track_user_name; $track_list_hash[$track_name][] = $track; } //*** ordering & removing *** if ( $exhibit_selected == "Public" ) { $res_trackorder = pg_query( $hDB_trackinformation, $sql_trackorder ); if ( pg_num_rows($res_trackorder) == 1 ) { // exec_ordering $order_str = pg_fetch_result( $res_trackorder,0,'order_str' ); $order_str_ary = explode( ":",$order_str ); $tmp_track_list_hash = array(); foreach ( $order_str_ary as $i => $order_track_name ) { foreach ( $track_list_hash as $track_name => $i ) { if ( $order_track_name == $track_name ) { $tmp_track_list_hash[$track_name] = $i; } } } // exec_removing $remove_str = pg_fetch_result( $res_trackorder,0,'remove_str' ); if ( !is_null($remove_str) || !empty($remove_str) || $remove_str != "" ) { $tmp_2_track_list_hash = array(); $removedtrack_list_hash = array(); $remove_str_ary = explode(":",$remove_str); foreach ( $tmp_track_list_hash as $track_name => $i ) { $f_remove = FALSE; foreach ( $remove_str_ary as $j => $remove_track_name ) { if ( $track_name == $remove_track_name ) { $f_remove = TRUE; break 1; } } if ( $f_remove == TRUE ) { $removedtrack_list_hash[$track_name] = $i; } else if ( $f_remove == FALSE ) { $tmp_2_track_list_hash[$track_name] = $i; } } $tmp_track_list_hash = $tmp_2_track_list_hash; } } $track_list_hash = $tmp_track_list_hash; } print(""); print(""); if ( $exhibit_selected == "All" ) { print ""; } print(""); if ( $exhibit_selected == "All" || $exhibit_selected == "Private" ) { print(""); } if ( $exhibit_selected == "All" ) { print(""); print(""); } print(""); print(""); print(""); foreach ( $track_list_hash as $track_name => $same_name_tracks ) { foreach ( $same_name_tracks as $tracknum => $track ) { $cnvt_track_name = convertExceptTrackName($track_name); print (""); //*** checkbox & Track name *** if ( $exhibit_selected == "All" ) { if ( count($same_name_tracks) == 1 ) { if ( $track['exhibit'] == "public" ) { print ""; print ""; } else if ( $track['exhibit'] == "private" ) { print ""; print ""; } } else if ( count($same_name_tracks) >= 1 ) { $f_public = FALSE; foreach ( $same_name_tracks as $i => $trk ) { if ( $trk['exhibit'] == "public" ) { $f_public = TRUE; } } if ( $f_public == TRUE && $tracknum == 0 ) { print ""; print ""; } if ( $f_public == FALSE && $tracknum == 0 ) { print ""; print ""; } } } else { print ""; } //*** User *** if ( $exhibit_selected == "All" || $exhibit_selected == "Private" ) { print (""); } //*** Public/Private *** if ( $exhibit_selected == "All" ) { print (""); } //*** Selected *** if ( $exhibit_selected == "All" ) { if ( $track['exhibit'] == "public" || count($same_name_tracks) == 1 ) { print (""); } else { print (""); } } //*** Comment *** print (""); //*** Operation *** print ""; print ""; } } print("

Release	Track name	User	Public/Private	Selection	Comment	Operation
	$track_name		$track_name		$track_name		$track_name	$track_name	".$track['user_name']."	".$track['exhibit']."			".$track['comment']."	"; print ""; if ( $exhibit_selected == "Public" ) { print " "; print " "; print " "; if ( is_null($track['user_id']) ) { print " "; } } print " "; print ""; print "

"); print("
"); if ( $exhibit_selected == "All") { print(""); } print(""); print(""); //*************************************************************** // removed track list //*************************************************************** if ( !empty($removedtrack_list_hash) ) { print "

removed track

"; print "

"; print ""; print ""; print(""); print(""); print(""); foreach ( $removedtrack_list_hash as $trackname => $i) { print ""; print ""; print ""; print ""; } print ""; print("

Track name	Comment	Operation
".$trackname."	".$i['comment']."

"); print(""); print(""); print(""); print(""); print "

"; } //*************************************************************** // add track //*************************************************************** print("

add new track

"); print("

"); print(""); print(""); print(""); print ""; print ""; print ""; print ""; print("

species

revision

option parameter

key: value:"; print " "; print "
"; if ( !empty($_SESSION['optparam']) ) { print ""; print ""; $optparam_list = $_SESSION['optparam']; foreach ( $optparam_list as $key => $val ) { print ""; } print "

Selection	Key	Value
	".$key."	".$val."

"; print ""; print " "; print ""; } print "

track URL

"); print("

"); print("
"); print(""); print(""); print(""); print(""); print(""); print("

"); //*************************************************************** // upload new track //*************************************************************** print("

upload new track

Easytrack file

"); print(""); //*************************************************************** // users list //*************************************************************** print("

users list

"); print("

"); print(""); print(""); $sql = "SELECT * FROM USERS"; $res = pg_query( $hDB_trackinformation, $sql ); for ( $i = 0; $i < pg_num_rows($res); $i++ ) { $uid = pg_fetch_result($res,$i,'uid'); $name = pg_fetch_result($res,$i,'name'); $password = pg_fetch_result($res,$i,'password'); $e_mail = pg_fetch_result($res,$i,'e_mail'); $authority = pg_fetch_result($res,$i,'authority'); print ""; if ( $modify_uid == $uid ) { print ""; print ""; print ""; print ""; print ""; } else { print ""; print ""; print ""; } print ""; } print ""; print "

Name	E-mail	Authority	Modify	Delete
$name		"; print ""; print "			$name	$e_mail	$authority

"; print ""; print ""; print "

"; print("

"); print(""); print(""); } else { ?>

Operation of Administrator

display parameter

track list

removed track

add new track

upload new track

users list

Administrator Authentication