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!

[Yorixz]

Originally Posted by KirbyDE

> deling users makes your user # go donw
Only if you delete more Users then new ones register
I use this on my Board since several month (6 month/14 day set), and the # User keeps increasing.

Myself I would say; who cares about the amount of registered users if like the half of it is inactive; they won't contribute to your forum at all.

Ontopic; very nice mod, I'll see if I can get this to work later

[Boofo]

Did we forget a table here, Kirby?

PHP Code:

 $db->query_write("DELETE FROM " . TABLE_PREFIX . " WHERE filename='./includes/cron/inactiveusers.php'"); 


[Yorixz]

Just wondering; how "beta" is this mod? Any chance it'll ++++ up and just delete all my users or something?

[Andreas]

Yes, that could happen.

[Oblivion Knight]

I got this error e-mail sent to me this morning.. I assume it's related to this plugin.

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

SELECT userid, username, email, languageid FROM 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 pmto
Error Number : 1064
Date : Wednesday, September 14th 2005 @ 06:43:27 AM
Script : http://www.gamerseuphoria.com/forum/...p?&rand=116136
Referrer :
IP Address : xx.xxx.xxx.xx
Username : Unregistered
Classname : vb_database

Any ideas?

[Andreas]

Yes.
Do you have selected any Usergroups to be affected?

[Oblivion Knight]

Yes.

Registered Users and Users Awaiting Email Confirmation.

[Andreas]

Strange.
Can you check the Value of $vbulletin->options['inactivegroups']?

[Oblivion Knight]

According to phpMyAdmin, the value is 2,3.

[Andreas]

Did you check Table setting or datastore (the later one is important, as this is where $vbulletin->options comes from)?