Roy Smith <r...@panix.com> ezt írta (időpont: 2022. nov. 2., Sze, 18:19):
> There's a bunch of block reason templates such as {{blocked proxy}},
> {{webhostblock}}, etc. They don't always get used, but they're good things
> to look for before you fall back to just comment_text like '%proxy%'
>
This works for huwiki, and we have only one.
>
> I don't think you need to check for ipb_expiry != 'infinity'. People who
> know SQL better than I do would know for sure, but I think the previous
> clause (ipb_expiry < now() + interval 1 month) would always be false in
> that case.
>
Unfortunately not, I tried without that, and a lot of infinities appeared.
So this was a workaround. I think MySQL is very loose with types, and in
your original version expiry date was a string constant. Numbers are before
letters. I modified it to show always one month, thus my comparison uses a
date type, while 'infinity' is still a string, and seems to precede dates.
_______________________________________________
pywikibot mailing list -- pywikibot@lists.wikimedia.org
To unsubscribe send an email to pywikibot-le...@lists.wikimedia.org
