<%@ 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=62.149.153.12; initial catalog=MSSql11819;uid=MSSql11819;pwd=72a256bf") 'Dim strConn = ("server=PIETREPP-626F41;uid=los;pwd=los;database=los") 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 Soldiers " ,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 Inventario " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Guilds_Requests " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Guilds " ,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("Create Table Soldiers( " & _ "[Id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Utente] [int] NULL , " & _ "[Name] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Sex] [char] (1) COLLATE Latin1_General_CI_AS NULL , " & _ "[Class] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Exp] [int] NULL , " & _ "[Level] [int] NULL , " & _ "[PF_Max] [int] NULL , " & _ "[PF_Now] [int] NULL , " & _ "[S_STR] [int] NULL , " & _ "[S_DEX] [int] NULL , " & _ "[S_INT] [int] NULL , " & _ "[Right_Arm] [int] NULL , " & _ "[Left_Arm] [int] NULL , " & _ "[Armor] [int] NULL , " & _ "[Magic_Item] [int] NULL , " & _ "[Position] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Last_Move] [datetime] NULL , " & _ "[Data_Last_Atk] [datetime] NULL , " & _ "[Last_Attacked] [datetime] NULL , " & _ "[Level_Points] [int] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Utenti( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Icq_Uin] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , " & _ "[Msn] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Gilda] [char] (3) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_Gilda] [smallint] NULL , " & _ "[username] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[password] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[attivo] [char] (2) COLLATE Latin1_General_CI_AS NULL , " & _ "[Email] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Accetta_Termini] [char] (7) COLLATE Latin1_General_CI_AS NULL , " & _ "[Money] [int] NULL , " & _ "[Registration_Data] [datetime] NULL , " & _ "[Last_Id] [int] NULL , " & _ "[pass] [binary] (500) NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Inventario( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Utente] [int] NULL , " & _ "[Id_Item] [int] NULL , " & _ "[Quantity] [int] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Guilds_Requests( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Gilda] [int] NULL , " & _ "[Id_Utente] [int] NULL , " & _ "[Data_Richiesta] [datetime] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Guilds( " & _ "[Id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Tag] [char] (3) COLLATE Latin1_General_CI_AS NULL , " & _ "[Name] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Background] [varchar] (5000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_1] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_2] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_3] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_4] [varchar] (20) COLLATE Latin1_General_CI_AS NULL , " & _ "[Grado_5] [varchar] (20) COLLATE Latin1_General_CI_AS 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 , " & _ "[Type_Message] [varchar] (10) COLLATE Latin1_General_CI_AS NULL , " & _ "[Messaggio] [varchar] (5000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Data_Messaggio] [datetime] NULL " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>