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