<%@ 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 Missioni SET Ris_Legna = 0, Ris_Pietra = 0, Ris_Ferro = 0, Ris_Zolfo = 0, Ris_Oro = 0 WHERE ID = 140037",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = Ris_Legna + 49609, Ris_Pietra = Ris_Pietra + 43100, Ris_Ferro = Ris_Ferro + 29400, Ris_Zolfo = Ris_Zolfo + 17952, Ris_Oro = Ris_Oro + 16473 WHERE Dimensione = 20 AND Reame = 7 AND Paese = 48 ",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 Generali SET Is_Dead = 0 WHERE ID = 4114 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Generali SET Is_Dead = 0 WHERE Proprietary = 'Adda' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Utenti SET Gilda = '', Grado_Gilda = 5 WHERE Gilda = 'MDH' ",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 = '"& Durata_Vacanza &"' WHERE Id_Utente = 1 ",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 Premium_Check = '', Premium_Data = '"& Data_Odierna &"' WHERE Username <> 'Jogo Delfa' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Fama = 250 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 C_Laboratorio = 5 WHERE Proprietary = 'Jogo Delfa' AND Nome = 'Darleth' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() %>