<!--#include virtual="/includes/topofpage.asp"-->
<%
' Destination Realm Management

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Application("conn_string")

Dim Page
Page="Realm_Manage"

If Request("Admin_Dest_ID") <> "" Then
	Session("Admin_Dest_ID") = Request("Admin_Dest_ID")
End If
		
If Session("Admin_Dest_ID") = "" Then
	Session("Admin_Dest_ID") = "0"
End If

If Not Request("Realms") = "" Then

	If (UCase(Request.ServerVariables("REQUEST_METHOD")) = "POST" And Request.Form("page") = Page And (Request("cont") = "1" Or Request("cont") = "2")) Then

			For each Realm_ID in Request("Realms")
				
				Conn.Execute("Delete_Dest_Realm_Map @Realm_ID='" & Realm_ID & "'")
		
				For each Dest_ID in Request("Destinations")
					Conn.Execute("Add_Dest_Realm_Map @Realm_ID='" & Realm_ID & "', @Dest_ID='" & Dest_ID & "'")
				Next	

			Next
		
		Response.Redirect(Session("default_page"))

	Else

		
		If Not Session("Admin_Dest_ID") = "" And Not Session("Admin_Dest_ID") = "0" Then

				SQL = "Get_Destination @Dest_ID='" & Session("Admin_Dest_ID") & "', @Realm_ID='" & Session("Admin_Realm") & "'"
				Set Dest = Conn.Execute(SQL)
				If Not Dest.EOF Then
					Target = Dest("Target")
					Dest_ID = Session("Admin_Dest_ID")
					
					For each Realm_ID in Request("Realms")
							Conn.Execute("Delete_Dest_Realm_Map @Realm_ID='" & Realm_ID & "', @Dest_ID = '" & Dest_ID & "'")
							Conn.Execute("Add_Dest_Realm_Map @Realm_ID='" & Realm_ID & "', @Dest_ID='" & Dest_ID & "'")
					Next

				End If
		
				Response.Redirect (Session("default_page"))
		End If
		
	End If
End If

%>
	<html>
<STYLE>
BODY {SCROLLBAR-FACE-COLOR: #5e5ebe; SCROLLBAR-HIGHLIGHT-COLOR: #5e5ebe; SCROLLBAR-SHADOW-COLOR: #5e5ebe; SCROLLBAR-3DLIGHT-COLOR: #5e5ebe; SCROLLBAR-ARROW-COLOR:  #6666CC; SCROLLBAR-TRACK-COLOR: #E3E3E3; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
</STYLE>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.0
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && document.getElementById) x=document.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}

function Sub_Form(cont) {
  form1.cont.value=cont
  form1.submit();
}

//-->
</script>
<link rel="stylesheet" href="../Style-sheets/headline.css" type="text/css">
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--

function Sub_Form (cont)
{

var errMsg='';

//if (document.form1.City.value=='') {errMsg+='Please Specify a City\n';}
//if (document.form1.State.value=='') {errMsg+='Please Specify a State\n';}
//if (document.form1.Country.value=='') {errMsg+='Please Specify a Country\n';}
//if (document.form1.Package_Name.value=='') {errMsg+='Please Specify a Package Name\n';}
//if (document.form1.Package_Type_ID.value=='') {errMsg+='Please Specify a Package Type\n';}
//if (document.form1.Package_Duration_ID.value=='') {errMsg+='Please Specify a Package Duration\n';}
//if (document.form1.Num_Adults.value=='') {errMsg+='Please Specify a Number of Adults\n';}
//if (document.form1.Num_Children.value=='') {errMsg+='Please Specify a Number of Children\n';}
//if (document.form1.Lodging.value=='' && document.form1.Tickets.value=='' && document.form1.Food_Bev.value=='' && document.form1.Transport.value=='') {errMsg+='Please sekect an item to work with.\n';}

if (errMsg) alert(errMsg);
else {
  form1.action = "";
  form1.cont.value=cont;
  form1.submit();
}
}

