<?php

  include('includes/global.php');

  if (array_key_exists('entry', $_POST)) {
    
    $entry = mysql_escape_string($_POST['entry']);  
    $Title = mysql_escape_string($_POST['Title']);  
    $Details = mysql_escape_string($_POST['Details']);
    $Objectives = mysql_escape_string($_POST['Objectives']);
    $OfferRewardText = mysql_escape_string($_POST['OfferRewardText']);
    $RequestItemsText = mysql_escape_string($_POST['RequestItemsText']);
    $EndText = mysql_escape_string($_POST['EndText']);
    $ObjectiveText1 = mysql_escape_string($_POST['ObjectiveText1']);
    $ObjectiveText2 = mysql_escape_string($_POST['ObjectiveText2']);
    $ObjectiveText3 = mysql_escape_string($_POST['ObjectiveText3']);
    $ObjectiveText4 = mysql_escape_string($_POST['ObjectiveText4']);

    $UserID = mysql_escape_string($_SESSION['UserID']);
    $QuestID = mysql_escape_string($_POST['ID']);
    $Language = mysql_escape_string($_POST['Language']);
    if (array_key_exists('End', $_POST))
      $complete = 1;
    else 
      $complete = 0;
    
    $Line = mysql_fetch_array($Database->SQLCommand("SELECT user FROM quests Where ID = '$QuestID'"));
    if (array_key_exists('Repair', $_POST)) 
      $UserID = $Line['user'];
      
      
  /*  if (array_key_exists('Repair', $_POST)) {
      $User = mysql_escape_string($_POST['UserRepair']); 
      echo 'Opraveno...'.$User;
    }  */
 //   echo $User;
    if (($Title == '') AND ($complete == 1))
      die('Musite zadat název Q');
    
    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests Where user='$UserID' AND entry = '$entry'"));
    if (!$Line) {
    
      $Database->SQLCommand("INSERT INTO `quests` (`entry` , `Title` , `Details` , `Objectives` , `OfferRewardText` , `RequestItemsText` , `EndText` , `ObjectiveText1` , `ObjectiveText2` , `ObjectiveText3` , `ObjectiveText4` , `Language` , `User` , `complete` )
      VALUES('$entry','$Title','$Details','$Objectives','$OfferRewardText','$RequestItemsText','$EndText','$ObjectiveText1','$ObjectiveText2','$ObjectiveText3','$ObjectiveText4','$Language','$UserID','$complete')");
    //  $Database->SQLCommand("INSERT INTO czquests VALUES('$entry','$Title','$Details','$Objectives','$OfferRewardText','$RequestItemsText','1','$User','$complete')");      
    //  $Database->SQLCommand("UPDATE ajquests SET state = '1' WHERE entry = '$entry'");      
      echo 'Quest: '.$entry.' uložen!<br />';
    } else {
      $sql = "UPDATE quests SET complete = '$complete', Title = '$Title',
       Details = '$Details', Objectives = '$Objectives',
       OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText',
       EndText = '$EndText', ObjectiveText1 = '$ObjectiveText1', ObjectiveText2 = '$ObjectiveText2',
       ObjectiveText3 = '$ObjectiveText3', ObjectiveText4 = '$ObjectiveText4', Language = '$Language' WHERE  user='$UserID' AND entry = '$entry'";
      $Database->SQLCommand($sql);
    //  echo $sql.'<br />';      
      echo 'Změny v Questu: '.$entry.' uloženy!<br />';
    }
    

    ++$QuestID;
    echo 'Překládat: <a href="Form.php?ID='.$QuestID.'">Následující</a> ';
      
  }
          
  ShowFooter();      
?>
