evolution-cms /
evolution
| @@ 781-821 (lines=41) @@ | ||
| 778 | // setup callback function |
|
| 779 | $callBackFnc = "clean_up"; |
|
| 780 | ||
| 781 | function clean_up($sqlParser) { |
|
| 782 | $ids = array(); |
|
| 783 | ||
| 784 | // secure web documents - privateweb |
|
| 785 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privateweb = 0 WHERE privateweb = 1"); |
|
| 786 | $sql = "SELECT DISTINCT sc.id |
|
| 787 | FROM `".$sqlParser->prefix."site_content` sc |
|
| 788 | LEFT JOIN `".$sqlParser->prefix."document_groups` dg ON dg.document = sc.id |
|
| 789 | LEFT JOIN `".$sqlParser->prefix."webgroup_access` wga ON wga.documentgroup = dg.document_group |
|
| 790 | WHERE wga.id>0"; |
|
| 791 | $ds = mysqli_query($sqlParser->conn,$sql); |
|
| 792 | if(!$ds) { |
|
| 793 | echo "An error occurred while executing a query: ".mysqli_error($sqlParser->conn); |
|
| 794 | } |
|
| 795 | else { |
|
| 796 | while($r = mysqli_fetch_assoc($ds)) $ids[]=$r["id"]; |
|
| 797 | if(count($ids)>0) { |
|
| 798 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privateweb = 1 WHERE id IN (".implode(", ",$ids).")"); |
|
| 799 | unset($ids); |
|
| 800 | } |
|
| 801 | } |
|
| 802 | ||
| 803 | // secure manager documents privatemgr |
|
| 804 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privatemgr = 0 WHERE privatemgr = 1"); |
|
| 805 | $sql = "SELECT DISTINCT sc.id |
|
| 806 | FROM `".$sqlParser->prefix."site_content` sc |
|
| 807 | LEFT JOIN `".$sqlParser->prefix."document_groups` dg ON dg.document = sc.id |
|
| 808 | LEFT JOIN `".$sqlParser->prefix."membergroup_access` mga ON mga.documentgroup = dg.document_group |
|
| 809 | WHERE mga.id>0"; |
|
| 810 | $ds = mysqli_query($sqlParser->conn,$sql); |
|
| 811 | if(!$ds) { |
|
| 812 | echo "An error occurred while executing a query: ".mysqli_error($sqlParser->conn); |
|
| 813 | } |
|
| 814 | else { |
|
| 815 | while($r = mysqli_fetch_assoc($ds)) $ids[]=$r["id"]; |
|
| 816 | if(count($ids)>0) { |
|
| 817 | mysqli_query($sqlParser->conn,"UPDATE `".$sqlParser->prefix."site_content` SET privatemgr = 1 WHERE id IN (".implode(", ",$ids).")"); |
|
| 818 | unset($ids); |
|
| 819 | } |
|
| 820 | } |
|
| 821 | } |
|
| 822 | ||
| 823 | function parse_docblock($element_dir, $filename) { |
|
| 824 | $params = array(); |
|
| @@ 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(); |
|
