Inactive User Management

[Andreas]

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!

[Boofo]

Ok, I'll bite. ;)

[Neal-UK]

Ok, I'll bite. ;)

I will, only when someone else does first......does it work ok Boofo? lol

[kall]

Cool!

Oh, in userdelnotification, it should be 'respond', not 'response'.

And... how well do linebreaks work in these body phrases?

[Andreas]

Hmm, linebreaks should work as they do in all other eMail Body Text Phrases too.

I'll fix the phrase when I got time, seems to be a minor issue ;)
Guess that happened as I first wanted to write "As we got no response ..."

[ThePimp]

I will install this when someone has tested it and found no errors. :)

[kall]

It doesn't seem to be picking up the usernames.

(Yes, I somehow missed the huge warning, and am running it on nzb. ;) )

Dear . It has come to our attention that you have registered at...

[Andreas]

Hmpf. In Phrase userinactivitywarning it should be $user[username] instead of $username ... slipped through the porting process :)

[Azhrialilu]

You're on a roll, Kirby! Another nice one :D

[Cyricx]

Awesome!!

[simon.]

I would love this in a non beta stage... Can Someone email me when its ok to use it?

[Andreas]

I think it will never leave Beta stage. :)

[FD929]

I think it will never leave Beta stage. :)

Why not?

[Andreas]

Because Beta Software by definition isn't supported :D

[Jenta]

idea - instead of prune, move

[Andreas]

I'll consider this for future Versions :)

[FrozenCreations]

umm, is i posible to make this mod.hack, not delete the user, just continue to e-mail them until they come and post?

deling users makes your user # go donw :(

[Andreas]

Set the Timespan between Notification and Deletion veeeeery high (like 3650 => 10 Years), then they will not be deleted.

[Andreas]

Set the Timespan between Notification and Deletion veeeeery high (like 3650 => 10 Years), then they will not be deleted.

> 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.

[FrozenCreations]

yeah, that will happen with me... it will shoot down!

[Yorixz]

> 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? ;)

$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/cron.php?&rand=116136
Referrer :
IP Address : xx.xxx.xxx.xx
Username : Unregistered
Classname : vb_databaseAny 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)?

[Oblivion Knight]

It appears to be the same in both the table setting and the datastore.

[Andreas]

Then this is more then strange.
Did you try to ran the cronjob it manually?

[Oblivion Knight]

Then this is more then strange.
Did you try to ran the cronjob it manually?Nope, it attempted to run automatically.

[havefun]

* havefun clicked install

nice mod. THX! :)

[matthias.m]

Does this Add-On work with vB 3.5 Gold too?

Greetings
Matthias Mönch

[Boss-Hog]

I have this hack installed and set the inactivity amount at 365. Shortly after that, some of my users started getting the following email:

Dear [user].

It has come to our attention that you have registered at
[forum] more then 0 days ago, but didn't login
again since.
Did you forget about us?
We would be happy to see you around again!

If you don't login again within 7 days from now, we will delete your
account.

I went into the options in the admin CP and the setting that had been at 365 somehow been changed to 0. I bumped it back up to 240 (roughly 8 months). Two questions: 1). any idea why this would have changed to 0 (is there a limit on this value?) and 2). how do I prevent those users who received the email from being deleted after the time between warning and removal elapses? Thanks.

[Flow Fusion]

Thank you great hack.

[Boss-Hog]

I have this hack installed and set the inactivity amount at 365. Shortly after that, some of my users started getting the following email:



I went into the options in the admin CP and the setting that had been at 365 somehow been changed to 0. I bumped it back up to 240 (roughly 8 months). Two questions: 1). any idea why this would have changed to 0 (is there a limit on this value?) and 2). how do I prevent those users who received the email from being deleted after the time between warning and removal elapses? Thanks.

Now, I'm getting a LOT of emails from my forum's users asking why they're getting that email. Is 365 too high of a number to use or why else would it have 'reset' to 0? Most importantly, how do I prevent these users from being deleted by the hack? Thanks.

[Boss-Hog]

Can someone PLEASE let me know what I need to do so that the massive amount of users who were incorrectly marked for deletion via cron will not be deleted when the "Time between Warning and Removal" is reached very soon? Thank you.

I have this hack installed and set the inactivity amount at 365. Shortly after that, some of my users started getting the following email:



