License: IMPORTANT: This is a commercial product made by AQB Soft. It cannot be modified for see more other than personal usage. The "personal usage" means the product can be installed and set up for ONE domain name ONLY. To be able to use this product for another domain names you have to order another copy of this product (license). This product cannot be redistributed for free or a fee without written permission from AQB Soft.
This is WONDERFUL!!! Thank you so much. It worked really well. Also, thank you for pasting details instructions on how to execute a query. It was very thoughtful to add for someone for those who don't know how. I've never seen anyone add those instructions with mods and queries I've executed in the past.
Before I was a member of BoonEx, my concern was to contact with the best agent, and in fact I think I found ...
From my beginnings Anton always helped me in everything I needed, I know he has a lot of work, yet he always gave me excellence in their work and personal attention.
I owe a lot to Anton, the best mods of Boonex are from Anton, actually i bought them all.
Well, all their products and services deserve more than five stars from a profesional who deserves more than it delivers.
If you see more are looking for professionals to realize their Projects, ROI, Honesty and Excellence, the answer of the equation is AntonLV.
You are still here anton? Fantastic.... You did some work with me on a mod back in 2007....(Had to go back to the Military), but I am back... in full force... and I may need to hire your help again.... Getting re-aquainted with Dolphin again....... I have some concepts and features I would like designed.... So hit me up here... (Email me)... for some details.... Thanks.... David P.S. this project is going to be huge... NOthing like it... and well... write back!!!
His works are genious. His support is best. You won't have to worry. Highly helpful personality. One of the best developers I have ever met on Unity. Many-many thanks for your kind help. I wish a happy and prosperous new year to you.
this has caused our site to be suspended due to sending out spam. so how can i remove the SQL command from the database and this mod from my installation
Just as advertised this modules sends every N days activation emails to all unconfirmed profiles on your site. If on your site there are hundreds or thousands of unconfirmed profiles and you configured the module to notify them every day then of course this would result in hundreds/thousands emails every night. So in that case it is necessary either to:
a) Delete old unconfirmed profiles
or
b) Set N parameter to a bigger value so it would notify unconfirmed members by portions every day.
Anyway see more to uninstall the module do the following:
1. Execute the following DB query to remove all records from DB:
DELETE FROM `sys_options` WHERE `Name` = 'confirmation_email_period' LIMIT 1;
DELETE FROM `sys_cron_jobs` WHERE `name` = 'auto_conf_emails' LIMIT 1;
2. Clean site's DB cache by clicking the "Clean db" link on the admin's dashboard page.
AntonLV, I just want to say this is a nice mod and will be very useful, thank you. The one problem is that i can’t get it to run. I installed the MYsql statement with no problems, cleared the db cache as directed, and went in to the Admin panel reset the number of days to 2 and saved it. I added a new record and waited, but it has now been 10 days and I have not received a conformation email. There are no messages in the queue. Is there something I am missing?
I am running the latest version see more of Dolphin 7.0.9
Tried the mod with 7.1 and got the following error when I did the SQL Query:
#1064 - 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 'INSERT INTO `sys_cron_jobs` (`id` ,`name` ,`time` ,`class` ,`file` ,`eval`) VAL' at line 3
Would love to get t his to work. It is a great idea and it could just be something at my end. Bit, I don;t know what it could be.
I have followed all your instructions but still my confirmation cannot be sent which is I don't know while, it was working before but after they upgrade to new versions for me never worked again. Any help, please.
Great ! Thank you very much ;-)
Racquel
Claudia
From my beginnings Anton always helped me in everything I needed, I know he has a lot of work, yet he always gave me excellence in their work and personal attention.
I owe a lot to Anton, the best mods of Boonex are from Anton, actually i bought them all.
Well, all their products and services deserve more than five stars from a profesional who deserves more than it delivers.
If you see more
Feel free to contact me.
Happy New Year to you and your family!!!
i am not a tech so can't take a chance..
a) Delete old unconfirmed profiles
or
b) Set N parameter to a bigger value so it would notify unconfirmed members by portions every day.
Anyway see more
I am running the latest version see more
Tried the mod with 7.1 and got the following error when I did the SQL Query:
#1064 - 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 'INSERT INTO `sys_cron_jobs` (`id` ,`name` ,`time` ,`class` ,`file` ,`eval`) VAL' at line 3
Would love to get t his to work. It is a great idea and it could just be something at my end. Bit, I don;t know what it could be.
Try to run this part of the query only (since the first part most likely worked fine):
INSERT INTO `sys_cron_jobs` (`id` ,`name` ,`time` ,`class` ,`file` ,`eval`)
VALUES (NULL , 'auto_conf_emails', '0 1 * * *', '', '', '$iPeriod = $GLOBALS[''MySQL'']->getParam(''confirmation_email_period''); $aProfilesToConfirm = $GLOBALS[''MySQL'']->getAll("SELECT `ID` FROM `Profiles` WHERE `Status` = ''Unconfirmed'' AND (`Couple`=0 OR `Couple` > `ID`) AND (TO_DAYS(NOW()) see more
Thanks