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