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

<% Dim Username = Request.Form("User1") Dim Mesi = Request.Form("User2") If Username = "" OR Mesi = "" Then Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("
Username:
Mesi:
") 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 %>