Page MenuHomePhabricator

CC text in Wikispore footer
Closed, ResolvedPublic

Description

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.

Related Objects

Event Timeline

DannyS712 added a subscriber: DannyS712.

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

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.

DannyS712 changed the task status from Open to Stalled.Jun 27 2020, 10:08 AM

Blocked on everyone on the list above signing http://wikispore.wmflabs.org/wiki/Wiki_talk:Copyrights

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.)

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.

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                                         |
+----------------+-------------------------------+-------+--------------------------------------------------------+
Tgr renamed this task from CC text in footer to CC text in Wikispore footer.Aug 23 2020, 9:57 AM
Tgr moved this task from Next-up to Done on the Wikispore board.
Tgr removed a project: WMF-Legal.

This is now done. Pages with nonfree edits are tracked via Template:Non-CC page.