1<?php
header('Content-Type: text/html; charset=utf-8');
include 'config.php';
include 'opendb.php';
include 'header.php';
include 'checkadmin.php';
mysql_query("SET NAMES 'utf8'");
date_default_timezone_set('Europe/Budapest');
$datetimeori = date("Y-m-d G:i:s");   
$delayeddatetime = strtotime( $datetimeori ) + 600;
$datetime=date("Y-m-d G:i:s",$delayeddatetime);
$nick=$_SESSION['nick'];
?>

<html>
<head>

	<title>Result</title>

</head>


<body>

<center><h3 class="admin">
<br><br>
ezek lettek:
<br><br>

<?php
$movie_id = $_GET["m"];
$book_id = $_GET["b"];
$game_id = $_GET["g"];
$connector_id = $_GET["c"];


?>

<?php
if($movie_id*1>0 && $connector_id*1>0){

$parancs = "SELECT id FROM connected_movies WHERE  connector_id='".$connector_id."'   AND  movie_id='".$movie_id."'"  ;

$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());
$exists=mysql_num_rows($eredmeny);



if($exists==0){

$parancs = "INSERT INTO connected_movies (connector_id, movie_id, nick, datetime) VALUES ('" . $connector_id . "','".$movie_id."','" . $nick . "', '" . $datetimeori . "') ;"      ;

$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());



//filmcim lekerdezese
$parancs = "SELECT * FROM movies WHERE movie_id ='" . $movie_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)) {
	$title2= "".$sor['title'];
	if( $sor['hun_title']!= $sor['eng_title']){
	$title2.= " // ".$sor['hun_title'];
	}
	if($sor['season']>0){
		 $title2.= " [s". $sor['season']."]";	
	}
	$title2.= " (".$sor['year'];
	$title2.= ")";
}

$parancs99 = "SELECT * FROM connectors WHERE id='".$connector_id."'";
$eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());
while ( $sor99 = mysql_fetch_array($eredmeny99)) {
$type=$sor99['type'];
}

//
$text=$title2;


//datetime+nick megk�r�s, CATEGORY megad�s


//admin_logba
$action_id=71;
$object_id=$connector_id;
$object_2_id=$movie_id;

$value_text="�j film: ".$text;

$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 . "\", '" . $datetimeori . "') ;"      ;
//$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());








//print "Lefuttatva: <br>" . $parancs;

$ref = "connectors.php?ct=".$type."&movie_id=".$movie_id."";
$ref = "movie.php?id=".$movie_id."";
print "<br><br><a href='".$ref."'>Nézz�kmeg berakta-e</a>";

echo "<meta http-equiv='Refresh' content='0; URL=".$ref."'>";





}else{

echo "<h3>Ez elvileg m�r bent van, n�d meg m�g egyszer l�gyszi</h3>";
}




/* 
$target_path_base = "pix/poster/";

$target_path = $target_path_base . basename( $_FILES['uploadedfile']['name']); 

print"<h1>".$target_path."</h1>";
copy($_FILES['uploadedfile']['tmp_name'], $target_path);
rename($target_path, $target_path_base."".$id.".jpg" );
 */
print "<br>";



}

if($book_id*1>0 && $connector_id*1>0){

$parancs = "SELECT id FROM connected_books WHERE  connector_id='".$connector_id."'   AND  book_id='".$book_id."'"  ;

$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekrni. A hiba oka: ".mysql_error());
$exists=mysql_num_rows($eredmeny);



if($exists==0){

$parancs = "INSERT INTO connected_books (connector_id, book_id, nick, datetime) VALUES ('" . $connector_id . "','".$book_id."','" . $nick . "', '" . $datetimeori . "') ;"      ;

$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());



//filmcim lekerdezese
$parancs = "SELECT * FROM books WHERE book_id ='" . $book_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)) {
	$title2= "".$sor['title'];
	if( $sor['hun_title']!= $sor['eng_title']){
	$title2.= " // ".$sor['hun_title'];
	}
	$title2.= " (".$sor['year'];
	$title2.= ")";
}

$parancs99 = "SELECT * FROM connectors WHERE id='".$connector_id."'";
$eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());
while ( $sor99 = mysql_fetch_array($eredmeny99)) {
$type=$sor99['type'];
}

//
$text=$title2;


//datetime+nick megk�r�s, CATEGORY megad�s


//admin_logba
$action_id=76;
$object_id=$connector_id;
$object_2_id=$book_id;

$value_text="Új könyv: ".$text;

$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 . "\", '" . $datetimeori . "') ;"      ;
//$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());








//print "Lefuttatva: <br>" . $parancs;
//$ref = "connectors.php?ct=".$type."&game_id=".$game_id."";
$ref = "book.php?id=".$book_id."";
print "<br><br><a href='".$ref."'>BACK</a>";

echo "<meta http-equiv='Refresh' content='0; URL=".$ref."'>";





}else{

echo "<h3>Ez elvileg m�r bent van, n�d meg m�g egyszer l�gyszi</h3>";
}




/* 
$target_path_base = "pix/poster/";

$target_path = $target_path_base . basename( $_FILES['uploadedfile']['name']); 

print"<h1>".$target_path."</h1>";
copy($_FILES['uploadedfile']['tmp_name'], $target_path);
rename($target_path, $target_path_base."".$id.".jpg" );
 */
print "<br>";



}

if($game_id*1>0 && $connector_id*1>0){

$parancs = "SELECT id FROM connected_games WHERE  connector_id='".$connector_id."'   AND  game_id='".$game_id."'"  ;

$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());
$exists=mysql_num_rows($eredmeny);



if($exists==0){

$parancs = "INSERT INTO connected_games (connector_id, game_id, nick, datetime) VALUES ('" . $connector_id . "','".$game_id."','" . $nick . "', '" . $datetimeori . "') ;"      ;

$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());



//filmcim lekerdezese
$parancs = "SELECT * FROM games WHERE game_id ='" . $game_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)) {
	$title2= "".$sor['title'];
	if( $sor['hun_title']!= $sor['eng_title']){
	$title2.= " // ".$sor['hun_title'];
	}
	$title2.= " (".$sor['year'];
	$title2.= ")";
}

$parancs99 = "SELECT * FROM connectors WHERE id='".$connector_id."'";
$eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());
while ( $sor99 = mysql_fetch_array($eredmeny99)) {
$type=$sor99['type'];
}

//
$text=$title2;


//datetime+nick megk�r�s, CATEGORY megad�s


//admin_logba
$action_id=76;
$object_id=$connector_id;
$object_2_id=$game_id;

$value_text="�j j�t�k: ".$text;

$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 . "\", '" . $datetimeori . "') ;"      ;
//$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lek�rni. A hiba oka: ".mysql_error());








//print "Lefuttatva: <br>" . $parancs;
//$ref = "connectors.php?ct=".$type."&game_id=".$game_id."";
$ref = "game.php?id=".$game_id."";
print "<br><br><a href='".$ref."'>BACK</a>";

echo "<meta http-equiv='Refresh' content='0; URL=".$ref."'>";





}else{

echo "<h3>Ez elvileg m�r bent van, n�d meg m�g egyszer l�gyszi</h3>";
}




/* 
$target_path_base = "pix/poster/";

$target_path = $target_path_base . basename( $_FILES['uploadedfile']['name']); 

print"<h1>".$target_path."</h1>";
copy($_FILES['uploadedfile']['tmp_name'], $target_path);
rename($target_path, $target_path_base."".$id.".jpg" );
 */
print "<br>";



}




include 'closedb.php';
?>



</body>

</html>