<%@ Page Language="vb" Debug="true" %> <% @Import NameSpace="System.Data" %> <% @Import NameSpace="System.Data.SQLClient" %> <% @Import NameSpace="System.Diagnostics.Debug" %> <% @Import Namespace="System.Web.Mail" %> <% @Import Namespace="System.Text.RegularExpressions" %> <% @Import NameSpace="System.Data.OleDb" %> <%@ Import namespace="System.IO" %> <%@ Import namespace="System.Net" %> <% sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_C_Taverna = r("C_Taverna") End While r.Close() sqlConn.Close() %> <% Dim VR = Request.QueryString("VR") VR = DeCripta(VR) Dim cod = Request.QueryString("cod") cod = DeCripta(cod) If VR = "Si" Then E1_arr(1) = "E_Sold_Semp" E1_arr(2) = "E_Sold_Cavallo" E1_arr(3) = "E_Arcieri_Corto" E1_arr(4) = "E_Arcieri_Lungo" E1_arr(5) = "E_Fanteria_Pesante" E1_arr(6) = "E_Balestrieri" E1_arr(7) = "E_Cavalleria_Pesante" E1_arr(8) = "E_Bombardieri" P1_arr(1) = 300 P1_arr(2) = 600 P1_arr(3) = 800 P1_arr(4) = 1000 P1_arr(5) = 1200 P1_arr(6) = 1500 P1_arr(7) = 1800 P1_arr(8) = 2000 If Var_C_Taverna + 1 > cod Then If Ris_Oro < P1_arr(cod) Then Msg_Taverna.Text = "Non hai abbastanza Oro per assoldare questo mercenario" End If If Ris_Oro > P1_arr(cod)-1 Then Ris_Oro = Ris_Oro - P1_arr(cod) Ris_Oro = Replace(Ris_Oro,",",".") sqlConn.Open() Stringa = "UPDATE Pianeti SET "& E1_arr(cod) &" = "& E1_arr(cod) &" + 1, Ris_Oro = "& Ris_Oro &" WHERE Dimensione = '"& Dimensione &"' AND Reame = '"& Reame &"' AND Paese = '"& Paese &"' " sqlComm = New SqlCommand(Stringa ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Msg_Taverna.Text = "Hai assoldato un mercenario" End If End If If Var_C_Taverna < cod Then Msg_Taverna.Text = "Non puoi assoldare questo mercenario!!!" End If End If %> <% If Var_C_Taverna < 1 Then %>

Non hai una Taverna!!!

  <% End If %> <% If Var_C_Taverna > 0 Then %>


Taverna


  <% sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Timer_Costruct = r("In_Costr_Infr") Ris_Legna = r("Ris_Legna") Ris_Ferro = r("Ris_Ferro") Ris_Zolfo = r("Ris_Zolfo") Ris_Pietra = r("Ris_Pietra") Ris_Oro = r("Ris_Oro") Cosa_Costr = r("Cosa_Costr") E1_arr(1) = "Soldato Semplice" E1_arr(2) = "Soldato a Cavallo" E1_arr(3) = "Arcieri (Arco Corto)" E1_arr(4) = "Arcieri (Arco Lungo)" E1_arr(5) = "Fanteria Pesante" E1_arr(6) = "Balestrieri" E1_arr(7) = "Cavalleria Pesante" E1_arr(8) = "Bombardieri" P1_arr(1) = 300 P1_arr(2) = 600 P1_arr(3) = 800 P1_arr(4) = 1000 P1_arr(5) = 1200 P1_arr(6) = 1500 P1_arr(7) = 1800 P1_arr(8) = 2000 For i = 1 to 8 If (r("C_Taverna")) > i-1 %><% End If Next End While r.Close() sqlConn.Close() %>
Assolda Mercenari

<%=E1_arr(i)%><%=P1_arr(i)%> Monete D'Oro &cod=<%=Cripta(i)%>">Assolda


 

  <% End If %>