<%@ 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=SYLAR-9EB193D3F;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("DROP TABLE Quest " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Item_Quest " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Artefact " ,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_Attack] [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 , " & _ "[Crediti] [int] NULL , " & _ "[Prod_Legna_Data] [datetime] NULL , " & _ "[Prod_Pietra_Data] [datetime] NULL , " & _ "[Prod_Mana_Data] [datetime] NULL , " & _ "[Prod_Oro_Data] [datetime] NULL , " & _ "[Incr_Atk] [datetime] NULL , " & _ "[Incr_Dif] [datetime] NULL , " & _ "[Gen_Nome] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Razza] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Allineamento] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Classe] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Racial_Hate] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Stats] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Talenti] [varchar] (200) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gen_Lvl] [int] NULL , " & _ "[Gen_Lvl_Exp] [int] NULL , " & _ "[Gen_Right_Hand_Id] [int] NULL , " & _ "[Gen_Left_Hand_Id] [int] NULL , " & _ "[Gen_Helm_Id] [int] NULL , " & _ "[Gen_Neck_Id] [int] NULL , " & _ "[Gen_Chest_Id] [int] NULL , " & _ "[Gen_Gauntlets_Id] [int] NULL , " & _ "[Gen_Legs_Id] [int] NULL , " & _ "[Gen_Back_Id] [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() sqlConn.Open() sqlComm = New SqlCommand("Create Table Quest ( " & _ "[Id_Quest] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Number_Items] [int] NULL , " & _ "[Item_Name] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Total_Item] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Title_Quest] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Description] [varchar] (3000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Quest_Status] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Date_Start] [datetime] NULL , " & _ "[Date_End] [datetime] NULL , " & _ "[Winner] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Prize_Quantity] [int] NULL , " & _ "[Prize_Resource] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Prize_Artefact] [int] NULL , " & _ "[Data_Termine] [datetime] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Item_Quest ( " & _ "[Id_Utente] [int] NULL , " & _ "[Id_Quest] [int] NULL , " & _ "[Item_Name] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Artefact ( " & _ "[Id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Utente] [int] NULL , " & _ "[Artefact_Name] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Artefact_Desc] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Artefact_Type] [char] (10) NULL , " & _ "[Artefact_Bonus_How] [int] NULL , " & _ "[Artefact_Bonus_Type] [varchar] (10) COLLATE Latin1_General_CI_AS NULL , " & _ "[Artefact_Bonus_Who] [int] 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 %>