require_once('verwaltung/class.php');
$mysql = mysql_class::getInstance();
//$3Data = $mysql->fetch_all("select * from vw_quiz where Gewinner is not null");
?>
$quizs = $mysql->fetch_all('SELECT spender_preis, spender_name, gewinner_name,ausgabe, unix_timestamp(updatetime) as updatetime FROM `quiz` order by spender_wert desc, spender_prio desc' . ((isset($_GET['sqlLimit'])&& is_numeric($_GET['sqlLimit'])) ? (' limit ' . $_GET['sqlLimit']) : ''));
$i=0;
$x=0;
$updatetime=0;
foreach($quizs as $quiz){
if($quiz['updatetime'] > $updatetime){
$updatetime=$quiz['updatetime'];
}
if(empty($quiz['gewinner_name']) || !empty($quiz['ausgabe'])){
$x++;
}
}
foreach($quizs as $quiz){
$i++;
if(empty($quiz['gewinner_name']) || !empty($quiz['ausgabe'])){
if(!isset($_GET['showAll'])){
continue;
}
}
?>
if(!isset($_GET['hideGewinner'])){
?>
}
?>
}
?>
$testC = $mysql->fetch_all('SELECT count(1) as cnt FROM `quiz` where gewinner_name is not null');
if($testC[0]['cnt'] == 0 && !isset($_GET['showAll'])){
//$mysql->array2table($quizData, '100%');
?>