vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - Move Inactive and Lurker Users To New Usergroup (https://vborg.vbsupport.ru/showthread.php?t=231874)

Paul M 04-10-2010 11:42 AM

Technically you could probably modify the sql into something really horrible to do this - but I wouldnt recommend trying. :)

Julie 04-11-2010 10:42 AM

Quote:

Originally Posted by Paul M (Post 2018883)
Technically you could probably modify the sql into something really horrible to do this - but I wouldnt recommend trying. :)

Oh ok, thanks, then I won't try altering the SQL :D

blue6995 04-30-2010 08:50 PM

Quote:

Originally Posted by Paul M (Post 1967421)
Well I suppose you could read the options ;)

BTW, those users are not in COPPA, they will have a usergroup of zero - its just that vbulletin has no u/g of zero, so it shows the first one in the list.

I too must learn to read! I installed this mod but then got called away before I could make any changes. Consequently, I didn't get round to setting the Lurker cut off point to 0 until the next day. Of course, by then, I presume the daily check had been run and loads of my members have been moved to usergroup 0, which is preventing them accessing some parts of the forum and getting a message they have been banned.

Other than going through every member that hasn't made a post for 90 days, is there an easier way I can get them back to the registered users group from usergroup 0?

Many thanks

Paul M 05-01-2010 01:15 PM

Try setting the lurker group as usergroup 2, it should then move them all to that next time it runs.

Otherwise you can just run a bit of SQL :

Code:

UPDATE user SET usergroupid = 2 WHERE usergroupid = 0

blue6995 05-01-2010 02:12 PM

Quote:

Originally Posted by Paul M (Post 2030057)
Try setting the lurker group as usergroup 2, it should then move them all to that next time it runs.

Otherwise you can just run a bit of SQL :

Code:

UPDATE user SET usergroupid = 2 WHERE usergroupid = 0

Paul, many thanks. I ran the SQL, which worked a treat!

Raptor 05-18-2010 03:10 PM

Is there a lurker option for the 3.8.x mod ?

I only see inactive option. Thanks.

Paul M 05-18-2010 06:17 PM

Nope, its only in the 4.0 version.

Raptor 05-18-2010 07:31 PM

Thanks Paul M

OK can you help me structure an SQL query then please ? :)

basically to update a usergroup id if belongs to X where join date is before Y and activity after Z with posts less than A

example move users from registered ug to lurker ug if they registered before 2010-01-01 and visited the board after 2010-05-01 with posts less than 1

Bouncer222 05-21-2010 09:33 PM

nvm

Ken Sanders 05-22-2010 01:52 AM

Wow! Exactly what I need! Will this work with 4.0.3? If so, count me in and I'll happily donate!
Managing users has been a real pain.

ArchAngelz 05-22-2010 02:52 AM

Following up from this comment, I was also wondering if we could have an option to flag lurkers and inactives as a secondary group; leaving the Primary as Registered Members or whatever it used to be?


Quote:

Originally Posted by Boots (Post 1945020)
Any chance of adding that ability? I'd like to be able to flag lurkers with an additional usergroup so I can treat them differently but it would break everything if I changed their primary group.


Paul M 05-23-2010 11:17 AM

Quote:

Originally Posted by Ken Sanders (Post 2041709)
Wow! Exactly what I need! Will this work with 4.0.3? If so, count me in and I'll happily donate!
Managing users has been a real pain.

It will work with any 4.0.x version.

Paul M 05-23-2010 11:18 AM

Quote:

Originally Posted by ArchAngelz (Post 2041726)
Following up from this comment, I was also wondering if we could have an option to flag lurkers and inactives as a secondary group; leaving the Primary as Registered Members or whatever it used to be?

Sorry, this is for primary usergroup only, and thats unlikely to change.

Ken Sanders 05-23-2010 01:10 PM

Nice mod. Many thanks. Marked as installed, nominated and donated

Adam H 06-01-2010 07:56 PM

Has there been any reports of this mod telling members they are banned and changing their usergroups to Administrators ? I use this on most of my forums however a client has used it and has come up against this problem , the problems didnt start until this was installed , just trying to figure out whether the mod could possibly do it or has whether someone has been playing some other settings

Paul M 06-05-2010 10:49 AM

Well in theory this could move you to a banned or admin group - if you were silly enough to set it up to do that.

KissOfDeath 06-12-2010 08:05 PM

thanks for the mod,
can i make a request though?
is it possible to auto move users after making 3 or 5 new posts instead of just 1?
i foresee that a lurker will make a post asking why he's been moved to the lurker usergroup or has decreased permission settings, then being automatically returned back to the member user group when they havn't really contributed to the forums...

Paul M 06-13-2010 07:54 PM

No, thats not possible without re-designing they way it works - it doesnt count posts, simply checks if one has been made.

pant 06-14-2010 09:21 AM

Installed and rated.

This is evry handy to use on conjumction with User Promotions.

Feature Request. Do be able to set multiple Inactive/Lurker rules.

Thanks
Stuart

