My script uses the log table, so if they hade made a contribution they are not deleted, but I will change it, to check if they have an active contribution.
the "create account" is active, so feel free to test it (the database will be dropped afterwards). Jan. @RBG, we will get to 2012 hopefully before we reach 2013 :-) thanks to all that helps deleting files. On 22 December 2012 23:21, TJ Frazier <tjfraz...@cfl.rr.com> wrote: > On 12/22/2012 16:40, janI wrote: > >> On 22 December 2012 22:32, TJ Frazier <tjfraz...@cfl.rr.com> wrote: >> >> On 12/22/2012 11:17, janI wrote: >>> >>> On 22 December 2012 17:10, RGB ES <rgb.m...@gmail.com> wrote: >>>> >>>> 2012/12/22 janI <j...@apache.org> >>>> >>>>> >>>>> Before I upgrade our database (and system) to 1.20.2 I would like to >>>>> >>>>>> >>>>>> clean >>>>> >>>>> some of the dead stuff. >>>>>> >>>>>> I would apriciate if some of the sysop could help me with >>>>>> - looking at special page/unused files and delete them (during upload >>>>>> people are warned this will happen) >>>>>> >>>>>> >>>>>> I started to delete some unused files. There are an awful lot of >>>>> them... >>>>> >>>>> That is why I need some help :-) >>>>> >>>> >>>> but it does not matter if it takes a bit of time..I will not do the >>>> upgrade >>>> until end of year. >>>> >>>> >>>> >>>> >>>> Regards >>>>> Ricardo >>>>> >>>>> >>>>> >>>>> - looking at special page/unsed categories and delete them (WATCH >>>>> out, >>>>> >>>>>> at >>>>>> least one russian template has a remark "please do not delete") >>>>>> >>>>>> there are too much for me alone. >>>>>> >>>>>> Once it has been done, I will clean it from the database, so we have a >>>>>> slimmer system, without loosing any information. >>>>>> >>>>>> Jan. >>>>>> >>>>>> >>>>>> >>>>> Hi, Jan, >>>> >>> >>> Cleaning out some files, I found a lot of students doing their homework >>> on >>> the wiki :/ so I hope you will run your "delete stale unused accounts" >>> script again, and with the date updated to the next month. We should get >>> rid of a lot of stale accounts. >>> >>> Thanks for helping, the list seems endless :-( >> >> I will run the script again, but not until the upgrade is done, and if the >> students have uploaded images they will not be deleted, my script searches >> for users with no contributions of any kind, however I can modify it (if >> the community agrees) to search for users with my PAGE contributions. >> >> The users in question no longer have files uploaded; they've been > deleted. If your script counts deleted contributions as active, then yes, > please change it. Otherwise, the accounts will disappear properly. > > >> >> >>> BTW, I am adding a request to the Wiki Maintenance page, to install the >>> "CheckUser" extension. I want to use that to fight the spammers. >>> >>> I looked at the extension, I can load that, no problem...but if I >> understand it correctly it does not help identifying already created >> users. >> >> The extension is no help in identifying new spammers, but it's a great > help in chasing them, by complaining to the ISP. I have all the bookmarks > for that, from my time as a ML moderator. > > It's also helpful in identifying multiple accounts for the same user > (which is okay, unless they're all spammers!). > > > Did you have a look at the new create account page, on wikitest, that is >> not easy for the average spammer to bypass. >> >> It certainly looks ferocious! I hope it works. > /tj/ > > jan I. >> >> >>> /tj/ >>> >> > > >
