<?php
if(IN_MANAGER_MODE!="true") die("<b>INCLUDE_ORDERING_ERROR</b><br /><br />Please use the MODx Content Manager instead of accessing this file directly.");

/**
 *	Secure Web Documents
 *	This script will mark web documents as private
 *
 *	A document will be marked as private only if a web user group 
 *	is assigned to the document group that the document belongs to.
 *
 */

function secureWebDocument($docid='') {
	global $modx;
		
	$modx->db->query("UPDATE ".$modx->getFullTableName("site_content")." SET privateweb = 0 WHERE ".($docid>0 ? "id='$docid'":"privateweb = 1"));
	$sql =  "SELECT DISTINCT sc.id 
			 FROM ".$modx->getFullTableName("site_content")." sc
			 LEFT JOIN ".$modx->getFullTableName("document_groups")." dg ON dg.document = sc.id
			 LEFT JOIN ".$modx->getFullTableName("webgroup_access")." wga ON wga.documentgroup = dg.document_group
			 WHERE ".($docid>0 ? " sc.id='$docid' AND ":"")."wga.id>0";
	$ids = $modx->db->getColumn("id",$sql);
	if(count($ids)>0) {
		$modx->db->query("UPDATE ".$modx->getFullTableName("site_content")." SET privateweb = 1 WHERE id IN (".implode(", ",$ids).")");	
	}
}
?>