[Marek58]

Polish version

[gwerzal]

Could be very useful for one of my sites.

Thank you.

[BozzaJos]

Tagged for future use, thanks for the hard work!

[tornado88]

Worked for me... did exactly what it said it would do.

I only used the test and manual delete function....

Maybe later, I'll try the cron enabled function.

In any case - thanks for the handy utility!

[cobaku]

it works
thank you

[Vitaly]

Code is completely refactored to make it clear & more effective. Blogs & SG support added.

After upgrade your previous rules wil be disabled. Please, check those manually & enable again.

[BadgerDog]

Installed with thanks for testing on 4.04 ....

We'd like to use it to clear out any users "Awaiting Email Confirmation" user group who haven't responded to validation email in 14 days or more ...

Regards,
Doug

[phr4nk13]

That'S exatly what i've searched for. Thanks.

But I gat a SQL/database-error with it when selecting "User has never posted (also count in social groups and blogs)" and test this option.


With my little SQL knowlegde and some Try and Error this function_users_cleanup.php (attachment) is working i think. Anyway please chekc my changes if there are any security mistakes.

Is there a chance to include custom profilefields in the options?

Using vBulletin Suite 4.1.2. German

Sorry for my bad english

[Vitaly]

Thanks for your help. Could you tell full text of SQL error?

May be, problem can be with scopes, but "never posted" condition works at my forum. Can't accept your patch into mainline, because you removed table prefix - that will not be compatible with all installations. But i'll try to do somerthing, if you tell me more info about error. Please, tell me also your SQL version & exact selections set in your cleanup rule, that cause problems.

[phr4nk13]

I didn't remove the table prefix, i added it. That ist the errormessage onli with this option "User has never posted (also count in social groups and blogs)" selectet and clicked on "test":

Datenbankfehler in vBulletin 4.1.2:

Invalid SQL:
SELECT
`user`.*
FROM
vb_user AS user
LEFT JOIN vb_groupmessage ON `groupmessage`.postuserid = `user`.userid
LEFT JOIN vb_blog_text ON `blog_text`.bloguserid = `user`.userid
WHERE
`user`.`posts` = 0 AND `groupmessage`.gmid IS NULL AND `blog_text`.blogtextid IS NULL AND `user`.`userid` NOT IN (0);

MySQL-Fehler : Unknown column 'groupmessage.gmid' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 21.03.2011 @ 20:23:28
Datum : Monday, 21.03.2011 @ 20:23:28
Skript : vbroot/admincp/users_cleanup.php?do=test
Referrer : vbroot/admincp/users_cleanup.php?do=add
IP-Adresse : xXx
Benutzername : xXx
Klassenname : vB_Database
MySQL-Version : 5.1.43-nmm4-log

I was first trying to hardcode the prefix. Than i got the variable to work.

That are the only lines i changed:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[BadgerDog]

Does the last few posts mean there's a problem with the mod and we should put it's use on hold for now?

Thanks ...

Regards,
Doug

[phr4nk13]

Thats only a problem at my installation (atm) and the last option selected. If you push "test" you can try it yourself. All other options working fine for me.

[Vitaly]

Thanks again for your efforts. Try 0.4 updated version.

[phr4nk13]

Yay it works. Thanks

And now my question from above: Is there a chance to include custom profilefields in the options?