public function updateFolders($scannerId, $folders) { include_once 'modules/Settings/MailConverter/handlers/MailScannerInfo.php'; $db = PearDatabase::getInstance(); $scannerName = Settings_MailConverter_Module_Model::getScannerName($scannerId); $scannerInfo = new Vtiger_MailScannerInfo($scannerName); $lastScan = $scannerInfo->dateBasedOnMailServerTimezone('d-M-Y'); $db->pquery("DELETE FROM vtiger_mailscanner_folders WHERE scannerid=?", array($scannerId)); foreach ($folders as $folder) { $db->pquery("INSERT INTO vtiger_mailscanner_folders VALUES(?,?,?,?,?,?)", array('', $scannerId, $folder, $lastScan, '0', '1')); } }