thumper
Hello,

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.
AntonLV
The error message seems odd.

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 - TO_DAYS(`DateReg`)) % {$iPeriod} = 0"); foreach ($aProfilesToConfirm as $aProfile) activation_mail($aProfile[''ID''], 0);');
 
 
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.
PET:0.075734853744507