$db = new pustaka_db;
$db->query("select * from tb_soal
			left join (select tbjs_kodesoal, count(tbjs_id) jumlah from tb_jawabsoal where tbjs_idjawab = '".$data['idjawab']."' group
            by tbjs_kodesoal) as ab on tbs_kodesoal = tbjs_kodesoal
			left join (select tbs_kodesoal idksoal, count(tbs_kodesoal) as jumsoal from tb_soal where tbs_kodesoal =
            '".$data['md5soal']."' group by tbs_kodesoal) as aa on tbs_kodesoal = idksoal
			where tbs_kodesoal = '".$data['md5soal']."'
			and tbs_idsoal not in (select tbjs_idsoal from tb_jawabsoal where tbjs_idjawab = '".$data['idjawab']."')");
$dds = $db->fetch();
$key = array_rand($dds);
$hasil = $dds[$key];
if($hasil == ""){
	$tk['md5soal'] = $data['md5soal'];
	$tk['idjawab'] = $data['idjawab'];
	$tokenbaru = lib_crypto::encrypt(json_encode($tk));
	header("Location: ".$this->homebase()."tugas/kerjakan/token/".$tokenbaru);
}

$acak = str_shuffle("abcde");
if(file_exists("content/soal/".$hasil['tbs_gambar'])){
	$gbr = "<div class=\"row\"><div class=\"col-md-12\"><img src=\"".$this->homebase()."content/soal/".$hasil['tbs_gambar']."\"
    height=\"300px\" widthss=\"150px\"></div></div>";
}else{
	$gbr = "";
}

$jawab['a'] = lib_crypto::encrypt(json_encode(array("jawabansistem" => strtoupper(substr($acak,0,1)), "jawabaninput" => "A")));
$jawab['b'] = lib_crypto::encrypt(json_encode(array("jawabansistem" => strtoupper(substr($acak,1,1)), "jawabaninput" => "B")));
$jawab['c'] = lib_crypto::encrypt(json_encode(array("jawabansistem" => strtoupper(substr($acak,2,1)), "jawabaninput" => "C")));
$jawab['d'] = lib_crypto::encrypt(json_encode(array("jawabansistem" => strtoupper(substr($acak,3,1)), "jawabaninput" => "D")));
$jawab['e'] = lib_crypto::encrypt(json_encode(array("jawabansistem" => strtoupper(substr($acak,4,1)), "jawabaninput" => "E")));

$tok['md5soal'] = $data['md5soal'];
$tok['idjawab'] = $data['idjawab'];
$tok['idsoal'] = $hasil['tbs_idsoal'];
$tok['jawabanbenar'] = $hasil['tbs_pilihanbenar'];
$newtoken = lib_crypto::encrypt(json_encode($tok));