<%@ 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 Page = Request.QueryString ("Page") If Page = "Vendi" Then Dim Id_Item = Request.QueryString("Item_Id") Dim Item_Cost = 0 Dim There_Is = 0 Dim Quantity = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Cost, Quantity FROM Items JOIN Inventario ON Inventario.Id_Item = '"& Id_Item &"' AND Inventario.Id_Utente = '"& Id_This_User &"' WHERE Items.Id = '"& Id_Item &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() There_Is = 1 Quantity = r("Quantity") Item_Cost = r("Cost") End While r.Close() sqlConn.Close() Dim Errore = 0 If There_Is = 0 OR Quantity < 1 Then Response.Write ("



Non hai questo oggetto!") Errore = 1 End If If Errore = 0 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Money = Money + "& Item_Cost/2 &" WHERE Utenti.Id = '"& Id_This_User &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Response.Redirect ("inventario.aspx") End If End If If Page = "Indossa" Then Dim Id_Item = Request.QueryString("Item_Id") Dim Id_Soldier = Request.QueryString("Sold_Id") Dim Tipo_Cambio = "" Dim Id_Arma_da_Togliere = "" Dim Id_Utente = "" Dim Inventario_Quantity = 0 Dim Item_Level = 0 Dim Soldier_Level = 0 Dim Type_Soldier = "" Dim Item_Soldier_Type = "" Dim Pf_Now Dim Pf_Max Dim Nome_Soldato Dim Errore = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Utenti.Id as Id_Utente, Soldiers.Name, Soldiers.Class, Soldiers.Pf_Now, Soldiers.Pf_Max, Soldiers.Level as Level_Soldier, Inventario.Quantity, Soldiers.Right_Arm, Soldiers.Left_Arm, Soldiers.Armor, Soldiers.Magic_Item, Items.Id, Items.Item_Name, Items.Item_Type, Items.Soldier_Type, Items.Level FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente JOIN Inventario ON Inventario.Id_Item = '"& Id_Item &"' AND Inventario.Id_Utente = Utenti.Id JOIN Items ON Items.Id = '"& Id_Item &"' WHERE Utenti.Username = '"& Username &"' AND Soldiers.Id = '"& Id_Soldier &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Pf_Now = r("Pf_Now") Pf_Max = r("Pf_Max") Nome_Soldato = r("Name") Type_Soldier = r("Class") Item_Soldier_Type = r("Soldier_Type") Item_Level = r("Level") Soldier_Level = r("Level_Soldier") Inventario_Quantity = r("Quantity") Id_Utente = r("Id_Utente") Tipo_Cambio = r("Item_Type") If Tipo_Cambio = "WEA" Then Id_Arma_da_Togliere = r("Right_Arm") End If If Tipo_Cambio = "SHI" Then Id_Arma_da_Togliere = r("Left_Arm") End If If Tipo_Cambio = "ARM" Then Id_Arma_da_Togliere = r("Armor") End If If Tipo_Cambio = "MAG" Then Id_Arma_da_Togliere = r("Magic_Item") End If End While r.Close() sqlConn.Close() If Tipo_Cambio = "WEA" OR Tipo_Cambio = "SHI" OR Tipo_Cambio = "ARM" OR Tipo_Cambio = "MAG" Then If Inventario_Quantity < 1 Then Response.Write ("



Non hai questo oggetto!") Errore = 1 End If If Type_Soldier <> Item_Soldier_Type AND Item_Soldier_Type <> "ALL" Then Response.Write ("



Questo soldato non può indossare questo oggetto perchè può essere indossato da una Classe diversa!") Errore = 1 End If If Soldier_Level < Item_Level Then Response.Write ("



