vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Mini Mods - Email Reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=237531)

usefee 10-06-2013 06:15 PM

work with 4.2.1?

DemOnstar 10-06-2013 06:21 PM

Hopefully I will get a result in less than 13 days...

Loki12 10-06-2013 07:30 PM

Quote:

Originally Posted by usefee (Post 2450489)
work with 4.2.1?

Yes it does, works fine. And, it has already boosted my active membership. Indispensable mod.

usefee 10-09-2013 07:21 AM

Quote:

Originally Posted by Loki12 (Post 2450499)
Yes it does, works fine. And, it has already boosted my active membership. Indispensable mod.

thanks
download the original file from first post or modified it with this thread posts!?

usefee 10-14-2013 10:13 AM

nobody!?

rhody401 10-15-2013 01:16 PM

The one from the author works great with 4.2.1 and youll have no trouble with the instructions.

DemOnstar 10-20-2013 04:00 PM

This one seems to work! 4.2.1.

:up:

honda208 11-09-2013 08:42 PM

Is this still a working add-on? I have 4.2.2, thanks.

thernus 02-02-2014 09:02 PM

After I install the hack I get this error message via mail:

Quote:

Invalid SQL:
SELECT userid, username, email, usergroupid, FROM_UNIXTIME(lastvisit) lastvisit, FROM_UNIXTIME(lastactivity) lastactivity, CASE WHEN lastpost = 0 THEN '' ELSE FROM_UNIXTIME(lastpost) END AS lastpost, CASE WHEN rmEmailDate = 0 THEN '' ELSE FROM_UNIXTIME(rmEmailDate) END AS lastreminder, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastvisit, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastactivity, CASE WHEN lastpost = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastpost), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastpost, CASE WHEN rmEmailDate = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastemail, rmoptout FROM vb3_user WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND usergroupid IN ('3','18','22','23','21') AND rmEmailCount = 0 AND options & 16 AND rmoptout = 0 LIMIT 0, 50;;

MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_last' at line 1
Fehler-Nr. : 1064
Is there a way to fix it?


THX
th

M.C. 03-08-2014 08:31 AM

It's working but gives me error in AdminCP -> Settings:
Warning: trim() expects parameter 1 to be string, array given in [path]/includes/adminfunctions_options.php on line 1032


All times are GMT. The time now is 10:18 PM.

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.01692 seconds
  • Memory Usage 1,736KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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