";
$parancs = "DELETE FROM movie_locations WHERE movie_id='" . $movie_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 movie_id, hun_title, title, year, season FROM movies WHERE movie_id ='" . $movie_id."' " ;
$eredmeny3 = mysql_query($parancs3, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$adminmovietext=""; //adminloghoz;
while ( $sor = mysql_fetch_array($eredmeny3)) {
$adminmovietext.=$sor['title'];
$adminmovietext.=" // ".$sor['hun_title'];
if ($sor['season']>0){
$adminmovietext.=" [s". $sor['season']."]";
}
$adminmovietext.=" (". $sor['year'].")";
}
date_default_timezone_set('Europe/Budapest');
$datetime = date("y-m-d G:i:s");
$action_id=61;
$object_id=$movie_id;
$object_2_id;
$value_text="Helyszín törlése: ".$locname." || Erről a filmről: ".$adminmovietext;
$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 
Vissza a filmhez"; $ref="movie.php?id=".$movie_id; echo ""; include 'closedb.php'; ?>