%@ 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" %>
<%
Dim counter = 0
Dim P_Fattorie
Dim P_Taglialegna
Dim P_Min_Pietra
Dim P_Min_Ferro
Dim P_Min_Zolfo
Dim P_Min_Oro
Dim P_Cittadini
Dim Dimensione_Q = Request.QueryString ("Dim")
Dim Reame_Q = Request.QueryString ("Rea")
Dim Paese_Q = Request.QueryString ("Pae")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * from pianeti WHERE Dimensione = '"& Dimensione_Q &"' AND Reame = '"& Reame_Q &"' AND Paese = '"& Paese_Q &"' ", sqlConn)
'sqlComm = New SqlCommand("SELECT * from pianeti where P_Fattorie Is Null and paese <> 0 order by data_last_access", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
'If r("P_Fattorie") + r("P_Taglialegna") + r("P_Min_Pietra") + r("P_Min_Ferro") + r("P_Min_Zolfo") + r("P_Min_Oro") > r("P_Cittadini") Then
counter = counter + 1
response.write (r("proprietary"))
response.write (" : ")
response.write (r("Data_Last_Access"))
response.write ("
")
Proprietary = r("proprietary")
Dimensione = r("Dimensione")
Reame = r("Reame")
Paese = r("Paese")
P_Fattorie = r("P_Fattorie")
P_Taglialegna = r("P_Taglialegna")
P_Min_Pietra = r("P_Min_Pietra")
P_Min_Ferro = r("P_Min_Ferro")
P_Min_Zolfo = r("P_Min_Zolfo")
P_Min_Oro = r("P_Min_Oro")
P_Cittadini = r("P_Cittadini")
'End If
End While
r.Close()
sqlConn.Close()
Dim RQ = Request.QueryString ("ID")
sqlConn.Open()
If RQ = 1 Then
sqlComm = New SqlCommand("UPDATE Pianeti SET P_Fattorie = P_Fattorie - 10 WHERE Dimensione = '"& Dimensione_Q &"' AND Reame = '"& Reame_Q &"' AND Paese = '"& Paese_Q &"' ",sqlConn)
End If
If RQ = 2 Then
sqlComm = New SqlCommand("UPDATE Pianeti SET P_Min_Oro = P_Min_Oro - 10 WHERE Dimensione = '"& Dimensione_Q &"' AND Reame = '"& Reame_Q &"' AND Paese = '"& Paese_Q &"' ",sqlConn)
End If
If RQ = 3 Then
sqlComm = New SqlCommand("UPDATE Pianeti SET P_Min_Oro = 0, P_Min_Ferro = 0, P_Min_Zolfo = 0, P_Min_Pietra = 0, P_Taglialegna = 0 WHERE Dimensione = '"& Dimensione_Q &"' AND Reame = '"& Reame_Q &"' AND Paese = '"& Paese_Q &"' ",sqlConn)
End If
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Response.Write ("
")
Response.Write (counter)
Response.Write ("
")
Response.Write ("
")
Response.Write ("
")
Response.Write (Proprietary)
Response.Write ("
")
Response.Write (Dimensione)
Response.Write ("
")
Response.Write (Reame)
Response.Write ("
")
Response.Write (Paese)
Response.Write ("
")
Response.Write (P_Fattorie)
Response.Write ("
")
Response.Write (P_Taglialegna )
Response.Write ("
")
Response.Write (P_Min_Pietra )
Response.Write ("
")
Response.Write (P_Min_Ferro )
Response.Write ("
")
Response.Write (P_Min_Zolfo )
Response.Write ("
")
Response.Write (P_Min_Oro )
Response.Write ("
")
Response.Write ("
")
Response.Write (P_Cittadini )
%>