<%@ 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 ("
Classe: "& r("Class") &"") Response.Write ("
Livello: "& r("Level") &"") Response.Write ("
") Response.Write ("
Str Base: "& r("S_STR") &"") Response.Write ("
Dex Base: "& r("S_DEX") &"") Response.Write ("
Int Base: "& r("S_INT") &"") Response.Write ("
") If r("Level_Points") > 0 Then Response.Write ("

Hai "& r("Level_Points") &" Level Points da distribuire. Quale caratteristica vuoi aumentare?
") Response.Write ("



Str") Response.Write ("

Dex") Response.Write ("

Int") End If Response.Write ("

") End While r.Close() sqlConn.Close() End If %>