vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - Automatic Inactive Users Pruning - vB3.7 RC2 (https://vborg.vbsupport.ru/showthread.php?t=177403)

J98680Bxxxxx 04-27-2008 10:00 PM

Automatic Inactive Users Pruning - vB3.7 RC2
 
Originally Created by NeoRevan (in 2005) for vB 3.0.7.

I could not run NeoRevan?s version on vB3.7 CR2.

I also took a look at a similar Mod by Paul M (Dr Pepper Addict) on Inactive Users, but I missed some of NeoRevan?s features on it.

Thus I decided to update NeoRevan?s version to suit my needs on vB 3.7 CR2. If needed, I Will update it accordingly for vB3.7 Gold, once it?s released.

Feel free to use this Mod as you see fit, I just wished to share it with this Community. :up:

What this Mod does:
  1. Runs a daily cronjob, removing all members according to the script's configuration
  2. Exclude selected usergroups from been pruned
  3. Flag automatically selected user(s) for pruning after x days (7 by default)
  4. Email automatically selected user(s) that have been flagged (on by default)
  5. Has the ability to prune users that match ALL the following conditions:
    1. Has not visited in the last x days (30 by default)
    2. Has not posted in the last x days (30 by default)
    3. Has x or fewer posts (0 by default)
    4. Has been flagged for pruning earlier than x days (7 by default)
  6. Send email to pruned users, notifying them of their change in status membership (on by default)
  7. Send email to the admin (webmaster) for book keeping.

Installation instructions in the attachment. :)

KURTZ 04-28-2008 02:22 PM

basically this hack put the inactive users on a different user group right? have you tested it onto RC4?

J98680Bxxxxx 04-28-2008 02:34 PM

Quote:

Originally Posted by KURTZ (Post 1501525)
basically this hack put the inactive users on a different user group right? have you tested it onto RC4?

:up: Correct. No deletion performed.

I tested it on vB 3.7 CR2 and it works fine.

I haven?t installed the latest vB versions > 3.7 CR2, as I got tired of moving from one vB 3.7 beta xx to another vB 3.7 beta yy. Now waiting for the final vB 3.7 Gold, on which I will update the Mod if required.

setishock 04-28-2008 04:54 PM

Does it make the user group or do you have to manually set one up?

J98680Bxxxxx 04-28-2008 08:48 PM

Quote:

Originally Posted by setishock (Post 1501616)
Does it make the user group or do you have to manually set one up?

Manually set one and reference it in the configuration parameters.

Jasem 04-29-2008 08:44 AM

Thank you very much

slowphantom 04-29-2008 05:05 PM

nice mod thx
but is there a way to do not remove user
i was thinking to just move it to another group

Alien 04-29-2008 05:46 PM

Re-read the posts above for your answer. ;)

slowphantom 04-30-2008 10:04 AM

Quote:

Originally Posted by Alien (Post 1502544)
Re-read the posts above for your answer. ;)



yes got it thx

slowphantom 04-30-2008 10:11 AM

i got idea i hope it will do good jop

what about if the user read x post without posting answer will be moved too
that mean for all usere how log in and read therd without say thx or any thing will be moved to another group

i gusse we will need this option too

J98680Bxxxxx 04-30-2008 11:03 AM

Quote:

Originally Posted by slowphantom (Post 1503176)
i got idea i hope it will do good jop

what about if the user read x post without posting answer will be moved too
that mean for all usere how log in and read therd without say thx or any thing will be moved to another group

i gusse we will need this option too

If your forum is not a READ ONLY forum, if a user has read x posts without posting a reply in the last x days, you can still have it pruned by adjusting the value of "$lastactivity" to 0 or 1 in the configuration file. But choose your values accordingly so that they apply is a consistent manner as the days go by and your forum is running.

Charlie98902 05-13-2008 03:17 AM

With the setting you told us to use this is generating every 24 hours I think is there a way to have this done monthly only and how do I go about that please?

