<?php


class Users_model extends CI_Model {


        public function create_account($data) {

	       $this->db->insert('users',$data);

        }


        public function check_nickname($nickname)  {

        	return $this->db->where('nickname',$nickname)->get('users')->num_rows() == 0;

        }


        public function check_email($email) {

        	return $this->db->where('email',$email)->get('users')->num_rows() == 0;

        }


        public function get_torrents($limit,$offset) {

            return $this->db->select('torrents.id , torrents.state, torrents.age , torrents.comments_count , torrents.publish_date , torrents.name , torrents.category_slug , torrents.size , torrents.seed , torrents.leech , torrents.completed , users.nickname AS nickname , categories.id AS category_id , categories.name AS category')

                    ->from('torrents')

                    ->join('users','torrents.uploader = users.id')

                    ->where('uploader',$this->session->id)

                    ->join('categories','torrents.category = categories.id')

                    ->order_by('id','desc')

                    ->limit($limit,$offset)

                    ->get()

                    ->result();

        }


        public function get_spe_userdata($where_value, $user_data, $where = 'id') 

        {

            return $this->db->select($user_data)->where($where, $where_value)->get('users')->row();

        } 


        public function get_user_comments($userId, $limit = 15, $offset = 0)

	    {

	        return $this->db->select('comments.*, torrents.name AS torrent_name, torrents.id AS torrent_id')

	            ->from('comments')

	            ->where('comments.publisher', $userId)

	            ->order_by('comments.id', 'desc')

                ->join('torrents','torrents.id = comments.guid')

	            ->limit($limit, $offset)

	            ->get()->result();

	    }


        public function get_profile_torrents($user_id,$limit,$offset) {

            return $this->db->select('torrents.id , torrents.state , torrents.age , torrents.comments_count , torrents.publish_date , torrents.name , torrents.category_slug , torrents.size , torrents.completed, torrents.seed ,torrents.leech , users.nickname AS nickname , categories.id AS category_id , categories.name AS category')

                    ->from('torrents')

                    ->join('users','torrents.uploader = users.id')

                    ->where('torrents.state', 0)

                    ->where('uploader',$user_id)

                    ->join('categories','torrents.category = categories.id')

                    ->order_by('id','desc')

                    ->limit($limit,$offset)

                    ->get()

                    ->result();

        }


        public function get_full_profile_torrents($user_id,$limit,$offset) {

            return $this->db->select('torrents.id , torrents.correction_request, torrents.state , torrents.age , torrents.comments_count , torrents.publish_date , torrents.name , torrents.category_slug , torrents.size , torrents.completed, torrents.seed ,torrents.leech , users.nickname AS nickname , categories.id AS category_id , categories.name AS category')

                    ->from('torrents')

                    ->join('users','torrents.uploader = users.id')

                    ->where('uploader',$user_id)

                    ->join('categories','torrents.category = categories.id')

                    ->order_by('id','desc')

                    ->limit($limit,$offset)

                    ->get()

                    ->result();

        }


        public function is_user_exists($id,$pass) {

                return $this->db->select('pass')->where('nickname',$id)->get('users')->row()->pass == md5($pass);

        }


        public function get_userdata($value,$column='id') {

                return $this->db->where($column,$value)->get('users')->row();

        } 


        public function add_comment($guid,$comment,$date) {

                $this->db->insert('comments',array('ip' => $_SERVER['REMOTE_ADDR'], 'guid' => $guid , 'publish_date' => $date , 'publisher' => $this->session->id , 'comment' => $comment));

                return $this->db->insert_id();

        }

        
        public function get_usertracker_data() {

			return $this->db->select('torrent_pass,end_freeleech,download_multiplier,downloaded,uploaded,can_leech,view_disabled_announce')->where('user_id',$this->session->id)->get('xbt_users')->row();

        }


        public function update_favourites($user_id,$favourites) {

            $this->db->where('id',$user_id)->set('favourites',$favourites)->update('users');

        }


}