%@ 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" %>
Controllo Attacchi
")
Response.Write ("
")
Response.Write ("
")
Else
Dim Data_Odierna as String = Datetime.Now
Data_Odierna = Replace(Data_Odierna,".",":")
Data_Odierna = Format_Date(Data_Odierna)
Dim Premium_Data
Dim There_Is = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Premium_Data FROM Utenti WHERE Username = '"& Username &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
There_Is = 1
Premium_Data = r("Premium_Data")
End While
r.Close()
sqlConn.Close()
If Premium_Data < Datetime.Now Then
Premium_Data = Datetime.Now
End If
Premium_Data = Format_Date(Premium_Data.AddDays(32*Mesi))
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Premium_Data = '"& Premium_Data &"' WHERE Username = '" & Username & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
If There_Is = 0 Then
Response.Write ("Utente "& Username &" non trovato!!!")
End If
If There_Is = 1 Then
Response.Write ("Aggiunti "& Mesi &" Mesi di Premium all'utente "& Username &"")
End If
End If
%>