Example #1
0
 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']);
 }
Example #2
0
 public function deleteArticle($url)
 {
     //vrati autora clanku
     $articleAuthor = Database::querryOne('
         SELECT author
         FROM articles
         WHERE url = ?
     ', array($url));
     //odstrani clanok
     Database::querry('DELETE FROM articles WHERE url = ?', array($url));
     //aktualizovanie poctu clankov uzivatela - autora odstraneneho clanku
     $userManager = new UserManager();
     $userManager->getUserData($articleAuthor['author']);
 }
Example #3
0
 public function deleteMessage($message_id, $user)
 {
     $message = $this->returnMessage($message_id);
     //ak je uzivatel odosielatel
     if ($message['sender'] == $user['name']) {
         if ($message['recipient_del'] == 1) {
             Database::querry('DELETE FROM messages WHERE message_id = ?', array($message_id));
         } else {
             $values = array('sender_del' => 1);
             Database::update('messages', $values, 'WHERE message_id = ?', array($message_id));
         }
     } else {
         if ($message['sender_del'] == 1) {
             Database::querry('DELETE FROM messages WHERE message_id = ?', array($message_id));
         } else {
             $values = array('recipient_del' => 1);
             Database::update('messages', $values, 'WHERE message_id = ?', array($message_id));
         }
     }
 }
Example #4
0
 public function deleteUser($user)
 {
     Database::querry('DELETE FROM users WHERE name = ?', array($user));
 }