<%@ 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" %> <% sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = 0 WHERE Ris_Legna < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Pietra = 0 WHERE Ris_Pietra < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Ferro = 0 WHERE Ris_Ferro < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Zolfo = 0 WHERE Ris_Zolfo < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Oro = 0 WHERE Ris_Oro < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Sold_Semp = 0 WHERE E_Sold_Semp < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Sold_Cavallo = 0 WHERE E_Sold_Cavallo < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Arcieri_Corto = 0 WHERE E_Arcieri_Corto < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Arcieri_Lungo = 0 WHERE E_Arcieri_Lungo < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Balestrieri = 0 WHERE E_Balestrieri < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Cavalleria_Pesante = 0 WHERE E_Cavalleria_Pesante < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Bombardieri = 0 WHERE E_Bombardieri < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Cannone = 0 WHERE E_Cannone < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Generale = 0 WHERE E_Generale < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Petardo = 0 WHERE E_Petardo < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Ballista = 0 WHERE E_Ballista < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Catapulta = 0 WHERE E_Catapulta < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Ariete = 0 WHERE E_Ariete < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET E_Trabucco = 0 WHERE E_Trabucco < 0",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>