vb.org Archive

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 08-17-2008 11:40 AM

Quote:

Originally Posted by EagleNick (Post 1600660)
I'm running version 1.1.1 on vB 3.7.2PL1 and it's working fine.

I see that some other members are having errors with your later updates...?

I think I'm just going to stay put. I don't want it to break.

whichever works best for you really - i only decided to update this because of some people having issues. :)

C Braithwaite 08-17-2008 11:41 AM

Quote:

Originally Posted by RedPoint (Post 1600658)
Old plugin deinstalled, new installed, setting, run
Thank you CBraithwaite for this plugin

Regards

you are more than welcome - any feedback on the performance would be great!

Chimpie 08-17-2008 11:44 AM

It looks nice, but as soon as I make the mod active I get a database error:

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (0252','259','260,1070);

MySQL Error : 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 '','259','260,1070)' at line 3
Error Number : 1064
Request Date : Sunday, August 17th 2008 @ 07:43:25 AM
Error Date : Sunday, August 17th 2008 @ 07:43:25 AM
Script : http://www.skywarnonline.com/forums/...ime&order=desc
Referrer : http://www.skywarnonline.com/forums/...e&pp=20&page=1
IP Address : **********
Username : Dave
Classname : vB_Database
MySQL Version : 5.0.51a-community

Artes_Marciales 08-17-2008 11:51 AM

Thanks foro the update!! : )

¿work on vb 3.7.2??

djbaxter 08-17-2008 12:18 PM

I'm currently using 1.13 which is working well for me. I like the option to email the reports of who was sent an email and any invalid addresses. Could you inlcude that option in the next update?

ezurick 08-17-2008 12:24 PM

Quote:

Originally Posted by C Braithwaite (Post 1600637)
i have just updated the plugin to fix some bugs. I've also added some reports (see screenshots)



sorry about that - update the plugin and the bug should have been removed.

Ummm.. the last I checked, this forum is for 3.6 Mods and add-ons.. this is NOT 3.7!!!! I tried to update your lastest version and it states the product is for 3.7 and not compatible to 3.6... I am running 3.6 and refuse to upgrade... PLEASE move this mod to 3.7 and kill it here... or support the 3.6....

RedTrinity 08-17-2008 12:30 PM

Ok updated again and looking good!

This may sound silly, but how do you make it run? :confused::o I want to send out my first lot of reminder emails now but don't know how to initiate the process lol. Otherwise, is there a set time when it runs automatically (each day for example)?

Cheers again :)

RedPoint 08-17-2008 12:30 PM

sorry guys,
i mean by me its running, but here:
Quote:

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /forum/includes/cron/remindermail.php on line 82 Parse error: syntax error, unexpected T_STRING in /forum/includes/cron/remindermail.php on line 82
What is that guys?

Regards

frostyIntrepid 08-17-2008 12:38 PM

Hmm, may I know from where can I view the log entries that store where the emails are sent to?

djbaxter 08-17-2008 12:49 PM

Quote:

Originally Posted by GamerGirl27 (Post 1600691)
Ok updated again and looking good!

This may sound silly, but how do you make it run? :confused::o I want to send out my first lot of reminder emails now but don't know how to initiate the process lol. Otherwise, is there a set time when it runs automatically (each day for example)?

Cheers again :)

  1. Go to Admin CP | Scheduled Tasks | Scheduled Task Manager
  2. Scroll down to find Inactive User Reminder Emails
  3. Edit to set when you want the cron job to execute
  4. Click on Run Now to execute the task im mediately

C Braithwaite 08-17-2008 01:13 PM

Quote:

Originally Posted by djbaxter (Post 1600685)
I'm currently using 1.13 which is working well for me. I like the option to email the reports of who was sent an email and any invalid addresses. Could you inlcude that option in the next update?

I plan to update this - for the time being i have just added basic logging.

Quote:

Originally Posted by ezurick (Post 1600690)
Ummm.. the last I checked, this forum is for 3.6 Mods and add-ons.. this is NOT 3.7!!!! I tried to update your lastest version and it states the product is for 3.7 and not compatible to 3.6... I am running 3.6 and refuse to upgrade... PLEASE move this mod to 3.7 and kill it here... or support the 3.6....

