Articles Ãþ§O °Ñ¦Ò¤å¥ó
[DAO]

Ãþ§OArticlesªºÄ~©Ó¹Ï:

¥þ³¡¦¨­û¦Cªí

¤½¶}¤èªk(Public Methods)
	Articles ()
	getUserArticle ($artId, $userId=-1)
	getBlogArticle ($artId, $blogId=-1, $includeHiddenFields=true, $date=-1, $categoryId=-1, $userId=-1, $status=POST_STATUS_ALL, $maxDate=-1)
	getBlogArticleByTitle ($artTitle, $blogId=-1, $includeHiddenFields=true, $date=-1, $categoryId=-1, $userId=-1, $status=POST_STATUS_PUBLISHED, $maxDate=-1)
	getBlogNextArticle ($article)
	getBlogPrevArticle ($article)
	searchBlogArticles ($blogId, $searchTerms)
	getNumBlogArticles ($blogid, $date=-1, $amount=-1, $categoryId=-1, $status=0, $userId=0, $maxDate=0, $searchTerms="")
	getBlogArticles ($blogid, $date=-1, $amount=-1, $categoryId=0, $status=0, $userId=0, $maxDate=0, $searchTerms="", $page=-1)
	getArticleIdFromName ($articleName)
	getArticlesText ($articleIds)
	getBlogArticlesByQuery ($query)
	getNumberPostsPerMonth ($blogId)
	getNumberPostsPerMonthAdmin ($blogId)
	getNumberPostsPerDay ($blogId, $year=null, $month=null)
	addPostCategoriesLink ($articleId, $categories)
	deletePostCategoriesLink ($articleId)
	updatePostCategoriesLink ($articleId, $categories)
	addArticle (&$newArticle)
	addArticleText ($newArticle)
	getArticleText ($articleId)
	updateArticleText ($article)
	addArticleCustomFields ($artId, $blogId, $fields)
	updateArticle ($article)
	updateArticleCustomFields ($artId, $blogId, $fields)
	updateArticleNumReads ($articleId)
	updateArticleNumReadsByName ($articleName)
	deleteArticle ($artId, $userId, $blogId, $forever=false)
	doesUserOwnArticle ($userinfo, $artid)
	getAllArticles ($maxPosts=0, $date=0)
	deleteBlogPosts ($blogId)
	purgePosts ()
	getArticleCategories ($articleId, $blogId=-1)
	getArticleCategoryIds ($articleId)
	setTimeDiff ($timeDiff)
¤½¶}ÄÝ©Ê
	$categories
	$comments
	$trackbacks
	$users
	$blogs
	$customfields
	$_blogInfo
	$_blogSettings
	$_timeDiff
¨p¦³¤èªk(Private Methods)
	_getBlogArticleFromQuery ($query, $includeHiddenFields)
	buildWhere ($blogid, $date=-1, $amount=-1, $categoryId=0, $status=0, $userId=0, $maxDate=0, $searchTerms="")
	deleteArticleText ($articleId)
	_fillArticleInformation ($query_result, $includeHiddenFields=true)
	_fillArticleHeaderInformation ($query_result, $includeHiddenFields=true)

---

¸Ô²Ó´y­z

Model for the Articles

©w¸q¦b articles.class.php Àɮפ§²Ä 25 ¦æ.

---

«Øºc¤l»P¸Ñºc¤l»¡©ú¤å¥ó

Articles::Articles (   )

