evolution-cms /
evolution
| @@ 431-443 (lines=13) @@ | ||
| 428 | LEFT JOIN `" . $sqlParser->prefix . "webgroup_access` wga ON wga.documentgroup = dg.document_group |
|
| 429 | WHERE wga.id>0"; |
|
| 430 | $ds = mysqli_query($sqlParser->conn, $sql); |
|
| 431 | if (!$ds) { |
|
| 432 | echo "An error occurred while executing a query: " . mysqli_error($sqlParser->conn); |
|
| 433 | } else { |
|
| 434 | while ($r = mysqli_fetch_assoc($ds)) { |
|
| 435 | $ids[] = $r["id"]; |
|
| 436 | } |
|
| 437 | if (count($ids) > 0) { |
|
| 438 | mysqli_query($sqlParser->conn, |
|
| 439 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privateweb = 1 WHERE id IN (" . implode(", ", |
|
| 440 | $ids) . ")"); |
|
| 441 | unset($ids); |
|
| 442 | } |
|
| 443 | } |
|
| 444 | ||
| 445 | // secure manager documents privatemgr |
|
| 446 | mysqli_query($sqlParser->conn, |
|
| @@ 454-466 (lines=13) @@ | ||
| 451 | LEFT JOIN `" . $sqlParser->prefix . "membergroup_access` mga ON mga.documentgroup = dg.document_group |
|
| 452 | WHERE mga.id>0"; |
|
| 453 | $ds = mysqli_query($sqlParser->conn, $sql); |
|
| 454 | if (!$ds) { |
|
| 455 | echo "An error occurred while executing a query: " . mysqli_error($sqlParser->conn); |
|
| 456 | } else { |
|
| 457 | while ($r = mysqli_fetch_assoc($ds)) { |
|
| 458 | $ids[] = $r["id"]; |
|
| 459 | } |
|
| 460 | if (count($ids) > 0) { |
|
| 461 | mysqli_query($sqlParser->conn, |
|
| 462 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privatemgr = 1 WHERE id IN (" . implode(", ", |
|
| 463 | $ids) . ")"); |
|
| 464 | unset($ids); |
|
| 465 | } |
|
| 466 | } |
|
| 467 | } |
|
| 468 | } |
|
| 469 | ||
