<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
Security::demand(ADMIN);
$smarty = new AdminSmarty();
$smarty->assign("pagetitle", "proquiz");
// hämta alla MinaQuiz som har användarID 0
$MinaQuiz = MinaQuiz::listAsArray(0);
foreach ($MinaQuiz as $key => $quiz) {
$MinaQuiz[$key]['fragor'] = MinaQuiz::getQuestions($quiz['id']);
}
$smarty->assign("isAgare", true);
$smarty->assign("egensida", "1");
$smarty->assign("proquiz", $MinaQuiz);
$smarty->assign("x", 0);
$smarty->assign("show", false);
$smarty->assign('visa_antal_fragor', 3);
$smarty->display('proquiz.tpl');
public static function listAsArray($medlem, $order_by = "namn ASC")
{
global $db;
$medlem_id = is_int($medlem) ? $medlem : $medlem->getId();
$minaquiz = $db->allValuesAsArray("\tSELECT\n\t\t\t\t\t\t\t\t\t\t\t*\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\tmm_minaquiz\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\tmedlem_id = '" . $medlem_id . "'\n\t\t\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t{$order_by}\n\t\t");
foreach ($minaquiz as $id => $quiz) {
$fragor = MinaQuiz::getQuestions($id);
$minaquiz[$id]['fragor'] = $fragor;
$minaquiz[$id]['antal_fragor'] = count($fragor);
}
return $minaquiz;
}
