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.

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?

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?

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

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

Doug

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

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

Greetings,
Matthias

I dont see why we couldnt use it.

Anyone else know?

Doug

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

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

*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

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

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

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

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 :)

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

Greetings,
Matthias

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

Main reason: Time

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

sweet
ty

Hey Andreas,
please correct this code in the downloadable file :)

Thank you,
regards Ben.

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

https://vborg.vbsupport.ru/showpost....1&postcount=56
https://vborg.vbsupport.ru/showpost....3&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.

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

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.

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.

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

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

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

ciao take care

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

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

/me clicks install

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

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

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

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

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.

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

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