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)

djr 03-18-2003 06:08 PM

Quote:

Glad it worked for you djr :) Losing so many members must have been painful though.
Yeah, actually it was, but they weren't contributing anyway, so no real hard done.
I was wondering why you used lastactivity instead of lastvisit?

I have this user (which wasn't deleted):
Lastvisit: 2000-11-24 23:16:11
Lastactivity: 2003-02-24 18:05:25
Lastpost: 2000-11-24 23:11:56

I know I could easily replace lastactivity by lastvisit, but wanted to check with you first.

amykhar 03-18-2003 06:18 PM

What's the difference between the last activity and a last visit? I think I need to research that. Either would be fine though. You could even use lastpost if you wanted to kill off lurkers.

Amy

TheEDIGuy 03-18-2003 07:45 PM

I've found that lastactivity is more accurate. Lastvisit might not get updated if the user is visiting with cookies. I frequently have lastivits that are 2-3 days old, but the lastactivity is today, and I know they were on the site today.

What I'm more curious about - how many members did you originally e-mail about inactivity, and how many got deleted for not having visited? In other words, how many inactive members were convinced to come back because of the program?

amykhar 03-18-2003 08:52 PM

EDIGuy, I have a confession to make. The first time I tested this hack, I didn't have the templates installed on the style I use; so I sent blank emails to over a hundred users. The blank emails actually inspired them to come see what was going on :D

Amy

djr 03-18-2003 10:01 PM

If I recall well, about 150 users returned to the board out of the approx. 1750 users that were emailed. Most of the 1750 had non-working email adresses (I use a 365 year timespan)

- djr

TheEDIGuy 03-18-2003 10:13 PM

I hate non-working e-mails. I don't do the verification, because I find it turns off prospective members. So, I have the birthday hack and this hack, and if any e-mail bounces, the user's account is deleted immediately, no questions asked. I figure I only ask them for one thing, if they can't do that, too bad.

The hack is prompting some of my missing members to return, but unfortunately, seems to be bringing back members I was happy they'd gone as well. It's a double-edged sword.

But I still love it.

amykhar 03-19-2003 02:05 AM

EDIGuy, I was sneaky. I went and bumped the activity date of some members I would rather not see again before the emails were sent. :D

Amy

TheEDIGuy 03-19-2003 11:30 AM

Good idea. A while back, we ran off a large group of people we were happy to see go. I deleted the accounts of the worst offenders, but the rest of them got notices when I first ran it. A couple came back (but they were much more decent without their friends around).

I still haven't hit my 30-day mark when the big reminder goes out again, but it'll be interesting for me to compare it with last month's initial send, to see how many came back.

I think my initial e-mail was 468, and now is about 14 per day.

wolfe 03-19-2003 08:35 PM

with the other none active members list hack it only classes people as none active if they have not posted in 1 mounth can u add this to the hack please so you can have it not logged in for X days aand/or nopt posted for X days would make this hack the best around for what i does :D

amykhar 03-19-2003 09:15 PM

Wolfe, this addon will do what you want.

In manageInactive.php find:

PHP Code:


$countEmail 
0

Add above:

PHP Code:

$lastpostcut 2592000


Find:
PHP Code:

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

Replace with:
PHP Code:

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


That should do it for you. Tweak the $lastpostcut to be what you want. Currently it is set for 30 days.

Note: This addon is not tested. Use at your own risk.


All times are GMT. The time now is 10:52 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.01119 seconds
  • Memory Usage 1,744KB
  • 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
  • (4)bbcode_php_printable
  • (1)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