evolution-cms /
evolution
| @@ 836-887 (lines=52) @@ | ||
| 833 | // setup callback function |
|
| 834 | $callBackFnc = "clean_up"; |
|
| 835 | ||
| 836 | if (!function_exists('clean_up')) { |
|
| 837 | function clean_up($sqlParser) |
|
| 838 | { |
|
| 839 | $ids = array(); |
|
| 840 | ||
| 841 | // secure web documents - privateweb |
|
| 842 | mysqli_query($sqlParser->conn, |
|
| 843 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privateweb = 0 WHERE privateweb = 1"); |
|
| 844 | $sql = "SELECT DISTINCT sc.id |
|
| 845 | FROM `" . $sqlParser->prefix . "site_content` sc |
|
| 846 | LEFT JOIN `" . $sqlParser->prefix . "document_groups` dg ON dg.document = sc.id |
|
| 847 | LEFT JOIN `" . $sqlParser->prefix . "webgroup_access` wga ON wga.documentgroup = dg.document_group |
|
| 848 | WHERE wga.id>0"; |
|
| 849 | $ds = mysqli_query($sqlParser->conn, $sql); |
|
| 850 | if (!$ds) { |
|
| 851 | echo "An error occurred while executing a query: " . mysqli_error($sqlParser->conn); |
|
| 852 | } else { |
|
| 853 | while ($r = mysqli_fetch_assoc($ds)) { |
|
| 854 | $ids[] = $r["id"]; |
|
| 855 | } |
|
| 856 | if (count($ids) > 0) { |
|
| 857 | mysqli_query($sqlParser->conn, |
|
| 858 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privateweb = 1 WHERE id IN (" . implode(", ", |
|
| 859 | $ids) . ")"); |
|
| 860 | unset($ids); |
|
| 861 | } |
|
| 862 | } |
|
| 863 | ||
| 864 | // secure manager documents privatemgr |
|
| 865 | mysqli_query($sqlParser->conn, |
|
| 866 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privatemgr = 0 WHERE privatemgr = 1"); |
|
| 867 | $sql = "SELECT DISTINCT sc.id |
|
| 868 | FROM `" . $sqlParser->prefix . "site_content` sc |
|
| 869 | LEFT JOIN `" . $sqlParser->prefix . "document_groups` dg ON dg.document = sc.id |
|
| 870 | LEFT JOIN `" . $sqlParser->prefix . "membergroup_access` mga ON mga.documentgroup = dg.document_group |
|
| 871 | WHERE mga.id>0"; |
|
| 872 | $ds = mysqli_query($sqlParser->conn, $sql); |
|
| 873 | if (!$ds) { |
|
| 874 | echo "An error occurred while executing a query: " . mysqli_error($sqlParser->conn); |
|
| 875 | } else { |
|
| 876 | while ($r = mysqli_fetch_assoc($ds)) { |
|
| 877 | $ids[] = $r["id"]; |
|
| 878 | } |
|
| 879 | if (count($ids) > 0) { |
|
| 880 | mysqli_query($sqlParser->conn, |
|
| 881 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privatemgr = 1 WHERE id IN (" . implode(", ", |
|
| 882 | $ids) . ")"); |
|
| 883 | unset($ids); |
|
| 884 | } |
|
| 885 | } |
|
| 886 | } |
|
| 887 | } |
|
| 888 | ||
| 889 | if (!function_exists('parse_docblock')) { |
|
| 890 | function parse_docblock($element_dir, $filename) |
|
| @@ 415-466 (lines=52) @@ | ||
| 412 | } |
|
| 413 | } |
|
| 414 | ||
| 415 | if (!function_exists('clean_up')) { |
|
| 416 | function clean_up($sqlParser) |
|
| 417 | { |
|
| 418 | $ids = array(); |
|
| 419 | ||
| 420 | // secure web documents - privateweb |
|
| 421 | mysqli_query($sqlParser->conn, |
|
| 422 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privateweb = 0 WHERE privateweb = 1"); |
|
| 423 | $sql = "SELECT DISTINCT sc.id |
|
| 424 | FROM `" . $sqlParser->prefix . "site_content` sc |
|
| 425 | LEFT JOIN `" . $sqlParser->prefix . "document_groups` dg ON dg.document = sc.id |
|
| 426 | LEFT JOIN `" . $sqlParser->prefix . "webgroup_access` wga ON wga.documentgroup = dg.document_group |
|
| 427 | WHERE wga.id>0"; |
|
| 428 | $ds = mysqli_query($sqlParser->conn, $sql); |
|
| 429 | if (!$ds) { |
|
| 430 | echo "An error occurred while executing a query: " . mysqli_error($sqlParser->conn); |
|
| 431 | } else { |
|
| 432 | while ($r = mysqli_fetch_assoc($ds)) { |
|
| 433 | $ids[] = $r["id"]; |
|
| 434 | } |
|
| 435 | if (count($ids) > 0) { |
|
| 436 | mysqli_query($sqlParser->conn, |
|
| 437 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privateweb = 1 WHERE id IN (" . implode(", ", |
|
| 438 | $ids) . ")"); |
|
| 439 | unset($ids); |
|
| 440 | } |
|
| 441 | } |
|
| 442 | ||
| 443 | // secure manager documents privatemgr |
|
| 444 | mysqli_query($sqlParser->conn, |
|
| 445 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privatemgr = 0 WHERE privatemgr = 1"); |
|
| 446 | $sql = "SELECT DISTINCT sc.id |
|
| 447 | FROM `" . $sqlParser->prefix . "site_content` sc |
|
| 448 | LEFT JOIN `" . $sqlParser->prefix . "document_groups` dg ON dg.document = sc.id |
|
| 449 | LEFT JOIN `" . $sqlParser->prefix . "membergroup_access` mga ON mga.documentgroup = dg.document_group |
|
| 450 | WHERE mga.id>0"; |
|
| 451 | $ds = mysqli_query($sqlParser->conn, $sql); |
|
| 452 | if (!$ds) { |
|
| 453 | echo "An error occurred while executing a query: " . mysqli_error($sqlParser->conn); |
|
| 454 | } else { |
|
| 455 | while ($r = mysqli_fetch_assoc($ds)) { |
|
| 456 | $ids[] = $r["id"]; |
|
| 457 | } |
|
| 458 | if (count($ids) > 0) { |
|
| 459 | mysqli_query($sqlParser->conn, |
|
| 460 | "UPDATE `" . $sqlParser->prefix . "site_content` SET privatemgr = 1 WHERE id IN (" . implode(", ", |
|
| 461 | $ids) . ")"); |
|
| 462 | unset($ids); |
|
| 463 | } |
|
| 464 | } |
|
| 465 | } |
|
| 466 | } |
|
| 467 | ||
| 468 | if (!function_exists('parse_docblock')) { |
|
| 469 | function parse_docblock($element_dir, $filename) |
|