Firstly - You've not even clicked install so you get ZERO support on any of the modification. Secondly there is no need for the attitude - I will quite happily move this to another section. It didn't even occur to me that the sections had been split up.

Quote:

Originally Posted by GamerGirl27 (Post 1600691)
Ok updated again and looking good!

This may sound silly, but how do you make it run? :confused::o I want to send out my first lot of reminder emails now but don't know how to initiate the process lol. Otherwise, is there a set time when it runs automatically (each day for example)?

Cheers again :)

Which version are you using? if it's 1.2 (designed for 3.7.2) then it runs continuously - you just have to enable it in it's option grop (see the screenshot as to were to find that).

Quote:

Originally Posted by RedPoint (Post 1600692)
sorry guys,
i mean by me its running, but here:


What is that guys?

Regards

I'm not currently supporting 3.6 versions until i have 3.7 perfected. backwards i know.

Quote:

Originally Posted by frostyIntrepid (Post 1600694)
Hmm, may I know from where can I view the log entries that store where the emails are sent to?

currently there is basic information about the users that have been contacted. this can be found in admincp/remindermail.php (or use the link under the "Users" section in the admin CP [see attached pictures])

kpascal 08-17-2008 01:30 PM

Quote:

Originally Posted by djbaxter (Post 1600698)
  1. Go to Admin CP | Scheduled Tasks | Scheduled Task Manager
  2. Scroll down to find Inactive User Reminder Emails
  3. Edit to set when you want the cron job to execute
  4. Click on Run Now to execute the task im mediately

I have just added this mod and can not find this task in the Scheduled Task Manager. Should it appear right away?

djbaxter 08-17-2008 01:53 PM

Quote:

Originally Posted by C Braithwaite (Post 1600704)
Which version are you using? if it's 1.2 (designed for 3.7.2) then it runs continuously - you just have to enable it in it's option grop (see the screenshot as to were to find that).

Quote:

Originally Posted by kpascal (Post 1600708)
I have just added this mod and can not find this task in the Scheduled Task Manager. Should it appear right away?

My apologies - I'm not using version 1.2 so my instructions don't apply. See Chris' response quoted from just above your post.

Moparx 08-17-2008 03:16 PM

I just upgraded to 1.2 and I have to say that 14 extra queries on each page is rather unacceptable.

C Braithwaite 08-17-2008 03:35 PM

Quote:

Originally Posted by Moparx (Post 1600779)
I just upgraded to 1.2 and I have to say that 14 extra queries on each page is rather unacceptable.

It only has the higher amount of queries when it finds inactive users. after a short while it will reduce as there will be less inactive users to contact. also if you disable the logging features it will reduce queries further, as will reducing the amount of users the mod processes.

I could take out 2 queries and mail directly - but i think this would only be disguising things by reducing queries not processing time.

This way the processing is distributed more - 14 queries is not going to effect performance anyway, especially not for a forum with under 500 users, of which 10% are active.

iogames 08-17-2008 03:43 PM

Grrr!

Doesn't work with 3.6.10

Quote:

This product is not compatible with version 3.6.10 of vBulletin. (Compatible starting with 3.7.2)

Moparx 08-17-2008 04:00 PM

Quote:

Originally Posted by C Braithwaite (Post 1600792)
It only has the higher amount of queries when it finds inactive users. after a short while it will reduce as there will be less inactive users to contact. also if you disable the logging features it will reduce queries further, as will reducing the amount of users the mod processes.

I could take out 2 queries and mail directly - but i think this would only be disguising things by reducing queries not processing time.

This way the processing is distributed more - 14 queries is not going to effect performance anyway, especially not for a forum with under 500 users, of which 10% are active.

Ah, I see. I'll leave it on and see how things go.
Another thing I noticed: I get a Database Error when I view Who's Online with 1.2 enabled

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb3_user AS user
WHERE userid IN (0586','755','757);

C Braithwaite 08-17-2008 04:14 PM

Quote:

Originally Posted by Moparx (Post 1600808)
Another thing I noticed: I get a Database Error when I view Who's Online with 1.2 enabled

