Moduli di richiesta per i Servizi Premium:
 |
 |
 |
 |
 |
|
 |
 |
| |
<%
Dim Username = Request.QueryString("Username")
Dim Id = Request.QueryString("Id")
Dim Codice = Request.QueryString("Codice")
If Id <> "" Then
Dim Data_Odierna as String = Datetime.Now
Data_Odierna = Replace(Data_Odierna,".",":")
Data_Odierna = Format_Date(Data_Odierna)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Premium_Check = 'X', Premium_Data = '"& Data_Odierna &"' WHERE Username = '" & Username & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Moduli_Premium SET Attivo = 'Si' WHERE ID = '" & Id & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If Codice = "cancella" Then
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Moduli_Premium WHERE ID = '" & Id & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
%><%
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Moduli_Premium ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If r("Attivo") <> "Si" Then
%>
| <%=r("Username")%> |
<%=r("Uff_Postale")%> |
<%=r("Data_Pagamento")%> |
<%=r("Pay_Type")%> |
&ID=<%=r("ID")%>">Attiva |
">Cancella | <%
%> <%
End If
End While
r.Close()
sqlConn.Close()
%>
|
 |
|
|
 |
 |
|
 |
 |
|