J98680Bxxxxx 05-13-2008 05:16 PM

Quote:

Originally Posted by Charlie98902 (Post 1517871)
With the setting you told us to use this is generating every 24 hours I think is there a way to have this done monthly only and how do I go about that please?

Hi Charlie,

You can specify when you wish to have the cron executed in the ACP -> Scheduled Task Manager -> Prune Inactive Members (Edit)

To have it executed every 29th (at 00:00) of the month for example, select the value 29 from the "Day of the month" drop down selection. :up:

Title : Prune Inactive Members
Day of the Week : *
Day of the Month : 29
Hour : 0
Minute : 0
Active : Yes

Charlie98902 05-13-2008 08:21 PM

Thank you I thought it was a small tweak such as this.

Mum 05-14-2008 09:37 AM

Installed, however it appeared to only flag 2 users, which is incorrect... i didn't get an email or anything tell me...

BluAzn 05-21-2008 09:41 AM

I am having problems using this mod, most of the users haven't posted over months and still their status is still there. I have adjusted the configuration of the file, help would be great. I wanted to prune the users to the "Newbie" status.

J98680Bxxxxx 05-21-2008 10:46 AM

Quote:

Originally Posted by BluAzn (Post 1526657)
I am having problems using this mod, most of the users haven't posted over months and still their status is still there. I have adjusted the configuration of the file, help would be great. I wanted to prune the users to the "Newbie" status.

Which configuration parameters are you using?

BluAzn 05-21-2008 12:30 PM

Code:

// Configuration parameters

// The user must had logged in the forum in the last x days
$lastactivity = 5;

// The amount of days an user stays "flagged" before been pruned
$flaggedtime = 7;

// The user must have posted in the forum in the last x days
$lastpost = 5;

// Users with more than this amount of posts will not be pruned
$maxposts = 100;

// Set this to true to email the members that are been pruned
$sendmail = true;

// This is the UserGroup that will receive pruned members.
// If you do not have such usergroup already available,
// please create one and refer to its id number here.
$groupid = 2;

// Set here the usergroups you do NOT wish to have modified,
// seperate each groupid with a space
$exclude = "6 7 5 13 133 9 136 134 12 60 135 11";

// End Configuration parameters


Super Jinni 05-21-2008 06:42 PM

and what about if the users who got pruned signed in and/or post a thread or post?
do they automatically remove to the group which they were belonged to before pruning?

thank you for this, I didn't notice it just now..
and currently I'm using Paul's which I really like.. but as you said, it has not features as yours..

are they work in the same way with Paul's or there is differences?

J98680Bxxxxx 05-21-2008 07:24 PM

Quote:

Originally Posted by BluAzn (Post 1526801)
Code:

// Configuration parameters

// The user must had logged in the forum in the last x days
$lastactivity = 5;

// The amount of days an user stays "flagged" before been pruned
$flaggedtime = 7;

// The user must have posted in the forum in the last x days
$lastpost = 5;

// Users with more than this amount of posts will not be pruned
$maxposts = 100;

// Set this to true to email the members that are been pruned
$sendmail = true;

// This is the UserGroup that will receive pruned members.
// If you do not have such usergroup already available,
// please create one and refer to its id number here.
$groupid = 2;

// Set here the usergroups you do NOT wish to have modified,
// seperate each groupid with a space
$exclude = "6 7 5 13 133 9 136 134 12 60 135 11";

// End Configuration parameters


Hi BluAzn,

I suppose that you are placing your registered members in usergroup(s) different from the standard "Registered Users" group (of Id = 2)?

Please ensure that the Usergroup that will receive pruned members is different from the usergroup(s) where those members are selected before been flagged or pruned.

Let me know if that's not the case.

J98680Bxxxxx 05-21-2008 07:31 PM

Quote:

Originally Posted by Super Jinni (Post 1527176)
and what about if the users who got pruned signed in and/or post a thread or post?
do they automatically remove to the group which they were belonged to before pruning?

