Dzahn has submitted this change and it was merged.
Change subject: add stats table for sourceforge wikis
......................................................................
add stats table for sourceforge wikis
Bug: 58396
Change-Id: Ida4740215aeb550cb28fca0a77b5520832fcf8d2
---
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, 32 insertions(+), 3 deletions(-)
Approvals:
Dzahn: Looks good to me, approved
diff --git a/etc/wikistats/config.php b/etc/wikistats/config.php
index 6497783..a593382 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');
+$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');
# 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');
+$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');
# 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');
+$tables_with_prefix_short=array('anarchopedias', 'wikisite', 'pardus',
'rodovid', 'opensuse','wikisite','scoutwiki', 'gamepedias','sourceforge');
# 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 ca86728..c71d7ec 100644
--- a/usr/lib/wikistats/update.php
+++ b/usr/lib/wikistats/update.php
@@ -174,6 +174,9 @@
$table="gamepedias";
$domain="gamepedia.com";
break;
+ case "sf":
+ $table="sourceforge";
+ $domain="sourceforge.net";
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 c74c7dc..898136f 100755
--- a/usr/lib/wikistats/update_functions.php
+++ b/usr/lib/wikistats/update_functions.php
@@ -147,6 +147,9 @@
case "ga":
$table="gamepedias";
$domain="gamepedia.com";
+ case "sf":
+ $table="sourceforge";
+ $domain="sourceforge.net";
break;
default:
$table="unknown";
diff --git a/usr/share/php/wikistats/coalesced_query.php
b/usr/share/php/wikistats/coalesced_query.php
index 77bdd41..c0397c5 100644
--- a/usr/share/php/wikistats/coalesced_query.php
+++ b/usr/share/php/wikistats/coalesced_query.php
@@ -59,6 +59,8 @@
(select 'w3' as project,'w3cwikis' 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 w3cwikis)
union all
(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)
order by ${sort};";
?>
diff --git a/usr/share/php/wikistats/largest_query.php
b/usr/share/php/wikistats/largest_query.php
index 868411a..ca10979 100755
--- a/usr/share/php/wikistats/largest_query.php
+++ b/usr/share/php/wikistats/largest_query.php
@@ -54,6 +54,8 @@
UNION SELECT ${fields_nolangs},"Gamepedia" AS type FROM gamepedias WHERE good
>= ${threshold}
+UNION SELECT ${fields_nolangs},"Sourceforge" AS type FROM sourceforge WHERE
good >= ${threshold}
+
ORDER BY ${msort} LIMIT ${limit};
FNORD;
diff --git a/var/www/wikistats/detail.php b/var/www/wikistats/detail.php
index 8be9541..ce891cd 100644
--- a/var/www/wikistats/detail.php
+++ b/var/www/wikistats/detail.php
@@ -184,6 +184,11 @@
$domain="gamepedia.com";
$db_table="gamepedias";
break;
+ case "sf":
+ $project_name="Sourceforge";
+ $domain="sourceforge.net";
+ $db_table="sourceforge";
+ break;
default:
$project_name="invalid";
diff --git a/var/www/wikistats/display.php b/var/www/wikistats/display.php
index 7065acc..9fd6961 100644
--- a/var/www/wikistats/display.php
+++ b/var/www/wikistats/display.php
@@ -184,6 +184,11 @@
$domain="gamepedia.com";
$db_table="gamepedias";
break;
+ case "sf":
+ $project_name="Sourceforge";
+ $domain="sourceforge.net";
+ $db_table="sourceforge";
+ break;
default:
$project_name="invalid";
@@ -202,6 +207,7 @@
<li><a href="${phpself}?t=os">os</a> (opensuse)</li><li><a
href="${phpself}?t=re">re</a> (referata)</li><li><a
href="${phpself}?t=pa">pa</a> (pardus)</li>
<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>
</ul></html>
INVALID;
exit;
diff --git a/var/www/wikistats/displayw.php b/var/www/wikistats/displayw.php
index 4711c37..39313a5 100644
--- a/var/www/wikistats/displayw.php
+++ b/var/www/wikistats/displayw.php
@@ -179,6 +179,11 @@
$domain="gamepedia.com";
$db_table="gamepedias";
break;
+ case "sf":
+ $project_name="Sourceforge";
+ $domain="sourceforge.net";
+ $db_table="sourceforge";
+ break;
default:
$project_name="invalid";
@@ -197,6 +202,7 @@
<li><a href="${phpself}?t=os">os</a> (opensuse)</li><li><a
href="${phpself}?t=re">re</a> (referata)</li><li><a
href="${phpself}?t=pa">pa</a> (pardus)</li>
<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>
</ul></html>
INVALID;
exit;
diff --git a/var/www/wikistats/largest_html.php
b/var/www/wikistats/largest_html.php
index 53beb34..e768325 100644
--- a/var/www/wikistats/largest_html.php
+++ b/var/www/wikistats/largest_html.php
@@ -83,6 +83,8 @@
UNION ALL
SELECT count(id) AS count,'Gamepedia' AS type FROM gamepedias
UNION ALL
+SELECT count(id) AS count,'Sourceforge' AS type FROM sourceforge
+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/159661
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ida4740215aeb550cb28fca0a77b5520832fcf8d2
Gerrit-PatchSet: 1
Gerrit-Project: operations/debs/wikistats
Gerrit-Branch: master
Gerrit-Owner: Dzahn <[email protected]>
Gerrit-Reviewer: Dzahn <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
