vb.org Archive
Page 35 of 143 « First 253334 35 36374585135 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Mini Mods - Email reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=138946)

C Braithwaite 03-30-2007 06:17 PM
Quote:
Originally Posted by Fungsten (Post 1215773)
What about these other conditions?
what about which other conditions?

Exitilus 03-30-2007 06:25 PM
Is there any way i can get this thing to e-mail me ? I want to make sure the HTML is coming out correctly heh ..

TheEDIGuy 03-30-2007 06:42 PM
Installed, configured, and running well so far. Thanks!

PassLab.net 03-30-2007 07:35 PM
Quote:
Originally Posted by djbaxter (Post 1179492)
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");
Quote:
Originally Posted by C Braithwaite (Post 1179665)
that is something i never thought of - i will update that in the php later today. cheers

Well guys, I really loved this hack thanks Braithwaite! and thanks djbaxter for your help...

I ve installed this hack last week. I ve just noticed that it still sends e-mails to the banned users...

what should I do? Banned usergroup is 8 in my board and I didnt add them in the AdminCP where it says:

Code:
List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7
the remindermail.php which I ve got from you is like this:

Code:
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
how are we gonna fix this?

thanks a million

NaughtyStud 03-31-2007 03:20 AM
Nice Mod, thank you and clicked Install. ;)

cajunboy2208 03-31-2007 03:37 AM
Thanks for this program. I just installed it, and sent out the e-mails. I am hoping to get a few members back. Thanks once again for this great mod!
MOTM Nominee for me!

C Braithwaite 03-31-2007 04:43 PM
Quote:
Originally Posted by PassLab.net (Post 1216364)
Well guys, I really loved this hack thanks Braithwaite! and thanks djbaxter for your help...

I ve installed this hack last week. I ve just noticed that it still sends e-mails to the banned users...

what should I do? Banned usergroup is 8 in my board and I didnt add them in the AdminCP where it says:

Code:
List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7
the remindermail.php which I ve got from you is like this:

Code:
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
        $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
how are we gonna fix this?

thanks a million

I don't understand why the code needs fixing?

Fungsten 03-31-2007 07:13 PM
What I was asking you about was what other settings could there be where email would not get sent? Should I ask that question in the other forum for general questions?

Quote:
Originally Posted by C Braithwaite (Post 1216303)
what about which other conditions?

PassLab.net 04-01-2007 12:43 AM
Quote:
Originally Posted by C Braithwaite (Post 1216936)
I don't understand why the code needs fixing?
It is sending e-mails to the banned users :) thats why I ve asked for your help...

C Braithwaite 04-01-2007 06:18 AM
Quote:
Originally Posted by Fungsten (Post 1217052)
What I was asking you about was what other settings could there be where email would not get sent? Should I ask that question in the other forum for general questions?
maybe it is just a case of you dont have any inactive users?

the code works like this:
  • Find inactive users based on last visit/last post
  • Check previously returned inactive users against usergroups
  • Check aforementioned inactive users for receive admin email settings

if a users is considered inactive, is a member of specified usergroups, and has selected to be sent admin emails then an email will be sent.
if any one of the previous is not true then an email will not be sent.

if you increase the quantity, it is more likely to send emails out.

Quote:
Originally Posted by PassLab.net (Post 1217154)
It is sending e-mails to the banned users :) thats why I ve asked for your help...
there is nothign wrong with thequoted code - the usergroup checking comes later.

make sure your users which are banned are not part of any other usergroups.

the code will check each member against the list of usergroups specified, and if they are a member of that usergroup then they will be sent an email. it uses vbulletin's is_member_of function.


All times are GMT. The time now is 11:02 AM.
Page 35 of 143 « First 253334 35 36374585135 Last »
Show 40 post(s) from this thread on one page

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.05111 seconds
  • Memory Usage 1,755KB
  • 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
  • (6)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
  • (4)pagenav_pagelinkrel
  • (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