|
@@ 2447-2457 (lines=11) @@
|
| 2444 |
|
|
| 2445 |
|
if (!empty($dataList)) { |
| 2446 |
|
foreach ($dataList as $data) { |
| 2447 |
|
if (isset($oldGroups[$data['group_id']])) { |
| 2448 |
|
// Deleting relation |
| 2449 |
|
$sql = "DELETE FROM announcement_rel_group WHERE group_id = {$data['group_id']}"; |
| 2450 |
|
$connection->executeQuery($sql); |
| 2451 |
|
|
| 2452 |
|
// Add new relation |
| 2453 |
|
$data['group_id'] = $oldGroups[$data['group_id']]; |
| 2454 |
|
$sql = "INSERT INTO announcement_rel_group(group_id, announcement_id) |
| 2455 |
|
VALUES ('{$data['group_id']}', '{$data['announcement_id']}')"; |
| 2456 |
|
$connection->executeQuery($sql); |
| 2457 |
|
} |
| 2458 |
|
} |
| 2459 |
|
} |
| 2460 |
|
|
|
@@ 2464-2473 (lines=10) @@
|
| 2461 |
|
$sql = "SELECT * FROM group_rel_tag"; |
| 2462 |
|
$result = $connection->executeQuery($sql); |
| 2463 |
|
$dataList = $result->fetchAll(); |
| 2464 |
|
if (!empty($dataList)) { |
| 2465 |
|
foreach ($dataList as $data) { |
| 2466 |
|
if (isset($oldGroups[$data['group_id']])) { |
| 2467 |
|
$data['group_id'] = $oldGroups[$data['group_id']]; |
| 2468 |
|
$sql = "INSERT INTO usergroup_rel_tag (tag_id, usergroup_id) |
| 2469 |
|
VALUES ('{$data['tag_id']}', '{$data['group_id']}')"; |
| 2470 |
|
$connection->executeQuery($sql); |
| 2471 |
|
} |
| 2472 |
|
} |
| 2473 |
|
} |
| 2474 |
|
} |
| 2475 |
|
|
| 2476 |
|
if ($debug) { |