public function update(UserInterface $user)
{
$req = $this->db->prepare('
UPDATE `camagru_user` SET
username = :username,
email = :email,
password = :password,
hash = :hash,
active = :active
WHERE id = :id
');
$req->execute(['id' => $user->getId(), 'username' => $user->getUsername(), 'email' => $user->getEmail(), 'password' => $user->getPassword(), 'hash' => $user->getHash(), 'active' => $user->getActive()]);
}
public function create(UserInterface $user, PictureInterface $picture, $content)
{
$comment = new Comment();
$comment->setUserId($user->getId())->setPictureId($picture->getId())->setContent($content);
return $comment;
}
public function count(UserInterface $user = null)
{
if (isset($user)) {
$userId = $user->getId();
$req = $this->db->prepare('
SELECT COUNT(*) as count FROM `camagru_picture`
WHERE userId = :userId
');
$req->bindParam(':userId', $userId, \PDO::PARAM_INT);
} else {
$req = $this->db->prepare('
SELECT COUNT(*) as count FROM `camagru_picture`
');
}
$req->execute();
return strval($req->fetch()['count']);
}
private function send($message, $title, UserInterface $user)
{
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf8' . "\r\n";
$headers .= 'To: ' . $user->getUsername() . ' <' . $user->getEmail() . '>' . "\r\n";
$headers .= 'From: Camagru <*****@*****.**>' . "\r\n";
mail($user->getEmail(), '[Camagru] ' . $title, $message, $headers);
}
