evolution-cms /
evolution
| @@ 244-284 (lines=41) @@ | ||
| 241 | // setup callback function |
|
| 242 | $callBackFnc = "clean_up"; |
|
| 243 | ||
| 244 | function clean_up($sqlParser) { |
|
| 245 | $ids = array(); |
|
| 246 | ||
| 247 | // secure web documents - privateweb |
|
| 248 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privateweb = 0 WHERE privateweb = 1"); |
|
| 249 | $sql = "SELECT DISTINCT sc.id |
|
| 250 | FROM `".$sqlParser->prefix."site_content` sc |
|
| 251 | LEFT JOIN `".$sqlParser->prefix."document_groups` dg ON dg.document = sc.id |
|
| 252 | LEFT JOIN `".$sqlParser->prefix."webgroup_access` wga ON wga.documentgroup = dg.document_group |
|
| 253 | WHERE wga.id>0"; |
|
| 254 | $ds = mysqli_query($sqlParser->conn,$sql); |
|
| 255 | if(!$ds) { |
|
| 256 | echo "An error occurred while executing a query: ".mysqli_error($sqlParser->conn); |
|
| 257 | } |
|
| 258 | else { |
|
| 259 | while($r = mysqli_fetch_assoc($ds)) $ids[]=$r["id"]; |
|
| 260 | if(count($ids)>0) { |
|
| 261 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privateweb = 1 WHERE id IN (".implode(", ",$ids).")"); |
|
| 262 | unset($ids); |
|
| 263 | } |
|
| 264 | } |
|
| 265 | ||
| 266 | // secure manager documents privatemgr |
|
| 267 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privatemgr = 0 WHERE privatemgr = 1"); |
|
| 268 | $sql = "SELECT DISTINCT sc.id |
|
| 269 | FROM `".$sqlParser->prefix."site_content` sc |
|
| 270 | LEFT JOIN `".$sqlParser->prefix."document_groups` dg ON dg.document = sc.id |
|
| 271 | LEFT JOIN `".$sqlParser->prefix."membergroup_access` mga ON mga.documentgroup = dg.document_group |
|
| 272 | WHERE mga.id>0"; |
|
| 273 | $ds = mysqli_query($sqlParser->conn,$sql); |
|
| 274 | if(!$ds) { |
|
| 275 | echo "An error occurred while executing a query: ".mysqli_error($sqlParser->conn); |
|
| 276 | } |
|
| 277 | else { |
|
| 278 | while($r = mysqli_fetch_assoc($ds)) $ids[]=$r["id"]; |
|
| 279 | if(count($ids)>0) { |
|
| 280 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privatemgr = 1 WHERE id IN (".implode(", ",$ids).")"); |
|
| 281 | unset($ids); |
|
| 282 | } |
|
| 283 | } |
|
| 284 | } |
|
| 285 | ||
| 286 | function parse_docblock($element_dir, $filename) { |
|
| 287 | $params = array(); |
|
| @@ 797-837 (lines=41) @@ | ||
| 794 | // setup callback function |
|
| 795 | $callBackFnc = "clean_up"; |
|
| 796 | ||
| 797 | function clean_up($sqlParser) { |
|
| 798 | $ids = array(); |
|
| 799 | ||
| 800 | // secure web documents - privateweb |
|
| 801 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privateweb = 0 WHERE privateweb = 1"); |
|
| 802 | $sql = "SELECT DISTINCT sc.id |
|
| 803 | FROM `".$sqlParser->prefix."site_content` sc |
|
| 804 | LEFT JOIN `".$sqlParser->prefix."document_groups` dg ON dg.document = sc.id |
|
| 805 | LEFT JOIN `".$sqlParser->prefix."webgroup_access` wga ON wga.documentgroup = dg.document_group |
|
| 806 | WHERE wga.id>0"; |
|
| 807 | $ds = mysqli_query($sqlParser->conn,$sql); |
|
| 808 | if(!$ds) { |
|
| 809 | echo "An error occurred while executing a query: ".mysqli_error($sqlParser->conn); |
|
| 810 | } |
|
| 811 | else { |
|
| 812 | while($r = mysqli_fetch_assoc($ds)) $ids[]=$r["id"]; |
|
| 813 | if(count($ids)>0) { |
|
| 814 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privateweb = 1 WHERE id IN (".implode(", ",$ids).")"); |
|
| 815 | unset($ids); |
|
| 816 | } |
|
| 817 | } |
|
| 818 | ||
| 819 | // secure manager documents privatemgr |
|
| 820 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privatemgr = 0 WHERE privatemgr = 1"); |
|
| 821 | $sql = "SELECT DISTINCT sc.id |
|
| 822 | FROM `".$sqlParser->prefix."site_content` sc |
|
| 823 | LEFT JOIN `".$sqlParser->prefix."document_groups` dg ON dg.document = sc.id |
|
| 824 | LEFT JOIN `".$sqlParser->prefix."membergroup_access` mga ON mga.documentgroup = dg.document_group |
|
| 825 | WHERE mga.id>0"; |
|
| 826 | $ds = mysqli_query($sqlParser->conn,$sql); |
|
| 827 | if(!$ds) { |
|
| 828 | echo "An error occurred while executing a query: ".mysqli_error($sqlParser->conn); |
|
| 829 | } |
|
| 830 | else { |
|
| 831 | while($r = mysqli_fetch_assoc($ds)) $ids[]=$r["id"]; |
|
| 832 | if(count($ids)>0) { |
|
| 833 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privatemgr = 1 WHERE id IN (".implode(", ",$ids).")"); |
|
| 834 | unset($ids); |
|
| 835 | } |
|
| 836 | } |
|
| 837 | } |
|
| 838 | ||
| 839 | function parse_docblock($element_dir, $filename) { |
|
| 840 | $params = array(); |
|
