Example #1
0
 public static function of($user)
 {
     if (!self::$db) {
         self::$db = MySQL_Database::instance();
     }
     $sql = 'SELECT s.status, s.message, s.user_id FROM ' . MYSQL_PREFIX . 'status AS s';
     if (is_int($user) || 1) {
         $sql .= ' WHERE s.user_id = :user';
     } else {
         $sql .= ' LEFT JOIN ' . MYSQL_PREFIX . 'users AS u ON u.user_id = s.user_id WHERE u.username = :user';
     }
     $sql .= ' LIMIT 1';
     $prep = self::$db->prepare($sql);
     $prep->execute(array(':user' => $user));
     $status = $prep->fetch(PDO::FETCH_OBJ);
     return new Status($status->user_id, $status->status, $status->message);
 }
Example #2
0
 function __construct($user_id, $s = null, $message = '')
 {
     self::$db = MySQL_Database::instance();
     $this->s = $s;
     $this->message = $message;
     $this->user_id = $user_id;
 }