User:Bot1058/refreshlinks.php
Appearance
<?php
/** refreshlinks.php - Null-edit pages in order to refresh links which are old.
* Version 3.3
*
* (c) 2022–2024 WBM - http://wiki.riteme.site/wiki/User:Wbm1058
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
*
* Developers (add yourself here if you worked on the code):
* WBM - [[User:Wbm1058]] - v 2.0 May 2022 began operating from my desktop PC
* - v 3.0 February 2023 began operating on the Toolforge jobs framework
**/
ini_set("display_errors", 1);
error_reporting(E_ALL ^ E_NOTICE);
require_once 'botclasses.php'; // Botclasses.php was written by User:Chris_G and is available under the GNU General Public License
$AssumeHTTPFailuresAreJustTimeoutsAndShouldBeSuppressed = true;
include("logininfo.php");
const ds = 86400; #number of seconds in a day
const querylimit = 10000;
$querylimit = querylimit;
$ns = array_fill(0, 2301, "undefined");
$ns[0] = ":";
$ns[1] = "Talk:";
$ns[2] = "User:";
$ns[3] = "User talk:";
$ns[4] = "Wikipedia:";
$ns[5] = "Wikipedia talk:";
$ns[6] = "File:";
$ns[7] = "File talk:";
$ns[8] = "MediaWiki:";
$ns[9] = "MediaWiki talk:";
$ns[10] = "Template:";
$ns[11] = "Template talk:";
$ns[12] = "Help:";
$ns[13] = "Help talk:";
$ns[14] = "Category:";
$ns[15] = "Category talk:";
$ns[100] = "Portal:";
$ns[101] = "Portal talk:";
$ns[118] = "Draft:";
$ns[119] = "Draft talk:";
$ns[710] = "TimedText:";
$ns[711] = "TimedText talk:";
$ns[828] = "Module:";
$ns[829] = "Module talk:";
$ns[2300] = "Gadget:";
$ns[2301] = "Gadget talk:";
#print_r($ns);
echo "\nPHP version: " . PHP_VERSION . "\n";
login_again:
echo "\nLogging in...\n";
$objwiki = new wikipedia();
$objwiki->login($user, $pass);
echo "...done.\n";
doit_again:
$days_ago_to_refresh = file_get_contents('./php/refreshlinks.dar');
echo "\nDays ago to refresh: " . $days_ago_to_refresh . "\n";
$current_time = time();
$days_ago = $current_time - ds*$days_ago_to_refresh;
echo "Current time: " . $current_time . " (" . date("Y-m-d H:i:s", $current_time) . ")\n";
echo "Refresh time: " . $days_ago . " (" . date("Y-m-d H:i:s", $days_ago) . ")";
$days_ago = date("YmdHis", $days_ago);
echo " ==> " . $days_ago . "\n\n";
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("enwiki.analytics.db.svc.wikimedia.cloud", $toolforgeuser, $toolforgepass, "enwiki_p");
/* Tunnel the Toolforge database to local port 4711 – use when not on the cloud */
#$mysqli = new mysqli("127.0.0.1:4711", $toolforgeuser, $toolforgepass, "enwiki_p");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
echo "Connected to database\n";
$result = $mysqli->query("SELECT page_namespace, page_title FROM page WHERE page_links_updated < $days_ago LIMIT $querylimit");
print_r($result);
$rows = $result->fetch_all(MYSQLI_ASSOC);
#print_r($rows);
$namespaces = array_column($rows, 'page_namespace');
$titles = array_column($rows, 'page_title');
echo "\n" . count($titles) . " pages found needing links refreshed\n";
for ($i = 0; $i < count($titles); $i++) {
if ($ns[$namespaces[$i]] != "undefined") {
$nspaces[$i] = $ns[$namespaces[$i]];
$titles[$i] = $nspaces[$i] . $titles[$i];
#echo "\n" . $i . "> " . $titles[$i];
}
else {
echo "\n\nUndefined namespace: " . $namespaces[$i] . "\n";
$mysqli->close();
die;
}
}
/* close connection */
$mysqli->close();
for ($a = 0; $a < count($titles); $a+=20) {
echo "\n" . $a . "> " . $titles[$a] . "\n";
# . " | " . $titles[$a+1] . " | " . $titles[$a+2] . " | " . $titles[$a+3] . " | " . $titles[$a+4];
#echo "\n" . ($a+5) . "> " . $titles[$a+5]
# . " | " . $titles[$a+6] . " | " . $titles[$a+7] . " | " . $titles[$a+8] . " | " . $titles[$a+9];
#echo "\n" . ($a+10) . "> " . $titles[$a+10]
# . " | " . $titles[$a+11] . " | " . $titles[$a+12] . " | " . $titles[$a+13] . " | " . $titles[$a+14];
#echo "\n" . ($a+15) . "> " . $titles[$a+15]
# . " | " . $titles[$a+16] . " | " . $titles[$a+17] . " | " . $titles[$a+18] . " | " . $titles[$a+19] . "\n";
if (isset($titles[$a+19])) {
$result = $objwiki->purgeCache($titles[$a] . "|" . $titles[$a+1] . "|" . $titles[$a+2] . "|" . $titles[$a+3] . "|" .
$titles[$a+4] . "|" . $titles[$a+5] . "|" . $titles[$a+6] . "|" . $titles[$a+7] . "|" .
$titles[$a+8] . "|" . $titles[$a+9] . "|" . $titles[$a+10] . "|" . $titles[$a+11] . "|" .
$titles[$a+12] . "|" . $titles[$a+13] . "|" . $titles[$a+14] . "|" . $titles[$a+15] . "|" .
$titles[$a+16] . "|" . $titles[$a+17] . "|" . $titles[$a+18] . "|" . $titles[$a+19]);
}
else {
$titleslist = $titles[$a];
for ($aa = 1; $aa < 18; $aa++) {
if (isset($titles[$a+$aa])) $titleslist = $titleslist . "|" . $titles[$a+$aa];
}
$result = $objwiki->purgeCache($titleslist);
}
if (isset($result['error']['code'])) {
if ($result['error']['code'] == "assertuserfailed") goto login_again;
}
#print_r($result);
sleep (1);
#usleep (750000);
}
$finish_time = time();
$elapsed = $finish_time - $current_time;
echo "\nMission accomplished at " . date("Y-m-d H:i:s", $finish_time) . " in " . date("H:i:s", $elapsed) . ".\n\n";
if (count($titles) < 250) {
$days_ago_to_refresh = $days_ago_to_refresh - 1;
file_put_contents('./php/refreshlinks.dar', $days_ago_to_refresh);
}
else if (count($titles) == querylimit) {
$days_ago_to_refresh += 1;
file_put_contents('./php/refreshlinks.dar', $days_ago_to_refresh);
}
sleep (120);
goto doit_again;
?>