EGroupware / egroupware

{

	// Set UID of series exception to UID of series master

	// update cal_etag, cal_modified and cal_modifier to distribute changes on GroupDAV devices

	foreach($GLOBALS['egw_setup']->db->query('

		SELECT cal_ex.cal_id,cal_ex.cal_uid AS cal_uid_ex,cal_master.cal_uid AS cal_uid_master

		FROM egw_cal cal_ex

		JOIN egw_cal cal_master ON cal_ex.cal_reference=cal_master.cal_id

		WHERE cal_ex.cal_reference != 0',__LINE__,__FILE__) as $row)

	{

		if (strlen($row['cal_uid_master']) > 0 && $row['cal_uid_ex'] != $row['cal_uid_master'])

		{

			$GLOBALS['egw_setup']->db->query('UPDATE egw_cal SET cal_uid=\''.$row['cal_uid_master'].

				'\',cal_etag=cal_etag+1,cal_modified='.time().

				',cal_modifier=NULL WHERE cal_id='.(int)$row['cal_id'],__LINE__,__FILE__);

		}

	}

	// Search series exception for nearest exception in series master and add that RECURRENCE-ID

	// as cal_reference (for 1.6.003 and move it to new field cal_recurrence in 1.7.001)

{

	// Set UID of series exception to UID of series master

	// update cal_etag,cal_modified and cal_modifier to distribute changes on GroupDAV devices

	foreach($GLOBALS['egw_setup']->db->query('

		SELECT cal_ex.cal_id,cal_ex.cal_uid AS cal_uid_ex,cal_master.cal_uid AS cal_uid_master

		FROM egw_cal cal_ex

		JOIN egw_cal cal_master ON cal_ex.cal_reference=cal_master.cal_id

		WHERE cal_ex.cal_reference != 0',__LINE__,__FILE__) as $row)

	{

		if (strlen($row['cal_uid_master']) > 0 && $row['cal_uid_ex'] != $row['cal_uid_master'])

		{

			$GLOBALS['egw_setup']->db->query('UPDATE egw_cal SET cal_uid=\''.$row['cal_uid_master'].

				'\',cal_etag=cal_etag+1,cal_modified='.time().

				',cal_modifier=NULL WHERE cal_id='.(int)$row['cal_id'],__LINE__,__FILE__);

		}

	}

	return $GLOBALS['setup_info']['calendar']['currentver'] = '1.7.008';

}