On Thu, Mar 27, 2014 at 6:01 PM, John <phoenixoverride(a)gmail.com> wrote:
Yep. Localuser keeps track of the attachments, so any entry there for a
username + wiki means the global username of the same name is attached on
that wiki. It's all done via username, not user id.
If you're using php to do the processing, you can use
CentralAuthUser::attachedOn() to test if the account is attached, or
use listAttached() to get the array of all wikis where the user is attached.
On Thu, Mar 27, 2014 at 8:35 PM, Dan Andreescu <dandreescu(a)wikimedia.org
wrote:
Thank you very much for the reply Max, +1 beer
for next time we meet.
On Thu, Mar 27, 2014 at 5:10 PM, MZMcBride <z(a)mzmcbride.com> wrote:
> Teresa Cho wrote:
> >I'm trying to add a feature to Wikimetrics that will allow users to
> >create a cohort with a username and find all accounts across wikis. I
> >want to use the CentralAuth database, because as far as I can tell, it
> >stores the global username and all the local usernames. However, I
don't
> >see where it connects the globalusers to
the localusers. Is it just
the
>username?
>
>Does the username have to be the same across local wikis and you query
>the localuser table with what you think is the global username? If
that's
> >the case, I suppose I don't need to look at the global table.
>
> Hi.
>
> Broadly, I think the answer for you're looking for is no: CentralAuth
> accounts (global user accounts that match to local user accounts) are
not
fully
unified on Wikimedia wikis. It's a long-term goal, but it's a
disruptive change to make, so it's taken a while. :-)
It sounds like you want programmatically retrieve the info from:
<https://www.mediawiki.org/wiki/Special:CentralAuth/Jimbo_Wales>.
If so, I'd recommend the MediaWiki Web API
(<https://www.mediawiki.org/w/api.php>) for this. Perhaps the
globaluserinfo API module?
https://www.mediawiki.org/w/api.php?action=query&meta=globaluserinfo&am…
r=Jimbo+Wales&guiprop=groups|merged|unattached
If you must directly query the MediaWiki database using SQL, you'll
likely
> need to read through the source code of the CentralAuth MediaWiki
> extension to figure out exactly what the PHP and SQL is doing with the
> underlying data. The source code of the CentralAuth MediaWiki extension
> can be found here:
> <
https://git.wikimedia.org/tree/mediawiki%2Fextensions%2FCentralAuth.git
>.
> You'll likely want to read through central-auth.sql in particular.
>
> Dan Andreescu wrote:
> >Any links to documentation on consuming data from the CentralAuth
> >databases is welcome. We searched a bit and found mostly installation
> >instructions.
>
> Well, very generally you (or your program) probably shouldn't be
querying
> the databases directly, but if you can
provide more specific
information
> about where you looked, we can probably add
some redirects for future
> w[ao]nderers.
>
> For general clarity, while I used
www.mediawiki.org in the examples in
> this e-mail, because the Web API is retrieving global (wiki farm-wide)
> data, the equivalent URL paths should work on other Wikimedia wikis
such
as
en.wikipedia.org or
meta.wikimedia.org.
MZMcBride
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l