clean_events.php

groupoffice

<?php
/*
This script will update the databse fopr version 2.03
*/
require('../../Group-Office.php');
$db = new db();
$db->Halt_On_Error = 'no';

require_once($GO_MODULES->modules['calendar']['class_path'].'calendar.class.inc');
$cal = new calendar();

$sql = "SELECT cal_events.id
FROM cal_events
LEFT JOIN acl_items ON ( cal_events.acl_read = acl_items.id
OR cal_events.acl_write = acl_items.id )
WHERE acl_items.id IS NULL";

$db->query($sql);
while($db->next_record())
{
	$cal->delete_event($db->f('id'));
}
?>