logged_in){ // echo ""; //} //else{ // $URL="../snug/login.php"; //header ("Location: $URL"); //} include("include/session.php"); if(!$session->logged_in) { $URL="../snug/login.php"; header ("Location: $URL"); } include($_SERVER['DOCUMENT_ROOT']."/SpryAssets/db_con_snug.php"); $tb = "register_conference"; $tb_backup = "register_conference_deleted"; /// connection to database variables //include($_SERVER['DOCUMENT_ROOT']."/SpryAssets/db_con_snug.php"); include($_SERVER['DOCUMENT_ROOT']."/SpryAssets/wordfile.php"); /// connection to database $connection = @mysqli_connect ("$server", "$username", "$password"); $db = @mysqli_select_db ($connection,"$dbname"); $tb = "register_conference"; if($_REQUEST['conf_year']=="") { $current_year_query = "select distinct(conf_year) from ".$tb_backup." order by conf_year desc"; $current_year_result = @mysqli_query($connection,$current_year_query); $current_year_row = @mysqli_fetch_array($current_year_result); if($current_year_row['conf_year']!="") { $conf_year = $current_year_row['conf_year']; } } else { $conf_year = $_REQUEST['conf_year']; } if($_REQUEST['action']=='restore') { $query_restore = "INSERT INTO ".$tb." SELECT d.* FROM ".$tb_backup." d WHERE d.id = '".$_REQUEST['rec_id']."'"; $result = @mysqli_query($connection,$query_restore); $query = "DELETE FROM ".$tb_backup." WHERE id = ".$_REQUEST['rec_id']." LIMIT 1"; $result = @mysqli_query($connection,$query); } ?> SNUG Conference Deleted Records