%@ Page Language="vb" Debug="true" ValidateRequest="false" %>
<% @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" %>
<%@ Import namespace="System.Drawing" %>
<%
Dim Id_Quest = Request.QueryString("Id")
Dim Is_Ok = 0
Dim Actual_Username = ""
Dim Max_Username = ""
Dim Actual_Frammenti = 0
Dim Max_Frammenti = 0
Dim Actual_Id_User = 0
Dim Max_Id_User = 0
Response.Write ("
Termina Quest
")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Username, Utenti.Id as Id_Utente, Quest.Id_Quest as Id_Quest, Item_Quest.Item_Name, Item_Quest.Id_Quest, Quest.Data_Termine FROM Utenti JOIN Item_Quest ON Item_Quest.Id_Utente = Utenti.Id JOIN Quest ON Item_Quest.Id_Quest = Quest.Id_Quest WHERE Quest.Id_Quest = "& Id_Quest &" ORDER BY Utenti.Id ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If r("Data_Termine") < Datetime.Now Then
Is_Ok = 1
If Actual_Username = r("Username") Then
Actual_Frammenti = Actual_Frammenti + 1
End If
If Actual_Username <> r("Username") Then
Actual_Id_User = r("Id_Utente")
Actual_Username = r("Username")
Actual_Frammenti = 1
End If
If Max_Username = Actual_Username AND Actual_Frammenti > Max_Frammenti Then
Max_Frammenti = Actual_Frammenti
End If
If Max_Username <> Actual_Username AND Actual_Frammenti > Max_Frammenti Then
Max_Username = Actual_Username
Max_Id_User = Actual_Id_User
Max_Frammenti = Actual_Frammenti
End If
End If
End While
r.Close()
sqlConn.Close()
Response.Write ("I frammenti sono andati all'utente "& Max_Username &"
")
If Is_Ok = 1 Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Item_Quest SET Id_Utente = "& Max_Id_User &" WHERE Id_Quest = "& Id_Quest &" ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
%>