<%@ 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" %> <% Dim Codice = Request.QueryString("Codice") Dim Id_Quest = Request.QueryString("Id_Quest") Dim Id_Utente = Request.QueryString("Id_Utente") If Codice = "Ridistribuisci" Then Dim Data_Meno_Quindici = Format_Date(Datetime.Now.AddDays(-15)) Dim Data_Adesso_XXX = Format_Date(Datetime.Now) Dim User_Id = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 1 Utenti.ID, Utenti.Username, Utenti.Premium_Data FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Attivo = 'Si' AND Utenti.Ban = 0 AND Utenti.Vacanza = 0 AND Pianeti.Is_Principal = 1 AND Pianeti.Data_Last_Access > '"& Data_Meno_Quindici &"' AND Not Utenti.Premium_Data < '"& Data_Adesso_XXX &"' ORDER BY NEWID() ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() User_Id = r("Id") Response.Write ("Dato a: "& r("Username") &"

") End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Item_Quest SET Id_Utente = "& User_Id &" WHERE Id_Utente = "& Id_Utente &" AND Id_Quest = "& Id_Quest &" ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() response.write (Id_Utente) Response.Write ("
") response.write (Id_Quest) Response.Write ("
") response.write (User_Id) End If %>
<% sqlConn.Open() sqlComm = New SqlCommand("SELECT Username, Utenti.Id as Id_Utente, Item_Name, Id_Quest FROM Utenti JOIN Item_Quest ON Item_Quest.Id_Utente = Utenti.Id ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write (r("Username") &" - "& r("Item_Name") &" Ridistribuisci") Response.Write ("

") End While r.Close() sqlConn.Close() %>