function gen_user_sub_list(&$tpl, &$sql, $user_id)
{
$domain_id = get_user_domain_id($sql, $user_id);
$query = <<<SQL_QUERY
select
subdomain_id, subdomain_name, subdomain_mount, subdomain_status
from
subdomain
where
domain_id = ?
order by
subdomain_name
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_id));
if ($rs->RecordCount() == 0) {
$tpl->assign(array('SUB_MSG' => tr('Subdomain list is empty!'), 'SUB_LIST' => ''));
$tpl->parse('SUB_MESSAGE', 'sub_message');
} else {
$counter = 0;
while (!$rs->EOF) {
if ($counter % 2 == 0) {
$tpl->assign('ITEM_CLASS', 'content');
} else {
$tpl->assign('ITEM_CLASS', 'content2');
}
list($sub_action, $sub_action_script) = gen_user_sub_action($rs->fields['subdomain_id'], $rs->fields['subdomain_status']);
$sbd_name = decode_idna($rs->fields['subdomain_name']);
$tpl->assign(array('SUB_NAME' => $sbd_name, 'SUB_MOUNT' => $rs->fields['subdomain_mount'], 'SUB_STATUS' => translate_dmn_status($rs->fields['subdomain_status']), 'SUB_ACTION' => $sub_action, 'SUB_ACTION_SCRIPT' => $sub_action_script));
$tpl->parse('SUB_ITEM', '.sub_item');
$rs->MoveNext();
$counter++;
}
$tpl->parse('SUB_LIST', 'sub_list');
$tpl->assign('SUB_MESSAGE', '');
}
}
/**
* @param EasySCP_TemplateEngine $tpl
* @param int $user_id
*/
function gen_user_sub_list($tpl, $user_id)
{
$sql = EasySCP_Registry::get('Db');
$domain_id = get_user_domain_id($user_id);
$query = "\n\t\tSELECT\n\t\t\ts.subdomain_id,\n\t\t\ts.subdomain_name,\n\t\t\ts.subdomain_mount,\n\t\t\ts.status,\n\t\t\ts.subdomain_url_forward,\n\t\t\td.domain_name\n\t\tFROM\n\t\t\tsubdomain s,\n\t\t\tdomain d\n\t\tWHERE\n\t\t\ts.domain_id = d.domain_id\n\t\tAND\n\t\t\ts.domain_id = ?\n\t\tORDER BY\n\t\t\ts.subdomain_name;\n\t";
$query2 = "\n\t\tSELECT\n\t\t\ts.subdomain_alias_id,\n\t\t\ts.subdomain_alias_name,\n\t\t\ts.subdomain_alias_mount,\n\t\t\ts.subdomain_alias_url_forward,\n\t\t\ts.status,\n\t\t\ta.alias_name\n\t\tFROM\n\t\t\tsubdomain_alias s,\n\t\t\tdomain_aliasses a\n\t\tWHERE\n\t\t\ts.alias_id = a.alias_id\n\t\tAND\n\t\t\ta.domain_id = ?\n\t\tORDER BY\n\t\t\ts.subdomain_alias_name\n\t;";
$rs = exec_query($sql, $query, $domain_id);
$rs2 = exec_query($sql, $query2, $domain_id);
if ($rs->recordCount() + $rs2->recordCount() == 0) {
$tpl->assign(array('SUB_MSG' => tr('Subdomain list is empty!'), 'SUB_MSG_TYPE' => 'info', 'SUB_LIST' => ''));
} else {
while (!$rs->EOF) {
list($sub_action, $sub_action_script) = gen_user_sub_action($rs->fields['subdomain_id'], $rs->fields['status']);
list($sub_forward, $sub_edit_link, $sub_edit) = gen_user_sub_forward($rs->fields['subdomain_id'], $rs->fields['status'], $rs->fields['subdomain_url_forward'], 'dmn');
$sbd_name = decode_idna($rs->fields['subdomain_name']);
$dmn_name = decode_idna($rs->fields['domain_name']);
$sub_forward = decode_idna($sub_forward);
$tpl->append(array('SUB_NAME' => tohtml($sbd_name), 'SUB_ALIAS_NAME' => tohtml($dmn_name), 'SUB_MOUNT' => tohtml($rs->fields['subdomain_mount']), 'SUB_FORWARD' => $sub_forward, 'SUB_STATUS' => translate_dmn_status($rs->fields['status']), 'SUB_EDIT_LINK' => $sub_edit_link, 'SUB_EDIT' => $sub_edit, 'SUB_ACTION' => $sub_action, 'SUB_ACTION_SCRIPT' => $sub_action_script));
$rs->moveNext();
}
while (!$rs2->EOF) {
list($sub_action, $sub_action_script) = gen_user_alssub_action($rs2->fields['subdomain_alias_id'], $rs2->fields['status']);
list($sub_forward, $sub_edit_link, $sub_edit) = gen_user_sub_forward($rs2->fields['subdomain_alias_id'], $rs2->fields['status'], $rs2->fields['subdomain_alias_url_forward'], 'als');
$sbd_name = decode_idna($rs2->fields['subdomain_alias_name']);
$sub_forward = decode_idna($sub_forward);
$tpl->append(array('SUB_NAME' => tohtml($sbd_name), 'SUB_ALIAS_NAME' => tohtml($rs2->fields['alias_name']), 'SUB_MOUNT' => tohtml($rs2->fields['subdomain_alias_mount']), 'SUB_FORWARD' => $sub_forward, 'SUB_STATUS' => translate_dmn_status($rs2->fields['status']), 'SUB_EDIT_LINK' => $sub_edit_link, 'SUB_EDIT' => $sub_edit, 'SUB_ACTION' => $sub_action, 'SUB_ACTION_SCRIPT' => $sub_action_script));
$rs2->moveNext();
}
$tpl->assign('SUB_MESSAGE', '');
}
}