thank you for this, I didn't notice it just now..
and currently I'm using Paul's which I really like.. but as you said, it has not features as yours..

are they work in the same way with Paul's or there is differences?

There is no automatic removal from the "Pruned Usergroup", simply because, in my forum for example, moderator(s) must ensure that pruned users are not just posting non sense of the type "Thank you, nice thread" or "Thank you, keep up the good work", etc... over and over just to get unpruned.

The basic principle for pruning is the same as with Paul's Mod. Read the "What this Mod does" from the Thread text above.

Super Jinni 05-22-2008 11:13 AM

ok, I think I like this one more than Paul's Mod

I guess I have to uninstall Paul's Mod in order to install this one right?

and I think if you can make an option for the automatic removal from the "Pruned Usergroup" to turn it on/of according to some conditions depending on the cases that user has moved to the "Pruned Usergroup"

to be honest with you, I've been using Paul's Mod for a while no, and there are some users who they have been in the "Inactive Usergroups" ,and I'm afraid if I Uninstall Paul's Mod I'll have some problems with those who are now in the "Inactive Usergroup".

any suggestions?

:)

J98680Bxxxxx 05-22-2008 11:38 AM

Hi Super Jinni,

It's up to you how you want to use these two mods. I don't think that this Mod and the one from Dr. Peper conflict. Just ensure that you specify the same usergroup Id for prumed members. In any case, you can always move pruned members to any other usergroup manually from your ACP -> Usergroups -> Usergroup Manager.

It is possible to have an automatic removal from the "Pruned Usergroup" according to some conditions. You can use the cron of this mod as basis and just change the SQL query accordingly. :)

Super Jinni 05-22-2008 12:55 PM

ok then, I'm gonna give it a try.. I'll install it beside Paul's Mod..

if I have any problem, I'll post it here..

thanks

:)

Zelda-King 05-26-2008 03:31 PM

I just ran the first cron job on 3.7 Gold. Some users were 'pruned' but they weren't put in the specified usergroup. Would that be because they'd already been inactive for well over the specified time and thus immediately deleted or what?

Am using the following config:
Code:

// The user must had logged in the forum in the last x days
$lastactivity = 365;

// The amount of days an user stays "flagged" before been pruned
$flaggedtime = 7;

// The user must have posted in the forum in the last x days
$lastpost = 365;

// Users with more than this amount of posts will not be pruned
$maxposts = 1;

// Set this to true to email the members that are been pruned
$sendmail = true;

// This is the UserGroup that will receive pruned members.
// If you do not have such usergroup already available,
// please create one and refer to its id number here.
$groupid = 23;

// Set here the usergroups you do NOT wish to have modified,
// seperate each groupid with a space
$exclude = "5 6 7 10 22";


J98680Bxxxxx 05-26-2008 06:13 PM

Quote:

Originally Posted by Zelda-King (Post 1531944)
I just ran the first cron job on 3.7 Gold. Some users were 'pruned' but they weren't put in the specified usergroup. Would that be because they'd already been inactive for well over the specified time and thus immediately deleted or what?
...

Hi Zelda-King,

On the first cron job, users get flagged, not pruned yet. Nothing get deleted. Users are moved from one usergroup to another only after the specified flagged time.

Ensure that you actually have the specified usergroup Id = 23 created, also checkout the usergroup ID of those members that were 'pruned'.

:)

Zelda-King 05-26-2008 06:22 PM

Hello!

Well that would explain it then. Nicely timed response too! I was just wondering why no one had changed to that usergroup and yet my member count hadn't gone down either.

What I'm not sure about is how to find which users have been flagged. Oh, and are they e-mailed at this stage or on being pruned?

J98680Bxxxxx 05-26-2008 08:23 PM

Hi,

Those members flagged receive an e-mail notifying them of their situation and asking them to improve their activity status. When the specified flagged time expire, they get 'pruned' and also receive a second e-mail notifying them of their change in status.

To find users that have been flagged, you can use phpMyAdmin (on your server CPanel) and view the (last column of) user table.

