<% 


				dim Tabla, tabla2
				dim totalPrecio 
				dim db
				dim ssql
				dim Ultima

				set db = server.CreateObject("adodb.Connection")			
				set Tabla = server.CreateObject("adodb.Recordset")
				set Tabla2 = server.CreateObject("adodb.Recordset")			
				
				db.open "DSN=dbconsul"


				' Obtenemos el id de la base de datos
				
				tabla2.open "select max(ipv_id) from formulario",db,3,3
				
				if tabla2.eof then
					Ultima = 1
				else
					Ultima = tabla2.fields(0) + 1
				end if

 				tabla2.close
				if ultima = "" or isnull(ultima) then ultima=1
				
				TotalPrecio = 0
				miembroForo = "N"
				fechaTope = "N"

				if request.form("codigoRegistro")="ipv6fmember" then
					miembroForo = "S"
				end if

				if date < cdate("15/01/2001") then
					fechaTope = "S"
				end if

				if request.form("codigoRegistro")="ipv6fmember" then
					if date < cdate("15/01/2001") then
						if request.form("AsisteConferencia") = "S" then
							TotalPrecio = TotalPrecio + 100
						end if
						if request.form("tutorial") = "S" then
							TotalPrecio = TotalPrecio + 50
						end if
					else
						if request.form("AsisteConferencia") = "S" then
							TotalPrecio = TotalPrecio + 250
						end if
						if request.form("tutorial") = "S" then
							TotalPrecio = TotalPrecio + 100
						end if
					end if
				else
					
					if date < cdate("15/01/2001") then
						if request.form("AsisteConferencia") = "S" then
							TotalPrecio = TotalPrecio + 200
						end if
						if request.form("tutorial") = "S" then
							TotalPrecio = TotalPrecio + 75
						end if
                 else
						if request.form("AsisteConferencia") = "S" then
							TotalPrecio = TotalPrecio + 250
						end if
						if request.form("tutorial") = "S" then
							TotalPrecio = TotalPrecio + 100
						end if
					end if
				end if

				TotalPrecio=TotalPrecio*1.16
				
				if request.form("aloja28")="S" then
					TotalPrecio = TotalPrecio + 42.8
				end if
				if request.form("aloja29")="S" then
					TotalPrecio = TotalPrecio + 42.8
				end if
				if request.form("aloja30")="S" then
					TotalPrecio = TotalPrecio + 42.8
				end if
				if request.form("aloja31")="S" then
					TotalPrecio = TotalPrecio + 42.8
				end if
				
				
				tabla2.open "select * from formulario",db,3,3
				
				tabla2.AddNew
				
				tabla2.fields("ipv_id").value = Ultima
				tabla2.fields("ipv_compania").value = request.form("compania")
				tabla2.fields("ipv_ivaeuropeo").value = request.form("ivaeuropeo")
				tabla2.fields("ipv_nombre").value = request.form("nombre")
				tabla2.fields("ipv_apellidos").value = request.form("apellidos")
				tabla2.fields("ipv_cargo").value = request.form("cargo")
				tabla2.fields("ipv_direccion").value = request.form("direccion")
				tabla2.fields("ipv_cpeuropeo").value = request.form("cpeuropeo")
				tabla2.fields("ipv_municipio").value = request.form("municipio")
				tabla2.fields("ipv_provincia").value = request.form("provincia")
				tabla2.fields("ipv_pais").value = request.form("pais")
				tabla2.fields("ipv_email").value = request.form("email")
					
				tabla2.fields("ipv_codTelefonicoPais").value = request.form("codTelefonicoPais")
				tabla2.fields("ipv_restotelefono").value = request.form("restotelefono")
				tabla2.fields("ipv_restofax").value = request.form("restofax")
				tabla2.fields("ipv_movil").value = request.form("movil")

				if request.form("codigoRegistro") = "ipv6fmember" then 
					tabla2.fields("ipv_codigoRegistro").value = "S"
				else
					tabla2.fields("ipv_codigoRegistro").value = "N"
				end if 
				
				tabla2.fields("ipv_portatil").value = request.form("portatil")
				
				tabla2.fields("ipv_wirelesslan").value = request.form("wirelesslan")
				tabla2.fields("ipv_lan10100").value = request.form("lan10100")

				if request.form("AsisteConferencia") = "S" then
					if miembroForo = "S" then
						if fechaTope = "S" then
							tabla2.fields("ipv_AsisteConferencia").value = "1"
						else
							tabla2.fields("ipv_AsisteConferencia").value = "5"
						end if
					else
						if fechaTope = "S" then
							tabla2.fields("ipv_AsisteConferencia").value = "2"
						else
							tabla2.fields("ipv_AsisteConferencia").value = "5"
						end if
					end if
				end if

				if request.form("tutorial")="S" then
					if miembroForo="S" then
						if fechaTope = "S" then
							tabla2.fields("ipv_tutorial").value = "5"
						else
							tabla2.fields("ipv_tutorial").value = "1"
						end if
					else
						if fechaTope = "S" then
							tabla2.fields("ipv_tutorial").value = "7"
						else
							tabla2.fields("ipv_tutorial").value = "1"
						end if
					end if
				end if

				tabla2.fields("ipv_aloja28").value = request.form("aloja28")
				tabla2.fields("ipv_aloja29").value = request.form("aloja29")
				tabla2.fields("ipv_aloja30").value = request.form("aloja30")
				tabla2.fields("ipv_aloja31").value = request.form("aloja31")
				
				tabla2.fields("ipv_vegetariano").value = request.form("vegetariano")
				tabla2.fields("ipv_cena30").value = request.form("cena30")
				tabla2.fields("ipv_cena31").value = request.form("cena31")
				tabla2.fields("ipv_porquemedio").value = request.form("porquemedio")
				tabla2.fields("ipv_total").value = totalprecio
				
				tabla2.update
				
				'ssql =" insert into formulario "
				'ssql = ssql & "(ipv_id,"
				'ssql = ssql & "ipv_compania,"
				'ssql = ssql & "ipv_ivaeuropeo,"
				'ssql = ssql & "ipv_nombre,"
				'ssql = ssql & "ipv_apellidos,"
				'ssql = ssql & "ipv_cargo,"
				'ssql = ssql & "ipv_direccion,"
				'ssql = ssql & "ipv_cpeuropeo,"
				'ssql = ssql & "ipv_municipio,"
				'ssql = ssql & "ipv_provincia,"
				'ssql = ssql & "ipv_pais,"
				'ssql = ssql & "ipv_email,"
				'ssql = ssql & "ipv_codTelefonicoPais,"
				'ssql = ssql & "ipv_restotelefono,"
				'ssql = ssql & "ipv_restofax,"
				'ssql = ssql & "ipv_movil,"
				'ssql = ssql & "ipv_codigoRegistro,"
				'ssql = ssql & "ipv_portatil,"
				'ssql = ssql & "ipv_wirelesslan,"
				'ssql = ssql & "ipv_lan10100,"
				'ssql = ssql & "ipv_AsisteConferencia,"
				'ssql = ssql & "ipv_tutorial,"
				'ssql = ssql & "ipv_aloja28,"
				'ssql = ssql & "ipv_aloja29,"
				'ssql = ssql & "ipv_aloja30,"
				'ssql = ssql & "ipv_aloja31,"
				'ssql = ssql & "ipv_vegetariano,"
				'ssql = ssql & "ipv_cena30,"
				'ssql = ssql & "ipv_cena31,"
				'ssql = ssql & "ipv_porquemedio,ipv_total)"
			'	
				'ssql = ssql & " values (" & Ultima & ","
				'ssql = ssql & "'" & request.form("compania") & "',"
				'ssql = ssql & "'" & request.form("ivaeuropeo") & "',"
				'ssql = ssql & "'" & request.form("nombre") & "',"
				'ssql = ssql & "'" & request.form("apellidos") & "',"
				'ssql = ssql & "'" & request.form("cargo") & "',"
				'ssql = ssql & "'" & request.form("direccion") & "',"
				'ssql = ssql & "'" & request.form("cpeuropeo") & "',"
				'ssql = ssql & "'" & request.form("municipio") & "',"
				'ssql = ssql & "'" & request.form("provincia") & "',"
				'ssql = ssql & "'" & request.form("pais") & "',"
				'ssql = ssql & "'" & request.form("email") & "',"
				'ssql = ssql & "'" & request.form("codTelefonicoPais") & "',"
				'ssql = ssql & "'" & request.form("restotelefono") & "',"
				'ssql = ssql & "'" & request.form("restofax") & "',"
				'ssql = ssql & "'" & request.form("movil") & "',"
				'ssql = ssql & "'" & request.form("codigoRegistro") & "',"
				'ssql = ssql & "'" & request.form("portatil") & "',"
				'ssql = ssql & "'" & request.form("wirelesslan") & "',"
				'ssql = ssql & "'" & request.form("lan10100") & "',"
				'ssql = ssql & "'" & request.form("AsisteConferencia") & "',"
				'ssql = ssql & "'" & request.form("tutorial") & "',"
				'ssql = ssql & "'" & request.form("aloja28") & "',"
				'ssql = ssql & "'" & request.form("aloja29") & "',"
				'ssql = ssql & "'" & request.form("aloja30") & "',"
				'ssql = ssql & "'" & request.form("aloja31") & "',"
				'ssql = ssql & "'" & request.form("vegetariano") & "',"
				'ssql = ssql & "'" & request.form("cena30") & "',"
				'ssql = ssql & "'" & request.form("cena31") & "',"
				'ssql = ssql & "'" & request.form("porquemedio") & "'," & totalprecio & ")"
				'db.BeginTrans
				'db.execute ssql
				'db.CommitTrans
				'Tabla.open ssql,db, 3, 3 

				'tabla2.close
				
				db.close

