eform db backup (store a copy of each email sent via eForm in MySQL table)

##################################
## CUSTOM - RECORD MAIL IN DATABSE
##################################
	$backupTableFull = $modx->getFullTableName('eform_backup');
	$backupTable = explode('.', $backupTableFull);
	
	##################################################
	## CHECK IF CUSTOM TABLE EXISTS. IF NOT, CREATE IT
	##################################################
		$tableNames = $modx->db->query("SHOW TABLES");
		while($eachTable = $modx->db->getRow($tableNames, 'num')){
			$allTables[] = $eachTable[0];
		}
		if(!in_array($backupTable, $allTables)){
			$createTable = $modx->db->query("CREATE TABLE IF NOT EXISTS ".$backupTableFull." (`id` int(11) unsigned NOT NULL auto_increment,`timestamp` datetime NOT NULL,`to` text NOT NULL,`from` text NOT NULL,`fromname` text NOT NULL,`replyto` text NOT NULL,`cc` text NOT NULL,`bcc` text NOT NULL,`subject` text NOT NULL,`body` text NOT NULL,PRIMARY KEY  (`id`))");
			if(!$createTable){
				return $this->FormatMessage($modx->db->getLastError);
			}
		}			
		
	##################
	## INSERT THE DATA
	##################
		$backupSQL = "INSERT INTO ".$backupTableFull." (`timestamp`,`to`,`from`,`fromname`,`replyto`,`cc`,`bcc`,`subject`,`body`) VALUES (NOW(),'".$modx->db->escape($to)."','".$modx->db->escape($from)."','".$modx->db->escape($fromname)."','".$modx->db->escape($replyto)."','".$modx->db->escape($cc)."','".$modx->db->escape($bcc)."','".$modx->db->escape($subject)."','".$modx->db->escape($report)."')";
		$modx->db->query($backupSQL);
####################################
## / CUSTOM - RECORD MAIL IN DATABSE
####################################