ikan Uploader :
Directory : /home/ubuntu/chalkbank/application/models/
Upload File : |
| Current File : //home/ubuntu/chalkbank/application/models/Qbank_model.php |
<?php
Class Qbank_model extends CI_Model
{
Public function __construct(){
parent::__construct();
$db2 = $this->load->database('readerdb', TRUE);
}
function question_list($limit,$cid='0',$lid='0',$uid='', $level='', $lquid='',$other_cids=''){
$db2 = $this->load->database('readerdb', TRUE);
if($this->input->post('search')){
$search=$this->input->post('search');
$db2->or_where('savsoft_qbank.qid',$search);
$db2->or_like('savsoft_qbank.question',$search);
$db2->or_like('savsoft_qbank.description',$search);
}
if($lid!='0'){
$db2->where('savsoft_qbank.lid',$lid);
}
$admin_flag = 'Y';
$clist = array();
if($cid!='0'){
if($other_cids!=''){
$clist = explode(',',$other_cids);
$clist[] = $cid;
$admin_flag = 'N';
} else {
$clist[] = $cid;
}
$db2->where_in('savsoft_qbank.cid',$clist);
//$db2->where('savsoft_qbank.cid',$cid);
} else {
if($other_cids!=''){
$clist = explode(',',$other_cids);
$admin_flag = 'N';
$db2->where_in('savsoft_qbank.cid',$clist);
}
}
if($uid!='' && $admin_flag=='Y'){
$db2->where('savsoft_qbank.admin_id',$uid);
}
if($level!='' && $level!='0'){
$db2->where('savsoft_qbank.level',$level);
}
if($lquid!=''){
$db2->where('savsoft_qbank.qid<',$lquid);
}
$db2->join('savsoft_category','savsoft_category.cid=savsoft_qbank.cid');
$db2->join('savsoft_level','savsoft_level.lid=savsoft_qbank.lid');
$db2->limit($this->config->item('number_of_rows'),$limit);
$db2->order_by('savsoft_qbank.qid','desc');
$query = $db2->get('savsoft_qbank');
//echo $this->db->last_query(); die;
$results = $query->result_array();
return $results;
}
function rcquestion_list($limit,$cid='0',$lid='0',$uid='', $level=''){
if($this->input->post('search')){
$search=$this->input->post('search');
$this->db->or_where('savsoft_rcqbank.qid',$search);
$this->db->or_like('savsoft_rcqbank.question',$search);
$this->db->or_like('savsoft_rcqbank.description',$search);
}
if($uid!=''){
$this->db->where('savsoft_rcqbank.admin_id',$uid);
}
$this->db->limit($this->config->item('number_of_rows'),$limit);
$this->db->order_by('savsoft_rcqbank.qid','desc');
$query=$this->db->get('savsoft_rcqbank');
//echo $this->db->last_query(); die;
$results = $query->result_array();
return $results;
}
function num_qbank($uid = '', $other_cids=''){
$admin_flag = 'Y';
$clist = array();
if($other_cids!=''){
$clist = explode(',',$other_cids);
$admin_flag = 'N';
$this->db->where_in('savsoft_qbank.cid',$clist);
}
if($uid!='' && $admin_flag=='Y'){
$this->db->where('savsoft_qbank.admin_id',$uid);
}
$this->db->where('savsoft_qbank.cid>0');
$this->db->where('savsoft_qbank.lid>0');
$query = $this->db->get('savsoft_qbank');
$results = $query->num_rows();
return $results;
}
function get_rcquestion($qid){
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('qid',$qid);
$query=$db2->get('savsoft_rcqbank');
$results = $query->row_array();
return $results;
}
function get_question($qid){
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('qid',$qid);
$query=$db2->get('savsoft_qbank');
$results = $query->row_array();
return $results;
}
function get_option($qid){
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('qid',$qid);
$query=$db2->get('savsoft_options');
$results = $query->result_array();
return $results;
}
function remove_rcquestion($qid){
$this->db->where('qid',$qid);
if($this->db->delete('savsoft_rcqbank')){
$this->db->where('rc_qid',$qid);
$this->db->delete('savsoft_qbank');
return true;
}else{
return false;
}
}
function remove_question($qid){
$this->db->where('qid',$qid);
if($this->db->delete('savsoft_qbank')){
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
return true;
}else{
return false;
}
}
function insert_rc_question(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('rc_answer'),
'createdon'=>date('Y-m-d H:i:s'),
'modifiedon'=>date('Y-m-d H:i:s'),
'cid'=>$this->input->post('cid'),
'rc_qid'=>$this->input->post('rc_qid'),
'admin_id'=>$this->input->post('admin_id'),
'lid'=>$this->input->post('lid')
);
$this->db->insert('savsoft_qbank',$userdata);
$qid=$this->db->insert_id();
foreach($this->input->post('option') as $key => $val){
if($this->input->post('score')==$key){
$score=1;
}else{
$score=0;
}
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function insert_question_1(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('multiple_choice_single_answer'),
'createdon'=>date('Y-m-d H:i:s'),
'modifiedon'=>date('Y-m-d H:i:s'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'admin_id'=>$this->input->post('admin_id'),
'lid'=>$this->input->post('lid')
);
if($this->input->post('rc_qid')!=''){
$userdata['rc_qid'] = $this->input->post('rc_qid');
}
$this->db->insert('savsoft_qbank',$userdata);
$qid=$this->db->insert_id();
foreach($this->input->post('option') as $key => $val){
if($this->input->post('score')==$key){
$score=1;
}else{
$score=0;
}
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function insert_question_2(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'admin_id'=>$this->input->post('admin_id'),
'createdon'=>date('Y-m-d H:i:s'),
'modifiedon'=>date('Y-m-d H:i:s'),
'question_type'=>$this->lang->line('multiple_choice_multiple_answer'),
'level'=>$this->input->post('level'),
'cid'=>$this->input->post('cid'),
'lid'=>$this->input->post('lid')
);
$this->db->insert('savsoft_qbank',$userdata);
$qid=$this->db->insert_id();
foreach($this->input->post('option') as $key => $val){
if(in_array($key,$this->input->post('score'))){
$score=(1/count($this->input->post('score')));
}else{
$score=0;
}
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function insert_question_3(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('match_the_column'),
'admin_id'=>$this->input->post('admin_id'),
'cid'=>$this->input->post('cid'),
'createdon'=>date('Y-m-d H:i:s'),
'level'=>$this->input->post('level'),
'modifiedon'=>date('Y-m-d H:i:s'),
'lid'=>$this->input->post('lid')
);
$this->db->insert('savsoft_qbank',$userdata);
$qid=$this->db->insert_id();
foreach($this->input->post('option') as $key => $val){
$score=(1/count($this->input->post('option')));
$userdata=array(
'q_option'=>$val,
'q_option_match'=>$_POST['option2'][$key],
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function insert_question_4(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('short_answer'),
'admin_id'=>$this->input->post('admin_id'),
'createdon'=>date('Y-m-d H:i:s'),
'modifiedon'=>date('Y-m-d H:i:s'),
'level'=>$this->input->post('level'),
'cid'=>$this->input->post('cid'),
'lid'=>$this->input->post('lid')
);
$this->db->insert('savsoft_qbank',$userdata);
$qid=$this->db->insert_id();
foreach($this->input->post('option') as $key => $val){
$score=1;
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function insert_question_5(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('long_answer'),
'admin_id'=>$this->input->post('admin_id'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'createdon'=>date('Y-m-d H:i:s'),
'modifiedon'=>date('Y-m-d H:i:s'),
'lid'=>$this->input->post('lid')
);
$this->db->insert('savsoft_qbank',$userdata);
$qid=$this->db->insert_id();
return true;
}
function insert_question_6(){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>'NA',
'admin_id'=>$this->input->post('admin_id'),
'createdon'=>date('Y-m-d H:i:s'),
'modifiedon'=>date('Y-m-d H:i:s'),
'question_type'=>$this->lang->line('rc_answer')
);
$this->db->insert('savsoft_rcqbank',$userdata);
$qid=$this->db->insert_id();
return $qid;
}
function update_question_1($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'modifiedon'=>date('Y-m-d H:i:s'),
'question_type'=>$this->lang->line('multiple_choice_single_answer'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'lid'=>$this->input->post('lid')
);
if($this->input->post('rc_qid')!=''){
$userdata['rc_qid'] = $this->input->post('rc_qid');
}
$this->db->where('qid',$qid);
$this->db->update('savsoft_qbank',$userdata);
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
foreach($this->input->post('option') as $key => $val){
if($this->input->post('score')==$key){
$score=1;
}else{
$score=0;
}
if($val!=''){
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
}
return true;
}
function update_question_2($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('multiple_choice_multiple_answer'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'lid'=>$this->input->post('lid')
);
$this->db->where('qid',$qid);
$this->db->update('savsoft_qbank',$userdata);
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
foreach($this->input->post('option') as $key => $val){
if(in_array($key,$this->input->post('score'))){
$score=(1/count($this->input->post('score')));
}else{
$score=0;
}
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function update_question_3($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('match_the_column'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'lid'=>$this->input->post('lid')
);
$this->db->where('qid',$qid);
$this->db->update('savsoft_qbank',$userdata);
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
foreach($this->input->post('option') as $key => $val){
$score=(1/count($this->input->post('option')));
$userdata=array(
'q_option'=>$val,
'q_option_match'=>$_POST['option2'][$key],
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function update_question_4($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('short_answer'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'lid'=>$this->input->post('lid')
);
$this->db->where('qid',$qid);
$this->db->update('savsoft_qbank',$userdata);
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
foreach($this->input->post('option') as $key => $val){
$score=1;
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
function update_question_5($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('long_answer'),
'cid'=>$this->input->post('cid'),
'level'=>$this->input->post('level'),
'lid'=>$this->input->post('lid')
);
$this->db->where('qid',$qid);
$this->db->update('savsoft_qbank',$userdata);
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
return true;
}
function update_rcquestion_6($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('rc_answer')
);
$this->db->where('qid',$qid);
$this->db->update('savsoft_rcqbank',$userdata);
return true;
}
function update_question_6($qid){
$userdata=array(
'question'=>$this->input->post('question'),
'description'=>$this->input->post('description'),
'question_type'=>$this->lang->line('rc_answer'),
'rc_qid'=>$this->input->post('rc_qid'),
'level'=>$this->input->post('level'),
'cid'=>$this->input->post('cid'),
'lid'=>$this->input->post('lid')
);
$this->db->where('qid',$qid);
$this->db->update('savsoft_qbank',$userdata);
$this->db->where('qid',$qid);
$this->db->delete('savsoft_options');
foreach($this->input->post('option') as $key => $val)
{
if($this->input->post('score')==$key){
$score=1;
}else{
$score=0;
}
$userdata=array(
'q_option'=>$val,
'qid'=>$qid,
'score'=>$score,
);
$this->db->insert('savsoft_options',$userdata);
}
return true;
}
// category function start
function category_list($uid='', $other_cids=''){
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($uid)){
if($other_cids!=''){
$db2->where(" admin_id = $uid OR cid IN($other_cids) ");
} else {
$db2->where('admin_id',$uid);
}
}
$db2->order_by('cid','desc');
$query=$db2->get('savsoft_category');
$results = $query->result_array();
return $results;
}
// category function start
function category_list_array($uid=''){
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($uid)){
$db2->where('admin_id',$uid);
}
$db2->order_by('cid','desc');
$query=$db2->get('savsoft_category');
$result = array();
foreach($query->result_array() as $val){
$result[$val['cid']] = $val;
}
return $result;
}
function update_category($cid){
$userdata=array(
'category_name'=>$this->input->post('category_name'),
);
$this->db->where('cid',$cid);
if($this->db->update('savsoft_category',$userdata)){
return true;
}else{
return false;
}
}
function remove_category($cid){
$this->db->where('cid',$cid);
if($this->db->delete('savsoft_category')){
return true;
}else{
return false;
}
}
function insert_category(){
$userdata=array(
'category_name'=>$this->input->post('category_name'),
'admin_id'=>$this->input->post('admin_id'),
);
if($this->db->insert('savsoft_category',$userdata)){
return true;
}else{
return false;
}
}
// category function end
// level function start
function level_list($uid='', $cid='', $other_cids=''){
$db2 = $this->load->database('readerdb', TRUE);
$admin_flag = 'Y';
if(!empty($cid)){
$clist = array();
if($other_cids!=''){
$clist = explode(',',$other_cids);
}
$clist[] = $cid;
$db2->where_in('cid',$clist);
} else if($other_cids!='' && empty($cid)) {
$admin_flag = 'N';
$clist = array();
$clist = explode(',',$other_cids);
$db2->where_in('cid',$clist);
}
if(!empty($uid) && $admin_flag=='Y'){
$db2->where('admin_id',$uid);
}
$query=$db2->get('savsoft_level');
$results = $query->result_array();
return $results;
}
// level function start
function level_list_array($tbl_name = 'savsoft_level', $condition){
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($condition)){
foreach($condition as $key=>$val){
if($key=='search') {
$search=strtolower($val);
$db2->like('level_name',$search);
} else {
$db2->where($key,$val);
}
}
}
$db2->order_by('lid','desc');
$query=$db2->get($tbl_name);
//echo $this->db->last_query(); die;
$results = $query->result_array();
return $results;
}
// level function start
function single_level_details($uid='', $lid){
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('admin_id',$uid);
$db2->where('lid',$lid);
$query=$db2->get('savsoft_level');
//echo $this->db->last_query(); die;
$results = $query->row_array();
return $results;
}
function update_level($lid){
$userdata=array(
'level_name'=>$this->input->post('level_name'),
'status'=>$this->input->post('status'),
'cid'=>$this->input->post('cid')
);
$this->db->where('lid',$lid);
if($this->db->update('savsoft_level',$userdata)){
return true;
}else{
return false;
}
}
function remove_level($lid){
$this->db->where('lid',$lid);
if($this->db->delete('savsoft_level')){
return true;
}else{
return false;
}
}
function insert_level(){
$userdata=array(
'cid'=>$this->input->post('cid'),
'level_name'=>$this->input->post('level_name'),
'status'=>$this->input->post('status'),
'admin_id'=>$this->input->post('admin_id')
);
if($this->db->insert('savsoft_level',$userdata)){
return true;
}else{
return false;
}
}
// level function end
function import_question($question,$uid=''){
//echo "<pre>"; print_r($question);exit;
$questioncid=$this->input->post('cid');
$questiondid=$this->input->post('did');
foreach($question as $key => $singlequestion){
//$ques_type=
//echo $ques_type;
if($key != 0){
//echo "<pre>";print_r($singlequestion);
$ques_type= $singlequestion['0'];
$question= str_replace('"','"',$singlequestion['1']);
$question= str_replace("`",''',$question);
$question= str_replace("‘",''',$question);
$question= str_replace("’",''',$question);
$question= str_replace("“",'"',$question);
$question= str_replace("‘",''',$question);
$question= str_replace("’",''',$question);
$question= str_replace(" ",' ',$question);
$description= 'NA';
if($ques_type=="0" || $ques_type==""){
$question_type=$this->lang->line('multiple_choice_single_answer');
}
/*if($ques_type=="1"){
$question_type=$this->lang->line('multiple_choice_multiple_answer');
}
if($ques_type=="2"){
$question_type=$this->lang->line('match_the_column');
}
if($ques_type=="3"){
$question_type=$this->lang->line('short_answer');
}
if($ques_type=="4"){
$question_type=$this->lang->line('long_answer');
}*/
$rc_qid = $singlequestion['2'];
$insert_data = array(
'cid' => $questioncid,
'lid' => $questiondid,
'question' =>$question,
'description' => $description,
'admin_id' => $uid,
'question_type' => $question_type
);
if($rc_qid>0){
$insert_data['rc_qid'] = $rc_qid;
}
if($question<>'') {
if($this->db->insert('savsoft_qbank',$insert_data)){
$qid=$this->db->insert_id();
$optionkeycounter = 4;
if($ques_type=="0" || $ques_type==""){
for($i=1;$i<=10;$i++){
if($singlequestion[$optionkeycounter] != ""){
if($singlequestion['3'] == $i){ $correctoption ='1'; }
else{ $correctoption = 0; }
$insert_options = array(
"qid" =>$qid,
"q_option" => $singlequestion[$optionkeycounter],
"score" => $correctoption
);
$this->db->insert("savsoft_options",$insert_options);
$optionkeycounter++;
}
}
}
//multiple type
if($ques_type=="1"){
$correct_options=explode(",",$singlequestion['3']);
$no_correct=count($correct_options);
$correctoptionm=array();
for($i=1;$i<=10;$i++){
if($singlequestion[$optionkeycounter] != ""){
foreach($correct_options as $valueop){
if($valueop == $i){ $correctoptionm[$i-1] =(1/$no_correct);
break;
}
else{ $correctoptionm[$i-1] = 0; }
}
}
}
print_r($correctoptionm);
for($i=1;$i<=10;$i++){
if($singlequestion[$optionkeycounter] != ""){
$insert_options = array(
"qid" =>$qid,
"q_option" => $singlequestion[$optionkeycounter],
"score" => $correctoptionm[$i-1]
);
$this->db->insert("savsoft_options",$insert_options);
$optionkeycounter++;
}
}
}
//multiple type end
//match Answer
if($ques_type=="2"){
$qotion_match=0;
for($j=1;$j<=10;$j++){
if($singlequestion[$optionkeycounter] != ""){
$qotion_match+=1;
$optionkeycounter++;
}
}
///h
$optionkeycounter=4;
for($i=1;$i<=10;$i++){
if($singlequestion[$optionkeycounter] != ""){
$explode_match=explode('=',$singlequestion[$optionkeycounter]);
$correctoption =1/$qotion_match;
$insert_options = array(
"qid" =>$qid,
"q_option" =>$explode_match[0] ,
"q_option_match" =>$explode_match[1] ,
"score" => $correctoption
);
$this->db->insert("savsoft_options",$insert_options);
$optionkeycounter++;
}
}
}
//end match answer
//short Answer
if($ques_type=="3"){
for($i=1;$i<=1;$i++){
if($singlequestion[$optionkeycounter] != ""){
if($singlequestion['3'] == $i){ $correctoption ='1'; }
$insert_options = array(
"qid" =>$qid,
"q_option" => $singlequestion[$optionkeycounter],
"score" => $correctoption
);
$this->db->insert("savsoft_options",$insert_options);
$optionkeycounter++;
}
}
}
//end Short answer
} //
}
}
}
}
}
?>
Kontol Shell Bypass