%@ 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" %>
Distribuzione Punti |
|
<%
Dim Id_Soldier = Request.QueryString("Id_This_Soldier")
Dim Charact = Request.QueryString("char")
Dim Nome_Soldato
Dim Level_Points = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Level_Points, Name FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Utenti.Username = '"& Username &"' AND Soldiers.Id = '"& Id_Soldier &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Nome_Soldato = r("Name")
Level_Points = r("Level_Points")
End While
r.Close()
sqlConn.Close()
If Level_Points < 1 Then
Response.Write ("Non hai punti da distribuire per questo soldato!!!")
End If
If Level_Points > 0 Then
If Charact <> "" Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Soldiers SET S_"& Charact &" = S_"& Charact &" + 1, Level_Points = Level_Points - 1, PF_Now = PF_Now + 10, PF_Max = PF_Max + 10 WHERE Soldiers.Id = '"& Id_Soldier &"' ",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 = "Chars"
m_cmd.Parameters.Add("@Data_Messaggio", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Hai speso un Level Point per aumentare la caratteristica '"& Charact &"' del soldato "& Nome_Soldato &"."
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Response.Redirect ("soldiers.aspx?Id_This_Soldier="& Id_This_Soldier &"")
End If
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Name, Sex, Class, Level, Exp, Level_Points, S_STR, S_DEX, S_INT, Soldiers.Id as Id_Soldier FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Utenti.Username = '"& Username &"' AND Soldiers.Id = '"& Id_Soldier &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Response.Write (" ")
Response.Write ("Soldato: "& r("Name") &"")
Response.Write ("
|