%@ 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 Check_Spendi = Request.QueryString("points_code")
Dim There_Is_Punti = 0
If Check_Spendi <> "" Then
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Punti FROM Utenti WHERE Username = '"& Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If Not r("Punti") < 100 Then
There_Is_Punti = 1
End If
End While
r.Close()
sqlConn.Close()
If There_Is_Punti = 0 Then
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",800) &""
End If
If There_Is_Punti = 1 Then
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Utenti SET Punti = Punti - 100 WHERE Username = '"& Proprietary &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If Check_Spendi = "ris_1" AND There_Is_Punti = 1 Then
Ris_Legna = Ris_Legna + 10000
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Pianeti SET Ris_Legna = Ris_Legna + 10000 WHERE ID = '"& Id_Paese &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",801) &""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_Utente
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Premium"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
End If
If Check_Spendi = "ris_2" AND There_Is_Punti = 1 Then
Ris_Pietra = Ris_Pietra + 10000
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Pianeti SET Ris_Pietra = Ris_Pietra + 10000 WHERE ID = '"& Id_Paese &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",802) &""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_Utente
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Premium"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
End If
If Check_Spendi = "ris_3" AND There_Is_Punti = 1 Then
Ris_Mana = Ris_Mana + 10000
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Pianeti SET Ris_Mana = Ris_Mana + 10000 WHERE ID = '"& Id_Paese &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",803) &""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_Utente
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Premium"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
End If
If Check_Spendi = "ris_4" AND There_Is_Punti = 1 Then
Ris_Oro = Ris_Oro + 10000
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Pianeti SET Ris_Oro = Ris_Oro + 10000 WHERE ID = '"& Id_Paese &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",804) &""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_Utente
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Premium"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
End If
End If
%>
<%=Read_File("inc\Lang\Languages.aspx",19)%>
<%
Dim Fama_Tua = 0
Dim Punti = 0
Response.Write (""& Read_File("inc\Lang\Languages.aspx",657) &"
")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Background, Icq_Uin, Msn, ID, Fama, Punti FROM Utenti WHERE Username = '" + Proprietary + "' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Fama_Tua = r("Fama")
Punti = r("Punti")
Txt_Background_Impero.Text = Replace(r("Background"),"
",VbCrLf)
Txt_Icq_Uin.Text = r("Icq_Uin")
Txt_Msn.Text = r("Msn")
Txt_Background_Impero.CssClass = "textbox"
%>
<%=Read_File("inc\Lang\Languages.aspx",659)%>
<%=Read_File("inc\Lang\Languages.aspx",660)%>
<%=Read_File("inc\Lang\Languages.aspx",661)%> <%=Read_File("inc\Lang\Languages.aspx",662)%> <%=Read_File("inc\Lang\Languages.aspx",663)%>
<%
Btn_Cambia_Icq.Text = Read_File("inc\Lang\Languages.aspx",665)
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",664) &"
")
Response.Write ("
| "& Read_File("inc\Lang\Languages.aspx",664) &": ") %> | |
"& Read_File("inc\Lang\Languages.aspx",666) &"
")
Response.Write ("
| "& Read_File("inc\Lang\Languages.aspx",666) &": ") %> | |
"& Read_File("inc\Lang\Languages.aspx",805) &"
")
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",806) &"
")
%>
Forum Code:
"& Read_File("inc\Lang\Languages.aspx",807) &"
"& Punti &"
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",808) &"")
Response.Write ("
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",809) &"")
Response.Write ("
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",810) &"")
Response.Write ("
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",811) &"")
Response.Write ("
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",28) &"
")
Dim Errore_Premium = ""
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Premium_Data FROM Utenti WHERE Username = '"& Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If r("Premium_Data") < Datetime.Now Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",833) &"")
Else
Response.Write (""& Read_File("inc\Lang\Languages.aspx",834) &""& - (DateDiff("d",r("Premium_Data"),Datetime.Now)) + 1 &"")
End If
End While
r.Close()
sqlConn.Close()
%>