SQLCommand("UPDATE czquests SET state = '1' WHERE entry = '$entry'");
$Database->SQLCommand("UPDATE czquests SET state = '2' WHERE user= '$User' AND entry = '$entry'");
Echo 'Quest byl zkontrolován';
}
if ((array_key_exists('save', $_GET)) or (array_key_exists('End', $_GET)) or (array_key_exists('Repair', $_GET))) {
if (array_key_exists('End', $_GET))
$complete = 1;
else
$complete = 0;
if (array_key_exists('Repair', $_GET))
$complete = 1;
$entry = mysql_escape_string($_GET['entry']);
$Title = mysql_escape_string($_GET['Title']);
$Details = mysql_escape_string($_GET['Details']);
$Objectives = mysql_escape_string($_GET['Objectives']);
$OfferRewardText = mysql_escape_string($_GET['OfferRewardText']);
$RequestItemsText = mysql_escape_string($_GET['RequestItemsText']);
$User = mysql_escape_string($_GET['user']);
if (array_key_exists('Repair', $_GET)) {
$User = mysql_escape_string($_GET['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 czquests Where user='$User' AND entry = '$entry'"));
if (!$Line) {
$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'");
} else {
$Database->SQLCommand("UPDATE czquests SET complete = '$complete', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry' AND user='$User'");
}
if ($complete == 1)
echo 'Quest: '.$entry.' uložen, v blízké době bude zkontrolován a vložen na server.!
';
if ($complete == 0)
echo 'Quest: '.$entry.' uložen, můžete na něm pozděj pracovat!
';
++$entry;
echo 'Překládat: ['.$entry.'] ';
//nastavení hodnoty 1 pro updatování statistiky
$Database->SQLCommand("UPDATE var SET Value = '1' WHERE Name = 'UpdateStatistic'");
$Database->Disconnect();
}
?>