Page MenuHomePhabricator

Add hif.wiktionary to wikistats
Closed, ResolvedPublic


Once the wiki is created, please add it to the wikistats.

Related Objects


Event Timeline

Reedy changed the task status from Stalled to Open.Nov 6 2017, 9:58 PM
Dzahn subscribed.

feel free to assign these directly to me

instance: wikistats-cowgirl (mysql -u root wikistats)

We have an existing Wikipedia for language "hif":

MariaDB [wikistats]> select lang,prefix,loclang,loclanglink from wikipedias where prefix="hif";
| lang       | prefix | loclang    | loclanglink      |
| Fiji Hindi | hif    | Fiji Hindi | Fiji Hindi bhasa |

So we can just copy it from wikipedias table to wiktionaries table like:

MariaDB [wikistats]> insert into wiktionaries (lang,prefix,loclang,loclanglink,method) select lang,prefix,loclang,loclanglink,method from wikipedias where prefix="hif";
Query OK, 1 row affected (0.09 sec)
Records: 1  Duplicates: 0  Warnings: 0

and then update it to get the numbers:

dzahn@wikistats-cowgirl:~$ /usr/bin/php /usr/lib/wikistats/update.php wt prefix hif
sent query: 'select * from wiktionaries where prefix="hif"'.
A(1/173) - - calling API:
-> http answer: 200 -> parsing answer: 0
---> OK - total: 8 good: 0 edits: 10 users: 31 active users: 4 admins: 0 images: 0
---> update wiktionaries set total="8",good="0",edits="10",users="31",activeusers="4",admins="0",images="0",http="200",ts=NOW() where id="437"; 

1 wikis succesfully updated.

Added on

There are 173 wikis in table 'wiktionaries'. 'hif' is ranked 173rd by good pages, 173rd by total pages, 173rd by edits and 173rd by users.