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