<%@ 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 Items " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Items( " & _ "[ID] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Mercato] [char] (1) , " & _ "[Soldier_Type] [varchar] (20) , " & _ "[Item_Type] [char] (3) , " & _ "[Item_Name] [varchar] (40) , " & _ "[Cost] [int] , " & _ "[Valore] [int] , " & _ "[Level] [int] , " & _ "[Descrizione] [varchar] (100) , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim m_conn Dim m_cmd dim m_sql m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pozione di Stamina" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Permette di far effettuare un altro movimento e un altro attacco al vostro soldato." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Spada Corta in Ferro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Spada Lunga in Ferro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Morning Star" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mazzafrusto" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mazza Ferrata" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Ascia da Battaglia" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mazza Da Guerra" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mazzafrusto a Tre Teste" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Spaccaossa" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mazza dei Re" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Spada AmmazzaDraghi" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Spada Lunga degli Angeli" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mjolnir" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close 'ARMATURE GUERRIERO m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Maglie" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Piastre" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura Completa" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura Di Oro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura Corazzata" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura del Leone" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura Sacrilega" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura Poderosa" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Diamante" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pietra Rossa" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pietra Nera" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Mithril" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di San Giorgio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close 'SCUDI GUERRIERO m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di Rotondo di Legno" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di Rotondo di Ferro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo a Tre Punte" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo a Goccia" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo Torre" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo del Leone" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo del Sacrificio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo del Falco" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di Diamante" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di Pietra Rossa" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di Pietra Nera" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di Mithril" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Warrior" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scudo di San Giorgio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close 'ARMI ARCIERE m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Corto" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Lungo" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Composito" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Balestra" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pugnale" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Elfico" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Splendente" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Balestra Pesante" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pugnale Avvelenato" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Di Avorio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Balestra Nera" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pugnale Assassino" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Arco Divino" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle di Cinghiale" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle di Orso" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Cuoio Borchiato" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Cuoio Rinforzato" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Ossa" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle di Rettile" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle di Basilisco" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle di Drago" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura Leggera Elfica" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Ossa di Drago" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Ossa di Demone" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Armatura di Pelle Demoniaca" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Buckler di Legno" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Buckler Rinforzato" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Buckler di Ferro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle Borchiata" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Scaglie" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle di Rettile" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle di Basilisco" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle di Drago" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti Elfici" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle di Drago Antico" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle di Demone Giovane" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Archer" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Guanti di Pelle Demoniaca" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close 'ARMI MAGO m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bastone di Legno" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bastone Bianco" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bacchetta Magica" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bacchetta di Ghiaccio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bacchetta di Fuoco" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bastone del Gelo" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bastone delle Fiamme" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bacchetta delle Fiamme Oscure" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bacchetta dei Necromanti" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro degli Incantesimi" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro di Magia Nera" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro di Magia Demoniaca" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Necronomicon" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "WEA" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Veste da Mago" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Veste di Protezione" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Veste Rinforzata" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Veste Magica" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Veste dell Assorbimento" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Tunica dell Adepto" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Tunica dell Anziano" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Tunica del Maestro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Tunica del Saggio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Abito del Vento" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Abito del Ghiaccio" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Abito della Fiamma" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Abito della Magnificenza" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "ARM" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scroll della Protezione dell Aria" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scroll della Protezione della Terra" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scroll della Protezione dell Acqua" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scroll della Protezione del Fuoco" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2750 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Scroll della Protezione Degli Elementi" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro della Protezione Minima" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 6250 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro della Protezione Minore" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 9500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 7 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro della Protezione Maggiore" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 22 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Libro della Protezione Massima" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 9 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 25 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Incantesimo della Difesa del Turbine" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 22500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Incantesimo della Difesa del Gelo" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 30000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 13 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Incantesimo della Difesa delle Fiamme" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "Mage" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Incantesimo di Armatura Magica" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "SHI" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 100000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 30 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 60 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "0" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close 'ITEMS MAGICI m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Anello Magico" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Anello Mistico" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 2 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bracciale dell Intelligenza" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 4000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bracciale della Concentrazione" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 8000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 4 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bandana della Mente" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 12500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 20 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Bandana della Mente Superiore" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 18000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 6 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 27 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Collana della Telepatia" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 25000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 8 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 35 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Collana della Telecinesi" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 32000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 10 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 40 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mantello dello Spirito" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 40000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 12 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 45 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Mantello Sacro" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "MAG" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 45000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 50 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close 'CIBI E POZIONI m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pane" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 500 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato del 10% dei suoi PF Totali." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Carne" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 800 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato del 20% dei suoi PF Totali." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pesce" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1100 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato del 30% dei suoi PF Totali." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Aragosta" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1400 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato del 40% dei suoi PF Totali." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Birra" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 1600 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato del 50% dei suoi PF Totali." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Vino" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 2300 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato del 75% dei suoi PF Totali." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Carne di Drago" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 3000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Cura il vostro soldato completamente." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pozione di Forza" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 15000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Aumenta di +1 la Forza del vostro Soldato permanentemente." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pozione di Destrezza" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 15000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Aumenta di +1 la Destrezza del vostro Soldato permanentemente." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Items (Mercato, Soldier_Type, Item_Name, Item_Type, Cost, Valore, Level, Descrizione) VALUES (@Mercato, @Soldier_Type, @Item_Name, @Item_Type, @Cost, @Valore, @Level, @Descrizione)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Soldier_Type", sqldbtype.varchar).Value = "ALL" m_cmd.Parameters.Add("@Item_Name", sqldbtype.varchar).Value = "Pozione di Intelligenza" m_cmd.Parameters.Add("@Item_Type", sqldbtype.char).Value = "OBJ" m_cmd.Parameters.Add("@Cost", sqldbtype.int).Value = 15000 m_cmd.Parameters.Add("@Valore", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Mercato", sqldbtype.char).Value = "1" m_cmd.Parameters.Add("@Descrizione", sqldbtype.varchar).Value = "Aumenta di +1 l Intelligenza del vostro Soldato permanentemente." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close %>