/** * 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); }