function countNotExternal()
{
$dbr = wfGetDB(DB_SLAVE, "dpl");
/**
* get active databases from city_list
*/
$databases = array();
$res = $dbr->select(WikiFactory::table("city_list"), array("city_dbname", "city_id"), array("city_public" => 1), __FUNCTION__);
while ($row = $dbr->fetchObject($res)) {
$databases[$row->city_id] = $row->city_dbname;
}
$dbr->freeResult($res);
foreach ($databases as $city_id => $database) {
$sql = "\n\t\t\tSELECT count(*) as count\n\t\t\tFROM revision r1 FORCE INDEX (PRIMARY), text t2\n\t\t\tWHERE old_id = rev_text_id\n\t\t\tAND old_flags NOT LIKE '%external%'\n\t\t";
$dbr->selectDB($database);
$dbr->begin();
$res = $dbr->query($sql, __FUNCTION__);
$row = $dbr->fetchObject($res);
if (!empty($row->count)) {
printf("Not External rows in %5d %30s = %8d\n", $city_id, $database, $row->count);
}
$dbr->freeResult($res);
$dbr->commit();
}
}
* @package MediaWiki
* @addtopackage maintenance
*
* clear wikifactory variables cache
*
* Usage:
* (particular wiki)
* SERVER_ID=<city_id_from_city_list> php maintenance/wikia/clear_wikifactory_cache.php
*
* or
* (whole cache, all wikis)
* SERVER_ID=177 php maintenance/wikia/clear_wikifactory_cache.php --all
*/
ini_set("include_path", dirname(__FILE__) . "/..");
require_once "commandLine.inc";
$all = isset($options["all"]) ? $options["all"] : false;
if (!$all) {
WikiFactory::clearCache($wgCityId);
printf("%s removing %5d:%s from cache\n", wfTimestamp(TS_DB, time()), $wgCityId, $wgDBname);
} else {
/**
* iterate through city_list
*/
$dbr = WikiFactory::db(DB_SLAVE);
$res = $dbr->select(WikiFactory::table("city_list"), array("city_id", "city_dbname"), array("city_public" => 1), __FILE__, array("ORDER BY" => "city_id"));
while ($row = $dbr->fetchObject($res)) {
WikiFactory::clearCache($row->city_id);
printf("%s removing %5d:%s from cache\n", wfTimestamp(TS_DB, time()), $row->city_id, $row->city_dbname);
}
$dbr->close();
}
$quiet = isset($options['quiet']);
$conds = array(
'ug_group' => 'heper',
'ug_user' => array('96953') //see RT#67513, RT#131567
);
$dbr = WikiFactory::db(DB_MASTER);
/**
* get active databases from city_list
*/
$databases = array();
$res = $dbr->select(
WikiFactory::table('city_list'),
array('city_dbname', 'city_id'),
array('city_public' => 1, 'city_useshared' => 1),
__FUNCTION__
);
while ($row = $dbr->fetchObject($res)) {
$databases[$row->city_id] = $row->city_dbname;
}
$dbr->freeResult($res);
foreach ($databases as $city_id => $database) {
//skip central (global user rights)
if ( in_array( $city_id, array( 177 ) ) ) {
continue;
}
require_once dirname(__FILE__) . '/../commandLine.inc';
$time_start = microtime(true);
$dbr = wfGetDB(DB_SLAVE);
$dbw = wfGetDB(DB_MASTER, array(), $wgExternalSharedDB);
// get messages with city = NULL
echo "#1: Get list of shoutbox messages not yet converted from host name to cityId\n";
$messages = $dbw->select('shout_box_messages', array('id', 'wikia'), array('city' => NULL), 'shoutbox_host_to_city_id');
// update city value
echo "#2: Update each message (set city value based on hostname)\n";
$messagesCount = 0;
while ($msg = $dbr->fetchObject($messages)) {
$url = "http://{$msg->wikia}/";
switch ($url) {
case 'http://wikia.com/':
$city = 177;
break;
default:
$city = $dbr->selectField(WikiFactory::table('city_list'), array('city_id'), array('city_url' => $url), 'shoutbox_host_to_city_id');
}
if (is_numeric($city)) {
$dbw->update('shout_box_messages', array('city' => $city), array('id' => $msg->id), 'shoutbox_host_to_city_id');
$messagesCount++;
echo "\t{$url} -> {$city}\n";
} else {
echo "\t{$url} -> ERROR!\n";
}
}
// make sure we commit transaction
$dbw->commit();
$time = microtime(true) - $time_start;
echo "#3: Updated " . $messagesCount . " messages. Execution time: {$time} seconds\n";
/**
* getQueryInfo
*
* get default field for sorting
*
* @return array: query info
*/
function getQueryInfo()
{
$query = array("tables" => array(WikiFactory::table("city_list_log"), WikiFactory::table("city_list")), "fields" => array("*"), "conds" => array(WikiFactory::table("city_list", "city_id") . " = " . WikiFactory::table("city_list_log", "cl_city_id")));
if ($this->mWikiId) {
$query["conds"][] = WikiFactory::table("city_list", "city_id") . " = " . $this->mWikiId;
}
$variable = $this->getRequest()->getInt('variable');
if ($variable > 0) {
$query['conds'][] = WikiFactory::table('city_list_log', 'cl_type') . '=' . WikiFactory::LOG_VARIABLE;
$query['conds'][] = WikiFactory::table('city_list_log', 'cl_var_id') . '=' . $variable;
}
return $query;
}
<?php
/**
* @package MediaWiki
* @addtopackage maintenance
* @author eloy@wikia
*
* dump wikifactory variables as php values
*
*/
ini_set("include_path", dirname(__FILE__) . "/..");
require_once "commandLine.inc";
$dbr = WikiFactory::db(DB_SLAVE);
echo "<?php\n\n";
$oRes = $dbr->select(array(WikiFactory::table("city_variables"), WikiFactory::table("city_variables_pool")), array("*"), array("cv_city_id" => $wgCityId, "cv_variable_id = cv_id"), __FILE__);
while ($oRow = $dbr->fetchObject($oRes)) {
echo '$' . "{$oRow->cv_name} = ";
echo var_export(unserialize($oRow->cv_value));
echo ";\n";
}
* @package MediaWiki
* @subpackage Maintanance
*
*/
require_once '../commandLine.inc';
if (isset($options['help'])) {
die("Usage: php removeUserRightsOnLocalDB.php [--quiet]\n\n\t\t --help you are reading it right now\n\t\t --quiet do not print anything to output\n\n");
}
$quiet = isset($options['quiet']);
$conds = array('ug_group' => 'heper', 'ug_user' => array('96953'));
$dbr = WikiFactory::db(DB_MASTER);
/**
* get active databases from city_list
*/
$databases = array();
$res = $dbr->select(WikiFactory::table('city_list'), array('city_dbname', 'city_id'), array('city_public' => 1, 'city_useshared' => 1), __FUNCTION__);
while ($row = $dbr->fetchObject($res)) {
$databases[$row->city_id] = $row->city_dbname;
}
$dbr->freeResult($res);
foreach ($databases as $city_id => $database) {
//skip central (global user rights)
if (in_array($city_id, array(177))) {
continue;
}
if (!$quiet) {
echo "Connecting to wiki (ID:{$city_id}, dbname:{$database})\n";
}
$dbw = wfGetDB(DB_MASTER, array(), $database);
$dbw->delete('user_groups', $conds, __FUNCTION__);
$dbw->close();
/**
* getQueryInfo
*
* get default field for sorting
*
* @return array: query info
*/
function getQueryInfo()
{
$query = array("tables" => array(WikiFactory::table("city_list_log"), WikiFactory::table("city_list")), "fields" => array("*"), "conds" => array(WikiFactory::table("city_list", "city_id") . " = " . WikiFactory::table("city_list_log", "cl_city_id")));
if ($this->mWikiId) {
$query["conds"][] = WikiFactory::table("city_list", "city_id") . " = " . $this->mWikiId;
}
return $query;
}
