<%@ 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 = "" 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 & "" Lista_Utenti.Text = Lista_Utenti.Text & "" Last_Id_Page = r("Id") End While r.Close() sqlConn.Close() Lista_Utenti.Text = Lista_Utenti.Text & "
"& Read_File("inc\Lang\Languages.aspx",436) &""& Read_File("inc\Lang\Languages.aspx",525) &""& Read_File("inc\Lang\Languages.aspx",526) &"

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 & " "& Read_File("inc\Lang\Languages.aspx",439) &""& Razza &"


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