I went into the options in the admin CP and the setting that had been at 365 somehow been changed to 0. I bumped it back up to 240 (roughly 8 months). Two questions: 1). any idea why this would have changed to 0 (is there a limit on this value?) and 2). how do I prevent those users who received the email from being deleted after the time between warning and removal elapses? Thanks.

[Andreas]

Normally, it should not happen that users are tagged incorrectly.
What are your exact settings?

[Boss-Hog]

Normally, it should not happen that users are tagged incorrectly.
What are your exact settings?

Andreas,

Six days ago, I had increased the inactivity amount from the default (180 days) to 365 and saved my settings. The cron processed its daily job and shortly aferwards, I noticed that that this setting had somehow been changed from 365 to 0, which resulted in users being incorrectly tagged for deletion. I have since changed it back to 180 and that value is being retained. On 11/9, I can see from the cron log that a large amount of users were tagged for deletion in 7 days, which is what that value is set at, based on the 0 value that had been in there at the time. Even though I have changed this back to 180, how do I avoid these users that were tagged for deletion when the value was 0 from being deleted after 7 days? Thank you.

[Andreas]

Setting either interval to 0 is kinda pointless ;)

Anyway, I changed to code to do nothing in this case.

[Boss-Hog]

Setting either interval to 0 is kinda pointless ;)

Anyway, I changed to code to do nothing in this case.

Right, I didn't actually set it to 0 - somehow, the value was changed from 365 to 0. In any event, how do I remove the users that were marked for deletion during the time the value was 0?

[Andreas]

The cronjob will remove tagged users automatically, as this is what this Hack is for.

[Boss-Hog]

The cronjob will remove tagged users automatically, as this is what this Hack is for.

But since these users were incorrectly tagged (due to the days being set at 0) how can I have the cron NOT delete them, since they are truly not inactive users?

[dcpaq2xx]

Has anyone talked to the Vbulletin staff about this idea yet?

This would be an awesome feature to have come standard with Vbulletin.

Doug

[dcpaq2xx]

Does anyone have anything new to report on this mod?

If the majority of the "bugs" have been worked out id be willing to try it out myself.

Again this would be an excellent feature to come standard with Vbulletin.

If only the developers at VB would bit. :(

Doug

[matthias.m]

I think, that we can not use this Hack for vB 3.5.x???

Greetings,
Matthias

[dcpaq2xx]

I dont see why we couldnt use it.

Anyone else know?

Doug

[matthias.m]

It works on vB 3.5.3!

But other Question: This Hack taggs Users as inactive if they don`t log in after the specified amount of Days.

On my Board i will need a Hack that marks Users as inactive if they haven`t postet a amount of X Posts in the last Y Days - is this possible?

Greetings,
Matthias

[dcpaq2xx]

Another thing I would like to add to the questions...

Can we get this hack to NOT delete the users who are tagged as inactive but just move them over to a another user group or custom group instead of actually deleting them permanetly? Or have a choice in the admin control panel to choose between either one?

This is just incase they should come back a day, week, or what ever after they would have been deleted, this way if we just moved them to a hidden or different user group all we would have to do to restore them is move their user account back into the users group they were previously in again.

Doug

[Julie]

*pokes the author*

As dcpaq2, I would like this mark users from forum X (and all it's child forums if possible automatically) if they haven't posted in Y days. I too would like it to then, if a user is proved inactive, move it from usergroup A and into usergroup B.

Possible? :D Because that would make me one happy webby! :D

[Andreas]

I do not need the requested features and therefore won't add them.
Sorry.

[Julie]

It was worth the poke :P Hehe... Well, should you be bored one day.... ;)

[dcpaq2xx]

I do not need the requested features and therefore won't add them.
Sorry.

You don't need the requested features???

So if this mod was for you then why are you even sharing it with us if your not willing to add new features to the mod? I don't understand your thoughts.

Doug

[Andreas]

Well, I create most of the Hacks I create for usage on my board - and I share them because I think others might benefit from them too.
Though, I rarely add features I don't need/am interested in implementing - that's the deal.
If you prefer I keep my stuff for myelf, no problem - I can do so in the future :)

[matthias.m]

If you prefer I keep my stuff for myelf, no problem - I can do so in the future :)

