<%=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
%>
|
|