cantico / absences

	// correction des demandes n'ayant pas de date de creation

	$res = $babDB->db_query("SELECT `id`, `date` FROM absences_entries WHERE createdOn='0000-00-00 00:00:00'");

	while ($arr = $babDB->db_fetch_assoc($res))

	{

		$babDB->db_query("UPDATE absences_entries SET createdOn=".$babDB->quote($arr['date'])." WHERE id=".$babDB->quote($arr['id']));

	}

	$typescount = 0;

	$res = $babDB->db_query('SELECT COUNT(*) FROM '.$babDB->backTick('absences_types'));

	require_once $GLOBALS['babInstallPath'].'utilit/uuid.php';

	$res = $babDB->db_query("SELECT id FROM absences_rights WHERE uuid=''");

	while ($arr = $babDB->db_fetch_assoc($res))

	{

		$babDB->db_query('UPDATE absences_rights SET uuid='.$babDB->quote(bab_uuid()).' WHERE id='.$babDB->quote($arr['id']));

	}

	$res = $babDB->db_query("SELECT id FROM absences_rights_inperiod WHERE uuid=''");

	while ($arr = $babDB->db_fetch_assoc($res))

	}

	$res = $babDB->db_query("SELECT id FROM absences_rights_inperiod WHERE uuid=''");

	while ($arr = $babDB->db_fetch_assoc($res))

	{

		$babDB->db_query('UPDATE absences_rights_inperiod SET uuid='.$babDB->quote(bab_uuid()).' WHERE id='.$babDB->quote($arr['id']));

	}

	// reprise des gestionnaires en tant que groupe avec ACL, faire la reprise si la table absences_options contient des lignes

		// recopier les liens droit-regime

		$res = $babDB->db_query('SELECT * FROM absences_coll_rights WHERE id_right='.$babDB->quote($old_id_right));

		while ($arr = $babDB->db_fetch_assoc($res))

		{

			$babDB->db_query('INSERT INTO absences_coll_rights (id_coll, id_right) VALUES ('.$babDB->quote($arr['id_coll']).', '.$babDB->quote($new_id_right).')');

		}