Changeset 19973

Timestamp:

09/26/08 21:30:55 (5 years ago)

Author:

kenji

Message:

Add methods

Files:

• events/phpframework/codeigniter/trunk/system/application/models/user_model.php (modified) (2 diffs)

events/phpframework/codeigniter/trunk/system/application/models/user_model.php

@@ -14 +14 @@
                 $row = $query->row();
                 return array($row->username, $row->image);
+        }
+
+        function get_username_and_image_by_username($username)
+        {
+                $this->db->select('id, username, image');
+                $query = $this->db->get_where('users', array('username' => $username));
+                return $query->row();
         }
 
@@ -53 +60 @@
         }
 
+        function get_friends_count($id)
+        {
+                $this->db->select('COUNT(*) AS count');
+                $this->db->where('user_id', $id);
+                $query = $this->db->get('followers');
+                $row = $query->row();
+                return $row->count;
+        }
+
+        function get_followers_count($id)
+        {
+                $this->db->select('COUNT(*) AS count');
+                $this->db->where('follow_id', $id);
+                $query = $this->db->get('followers');
+                $row = $query->row();
+                return $row->count;
+        }
+
 }