We should have "Text is available under the Creative Commons Attribution-ShareAlike License; additional terms may apply. See Terms of Use for details." or similar in the footer on all pages. Not certain if there is any advantage to CC-BY-SA 4.0 over the Wikimedia standard CC-BY-SA-3.0.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Tgr | T248271 CC text in Wikispore footer | |||
| Resolved | Tgr | T260049 Create Pywikibot family for Wikispore | |||
| Resolved | Tgr | T261066 Pywikibot bot password login failure |
Event Timeline
Comment Actions
When going to save an edit, the warning says "Please note that all contributions to Wikispore may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here. You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Wiki:Copyrights for details). Do not submit copyrighted work without permission!" - a license for the whole site needs to be decided upon, and editors need to be aware of the licensing of their contributions
Comment Actions
Current copyright holders (as of 2020-07-18):
vagrant@localhost:[wiki]> select user_name, count(*) edits from revision join revision_actor_temp on rev_id = revactor_rev join actor on revactor_actor = actor_id join user on actor_user = user_id left join ipblocks on user_id = ipb_user where ipb_user is null group by user_name order by edits desc; +---------------------+-------+ | user_name | edits | +---------------------+-------+ | Pharos | 571 | | Koavf | 356 | | Zblace | 128 | | Denny | 115 | | ChristianSW | 73 | | A12n | 41 | | Spinster | 24 | | Sj | 20 | | Ottawahitech | 13 | | Econterms | 13 | | Tgr | 10 | | PKM | 10 | | Mvolz | 10 | | Dmehus | 7 | | Perohanych | 6 | | Sannita | 6 | | Funcrunch | 6 | | R9H9 | 6 | | Ircpresident | 6 | | Sm8900 | 4 | | AllyD | 3 | | Rosiestep | 3 | | 1234qwer1234qwer4 | 3 | | DutchTreat | 3 | | Maintenance script | 2 | | Bluerasberry | 2 | | Battleofalma | 2 | | FULBERT | 2 | | Ainali | 2 | | Amire80 | 2 | | Killarnee | 2 | | GZWDer | 2 | | Serial Number 54129 | 1 | | Luk3 | 1 | | Clifford Anderson | 1 | | Yaron Koren | 1 | | Reify-tech | 1 | | Treetopz | 1 | | TrMendenhall | 1 | | EdSaperia | 1 | | Librarian lena | 1 | +---------------------+-------+ 41 rows in set (0.00 sec)
We need their permission for making the switch.
Comment Actions
Blocked on everyone on the list above signing http://wikispore.wmflabs.org/wiki/Wiki_talk:Copyrights
Comment Actions
List of pages with edits by users who have not signed yet:
select page_namespace, page_title, count(*) edits, group_concat(distinct user_name separator ',') from page join revision on page_id = rev_page join revision_actor_temp on rev_id = revactor_rev join actor on revactor_actor = actor_id join user on actor_user = user_id left join ipblocks on user_id = ipb_user where ipb_user is null and rev_timestamp < '20200725150000' and user_name not in ('Pharos', 'Tgr', 'Sj', 'Koavf', 'Zblace', 'Spinster', 'Mvolz', 'PKM', 'ChristianSW', 'Dmehus', 'A12n', 'Maintenance script', 'FuzzyBot') group by page_namespace, page_title order by edits desc;+----------------+-------------------------------------------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------+ | page_namespace | page_title | edits | group_concat(distinct user_name separator ',') | +----------------+-------------------------------------------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------+ | 3012 | Wikilambda/Glossary | 33 | Denny | | 0 | Guestbook | 17 | Bluerasberry,Reify-tech,Funcrunch,1234qwer1234qwer4,Ircpresident,Perohanych,Sannita,Battleofalma,TrMendenhall,Ottawahitech,Sm8900 | | 3012 | Wikilambda/Tasks | 14 | Denny,Amire80 | | 3012 | Wikilambda/Name | 13 | Denny | | 0 | Wikispore_Day | 12 | Yaron Koren,Treetopz,Rosiestep,EdSaperia,Ainali,Daniel Mietchen,AllyD,Dyolf77,Csisc,Bluerasberry,Ziko | | 3012 | Wikilambda/Examples | 10 | Denny | | 10 | Art_Event | 9 | AllyD | | 0 | Greenhouse | 7 | Ottawahitech,Denny,GZWDer,Sannita,AllyD | | 3012 | Main_page | 7 | Denny | | 3012 | Wikilambda/Components | 6 | Denny | | 3012 | Wikilambda/Plan | 6 | Denny | | 3000 | Richard_Demarco_Gallery | 5 | AllyD | | 3012 | Wikilambda/Architecture | 5 | Denny | | 2 | Perohanych | 4 | Perohanych | | 3 | Koavf | 4 | Ottawahitech,Denny | | 3002 | World_AIDS_Day_2019 | 4 | Funcrunch,FULBERT,Luk3 | | 3010 | Pouliakas_and_Branka,_2020 | 4 | Econterms | | 3012 | Wikilambda/Organization | 4 | Denny | | 1 | Art_Spore | 3 | AllyD | | 1 | Crisis_Spore | 3 | Ottawahitech | | 2 | Denny | 3 | Denny | | 2 | R9H9 | 3 | R9H9 | | 3 | R9H9 | 3 | R9H9 | | 3000 | DATA | 3 | AllyD | | 0 | Art_Spore | 2 | AllyD | | 0 | Crisis_Spore | 2 | Econterms,Kroger4 | | 0 | FAQ | 2 | Ottawahitech,GZWDer | | 2 | DutchTreat | 2 | DutchTreat | | 2 | Funcrunch | 2 | Funcrunch | | 2 | Ircpresident | 2 | Ircpresident | | 2 | Sannita/Sandbox | 2 | Sannita | | 3 | Pharos | 2 | Ottawahitech | | 3000 | Strategy:_Get_Arts | 2 | AllyD | | 3010 | Béland,_Brodeur,_and_Wright,_2020 | 2 | Econterms | | 3010 | Oguzoglu,_2020 | 2 | Econterms | | 3012 | Supporting_material | 2 | Denny | | 3012 | Wikilambda/Goals | 2 | Denny | | 3012 | Wikilambda/Requirements | 2 | Denny | | 3012 | Wikilambda/Summary | 2 | Denny | | 0 | Geo_Spore | 1 | Kroger4 | | 0 | Main_Page | 1 | 1234qwer1234qwer4 | | 0 | Richard_Demarco_Gallery | 1 | AllyD | | 0 | Sport_Spore | 1 | Sannita | | 0 | Wikilambda:Supporting_material | 1 | Denny | | 1 | Fact_Spore | 1 | Ottawahitech | | 1 | Wikispore_Day | 1 | Ziko | | 2 | Ainali | 1 | Ainali | | 2 | AllyD/sandbox | 1 | AllyD | | 2 | Battleofalma | 1 | Battleofalma | | 2 | Bluerasberry | 1 | Bluerasberry | | 2 | Clifford_Anderson | 1 | Clifford Anderson | | 2 | Dyolf77 | 1 | Dyolf77 | | 2 | Econterms | 1 | Econterms | | 2 | FULBERT | 1 | FULBERT | | 2 | Killarnee | 1 | Killarnee | | 2 | Kpjas | 1 | Kpjas | | 2 | Masssly | 1 | Masssly | | 2 | Rosiestep | 1 | Rosiestep | | 2 | Sm8900 | 1 | Sm8900 | | 3 | Bluerasberry | 1 | Ottawahitech | | 3 | Denny | 1 | Denny | | 3 | Ircpresident | 1 | Ircpresident | | 3 | Killarnee | 1 | Killarnee | | 3 | Rosiestep | 1 | Rosiestep | | 3 | Serial_Number_54129 | 1 | Serial Number 54129 | | 3 | Sm8900 | 1 | Sm8900 | | 8 | Common.css | 1 | Amire80 | | 11 | Art_Event | 1 | AllyD | | 14 | Art_Spore | 1 | AllyD | | 14 | Wikispore | 1 | 1234qwer1234qwer4 | | 3000 | National_Review_of_Live_Art | 1 | AllyD | | 3002 | Armistice_Day_2019 | 1 | AllyD | | 3002 | International_Women's_Day_2020 | 1 | AllyD | | 3003 | World_AIDS_Day_2019 | 1 | Funcrunch | | 3006 | Joséphine-Eléonore-Marie-Pauline_de_Galard_de_Brassac_de_Béarn | 1 | DutchTreat | | 3010 | Borjas_and_Cassidy,_2020 | 1 | Econterms | | 3010 | Covid_economics | 1 | Econterms | | 3010 | Covid_wiki-adjacent_resources | 1 | Librarian lena | | 3010 | Pouliakas,_Branka,_2020 | 1 | Econterms | | 3012 | Wikilambda/Overview | 1 | Denny | | 3012 | Wikilambda/Vision | 1 | Denny | +----------------+-------------------------------------------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------+
List of users who have not signed yet:
select user_name, count(*) edits from revision join revision_actor_temp on rev_id = revactor_rev join actor on revactor_actor = actor_id join user on actor_user = user_id left join ipblocks on user_id = ipb_user where ipb_user is null and rev_timestamp < '20200725150000' and user_name not in ('Pharos', 'Tgr', 'Sj', 'Koavf', 'Zblace', 'Spinster', 'Mvolz', 'PKM', 'ChristianSW', 'Dmehus', 'A12n', 'Maintenance script', 'FuzzyBot') group by user_name order by edits desc;+---------------------+-------+ | user_name | edits | +---------------------+-------+ | Denny | 115 | | AllyD | 33 | | Econterms | 13 | | Ottawahitech | 13 | | Funcrunch | 6 | | R9H9 | 6 | | Ircpresident | 6 | | Perohanych | 6 | | Sannita | 6 | | GZWDer | 4 | | Sm8900 | 4 | | Bluerasberry | 3 | | 1234qwer1234qwer4 | 3 | | DutchTreat | 3 | | Rosiestep | 3 | | Amire80 | 2 | | Kroger4 | 2 | | FULBERT | 2 | | Ziko | 2 | | Killarnee | 2 | | Battleofalma | 2 | | Ainali | 2 | | Daniel Mietchen | 2 | | Dyolf77 | 2 | | Masssly | 1 | | Reify-tech | 1 | | Librarian lena | 1 | | Kpjas | 1 | | Serial Number 54129 | 1 | | Luk3 | 1 | | Clifford Anderson | 1 | | Yaron Koren | 1 | | Treetopz | 1 | | EdSaperia | 1 | | TrMendenhall | 1 | | Csisc | 1 | +---------------------+-------+
(That's 33 users. There were 25 users when we created the signing page, FWIW. It would be good if someone could take upon themselves to manage the social side of this, otherwise it will get out of hand quickly.)
Comment Actions
The contirbution warning has been changed to say new edits are under CC-BY-SA, so only edits older than this comment will have to be relicensed.
Comment Actions
People who signed up so far: 1234qwer1234qwer4, A12n, Ainali, AllyD, Amire80, Bluerasberry, ChristianSW, Denny, Dmehus, DutchTreat, Dyolf77, Econterms, Funcrunch, Ircpresident, Killarnee, Koavf, Kpjas, Luk3, Mvolz, Ottawahitech, Pharos, PKM, Rosiestep, Sannita, Sj, Spinster, Tgr, Treetopz, Zblace, Ziko. (Thanks!)
Remaining users (17):
select user_name, count(*) edits from revision join revision_actor_temp on rev_id = revactor_rev join actor on revactor_actor = actor_id join user on actor_user = user_id left join ipblocks on user_id = ipb_user where ipb_user is null and rev_timestamp < '20200725150000' and user_name not in ('1234qwer1234qwer4', 'A12n', 'Ainali', 'AllyD', 'Amire80', 'Bluerasberry', 'ChristianSW', 'Denny', 'Dmehus', 'DutchTreat', 'Dyolf77', 'Econterms', 'Funcrunch', 'Ircpresident', 'Killarnee', 'Koavf', 'Kpjas', 'Luk3', 'Mvolz', 'Ottawahitech', 'Pharos', 'PKM', 'Rosiestep', 'Sannita', 'Sj', 'Spinster', 'Tgr', 'Treetopz', 'Zblace', 'Ziko', 'Maintenance script', 'FuzzyBot') group by user_name order by edits desc;+---------------------+-------+ | user_name | edits | +---------------------+-------+ | R9H9 | 6 | | Perohanych | 6 | | Sm8900 | 4 | | GZWDer | 4 | | Kroger4 | 2 | | FULBERT | 2 | | Battleofalma | 2 | | Daniel Mietchen | 2 | | Reify-tech | 1 | | TrMendenhall | 1 | | Librarian lena | 1 | | Serial Number 54129 | 1 | | Clifford Anderson | 1 | | Yaron Koren | 1 | | EdSaperia | 1 | | Csisc | 1 | | Masssly | 1 | +---------------------+-------+
Remaining pages (18):
select page_namespace, page_title, count(*) edits, group_concat(distinct user_name separator ',') from page join revision on page_id = rev_page join revision_actor_temp on rev_id = revactor_rev join actor on revactor_actor = actor_id join user on actor_user = user_id left join ipblocks on user_id = ipb_user where ipb_user is null and rev_timestamp < '20200725150000' and user_name not in ('1234qwer1234qwer4', 'A12n', 'Ainali', 'AllyD', 'Amire80', 'Bluerasberry', 'ChristianSW', 'Denny', 'Dmehus', 'DutchTreat', 'Dyolf77', 'Econterms', 'Funcrunch', 'Ircpresident', 'Killarnee', 'Koavf', 'Kpjas', 'Luk3', 'Mvolz', 'Ottawahitech', 'Pharos', 'PKM', 'Rosiestep', 'Sannita', 'Sj', 'Spinster', 'Tgr', 'Treetopz', 'Zblace', 'Ziko', 'Maintenance script', 'FuzzyBot') group by page_namespace, page_title order by edits desc;+----------------+-------------------------------+-------+--------------------------------------------------------+ | page_namespace | page_title | edits | group_concat(distinct user_name separator ',') | +----------------+-------------------------------+-------+--------------------------------------------------------+ | 0 | Guestbook | 7 | Reify-tech,Perohanych,Battleofalma,TrMendenhall,Sm8900 | | 0 | Wikispore_Day | 5 | Yaron Koren,EdSaperia,Daniel Mietchen,Csisc | | 2 | Perohanych | 4 | Perohanych | | 0 | Greenhouse | 3 | GZWDer | | 2 | R9H9 | 3 | R9H9 | | 3 | R9H9 | 3 | R9H9 | | 0 | Crisis_Spore | 1 | Kroger4 | | 0 | FAQ | 1 | GZWDer | | 0 | Geo_Spore | 1 | Kroger4 | | 2 | Battleofalma | 1 | Battleofalma | | 2 | Clifford_Anderson | 1 | Clifford Anderson | | 2 | FULBERT | 1 | FULBERT | | 2 | Masssly | 1 | Masssly | | 2 | Sm8900 | 1 | Sm8900 | | 3 | Serial_Number_54129 | 1 | Serial Number 54129 | | 3 | Sm8900 | 1 | Sm8900 | | 3002 | World_AIDS_Day_2019 | 1 | FULBERT | | 3010 | Covid_wiki-adjacent_resources | 1 | Librarian lena | +----------------+-------------------------------+-------+--------------------------------------------------------+