Inactive User Management

Inactive User Management
Description

This Hack lets you automatically prune inactive Users based on several conditions.
It can be configured in ACP / vBulletin Options / vBulletin Options / Inactive User Management.

Details
1 Product XML with 1 Plugin, 4 Phrases and 5 Settings

History
1.0.0
Initial Version

1.0.0 Build 2
Fixed 2 Phrases

1.0.0 Build 3
Fixed broken query in uninstall code

Warning
This Hack is Beta, provided AS-IS.
I take no responsibility, whatever might appen when using this.

I strongly recommend NOT to use this in a production environment!

Please only click Install if you actually have installed/are using this Hack, and click Uninstall whan you don't use it any longer!

[WNxWakko]

Well, I guess for those that it worked, great and for those that it doesn't too bad so sad. No support. Uninstalling.

[Harry72]

Thx Andi. Installed it. Great Hack !:banana:

[VaaKo]

/me clicks install

[Konstantinos]

is there any way to make awaiting acti auto prune by X days and registered autoprune for Z days, guess not

i got this email

atabase error in vBulletin 3.5.4:
Invalid SQL:
SELECT userid, username, email, languageid FROM vbuser
WHERE usergroupid IN ()
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND lastactivity < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -180 DAY));
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ')
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
' at line 2
Error Number : 1064
Date : Tuesday, May 16th 2006 @ 09:15:25 PM

[Annapurna]

Hello,

After installing - which was fine - I've got this mail:

Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:

SELECT userid, username, email, languageid FROM trekkingforum_user
WHERE usergroupid IN ()
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND lastactivity < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -180 DAY));

MySQL-Fehler : You have an error in your SQL syntax near ')
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND ' at line 3
Fehler-Nr. : 1064
Datum : Wednesday, May 17th 2006 @ 12:03:18 AM
Skript : http://www.trekkingforum.com/forum/cron.php?&rand=289400
Referrer : http://www.trekkingforum.com/forum/index.php
IP-Adresse : xx.xx.xx.xx
Benutzername : Unregistriert
Klassenname : vb_database

Hmmm,
Is it normal? will it work properly? Or is it better to uninstall again?

Andreas

[cOuNtErFiET]

so is this working cause i do have a productive board and would love to add this hack so i do not have to go through each user and click delete...please reply if you have tried it and working for you i use 5.4 too btw...

Thanks
CF

[cOuNtErFiET]

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT userid, username, email, languageid FROM vb_user
WHERE usergroupid IN ()
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND lastactivity < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -180 DAY));

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND ' at line 2
Error Number : 1064

guess its not working... maybe missing the .TABLE PREFIX. ?

[Neo_obs]

It works on my test forum and if Andreas doesnt mind I would like to work on this a little bit and maybe add the feature of moving to another usergroup and fixing the syntax errors if i can.

[cOuNtErFiET]

please do , i get an error everyday cause of that sql up ther eand would like to get the SQL to add with the table prefix in it so that i can use it...if you cvan help me that would be great...

Thanks
CF

[cOuNtErFiET]

ok thanks for your offer to help Neo, but i have got it had to uninstall and reinstall it and it worked so my server must have glitched or something...but all is well now i believe no more SQL errors yet...lol