Hope it help. :)

Mum 05-26-2008 10:17 PM

What does the email say? (i'm not sure how to find it to read it)

Zelda-King 05-27-2008 03:45 AM

Perfectly clear. Thanks for clearing that up!

J98680Bxxxxx 05-27-2008 08:18 AM

Quote:

Originally Posted by Mum (Post 1532300)
What does the email say? (i'm not sure how to find it to read it)

Open the attached document, using WordPad, and check it out.

Marvin Hlavac 06-21-2008 05:32 PM

Hi all :)

Can this mod delete members automatically, not just move them to another group? I'd like a mod that would delete all my members with 0 posts, who have not been active for one year, and also I'd like to delete all members who have been in the "Waiting for email confirmation" group for over 30 days.

Vinyljunky 07-18-2008 02:57 PM

Installed and working.

Thank you

polgara_j 07-25-2008 05:30 AM

Installed this mod but have received database errors each time I've tried to run it.
Error:
Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE `user` SET `deleflag` = '1216967229' WHERE `userid` = '91';

MySQL Error : Unknown column 'deleflag' in 'field list'
Error Number : 1054
Request Date : Thursday, July 24th 2008 @ 11:27:09 PM
Error Date : Thursday, July 24th 2008 @ 11:27:09 PM
Script : http://www.houseofmoms.org/admincp/c...cron&cronid=19
Referrer : http://www.houseofmoms.org/admincp/c....php?do=modify
IP Address : 64.xxx.xxx.xxx
Username : polgara_j
Classname : vB_Database
MySQL Version : 4.1.11-Debian_4sarge7
any ideas?

J98680Bxxxxx 07-25-2008 07:24 AM

Quote:

Originally Posted by polgara_j (Post 1583590)
Installed this mod but have received database errors each time I've tried to run it.
Error:

any ideas?

Did you follow those instructions on creating the database TABLES? :)

Panagioths 07-27-2008 02:20 PM

Hello and thanks for the nice mod. Is there a chance to make a cron job that put back users that have visited the forum back to registered users?

J98680Bxxxxx 07-27-2008 04:45 PM

Quote:

Originally Posted by Panagioths (Post 1585275)
Hello and thanks for the nice mod. Is there a chance to make a cron job that put back users that have visited the forum back to registered users?

Almost no chances to sit down and write one. The reason is due to the fact that the cron was written to encourage users to become active in posting. If a user is just visiting the board without posting anything, he can well stay in the "pruned" box if he/she has been pruned. If the "pruned" user decide to create a post, I haven't found a way to automatically check that what the "pruned" users will be posting: spams just to get unpruned or will effective posts? Thus, I use a manual process to move a "pruned" user back to the "registered" usergroup.

polgara_j 08-02-2008 06:03 PM

Quote:

Originally Posted by J98680B2423E (Post 1583642)
Did you follow those instructions on creating the database TABLES? :)

Actually the issue was that one of the other admins forgot to change the vb language from swedish. :rolleyes: Once we changed it to the standard latin thing your addon worked. :) Thanks, it's a great mod!

Davey-UK 10-28-2008 12:42 PM

Really wish this could include an option to add a user back to the registered usergroup once they are active again.

You mention that the cron could be tweaked to do this???

Any chance of doing it. All my members are in the registered usergroup, and i wouldnt have VIP members included in this mod anyway, so it should just be a straight role reversal??

Any ideas would be greatly appreciated. I may even pay for this mods upgrade. Basically we just dont have the time to monior users continuously. We want it really to stop members playing in the arcade and never even looking at the forum! We could use the vBcredits mod, but its far too intrusive and long winded for this simple option that we require.

Thanks for a great mod though and hopefully you will shed a bit of light on this issue.

:D

popmyzit 02-16-2009 11:09 PM

yeah would be nice to move users back once active again


All times are GMT. The time now is 04:54 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01459 seconds
  • Memory Usage 1,841KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete