facebook_accounts_model.php

<?
	class Facebook_accounts_model extends Model
	{
		var $id;
		var $user_id;
		var $facebook_id;
		var $p_username;
		var $p_password;
		function __construct()
		{
			parent::Model();
			//$this->load->database();
		}
		
		function getUserPreferences($facebookid=NULL)
		{
			if($facebookid!=NULL){
				$query=$this->db->get_where('facebook_accounts',array('facebook_id'=>$facebookid),1,0);
				//$query=$this->db->get('facebook_accounts');
				return ($query->result());
			}else{
				log_message('error','No Facebookid supplied in getUserPreferences');
				return NULL;
			}
		}
		function saveLoginInfo($facebookid=NULL,$p_username=NULL,$p_password=NULL)
		{
			$query=$this->db->get_where('facebook_accounts',array('facebook_id'=>$facebookid),1,0);
			$result=$query->result();
			if($query->num_rows()>0){
				//UPDATE
				$query2=$this->db->get_where('users',array('username'=>$p_username),1,0);
				$row2=$query2->result();
				$data=array(
						'user_id'=>$row2[0]->id,
						'p_username'=>$p_username,
						'p_password'=>$p_password
						);
				$this->db->where('facebook_id',$facebookid);
				$this->db->update('facebook_accounts',$data);
				return($this->db->affected_rows());
			}else{
				//INSERT
				$query2=$this->db->get_where('users',array('username'=>$p_username),1,0);
				$result2=$query2->result();
				$data=array(
						'user_id'=>$result2[0]->id,
						'facebook_id'=>$facebookid,
						'p_username'=>$p_username,
						'p_password'=>$p_password
						);
				$this->db->insert('facebook_accounts',$data);
				//return($result2);
				return($this->db->affected_rows());
			}
		}
	}
?>