コード例 #1
0
 function isLoggedIn()
 {
     global $db;
     if (!$db) {
         try {
             $db = new dbConnection();
         } catch (Exception $e) {
             return false;
         }
     }
     if (!$db->connected) {
         return false;
     }
     $dat = new DateTime();
     $qry = "DELETE FROM ecsession WHERE expires < " . $dat->getTimestamp();
     $res = $db->do_query($qry);
     if ($res !== true) {
         return false;
     }
     $this->user = false;
     $qry = "select user, firstName, lastName, email, serverManager from ecsession left join user on ecsession.user = user.idUsers WHERE ecsession.id = '" . session_id() . "'";
     $res = $db->do_query($qry);
     if ($res !== true) {
         die($res . "\n" . $qry);
     }
     while ($arr = $db->get_row_array()) {
         $this->user = $arr["user"];
         $this->firstName = $arr["firstName"];
         $this->lastName = $arr["lastName"];
         $this->email = $arr["email"];
         $this->serverManager = $arr["serverManager"];
     }
     $db->free_result();
     return $this->user !== false;
 }