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

Classifica

<% Dim Page = Request.Querystring ("Page") Page = Page*10 Dim Pagine = 0 Dim counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT COUNT(*) as Quanti FROM Utenti JOIN SOldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Soldiers.Class <> '' AND Utenti.Username <> 'Npc' ", 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.Id, Soldiers.Id as Id_Soldato, Utenti.Username, Soldiers.Name, Soldiers.Sex, Soldiers.Class, Soldiers.Level FROM Utenti JOIN SOldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Soldiers.Class <> '' AND Utenti.Username <> 'Npc' AND Soldiers.ID NOT IN (SELECT TOP "& Page &" ID FROM Soldiers WHERE Soldiers.Class <> '' AND Utenti.Username <> 'Npcx' ORDER BY Level DESC, Exp DESC) ORDER BY Level DESC, Exp DESC ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() COUNTER = COUNTER + 1 Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("

"& Page + counter &"°

") Response.Write ("




") Response.Write ("

Nome: "& r("Name") &"") Response.Write ("
Utente: "& r("Username") &"") If UCASE(r("Sex")) = "M" Then Response.Write ("
Sesso: Maschio") End If If UCASE(r("Sex")) = "F" Then Response.Write ("
Sesso: Femmina") End If Response.Write ("
Classe: "& r("Class") &"") Response.Write ("
Livello: "& r("Level") &"") Response.Write ("
") 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 ("
") %>