<%@ 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" %>


<%=Read_File("inc\Lang\Languages.aspx",177) %>

<% Dim Codice = Request.QueryString ("Codice") Dim Pf_Torrette_New If Codice = "Aggiusta_Mura_Confirm" Then Dim Spesa Dim Pietra Dim Pf_Mura_New sqlConn.Open() sqlComm = New SqlCommand("SELECT Ris_Pietra, C_Mura, C_Torrette, R_Mura, R_Torrette, PF_Mura, PF_Torrette FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If Not r("Ris_Pietra") < CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 Then Spesa = CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 Pietra = r("Ris_Pietra") Pf_Mura_New = CInt(50000 + (50000*r("R_Mura")/10)) Response.write (""& Read_File("inc\Lang\Languages.aspx",182) &"") End If If r("Ris_Pietra") < CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",178) &": "& CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 &" "& Read_File("inc\Lang\Languages.aspx",179) &"") End If End While r.Close() sqlConn.Close() If Not Pietra < Spesa Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Pietra = Ris_Pietra - "& CInt(Spesa) &", PF_Mura = "& Pf_Mura_New &" WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If If Codice = "Aggiusta_Mura" Then sqlConn.Open() sqlComm = New SqlCommand("SELECT Ris_Pietra, C_Mura, C_Torrette, R_Mura, R_Torrette, PF_Mura, PF_Torrette FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If Not r("Ris_Pietra") < CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",178) &": "& CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 &".

"& Read_File("inc\Lang\Languages.aspx",180) &"") Response.write ("

"& Read_File("inc\Lang\Languages.aspx",181) &"

") End If If r("Ris_Pietra") < CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",178) &": "& CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 &" "& Read_File("inc\Lang\Languages.aspx",179) &"") End If End While r.Close() sqlConn.Close() End If If Codice = "Aggiusta_Torrette_Confirm" Then Dim Spesa Dim Pietra sqlConn.Open() sqlComm = New SqlCommand("SELECT Ris_Pietra, C_Mura, C_Torrette, R_Mura, R_Torrette, PF_Mura, PF_Torrette FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Dim Var_Pf_Torrette If r("R_Torrette") < 5 Then Var_Pf_Torrette = 30000 End If If r("R_Torrette") > 4 AND r("R_Torrette") < 10 Then Var_Pf_Torrette = 40000 End If If r("R_Torrette") > 9 Then Var_Pf_Torrette = 50000 End If If Not r("Ris_Pietra") < CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 Then Spesa = CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 Pietra = r("Ris_Pietra") Pf_Torrette_New = CInt(Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) Response.write (""& Read_File("inc\Lang\Languages.aspx",183) &"") End If If r("Ris_Pietra") < CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",184) &": "& CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 &" "& Read_File("inc\Lang\Languages.aspx",179) &"") End If End While r.Close() sqlConn.Close() If Not Pietra < Spesa Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Pietra = Ris_Pietra - "& CInt(Spesa) &", PF_Torrette = "& Pf_Torrette_New &" WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If If Codice = "Aggiusta_Torrette" Then sqlConn.Open() sqlComm = New SqlCommand("SELECT Ris_Pietra, C_Mura, C_Torrette, R_Mura, R_Torrette, PF_Mura, PF_Torrette FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Dim Var_Pf_Torrette If r("R_Torrette") < 5 Then Var_Pf_Torrette = 30000 End If If r("R_Torrette") > 4 AND r("R_Torrette") < 10 Then Var_Pf_Torrette = 40000 End If If r("R_Torrette") > 9 Then Var_Pf_Torrette = 50000 End If If Not r("Ris_Pietra") < CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",184) &": "& CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 &".

"& Read_File("inc\Lang\Languages.aspx",180) &"") Response.write ("

"& Read_File("inc\Lang\Languages.aspx",181) &"

") End If If r("Ris_Pietra") < CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",184) &": "& CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 &" "& Read_File("inc\Lang\Languages.aspx",179) &"") End If End While r.Close() sqlConn.Close() End If If Codice = "" Then sqlConn.Open() sqlComm = New SqlCommand("SELECT C_Mura, C_Torrette, R_Mura, R_Torrette, PF_Mura, PF_Torrette FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("C_Mura") > 0 Then Response.write (" "& Read_File("inc\Lang\Languages.aspx",100) &"

") Response.write (" "& Read_File("inc\Lang\Languages.aspx",186) &": "& r("PF_Mura")) Response.write ("

"& Read_File("inc\Lang\Languages.aspx",187) &": "& 50000 + (50000*r("R_Mura")/10)) Response.write ("

"& Read_File("inc\Lang\Languages.aspx",178) &": "& CInt((50000 + (50000*r("R_Mura")/10)) - r("PF_Mura"))/4 &" "& Read_File("inc\Lang\Languages.aspx",188) &"") If ((50000 + (50000*r("R_Mura")/10)) > r("PF_Mura")) Then Response.write ("


"& Read_File("inc\Lang\Languages.aspx",185) &"

") End If End If If r("C_Mura") = 0 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",189) &"") End If Response.write ("



") Dim Var_Pf_Torrette If r("R_Torrette") < 5 Then Var_Pf_Torrette = 30000 End If If r("R_Torrette") > 4 AND r("R_Torrette") < 10 Then Var_Pf_Torrette = 40000 End If If r("R_Torrette") > 9 Then Var_Pf_Torrette = 50000 End If If r("C_Torrette") > 0 Then Response.write (" "& Read_File("inc\Lang\Languages.aspx",97) &"

") Response.write (" "& Read_File("inc\Lang\Languages.aspx",190) &": "& r("PF_Torrette")) Response.write ("

"& Read_File("inc\Lang\Languages.aspx",193) &": "& Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) Response.write ("

"& Read_File("inc\Lang\Languages.aspx",184) &": "& CInt((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) - r("PF_Torrette"))/20 &" "& Read_File("inc\Lang\Languages.aspx",188) &"") If ((Var_Pf_Torrette + (Var_Pf_Torrette*r("R_Torrette")/10)) > r("PF_Torrette")) Then Response.write ("


"& Read_File("inc\Lang\Languages.aspx",191) &"

") End If End If If r("C_Torrette") = 0 Then Response.write (""& Read_File("inc\Lang\Languages.aspx",192) &"") End If End While r.Close() sqlConn.Close() End If %>