public function returnMessage($message_id)
{
return Database::querryOne('
SELECT message_id, sender, recipient, subject, message, date, unread, sender_del, recipient_del
FROM messages
WHERE message_id = ?
', array($message_id));
}
public function deleteComment($comment_id)
{
//vrati autora komentaru
$commentAuthor = Database::querryOne('
SELECT author
FROM comments
WHERE comment_id = ?
', array($comment_id));
//odstrani komentar
Database::querry('DELETE FROM comments WHERE comment_id = ?', array($comment_id));
//aktualizovanie poctu komentarov uzivatela - autora odstraneneho komentara
$userManager = new UserManager();
$userManager->getUserData($commentAuthor['author']);
}
public function getUserData($user)
{
//ziska pocet clankov
$count = Database::querryOne('
SELECT COUNT(*)
FROM articles
WHERE author = ?
', array($user));
$values['articles'] = $count[0];
//ziska pocet komentarov
$count = Database::querryOne('
SELECT COUNT(*)
FROM comments
WHERE author = ?
', array($user));
$values['comments'] = $count[0];
//zapise data do databazy
$this->updateUserData($user, $values);
}
public function returnLastArticleId()
{
$id = Database::querryOne("SELECT article_id FROM articles ORDER BY article_id DESC LIMIT 1");
return $id[0];
}
