%@ 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" %>
<%
Response.Write("
"& Read_File("inc\Lang\Languages.aspx",22) &"
")
Dim Box_Hidden = 0
Dim Is_Administrator
Dim Codice = DeCripta(Request.QueryString("Codice"))
Dim Utente = DeCripta(Request.QueryString("User"))
Dim Confirm = DeCripta(Request.QueryString("Confirm"))
Dim Gilda = DeCripta(Request.QueryString("Gilda"))
Dim Id_Mex = DeCripta(Request.QueryString("Id_Mex"))
If Codice = "add_gilda" AND Confirm <> "si" Then
Dim Is_Utente_Da_Gildare
Dim Id_Administrator
Dim Tag_Gilda
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Gilda, Id FROM Utenti WHERE Username = '" & Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Tag_Gilda = r("Gilda")
Id_Administrator = r("ID")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Id FROM Utenti WHERE ID = '" & Utente &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Is_Utente_Da_Gildare = r("ID")
End While
r.Close()
sqlConn.Close()
Dim Add_Gilda = "Add_Gilda"
Dim Si = "Si"
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",516) &" "& Tag_Gilda &" "& Read_File("inc\Lang\Languages.aspx",517) &" " + Proprietary + ". "& Read_File("inc\Lang\Languages.aspx",518) &"
"& Read_File("inc\Lang\Languages.aspx",519) &""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Is_Utente_Da_Gildare
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Gilda"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",520) &"")
Box_Hidden = 1
End If
If Codice = "add_gilda" AND Confirm = "si" Then
Dim Is_Utente_Da_Gildare
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Username = '" & Utente &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Is_Utente_Da_Gildare = r("ID")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Gilda = '"& Gilda &"' , Grado_Gilda = 5 WHERE ID = '" & Utente &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE Messaggio LIKE '"& Read_File("inc\Lang\Languages.aspx",521) &"%' AND Id_Utente = '" & Utente &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",522) &" "& Gilda &".")
Box_Hidden = 1
End If
If Codice = "aggiungi_lista_amici" Then
Dim Id_Proprietary
sqlConn.Open()
Dim sqlComm As New SqlCommand("SELECT ID FROM Utenti WHERE Username = '" + Proprietary + "' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Proprietary = r("ID")
End While
r.Close()
sqlConn.Close()
Dim Is_Amico_Exist = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Id_Utente FROM Lista_Amici WHERE Id_Utente = '"& Id_Proprietary &"' AND Id_Amico = '"& Utente &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Is_Amico_Exist = 1
End While
r.Close()
sqlConn.Close()
If Is_Amico_Exist = 0
Dim m_conn
Dim m_cmd
dim m_sql as String = "INSERT INTO Lista_Amici (Id_Utente, Id_Amico, Note) VALUES (@Id_Utente, @Id_Amico, @Note)"
Try
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_Proprietary
m_cmd.Parameters.Add("@Id_Amico", sqldbtype.int).Value = Utente
m_cmd.Parameters.Add("@Note", sqldbtype.varchar).Value = ""
m_conn.Open
m_cmd.ExecuteNonQuery
Finally
m_conn.Close
End Try
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",523) &"")
End If
If Is_Amico_Exist = 1
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",524) &"")
End If
Box_Hidden = 1
End If
If Codice = "cerca" Then
Dim Page = Request.QueryString("Page")
Dim Who = Request.QueryString("Who")
response.write (Who)
If Page = "" Then
Page = 0
End If
Dim Last_Id
Dim Last_Id_Page
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Username LIKE '%" & Who & "%' AND Attivo = 'Si' ORDER BY FAMA DESC, Utenti.ID", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Last_Id = r("ID")
End While
r.Close()
sqlConn.Close()
Dim Tua_Gilda = ""
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Gilda, Grado_Gilda FROM Utenti WHERE Username = '" & Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Is_Administrator = r("Grado_Gilda")
Tua_Gilda = Trim(r("Gilda"))
End While
r.Close()
sqlConn.Close()
Lista_Utenti.Text = ""& Read_File("inc\Lang\Languages.aspx",436) &" "& Read_File("inc\Lang\Languages.aspx",525) &" "& Read_File("inc\Lang\Languages.aspx",526) &" "
Dim Distance = 0
Dim Counter = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT TOP 50 Utenti.ID, Utenti.Race, Gilda, Pianeti.Nome, Dimensione, Reame, Paese, Username, Fama FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary AND Pianeti.Is_Principal = 1 WHERE Username LIKE '%" & Who & "%' AND Attivo = 'Si' AND Utenti.ID NOT IN (SELECT TOP "& Page &" ID FROM Utenti WHERE Username LIKE '%" & Who & "%' AND Attivo = 'Si' ORDER BY FAMA DESC, ID) ORDER BY FAMA DESC, Utenti.ID", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Dim Razza = ""
If Trim(r("Race")) = "Human" Then
Razza = Read_File("inc\Lang\Languages.aspx",792)
Else If Trim(r("Race")) = "Elf" Then
Razza = Read_File("inc\Lang\Languages.aspx",793)
Else If Trim(r("Race")) = "Orc" Then
Razza = Read_File("inc\Lang\Languages.aspx",794)
Else If Trim(r("Race")) = "Undead" Then
Razza = Read_File("inc\Lang\Languages.aspx",795)
End If
Counter = Counter + 1
Response.Write ("")
Distance = Distance + (Ever_Positive(r("Dimensione") - Dimensione) * 100)
Distance = Distance + (Ever_Positive(r("Reame") - Reame) * 10)
Distance = Distance + Ever_Positive(r("Paese") - Paese)
Distance = CInt(Distance/50)
Dim Add_Gilda = "Add_Gilda"
Lista_Utenti.Text = Lista_Utenti.Text & " "
Last_Id_Page = r("Id")
End While
r.Close()
sqlConn.Close()
Lista_Utenti.Text = Lista_Utenti.Text & " Distance Then
Lista_Utenti.Text = Lista_Utenti.Text & " onmouseover=""doTooltip(event, messages["& counter &"] )"" onmouseout=""hideTip()"""
End If
Lista_Utenti.Text = Lista_Utenti.Text & ">"& r("Username") &" "& r("Fama") &" "
If Trim(r("Gilda")) = "" AND Tua_Gilda <> "" Then
If Is_Administrator < 3 Then
Lista_Utenti.Text = Lista_Utenti.Text & ""& Read_File("inc\Lang\Languages.aspx",527) &""
End If
End If
If Trim(r("Gilda")) <> "" Then
Dim Gilda_Word = "Gilda"
Lista_Utenti.Text = Lista_Utenti.Text & ""& Trim(Ucase(r("Gilda"))) &""
End If
Lista_Utenti.Text = Lista_Utenti.Text & "  
"& Razza &" "
Lista_Utenti.Text = Lista_Utenti.Text & "
"
If Page <> 0 Then
Lista_Utenti.Text = Lista_Utenti.Text & ""& Read_File("inc\Lang\Languages.aspx",528) &""
End If
If Page <> 0 AND Last_Id <> Last_Id_Page Then
Lista_Utenti.Text = Lista_Utenti.Text & " - "
End If
If Last_Id <> Last_Id_Page Then
Lista_Utenti.Text = Lista_Utenti.Text & ""& Read_File("inc\Lang\Languages.aspx",529) &""
End If
End If
%>
<% If Box_Hidden = 0 Then %>
<%
Page.RegisterHiddenField("__EVENTTARGET", "Btn_Cerca_Utenti")
%>
<% End If %>