Hello,

 

sometimes I’m doing manuel:

 

$SQL = "SELECT * FROM `contacts` WHERE `del` = 1 AND DATE_ADD(`changed`,INTERVAL 45 DAY) < NOW() ";

$res = mysql_query($SQL) or die (__LINE__ .": ".$SQL);

 

while($row = mysql_fetch_array($res))

{

$SQL = "DELETE FROM `contactgroupmembers` WHERE `contact_id` = ".$row['contact_id'];

$rex = mysql_query($SQL) or die (__LINE__ .": ".$SQL);

 

$SQL = "DELETE FROM `contacts` WHERE `contact_id` = ".$row['contact_id'];

$rex = mysql_query($SQL) or die (__LINE__ .": ".$SQL);

 

echo "Delete ".$row['contact_id']."<br>";

flush();

}

mysql_free_result($res);

 

Best regards from germany

 

Ulli

 

From: users-bounces@lists.roundcube.net [mailto:users-bounces@lists.roundcube.net] On Behalf Of Jorge Bastos
Sent: Thursday, December 07, 2017 11:43 AM
To: 'Roundcube Users mailing list' <users@lists.roundcube.net>
Subject: [RCU] Cron files

 

Hi,

 

Which cron job’s should be added for a good maintenance of RC?

 

gc.sh

 

and what else?

 

Thanks,