<%@ 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 strConn = ("server=PICCOLO8-4FC49E;uid=sa;pwd=sa;database=low") Dim strConn = ("server=62.149.153.14; initial catalog=MSSql14112;uid=MSSql14112;pwd=3d2c957f") Dim sqlConn As New SqlConnection(strConn) Dim SqlComm as New SqlCommand Dim r as SqlDatareader Dim result As Integer sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Abilita " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Ban " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Code " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Edifici " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Esercito " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Gilde " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Lista_Amici " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Messaggi " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Missioni " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Pianeti" ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Ricerche " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Soldati_In_Missione " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Utenti " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Punti " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Vacanza" ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Moduli_Premium" ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Ban ( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Username_Bannato] [varchar] (50) NOT NULL , " & _ "[Motivazione] [varchar] (100) NOT NULL , " & _ "[Data_Rilascio] [datetime] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Abilita ( " & _ "[Id_Paese] [int] NULL , " & _ "[Ab_1] [int] NULL , " & _ "[Ab_2] [int] NULL , " & _ "[Ab_3] [int] NULL , " & _ "[Ab_4] [int] NULL , " & _ "[Ab_5] [int] NULL , " & _ "[Ab_6] [int] NULL , " & _ "[Ab_7] [int] NULL , " & _ "[Ab_8] [int] NULL , " & _ "[Ab_9] [int] NULL , " & _ "[Ab_10] [int] NULL , " & _ "[Ab_11] [int] NULL , " & _ "[Ab_12] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Code( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Coda_Addestra] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Quantity] [int] NULL , " & _ "[Race] [varchar] (10) COLLATE Latin1_General_CI_AS NULL , " & _ "[Id_Paese] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Edifici ( " & _ "[Id_Paese] [int] NULL , " & _ "[C_Costr_1] [int] NULL , " & _ "[C_Costr_2] [int] NULL , " & _ "[C_Costr_3] [int] NULL , " & _ "[C_Costr_4] [int] NULL , " & _ "[C_Costr_5] [int] NULL , " & _ "[C_Costr_6] [int] NULL , " & _ "[C_Costr_7] [int] NULL , " & _ "[C_Costr_8] [int] NULL , " & _ "[C_Costr_9] [int] NULL , " & _ "[C_Costr_10] [int] NULL , " & _ "[C_Costr_11] [int] NULL , " & _ "[C_Costr_12] [int] NULL , " & _ "[C_Costr_13] [int] NULL , " & _ "[C_Costr_14] [int] NULL , " & _ "[C_Costr_15] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Esercito ( " & _ "[Id_Paese] [int] NULL , " & _ "[E_Sold_1] [decimal] (10,4) NULL , " & _ "[E_Sold_2] [decimal] (10,4) NULL , " & _ "[E_Sold_3] [decimal] (10,4) NULL , " & _ "[E_Sold_4] [decimal] (10,4) NULL , " & _ "[E_Sold_5] [decimal] (10,4) NULL , " & _ "[E_Sold_6] [decimal] (10,4) NULL , " & _ "[E_Sold_7] [decimal] (10,4) NULL , " & _ "[E_Sold_8] [decimal] (10,4) NULL , " & _ "[E_Sold_9] [decimal] (10,4) NULL , " & _ "[E_Sold_10] [decimal] (10,4) NULL , " & _ "[E_Sold_11] [decimal] (10,4) NULL , " & _ "[E_Sold_12] [decimal] (10,4) NULL , " & _ "[E_Sold_13] [decimal] (10,4) NULL , " & _ "[E_Sold_14] [decimal] (10,4) NULL , " & _ "[E_Sold_15] [decimal] (10,4) NULL , " & _ "[E_Sold_16] [decimal] (10,4) NULL , " & _ "[E_Sold_17] [decimal] (10,4) NULL , " & _ "[E_Sold_18] [decimal] (10,4) NULL , " & _ "[E_Sold_19] [decimal] (10,4) NULL , " & _ "[E_Sold_20] [decimal] (10,4) NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Gilde ( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Nome] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Tag] [char] (3) NULL , " & _ "[Descrizione] [varchar] (5000) NULL , " & _ "[Grado_1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_2] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_3] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_4] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_5] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Lista_Amici ( " & _ "[Id_Utente] [int] NULL , " & _ "[Id_Amico] [int] NULL , " & _ "[Note] [varchar] (200) NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Messaggi ( " & _ "[Id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Utente] [int] NULL , " & _ "[Messaggio] [varchar] (3000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data] [datetime] NULL , " & _ "[Type_Message] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Id_Sender] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Missioni ( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Type_Mission] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Time_Started] [datetime] NULL , " & _ "[Time_Arrive] [datetime] NULL , " & _ "[Army_Of] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Id_Started] [int] NULL , " & _ "[Id_Arrive] [int] NULL , " & _ "[Ris_Legna] [int] NULL , " & _ "[Ris_Pietra] [int] NULL , " & _ "[Ris_Mana] [int] NULL , " & _ "[Ris_Oro] [int] NULL , " & _ "[Morti_Atk] [int] NULL , " & _ "[Morti_Ass] [int] NULL , " & _ "[Winner] [char] (3) COLLATE Latin1_General_CI_AS NULL , " & _ "[Avviso] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Ritirata] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Colonize] [varchar] (10) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Pianeti ( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Data_Last_Access] [datetime] NULL , " & _ "[Proprietary] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Nome] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Ris_Legna] [numeric](15, 4) NULL , " & _ "[Ris_Pietra] [numeric](15, 4) NULL , " & _ "[Ris_Mana] [numeric](15, 4) NULL , " & _ "[Ris_Oro] [numeric](15, 4) NULL , " & _ "[Dimensione] [int] NULL , " & _ "[Reame] [int] NULL , " & _ "[Paese] [int] NULL , " & _ "[In_Costr_Eser] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Eser] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Eser] [datetime] NULL , " & _ "[Data_Fine_Eser] [datetime] NULL , " & _ "[In_Costr_Infr] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Infr] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Infr] [datetime] NULL , " & _ "[Data_Fine_Infr] [datetime] NULL , " & _ "[In_Costr_Res] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Res] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Res] [datetime] NULL , " & _ "[Data_Fine_Res] [datetime] NULL , " & _ "[In_Costr_Dif] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Dif] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Dif] [datetime] NULL , " & _ "[Data_Fine_Dif] [datetime] NULL , " & _ "[In_Costr_Ab] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Cosa_Costr_Ab] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Costr_Ab] [datetime] NULL , " & _ "[Data_Fine_Ab] [datetime] NULL , " & _ "[P_Cittadini] [decimal] (10,4) NULL , " & _ "[P_Costr_3] [int] NULL , " & _ "[P_Costr_4] [int] NULL , " & _ "[P_Costr_5] [int] NULL , " & _ "[P_Costr_6] [int] NULL , " & _ "[Is_Principal] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Ricerche ( " & _ "[Id_Paese] [int] NULL , " & _ "[R_Ric_1] [int] NULL , " & _ "[R_Ric_2] [int] NULL , " & _ "[R_Ric_3] [int] NULL , " & _ "[R_Ric_4] [int] NULL , " & _ "[R_Ric_5] [int] NULL , " & _ "[R_Ric_6] [int] NULL , " & _ "[R_Ric_7] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Soldati_In_Missione ( " & _ "[Id_Soldato] [int] NULL , " & _ "[Id_Missione] [int] NULL , " & _ "[Type_Soldato] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Quantity_Soldato] [float] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Utenti ( " & _ "[Fama] [int] NULL , " & _ "[Last_Access] [datetime] NULL , " & _ "[Last_Id] [int] NULL , " & _ "[Gilda] [char] (3) NULL , " & _ "[Grado_Gilda] [int] NULL , " & _ "[Initial_Ip] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Accetta_Termini] [char] (7) COLLATE Latin1_General_CI_AS NULL , " & _ "[username] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[password] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Msn] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Icq_Uin] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , " & _ "[id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Background] [varchar] (5000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Email] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Attivo] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Vacanza] [int] NULL , " & _ "[Ban] [int] NULL , " & _ "[Race] [char] (10) NULL , " & _ "[Premium_Data] [datetime] NULL , " & _ "[Registration_Data] [datetime] NULL , " & _ "[Punti] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Vacanza( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Utente] [int] NOT NULL , " & _ "[Data_Inizio] [datetime] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Punti ( " & _ "[Data] [datetime] NULL , " & _ "[Ip] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[username] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Moduli_Premium( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Username] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Uff_Postale] [varchar] (500) NULL , " & _ "[Data_Pagamento] [varchar] (100) NULL , " & _ "[Mesi] [varchar] (20) NULL , " & _ "[Attivo] [char] (2) NULL , " & _ "[Pay_Type] [char] (10) NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim m_conn Dim m_cmd dim m_sql as String = "INSERT INTO Pianeti (Dimensione, Reame, Paese) VALUES (@Dimensione, @Reame, @Paese)" Try m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Dimensione", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try %>