<%@ 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 m_conn Dim m_cmd dim m_sql as String = "INSERT INTO Pianeti (Data_Last_Access, Proprietary, Nome, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro, Dimensione, Reame, Paese, In_Costr_Eser, Cosa_Costr_Eser, Data_Costr_Eser, In_Costr_Infr, Cosa_Costr, Data_Costr_Infr, In_Costr_Res, Cosa_Costr_Res, Data_Costr_Res, C_Fattorie, C_TagliaLegna, C_Min_Ferro, C_Min_Pietra, C_Min_Zolfo, C_Min_Oro, C_Case, C_Poligono_Tiro, C_Scuderia, C_Centro_Villaggio, C_Laboratorio, C_Prigione, C_Torture, C_Tesoreria, C_Mercato, C_Taverna, C_Torrette, C_Mura, C_Caserma, P_Taglialegna, P_Min_Ferro, P_Min_Pietra, P_Min_Zolfo, P_Min_Oro, P_Fattorie, P_Cittadini, P_Prigionieri, R_Add_Cavalli, R_Filoni_Oro, R_Armi, R_Tempr_Ferro, R_Scudi, R_Gerarchia, R_Mura, R_Guardie, R_Torrette, R_Assedio, R_Esplorazione, E_Sold_Semp, E_Sold_Cavallo, E_Carovana, E_Arcieri_Corto, E_Arcieri_Lungo, E_Fanteria_Pesante, E_Balestrieri, E_Cavalleria_Pesante, E_Bombardieri, E_Cannone, E_Esploratore, E_Ladro, E_Generale, E_Carretto_Piccolo, E_Carretto_Grande, E_Petardo, E_Ballista, E_Catapulta, E_Ariete, E_Trabucco, PF_Mura, PF_Torrette, Tasse, Morale, G_Captured, Is_Principal, D_Sold_Semp, D_Sold_Cavallo, D_Carovana, D_Arcieri_Corto, D_Arcieri_Lungo, D_Fanteria_Pesante, D_Balestrieri, D_Cavalleria_Pesante, D_Bombardieri, D_Cannone, D_Esploratore, D_Ladro, D_Generale, D_Petardo, D_Ballista, D_Catapulta, D_Ariete, D_Trabucco, Ponte_Lev) VALUES (@Data_Last_Access, @Proprietary, @Nome, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro, @Dimensione, @Reame, @Paese, @In_Costr_Eser, @Cosa_Costr_Eser, @Data_Costr_Eser, @In_Costr_Infr, @Cosa_Costr, @Data_Costr_Infr, @In_Costr_Res, @Cosa_Costr_Res, @Data_Costr_Res, @C_Fattorie, @C_TagliaLegna, @C_Min_Ferro, @C_Min_Pietra, @C_Min_Zolfo, @C_Min_Oro, @C_Case, @C_Poligono_Tiro, @C_Scuderia, @C_Centro_Villaggio, @C_Laboratorio, @C_Prigione, @C_Torture, @C_Tesoreria, @C_Mercato, @C_Taverna, @C_Torrette, @C_Mura, @C_Caserma, @P_Taglialegna, @P_Min_Ferro, @P_Min_Pietra, @P_Min_Zolfo, @P_Min_Oro, @P_Fattorie, @P_Cittadini, @P_Prigionieri, @R_Add_Cavalli, @R_Filoni_Oro, @R_Armi, @R_Tempr_Ferro, @R_Scudi, @R_Gerarchia, @R_Mura, @R_Guardie, @R_Torrette, @R_Assedio, @R_Esplorazione, @E_Sold_Semp, @E_Sold_Cavallo, @E_Carovana, @E_Arcieri_Corto, @E_Arcieri_Lungo, @E_Fanteria_Pesante, @E_Balestrieri, @E_Cavalleria_Pesante, @E_Bombardieri, @E_Cannone, @E_Esploratore, @E_Ladro, @E_Generale, @E_Carretto_Piccolo, @E_Carretto_Grande, @E_Petardo, @E_Ballista, @E_Catapulta, @E_Ariete, @E_Trabucco, @PF_Mura, @PF_Torrette, @Tasse, @Morale, @G_Captured, @Is_Principal, @D_Sold_Semp, @D_Sold_Cavallo, @D_Carovana, @D_Arcieri_Corto, @D_Arcieri_Lungo, @D_Fanteria_Pesante, @D_Balestrieri, @D_Cavalleria_Pesante, @D_Bombardieri, @D_Cannone, @D_Esploratore, @D_Ladro, @D_Generale, @D_Petardo, @D_Ballista, @D_Catapulta, @D_Ariete, @D_Trabucco, @Ponte_Lev)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Data_Last_Access", sqldbtype.datetime).Value = DateTime.Now m_cmd.Parameters.Add("@Proprietary", sqldbtype.varchar).Value = "ciccio2" m_cmd.Parameters.Add("@Nome", sqldbtype.varchar).Value = "Nome_Paese" m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = 5000 m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = 3500 m_cmd.Parameters.Add("@Ris_Ferro", sqldbtype.int).Value = 2000 m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Dimensione", sqldbtype.int).Value = 20 m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = 20 m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@In_Costr_Eser", sqldbtype.char).Value = "No" m_cmd.Parameters.Add("@Cosa_Costr_Eser", sqldbtype.varchar).Value = "" m_cmd.Parameters.Add("@Data_Costr_Eser", sqldbtype.datetime).Value = DateTime.Now m_cmd.Parameters.Add("@In_Costr_Infr", sqldbtype.char).Value = "No" m_cmd.Parameters.Add("@Cosa_Costr", sqldbtype.varchar).Value = "" m_cmd.Parameters.Add("@Data_Costr_Infr", sqldbtype.datetime).Value = DateTime.Now m_cmd.Parameters.Add("@In_Costr_Res", sqldbtype.char).Value = "No" m_cmd.Parameters.Add("@Cosa_Costr_Res", sqldbtype.varchar).Value = "" m_cmd.Parameters.Add("@Data_Costr_Res", sqldbtype.datetime).Value = DateTime.Now m_cmd.Parameters.Add("@C_Fattorie", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@C_TagliaLegna", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@C_Min_Ferro", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@C_Min_Pietra", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@C_Min_Zolfo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Min_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Case", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@C_Poligono_Tiro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Scuderia", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Centro_Villaggio", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@C_Laboratorio", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Prigione", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Torture", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Tesoreria", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Mercato", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Taverna", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Torrette", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Mura", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@C_Caserma", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@P_Taglialegna", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@P_Min_Ferro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@P_Min_Pietra", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@P_Min_Zolfo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@P_Min_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@P_Fattorie", sqldbtype.int).Value = 10 m_cmd.Parameters.Add("@P_Cittadini", sqldbtype.int).Value = 100 m_cmd.Parameters.Add("@P_Prigionieri", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Add_Cavalli", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Filoni_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Armi", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Tempr_Ferro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Scudi", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Gerarchia", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Mura", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Guardie", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Torrette", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Assedio", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@R_Esplorazione", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Sold_Semp", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@E_Sold_Cavallo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Carovana", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Arcieri_Corto", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Arcieri_Lungo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Fanteria_Pesante", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Balestrieri", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Cavalleria_Pesante", sqldbtype.int).Value =0 m_cmd.Parameters.Add("@E_Bombardieri", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Cannone", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Esploratore", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Ladro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Generale", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@E_Carretto_Piccolo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Carretto_Grande", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Petardo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Ballista", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Catapulta", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Ariete", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@E_Trabucco", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@PF_Mura", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@PF_Torrette", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Tasse", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Morale", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@G_Captured", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Is_Principal", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@D_Sold_Semp", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Sold_Cavallo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Carovana", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Arcieri_Corto", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Arcieri_Lungo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Fanteria_Pesante", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Balestrieri", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Cavalleria_Pesante", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Bombardieri", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Cannone", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Esploratore", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Ladro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Generale", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Petardo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Ballista", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Catapulta", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Ariete", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@D_Trabucco", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ponte_Lev", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Generali (Dimensione, Reame, Paese, Is_Dead, Nome, Scheda, Proprietary, Livello, Exp) VALUES (@Dimensione, @Reame, @Paese, @Is_Dead, @Nome, @Scheda, @Proprietary, @Livello, @Exp)" 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 = 20 m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = 20 m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Is_Dead", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Nome", sqldbtype.varchar).Value = "Nome_Generale" m_cmd.Parameters.Add("@Scheda", sqldbtype.varchar).Value = "" m_cmd.Parameters.Add("@Proprietary", sqldbtype.varchar).Value = "ciccio2" m_cmd.Parameters.Add("@Livello", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Exp", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close %>