public static function getCommentTreeByArticleID($id, $parent = -1) { $query = mysql_query("SELECT *, (SELECT username FROM users WHERE id = (SELECT user_id FROM comments AS sub WHERE sub.id = prime.id) ) AS author, (SELECT COUNT(id) FROM comments AS sub WHERE sub.parent_id = prime.id) AS count FROM comments AS prime WHERE parent_id='{$parent}' AND post_id='{$id}'") or die(mysql_error()); $i = 0; $comments = array(); while ($row = mysql_fetch_assoc($query)) { $comments[$i] = new Comment($row['id'], $row['content'], $id, $row['author']); $comments[$i]->prime = $parent; if ($row['count'] > 0) { $comments[$i]->comments = CommentModel::getCommentTreeByArticleID($id, $row['id']); } else { $comments[$i]->comments = array(); } $i++; } return $comments; }
public function index() { $view = new XView(Article_Table_View); $view->title = 'XRAT | Main Page'; $view->total_groups = ceil(ArticleModel::getCount()); $view->articles = ArticleModel::getArticles(0, $view->total_groups); foreach ($view->articles as $article) { $last_commentator = CommentModel::getAuthorByCommentId($article->id); if ($last_commentator == NULL) { $last_commentator = $article->author; } $article->set('last_commentator', $last_commentator); $comment_count = CommentModel::getCommentCountByArticle($article->id); $article->set('comment_count', $comment_count); $view_count = ViewsModel::getViewNumber($article->id); $article->set('view_count', $view_count); } $this->__common($view); }
public function removecomment($id) { CommentModel::remove($id); $this->view($id); }