private static void smethod_6(Session session_0, ClientMessage clientMessage_0)
{
uint num = clientMessage_0.ReadUnsignedInteger();
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
client.SetParameter("user1", session_0.CharacterId);
client.SetParameter("user2", num);
client.SetParameter("confirmed", 1);
if (client.ExecuteNonQuery("UPDATE laptop_amigos SET aceptado = @confirmed WHERE id_usuario = @user1 AND id_amigo = @user2 LIMIT 1") > 0)
{
client.SetParameter("user1", num);
client.SetParameter("user2", session_0.CharacterId);
client.SetParameter("confirmed", 1);
client.ExecuteNonQuery("INSERT INTO laptop_amigos (id_usuario,id_amigo,aceptado) VALUES (@user1,@user2,@confirmed)");
session_0.LaptopFriendCache.AddToCache(num);
Session sessionByCharacterId = SessionManager.GetSessionByCharacterId(num);
if (sessionByCharacterId != null)
{
sessionByCharacterId.LaptopFriendCache.AddToCache(session_0.CharacterId);
ForceLaptopUpdateForSession(sessionByCharacterId);
sessionByCharacterId.SendData(LaptopNewFriendComposer.Compose(session_0.CharacterInfo), false);
}
session_0.SendData(LaptopAcceptFriendComposer.Compose(num), false);
}
}
}
private static void smethod_6(Session session_0, ClientMessage clientMessage_0)
{
uint num = clientMessage_0.ReadUnsignedInteger();
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
client.SetParameter("user1", session_0.CharacterId);
client.SetParameter("user2", num);
client.SetParameter("confirmed", 1);
string query1 = "UPDATE laptop_amigos SET aceptado = '1' WHERE id_usuario = " + session_0.CharacterId + " AND id_amigo = " + num + " LIMIT 1";
Console.WriteLine(query1);
if (client.ExecuteNonQuery(query1) > 0)
{
client.ExecuteNonQuery("UPDATE laptop_amigos SET aceptado = '1' WHERE id_usuario = " + num + " AND id_amigo = " + session_0.CharacterId + " LIMIT 1");
session_0.LaptopFriendCache.AddToCache(num);
Session sessionByCharacterId = SessionManager.GetSessionByCharacterId(num);
if (sessionByCharacterId != null)
{
sessionByCharacterId.LaptopFriendCache.AddToCache(session_0.CharacterId);
ForceLaptopUpdateForSession(sessionByCharacterId);
sessionByCharacterId.SendData(LaptopNewFriendComposer.Compose(session_0.CharacterInfo));
}
session_0.SendData(LaptopAcceptFriendComposer.Compose(num));
}
}
}