// CHECK IF USER IS ALLOWED TO COMMENT
$allowed_to_comment = 1;
if(!($privacy_max & $rc_article->article_info[article_comments])) { $allowed_to_comment = 0; }
// SHOW FILES IN THIS ALBUM
$articlealbum_info = $database->database_fetch_assoc($database->database_query("SELECT articlealbum_id FROM se_articlealbums WHERE articlealbum_article_id='".$rc_article->article_info[article_id]."' LIMIT 1"));
$total_files = $rc_article->article_media_total($articlealbum_info[articlealbum_id]);
$file_array = $rc_article->article_media_list(0, 5, "RAND()", "(articlemedia_articlealbum_id='$articlealbum_info[articlealbum_id]')");
$rc_article->article_info[article_body] = str_replace("\r\n", "", html_entity_decode($rc_article->article_info[article_body]));
$rc_tag = new rc_articletag();
$article_tags = $rc_tag->get_object_tags($article_id);
// ASSIGN VARIABLES AND DISPLAY ARTICLE PAGE
$smarty->assign('article', $rc_article);
$smarty->assign('articleowner_info', $articleowner_info);
$smarty->assign('article_category', $article_category);
$smarty->assign('parent_category', $parent_category);
$smarty->assign('comments', $comments);
$smarty->assign('total_comments', $total_comments);
$smarty->assign('article_tags', $article_tags);
$smarty->assign('is_article_private', $is_article_private);
$smarty->assign('allowed_to_comment', $allowed_to_comment);
$smarty->assign('files', $file_array);
$smarty->assign('total_files', $total_files);
include "footer.php";
?>
function article_list($start, $limit, $sort_by = "article_id DESC", $where = "", $article_details = 0) {
global $database, $user, $owner;
// BEGIN QUERY
$article_query = "SELECT se_articles.*, se_articlecats.articlecat_title, count(articlecomment_id) AS total_comments";
// IF NO USER ID SPECIFIED, RETRIEVE USER INFORMATION
if($this->user_id == 0) { $article_query .= ", se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname "; }
// CONTINUE QUERY
$article_query .= " FROM se_articles LEFT JOIN se_articlecats ON se_articles.article_articlecat_id=se_articlecats.articlecat_id LEFT JOIN se_articlecomments ON se_articles.article_id=se_articlecomments.articlecomment_article_id";
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
if($this->user_id == 0) { $article_query .= " LEFT JOIN se_users ON se_articles.article_user_id=se_users.user_id"; }
// ADD WHERE IF NECESSARY
if($where != "" | $this->user_id != 0) { $article_query .= " WHERE"; }
// ENSURE USER ID IS NOT EMPTY
if($this->user_id != 0) { $article_query .= " article_user_id='".$this->user_id."'"; }
// INSERT AND IF NECESSARY
if($this->user_id != 0 & $where != "") { $article_query .= " AND"; }
// ADD WHERE CLAUSE, IF NECESSARY
if($where != "") { $article_query .= " $where"; }
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
$article_query .= " GROUP BY article_id ORDER BY $sort_by LIMIT $start, $limit";
// RUN QUERY
$articleentries = $database->database_query($article_query);
$rc_tag = new rc_articletag();
// GET BLOG ENTRIES INTO AN ARRAY
$article_array = Array();
while($article_info = $database->database_fetch_assoc($articleentries)) {
// CREATE OBJECT FOR EVENT
$article = new rc_article($article_info[user_id]);
$article->article_exists = 1;
$article->article_info= $article_info;
// CONVERT HTML CHARACTERS BACK
//$article_body = str_replace("\r\n", "", html_entity_decode($article_info[article_body]));
// IF NO USER ID SPECIFIED, CREATE OBJECT FOR AUTHOR
if($this->user_id == 0) {
$author = new se_user();
$author->user_exists = 1;
$author->user_info[user_id] = $article_info[user_id];
$author->user_info[user_username] = $article_info[user_username];
$author->user_info[user_photo] = $article_info[user_photo];
$author->user_info[user_fname] = $article_info[user_fname];
$author->user_info[user_lname] = $article_info[user_lname];
// OTHERWISE, SET AUTHOR TO OWNER/LOGGED-IN USER
} elseif($owner->user_exists != 0 & $owner->user_info[user_id] == $article_info[article_user_id]) {
$author = $owner;
} elseif($user->user_exists != 0 & $user->user_info[user_id] == $article_info[article_user_id]) {
$author = $user;
}
$author->user_displayname();
// SET EVENT ARRAY
$article_array[] = Array('article' => $article,
'tags' => $rc_tag->get_object_tags($article_info['article_id']),
'article_author' => $author);
}
// RETURN ARRAY
return $article_array;
} // END article_list() METHOD
// SET RESULT MESSAGE
$result = 1;
$article->article_lastupdate();
}
}
else {
$article_title = $article->article_info[article_title];
$article_body = $article->article_info[article_body];
$article_date_start = $article->article_info[article_date_start];
$article_tags = join(', ',$rc_tag->get_object_tags($article_id));
$article_inviteonly = $article->article_info[article_inviteonly];
$article_search = $article->article_info[article_search];
$article_privacy = $article->article_info[article_privacy];
$article_comments = $article->article_info[article_comments];
$article_draft = $article->article_info[article_draft] ? 1 : 0;
if($article->article_info[article_articlecat_id] == 0) {
$articlecat_id = 0;
$subarticlecat_id = 0;
} else {
$articlecat = $database->database_fetch_assoc($database->database_query("SELECT articlecat_id, articlecat_dependency FROM se_articlecats WHERE articlecat_id='".$article->article_info[article_articlecat_id]."'"));
if($articlecat[articlecat_dependency] == 0) {
$articlecat_id = $articlecat[articlecat_id];
$subarticlecat_id = "0";
} else {
$parentarticlecat = $database->database_fetch_assoc($database->database_query("SELECT articlecat_id FROM se_articlecats WHERE articlecat_id='$articlecat[articlecat_dependency]'"));
