Automoderated users, Autopatrolled users, Bureaucrats, Comment administrators, Confirmed users, Forum administrators, Interface administrators, Moderators, Rollbackers, Administrators
116,442
edits
User:Damian Yerrick/crosswick worksheet: Difference between revisions
User:Damian Yerrick/crosswick worksheet (view source)
Revision as of 16:27, 23 April 2020
, 4 years agoupdate links
(crosswicking is done; two (YKT)TWs remain) |
Looney Toons (talk | contribs) (update links) |
||
| (13 intermediate revisions by 2 users not shown) | |||
Line 1:
During the last week of July 2014, a year and a half of changes made by [[User:Damian Yerrick|Damian Yerrick]] to the article [
Over the two following weeks, he [[Topic:Rzi9sg1bgk2h3cv0|tried to get help]] with fixing more than 500 pages mistakenly linking to ''[[Cracked]]'' (a magazine), but he ended up having to do [[Special:WhatLinksHere/Cracked|them]] himself.
Finally, he [[Trope Workshop|proposed]] two tropes on ATT that had been launched on TVT after the fork: [[Dumpster Dive]] and [[Box-and-Stick Trap]].
<!-- SQLite patterns used to explore low-hanging fruit
/* show relevant parts of schema */
select sql from sqlite_master where tbl_name in ('pages', 'links');
/* show [[cracked]].com and [[cracked|cracked.com]] */
select '*[['||title||']]' from pages
where lower(markup) like '%cracked]].com%' or lower(markup) like '%cracked|cracked.com%';
/* all subpages linking to Cracked */
select '*[['||pages.title||']]' from pages inner join links on pages.pageid = links.from_pageid
where links.manner = 'wick' and links.to_title = 'Cracked' and pages.title like '%/%';
/* I did a few hundred manually by going down SP:WLH/Cracked. Then I did research on how to get regexps working in Python sqlite
https://stackoverflow.com/a/5365533/2738262
and now I continue with the queries */
/* potholed inexact quotations (hard) */
select '*[['||title||']]' from pages
where lower(markup) like '%[[cracked|%'
/* [[Cracked]] in the same line as an outbound (easy) */
select '*[['||title||']]' from pages
where markup regexp '\[\[Cracked\]\].*cracked.com/'
or markup regexp 'cracked.com/.*\[\[Cracked\]\]'
-->
| |||