Topic on Talk:Quarry

Jump to navigation Jump to search

how do you find the author of a file?

Jarekt (talkcontribs)

Lately I was adding SDC statements P7482=Q66458942 to files that have {{Own}} template on Commons, using query. User:Schlurcher pointed out cases where people are incorrectly using {{Own}} template for files where person listed as author is not the uploader. I would like to exclude such cases in the future query and find files where I added P7482, but where uploader is not the same as the author listed in {{Information}} template. query can find my edits from this month to files and can find the name of the original uploader. Anybody knows how to find the name listed as "author"? Extension:Media Viewer displays "author" so I assume it is stored somewhere. Any ideas?

Edgars2007 (talkcontribs)

You will have to use API (or parsing of desciption pages). Database doesn't have that info. Also Mediaviewer gets author with API: today's POTD example

Jarekt (talkcontribs)

Edgars2007, Thank you for reply. API is not a very useful solution as I was hoping to write SQL query that compares the uploader to the author (listed in {{information}} template). Do SQL queries have access to the wikitext of the files? I could just get the author through regular expressions.

Edgars2007 (talkcontribs)

Yes, I understand that it's not useful, creates a headache etc.  :)

And no, database doesn't have the wikitext of pages.

Reply to "how do you find the author of a file?"