|
@@ 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__); |