<%@ 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" %>

Chi c'è qui?

<% Dim Page = Request.Querystring ("Page") Page = Page*10 Dim Pagine = 0 Dim counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT COUNT(*) as Quanti FROM Soldiers JOIN Utenti ON Utenti.Id = Soldiers.Id_Utente JOIN Soldiers as Soldiers_Io ON Soldiers_Io.Id = '"& Id_This_Soldier &"' WHERE Utenti.Username <> '"& Username &"' AND Soldiers.Pf_Now > 0 AND Soldiers.Position = Soldiers_Io.Position ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() pagine = (r("Quanti")) End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 10 Utenti.Username, Utenti.Gilda, Soldiers.Name, Soldiers.Sex, Soldiers.Class, Soldiers.Level, Soldiers.Exp, Soldiers.S_STR, Soldiers.S_DEX, Soldiers.S_INT, Soldiers.Id as Id_Soldier FROM Soldiers JOIN Utenti ON Utenti.Id = Soldiers.Id_Utente JOIN Soldiers as Soldiers_Io ON Soldiers_Io.Id = '"& Id_This_Soldier &"' WHERE Utenti.Username <> '"& Username &"' AND Soldiers.Pf_Now > 0 AND Soldiers.Position = Soldiers_Io.Position AND Soldiers.ID NOT IN (SELECT TOP "& Page &" Soldiers.ID FROM Soldiers JOIN Utenti ON Utenti.Id = Soldiers.Id_Utente JOIN Soldiers as Soldiers_Io ON Soldiers_Io.Id = '"& Id_This_Soldier &"' WHERE Utenti.Username <> '"& Username &"' AND Soldiers.Pf_Now > 0 AND Soldiers.Position = Soldiers_Io.Position ORDER BY Soldiers.Id) ORDER BY Soldiers.Id ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("") Response.Write ("") Response.Write ("

") Response.Write ("

") Response.Write ("

Nome: "& r("Name") &"") Response.Write ("
Utente: "& r("Username") &"") If Trim(r("Gilda")) <> "" Then Response.Write (" ["& Trim(r("Gilda")) &"]") End If If r("Sex") = "m" Then Response.Write ("
Sesso: Maschio") End If If r("Sex") = "f" Then Response.Write ("
Sesso: Femmina") End If Response.Write ("
Classe: "& r("Class") &"") Response.Write ("
Livello: "& r("Level") &"") Response.Write ("
") Response.Write ("
") Response.Write ("

Attacca") Response.Write ("
") End While r.Close() sqlConn.Close() Dim x Response.Write ("
") If (Page/10) > 2 Then Response.Write ("...") End If For x = 0 to Pagine/10 If x > (Page/10 - 3) AND x < (Page/10 + 3) Then Response.Write ("") If x = (Page/10) Then Response.Write ("[") End If Response.Write (x+1) If x = (Page/10) Then Response.Write ("]") End If Response.Write ("") End If Next If (Page/10) < (Pagine/10)-3 Then Response.Write ("...") End If Response.Write ("
") %>