vb.org Archive - Mini Mods - Email reminder for inactive users

Page 7 of 143

« First

107

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)

Chadi

02-11-2007 01:43 PM

I only want to email to usergroup ID 2 and 3. How can I set this up?

carpefile

02-11-2007 01:44 PM

Quote:

Originally Posted by djbaxter (Post 1179836)

At the risk of telling you something you already know, I don't believe there is a "Banned" group by default in vBulletin - mine is ID=20 but it may be different for others so you'll need to make that a variable.

I also got a parsing error when making that change. I only edited the usergroup to match my board's banned id.

@C Braithwaite- I'm not sure the cron job is running, it doesn't show in the log even though logging is enabled. It runs manually when you push the run button, but nothing in the log indicates it ran. I set it to run every ten minutes for 1 hour every night 100 mails per (just till it catches up with the 1500 or so inactive members, then will set it to run once weekly).

Also noticed there is no title, description, or log phrase listed in the scheduled task.

It may be running without making any log entries, I don't know.

Thanx again, once the bugs are ironed out, this will be extremely useful to a ton of peeps.

djbaxter

02-11-2007 02:14 PM

Quote:

Originally Posted by carpefile (Post 1179890)

I also got a parsing error when making that change. I only edited the usergroup to match my board's banned id.

OK. Good to know. I haven't actually yet tried my suggested modification yet - my first attempt at installing the addon (original version) crashed my email server - my fault for setting the number of emails too high but I'm now waiting for some of these bugs to be fixed before I reinstall.

Can you tell me what the parsing error was? What did it object to?

Quote:

Originally Posted by carpefile (Post 1179890)

once the bugs are ironed out, this will be extremely useful

It will indeed.

carpefile

02-11-2007 03:38 PM

unexpected t string error in line 19.

C Braithwaite

02-11-2007 03:42 PM

what i hope to do is create a list of usergroups and let you select which you send to.

i hope to iron out all bug, and ill look into the cron to see if it is running.

bazzup

02-11-2007 03:47 PM

installed tody and already got one lost member back good job

djbaxter

02-11-2007 04:40 PM

Quote:

Originally Posted by carpefile (Post 1179963)

unexpected t string error in line 19.

Of course. Sorry - left out a quotation mark. Try this (my example excludes two member groups for my forums) and uses lastactivity instead of lastpost:

Code:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND ". TABLE_PREFIX . "usergroup != 20  AND ". TABLE_PREFIX . "usergroup != 23 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 ". TABLE_PREFIX . "usergroup != 23 AND emailDate 

< '$datetime[lastemail]' LIMIT $quantity");

Edit: Sorry - that SQL syntax is also incorrect.

My head hurts - any SQL gurus here?

WEBDosser

02-11-2007 07:32 PM

cool.. uninstalled and re-installed the new version, looks a lot better :)

projectego

02-11-2007 09:57 PM

Thanks for the update. :)

BobbyBig

02-11-2007 10:01 PM

I took a look at your code - now I uninstalled this Mod. The frequency which can be set in the admincp is a lie.

Frequenzy just inceases the Time when the Email will be send again. It doesnt mean for "1" that it only will be send 1 time, but thats how you wrote it...

That means Inactive Users will receive the email every X days of not posting when Y days are over.

Also you ever thought about one thing: 15 Days Inactivity, Frequenzy 1, Emails Send: 50.
15*50 = 750

That means in this Period only 750 Inactive Users get the email, after this OTHER inactive users are not effected by this rule, instead the Users which allready received emails will receive email AGAIN.

You should work on the logic for that.

regards

All times are GMT. The time now is 11:50 AM.

Page 7 of 143

« First

107

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01559 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 (4)pagenav_pagelink (3)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
Messages: