public static function readFirst($myID)
{
$db = Database::getInstance();
$query = $db->prepare("SELECT * FROM messages WHERE recipientid = ? ORDER BY readflag DESC ");
$query->execute([$myID]);
return $query;
}
public static function isBlocked($fromID, $toID)
{
$db = Database::getInstance();
$query = $db->prepare('SELECT resctrictionid FROM restrictions WHERE (fromid = ? AND toid = ?)');
$query->execute([$fromID, $toID]);
return $query->fetch()['resctrictionid'];
}
public static function checksNewRequests($myID)
{
$db = Database::getInstance();
$query = $db->prepare('SELECT * FROM requests WHERE toid = ?');
$query->execute([$myID]);
return $query;
}
public static function getNumberOfComments($id)
{
$db = Database::getInstance();
$query = $db->prepare("SELECT COUNT(tweetid) AS n FROM tweetcomments WHERE tweetid = ?");
$query->execute([$id]);
return $query->fetch()['n'];
}
public static function getUserGalleries($userid)
{
$db = Database::getInstance();
$query = $db->prepare("SELECT * FROM gallery WHERE userid = ?");
$query->execute([$userid]);
return $query->fetchAll();
}
public static function postComment(PhotoComment $comment)
{
$db = Database::getInstance();
$query = $db->prepare('INSERT INTO photocomments (photoid,userid,content) VALUES (?, ?, ?)');
$query->execute([$comment->getPhotoid(), $comment->getUserid(), $comment->getContent()]);
}
public static function unfriend($firstID, $secondID)
{
$db = Database::getInstance();
$query = $db->prepare('DELETE FROM friends WHERE (user1 = ? AND user2 = ?) OR (user1 = ? AND user2 = ?)');
$query->execute([$firstID, $secondID, $secondID, $firstID]);
}
public static function showInUsersList($userid)
{
$db = Database::getInstance();
$query = $db->prepare('UPDATE users SET visibility = 1 WHERE userid = ?');
$query->execute([$userid]);
}
public static function getAllPhotos()
{
$db = Database::getInstance();
$query = $db->prepare('SELECT * FROM photo');
$query->execute();
return $query;
}
