";
$parancs = "DELETE FROM book_locations WHERE book_id='" . $book_id."' AND location_id='".$location_id."' " ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());
if ($_SESSION['role'] == 'admin'){
print $parancs."
";
}
//helyszin lek�rdez�se
$parancs4 = "SELECT hun_name FROM locations WHERE id ='" . $location_id."' " ;
$eredmeny4 = mysql_query($parancs4, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$tagtext="";
while ( $sor = mysql_fetch_array($eredmeny4)) {
$locname=$sor['hun_name'];
}
$parancs3 = "SELECT book_id, hun_title, title, year FROM books WHERE book_id ='" . $book_id."' " ;
$eredmeny3 = mysql_query($parancs3, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$adminbooktext=""; //adminloghoz;
while ( $sor = mysql_fetch_array($eredmeny3)) {
$adminbooktext.=$sor['title'];
$adminbooktext.=" // ".$sor['hun_title'];
if ($sor['season']>0){
$adminbooktext.=" [s". $sor['season']."]";
}
$adminbooktext.=" (". $sor['year'].")";
}
date_default_timezone_set('Europe/Budapest');
$datetime = date("y-m-d G:i:s");
$action_id=62;
$object_id=$book_id;
$object_2_id;
$value_text="Helyszín törlése: ".$locname." || Erről a játékról: ".$adminbooktext;
$parancs = "INSERT INTO admin_log (nick, action_id, object_id, object_2_id, value, datetime) VALUES ('".$_SESSION['nick']."', '" . $action_id . "', '" . $object_id . "','" . $object_2_id . "', \"" . $value_text . "\", '" . $datetime . "') ;" ;
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
print "
Helyszín sikeresen törölve 
".$txt["back_to_the_book"].""; $ref="book.php?id=".$book_id; echo ""; include 'closedb.php'; ?>