";
$parancs = "DELETE FROM reviews WHERE rev_id='" . $rev_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."
";
}
/*
$parancs = "DELETE FROM fresh WHERE nick='" . $nick."' AND datetime='".$datetime."' AND category='17'" ;
//$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if ($_SESSION['role'] == 'admin'){
print $parancs."
";
}
print "
".$txt["last_seen_deleted_successfully"]." 
".$txt["last_seen_deleted_successfully"]."
".$txt["what_did_i_see_last"].""; $ref="lastbooks.php?user=".$nick; echo ""; */ if($review_type=="movie"){ $parancs = "SELECT hun_title, title, year, season FROM movies WHERE movie_id =" . $review_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $title1= $sor['title']; $hun_title= $sor['hun_title']; $year= $sor['year']; $season= $sor['season']; } } if($review_type=="person"){ $parancs = "SELECT name FROM persons WHERE person_id =" . $review_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $title1= $sor['name']; } } if($review_type=="book"){ $parancs = "SELECT hun_title, title, year FROM books WHERE book_id =" . $review_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $title1= $sor['title']; $hun_title= $sor['hun_title']; $year= $sor['year']; } } if($review_type=="tag"){ $parancs = "SELECT hun_tag_name FROM tags WHERE tag_id =" . $review_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $title1 = $sor['hun_tag_name']; } } if($review_type=="genre"){ $parancs = "SELECT hun_genre_name FROM genres WHERE genre_id =" . $review_id ; $eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error()); while ( $sor = mysql_fetch_array($eredmeny)) { $title1= $sor['hun_genre_name']; } } $action_id=810; switch($review_type){ case "movie": $action_id=811; break; case "book": $action_id=812; break; case "tag": $action_id=813; break; case "genre": $action_id=814; break; default: $action_id=810; } $admintext=$title1; if($hun_title!=$title1 && strlen($hun_title)>0){ $admintext.=" // ".$hun_title; } if(strlen($year)>0){ $admintext.=" (".$year.")"; } if($season>0){ $admintext.=" [s".$season."]"; } date_default_timezone_set('Europe/Budapest'); $datetime = date("y-m-d G:i:s"); //$action_id=50; $object_id=$review_id; $object_2_id=$review_id; $value_text="Cikk törlése: ".$title." || Innen: ".$admintext." (".$review_type.")"; $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 "
".$txt["done"]."