283:
JOIN user_groups ON actor_user = ug_user WHERE ptrp_reviewed = 0 AND ptrpt_tag_id = 9 # Snippet AND page_namespace = 0 AND page_is_redirect = 1 AND EXISTS ( # Only 1 revision based on rev_count page triage tag SELECT 1 FROM pagetriage_page_tags tags2 WHERE tags2.ptrpt_page_id = page_id AND tags2.ptrpt_tag_id = 7 AND tags2.ptrpt_value = 1 ) AND EXISTS ( # Move log from the same time by the same person SELECT 1 FROM logging_logindex lgl2 WHERE log_namespace = page_namespace AND log_title = page_title AND log_timestamp = rev_timestamp AND log_actor = rev_actor AND log_type = 'move' AND log_action = 'move' ) AND ug_group = 'extendedmover' LIMIT 100;
298:
356:
519:
be only a few dozen over 14 days. Danny is a trusted botop and while it needs to go through a trial to make sure everything is working, we are not going to begrudge a handful of edits on either side of 100 if the task can be shown to be operating within expected parameters. So sure, run it for a day
282:
SELECT page_id AS 'pageid', page_title AS 'title', ptrpt_value AS 'target', actor_name AS 'creator' FROM page JOIN pagetriage_page ON page_id = ptrp_page_id JOIN pagetriage_page_tags ON ptrp_page_id = ptrpt_page_id JOIN revision rv ON page_latest = rev_id JOIN actor ON rev_actor = actor_id
337:
every 15 minutes with the redirects that it patrols and why - a 14 day trial will be 1344 entries to scan through, and I would expect that almost all of the relevant entries would be on the first run (for any existing backlog) - would a shorter trial be okay? Like a day (or even less)?
514:
I was giving the botop what they wanted. They said 14 days was too long and there would be too many actions to look at. I threw out 100 as our standard number (which does happen to be "about a day's worth" when you do the maths) because on these "not sure how many per day" requests it
266:
If possible, I'd like to request speedy approval and/or a time-based trial, so that I don't need to add a whole bunch of logic to the bot to count how many redirects have already been patrolled in the trial.
488:
may have had would be that the bot might be done within a day. What are your thoughts, Primefac? Provided that it won't actually complete within a day, I don't see an issue with a 1 day trial. cc
155:
213:
436:
I'm also wondering that - also the "whichever happens first" means I would still need to add some logic to count how many redirects have been patrolled in the trial already --
396:
415:
Is there a reason that a single day trial (as requested by Danny) would be a Bad Thing? Of course, I am not a bot op, so there might be something I am unaware of :)
347:
302:
Approved for trial (100 edits or 14 days, whichever happens first). Please provide a link to the relevant contributions and/or diffs when the trial is complete.
505:
475:
548:
584:
570:
529:
445:
431:
410:
613:
322:
263:
for the current rules) once I write it. You can see the implementation I intend to use is to patrol all redirects based on the query below.
45:
60:
55:
334:
90:
21:
464:
420:
385:
75:
125:
65:
308:
113:
453:
375:
365:
70:
85:
260:
80:
50:
330:
304:
137:
119:
149:
143:
291:
30:
471:
427:
392:
31:
131:
201:
180:
8:
580:
575:
Yes, sorry, I was out of town for a while but am back and will do bot stuff again soon --
441:
343:
107:
562:
544:
525:
497:
406:
318:
536:
461:
417:
382:
214:
Knowledge talk:New pages patrol/Reviewers/Archive 51#Idea to reduce redirect backlog
576:
556:
491:
437:
339:
102:
17:
607:
540:
521:
483:
402:
314:
231:
189:
259:
The code will be added to my current redirect patrolling bot rules (see
539:, using the assistance template twice in ten days is a bit excessive.
480:
Though I cannot speak on his behalf, I imagine a concern that
207:
as "patrolled" in the new page patrol / page curation system
167:
211:Links to relevant discussions (where appropriate):
605:
459:(apologies for using this a lot as of late...)
614:Open Knowledge bot requests for approval
200:Automatically mark redirects created by
14:
606:
335:User:DannyS712 bot III/Redirects.json
225:Estimated number of pages affected:
27:
28:
625:
174:Automatic, Supervised, or Manual:
401:I've tweaked the trial numbers.
354:
296:
166:00:02, Thursday, May 9, 2024 (
13:
1:
261:User:DannyS712 bot III/rules
7:
10:
630:
520:and see where you end up.
311:) 10:58, 9 May 2024 (UTC)
585:02:39, 21 July 2024 (UTC)
571:22:20, 13 July 2024 (UTC)
549:00:03, 10 July 2024 (UTC)
530:00:03, 10 July 2024 (UTC)
432:22:39, 29 June 2024 (UTC)
411:17:03, 29 June 2024 (UTC)
397:03:32, 29 June 2024 (UTC)
323:17:03, 29 June 2024 (UTC)
506:04:24, 9 July 2024 (UTC)
476:22:45, 6 July 2024 (UTC)
446:12:18, 1 July 2024 (UTC)
561:did you see the above?
359:Peanut gallery comment)
348:16:13, 9 May 2024 (UTC)
245:Already has a bot flag
205:as part of a page move
510:I had no concerns; I
454:bag assistance needed
376:BAG assistance needed
366:BAG assistance needed
331:ProcrastinatingReader
305:ProcrastinatingReader
202:Knowledge:Page movers
22:Requests for approval
181:Programming language
32:DannyS712 bot III 74
361:I am BOLDly adding
333:the bot reports to
232:Exclusion compliant
198:Function overview:
360:
289:
288:
257:Function details:
621:
568:
565:
560:
551:
503:
500:
495:
487:
467:
458:
452:
423:
388:
380:
374:
370:
364:
358:
357:
352:
325:
300:
299:
270:
269:
160:
159:
629:
628:
624:
623:
622:
620:
619:
618:
604:
603:
566:
563:
554:
534:
501:
498:
489:
481:
465:
456:
450:
421:
386:
378:
372:
368:
362:
355:
313:count updated.
312:
297:
294:
285:
284:
275:
219:Edit period(s):
105:
101:
96:
35:
26:
25:
24:
12:
11:
5:
627:
617:
616:
602:
601:
600:
599:
598:
597:
596:
595:
594:
593:
592:
591:
590:
589:
588:
587:
532:
448:
350:
293:
290:
287:
286:
281:
280:
277:
276:
273:
95:
94:
88:
83:
78:
73:
68:
63:
58:
53:
48:
46:Approved BRFAs
43:
36:
34:
29:
18:Knowledge:Bots
15:
9:
6:
4:
3:
2:
626:
615:
612:
611:
609:
586:
582:
578:
574:
573:
572:
569:
558:
553:
552:
550:
546:
542:
538:
533:
531:
527:
523:
518:
513:
509:
508:
507:
504:
493:
485:
479:
478:
477:
473:
469:
468:
463:
455:
449:
447:
443:
439:
435:
434:
433:
429:
425:
424:
419:
414:
413:
412:
408:
404:
400:
399:
398:
394:
390:
389:
384:
377:
367:
351:
349:
345:
341:
336:
332:
328:
327:
326:
324:
320:
316:
310:
306:
303:
279:
278:
272:
271:
268:
264:
262:
258:
254:
252:
249:
246:
242:
240:
237:
234:
233:
228:
226:
222:
220:
216:
215:
212:
208:
206:
203:
199:
195:
193:
191:
186:
184:
182:
177:
175:
171:
169:
165:
161:
157:
154:
151:
148:
145:
142:
139:
136:
133:
130:
127:
124:
121:
118:
115:
112:
109:
104:
100:
92:
89:
87:
84:
82:
79:
77:
74:
72:
69:
67:
64:
62:
59:
57:
54:
52:
49:
47:
44:
42:
38:
37:
33:
23:
19:
537:HouseBlaster
516:
511:
460:
416:
381:
301:
295:
274:Query to run
265:
256:
255:
250:
247:
244:
243:
238:
235:
230:
229:
224:
223:
218:
217:
210:
209:
204:
197:
196:
188:
187:
179:
178:
173:
172:
163:
162:
152:
146:
140:
134:
128:
122:
116:
110:
98:
97:
40:
474:· he/they)
430:· he/they)
395:· he/they)
221:Continuous
190:Source code
185:JavaScript
164:Time filed:
567:SandDoctor
502:SandDoctor
292:Discussion
192:available:
176:automatic
156:ANI search
150:rights log
138:page moves
126:edit count
86:rights log
76:page moves
577:DannyS712
557:DannyS712
535:And yes,
492:DannyS712
438:DannyS712
340:DannyS712
144:block log
103:DannyS712
99:Operator:
81:block log
608:Category
541:Primefac
522:Primefac
484:Primefac
403:Primefac
315:Primefac
248:(Yes/No)
236:(Yes/No)
114:contribs
56:contribs
20: |
512:thought
466:Blaster
422:Blaster
387:Blaster
517:might
462:House
418:House
383:House
227:Lots
61:count
16:<
581:talk
545:talk
526:talk
472:talk
442:talk
428:talk
407:talk
393:talk
344:talk
319:talk
309:talk
253:Yes
194:TBD
183:(s):
132:logs
108:talk
91:flag
71:logs
51:talk
41:BRFA
564:The
499:The
241:No
168:UTC
120:SUL
66:SUL
610::
583:)
547:)
528:)
496:--
457:}}
451:{{
444:)
409:)
379:}}
373:{{
371::
369:}}
363:{{
346:)
338:--
321:)
170:)
579:(
559::
555:@
543:(
524:(
494::
490:@
486::
482:@
470:(
440:(
426:(
405:(
391:(
353:(
342:(
329:@
317:(
307:(
251::
239::
158:)
153:·
147:·
141:·
135:·
129:·
123:·
117:·
111:·
106:(
93:)
39:(
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.