SQLCommand("DELETE FROM quests WHERE ID = '$questID' AND Language <> '0'"); echo 'Quest byl smazán!'; } if (array_key_exists('NotComplete', $_GET) and Licence(1)) { $questID = $_GET['ID']; $Database->SQLCommand("UPDATE quests SET Complete = '0' WHERE ID = '$questID'"); echo 'Quest byl vrázen k opravě!'; } if (array_key_exists('vote', $_GET)) { $questID = $_GET['ID']; $vote = $_GET['vote']; $IDuser = $_SESSION['UserID']; if (($vote > 5) OR ($vote < 1)) die ('Spadná známka'); //TODO: if (Licence(0)) die('Hlasovat můžou jenom registrovaní!'); $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM vote WHERE IDuser = '$IDuser' AND IDquest = '$questID'")); if (!$Line) { $Line = mysql_fetch_array($Database->SQLCommand("SELECT Vote,CountVote FROM quests WHERE ID = '$questID'")); $CountVote = $Line['CountVote']+1; $OldVote = $Line['Vote']*$Line['CountVote']; $NewVote = ($OldVote+$vote)/$CountVote; echo $NewVote; $Database->SQLCommand("UPDATE quests SET Vote = '$NewVote', CountVote = '$CountVote' WHERE ID = '$questID'"); $Database->SQLCommand("INSERT INTO `vote` ( `IDquest` , `IDuser` , `vote` ) VALUES ( '$questID', '$IDuser', '$vote');"); echo 'Hlas byl uložen!'; } else echo 'Již jste hlasoval!'; } if (array_key_exists('search', $_GET)) { $Search = $_GET['search']; $sql = "SELECT * FROM `quests`.`quests` WHERE `ID` LIKE '%$Search%' OR `entry` LIKE '%$Search%' OR `Title` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `Details` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `Objectives` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `OfferRewardText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `RequestItemsText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `EndText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `ObjectiveText1` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `ObjectiveText2` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `ObjectiveText3` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `ObjectiveText4` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs OR `Language` LIKE '%$Search%' OR `Vote` LIKE '%$Search%' OR `User` LIKE '%$Search%' OR `complete` LIKE '%$Search%'"; echo ''; $ID = $Database->SQLCommand($sql); while ($Line = mysql_fetch_array($ID)) { echo ''; } echo '

Pořadové číslo	ID questu	Název Questu	Počet hlasů
'.$Line['ID'].'	'.$Line['entry'].'	'.$Line['Title'].'	'.$Line['Vote'].'

'; } ShowFooter(); ?>