// 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]'"));