ikan Uploader :
Directory : /home/ubuntu/chalkbank/application/models/
Upload File : |
| Current File : //home/ubuntu/chalkbank/application/models/Leaderboard_model.php |
<?php
Class Leaderboard_model extends CI_Model
{
Public function __construct(){
parent::__construct();
$db2 = $this->load->database('readerdb', TRUE);
}
function leaderboard_list($limit, $admin_id = '', $quid='')
{
$db2 = $this->load->database('readerdb', TRUE);
$result_open=$this->lang->line('open');
$logged_in=$this->session->userdata('logged_in');
$uid=$logged_in['uid'];
$db2->select('savsoft_leaderboard.uid,savsoft_leaderboard.rid,savsoft_leaderboard.quid,savsoft_leaderboard.createdon, savsoft_leaderboard.percentage_obtained, savsoft_leaderboard.total_time,savsoft_users.first_name, savsoft_users.last_name,savsoft_users.profie_image,savsoft_users.email,savsoft_users.user_email,savsoft_users.su,savsoft_quiz.quiz_name');
if($this->input->post('search')){
$search=$this->input->post('search');
$db2->or_where('savsoft_users.first_name',$search);
$db2->or_where('savsoft_users.last_name',$search);
$db2->or_where('savsoft_leaderboard.rid',$search);
$db2->or_where('savsoft_quiz.quiz_name',$search);
}
if($logged_in['su']=='0'){
$gid=$logged_in['gid'];
$where="FIND_IN_SET('".$gid."', savsoft_quiz.gids)";
//$db2->where($where);
}
//if($this->input->post('fquid')){
$db2->where('savsoft_leaderboard.quid',$this->input->post('fquid'));
//}
if($admin_id !=''){
//$where = "(savsoft_users.admin_id = $admin_id OR savsoft_quiz_registration.admin_id=$admin_id)";
$where = "(savsoft_quiz.admin_id = $admin_id )";
$db2->where($where);
}
//$db2->limit($this->config->item('number_of_rows'),$limit);
$db2->order_by('percentage_obtained','desc');
$db2->order_by('total_time','asc');
$db2->join('savsoft_users','savsoft_users.uid=savsoft_leaderboard.uid');
//$db2->join('savsoft_quiz_registration','savsoft_quiz_registration.uid=savsoft_leaderboard.uid', 'left');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_leaderboard.quid');
$query=$db2->get('savsoft_leaderboard');
//echo $db2->last_query(); die;
return $query->result_array();
}
function quiz_list($admin_id = '', $ex_gid = ''){
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
if($admin_id>0){
$db2->where('savsoft_quiz.admin_id',$admin_id);
}
if($logged_in['su']=='0'){
$gid=$logged_in['gid'];
if(!empty($ex_gid)){
$oldgArray[] = $gid;
$records = array_merge($ex_gid,$oldgArray);
$whrQcon = "(";
if(is_array($records)){
$idx = 0;
foreach($records as $r){
$whrQcon = $whrQcon . 'savsoft_quiz.gids like concat("%'. $r .'%")' ;
if($idx + 1 < count($records)){
$whrQcon = $whrQcon . " OR ";
}
$idx = $idx + 1;
}
$whrQcon = $whrQcon . " )";
}
$db2->where($whrQcon);
} else {
$where="FIND_IN_SET('".$gid."', savsoft_quiz.gids)";
$db2->where($where);
}
}
$db2->where('savsoft_quiz.display_leaderboard','1');
$db2->order_by('quid','desc');
$query=$db2->get('savsoft_quiz');
return $query->result_array();
}
function remove_result($rid){
$this->db->where('savsoft_leaderboard.rid',$rid);
if($this->db->delete('savsoft_leaderboard')){
$this->db->where('rid',$rid);
$this->db->delete('savsoft_answers');
return true;
}else{
return false;
}
}
function quiz_qlist($limit, $list_uid='', $ex_gid=''){
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
if($logged_in['su']=='0'){
$gid=$logged_in['gid'];
if(!empty($ex_gid)){
$oldgArray[] = $gid;
$records = array_merge($ex_gid,$oldgArray);
$whrQcon = "(";
if(is_array($records)){
$idx = 0;
foreach($records as $r){
$whrQcon = $whrQcon . 'gids like concat("%'. $r .'%")' ;
if($idx + 1 < count($records)){
$whrQcon = $whrQcon . " OR ";
}
$idx = $idx + 1;
}
$whrQcon = $whrQcon . " )";
}
$db2->where($whrQcon);
} else {
$where="FIND_IN_SET('".$gid."', gids)";
$db2->where($where);
}
}
if($list_uid!=''){
$db2->where('savsoft_quiz.admin_id',$list_uid);
}
$db2->where('savsoft_quiz.display_leaderboard','1');
$db2->limit($this->config->item('number_of_rows'),$limit);
$db2->order_by('quid','desc');
$query=$db2->get('savsoft_quiz');
// echo $db2->last_query(); die;
return $query->result_array();
}
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_leaderboard.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_leaderboard.start_time >=',strtotime($date1));
}
if($date2 != ''){
$db2->where('savsoft_leaderboard.start_time <=',strtotime($date2));
}
$db2->order_by('rid','desc');
$db2->join('savsoft_users','savsoft_users.uid=savsoft_leaderboard.uid');
$db2->join('savsoft_group','savsoft_group.gid=savsoft_users.gid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_leaderboard.quid');
$query=$db2->get('savsoft_leaderboard');
return $query->result_array();
}
function get_result($rid, $uid=0)
{
$db2 = $this->load->database('readerdb', TRUE);
$logged_in=$this->session->userdata('logged_in');
$db2->where('savsoft_leaderboard.rid',$rid);
if($uid>0){
$db2->where('savsoft_users.uid',$uid);
}
$db2->join('savsoft_users','savsoft_users.uid=savsoft_leaderboard.uid');
$db2->join('savsoft_group','savsoft_group.gid=savsoft_users.gid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_leaderboard.quid');
$query=$db2->get('savsoft_leaderboard');
//echo $db2->last_query(); die;
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_leaderboard.quid',$quid);
$db2->join('savsoft_users','savsoft_users.uid=savsoft_leaderboard.uid');
$db2->join('savsoft_quiz','savsoft_quiz.quid=savsoft_leaderboard.quid');
$query=$db2->get('savsoft_leaderboard');
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_leaderboard.quid",$quid);
//$db2->group_by("savsoft_leaderboard.uid");
$db2->order_by("savsoft_leaderboard.score_obtained",'DESC');
$query = $this -> db -> get('savsoft_leaderboard');
$res[0]=$query -> num_rows();
$db2->where("savsoft_leaderboard.quid",$quid);
$db2->where("savsoft_leaderboard.uid !=",$uid);
if($score!=NULL){
$db2->where("savsoft_leaderboard.score_obtained <=",$score);
}
//$db2->group_by("savsoft_leaderboard.uid");
$db2->order_by("savsoft_leaderboard.score_obtained",'DESC');
$querys = $this -> db -> get('savsoft_leaderboard');
//echo $db2->last_query(); die;
$res[1]=$querys -> num_rows();
return $res;
}
}
?>
Kontol Shell Bypass