%@ 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 ("
| Nome | Qt. | Usa/Indossa | Vendi | |
| "& r("Item_Name") &" | "& r("Quantity") &" | ") Response.Write (""& r("Name_Soldier") &"") Response.Write (" | Vendi |