pant 06-14-2010 09:23 AM

Quote:

Originally Posted by KissOfDeath (Post 2052642)
thanks for the mod,
can i make a request though?
is it possible to auto move users after making 3 or 5 new posts instead of just 1?
i foresee that a lurker will make a post asking why he's been moved to the lurker usergroup or has decreased permission settings, then being automatically returned back to the member user group when they havn't really contributed to the forums...

This would also be good but I'm happy with the way that it works at the moment anyway.

Webbstre 06-16-2010 06:16 AM

I've had this installed for about a day and a half now on my test installation, and still there is no change in my users' usergroup associations. Any idea what could be wrong?

If it helps, my board was recently imported from phpbb3 and drupal, but everyone's original join dates stayed the same so I can't imagine that the import would cause anyone to have been said to be online.

pant 06-16-2010 09:48 AM

You won't have any activity status though will you?

Movement 07-05-2010 01:49 PM

*** installed ***

Thanks for the mod, but i have one question:
Once the user is being moved in the Lurkers, posted a message, he moved to the main usergroup, but his status is not changed (remains "Lurker"). How can I force the automatic change of status (according to the criteria the main usergroup)?

Paul M 07-05-2010 04:53 PM

Im not really sure why it would say Lurker in the first place, this does not set the usertitle.

Movement 07-05-2010 05:35 PM

Paul M, Ok, I will explain:

1. There is a usergroup "Lurkers", for it defined the special status "Lurker"
2. There is a usergroup "Users", for it special status not defined
3. Defined the following overall statuses (for example):
- 1-10 messages - "Beginner"
- 11-20 posts - "Advanced"
- 21-30 message - "Local"
- etc...
4. The user has 15 posts, belongs to the usergroup "Users" and has the status "Advanced"

This user is silent for some time and moved in a usergroup "Lurkers", it is given the status "Lurker". Then the user writes a message and automatically moved to the usergroup "Users", but he remains the status "Lurker". How can in this case will automatically be returned to him status "Advanced"?

Paul M 07-06-2010 12:16 AM

I understood your question - however, like I said, I do not know why it would say Lurker in the first place.

In your example ;

Quote:

This user is silent for some time and moved in a usergroup "Lurkers", it is given the status "Lurker"
There is no code in the mod to set usertitles (the bit in red) so something else is doing that.

Obviously, there is no code to reverse something it isnt doing in the first place.

Movement 07-06-2010 10:45 AM

Paul M, Clearly, thanks for the clarification. Apparently changing the status occurred during scheduled update statuses.

goran424 07-07-2010 06:38 AM

I've installed this on vBulletin 4.0.2 Patch Level 4 and 8 inactive members were moved to administrators group.....very scary! I guess i doesn't really work with 4.0.2. Love this mod but obviously it doesn't work for me. Installed but disabled until find out what the problem is.

Paul M 07-07-2010 06:33 PM

It works perfectly with any version of 4.0. It can only move people to the usergroups you define in the settings.

caciocode 08-17-2010 08:01 PM

Tagged

Lovinmysailor 08-17-2010 08:15 PM

You are my hero! I am going to install this sometime tonight or tomorrow. Thank you!

jj 08-17-2010 08:17 PM

I would like to say thanks for the mod and place a request for a third movement option: move members having below x posts to a specific usergroup and move them back if they pass the posting value. I think this could be a nice addition.

Firestorm17 08-21-2010 03:45 AM

Great mod Paul!

I have suggestion for the next version if there's one.

Separate the Inactive and the Lurker options.

Im only interest in the Lurker options , but if i put 0 in inactive when i run the daily update i get inactive error and doesnt do anything , so i have to put a number in the inactive higher than the number in the lurker.

It would be good , because you know different people require different thing's , that way its more flexible and i think its no that hard to rewrite...i would do it but my thing it's xml and sql xD.

Again great mod and thank you very much! i use a lot of your's mods

Paul M 08-21-2010 10:05 PM

Thats simply a bug, you should be able to disable either.

Paul M 09-12-2010 11:44 AM

Above issue fixed in 4.0.5.

sulasno 09-12-2010 03:34 PM

tagged and thanks

How can I suggest to vBulletin to incorporate all your mods to the software ?

Paul M 09-12-2010 11:27 PM

Vbulletin.com ;)

Janmaat 09-13-2010 09:03 AM

If an inactive user have been moved to the special usergroup. How can I reactive him manually? As I've receive a request by the user to activate his account again.

I fear If I move his account to the standard registered usergroup, he will be moved back again after the next cronjob.

Paul M 09-13-2010 09:59 AM

He will not be moved if hes active before the cron runs.

ETDC 09-20-2010 04:45 PM

Looks good but two quick questions:

? Will this work in 3.8.6?

? When the users are moved to, say, a group which doesn't allow signatures or profile info, will said information be stripped out/removed by the system automatically?

:)


All times are GMT. The time now is 04:12 AM.

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.01391 seconds
  • Memory Usage 1,819KB
  • 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
  • (2)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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