This one is baffling me. it doesn't happen on mine so it's difficult to figure out what is causing it. do you have any other plugin that effects the WOL page?

Moparx 08-17-2008 04:21 PM

Quote:

Originally Posted by C Braithwaite (Post 1600832)
This one is baffling me. it doesn't happen on mine so it's difficult to figure out what is causing it. do you have any other plugin that effects the WOL page?

I have a Custom WOL Locations product installed but that's it.

Additionally, The problem seems to have gone away after Email Reminder finished processing users & sending out emails.

iogames 08-17-2008 04:26 PM

Can you confirm me that it works with 3.6.10?

C Braithwaite 08-17-2008 04:36 PM

Quote:

Originally Posted by iogames (Post 1600842)
Can you confirm me that it works with 3.6.10?


it should do, but i cant say for sure.. the previous versions worked with 3.6.8, and 1.2 works with 3.7.2.

iogames 08-17-2008 04:53 PM

well first I uninstalled the previous version, and then proceeded to upload the new files, tried to import and:

Quote:

The following dependencies were not met:

1. This product is not compatible with version 3.6.10 of vBulletin. (Compatible starting with 3.7.2)
Anyone else with this problem [or solution :(]

C Braithwaite 08-17-2008 05:21 PM

Quote:

Originally Posted by iogames (Post 1600856)
well first I uninstalled the previous version, and then proceeded to upload the new files, tried to import and:



Anyone else with this problem [or solution :(]


some of the features are not compatible with earlier versions - but i will release a version that IS compatible.. soon

|Jordan| 08-17-2008 05:27 PM

There's no scheduled task in 1.2, how does it run automatically?

iogames 08-17-2008 05:28 PM

Quote:

Originally Posted by C Braithwaite (Post 1600874)
some of the features are not compatible with earlier versions - but i will release a version that IS compatible.. soon

please-please... because I feel naked! :D

C Braithwaite 08-17-2008 05:49 PM

Quote:

Originally Posted by |Jordan| (Post 1600877)
There's no scheduled task in 1.2, how does it run automatically?

it uses various hook locations such as init_startup

C Braithwaite 08-17-2008 06:29 PM

Quote:

Originally Posted by iogames (Post 1600878)
please-please... because I feel naked! :D

done. remove all older versions. upload files, install product.

StonePilot 08-17-2008 07:03 PM

I got a "Database Error" too when I upgraded to 1.21. I'll try to reupload the files becuase I'm locked out of even my admincp now. Anyone else?

C Braithwaite 08-17-2008 07:13 PM

Quote:

Originally Posted by StonePilot (Post 1600941)
I got a "Database Error" too when I upgraded to 1.21. I'll try to reupload the files becuase I'm locked out of even my admincp now. Anyone else?

there was a bug and a half in 1.2.1 - i've hopefully erased that now. you need to go into phpMyAdmin and locate the "datastore" table and delete the row "pluginlist" and that will unlock the site. Go back into admin CP and remove the plugin.

StonePilot 08-17-2008 07:14 PM

Quote:

Originally Posted by suvari1794 (Post 1600617)
I am too :(

Code:

Database error in vBulletin 3.7.2:

Invalid SQL:

INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header) VALUES ('1218968479','caginsan@gmail.com','admin@amaney.com','Merhaba $username!','<p>Merhaba _-'CaGo'-_!</p>
<p>Baya?? bir zamand?r forumumuzda sizi g?remiyoruz. Forumumuza tekrar g?zatmak istemez misiniz?</p>
<p>E?er ?ifrenizi unuttuysan?z , buradan ?ifre talep edebilirsiniz:
<a
href="/login.php?do=lostpw">/login.php?do=lostpw</a></p>
<p>Sizi
yeniden aram?zda g?rmek dile?iyle...</p>
<p>&nbsp;</p>

<p><a href=""></a></p>
<p>&nbsp;</p>
E?er bu e-postalardan bir daha almak  istemiyorsan?z sitemize ?yeli?inizle giri? yapmal?s?n?z ve kontrol panelinizdeki  ayarlar?n?zdan "Administrat?rler Bilgi E-Mailleri G?ndersinler" se?ene?ini kald?rmal?s?n?z.','MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: _-'CaGo'-_ <caginsan@gmail.com>
From: Amaney.com Reminder Service <admin@amaney.com>
');

MySQL Error  : 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 'CaGo'-_!</p>
<p>Baya?? bir zamand?r forumumuzda sizi g?remiyoruz. Forumumuza te' at line 1
Error Number  : 1064

Request Date  : Sunday, August 17th 2008 @ 01:21:19 PM
Error Date    : Sunday, August 17th 2008 @ 01:21:19 PM
Script        : http://www.amaney.com/forum/komik-ya...eni-mesaj.html
Referrer      : http://www.amaney.com/forum/

IP Address    : ****
- Alıntı metni gizle -
Username      :
Classname    : vB_Database
MySQL Version :


I'm getting the same bug, and I have lost my ability to get into ADMINCP. :confused: Any advice?

C Braithwaite 08-17-2008 07:28 PM

Quote:

Originally Posted by StonePilot (Post 1600951)
I'm getting the same bug, and I have lost my ability to get into ADMINCP. :confused: Any advice?

see previous post...

StonePilot 08-17-2008 07:40 PM

Quote:

Originally Posted by C Braithwaite (Post 1600950)
there was a bug and a half in 1.2.1 - i've hopefully erased that now. you need to go into phpMyAdmin and locate the "datastore" table and delete the row "pluginlist" and that will unlock the site. Go back into admin CP and remove the plugin.

Ok, deleted the row and it came back.

Yeah, bugs suck ... but all software has them from Microsoft down to vb plugins. No long term harm, but I don't have to to any aerobics for a month. Great product, it's been very benefitial to helping grow my community.


** Update, now MYSQL is reporting that Datastore has been corrupted and needs to be repaired. **

StonePilot 08-17-2008 07:59 PM

Ended up having to rebuild the Datastore table and then going back in and deleting the lines again. Then logged in quickly and uninstalled the product and it's working fine and got it all back up.

iogames 08-18-2008 12:13 AM

Thanks Chris!

Like 2 months someone made a hack for the same purpose and ranted over your hack but I kept yours because I was happy with it...

Now that you upgrade, looks good and professional, I've not regret been waited for so long...
Seems to work like a charm!

C Braithwaite 08-18-2008 04:51 AM

Quote:

Originally Posted by StonePilot (Post 1600975)
Ended up having to rebuild the Datastore table and then going back in and deleting the lines again. Then logged in quickly and uninstalled the product and it's working fine and got it all back up.

I am so glad to hear it is working properly now! verry sorry for the problems ive caused, but thank you all so much for the feedback and bug reports!

Quote:

Originally Posted by iogames (Post 1601093)
Thanks Chris!

Like 2 months someone made a hack for the same purpose and ranted over your hack but I kept yours because I was happy with it...

Now that you upgrade, looks good and professional, I've not regret been waited for so long...
Seems to work like a charm!

Thank you verymuch - I do try my best :D

tekguru 08-18-2008 05:31 AM

So is this version now 100% debugged and vB 3.7.2 compatible?

bugriders 08-18-2008 06:05 AM

I have upgraded my board to 3.7.2 patch 1.

Some members asked me to delete there account. I did that but they still receive the emails.
What can be the problem?

Artes_Marciales 08-18-2008 06:10 AM

+1 same cuestion here.

C Braithwaite 08-18-2008 06:23 AM

I hope we are now 100% bug free!

In regards to deleted members:

If a member has been fully deleted from the databasr then it is impossible for the plugin to contact them unless there is already a mail in the mail queue waiting to go.

if however you are just moving the user to a different usergroup then you need to make sure that the usergroup is not in the list to be monitored.

hope this helps.

dfc005 08-18-2008 06:26 AM

I'm checking out the Report for Inactive Users and it doesn't seem to be showing unique users at all. A bunch of userid/usernames are repeated lots of times. Is that a bug?


All times are GMT. The time now is 09:28 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.03513 seconds
  • Memory Usage 1,859KB
  • 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
  • (32)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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