/**
* Constructor
* @todo Document $par parameter.
* @param $par String: FIXME
*/
function wfSpecialWatchlist($par)
{
global $wgUser, $wgOut, $wgLang, $wgMemc, $wgRequest, $wgContLang;
global $wgUseWatchlistCache, $wgWLCacheTimeout, $wgDBname;
global $wgRCShowWatchingUsers, $wgEnotifWatchlist, $wgShowUpdatedMarker;
global $wgEnotifWatchlist;
$fname = 'wfSpecialWatchlist';
$skin =& $wgUser->getSkin();
$specialTitle = Title::makeTitle(NS_SPECIAL, 'Watchlist');
$wgOut->setRobotPolicy('noindex,nofollow');
# Anons don't get a watchlist
if ($wgUser->isAnon()) {
$wgOut->setPageTitle(wfMsg('watchnologin'));
$llink = $skin->makeKnownLinkObj(Title::makeTitle(NS_SPECIAL, 'Userlogin'), wfMsgHtml('loginreqlink'), 'returnto=' . $specialTitle->getPrefixedUrl());
$wgOut->addHtml(wfMsgWikiHtml('watchlistanontext', $llink));
return;
} else {
$wgOut->setPageTitle(wfMsg('watchlist'));
$wgOut->setSubtitle(wfMsgWikiHtml('watchlistfor', htmlspecialchars($wgUser->getName())));
}
if (wlHandleClear($wgOut, $wgRequest, $par)) {
return;
}
$defaults = array('days' => floatval($wgUser->getOption('watchlistdays')), 'hideOwn' => (int) $wgUser->getBoolOption('watchlisthideown'), 'hideBots' => (int) $wgUser->getBoolOption('watchlisthidebots'), 'namespace' => 'all');
extract($defaults);
# Extract variables from the request, falling back to user preferences or
# other default values if these don't exist
$prefs['days'] = floatval($wgUser->getOption('watchlistdays'));
$prefs['hideown'] = $wgUser->getBoolOption('watchlisthideown');
$prefs['hidebots'] = $wgUser->getBoolOption('watchlisthidebots');
# Get query variables
$days = $wgRequest->getVal('days', $prefs['days']);
$hideOwn = $wgRequest->getBool('hideOwn', $prefs['hideown']);
$hideBots = $wgRequest->getBool('hideBots', $prefs['hidebots']);
# Get namespace value, if supplied, and prepare a WHERE fragment
$nameSpace = $wgRequest->getIntOrNull('namespace');
if (!is_null($nameSpace)) {
$nameSpace = intval($nameSpace);
$nameSpaceClause = " AND rc_namespace = {$nameSpace}";
} else {
$nameSpace = '';
$nameSpaceClause = '';
}
# Watchlist editing
$action = $wgRequest->getVal('action');
$remove = $wgRequest->getVal('remove');
$id = $wgRequest->getArray('id');
$uid = $wgUser->getID();
if ($wgEnotifWatchlist && $wgRequest->getVal('reset') && $wgRequest->wasPosted()) {
$wgUser->clearAllNotifications($uid);
}
# Deleting items from watchlist
if ($action == 'submit' && isset($remove) && is_array($id)) {
$wgOut->addWikiText(wfMsg('removingchecked'));
$wgOut->addHTML('<p>');
foreach ($id as $one) {
$t = Title::newFromURL($one);
if (!is_null($t)) {
// WERELATE - run UnwatchArticle hooks; fix UnwatchArticle hook below to UnwatchArticleComplete
$article = new Article($t);
if (wfRunHooks('UnwatchArticle', array(&$wgUser, &$article))) {
$wl = WatchedItem::fromUserTitle($wgUser, $t);
if ($wl->removeWatch() === false) {
$wgOut->addHTML("<br />\n" . wfMsg('couldntremove', htmlspecialchars($one)));
} else {
wfRunHooks('UnwatchArticleComplete', array(&$wgUser, &$article));
$wgOut->addHTML(' (' . htmlspecialchars($one) . ')');
}
}
} else {
$wgOut->addHTML("<br />\n" . wfMsg('iteminvalidname', htmlspecialchars($one)));
}
}
$wgOut->addHTML("<br />\n" . wfMsg('wldone') . "</p>\n");
}
if ($wgUseWatchlistCache) {
$memckey = "{$wgDBname}:watchlist:id:" . $wgUser->getId();
$cache_s = @$wgMemc->get($memckey);
if ($cache_s) {
$wgOut->addWikiText(wfMsg('wlsaved'));
$wgOut->addHTML($cache_s);
return;
}
}
$dbr =& wfGetDB(DB_SLAVE);
extract($dbr->tableNames('page', 'revision', 'watchlist', 'recentchanges'));
$sql = "SELECT COUNT(*) AS n FROM {$watchlist} WHERE wl_user={$uid}";
$res = $dbr->query($sql, $fname);
$s = $dbr->fetchObject($res);
# Patch *** A1 *** (see A2 below)
# adjust for page X, talk:page X, which are both stored separately, but treated together
$nitems = floor($s->n / 2);
# $nitems = $s->n;
if ($nitems == 0) {
$wgOut->addWikiText(wfMsg('nowatchlist'));
return;
}
if (is_null($days) || !is_numeric($days)) {
$big = 1000;
/* The magical big */
// WERELATE - don't change default; pages don't change that often
// if($nitems > $big) {
# Set default cutoff shorter
// $days = $defaults['days'] = (12.0 / 24.0); # 12 hours...
// } else {
$days = $defaults['days'];
# default cutoff for shortlisters
// }
} else {
$days = floatval($days);
}
// Dump everything here
$nondefaults = array();
wfAppendToArrayIfNotDefault('days', $days, $defaults, $nondefaults);
wfAppendToArrayIfNotDefault('hideOwn', (int) $hideOwn, $defaults, $nondefaults);
wfAppendToArrayIfNotDefault('hideBots', (int) $hideBots, $defaults, $nondefaults);
wfAppendToArrayIfNotDefault('namespace', $nameSpace, $defaults, $nondefaults);
if ($days <= 0) {
$docutoff = '';
$cutoff = false;
$npages = wfMsg('watchlistall1');
} else {
$docutoff = "AND rev_timestamp > '" . ($cutoff = $dbr->timestamp(time() - intval($days * 86400))) . "'";
/*
$sql = "SELECT COUNT(*) AS n FROM $page, $revision WHERE rev_timestamp>'$cutoff' AND page_id=rev_page";
$res = $dbr->query( $sql, $fname );
$s = $dbr->fetchObject( $res );
$npages = $s->n;
*/
$npages = 40000 * $days;
}
/* Edit watchlist form */
if ($wgRequest->getBool('edit') || $par == 'edit') {
$wgOut->addWikiText(wfMsg('watchlistcontains', $wgLang->formatNum($nitems)) . "\n\n" . wfMsg('watcheditlist'));
$wgOut->addHTML('<form action=\'' . $specialTitle->escapeLocalUrl('action=submit') . "' method='post'>\n");
# Patch A2
# The following was proposed by KTurner 07.11.2004 to T.Gries
# $sql = "SELECT distinct (wl_namespace & ~1),wl_title FROM $watchlist WHERE wl_user=$uid";
$sql = "SELECT wl_namespace, wl_title, page_is_redirect FROM {$watchlist} LEFT JOIN {$page} ON wl_namespace = page_namespace AND wl_title = page_title WHERE wl_user={$uid}";
$res = $dbr->query($sql, $fname);
# Batch existence check
$linkBatch = new LinkBatch();
while ($row = $dbr->fetchObject($res)) {
$linkBatch->addObj(Title::makeTitleSafe($row->wl_namespace, $row->wl_title));
}
$linkBatch->execute();
if ($dbr->numRows($res) > 0) {
$dbr->dataSeek($res, 0);
}
# Let's do the time warp again!
$sk = $wgUser->getSkin();
$list = array();
while ($s = $dbr->fetchObject($res)) {
$list[$s->wl_namespace][$s->wl_title] = $s->page_is_redirect;
}
// TODO: Display a TOC
foreach ($list as $ns => $titles) {
if (Namespac::isTalk($ns)) {
continue;
}
if ($ns != NS_MAIN) {
$wgOut->addHTML('<h2>' . $wgContLang->getFormattedNsText($ns) . '</h2>');
}
$wgOut->addHTML('<ul>');
foreach ($titles as $title => $redir) {
$titleObj = Title::makeTitle($ns, $title);
if (is_null($titleObj)) {
$wgOut->addHTML('<!-- bad title "' . htmlspecialchars($s->wl_title) . '" in namespace ' . $s->wl_namespace . " -->\n");
} else {
global $wgContLang;
$toolLinks = array();
$titleText = $titleObj->getPrefixedText();
$pageLink = $sk->makeLinkObj($titleObj);
$toolLinks[] = $sk->makeLinkObj($titleObj->getTalkPage(), $wgLang->getNsText(NS_TALK));
if ($titleObj->exists()) {
$toolLinks[] = $sk->makeKnownLinkObj($titleObj, wfMsgHtml('history_short'), 'action=history');
}
$toolLinks = '(' . implode(' | ', $toolLinks) . ')';
$checkbox = '<input type="checkbox" name="id[]" value="' . htmlspecialchars($titleObj->getPrefixedText()) . '" /> ' . ($wgContLang->isRTL() ? '‏' : '‎');
if ($redir) {
$spanopen = '<span class="watchlistredir">';
$spanclosed = '</span>';
} else {
$spanopen = $spanclosed = '';
}
$wgOut->addHTML("<li>{$checkbox}{$spanopen}{$pageLink}{$spanclosed} {$toolLinks}</li>\n");
}
}
$wgOut->addHTML('</ul>');
}
$wgOut->addHTML("<input type='submit' name='remove' value=\"" . htmlspecialchars(wfMsg("removechecked")) . "\" />\n" . "</form>\n");
return;
}
# If the watchlist is relatively short, it's simplest to zip
# down its entirety and then sort the results.
# If it's relatively long, it may be worth our while to zip
# through the time-sorted page list checking for watched items.
# Up estimate of watched items by 15% to compensate for talk pages...
# Toggles
$andHideOwn = $hideOwn ? "AND (rc_user <> {$uid})" : '';
$andHideBots = $hideBots ? "AND (rc_bot = 0)" : '';
# Show watchlist header
$header = '';
if ($wgUser->getOption('enotifwatchlistpages') && $wgEnotifWatchlist) {
$header .= wfMsg('wlheader-enotif') . "\n";
}
if ($wgEnotifWatchlist && $wgShowUpdatedMarker) {
$header .= wfMsg('wlheader-showupdated') . "\n";
}
# Toggle watchlist content (all recent edits or just the latest)
if ($wgUser->getOption('extendwatchlist')) {
$andLatest = '';
$limitWatchlist = 'LIMIT ' . intval($wgUser->getOption('wllimit'));
} else {
$andLatest = 'AND rc_this_oldid=page_latest';
$limitWatchlist = '';
}
# TODO: Consider removing the third parameter
$header .= wfMsg('watchdetails', $wgLang->formatNum($nitems), $wgLang->formatNum($npages), '', $specialTitle->getFullUrl('edit=yes'));
$wgOut->addWikiText($header);
if ($wgEnotifWatchlist && $wgShowUpdatedMarker) {
$wgOut->addHTML('<form action="' . $specialTitle->escapeLocalUrl() . '" method="post"><input type="submit" name="dummy" value="' . htmlspecialchars(wfMsg('enotif_reset')) . '" /><input type="hidden" name="reset" value="all" /></form>' . "\n\n");
}
// WERELATE - handle changed view
if ($wgRequest->getBool('changed') || $par == 'changed') {
$wgOut->addHTML('<hr /><h2>All pages changed since last visited</h2><ul><li><a href="' . $specialTitle->getFullUrl() . '">Show recently-changed pages</a></li></ul>');
$sql = 'select wl_namespace, wl_title from watchlist where wl_user='******' and wl_notificationtimestamp > \'0\'';
$res = $dbr->query($sql, $fname);
$sk = $wgUser->getSkin();
$changed = '';
$count = 0;
while ($obj = $dbr->fetchObject($res)) {
$t = Title::makeTitle($obj->wl_namespace, $obj->wl_title);
$historylink = $sk->makeKnownLinkObj($t, 'hist', wfArrayToCGI(array('action' => 'history')));
$articlelink = $sk->makeKnownLinkObj($t);
$changed .= "<li> ( {$historylink} ) . . {$articlelink}</li>\n";
$count += 1;
}
$dbr->freeResult($res);
$wgOut->addHTML("<h3>{$count} page(s)</h3>\n<ul>" . $changed . '</ul>');
return;
}
// WERELATE - remove join with page table
$sql = "SELECT\n\t rc_namespace AS page_namespace, rc_title AS page_title,\n\t rc_comment AS rev_comment, rc_cur_id AS page_id,\n\t rc_user AS rev_user, rc_user_text AS rev_user_text,\n\t rc_timestamp AS rev_timestamp, rc_minor AS rev_minor_edit,\n\t rc_this_oldid AS rev_id,\n\t rc_last_oldid, rc_id, rc_patrolled,\n\t rc_new AS page_is_new,wl_notificationtimestamp\n\t FROM {$watchlist},{$recentchanges}\n\t WHERE wl_user={$uid}\n\t AND wl_namespace=rc_namespace\n\t AND wl_title=rc_title\n\t AND rc_timestamp > '{$cutoff}'\n\t {$andHideOwn}\n\t {$andHideBots}\n\t {$nameSpaceClause}\n\t ORDER BY rc_timestamp DESC\n\t {$limitWatchlist}";
$res = $dbr->query($sql, $fname);
// WERELATE - moved up from below so we can calculate $numRows inside the loop
// $numRows = $dbr->numRows( $res );
$numRows = 0;
$list = ChangesList::newFromUser($wgUser);
$rcs = $list->beginRecentChangesList();
$counter = 1;
// WERELATE - added array of seen pagetitles
$seen = array();
while ($obj = $dbr->fetchObject($res)) {
$nsTitle = "{$obj->page_namespace}:{$obj->page_title}";
if (!$andLatest || !isset($seen[$nsTitle])) {
$seen[$nsTitle] = 1;
$numRows++;
# Make fake RC entry
$rc = RecentChange::newFromCurRow($obj, $obj->rc_last_oldid);
$rc->counter = $counter++;
if ($wgShowUpdatedMarker) {
$updated = $obj->wl_notificationtimestamp;
} else {
// Same visual appearance as MW 1.4
$updated = true;
}
if ($wgRCShowWatchingUsers && $wgUser->getOption('shownumberswatching')) {
$sql3 = "SELECT COUNT(*) AS n FROM {$watchlist} WHERE wl_title='" . wfStrencode($obj->page_title) . "' AND wl_namespace='{$obj->page_namespace}'";
$res3 = $dbr->query($sql3, DB_READ, $fname);
$x = $dbr->fetchObject($res3);
$rc->numberofWatchingusers = $x->n;
} else {
$rc->numberofWatchingusers = 0;
}
$rcs .= $list->recentChangesLine($rc, $updated);
}
}
$rcs .= $list->endRecentChangesList();
$dbr->freeResult($res);
/* Start bottom header */
// WERELATE - add link to changed view
// $wgOut->addHTML( "<hr />\n<p>" );
$wgOut->addHTML('<hr /><h2>Recently-changed pages</h2><ul><li><a href="' . $specialTitle->getFullUrl('changed=yes') . '">Show all pages changed since last visited</a></li></ul><br/><p>');
if ($days >= 1) {
$wgOut->addWikiText(wfMsg('rcnote', $wgLang->formatNum($numRows), $wgLang->formatNum($days), $wgLang->timeAndDate(wfTimestampNow(), true)) . '<br />', false);
} elseif ($days > 0) {
$wgOut->addWikiText(wfMsg('wlnote', $wgLang->formatNum($numRows), $wgLang->formatNum(round($days * 24))) . '<br />', false);
}
$wgOut->addHTML("\n" . wlCutoffLinks($days, 'Watchlist', $nondefaults) . "<br />\n");
# Spit out some control panel links
$thisTitle = Title::makeTitle(NS_SPECIAL, 'Watchlist');
$skin = $wgUser->getSkin();
$linkElements = array('hideOwn' => 'wlhideshowown', 'hideBots' => 'wlhideshowbots');
# Problems encountered using the fancier method
$label = $hideBots ? wfMsgHtml('show') : wfMsgHtml('hide');
$linkBits = wfArrayToCGI(array('hideBots' => 1 - (int) $hideBots), $nondefaults);
$link = $skin->makeKnownLinkObj($thisTitle, $label, $linkBits);
$links[] = wfMsgHtml('wlhideshowbots', $link);
$label = $hideOwn ? wfMsgHtml('show') : wfMsgHtml('hide');
$linkBits = wfArrayToCGI(array('hideOwn' => 1 - (int) $hideOwn), $nondefaults);
$link = $skin->makeKnownLinkObj($thisTitle, $label, $linkBits);
$links[] = wfMsgHtml('wlhideshowown', $link);
$wgOut->addHTML(implode(' | ', $links));
# Form for namespace filtering
$thisAction = $thisTitle->escapeLocalUrl();
$nsForm = "<form method=\"post\" action=\"{$thisAction}\">\n";
$nsForm .= "<label for=\"namespace\">" . wfMsgExt('namespace', array('parseinline')) . "</label> ";
$nsForm .= HTMLnamespaceselector($nameSpace, '') . "\n";
$nsForm .= $hideOwn ? "<input type=\"hidden\" name=\"hideown\" value=\"1\" />\n" : "";
$nsForm .= $hideBots ? "<input type=\"hidden\" name=\"hidebots\" value=\"1\" />\n" : "";
$nsForm .= "<input type=\"hidden\" name=\"days\" value=\"" . $days . "\" />\n";
$nsForm .= "<input type=\"submit\" name=\"submit\" value=\"" . wfMsgExt('allpagessubmit', array('escape')) . "\" />\n";
$nsForm .= "</form>\n";
$wgOut->addHTML($nsForm);
if ($numRows == 0) {
$wgOut->addWikitext("<br />" . wfMsg('watchnochange'), false);
$wgOut->addHTML("</p>\n");
return;
}
$wgOut->addHTML("</p>\n");
/* End bottom header */
// WERELATE - change $s to $rcs
$wgOut->addHTML($rcs);
if ($wgUseWatchlistCache) {
$wgMemc->set($memckey, $s, $wgWLCacheTimeout);
}
}
function renderRss($input)
{
global $wgOutputEncoding;
$DefaultEncoding = "ISO-8859-1";
$VersionNote = "Mediawiki rss extension by mutante, Duesentrieb, Rdb and Mafs";
$VersionLink = "http://meta.wikimedia.org/wiki/User:Mafs/RSS";
$VersionNo = "0.1";
$DisableCache = true;
if (!$input) {
return "";
}
#if <rss>-section is empty, return nothing
#parse fields in rss-section
$fields = explode("|", $input);
$url = @$fields[0];
$args = array();
for ($i = 1; $i < sizeof($fields); $i++) {
$f = $fields[$i];
if (strpos($f, "=") === False) {
$args[strtolower(trim($f))] = False;
} else {
list($k, $v) = explode("=", $f, 2);
if (trim($v) == False) {
$args[strtolower(trim($k))] = False;
} else {
$args[strtolower(trim($k))] = trim($v);
}
}
}
#get charset from argument-array
$charset = @$args["charset"];
if (!$charset) {
$charset = $DefaultEncoding;
}
#get max number of headlines from argument-array
$maxheads = @$args["max"];
$headcnt = 0;
#get short-flag from argument-array
#if short is set, no description text is printed
if (isset($args["short"])) {
$short = True;
} else {
$short = False;
}
#get reverse-flag from argument-array
if (isset($args["reverse"])) {
$reverse = True;
} else {
$reverse = False;
}
#get version-flag from argument-array
if (isset($args["version"])) {
$DisplayVersion = True;
} else {
$DisplayVersion = False;
}
#get highlight terms from argument-array
$rssHighlight = @$args["highlight"];
$rssHighlight = str_replace(" ", " ", $rssHighlight);
$rssHighlight = explode(" ", trim($rssHighlight));
#get filter terms from argument-array
$rssFilter = @$args["filter"];
$rssFilter = str_replace(" ", " ", $rssFilter);
$rssFilter = explode(" ", trim($rssFilter));
#fetch rss. may be cached locally.
#Refer to the documentation of magpie for details.
$rss = @fetch_rss($url);
#check for errors.
if ($rss->ERROR) {
return "<div>Failed to load RSS feed from {$url}: " . $rss->ERROR . "</div>";
#localize...
}
if (!is_array($rss->items)) {
return "<div>Failed to load RSS feed from {$url}!</div>";
#localize...
}
#Bild title line
$title = iconv($charset, $wgOutputEncoding, $rss->channel['title']);
if (isset($rss->channel['link'])) {
$title = "<a href='" . $rss->channel['link'] . "'>{$title}</a>";
}
$output = "<h3>{$title}</h3>";
if ($reverse) {
$rss->items = array_reverse($rss->items);
}
$description = False;
foreach ($rss->items as $item) {
if (isset($item['description'])) {
$description = True;
break;
}
}
#Bild items
if (!$short and $description) {
#full item list
$output .= "<dl>";
foreach ($rss->items as $item) {
$d_text = true;
$d_title = true;
$href = trim(iconv($charset, $wgOutputEncoding, $item['link']));
$title = trim(iconv($charset, $wgOutputEncoding, $item['title']));
$d_title = wfRssFilter($title, $rssFilter);
$title = wfRssHighlight($title, $rssHighlight);
#bild description text if desired
if ($item["description"]) {
$text = trim(iconv($charset, $wgOutputEncoding, $item['description']));
#avoid pre-tags
$text = str_replace("\r", " ", $text);
$text = str_replace("\n", " ", $text);
$text = str_replace("\t", " ", $text);
$d_text = wfRssFilter($text, $rssFilter);
$text = wfRssHighlight($text, $rssHighlight);
$display = $d_text or $d_title;
} else {
$text = "";
$display = $d_title;
}
if ($display) {
$output .= "<dt><a href='{$href}'>{$title}</a></dt>";
if ($text) {
$output .= "<dd>{$text}</dd>\n";
}
}
#Cut off output when maxheads is reached:
if (++$headcnt == $maxheads) {
break;
}
}
$output .= "</dl>";
} else {
#short item list
$output .= "<ul>";
foreach ($rss->items as $item) {
$href = trim(iconv($charset, $wgOutputEncoding, $item['link']));
$title = trim(iconv($charset, $wgOutputEncoding, $item['title']));
$d_title = wfRssFilter($title, $rssFilter);
$title = wfRssHighlight($title, $rssHighlight);
if ($d_title) {
$output .= "<li><a href='{$href}'>{$title}</a></li>";
}
#Cut off output when maxheads is reached:
if (++$headcnt == $maxheads) {
break;
}
}
$output .= "</ul>";
}
if ($DisableCache) {
global $wgVersion;
# Do not cache this wiki page.
# for details see http://public.kitware.com/Wiki/User:Barre/MediaWiki/Extensions
global $wgTitle, $wgDBprefix;
$ts = mktime();
$now = gmdate("YmdHis", $ts + 120);
$ns = $wgTitle->getNamespace();
$ti = wfStrencode($wgTitle->getDBkey());
$version = preg_replace("/^([1-9]).([1-9]).*/", "\\1\\2", $wgVersion);
if ($version > 14) {
$sql = "UPDATE {$wgDBprefix}" . "page SET page_touched='{$now}' WHERE page_namespace={$ns} AND page_title='{$ti}'";
} else {
$sql = "UPDATE {$wgDBprefix}" . "cur SET cur_touched='{$now}' WHERE cur_namespace={$ns} AND cur_title='{$ti}'";
}
wfQuery($sql, DB_WRITE, "");
}
$VersionText = "";
if ($VersionNote) {
$VersionText = $VersionNote;
}
if ($VersionLink and $VersionNo) {
$VersionText = $VersionText . " - <a href=\"{$VersionLink}\" title=\"{$VersionLink}\">version {$VersionNo}</a>.";
}
if (!$VersionLink and $VersionNo) {
$VersionText = $VersionText . " - version {$VersionNo}.";
}
if ($DisplayVersion and $VersionText) {
$output = $output . "<div style=\"background-color: #E0E0E0; font-weight: bold; font-size: 60%; padding: 0em 0.5em 0em 0.5em;\" >{$VersionText}</div>";
}
return $output;
}
function getData($user = -1, $title = "", $type = -1)
{
$ret = array();
$sql = array();
if ($user != -1) {
$sql[] = "val_user='******'";
}
if ($type != -1) {
$sql[] = "val_type='" . wfStrencode($type) . "'";
}
if ($title != "") {
$sql[] = "val_title='" . wfStrencode($title) . "'";
}
$sql = implode(" AND ", $sql);
if ($sql != "") {
$sql = " WHERE " . $sql;
}
$sql = "SELECT * FROM validate" . $sql;
$res = wfQuery($sql, DB_READ);
while ($s = wfFetchObject($res)) {
$ret["{$s->val_title}"]["{$s->val_timestamp}"]["{$s->val_type}"][] = $s;
}
return $ret;
}
<?php
#
# Print SQL to insert namespace names into database.
# This source code is in the public domain.
require_once "commandLine.inc";
for ($i = -2; $i < 16; ++$i) {
$nsname = wfStrencode($wgLang->getNsText($i));
$dbname = wfStrencode($wgDBname);
print "INSERT INTO ns_name(ns_db, ns_num, ns_name) VALUES('{$dbname}', {$i}, '{$nsname}');\n";
}
/**
*
*/
function wfSpecialMissingLanguageLinks()
{
global $wgUser, $wgOut, $wgContLang, $wgTitle, $wgRequest;
$fname = 'wfSpecialMissingLanguageLinks';
$thelang = $wgRequest->getText('thelang');
if ($thelang == 'w') {
$thelang = 'en';
}
# Fix for international wikis
list($limit, $offset) = wfCheckLimits();
$dbr =& wfGetDB(DB_SLAVE);
$cur = $dbr->tableName('cur');
$sql = "SELECT cur_title FROM {$cur} " . "WHERE cur_namespace=" . NS_MAIN . " AND cur_is_redirect=0 " . "AND cur_title NOT LIKE '%/%' AND cur_text NOT LIKE '%[[" . wfStrencode($thelang) . ":%' " . "LIMIT {$offset}, {$limit}";
$res = $dbr->query($sql, $fname);
$mll = wfMsg('missinglanguagelinkstext', $wgContLang->getLanguageName($thelang));
$top = getMaintenancePageBacklink('missinglanguagelinks');
$top .= "<p>{$mll}</p><br />";
$top .= wfShowingResults($offset, $limit);
$wgOut->addHTML("<p>{$top}\n");
$sl = wfViewPrevNext($offset, $limit, 'REPLACETHIS');
$sl = str_replace('REPLACETHIS', sns() . ":Maintenance&subfunction=missinglanguagelinks&thelang=" . htmlspecialchars($thelang), $sl);
$wgOut->addHTML("<br />{$sl}\n");
$sk = $wgUser->getSkin();
$s = '<ol start=' . ($offset + 1) . '>';
while ($obj = $dbr->fetchObject($res)) {
$s .= "<li>" . $sk->makeKnownLink($obj->cur_title) . "</li>\n";
}
$dbr->freeResult($res);
$s .= '</ol>';
$wgOut->addHTML($s);
$wgOut->addHTML("<p>{$sl}\n");
}
function fixUserOptions()
{
print "Fixing user options...";
$res = wfQuery("SELECT user_id,user_options FROM user", DB_MASTER);
$total = wfNumRows($res);
$n = 0;
print " ({$total} total)\n";
while ($row = wfFetchObject($res)) {
$id = intval($row->user_id);
$option = wfStrencode($this->rewriteUserOptions($row->user_options));
wfQuery("UPDATE user SET user_options='{$option}' WHERE user_id={$id} LIMIT 1", DB_MASTER);
if (++$n % 50 == 0) {
print "{$n}\n";
}
}
wfFreeResult($res);
}
