Code:
<?php
class Member extends CI_Model {
var $info = array();
var $error = NULL;
var $activation_code = '';
var $id = 0;
function __construct(){
parent::__construct();
$this->error = NULL;
}
function default_info(){
$info = array(
'id' => 0,
'display_name' => 'Guest',
'email_address' => '',
'password' => '',
'status' => 0,
'activation_code' => '',
'location' => '',
'date_joined' => '',
'gender' => '',
'results_per_page' => 10,
'admin_emails' => FALSE,
'member_emails' => FALSE,
'team' => array('id' => 0),
'perms' => array(),
'group' => array('id' => 0),
'stats' => array(),
'signature' => '',
'last_active' => 0,
'last_forum_visit' => 0,
'member_profile' => 'Guest',
'date_of_birth' => '',
'gender' => '',
'profile_banner' => '',
'avatar' => array('url' => '')
);
return $info;
}
public function get_info($criteria){
$where = (is_numeric($criteria)) ? "WHERE member_id = ".$criteria : "WHERE email_address = '".$criteria."'";
$query_member = "
SELECT
m.member_id, m.display_name, m.email_address, m.group_id, m.status, m.activation_code, UNIX_TIMESTAMP(m.date_joined) AS date_joined,
m.gender, m.location, m.biography, m.mantra, m.birth_date, m.results_per_page, m.admin_emails, m.member_emails,
m.last_active, m.avatar_id, m.banner_id, m.signature, m.newsletter_subscription, m.recruiting_status,
m.facebook_username, m.website, m.steam_username, m.xboxlive_gamertag, m.psn_id,
g.group_id, g.title, g.description,
a.attachment_id, a.file_name,
f.message_id, f.author_id, COUNT(f.message_id) AS forum_count
FROM members AS m
LEFT JOIN member_groups AS g ON (m.group_id = g.group_id)
LEFT JOIN attachments AS a ON (m.attachment_id = a.attachment_id)
LEFT JOIN forum_messages AS f ON (m.member_id = f.author_id)
".$where."
GROUP BY m.member_id
LIMIT 1";
if($query_member = $this->db->query($query_member)){
if($query_member->num_rows() > 0){
$member = $query_member->row_array();
$member_id = $member['member_id'];
/* Determine if the user is already friends with the member... */
$this->db->select('request_id, author_id, recipient_id, status');
$this->db->from('member_requests');
$this->db->where('status', '1');
$this->db->where('author_id', $this->user['id']);
$this->db->where('recipient_id', $member_id);
$this->db->or_where('author_id', $member_id);
$this->db->where('recipient_id', $this->user['id']);
if($query_friend = $this->db->get()){
if($query_friend->num_rows() > 0){
$friend_status = TRUE;
} else {
$friend_status = FALSE;
}
}
$info = array(
'id' => $member['member_id'],
'display_name' => $member['display_name'],
'email_address' => $member['email_address'],
'status' => ($member['status'] == 0) ? FALSE : TRUE,
'activation_code' => $member['activation_code'],
'location' => $member['location'],
'date_joined' => date('M jS, Y', $member['date_joined']),
'gender' => ($member['gender'] == 0) ? 'Male' : 'Female',
'results_per_page' => $member['results_per_page'],
'admin_emails' => ($member['admin_emails'] == 0) ? FALSE : TRUE,
'member_emails' => ($member['member_emails'] == 0) ? FALSE : TRUE,
'group' => array(
'id' => $member['group_id'],
'title' => $member['title'],
'description' => $member['description']
),
'signature' => $member['signature'],
'last_active' => strtotime($member['last_active']),
'member_profile' => anchor('members/'.url_title($member['display_name']).'/'.$member['member_id'], $member['display_name']),
'newsletter' => ($member['newsletter_subscription'] == 1) ? TRUE : FALSE,
'date_of_birth' => date('M jS, Y', strtotime($member['birth_date'])),
'birth_date' => date('Y-m-d', strtotime($member['birth_date'])),
'age' => floor((time() - strtotime($member['birth_date'])) / (60 * 60 * 24 * 365)),
'gender' => $member['gender'],
'biography' => $member['biography'],
'banner' => NULL,
'mantra' => $member['mantra'],