<%@ 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" %> <% If Username = "los" Then Dim Codice = Request.Querystring ("Codice") Dim Who = Request.Querystring ("Who") Dim Page = Request.Querystring ("Page") Dim Id_Soldier = Request.Form ("Id_Soldier") Dim Id_User = Request.Form ("Id_User") Dim Pagine = 0 Dim counter = 0 response.write (Id_Soldier) 'response.end If Codice = "" Then sqlConn.Open() sqlComm = New SqlCommand("SELECT Name, Class, Sex, Id_Utente, Soldiers.Id, S_Str, S_Dex, S_Int, Level, Exp FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Utenti.Username = '"& Request.QueryString("Username") &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("

"& r("Name") &"

Str

Dex

Int

") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("

Level

Exp

") Response.Write ("





") Response.Write ("") End While r.Close() sqlConn.Close() End If If Id_Soldier <> "" Then Dim Str = Request.Form("Txt_Str") Dim Dex = Request.Form("Txt_Dex") Dim Int = Request.Form("Txt_Int") Dim Level = Request.Form("Txt_Level") Dim Exp = Request.Form("Txt_Exp") Dim Classx = Request.Form("Txt_Class") Dim Sex = Request.Form("Txt_Sex") sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Class = '"& Classx &"', Sex = '"& Sex &"', S_Str = '"& Str &"', S_Dex = '"& Dex &"', S_Int = '"& Int &"', Level = '"& Level &"', Exp = '"& Exp &"' WHERE Id = '"& Id_Soldier &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() Response.Redirect ("admin.aspx?Codice="& Id_User &"") End If End If %>