Code Duplication    Length = 6-6 lines in 2 locations

calendar/setup/tables_update.inc.php 2 locations

@@ 1898-1903 (lines=6) @@
1895
 */
1896
function calendar_upgrade1_7_006()
1897
{
1898
	foreach($GLOBALS['egw_setup']->db->query('SELECT * FROM egw_cal_dates
1899
		WHERE (cal_end-cal_start)%86400=86340',__LINE__,__FILE__) as $row)
1900
	{
1901
		$GLOBALS['egw_setup']->db->query('UPDATE egw_cal_dates SET cal_end=cal_end+59
1902
			WHERE cal_id='.(int)$row['cal_id'].' AND cal_start='.(int)$row['cal_start'],__LINE__,__FILE__);
1903
	}
1904
1905
	foreach($GLOBALS['egw_setup']->db->query('SELECT * FROM egw_cal_dates
1906
		WHERE cal_end-cal_start>0 AND (cal_end-cal_start)%86400=0',__LINE__,__FILE__) as $row)
@@ 1905-1910 (lines=6) @@
1902
			WHERE cal_id='.(int)$row['cal_id'].' AND cal_start='.(int)$row['cal_start'],__LINE__,__FILE__);
1903
	}
1904
1905
	foreach($GLOBALS['egw_setup']->db->query('SELECT * FROM egw_cal_dates
1906
		WHERE cal_end-cal_start>0 AND (cal_end-cal_start)%86400=0',__LINE__,__FILE__) as $row)
1907
	{
1908
		$GLOBALS['egw_setup']->db->query('UPDATE egw_cal_dates SET cal_end=cal_end-1
1909
			WHERE cal_id='.(int)$row['cal_id'].' AND cal_start='.(int)$row['cal_start'],__LINE__,__FILE__);
1910
	}
1911
1912
    $GLOBALS['egw_setup']->db->query('UPDATE egw_cal_repeats SET recur_interval=1
1913
			WHERE recur_interval=0',__LINE__,__FILE__);