|
@@ 121-126 (lines=6) @@
|
| 118 |
|
$res = $babDB->db_query("SELECT id, kind, date_begin_fixed FROM absences_rights WHERE kind='0'"); |
| 119 |
|
while ($arr = $babDB->db_fetch_assoc($res)) |
| 120 |
|
{ |
| 121 |
|
if ($arr['date_begin_fixed'] !== '0000-00-00 00:00:00') |
| 122 |
|
{ |
| 123 |
|
$babDB->db_query("UPDATE absences_rights SET kind='2' WHERE id=".$babDB->quote($arr['id'])); |
| 124 |
|
} else { |
| 125 |
|
$babDB->db_query("UPDATE absences_rights SET kind='1' WHERE id=".$babDB->quote($arr['id'])); |
| 126 |
|
} |
| 127 |
|
} |
| 128 |
|
|
| 129 |
|
|
|
@@ 229-232 (lines=4) @@
|
| 226 |
|
AND ur.id IS NULL |
| 227 |
|
'); |
| 228 |
|
|
| 229 |
|
if ($babDB->db_num_rows($res2) == 0) |
| 230 |
|
{ |
| 231 |
|
$babDB->db_query('INSERT INTO absences_coll_rights (id_coll, id_right) VALUES ('.$babDB->quote($link['id_coll']).','.$babDB->quote($link['id']).')'); |
| 232 |
|
} |
| 233 |
|
} |
| 234 |
|
} |
| 235 |
|
|