Dzahn has uploaded a new change for review.
https://gerrit.wikimedia.org/r/159663
Change subject: add stats table for orain.org wikis
......................................................................
add stats table for orain.org wikis
Bug: 70309
Change-Id: I9f7558ec8a3f4ee728589268759f5b89ef33b784
---
M etc/wikistats/config.php
M usr/lib/wikistats/update.php
M usr/lib/wikistats/update_functions.php
M usr/share/php/wikistats/coalesced_query.php
M usr/share/php/wikistats/largest_query.php
M var/www/wikistats/detail.php
M var/www/wikistats/display.php
M var/www/wikistats/displayw.php
M var/www/wikistats/largest_html.php
9 files changed, 36 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/debs/wikistats
refs/changes/63/159663/1
diff --git a/etc/wikistats/config.php b/etc/wikistats/config.php
index a593382..404c7b9 100644
--- a/etc/wikistats/config.php
+++ b/etc/wikistats/config.php
@@ -60,16 +60,16 @@
$socket_timeout="10";
# list all tables (which should be displayed on index page and included in
grand totals)
-$listtables=array('wikipedias','wikiquotes','wikibooks','wiktionaries','wikinews','wikisources','wikia','editthis','wikitravel','mediawikis','uncyclomedia','anarchopedias','opensuse','richdex','gratiswiki','qweki','wikisite','gentoo','hyperwave','scoutwiki','wmspecials','qweki','wikiversity','wikifur','metapedias','neoseeker','shoutwiki','referata','pardus','rodovid','wikkii','lxde','wikivoyage','w3cwikis',
'gamepedias', 'sourceforge');
+$listtables=array('wikipedias','wikiquotes','wikibooks','wiktionaries','wikinews','wikisources','wikia','editthis','wikitravel','mediawikis','uncyclomedia','anarchopedias','opensuse','richdex','gratiswiki','qweki','wikisite','gentoo','hyperwave','scoutwiki','wmspecials','qweki','wikiversity','wikifur','metapedias','neoseeker','shoutwiki','referata','pardus','rodovid','wikkii','lxde','wikivoyage','w3cwikis',
'gamepedias', 'sourceforge', 'orain');
# list tables which are valid for our api.php - CHECKME
-$valid_api_tables=array('wikipedias','mediawikis','wiktionaries','wikia','wikisources','wmspecials','uncyclomedia','wikibooks','wikiquotes','editthis','wikinews','wikisite','wikitravel','scoutwiki','anarchopedias','opensuse','gratiswiki','gentoo','wikimedias','metapedias','wikifur','neoseeker','wikiversity','wikivoyage','w3cwikis','gamepedias',
'sourceforge');
+$valid_api_tables=array('wikipedias','mediawikis','wiktionaries','wikia','wikisources','wmspecials','uncyclomedia','wikibooks','wikiquotes','editthis','wikinews','wikisite','wikitravel','scoutwiki','anarchopedias','opensuse','gratiswiki','gentoo','wikimedias','metapedias','wikifur','neoseeker','wikiversity','wikivoyage','w3cwikis','gamepedias',
'sourceforge', 'orain');
# list tables which should have language columns in the html tables
$tables_with_language_columns=array('wikipedias','wiktionaries','wikisources','uncyclomedia','wikibooks','wikiquotes','wikinews','wikitravel','anarchopedias','wikimedias','wikifur','wikiversity','pardus','rodovid','lxde','wikivoyage','metapedias');
# list tables with URLs like wikiname.domain.org/api.php
-$tables_with_prefix_short=array('anarchopedias', 'wikisite', 'pardus',
'rodovid', 'opensuse','wikisite','scoutwiki', 'gamepedias','sourceforge');
+$tables_with_prefix_short=array('anarchopedias', 'wikisite', 'pardus',
'rodovid', 'opensuse','wikisite','scoutwiki', 'gamepedias','sourceforge',
'orain');
# list tables with URLs like domain.org/wikiname/api.php
$tables_with_suffix_short=array('editthis','lxde');
diff --git a/usr/lib/wikistats/update.php b/usr/lib/wikistats/update.php
index c71d7ec..c0be38f 100644
--- a/usr/lib/wikistats/update.php
+++ b/usr/lib/wikistats/update.php
@@ -177,6 +177,11 @@
case "sf":
$table="sourceforge";
$domain="sourceforge.net";
+ break;
+ case "or":
+ $table="orain";
+ $domain="orain.org";
+ break;
default:
$table="unknown";
print "unknown table. exiting\n";
diff --git a/usr/lib/wikistats/update_functions.php
b/usr/lib/wikistats/update_functions.php
index 898136f..462bbdf 100755
--- a/usr/lib/wikistats/update_functions.php
+++ b/usr/lib/wikistats/update_functions.php
@@ -147,10 +147,15 @@
case "ga":
$table="gamepedias";
$domain="gamepedia.com";
+ break;
case "sf":
$table="sourceforge";
$domain="sourceforge.net";
break;
+ case "or":
+ $table="orain";
+ $domain="orain.org";
+ break;
default:
$table="unknown";
print "unknown table. exiting\n";
diff --git a/usr/share/php/wikistats/coalesced_query.php
b/usr/share/php/wikistats/coalesced_query.php
index c0397c5..8f1dae1 100644
--- a/usr/share/php/wikistats/coalesced_query.php
+++ b/usr/share/php/wikistats/coalesced_query.php
@@ -61,6 +61,8 @@
(select 'ga' as project,'gamepedias' as name,sum(good) as ggood, sum(total) as
gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as
gusers,sum(images) as gimages, count(id) as numwikis from gamepedias)
union all
(select 'sf' as project,'sourceforge' as name,sum(good) as ggood, sum(total)
as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as
gusers,sum(images) as gimages, count(id) as numwikis from sourceforge)
+union all
+(select 'or' as project,'orain' as name,sum(good) as ggood, sum(total) as
gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as
gusers,sum(images) as gimages, count(id) as numwikis from orain)
order by ${sort};";
?>
diff --git a/usr/share/php/wikistats/largest_query.php
b/usr/share/php/wikistats/largest_query.php
index ca10979..fccd77f 100755
--- a/usr/share/php/wikistats/largest_query.php
+++ b/usr/share/php/wikistats/largest_query.php
@@ -56,6 +56,8 @@
UNION SELECT ${fields_nolangs},"Sourceforge" AS type FROM sourceforge WHERE
good >= ${threshold}
+UNION SELECT ${fields_nolangs},"Orain" AS type FROM orain WHERE good >=
${threshold}
+
ORDER BY ${msort} LIMIT ${limit};
FNORD;
diff --git a/var/www/wikistats/detail.php b/var/www/wikistats/detail.php
index ce891cd..d8b8f6b 100644
--- a/var/www/wikistats/detail.php
+++ b/var/www/wikistats/detail.php
@@ -189,6 +189,11 @@
$domain="sourceforge.net";
$db_table="sourceforge";
break;
+ case "or":
+ $project_name="Orain";
+ $domain="orain.org";
+ $db_table="orain";
+ break;
default:
$project_name="invalid";
diff --git a/var/www/wikistats/display.php b/var/www/wikistats/display.php
index 9fd6961..50c226e 100644
--- a/var/www/wikistats/display.php
+++ b/var/www/wikistats/display.php
@@ -189,6 +189,11 @@
$domain="sourceforge.net";
$db_table="sourceforge";
break;
+ case "or":
+ $project_name="Orain";
+ $domain="orain.org";
+ $db_table="orain";
+ break;
default:
$project_name="invalid";
@@ -208,6 +213,7 @@
<li><a href="${phpself}?t=w3">w3</a> (w3c)</li>
<li><a href="${phpself}?t=ga">ga</a> (gamepedias)</li>
<li><a href="${phpself}?t=sf">sf</a> (sourceforge)</li>
+<li><a href="${phpself}?t=or">or</a> (orain)</li>
</ul></html>
INVALID;
exit;
diff --git a/var/www/wikistats/displayw.php b/var/www/wikistats/displayw.php
index 39313a5..473f2ef 100644
--- a/var/www/wikistats/displayw.php
+++ b/var/www/wikistats/displayw.php
@@ -184,6 +184,11 @@
$domain="sourceforge.net";
$db_table="sourceforge";
break;
+ case "or":
+ $project_name="Orain";
+ $domain="orain.org";
+ $db_table="orain";
+ break;
default:
$project_name="invalid";
@@ -203,6 +208,7 @@
<li><a href="${phpself}?t=w3">w3</a> (w3c)</li>
<li><a href="${phpself}?t=ga">ga</a> (gamepedias)</li>
<li><a href="${phpself}?t=sf">sf</a> (sourceforge)</li>
+<li><a href="${phpself}?t=or">or</a> (orain)</li>
</ul></html>
INVALID;
exit;
diff --git a/var/www/wikistats/largest_html.php
b/var/www/wikistats/largest_html.php
index e768325..85ac89c 100644
--- a/var/www/wikistats/largest_html.php
+++ b/var/www/wikistats/largest_html.php
@@ -85,6 +85,8 @@
UNION ALL
SELECT count(id) AS count,'Sourceforge' AS type FROM sourceforge
UNION ALL
+SELECT count(id) AS count,'Orain' AS type FROM orain
+UNION ALL
SELECT count(id) AS count,'Elwiki' AS type FROM elwiki where inactive is null";
$result = mysql_query("$countquery") or die(mysql_error());
--
To view, visit https://gerrit.wikimedia.org/r/159663
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I9f7558ec8a3f4ee728589268759f5b89ef33b784
Gerrit-PatchSet: 1
Gerrit-Project: operations/debs/wikistats
Gerrit-Branch: master
Gerrit-Owner: Dzahn <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
