include("../person/config/conf.php"); include("../person/config/config.php"); include("../person/logincheck.php"); $leg_num=$_GET['Id']; conn_web_db(); session_start(); $connectedvid = $_SESSION['Id']; if($connectedvid=="") { $connectedvid = 1; } // CONNEXION MYSQL $db_link = mysql_connect($sql_serveur,$sql_user,$sql_passwd); if(!$db_link) {echo "No connected to $sql_bdd on the server $sql_server"; exit;} $requete=mysql_db_query($sql_bdd,"select * from user_divawards where Aw_Id=\"$leg_num\"",$db_link) or die(mysql_error()); if(mysql_num_rows($requete)==0) { header("Location:noawards.php?Id=$leg_num"); exit; } $Aw_Name=mysql_result($requete,0,"Aw_Name"); $Aw_Vid=mysql_result($requete,0,"Aw_Vid"); $person2=mysql_db_query($sql_bdd,"select Pers_First_Name, Pers_Last_Name from user_data where Pers_Id=\"$Aw_Vid\"",$db_link) or die(mysql_error()); $person2b = mysql_fetch_array($person2); $name_2 = $person2b[Pers_Last_Name]; $surname_2 = $person2b[Pers_First_Name]; $person3=mysql_db_query($sql_bdd,"select name from divawards_list where letter=\"$Aw_Name\"",$db_link) or die(mysql_error()); $person3b = mysql_fetch_array($person3); $name_leg = $person3b[name]; include("staff.php"); if($Func_staff_PRE==1 OR $Func_staff_DIR==1 OR $Func_staff_MD==1) { } else { mysql_close($db_link); header("Location:http://www.ivao.org/noaccess.php"); exit; } $delete_aw=mysql_db_query($sql_bdd,"DELETE FROM user_divawards WHERE Aw_Id=\"$leg_num\"",$db_link) or die(mysql_error()); mysql_close($db_link); ?>
Division Awards Delete
|