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]; }