<?
require_once ('../settings.php');
require_once '../lib/userValidator.class.php';
require_once '../lib/SmartyRendererStandAlone.class.php';
$authClass=new userValidator(0);
    
$authClass->validateRequest();

$DB =& $authClass->getDB();
$UserInfo = $DB->getRow("select * from #__OSS_users where username=".$DB->quote($_SESSION["omniSecure"]["username"])." and password=".$DB->quote($_SESSION["omniSecure"]["password"]),DB_FETCHMODE_ASSOC);
$UserGroup = join(",",unserialize($UserInfo["_group"]));
$res = $DB->query("select g._group,pf.url,cfc.FileName from #__OSS_custom_forms_config cfc,#__OSS_groups g,#__OSS_prfolders pf where cfc.UserGroup in(".$UserGroup.") and g.id=cfc.UserGroup and pf.id=cfc.FolderID order by _group");

/*
$template = $DB->getOne("select value from #__OSS_email_messages where code='multiple_groups_select'");
$preg = "/<!-- row_begin -->(.*)<!-- row_end -->/is";

preg_match($preg,$template,$matches);
$row_template = $matches[1];
$result = "";
while ($rec = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
	$result .= strtr($row_template,array("!folder_url!"=>$rec["url"].$rec["FileName"],
																				"!group_name!"=>$rec["_group"]));
}
echo preg_replace($preg,$result,$template);
*/
$smarty = new SmartyRendererStandAlone(SMARTY_DEF_TEMPLATE_DIR);

$result = array();
while ($rec = $res->fetchRow(DB_FETCHMODE_ASSOC)) 
{
	$result[] = array("url" => $rec["url"].$rec["FileName"], "_group" => $rec["_group"]);
}
$smarty -> setAttribute("groups",$result);
$smarty -> setTemplate("multiple_groups_select.html");
$smarty -> execute();
?>