<?php
	$sql = Array(
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.ADD', 11, 1, 0, {ProductCatId})",
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.DELETE', 11, 1, 0, {ProductCatId})",
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.MODIFY', 11, 1, 0, {ProductCatId})",
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.VIEW', 11, 1, 0, {ProductCatId})",
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.VIEW', {User_GuestGroup}, 1, 0, {ProductCatId})",
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.VIEW', {User_NewGroup}, 1, 0, {ProductCatId})",
					"INSERT INTO Permissions (Permission, GroupId, PermissionValue, Type, CatId) VALUES ('PRODUCT.VIEW', {User_SubscriberGroup}, 1, 0, {ProductCatId})",
			);
			
	
	// prepare replacements array
	$application =& kApplication::Instance();
	$db =& $application->GetADODBConnection();
	
	$replacements	=	Array(
								'{ProductCatId}'			=>	$application->findModule('Name', 'In-Commerce', 'RootCat'),
								'{User_GuestGroup}'			=>	$application->ConfigValue('User_GuestGroup'),
								'{User_NewGroup}'			=>	$application->ConfigValue('User_NewGroup'),
								'{User_SubscriberGroup}'	=>	$application->ConfigValue('User_SubscriberGroup'),
						);
	
	$i = 0; $count = count($sql);
	while ($i < $count) {
		foreach ($replacements as $replace_from => $replace_to) {
			$sql[$i] = str_replace($replace_from, $replace_to, $sql[$i]);
		}
		$i++;
	}
	
	RunSQLText($application->Conn, $sql, 'dbconnection');		
			
?>