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