Thread: Mini Mods - Email reminder for inactive users
View Single Post
  #56  
Old 02-11-2007, 04:26 AM
C Braithwaite's Avatar
C Braithwaite C Braithwaite is offline
 
Join Date: Jan 2006
Location: Leeds
Posts: 293
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by chadi View Post
I just installed, manually ran scheduled task "emailreminders" and for some reason it only sent to about 20 people. I have 7,300 members and many have not logged in for a long time. How can this be?
it send emails out in small batches which can be amended in the options

Quote:
Originally Posted by rezapci View Post
thanks for hack, but dude, how this ting works? I just installed it, what should I do next?

I cant find any Option on vbOption!
it's there.

Quote:
Originally Posted by rezapci View Post
god, someone tell how to fix this, it keep sending this to all memmbers as:

We've noticed that you've not been active on mished for quite some time now, and we miss you!
Could we not tempt you back?
If you don't remember your password, you can request it here: http://www.mished.co.uk/forum/login.php?do=lostpw
We hope to see you soon

Kindest Regards
YOURSITE


What a unprofessional Hack Installations Directions

what the world you don't explain right to all user step by step what the heck we should do man.!

crab
I've given what i thought are ample instructions. upload, import, edit options. tell ya what - write you're own then eh?

Quote:
Originally Posted by djbaxter View Post
Would this do it?

Find:

Code:
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
Change to:

Code:
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]'  AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
that is something i never thought of - i will update that in the php later today. cheers
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01297 seconds
  • Memory Usage 1,783KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete