<%@ 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 Utenti SET Grado_Gilda = 0, Gilda = '' WHERE Gilda = '10!' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Gilde WHERE Tag = '10!' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = 100000, Ris_Pietra = 100000, Ris_Ferro = 100000, Ris_Zolfo = 0, Ris_Oro = 0 WHERE Dimensione = 18 AND Reame = 5 AND Paese = 37 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Dragon_Tooth = 0 WHERE Dimensione = 19 AND Reame = 15 AND Paese = 36 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET R_tempr_Ferro= 10 where dimensione = 3 and reame = 18 and paese = 26 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET R_Esplorazione = 15 WHERE R_Esplorazione > 15 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET R_Guardie = 15 WHERE R_Guardie > 15 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET E_Balestrieri = E_Balestrieri - 9304 WHERE Dimensione = 13 AND Reame = 7 AND Paese = 36 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET E_Cavalleria_Pesante = E_Cavalleria_Pesante + 1 WHERE Dimensione = '3' AND Reame = '1' AND Paese = '24' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET C_Mura = C_Mura + 1, C_Torrette = C_Torrette + 1 WHERE Dimensione = '19' AND Reame = '3' AND Paese = '20' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET C_Case = C_Case - 1 WHERE Dimensione = '3' AND Reame = '1' AND Paese = '21' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Messaggi SET Type_Message = 'Mix' WHERE Type_Message Is Null ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Messaggi SET Id_Sender = 0 WHERE Id_Sender Is Null ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'Dim Durata_Vacanza = New System.TimeSpan(0, -71, -58, 0) 'Durata_Vacanza = Datetime.Now.Add(Durata_Vacanza) 'Durata_Vacanza = Replace(Durata_Vacanza,".",":")' 'Durata_Vacanza = Format_Date(Durata_Vacanza) 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Vacanza SET Data_Inizio = '20/01/2005' WHERE Id_Utente = 3663 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Missioni Set Ris_Legna = 0, Ris_Pietra = 0, Ris_Ferro = 0, Ris_Zolfo = 0, Ris_Oro = 0 WHERE ID = 46944 OR ID = 46942 OR ID = 46941 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'Dim Data_Odierna as String = Datetime.Now 'Data_Odierna = Replace(Data_Odierna,".",":") 'Data_Odierna = Format_Date(Data_Odierna) 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Utenti SET Password = '123abc' WHERE Username = 'stefanofrancini' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Utenti SET Fama = 450 WHERE Username = 'SpillerO' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Utenti SET Password = 'fabiovanoli' WHERE Username = 'scrova73' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Missioni SET Ris_Legna = 0, Ris_Pietra = 0, Ris_Ferro = 0, Ris_Zolfo = 0, Ris_Oro = 0 WHERE ID = 82133 OR ID = 82145 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = Ris_Legna + 0, Ris_Pietra = Ris_Pietra + 0, Ris_Ferro = Ris_Ferro + 0, Ris_Zolfo = Ris_Zolfo + 0, Ris_Oro = Ris_Oro + 20000 WHERE Nome = 'Darleth' AND Proprietary = 'Jogo Delfa' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = 50000 , Ris_Pietra = 50000, Ris_Ferro = 50000, Ris_Zolfo = Ris_Zolfo + 0, Ris_Oro = Ris_Oro + 0 WHERE Dimensione = '11' AND Reame = '19' AND Paese = '45' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Proprietary = 'giakkie' WHERE Dimensione = '4' AND Reame = '1' AND Paese = '21' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Utenti SET Premium_Check = 'Y', Premium_Data = '18/01/2006 02:26:00' WHERE Username = 'Vladimir V. Melkor' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() %>