In reply to Automatic Confirmation Emails
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
The new Dolphin solution is powered by UNA Community Management System.
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