private function getTag()
{
$dbname = F::app()->wg->DBname;
$t = F::app()->wg->Title;
$title = $t->getText();
if ($dbname == 'dehauptseite') {
if (Wikia::isMainPage()) {
return 'RC_WIKIA_HOME';
}
if (strpos($title, 'Mobil') === 0) {
return 'RC_WIKIA_MOBIL';
}
if (in_array($title, array('Videospiele', 'Entertainment', 'Lifestyle'))) {
return 'RC_WIKIA_START';
}
if (WikiaPageType::getPageType() == 'search') {
return 'RC_WIKIA_SEARCH';
}
return 'RC_WIKIA_SVCE';
}
if ($dbname == 'de') {
if ($t->getNamespace() == NS_FORUM) {
return 'RC_WIKIA_PIN';
}
return 'RC_WIKIA_COMMUNITY';
}
if (HubService::getComscoreCategory(F::app()->wg->CityId)->cat_name == 'Entertainment') {
return 'RC_WIKIA_UGCENT';
}
return 'RC_WIKIA_UGC';
}
private function getHub() {
wfProfileIn( __METHOD__ );
global $wgCityId;
$catInfo = HubService::getComscoreCategory($wgCityId);
//i18n
if (!empty($catInfo)) {
$catInfo->cat_link = wfMsg('oasis-corporatefooter-hub-'. $catInfo->cat_name .'-link');
$catInfo->cat_name = wfMsg('hub-'. $catInfo->cat_name);
}
wfProfileOut( __METHOD__ );
return $catInfo;
}
function wfAdEngineSetupTopVars(&$vars)
{
global $wgCityId, $wgEnableKruxTargeting, $wgNoExternals;
wfProfileIn(__METHOD__);
// generic type of page: forum/search/article/home/...
$vars['wikiaPageType'] = WikiaPageType::getPageType();
// category/hub
$catInfo = HubService::getComscoreCategory($wgCityId);
$vars['cscoreCat'] = $catInfo->cat_name;
// Krux
$cat = AdEngine::getCachedCategory();
if (!empty($wgEnableKruxTargeting) && empty($wgNoExternals)) {
$vars['wgEnableKruxTargeting'] = $wgEnableKruxTargeting;
$vars['wgKruxCategoryId'] = WikiFactoryHub::getInstance()->getKruxId($cat['id']);
}
wfProfileOut(__METHOD__);
return true;
}
public static function onOutputPageBeforeHTML($out, $text)
{
$category = HubService::getComscoreCategory(F::app()->wg->cityId);
switch ($category->cat_id) {
case WikiFactoryHub::CATEGORY_ID_ENTERTAINMENT:
$categoryName = 'WikiaHubsEntertainment';
break;
case WikiFactoryHub::CATEGORY_ID_GAMING:
$categoryName = 'WikiaHubsVideoGames';
break;
case WikiFactoryHub::CATEGORY_ID_LIFESTYLE:
$categoryName = 'WikiaHubsLifestyle';
break;
default:
$categoryName = 'Wikia';
break;
}
OasisController::addBodyClass($categoryName);
return true;
}
private function getC7Value()
{
global $wgCityId;
$catInfo = HubService::getComscoreCategory($wgCityId);
return 'wikiacsid_' . strtolower($catInfo->cat_name);
}
public function loadDataAndUpdateDatabase() {
global $wgCityId;
wfProfileIn(__METHOD__);
if( !$this->options->overwrittenLang ) {
$wikisVisualizationLangCode = WikiFactory::getVarValueByName('wgLanguageCode', $wgCityId);
} else {
$wikisVisualizationLangCode = $this->options->overwrittenLang;
}
echo "\n";
echo 'Uploading wikis for "'.$wikisVisualizationLangCode.'" visualization: ';
echo "\n";
foreach( $this->options->csvContent as $line ) {
$element = str_getcsv($line, ',', '"');
if( $this->areAllRequiredWikiDataForDatabaseSet($element) ) {
$wikiDomain = trim( str_replace('http://', '', $element[2]), '/');
$wikiId = WikiFactory::DomainToID($wikiDomain);
$spreadSheetImageName = basename($element[4]);
$wikiMainImageUrl = $element[4];
$wikiMainImageName = $this->getCorpDestImageName($wikiDomain, $spreadSheetImageName);
$sliderImages = $this->getSliderImages( array_slice($element, self::SPREADSHEET_FIRST_ADD_IMG_IDX, self::SPREADSHEET_LAST_ADD_IMG_IDX) );
$wikiHeadline = !empty($element[1]) ? $element[1] : '';
$wikiDesc = !empty($element[5]) ? $element[5] : wfMsg( 'wikiahome-import-script-no-description' );
if( !$this->options->skipUpload ) {
//upload main image
$this->uploadImage($wikiMainImageUrl, $wikiMainImageName, $wikiId);
//upload slider images
$sliderUploadedImages = $this->uploadSliderImages($wikiDomain, $sliderImages, $wikiId);
}
if( $wikiId > 0 ) {
$wikiCityVertical = HubService::getComscoreCategory($wikiId);
$sliderUploadedImages = (!empty($sliderUploadedImages)) ? json_encode($sliderUploadedImages) : null;
$this->addToVisualizationTable(
array(
'city_id' => $wikiId,
'city_lang_code' => $wikisVisualizationLangCode,
'city_vertical' => $wikiCityVertical,
'city_headline' => $wikiHeadline,
'city_description' => $wikiDesc,
'city_main_image' => $wikiMainImageName,
'city_images' => $sliderUploadedImages,
)
);
} else {
$this->wikisNotAdded[] = $wikiDomain.' ('.$wikiId.') ';
}
}
}
$this->uploadImagesOnWikis();
$this->displayStatus();
wfProfileOut(__METHOD__);
}
public function getWikisForStaffTool($opt)
{
//todo: implement memc and purge it once admin changes data or main image is approved
//todo: add sql join and instead of headline provide wiki name
$db = $this->wf->GetDB(DB_SLAVE, array(), $this->wg->ExternalSharedDB);
$table = array('city_visualization', 'city_list');
$fields = array('city_visualization.city_id', 'city_visualization.city_vertical', 'city_list.city_title', 'city_visualization.city_flags');
$conds = $this->getConditionsForStaffTool($opt);
$options = $this->getOptionsForStaffTool($opt);
$joinConds = array('city_list' => array('join', 'city_list.city_id = city_visualization.city_id'));
$results = $db->select($table, $fields, $conds, __METHOD__, $options, $joinConds);
$wikis = array();
while ($row = $db->fetchObject($results)) {
$category = HubService::getComscoreCategory($row->city_id);
$row->city_vertical = $category->cat_name;
$wikis[] = $row;
}
return $wikis;
}
