SQLCommand("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM
quests WHERE quests.Language = '1' AND quests.Complete = '1' order by 2");
echo '
| Pořadové číslo | ID questu | Název Questu | Uživatel | Známka | Počet hlasování |
|---|
';
while ($Line = mysql_fetch_array($ID)) {
echo '| '.$Line['ID'].' |
'.$Line['entry'].' |
'.$Line['Title'].' |
'.$Line['User'].' |
'.$Line['Vote'].' |
'.$Line['CountVote'].' |
';
}
echo '
';
} else {
if(array_key_exists('limitx', $_GET)) {
$limitx = mysql_escape_string($_GET['limitx']);
$limity = mysql_escape_string($_GET['limity']);
$ID = $Database->SQLCommand("SELECT * FROM quests WHERE Language = '0' LIMIT $limitx,$limity");
// $ID = $Database->SQLCommand("SELECT quests.entry FROM quests WHERE Language = '0' AND quests.entry NOT IN
// (SELECT quests.entry FROM quests WHERE quests.Language = '1' AND state = '2') LIMIT $limitx,$limity");
while ($Line = mysql_fetch_array($ID)) {
$LineTranslate = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language <> 0 AND entry = '".$Line['entry']."'"));
if (!$LineTranslate)
echo '['.$Line['entry'].'] - '.$Line['Title'].'
'; //.$Line['Title']
}
} else {
if(array_key_exists('mydevelop', $_GET) and Licence(0)) {
echo '
| Pořadové číslo | ID questu | Název Questu |
|---|
';
$ID = $Database->SQLCommand("SELECT * FROM quests Where User='".$_SESSION['UserID']."' AND complete = '0' order by 1 ");
while ($Line = mysql_fetch_array($ID)) {
echo '| '.$Line['ID'].' |
'.$Line['entry'].' |
'.$Line['Title'].' |
';
}
echo '
';
} else {
if(array_key_exists('my', $_GET) and Licence(0)) {
echo '
| Pořadové číslo | ID questu | Název Questu | Známka |
|---|
';
$ID = $Database->SQLCommand("SELECT * FROM quests Where User='".$_SESSION['UserID']."' order by 1 ");
while ($Line = mysql_fetch_array($ID)) {
echo '| '.$Line['ID'].' |
'.$Line['entry'].' |
'.$Line['Title'].' |
'.$Line['Vote'].' |
';
}
echo '
';
} else {
}
}
}
if(array_key_exists('selection', $_GET)) {
for ($i=0; $i<30; ++$i) {
$limity = 200;
$limitx = $i*$limity;
$Under = $limitx+$limity;
echo ''.$limitx.' - '.$Under.'
';
}
echo 'Zbytek
';
// echo '3500-4000
';
}
}
ShowFooter();
?>