I could not do this yet because my phone is broken and as an ops i was required to use 2factor auth on wikitech.

I added jem to project wikistats so he should have shell,but still need to add instructions what to do how

Thanks., Dzahn. I have checked and I do have ssh access to both instances listed in wikitech. I wait for the instructions now, as I see I have no permissions for mysql, so I guess there are tools to know/configuration to do/etc. I leave the task open for now and we'll keep in contact.

@-jem- try mysql -u jem wikistats now

example for adding a new wikipedia:

insert into wikipedias (prefix, lang, loclang, method) values ("lrc", "Northern Luri", "لۊری شومالی", "8");

prefix - the subdomain of wikipedia.org / language code
lang - the language name in English
loclang - the language name in the local language itself (please use HTML entities, you can convert with http://konieczny.be/unicode.html)

(optionally there is also "loclanglink" for the link the language name points to in the HTML table but usually it works without it, this would be a name of a Wikipedia page about the language)

to update a single wiki i use something like:

sudo -u wikistatsuser /usr/bin/php /usr/lib/wikistats/update.php wp prefix lrc

Where "wp" is the table, "prefix" tells it i just want one specific one, and "lrc" is well.. the prefix.

forgot to add: do this on "wikistats-cowgirl" currently