%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Madrid Global IPv6 Summit - Go to Secure Payment Page</title>
</head>

<body>
<font face="arial">

<table border="1" bgcolor="#FFFFFF">
  <tr>
    <td colspan="3"><table border="0" width="100%">
      <tr>
        <td width="17%"><p align="left"><a href="guardarFormulario.asp"><img
        src="../../../Imagenes/Iconos/castellano.gif" alt="Versión en Castellano"
        align="absmiddle" border="0" width="35" height="23"></a>Spanish</td>
        <td width="16%"><p align="right"><big><strong>Organized by:</strong></big></td>
        <td width="33%" align="center"><a href="http://www.ipv6forum.com" target="_blank"><img
        src="../../../Imagenes/Logos/ipv6logo.gif" alt="IPv6 Forum" border="0" width="115"
        height="92"></a></td>
        <td width="34%" align="center"><a href="http://www.consulintel.es" target="_blank"><img
        src="../../../Imagenes/Logos/consulip.jpg" alt="CONSULINTEL" border="0" width="289"
        height="70"></a></td>
      </tr>
    </table>
    <h1 align="center"><small><font color="#0080C0">Global IPv6 Summit in Madrid (Spain)</font></small><br>
    <small><font color="#0080C0">29, 30, 31 January and 1st February (2001)</font></small></h1>
    </td>
  </tr>
  <tr>
    <td colspan="3"><table border="0" width="100%">
      <tr>
        <td align="center">
        <applet code="fphover.class" codebase="../../../_fpclass/" width="130" height="30">
          <param name="text" value="HOME">
          <param name="color" value="#808000">
          <param name="hovercolor" value="#808080">
          <param name="textcolor" value="#00FFFF">
          <param name="effect" value="lightGlow">
          <param name="url" value="../madridgishomeeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </td>
        <td align="center">
        <applet code="fphover.class" codebase="../../../_fpclass/" width="130" height="30">
          <param name="text" value="AGENDA">
          <param name="color" value="#000080">
          <param name="hovercolor" value="#0000FF">
          <param name="textcolor" value="#FFFF00">
          <param name="effect" value="lightGlow">
          <param name="url" value="../mgisagendaeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </td>
        <td align="center"><strong>
        <applet code="fphover.class" codebase="../../../_fpclass/" width="140" height="30">
          <param name="text" value="REGISTRATION">
          <param name="color" value="#FF0000">
          <param name="hovercolor" value="#FFFF00">
          <param name="textcolor" value="#000080">
          <param name="effect" value="glow">
          <param name="url" value valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </strong></td>
        <td align="center">
        <applet code="fphover.class" codebase="../../../_fpclass/" width="130" height="30">
          <param name="text" value="LOGISTICS">
          <param name="color" value="#008080">
          <param name="hovercolor" value="#00FF00">
          <param name="textcolor" value="#C0C0C0">
          <param name="effect" value="lightGlow">
          <param name="url" value="../mgislogisticaeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </td>
        <td align="center"><strong>
        <applet code="fphover.class" codebase="../../../_fpclass/" width="140" height="30">
          <param name="text" value="SPONSORSHIP">
          <param name="color" value="#FFFF00">
          <param name="hovercolor" value="#FF0000">
          <param name="textcolor" value="#000080">
          <param name="effect" value="glow">
          <param name="url" value="../mgispatrocinioeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </strong></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td valign="top" width="150"><p align="center">&nbsp;</p>
    <p align="center"><strong>Sponsored by:</strong></p>
    <p align="center"><a href="http://www.3com.com" target="_blank"><img
    src="../../../Imagenes/Logos/3com.gif" alt="3Com" border="0" width="109" height="60"></a><br>
    <br>
    <a href="http://www.6wind.com/" target="_blank"><img
    src="../../../Imagenes/Logos/6wind.jpg" alt="6Wind" border="0" width="138" height="44"></a><br>
    <br>
    <a href="http://www.cisco.com/" target="_blank"><img
    src="../../../Imagenes/Logos/cisco.gif" alt="Cisco" border="0" width="112" height="89"></a><br>
    <br>
    <a href="http://www.compaq.com/ipv6" target="_blank"><img
    src="../../../Imagenes/Logos/compaq.jpg" alt="Compaq" border="0" width="138" height="38"></a><br>
    <br>
    <a href="http://www.ericsson.es" target="_blank"><img
    src="../../../Imagenes/Logos/ericsson.gif" alt="Ericsson" border="0" width="136"
    height="26"></a><br>
    <br>
    <a href="http://www.hp.es" target="_blank"><img src="../../../Imagenes/Logos/hp.gif"
    alt="HP" border="0" width="69" height="57"></a><br>
    <br>
    <a href="http://www.idg.es/" target="_blank"><img src="../../../Imagenes/Logos/idg.gif"
    alt="IDG" border="0" width="150" height="52"></a><br>
    <br>
    <a href="http://www.mcyt.es/" target="_blank"><img src="../../../Imagenes/Logos/mcyt.gif"
    alt="Ministerio de Ciencia y Tecnología" border="0" width="101" height="137"></a><br>
    <br>
    <a href="http://www.nokia.com" target="_blank"><img
    src="../../../Imagenes/Logos/nokia.gif" alt="NOKIA" border="0" width="136" height="50"></a><br>
    <br>
    <a href="http://www.nortelnetworks.com" target="_blank"><img
    src="../../../Imagenes/Logos/nortel.gif" alt="Nortel Networks" border="0" width="125"
    height="32"></a><br>
    <br>
    <a href="mailto:info@novagnet.com"><img src="../../../Imagenes/Logos/novagnet.gif"
    alt="novaGnet systems" border="0" width="149" height="134"></a><br>
    <br>
    <a href="http://www.olainternet.com/" target="_blank"><img
    src="../../../Imagenes/Logos/olainternet.gif" alt="Ola Internet" border="0" width="137"
    height="72"></a><br>
    <br>
    <a href="http://www.sun.com" target="_blank"><img src="../../../Imagenes/Logos/sun.gif"
    alt="Sun Microsystems" border="0" width="114" height="52"></a><br>
    <br>
    <br>
    <br>
    </td>
    <td valign="top"><p align="center"><font color="#804000"><strong><br>
    <big>Payment Confirmation</big></strong></font><br>
    </p>
    <p>We have processed your request to attend the event and/or room confirmation.</p>
    <p>To continue, you need to apply for the payment with a credit card. In the next screen,
    type the credit card digits <em><strong>without any blank spaces</strong></em>, just
    numbers.</p>
    <p>Alternatively arrange a bank transfer within 48 hours. You will receive an email with
    the bank details (if not, please, write us to <a href="mailto:ipv6@consulintel.es">ipv6@consulintel.es</a>,
    with your registration number, so we can confirm the procedure).</p>
    <p>&nbsp;</p>
    <p align="center"><u><strong>VERY IMPORTANT !</strong></u></p>
    <p align="center"><strong>If you don't proceed with this step, your request is
    automatically CANCELLED.</strong></p>
    <p align="center">After this step, you will receive a Confirmation email; if you don't
    receive it, please, contact with the event organization by email at <a
    href="mailto:ipv6@consulintel.es">ipv6@consulintel.es</a></p>
    <form method="POST" action="https://tpv.4b.es/tpvv/teargral.exe">
      <input type="hidden" name="ordernum" value="<%=Ultima%>"><input type="hidden" name="store"
      value="o48"><input type="hidden" name="idioma" value="en"><div align="center"><center><p><input
      type="submit" value="Confirm the PAYMENT with a CREDIT/DEBIT card" name="Pasar a pagar"> </p>
      </center></div>
    </form>
    <form method="POST" action="pago_transf.asp">
      <input type="hidden" name="ordernum" value="<%=Ultima%>"><div align="center"><center><p><input
      type="submit" value="PAYMENT with bank TRANSFER" name="Transferencia"></p>
      </center></div>
    </form>
    </td>
    <td valign="top" width="150"><p align="center">&nbsp;</p>
    <p align="center"><strong>Endorsed by:</strong></p>
    <p align="center"><a href="http://www.3gpp.org" target="_blank"><img
    src="../../../Imagenes/Logos/3gpp.gif" alt="3GPP" border="0" width="95" height="55"></a><br>
    <br>
    <a href="http://www.aniel.es" target="_blank"><img src="../../../Imagenes/Logos/aniel.gif"
    alt="ANIEL" border="0" width="121" height="40"><br>
    <br>
    </a><a href="http://www.cmt.es" target="_blank"><img src="../../../Imagenes/Logos/cmt.gif"
    alt="CMT" border="0" width="111" height="85"></a><br>
    <br>
    <a href="http://www.nic.es" target="_blank"><img src="../../../Imagenes/Logos/esnic.gif"
    alt="ES-NIC" border="0" width="121" height="121"></a><a href="http://www.aniel.es"
    target="_blank"><br>
    <br>
    </a><a href="http://www.etsi.org" target="_blank"><img
    src="../../../Imagenes/Logos/etsi.gif" alt="ETSI" border="0" width="125" height="37"></a><br>
    <br>
    <a href="http://www.ineco.es" target="_blank"><img src="../../../Imagenes/Logos/ineco.gif"
    alt="INECO" border="0" width="93" height="121"></a><br>
    <br>
    <a href="http://www.isoc.org" target="_blank"><img src="../../../Imagenes/Logos/isoc.gif"
    alt="ISOC" border="0" width="120" height="48"></a><br>
    <br>
    <a href="http://www.rediris.es" target="_blank"><img
    src="../../../Imagenes/Logos/rediris.gif" alt="RedIRIS" border="0" width="120" height="33"></a><br>
    <br>
    <a href="http://www.telefonica.es" target="_blank"><img
    src="../../../Imagenes/Logos/telefonica.gif" alt="Telefónica" border="0" width="112"
    height="36"></a><br>
    <br>
    <a href="http://www.umts-forum.org" target="_blank"><img
    src="../../../Imagenes/Logos/umtsforum.gif" alt="UMTS Forum" border="0" width="110"
    height="180"></a><br>
    <br>
    <a href="http://www.it.uc3m.es/" target="_blank"><img
    src="../../../Imagenes/Logos/uc3m.gif"
    alt="Univ. Carlos III de Madrid - Dpto. Ingenieria Telemática" border="0" width="101"
    height="101"></a><br>
    <br>
    <a href="http://www.ac.upc.es/CCABA/" target="_blank"><img
    src="../../../Imagenes/Logos/upc.gif" alt="Univ. Politècnica de Catalunya" border="0"
    width="105" height="104"></a><br>
    <br>
    <a href="http://www.dit.upm.es/" target="_blank"><img
    src="../../../Imagenes/Logos/ditupm.gif"
    alt="Departamento de Ingeniería de Sistemas Telemáticos - ETS - UPM" border="0"
    width="106" height="106"></a><br>
    <br>
    <a href="http://www.wcai.com" target="_blank"><img src="../../../Imagenes/Logos/wcai.gif"
    alt="Wireless Communications Association International" border="0" width="106" height="72"></a><br>
    </td>
  </tr>
  <tr>
    <td colspan="3"><table border="0" width="100%">
      <tr>
        <td align="center">
        <applet code="fphover.class" codebase="../../../_fpclass/" width="130" height="30">
          <param name="text" value="HOME">
          <param name="color" value="#808000">
          <param name="hovercolor" value="#808080">
          <param name="textcolor" value="#00FFFF">
          <param name="effect" value="lightGlow">
          <param name="url" value="../madridgishomeeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </td>
        <td align="center">
        <applet code="fphover.class" codebase="../../../_fpclass/" width="130" height="30">
          <param name="text" value="AGENDA">
          <param name="color" value="#000080">
          <param name="hovercolor" value="#0000FF">
          <param name="textcolor" value="#FFFF00">
          <param name="effect" value="lightGlow">
          <param name="url" value="../mgisagendaeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </td>
        <td align="center"><strong>
        <applet code="fphover.class" codebase="../../../_fpclass/" width="140" height="30">
          <param name="text" value="REGISTRATION">
          <param name="color" value="#FF0000">
          <param name="hovercolor" value="#FFFF00">
          <param name="textcolor" value="#000080">
          <param name="effect" value="glow">
          <param name="url" value valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </strong></td>
        <td align="center">
        <applet code="fphover.class" codebase="../../../_fpclass/" width="130" height="30">
          <param name="text" value="LOGISTICS">
          <param name="color" value="#008080">
          <param name="hovercolor" value="#00FF00">
          <param name="textcolor" value="#C0C0C0">
          <param name="effect" value="lightGlow">
          <param name="url" value="../mgislogisticaeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </td>
        <td align="center"><strong>
        <applet code="fphover.class" codebase="../../../_fpclass/" width="140" height="30">
          <param name="text" value="SPONSORSHIP">
          <param name="color" value="#FFFF00">
          <param name="hovercolor" value="#FF0000">
          <param name="textcolor" value="#000080">
          <param name="effect" value="glow">
          <param name="url" value="../mgispatrocinioeng.htm" valuetype="ref">
          <param name="font" value="Helvetica">
          <param name="fontstyle" value="bold">
          <param name="fontsize" value="18">
        </applet>
        </strong></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
</font>
</body>
</html>