<%@ 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 sqlConn.Open() sqlComm = New SqlCommand("SELECT * from pianeti where paese <> 0 ", 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("Dimensione")) response.write (" : ") response.write (r("Reame")) response.write (" : ") response.write (r("Paese")) 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") Dim Dimensione_Q = Request.QueryString ("Dim") Dim Reame_Q = Request.QueryString ("Rea") Dim Paese_Q = Request.QueryString ("Pae") 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 ) 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() %>