©w¸q¦b articles.class.php Àɮפ§²Ä 40 ¦æ. °Ñ¦Ò cache, ¤Î Model::Model(). { $this->Model(); $this->categories = new ArticleCategories(); $this->comments = new ArticleComments(); $this->trackbacks = new Trackbacks(); $this->users = new Users(); $this->blogs = new Blogs(); $this->customfields = new CustomFieldsValues(); // fine, this is not very nice but it helps a lot, specially if all the classes // that need to load articles share the same instance $this->cache = Array(); $this->_blogInfo = null; $this->_timeDiff = 0; $this->_blogsettings = null; }

---

¨ç¦¡¦¨­û»¡©ú¤å¥ó

Articles::_fillArticleHeaderInformation (  $  query_result, $  includeHiddenFields = true )  [private]

©w¸q¦b articles.class.php Àɮפ§²Ä 1192 ¦æ. °Ñ¦Ò $article, $date, cache, ¤Î Timestamp::getDateWithOffset(). { $id = $query_result['id']; if( isset($this->cache[$id])) { return($this->cache[$id]); } // this is a little dirty trick or otherwise the old // that don't have the 'properties' field will not work // as they will appear to have comments disabled if( $query_result['properties'] == "" ) { $tmpArray = Array( 'comments_enabled' => true ); $query_result['properties'] = serialize($tmpArray); } // --- // this, i do not like... but I couldn't find a more // "elegant" way to arrange it! This makes this method // totally dependant on the blog configuration so it basically // means an additional query every time we fetch an article // (just in case we didn't have enough!) // --- // // if there's a time difference applied to all dates, then we'd better // calculate it here!! // if( $this->_blogInfo == null ) { $blogId = $query_result['blog_id']; $this->_blogInfo = $this->blogs->getBlogInfo( $blogId ); $this->_blogSettings = $this->_blogInfo->getSettings(); $this->_timeDiff = $this->_blogSettings->getValue( 'time_offset' ); } // we can use this auxiliary function to help us... $date = Timestamp::getDateWithOffset( $query_result['date'], $this->_timeDiff ); // postText does not exist here.. maybe a copy/paste problem? // anyway.. it works without postText, so i'll just set this to // null. oscar, pls double check.. original code: // $article = new Article( $postText['topic'], // $postText['text'], // NULL, $article = new Article( NULL, NULL, NULL, $query_result['user_id'], $query_result['blog_id'], $query_result['status'], $query_result['num_reads'], unserialize($query_result['properties']), $query_result['slug'], $query_result['id'] ); // and fill in all the fields with the information we just got from the db $article->setDate( $date ); $article->setTimeOffset( $this->_timeDiff ); $article->setBlogInfo( $this->_blogInfo ); $article->setUserInfo( $this->users->getUserInfoFromId( $query_result['user_id'] )); return $article; }

Articles::_fillArticleInformation (  $  query_result, $  includeHiddenFields = true )  [private]

Does exactly the same as _fillUserInformation, so that it can be reused by the different functions that work on articles from the database. This method is private and shouldn't be used outside this class. ©w¸q¦b articles.class.php Àɮפ§²Ä 1121 ¦æ. °Ñ¦Ò $article, $blogInfo, $category, $date, cache, getArticleCategories(), getArticleText(), ¤Î Timestamp::getDateWithOffset(). ³Q°Ñ¦Ò©ó _getBlogArticleFromQuery(), getAllArticles(), ¤Î getUserArticle(). { $id = $query_result['id']; if( isset($this->cache[$id])) { return($this->cache[$id]); } // this is a little dirty trick or otherwise the old // that don't have the 'properties' field will not work // as they will appear to have comments disabled if( $query_result['properties'] == "" ) { $tmpArray = Array( 'comments_enabled' => true ); $query_result['properties'] = serialize($tmpArray); } // --- // this, i do not like... but I couldn't find a more // "elegant" way to arrange it! This makes this method // totally dependant on the blog configuration so it basically // means an additional query every time we fetch an article // (just in case we didn't have enough!) // --- // // if there's a time difference applied to all dates, then we'd better // calculate it here!! // $blogId = $query_result['blog_id']; $blogInfo = $this->blogs->getBlogInfo( $blogId ); $blogSettings = $blogInfo->getSettings(); $timeDiff = $blogSettings->getValue( 'time_offset' ); // we can use this auxiliary function to help us... $date = Timestamp::getDateWithOffset( $query_result['date'], $timeDiff ); $articleCategories = $this->getArticleCategories( $query_result['id'], $query_result['blog_id'] ); $categoryIds = Array(); foreach( $articleCategories as $category ) array_push( $categoryIds, $category->getId()); // get the article text $postText = $this->getArticleText( $query_result['id'] ); $article = new Article( $postText['topic'], $postText['text'], $categoryIds, $query_result['user_id'], $query_result['blog_id'], $query_result['status'], $query_result['num_reads'], unserialize($query_result['properties']), $query_result['slug'], $query_result['id'] ); // and fill in all the fields with the information we just got from the db $article->setDate( $date ); $article->setTimeOffset( $timeDiff ); // get information about the categories of the article $article->setCategories( $articleCategories ); $article->setBlogInfo( $blogInfo ); $article->setUserInfo( $this->users->getUserInfoFromId( $query_result['user_id'] )); // fill in the cache with the result we just loaded $this->cache[$query_result['id']] = $article; return $article; }

Articles::_getBlogArticleFromQuery (  $  query, $  includeHiddenFields )  [private]

©w¸q¦b articles.class.php Àɮפ§²Ä 165 ¦æ. °Ñ¦Ò $article, $query, $result, _fillArticleInformation(), ¤Î Model::Execute(). ³Q°Ñ¦Ò©ó getBlogArticle(), getBlogArticleByTitle(), getBlogNextArticle(), ¤Î getBlogPrevArticle(). { // we send the query and then fetch the first array with the result $result = $this->Execute( $query ); if( $result == false ) return false; if ( $result->RecordCount() == 0) return false; $row = $result->FetchRow( $result ); $article = $this->_fillArticleInformation( $row, $includeHiddenFields ); $result->Close(); return $article; }

Articles::addArticle (  &$  newArticle  )

Adds a new article to the database °Ñ¼Æ: newArticle  An Article object with all the necessary information. ¶Ç¦^­È: Returns true if article was added successfully or false otherwise. If successful, it will modify the parmeter passed by reference and set its database id. ©w¸q¦b articles.class.php Àɮפ§²Ä 696 ¦æ. °Ñ¦Ò $query, $result, addArticleCustomFields(), addArticleText(), addPostCategoriesLink(), ¤Î Model::Execute(). { // first, we build up the query $query = "INSERT INTO ".$this->getPrefix()."articles( user_id,blog_id,status,date,properties, slug ) VALUES ( ".$newArticle->getUser().",". $newArticle->getBlog().",'". $newArticle->getStatus()."','". $newArticle->getDate()."','". serialize($newArticle->getProperties())."','". $newArticle->getPostSlug()."');"; // and then we send it to the db //$this->_db->debug=true; $result = $this->Execute( $query ); if( !$result ){ return false; } // get id of the post from the database $postId = $this->_db->Insert_ID(); // save the post text $newArticle->setId( $postId ); $this->addArticleText( $newArticle ); // and create the link between the post and its categories? $this->addPostCategoriesLink( $postId, $newArticle->getCategoryIds()); // and save the custom fields $this->addArticleCustomFields( $postId, $newArticle->getBlog(), $newArticle->getFields()); return $postId; }

Articles::addArticleCustomFields (  $  artId, $  blogId, $  fields )

Saves the custom fields of an article °Ñ¼Æ: artId  blogId  fields  ¶Ç¦^­È: True if successful or false otherwise ©w¸q¦b articles.class.php Àɮפ§²Ä 803 ¦æ. °Ñ¦Ò getValue(). ³Q°Ñ¦Ò©ó addArticle(). { $customFields = new CustomFieldsValues(); foreach( $fields as $field ) { $customFields->addCustomFieldValue( $field->getFieldId(), $field->getValue(), $artId, $blogId ); } return true; }

Articles::addArticleText (  $  newArticle  )

saves the text of an article to the database °Ñ¼Æ: newArticle  the Article object that we have just saved @return  true if successful or false otherwise ©w¸q¦b articles.class.php Àɮפ§²Ä 737 ¦æ. °Ñ¦Ò $query, Model::Execute(), Model::getPrefix(), ¤Î Db::qstr(). ³Q°Ñ¦Ò©ó addArticle(). { $filter = new Textfilter(); $prefix = $this->getPrefix(); $query = "INSERT INTO {$prefix}articles_text (article_id, topic, text, normalized_text, normalized_topic) VALUES( '".Db::qstr( $newArticle->getId())."', '". Db::qstr($newArticle->getTopic())."','". Db::qstr($newArticle->getText(false))."','". $filter->normalizeText(Db::qstr($newArticle->getText(false)))."', '". $filter->normalizeText(Db::qstr($newArticle->getTopic()))."')"; return( $this->Execute( $query )); }

Articles::addPostCategoriesLink (  $  articleId, $  categories )

adds records to the table that holds the many-to-many relationship between categories and posts in the blog. °Ñ¼Æ: articleId  categories  ¶Ç¦^­È: True ©w¸q¦b articles.class.php Àɮפ§²Ä 649 ¦æ. °Ñ¦Ò $categories, $query, ¤Î Model::Execute(). ³Q°Ñ¦Ò©ó addArticle(), ¤Î updatePostCategoriesLink(). { // nothing to do if the $categories array is not ehem, an array :) if( !is_array( $categories )) return true; foreach( $categories as $categoryId ) { $query = "INSERT INTO ".$this->getPrefix()."article_categories_link (article_id, category_id) VALUES ($articleId, $categoryId )"; $this->Execute( $query ); } return true; }

Articles::buildWhere (  $  blogid, $  date = -1, $  amount = -1, $  categoryId = 0, $  status = 0, $  userId = 0, $  maxDate = 0, $  searchTerms = "" )  [private]

builds a WHERE clause for a query ©w¸q¦b articles.class.php Àɮפ§²Ä 255 ¦æ. °Ñ¦Ò $date, $query, ¤Î Model::getPrefix(). ³Q°Ñ¦Ò©ó getBlogArticles(), ¤Î getNumBlogArticles(). { $postStatus = $status; $prefix = $this->getPrefix(); if($blogid == -1){ $query = "a.blog_id = a.blog_id"; } else{ $query = "a.blog_id = ".Db::qstr($blogid); } if( $date != -1 ) { // consider the time difference $blogSettings = $this->blogs->getBlogSettings( $blogid ); $timeDifference = $blogSettings->getValue( "time_offset" ); $SecondsDiff = $timeDifference * 3600; $query .= " AND FROM_UNIXTIME(UNIX_TIMESTAMP(a.date)+$SecondsDiff)+0 LIKE '$date%'"; } // the common part "c.id = a.category_id" is needed so that // we don't get one article row as many times as the amount of categories // we have... due to the sql 'join' operation we're carrying out if( $categoryId == -1 ) $query .= " AND c.id = l.category_id AND a.id = l.article_id "; else { if( $categoryId > 0 ) $query .= " AND a.id = l.article_id AND l.category_id = $categoryId AND c.id = l.category_id"; else { $query .= " AND c.id = l.category_id AND a.id = l.article_id AND c.in_main_page = 1"; } } if( $status > 0 ) $query .= " AND a.status = '$postStatus'"; if( $userId > 0 ) $query .= " AND a.user_id = ".Db::qstr($userId); if( $maxDate > 0 ) $query .= " AND a.date <= '$maxDate'"; // in case there were some search terms specified as parameters... if( $searchTerms != "" ) { // load the class dynamically so that we don't have to waste memory // if we're not going to need it! include_once( PLOG_CLASS_PATH."class/dao/searchengine.class.php" ); $searchEngine = new SearchEngine(); // prepare the query string $searchTerms = $searchEngine->_adaptSearchString( $searchTerms ); $whereString = $searchEngine->_generateSearchArticlesWhereString( $searchTerms ); // and add it to the current search $query .=" AND {$whereString} "; } if( $categoryId <= 0 ) $query .= " GROUP BY a.id "; return $query; }

Articles::deleteArticle (  $  artId, $  userId, $  blogId, $  forever = false )

Removes an article from the database If forever == true, the article is physically removed from the database. Otherwise, the 'status' field is set to 'deleted' Problem is, that MySQL will automatically update the 'date' field because he feels like it... even if we explicitely say date = old_date... grrreat :P Valid article identifier, blog identifier and user identifier are required to remove an article. It was done for security reasons and to make perfectly clear that we are removing an article (so that we wouldn't be deleting the wrong one if there was any bug!) °Ñ¼Æ: artId  A valid article identifier userid  A valid user identifier blogId  A valid blog identifier forever  A boolean meaning whether the post should be removed forever or simply its status should be set to 'deleted' ¶Ç¦^­È: Returns true if successful or false otherwise. ©w¸q¦b articles.class.php Àɮפ§²Ä 939 ¦æ. °Ñ¦Ò $comments, $query, $result, $trackbacks, deleteArticleText(), deletePostCategoriesLink(), ¤Î Model::Execute(). ³Q°Ñ¦Ò©ó deleteBlogPosts(), ¤Î purgePosts(). { if( $forever ) { $query = "DELETE FROM ".$this->getPrefix()."articles WHERE id = ".$artId." AND user_id = ".$userId." AND blog_id = ".$blogId.";"; // -- text -- $this->deleteArticleText( $artId ); // we also have to remove its comments and trackbacks if the article is being deleted forever // -- comments -- $comments = new ArticleComments(); $comments->deletePostComments( $artId ); // -- trackbacks -- $trackbacks = new Trackbacks(); $trackbacks->deletePostTrackbacks( $artId ); // -- post-to-categories mappings -- $this->deletePostCategoriesLink( $artId ); // -- custom fields -- $customFields = new CustomFieldsValues(); $customFields->removeArticleCustomFields( $artId ); } else { $query = "UPDATE ".$this->getPrefix()."articles SET date = date, status = 3 WHERE id = ".$artId." AND user_id = ".$userId." AND blog_id = ".$blogId.";"; } $result = $this->Execute( $query ); if( !$result ) return false; if( $this->_db->Affected_Rows() == 0 ) return false; return true; }

Articles::deleteArticleText (  $  articleId  )  [private]

removes the text of an article °Ñ¼Æ: articleId  ¶Ç¦^­È: true if successful or false otherwise °Ñ¾\: Articles::deleteArticle ©w¸q¦b articles.class.php Àɮפ§²Ä 981 ¦æ. °Ñ¦Ò $articleId, $query, Model::Execute(), ¤Î Db::qstr(). ³Q°Ñ¦Ò©ó deleteArticle(). { $query = "DELETE FROM ".$this->getPrefix()."articles_text WHERE article_id = '".Db::qstr($articleId)."'"; return( $this->Execute( $query )); }

Articles::deleteBlogPosts (  $  blogId  )

Removes all the posts from the given blog °Ñ¼Æ: blogId  The blog identifier ©w¸q¦b articles.class.php Àɮפ§²Ä 1045 ¦æ. °Ñ¦Ò $article, deleteArticle(), ¤Î getBlogArticles(). { $blogArticles = $this->getBlogArticles( $blogId ); foreach( $blogArticles as $article ) { // the deleteArticle method will also take care of removing comments and // trackbacks $this->deleteArticle( $article->getId(), $article->getUser(), $article->getBlog(), true ); } return true; }

Articles::deletePostCategoriesLink (  $  articleId  )

removes the relationship between posts and categories from the database. This method should only be used when removing an article!! ©w¸q¦b articles.class.php Àɮפ§²Ä 668 ¦æ. °Ñ¦Ò $query, ¤Î Model::Execute(). ³Q°Ñ¦Ò©ó deleteArticle(), ¤Î updatePostCategoriesLink(). { $query = "DELETE FROM ".$this->getPrefix()."article_categories_link WHERE article_id = $articleId"; return $this->Execute( $query ); }

Articles::doesUserOwnArticle (  $  userinfo, $  artid )

returns true if the user posted this article/post, or false if he or she doesn't own it °Ñ¼Æ: userInfo  A UserInfo object with information about the user artId  A valid article identifier ¶Ç¦^­È: Returns true if the article is owned by the user or false otherwise. ©w¸q¦b articles.class.php Àɮפ§²Ä 996 ¦æ. °Ñ¦Ò $article. { $article = $this->getArticle( $artid ); $articleOwnerInfo = $article->getUserInfo(); if( $articleOwnerInfo->getId() == $userinfo->getId()) return true; else return false; }

Articles::getAllArticles (  $  maxPosts = 0, $  date = 0 )

Returns all the posts in the database or the 'maxPosts' recent ones that have been published (status=='published') °Ñ¼Æ: maxPosts  The amount of post we want. ¶Ç¦^­È: Returns an array of Article objects containing the information about the posts. ©w¸q¦b articles.class.php Àɮפ§²Ä 1014 ¦æ. °Ñ¦Ò $date, $query, $result, _fillArticleInformation(), ¤Î Model::Execute(). { $query = "SELECT * FROM ".$this->getPrefix()."articles WHERE status = 1"; if( $date > 0 ) $query .= " AND date < '$date'"; $query .= " ORDER BY date DESC"; if( $maxPosts > 0 ) $query .= " LIMIT 0,".$maxPosts; $result = $this->Execute( $query ); if( !$result ) return false; $posts = Array(); while( $row = $result->FetchRow()) { $posts[] = $this->_fillArticleInformation( $row ); } $result->Close(); return $posts; }

Articles::getArticleCategories (  $  articleId, $  blogId = -1 )

returns all the categories that an article has been assigned to ©w¸q¦b articles.class.php Àɮפ§²Ä 1083 ¦æ. °Ñ¦Ò $articleId. ³Q°Ñ¦Ò©ó _fillArticleInformation(). { return $this->categories->getArticleCategories( $articleId, $blogId ); }

Articles::getArticleCategoryIds (  $  articleId  )

returns all the categories that an article has been assigned to ©w¸q¦b articles.class.php Àɮפ§²Ä 1091 ¦æ. °Ñ¦Ò $categories, $query, $result, ¤Î Model::Execute(). { $query = "SELECT category_id FROM ".$this->getPrefix()."article_categories_link WHERE article_id = $articleId"; $result = $this->Execute( $query ); // it's impossible that an article has no categories, but // we'll bear with it... if( !$result ) return Array(); // otherwise, fetch them $categories = Array(); while( $row = $result->FetchRow()) { $categories[] = $row['category_id']; } $result->Close(); return $categories; }

Articles::getArticleIdFromName (  $  articleName  )

Takes an article name and returns the id °Ñ¼Æ: articleName  an article "name" (the post 'slug') ¶Ç¦^­È: articleId or 0 if unsuccessful ©w¸q¦b articles.class.php Àɮפ§²Ä 462 ¦æ. { $query = "SELECT id FROM ".$this->getPrefix()."articles ". " WHERE slug = '".Db::qstr($articleName)."'"; $result = $this->Execute($query); if($row = $result->FetchRow()){ $result->Close(); if($row["id"]) return $row["id"]; } return 0; }

Articles::getArticlesText (  $  articleIds  )

returns the text of a bunch of articles, given their ids °Ñ¼Æ: articleIds  ¶Ç¦^­È: an array, where the key is the article id and the value is an another associative array with the text and topics of the articles ©w¸q¦b articles.class.php Àɮפ§²Ä 485 ¦æ. { $prefix = $this->getPrefix(); $query = "SELECT article_id,text,topic FROM {$prefix}articles_text WHERE article_id IN (".$articleIds.")"; $result = $this->Execute( $query ); // it's impossible that an article has no categories, but // we'll bear with it... if( !$result ) return Array(); // otherwise, fetch them while ($row = $result->FetchRow()) { $lastArticleId=$row["article_id"]; $postTexts[$lastArticleId]=$row; } $result->Close(); return( $postTexts ); }

Articles::getArticleText (  $  articleId  )

returns the text fields of an article °Ñ¼Æ: articleId  ¶Ç¦^­È: an array ©w¸q¦b articles.class.php Àɮפ§²Ä 758 ¦æ. °Ñ¦Ò $articleId, $query, $result, Model::Execute(), ¤Î Model::getPrefix(). ³Q°Ñ¦Ò©ó _fillArticleInformation(). { $prefix = $this->getPrefix(); $query = "SELECT text,topic FROM {$prefix}articles_text WHERE article_id = '".Db::qstr($articleId)."'"; $result = $this->Execute( $query ); if( !$result ) return false; $row = $result->FetchRow(); $result->Close(); return( $row ); }

Articles::getBlogArticle (  $  artId, $  blogId = -1, $  includeHiddenFields = true, $  date = -1, $  categoryId = -1, $  userId = -1, $  status = POST_STATUS_ALL, $  maxDate = -1 )

Gets an article from the database, given its id °Ñ¼Æ: artId  Identifier of the article we want to fetch blogId  If set, the article must belong to the given blog ¶Ç¦^­È: Returns an Article object or 'false' otherwise. ©w¸q¦b articles.class.php Àɮפ§²Ä 94 ¦æ. °Ñ¦Ò $date, $query, _getBlogArticleFromQuery(), ¤Î Model::getPrefix(). { $prefix = $this->getPrefix(); $query = "SELECT a.id, a.date, a.user_id,a.blog_id,a.status,a.properties, a.num_reads, a.slug FROM {$prefix}articles a "; // thanks jon for the tip :) You're right that the amount of rows will be too big if we don't really need these // fields! if($categoryId != -1 && $blogId != -1) { $query .= ", {$prefix}articles_categories c, {$prefix}article_categories_link l "; } $query .= "WHERE a.id = ".Db::qstr($artId); if( $blogId != -1 ) $query .= " AND a.blog_id = ".Db::qstr($blogId); if( $date != -1 && $maxDate == -1 ) { $query .= " AND a.date+0 LIKE '$date%'"; } elseif ( $date != -1 && $maxDate != -1 ) { $query .= " AND a.date+0 >= $date AND a.date+0 <= $maxDate"; } if( $userId != -1 ) $query .= " AND a.user_id = ".Db::qstr($userId); if( $categoryId != -1 ) $query .= " AND c.id = ".Db::qstr($categoryId)." AND c.id = l.category_id AND a.id = l.article_id"; if( $status != POST_STATUS_ALL ) $query .= " AND a.status = $status;"; return $this->_getBlogArticleFromQuery( $query, $includeHiddenFields ); }

Articles::getBlogArticleByTitle (  $  artTitle, $  blogId = -1, $  includeHiddenFields = true, $  date = -1, $  categoryId = -1, $  userId = -1, $  status = POST_STATUS_PUBLISHED, $  maxDate = -1 )

Gets an article from the database, given its slug, this is used with the fancy permalinks °Ñ¼Æ: artTitle  Identifier of the article we want to fetch blogId  If set, the article must belong to the given blog ¶Ç¦^­