No, no, no, no absolutely NO - you can`t do that Andreas, you know ;)

Greetings,
Matthias

[dcpaq2xx]

Well, I create most of the Hacks I create for usage on my board - and I share them because I think others might benefit from them too.
Though, I rarely add features I don't need/am interested in implementing - that's the deal.
If you prefer I keep my stuff for myelf, no problem - I can do so in the future :)

Andreas,

I would rather see you keep sharing your hacks with us but its just that most of the people here who share their hacks here are usually always willing to add new features or build on it from what it was for those who request it, but your flat out not willing to unless you want it for yourself. I just don't understand WHY?

What "IF" we paid you to do requested features to your mods? Would you be willing to add requested features or functions if we paid you or is the answer still the same?

I like your mods over most of the other mods here, I really do, it's just that it would be really nice to see your mods grow with more features and such.

I do hope you'll reconsider.

Doug

[Andreas]

Main reason: Time

Therefore I only add features that really interest me or that I do need as well.

[bloodwrath]

sweet
ty

[Ben?]

Hey Andreas,
Did we forget a table here, Kirby? ;)

$db->query_write("DELETE FROM " . TABLE_PREFIX . " WHERE filename='./includes/cron/inactiveusers.php'");
please correct this code in the downloadable file :)

Thank you,
regards Ben.

[Bison]

I won't install anything from this guy. He's too cocky for me and from the hacks he's posted that I found interesting, he does not support them. So people, why waste your time with this guy?

[Andreas]

Nobody forces you to install any Hacks.
If you don't like them, don't install them - easy as that :)

[Bison]

Nobody forces you to install any Hacks.
If you don't like them, don't install them - easy as that :)

I know that and its obvious that you don't care if anyone does, so why waste your time offering your half baked goodies? :rolleyes:

[Andreas]

https://vborg.vbsupport.ru/showpost.php?p=869391&postcount=56
https://vborg.vbsupport.ru/showpost.php?p=881563&postcount=88

Those are the reasons why I release Hacks.
As said before, I can just keep stuff for my own from now on - no problem :)
Though I still stink that at least some ppl appreciate my Hacks.

[Bison]

As said before, I can just keep stuff for my own from now on - no problem :)

Save us the drama ... thanks and have a good life! :)

[Streicher]

I won't install anything from this guy. He's too cocky for me and from the hacks he's posted that I found interesting, he does not support them. So people, why waste your time with this guy?

Nobody has to support the own hacks. Most are glad he has posted them. So, am I. His has written some of the best hacks ever. They are very usuable.

[WNxWakko]

This mod does not work. I set it up in settings, I manually run the cron and all it does is say

Inactive Users Cleanup

no done message, it doesnt purge the accounts, nothing.

[dcpaq2xx]

idea - instead of prune, move

If this program MOVED the user instead of PRUNNING them I would be using this program.

I dont want to delete them, I just want to move them to a different user group.

Doug

[Silvio]

Andreas, I have just upgraded from build 2 to 3.
but pls look at the new code as seems to be still build 2.

<product productid="inactiveusers" title="Inactive User Management" description="This Hack allows you to automatically prune inactive Users." version="1.0.0 Build 2" active="1">

Is that just a little typo or the archive wasen't upgraded?

ciao take care

[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 (http://www.trekkingforum.com/forum/cron.php?&rand=289400)
Referrer : http://www.trekkingforum.com/forum/index.php (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

[Annapurna]

I installed it a couple of months ago and it worked perfect.
I really don't want to miss it when upgrading!

Any experiences on 3.6?

Andreas

[lucky64]

Also wondering about 3.6

[HansMuenchen]

Hi Andreas!

Is that hack also working with 3.6.2 or you plan to make a new version for the VB 3.6.2 ?

Because that's the last Hack I REALY miss! Because that Hack help me to have a clean Forum.

Thanks for the Answer!

Greetings out of Munich
Hans

[Luggruff]

This works fine for me, I use 3.6.2

[cunder]

please make this also for 3.6.3

[alternity]

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.

I was wondering if you were still working on this? I'd absolutely love to be able to be able to move a person to a different usergroup based on inactivity. Thanks.

[richTV]

anyone tried this on 3.6.4 ?

TIA :)

[tuwebfacil]

anyone tried this on 3.6.4 ?

TIA :)

I want to know as well :)

[tschai]

Anyone know wheter there's an good non-beta alternative for this mod?

This is a very usefull mod, but a it's to important to be only beta...

[RedPoint]

Hi,
run this hack on 3.6.8 PL2 - yes or not?!

regards

[Konstantinos]

i use this on 3.6.8 and i thought it was working good but it doesnt. it wont delete any of the users who dont want to be deleted however i noticed while it deletes some users that need to be delete there are many others who should also have beleted but they arent. need fix asap