function delQ()
 {
     //pr($_POST);
     $myid = 0;
     $qid = addslashes($_POST['qid']);
     $q = new QuizQuestion();
     if ($qid != "" && $qid != 0) {
         $q->getByID($qid);
         $myid = $q->qid;
     }
     $json = array();
     $json['bool'] = 0;
     $json['aktif'] = 0;
     $json['cnt'] = 0;
     //cek apa miliknya
     $ul = new QuizUlangan();
     $ul->getByID(addslashes($_POST['ul_id']));
     //pr($ul);
     if ($ul->ulangan_creator_id != Account::getMyID()) {
         die('not allowed');
     }
     $scc = $q->delete($qid);
     //echo "Sukses save question : ".$scc." \n<br>";
     if ($scc) {
         if ($myid == 0) {
             $myid = $scc;
         }
         //echo "Sukses question ID : ".$myid." \n<br>";
         //echo "Penyimpanan Sukses";
         $json['bool'] = 1;
         $a = new QuizAnswer();
         $arrAns = $a->getWhere("answer_qid = '{$myid}'");
         foreach ($arrAns as $n) {
             $a->delete($n->answer_id);
         }
         //cek apa jumlahnya sdh 10, kalo 10 aktif
         $cnt = $q->getJumlah("q_ulangan_id = '{$ul->ulangan_id}' AND q_aktif = 1");
         $json['cnt'] = $cnt;
         if ($cnt >= 10) {
             $json['aktif'] = 1;
             $ul->ulangan_aktif = 1;
             $ul->save();
         } else {
             $json['aktif'] = 0;
             $ul->ulangan_aktif = 0;
             $ul->save();
         }
     }
     echo json_encode($json);
     //echo "end";
     exit;
 }
 public static function submit_ul()
 {
     if ($_POST['judul_ulangan'] == "" || $_POST['ulangan_file'] == "" || $_POST['deskripsi_ulangan'] == "" || !Auth::isLogged()) {
         die('no id');
     }
     $ul = new QuizUlangan();
     if ($_GET['ups']) {
         if (!isset($_POST['ul_id'])) {
             die('no id');
         } else {
             $ul->getByID(addslashes($_POST['ul_id']));
             if ($ul->ulangan_creator_id != Account::getMyID()) {
                 die('not allowed');
             }
             $ul->load = 1;
         }
     }
     $json['bool'] = 0;
     $ul->ulangan_level_id = 0;
     $ul->ulangan_aktif = 0;
     $ul->ulangan_name = addslashes($_POST['judul_ulangan']);
     $ul->ulangan_image = addslashes($_POST['ulangan_file']);
     $ul->ulangan_descr = addslashes($_POST['deskripsi_ulangan']);
     $ul->ulangan_fb_image = addslashes($_POST['ulangan_file']);
     $ul->ulangan_creator_id = Account::getMyID();
     $ul->ulangan_jumlah_soal = 10;
     $scc = $ul->save();
     if ($scc) {
         $json['bool'] = 1;
         $json['ul_id'] = $scc;
     }
     echo json_encode($json);
     exit;
 }
 public function hitung($args)
 {
     //pr($_POST);
     $jwb = $_POST['jwb'];
     $qid = $_POST['qid'];
     if (!isset($qid)) {
         die("No ID");
     }
     $ul = new QuizUlangan();
     $ul->getByID($qid);
     //update number
     $ul->ulangan_finished = $ul->ulangan_finished + 1;
     $ul->ulangan_update_date = leap_mysqldate();
     $ul->save();
     // user gen
     $acc = new Account();
     $ucreate = 0;
     if ($ul->ulangan_creator_id != 0) {
         $ucreate = 1;
         $acc->getByID($ul->ulangan_creator_id);
     }
     $ucreate_text = "Seberapa Indonesiakah Anda";
     //campur badge
     if ($ucreate) {
         $ul->ulangan_badge_1 = $ul->ulangan_image;
         $ul->ulangan_badge_2 = $ul->ulangan_image;
         $ul->ulangan_badge_3 = $ul->ulangan_image;
         $ul->ulangan_badge_4 = $ul->ulangan_image;
         $ul->ulangan_badge_5 = $ul->ulangan_image;
         $ucreate_text_title = $ul->ulangan_name;
         $ucreate_text = $acc->admin_name . " membuat ujian '" . $ul->ulangan_name . "' untuk INDONESIA. Berani terima tantangan dia?!?";
         $ul->ulangan_desc_1 = $ucreate_text;
         $ul->ulangan_desc_2 = $ucreate_text;
         $ul->ulangan_desc_3 = $ucreate_text;
         $ul->ulangan_desc_4 = $ucreate_text;
         $ul->ulangan_desc_5 = $ucreate_text;
         $ul->ulangan_descr = $ucreate_text;
     }
     $q = new QuizQuestion();
     $arrQ = $q->getWhere("q_ulangan_id = '{$ul->ulangan_id}' AND q_aktif = 1");
     //pr($arrQ);
     $jumlah_question = $ul->ulangan_jumlah_soal;
     foreach ($arrQ as $q) {
         $qs[$q->qid] = $q;
     }
     $point = 0;
     foreach ($jwb as $o) {
         $active = $qs[$o['qid']];
         if ($active->q_correct_answer_id == $o['aid']) {
             $point++;
         }
         //echo $o['qid']." jwb ".$o['aid']."<br>";
     }
     //pilah poin ke badge
     if ($point == 0) {
         $json['badge'] = _BPATH . _PHOTOURL . "thumbnail/" . $ul->ulangan_badge_1;
     }
     if ($point > 0 && $point < 6) {
         $json['badge'] = _BPATH . _PHOTOURL . "thumbnail/" . $ul->ulangan_badge_2;
     }
     if ($point > 5 && $point < 8) {
         $json['badge'] = _BPATH . _PHOTOURL . "thumbnail/" . $ul->ulangan_badge_3;
     }
     if ($point > 7 && $point < 10) {
         $json['badge'] = _BPATH . _PHOTOURL . "thumbnail/" . $ul->ulangan_badge_4;
     }
     if ($point == 10) {
         $json['badge'] = _BPATH . _PHOTOURL . "thumbnail/" . $ul->ulangan_badge_5;
     }
     $json['points'] = $point;
     $json['saved'] = 0;
     $json['naik_level'] = 0;
     $json['total_point'] = -1;
     $qp = new QuizPoints();
     if (Auth::isLogged()) {
         $pid = $qid . "_" . Account::getMyID();
         $qp->getByID($pid);
         if ($qp->points_id == "") {
             $qp->load = 0;
         }
         $qp->points_id = $pid;
         $qp->points_acc_id = Account::getMyID();
         $qp->points_ul_id = $qid;
         $qp->points_update = leap_mysqldate();
         if ($qp->points_nilai < $point) {
             $qp->points_nilai = $point;
         }
         $json['saved'] = $qp->save();
         $pointLama = QuizPoints::myPoints();
         $lvl_lama = floor($pointLama / 36);
         //update sessions points
         $qp->getPoints();
         $pointBaru = QuizPoints::myPoints();
         $lvl_baru = floor($pointBaru / 36);
         if ($lvl_baru > $lvl_lama && $pointLama > 0) {
             $json['naik_level'] = 1;
         }
         $json['total_point'] = $pointBaru;
     } else {
         if (!isset($_SESSION['game']['unsaved'])) {
             $_SESSION['game']['unsaved'] = array();
         }
         $_SESSION['game']['unsaved'][] = array($qid, $point);
     }
     echo json_encode($json);
     exit;
 }