<%@ 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 E_Sold_Semp = 0, E_Sold_Cavallo = 0, E_Arcieri_Corto = 0, E_Arcieri_Lungo = 0, E_Fanteria_Pesante = 0, E_Cavalleria_Pesante = 0, E_Bombardieri = 0, C_Mercato = 5, Ris_Legna = 10000 , Ris_Pietra = 10000 , Ris_Ferro = 10000 , Ris_Zolfo = 10000 , Ris_Oro = 10000 WHERE Dimensione = 3 AND Reame = 1 AND Paese = 19 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = 20000, Ris_Pietra = 20000, Ris_Ferro = 20000, Ris_Zolfo = 0, Ris_Oro = 0 WHERE Dimensione = 11 AND Reame = 17 AND Paese = 50 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET PF_Mura = 50000 WHERE PF_Mura = 0 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET PF_Torrette = 50000 WHERE PF_Torrette = 0 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET E_Sold_Semp = E_Sold_Semp + 10 WHERE Dimensione = 11 AND Reame = 1 AND Paese = 21 ",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() '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 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 C_Laboratorio = 5 WHERE Proprietary = 'Jogo Delfa' AND Nome = 'Darleth' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() %>