Il soldato non è di livello abbastanza alto per poter indossare questo oggetto!") Errore = 1 End If If Errore = 0 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity + 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Arma_da_Togliere &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() If Tipo_Cambio = "WEA" Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Right_Arm = '"& Id_Item &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Tipo_Cambio = "SHI" Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Left_Arm = '"& Id_Item &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Tipo_Cambio = "ARM" Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Armor = '"& Id_Item &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Tipo_Cambio = "MAG" Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Magic_Item = '"& Id_Item &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If Response.Redirect ("soldiers.aspx?Id_This_Soldier="& Id_Soldier &"") End If End If If Tipo_Cambio = "OBJ" AND Inventario_Quantity < 1 Then Response.Write ("



Non hai questo oggetto!") Errore = 1 End If If Tipo_Cambio = "OBJ" AND Errore = 0 Then If Id_Item = 1 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Data_Last_Move = '10/10/2002 00:00:01', Data_Last_Atk = '10/10/2002 00:00:01' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item > 128 AND Id_Item < 136 AND Pf_Now < 1 Then Response.Write ("



Non puoi dar da mangiare a questo soldato perchè è morto, devi prima resuscitarlo!!!") End If If Pf_Now > 0 Then If Id_Item = 129 Then Pf_Now = Pf_Now + (Pf_Max/100*10) If Pf_Now > Pf_Max Then Pf_Now = Pf_Max End If sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item = 130 Then Pf_Now = Pf_Now + (Pf_Max/100*20) If Pf_Now > Pf_Max Then Pf_Now = Pf_Max End If sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item = 131 Then Pf_Now = Pf_Now + (Pf_Max/100*30) If Pf_Now > Pf_Max Then Pf_Now = Pf_Max End If sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item = 132 Then Pf_Now = Pf_Now + (Pf_Max/100*40) If Pf_Now > Pf_Max Then Pf_Now = Pf_Max End If sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item = 133 Then Pf_Now = Pf_Now + (Pf_Max/100*50) If Pf_Now > Pf_Max Then Pf_Now = Pf_Max End If sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item = 134 Then Pf_Now = Pf_Now + (Pf_Max/100*75) If Pf_Now > Pf_Max Then Pf_Now = Pf_Max End If sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Item = 135 Then Pf_Now = Pf_Max sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET PF_Now = '"& Pf_Now &"' WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If If Id_Item = 136 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET S_STR = S_STR + 1 WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() m_sql = "INSERT INTO Messaggi (Id_Utente, Type_Message, Messaggio, Data_Messaggio) VALUES (@Id_Utente, @Type_Message, @Messaggio, @Data_Messaggio)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Potions" m_cmd.Parameters.Add("@Data_Messaggio", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Hai usato una Pozione di Forza per aumentare di +1 la Forza del tuo Soldato "& Nome_Soldato &"." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If If Id_Item = 137 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET S_DEX = S_DEX + 1 WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() m_sql = "INSERT INTO Messaggi (Id_Utente, Type_Message, Messaggio, Data_Messaggio) VALUES (@Id_Utente, @Type_Message, @Messaggio, @Data_Messaggio)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Potions" m_cmd.Parameters.Add("@Data_Messaggio", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Hai usato una Pozione di Destrezza per aumentare di +1 la Destrezza del tuo Soldato "& Nome_Soldato &"." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If If Id_Item = 138 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET S_INT = S_INT + 1 WHERE Soldiers.Id = '"& Id_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity - 1 WHERE Inventario.Id_Utente = '"& Id_This_User &"' AND Inventario.Id_Item = '"& Id_Item &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() m_sql = "INSERT INTO Messaggi (Id_Utente, Type_Message, Messaggio, Data_Messaggio) VALUES (@Id_Utente, @Type_Message, @Messaggio, @Data_Messaggio)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Potions" m_cmd.Parameters.Add("@Data_Messaggio", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Hai usato una Pozione di Intelligenza per aumentare di +1 l'Intelligenza del tuo Soldato "& Nome_Soldato &"." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If End If End If Response.Write ("") Dim i Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") sqlConn.Open() sqlComm = New SqlCommand("SELECT Soldiers.Name as Name_Soldier, Item_Type, Items.Id, Items.Cost, Items.Item_Name, Items.Level, Items.Valore, Inventario.Quantity FROM Utenti JOIN Inventario ON Utenti.Id = Inventario.Id_Utente JOIN Items ON Inventario.Id_Item = Items.Id JOIN Soldiers ON Soldiers.Id = '"& Id_This_Soldier &"' WHERE Utenti.Username = '"& Username &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Quantity") <> 0 Then i = i + 1 Response.Write ("") Response.Write ("") Response.Write ("") End If End While r.Close() sqlConn.Close() Response.Write ("

NomeQt.Usa/IndossaVendi

"& r("Item_Name") &""& r("Quantity") &"") Response.Write (""& r("Name_Soldier") &"") Response.Write ("Vendi
") %>