vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   Find, Optionally Email and Optionally Delete Inactive Members (https://vborg.vbsupport.ru/showthread.php?t=48964)

hypedave 04-28-2003 05:36 PM

Quote:

Today at 01:35 PM iggy123 said this in Post #80
is there anyway of setting this hack up so that it does include people in a certain usergroup ie admins / moderators

Yeah that will be like a nice add on, I have users that take vacations, so it would be nice to place them in a temporary vacation group, and have that group id be un touch by this hack, what ya think Amy?

amykhar 04-28-2003 05:49 PM

it would be cake for you to adjust the query. Just change the "WHERE lastactivity<$cutoffdate and emailDate<$dateCut" to "WHERE lastactivity<$cutoffdate and emailDate<$dateCut and usergroupid != X"

With X being the usergroup you want to exclude.

Amy

iggy123 04-28-2003 09:06 PM

Quote:

Today at 07:49 PM amykhar said this in Post #82
it would be cake for you to adjust the query. Just change the "WHERE lastactivity<$cutoffdate and emailDate<$dateCut" to "WHERE lastactivity<$cutoffdate and emailDate<$dateCut and usergroupid != X"

With X being the usergroup you want to exclude.

Amy

if i were to alter it too

"WHERE lastactivity<$cutoffdate and emailDate<$dateCut and usergroupid != X and usergroupid! = Y"
would it include both the groups?

iggy123 04-28-2003 09:15 PM

Quote:


$userArray=$DB_site->query("SELECT username,userid,email,adminemail,emailDate FROM user WHERE lastactivity
<$cutoffdate and emailDate<$dateCut and away==0 ORDER BY username");

This would exclude anybody who set themself as away. [/B]
shouldnt that be
Code:

$userArray=$DB_site->query("SELECT username,userid,email,adminemail,emailDate FROM user
WHERE lastactivity<$cutoffdate and emailDate<$dateCut and away =0 ORDER BY username");

Sorry if i am wrong but i don't know much php etc and it just looked incorrect.

amykhar 04-29-2003 11:51 AM

Yes, iggy. You caught a typo. Thanks.

Amy

hypedave 04-29-2003 06:04 PM

also would there be away to get a report of what user accounts are in the process of being deleted if they dont log back on after the notification email?

amykhar 04-29-2003 07:52 PM

I thought this one emailed the admins? Don't remember and am too lazy to scroll back up. If it doesn't find the hack that deletes members who never click the validation link and grab the email code from that.

Amy

iggy123 04-29-2003 07:53 PM

yea it does mail the admin well i got one anyhow LOL

GaleForce 04-29-2003 08:03 PM

This hack looks cool, I'm going to probably install it later. Its so tedious doing a find users by last post date, since you need to format the date in a weird way and email them individually :)

Cyricx 06-02-2003 09:36 PM

NM, problem fixed. User Error ;)

Question, can we make this hack run only on a specific usergroup?

For example, registered members (usergroupid 2).

allan grossman 07-05-2003 03:47 AM

I have it installed and working fine.

I haven't been able to figure out how to pass a username and password to the script to run it as a cron job, though.

The job runs fine but fails due to the lack of authentication.

Help?

amykhar 07-05-2003 12:35 PM

Quote:

Today at 12:47 AM allan grossman said this in Post #91
I have it installed and working fine.

I haven't been able to figure out how to pass a username and password to the script to run it as a cron job, though.

The job runs fine but fails due to the lack of authentication.

Help?

You uploaded the file to the wrong directory. It goes in forums and not in admin.

Amy

allan grossman 07-05-2003 01:50 PM

*reads instructions again*

Oops.

Thank you, Amy.

kadafi_alive 01-06-2005 07:20 AM

Does this work for VBulletin 3.0.3 as well?

walidaly 04-23-2008 01:15 AM

this hack needs an update


All times are GMT. The time now is 01:02 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.01344 seconds
  • Memory Usage 1,746KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (15)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