ikan Uploader :
Directory : /home/ubuntu/chalkbank/application/models/
Upload File : |
| Current File : //home/ubuntu/chalkbank/application/models/Advancesetting_model.php |
<?php
Class Advancesetting_model extends CI_Model
{
Public function __construct(){
parent::__construct();
$db2 = $this->load->database('readerdb', TRUE);
}
function module_list($uid = ''){
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($uid)){
$db2->where('admin_id',$uid);
}
$db2->order_by('mid','desc');
$query=$db2->get('savsoft_module');
//echo $db2->last_query(); die;
return $query->result_array();
}
function result_list($limit,$status='0', $admin_id = ''){
$db2 = $this->load->database('readerdb', TRUE);
$result_open=$this->lang->line('open');
$logged_in=$this->session->userdata('logged_in');
$uid=$logged_in['uid'];
if($this->input->post('search')){
$search=$this->input->post('search');
$db2->or_where('savsoft_users.email',$search);
$db2->or_where('savsoft_users.first_name',$search);
$db2->or_where('savsoft_users.last_name',$search);
$db2->or_where('savsoft_users.contact_no',$search);
$db2->or_where('savsoft_result.rid',$search);
$db2->or_where('savsoft_quiz.quiz_name',$search);
}else{
$db2->where('savsoft_result.result_status !=',$result_open);
}
if($logged_in['su']=='0'){
$db2->where('savsoft_result.uid',$uid);
}
if($status !='0'){
$db2->where('savsoft_result.result_status',$status);
}
if($admin_id !=''){
$db2->where('savsoft_users.admin_id',$admin_id);
}
$db2->limit($this->config->item('number_of_rows'),$limit);
$db2->order_by('rid','desc');
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query=$db2->get('savsoft_result');
return $query->result_array();
}
function insert_module(){
$userdata=array(
'module_name'=>$this->input->post('module_name'),
'module_slug'=>$this->input->post('module_slug'),
'admin_id'=>$this->input->post('admin_id'),
);
if($this->db->insert('savsoft_module',$userdata)){
return true;
}else{
return false;
}
}
function update_module($mid){
$userdata=array();
if($this->input->post('module_name')){
$userdata['module_name']=$this->input->post('module_name');
}
if($this->input->post('module_slug')){
$userdata['module_slug']=$this->input->post('module_slug');
}
$this->db->where('mid',$mid);
if($this->db->update('savsoft_module',$userdata)){
return true;
}else{
return false;
}
}
function remove_module($mid){
$this->db->where('mid',$mid);
if($this->db->delete('savsoft_module')){
return true;
}else{
return false;
}
}
function quiz_list(){
$db2 = $this->load->database('readerdb', TRUE);
$db2->order_by('quid','desc');
$query=$db2->get('savsoft_quiz');
return $query->result_array();
}
function remove_result($rid){
$this->db->where('savsoft_result.rid',$rid);
if($this->db->delete('savsoft_result')){
$this->db->where('rid',$rid);
$this->db->delete('savsoft_answers');
return true;
}else{
return false;
}
}
function generate_report($quid,$gid, $admin_id=''){
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
$uid=$logged_in['uid'];
$date1=$this->input->post('date1');
$date2=$this->input->post('date2');
if($quid != '0'){
$db2->where('savsoft_result.quid',$quid);
}
if($admin_id != ''){
$db2->where('savsoft_users.admin_id',$admin_id);
}
if($gid != '0'){
$db2->where('savsoft_users.gid',$gid);
}
if($date1 != ''){
$db2->where('savsoft_result.start_time >=',strtotime($date1));
}
if($date2 != ''){
$db2->where('savsoft_result.start_time <=',strtotime($date2));
}
$db2->order_by('rid','desc');
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_group','savsoft_group.gid=savsoft_users.gid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query=$db2->get('savsoft_result');
return $query->result_array();
}
function get_result($rid){
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
$uid=$logged_in['uid'];
if($logged_in['su']=='0'){
$db2->where('savsoft_result.uid',$uid);
}
$db2->where('savsoft_result.rid',$rid);
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_group','savsoft_group.gid=savsoft_users.gid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query=$db2->get('savsoft_result');
return $query->row_array();
}
function last_ten_result($quid){
$db2 = $this->load->database('readerdb', TRUE);
$db2->order_by('percentage_obtained','desc');
$db2->limit(10);
$db2->where('savsoft_result.quid',$quid);
$db2->join('savsoft_users','savsoft_users.uid=savsoft_result.uid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_result.quid');
$query=$db2->get('savsoft_result');
return $query->result_array();
}
function get_percentile($quid,$uid,$score)
{
$db2 = $this->load->database('readerdb', TRUE);
$logged_in =$this->session->userdata('logged_in');
$gid= $logged_in['gid'];
$res=array();
$db2->where("savsoft_result.quid",$quid);
//$db2->group_by("savsoft_result.uid");
$db2->order_by("savsoft_result.score_obtained",'DESC');
$query = $this -> db -> get('savsoft_result');
$res[0]=$query -> num_rows();
$db2->where("savsoft_result.quid",$quid);
$db2->where("savsoft_result.uid !=",$uid);
if($score!=NULL){
$db2->where("savsoft_result.score_obtained <=",$score);
}
//$db2->group_by("savsoft_result.uid");
$db2->order_by("savsoft_result.score_obtained",'DESC');
$querys = $this -> db -> get('savsoft_result');
//echo $db2->last_query(); die;
$res[1]=$querys -> num_rows();
return $res;
}
}
?>
Kontol Shell Bypass