public static function newFromUrl($url, $langCode, $dbType) { $url = str_replace('http://www.wikihow.com/', '', $url); $pageTitle = Misc::getUrlDecodedData($url); $row = self::getDBRowFromPageTitle($pageTitle, $langCode, $dbType); return is_null($row) ? null : BabelfishArticle::newFromDBRow($row, $dbType); }
private function getTranslatedArticles($moreWhere, $lang) { $where = array('tl_from_lang' => 'en', 'tl_to_lang' => $lang, "tl_from_aid = ct_page_id", "tl_to_lang = ct_lang_code"); $where[] = $moreWhere; $dbr = wfGetDB(DB_SLAVE); $res = $dbr->select(array('translation_link', 'babelfish_articles'), array('babelfish_articles.*'), $where, __METHOD__); $articles = array(); foreach ($res as $row) { $articles[] = BabelfishArticle::newFromDBRow($row, $this->dbType); } return $articles; }