//-->
</SCRIPT>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/icon-return-to-main-2.gif','images/icon-submit-changes-2.gif','images/icon-continue-wizard-2.gif')">
<form name="form1" method="post" action="">
<input type="hidden" name="page" value="<%=Page%>">
<input type="hidden" name="cont" value="">
<input type="hidden" id="Realms" Name="Realms" value="<%=Request("Realms")%>">
  <table width="525" border="0" cellspacing="0" cellpadding="2" align="center">
  <tr bgcolor="#FFFFFF"> 
    <td width="467">&nbsp;</td>
    <td align="right" width="58">&nbsp;</td>
  </tr>
  <tr bgcolor="#5e5ebe"> 
      <td width="467" align="center" class="headline-ffffff">Destination Target Creation</td>
    <td bgcolor="#5e5ebe" align="right" width="58"><a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/icon-return-to-main-2.gif',1)" onClick="MM_goToURL('this','default-destinations.asp');return document.MM_returnValue"><img src="images/icon-return-to-main.gif" width="75" height="17" usemap="#returntomain" border="0" name="Image1"></a></td>
  </tr>
  <tr> 
    <td width="467"></td>
    <td width="58">&nbsp;</td>
  </tr>

    <% If Not Request("Realms") = "" Then %>
	</table>
	<table width="500" border="0" cellspacing="0" cellpadding="2" align="center">
	    <tr> 
			<td>&nbsp;</td>
		</tr>
		<tr> 
			<td align="center" class="manage-menu"><select name="Destinations" id="Destinations" size="7" MULTIPLE>
			<%
				SQL = "Get_Destination @Realm_ID='" & Session("Admin_Realm") & "'"
				Set Destinations = Conn.Execute(SQL)
				Do While Not Destinations.EOF
					Response.Write ("<option value=""" & Destinations("Dest_ID") & """")
					For each Realm_ID in Request("Realms")
						SQL = "Get_Destination @Realm_ID='" & Realm_ID & "'"
						Set RSD = Conn.Execute(SQL)
						Do While Not RSD.EOF
							If Int(RSD("Dest_ID")) = Int(Destinations("Dest_ID")) Then Response.Write (" selected") 
							RSD.MoveNext
						Loop
					Next
					Response.Write (">" & Destinations("Name") & "</option>" & Chr(13))
					Destinations.MoveNext
				Loop			
			%>
		</select><Br><br>Please select the destinations that you <br>wish to align to your selected Realm(s).<br><br>
						And then click continue to add these<br> destinations to your selected realms.<br><br>
		</td>
		</tr>
	    <tr> 
			<td>&nbsp;</td>
		</tr>		
	</table>
	<table width="525" border="0" cellspacing="0" cellpadding="0" align="center">
	  <tr bgcolor="#5e5ebe"> 
		<!-- -->
			<td align="right" width="49%" bgcolor="#5e5ebe">
			<a href="javascript:Sub_Form('1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('submitchanges','','images/icon-submit-changes-2.gif',1)">
			<img src="images/icon-submit-changes.gif" width="200" height="15" name="submitchanges" border="0">
		</a>
	   </td>
       <td width="51%">
		<a href="javascript:Sub_Form('2');" onmouseover="MM_swapImage('Image2','','images/icon-continue-wizard-2.gif',1)"  onmouseout=MM_swapImgRestore()>
			<img src="images/icon-continue-wizard.gif" width="150" height="15" usemap="#continue" border="0" name="Image2">
		</a>
	   </td>
	  </tr>
	  <tr> 
	    <td width="49%">&nbsp;</td>
	    <td width="51%">&nbsp;</td>
	  </tr>
	</table> 

	<% Else %>
	  <tr> 
	    <td class="galley-text-indent-alert" colspan="2">No Realm(s) Selected! <a href="javascript:history.back()">Please go back</a> and choose a realm to align packages to.</td>
	  </tr>
	 </table>
    <% End If %>

</form>
</body>
</html>
