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 users to new usergroup (https://vborg.vbsupport.ru/showthread.php?t=178069)

blue6995 10-29-2008 06:51 AM

Quote:

Originally Posted by Paul M (Post 1654816)
No idea what that is, but its nothing to do with this mod. This does not have an associated cron of its own - like I said above, it taps into the standard daily update cron.

Thanks Paul. I get it now, doh!

Once the Daily Cleanup ran, inactive members were moved to the Usergroup I set up.

Deviant K1 10-30-2008 09:09 AM

INSTALLED! Thanks for the hack :)

AdrianH 11-17-2008 02:30 PM

Ran this mod before in the earlier v3.7 versions and it worked fine.

Re-installed it with v3.7.4 and the usergroups don't change, this error message is received some hours later when the cron job runs.

Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:

UPDATE forum_user
SET usergroupid = 16
WHERE usergroupid IN(02,)
AND lastactivity < 1219107463;

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 lastactivity < 1219107463' at line 3
Error Number : 1064
Request Date : Monday, November 17th 2008 @ 12:57:43 AM
Error Date : Monday, November 17th 2008 @ 12:57:43 AM
Script : http://www.xxxxx.org/cron.php?rand=1226883462
Referrer : http://www.xxxxx.org/f29/jenny-mccarthy-726/
IP Address : 92.237.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Paul M 11-17-2008 04:27 PM

You need to check the mods settings, you appear to have 02, in the List of Checked Groups setting, you need to remove the comma.

AdrianH 11-17-2008 04:46 PM

Thanks Paul,tried that and all appears to work again.

nibb 11-20-2008 05:53 PM

Im looking to accomplish something similar so I was searching and found this mod. I think this mod would work for what I need. Im willing to pay for this modification.

It needs to be changed so instead of moving inactive users to a usergroup it moves users that are registered from a specific IP to a usergroup and runned in cron automatically.

Please see my thread here of what i need:
http://www.vbulletin.com/forum/showthread.php?p=1654720

If someone is willing to do this I can pay him something. My forum is new im not rich but since im not a php programmer someone that is or the author can help me do modify it so it works the way i need.

Thanks to all.

tjh4384 12-06-2008 05:44 PM

Thanks!

badheeu 03-28-2009 12:32 PM

waiting for mod 3.8.1

Paul M 03-28-2009 04:43 PM

Quote:

Originally Posted by badheeu (Post 1778916)
waiting for mod 3.8.1

Maybe your should read the first post more carefully ;)

King Diamond 04-30-2009 04:38 PM

Hello Paul M, i instaled your Hack and setup it to move the inactive members to another group, unfortunly i didnt know that it also moves the inactives that had coments to the coopa users.

more then 20 thousand members, but wen i go check the coopa group it dont show any users.. and for me reactivate 20 thousand aconts one by one its imposible.

do you have any solution for me please?

thanks!


All times are GMT. The time now is 11:58 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.01121 seconds
  • Memory Usage 1,739KB
  • 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_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
  • (10)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