public static void DoAllNew(SqlDatabaseClient Db)
{
Db.ExecuteNonQuery("INSERT INTO " + Application.FirewindDb + ".items (item_id, base_id) SELECT DISTINCT id, base_item FROM " + Application.PhoenixDb + ".items;");
Db.ExecuteNonQuery("INSERT INTO " + Application.FirewindDb + ".items_users (item_id, user_id) SELECT DISTINCT id, user_id FROM " + Application.PhoenixDb + ".items WHERE room_id = '0';");
Db.ExecuteNonQuery("INSERT INTO " + Application.FirewindDb + ".items_extradata (item_id, data) SELECT DISTINCT id, extra_data FROM " + Application.PhoenixDb + ".items WHERE extra_data != '';");
Db.ExecuteNonQuery("INSERT INTO " + Application.FirewindDb + ".items_rooms (item_id, room_id, x, y, n) SELECT DISTINCT id,room_id, x + ( y / 100 ),z,rot FROM " + Application.PhoenixDb + ".items WHERE room_id != '0' AND wall_pos NOT LIKE ':w=%';");
}
public void UpdateHobbies(SqlDatabaseClient MySqlClient, uint LabelId, string mHobby)
{
switch (LabelId)
{
case 1:
this.string_5 = mHobby;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Hobby", this.string_5);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_1 = @Hobby WHERE id = @id LIMIT 1");
return;
case 2:
this.string_6 = mHobby;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Hobby", this.string_6);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_2 = @Hobby WHERE id = @id LIMIT 1");
return;
case 3:
this.string_7 = mHobby;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Hobby", this.string_7);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_3 = @Hobby WHERE id = @id LIMIT 1");
return;
}
this.string_5 = mHobby;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Hobby", this.string_5);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET hobby_1 = @Hobby WHERE id = @id LIMIT 1");
}
public static void Cleanup(SqlDatabaseClient Client)
{
Client.ExecuteNonQuery("TRUNCATE TABLE items");
Client.ExecuteNonQuery("TRUNCATE TABLE items_rooms");
Client.ExecuteNonQuery("TRUNCATE TABLE items_users");
Client.ExecuteNonQuery("TRUNCATE TABLE items_extradata");
}
public void UpdateGames(SqlDatabaseClient MySqlClient, bool WonRing = false, bool WonCoconut = false, bool WonShuriken = false, bool LoseShuriken = false)
{
if (WonRing)
{
this.uint_8++;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("WonRings", this.uint_8);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET rings_ganados = @WonRings WHERE id = @id LIMIT 1");
}
else if (WonCoconut)
{
this.uint_9++;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("WonCoconuts", this.uint_9);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET cocos_ganados = @WonCoconuts WHERE id = @id LIMIT 1");
}
else if (WonShuriken)
{
if (!LoseShuriken)
{
this.uint_12 += 5;
}
else
{
this.uint_12 += 2;
}
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("NinjaPoints", this.uint_12);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET nivel_ninja = @NinjaPoints WHERE id = @id LIMIT 1");
}
}
public void UpdateVotes(SqlDatabaseClient MySqlClient, uint ColorId, int Vote)
{
switch (ColorId)
{
case 1:
this.int_12 += Vote;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("GreenVotes", this.int_12);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_legal = @GreenVotes WHERE id = @id LIMIT 1");
return;
case 2:
this.int_13 += Vote;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("BlueVotes", this.int_13);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_sexy = @BlueVotes WHERE id = @id LIMIT 1");
return;
case 3:
this.int_14 += Vote;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("OrangeVotes", this.int_14);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_simpatico = @OrangeVotes WHERE id = @id LIMIT 1");
return;
}
this.int_12 += Vote;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("GreenVotes", this.int_12);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET votos_legal = @GreenVotes WHERE id = @id LIMIT 1");
}
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));
}
}
}
public void AddOrExtend(int Level, double ExtensionTime)
{
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
if (!IsActive)
{
mTimestampCreated = UnixTimestamp.GetCurrent();
mTimestampExpire = UnixTimestamp.GetCurrent();
}
mTimestampExpire += ExtensionTime;
mBaseLevel = (ClubSubscriptionLevel)Level;
MySqlClient.SetParameter("userid", mUserId);
bool CreateNewRecord = (MySqlClient.ExecuteScalar("SELECT null FROM user_subscriptions WHERE user_id = @userid LIMIT 1") == null);
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("expirestamp", mTimestampExpire);
MySqlClient.SetParameter("level", ((int)mBaseLevel).ToString());
if (CreateNewRecord)
{
MySqlClient.SetParameter("createstamp", UnixTimestamp.GetCurrent());
MySqlClient.ExecuteNonQuery("INSERT INTO user_subscriptions (user_id,subscription_level,timestamp_created,timestamp_expire) VALUES (@userid,@level,@createstamp,@expirestamp)");
}
else
{
MySqlClient.ExecuteNonQuery("UPDATE user_subscriptions SET subscription_level = @level, timestamp_expire = @expirestamp WHERE user_id = @userid LIMIT 1");
}
}
}
public void UpdateWishes(SqlDatabaseClient MySqlClient, uint LabelId, string mWish)
{
switch (LabelId)
{
case 1:
this.string_8 = mWish;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Wish", this.string_8);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_1 = @Wish WHERE id = @id LIMIT 1");
return;
case 2:
this.string_9 = mWish;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Wish", this.string_9);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_2 = @Wish WHERE id = @id LIMIT 1");
return;
case 3:
this.string_10 = mWish;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Wish", this.string_10);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_3 = @Wish WHERE id = @id LIMIT 1");
return;
}
this.string_8 = mWish;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Wish", this.string_8);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET deseo_1 = @Wish WHERE id = @id LIMIT 1");
}
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);
}
}
}
public void UpdateAvatar(SqlDatabaseClient MySqlClient, uint Type, string Colors)
{
if (string.IsNullOrEmpty(Colors) && !Type.Equals(null))
{
this.uint_2 = Type;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("AvatarType", this.uint_2);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET tipo_avatar = @AvatarType WHERE id = @id LIMIT 1");
}
else if (!string.IsNullOrEmpty(Colors) && Type.Equals(null))
{
this.string_3 = Colors;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("AvatarColors", this.string_3);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET colores_avatar = @AvatarColors WHERE id = @id LIMIT 1");
}
else if (!string.IsNullOrEmpty(Colors) && !Type.Equals(null))
{
this.uint_2 = Type;
this.string_3 = Colors;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("AvatarType", this.uint_2);
MySqlClient.SetParameter("AvatarColors", this.string_3);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET colores_avatar = @AvatarColors, tipo_avatar = @AvatarType WHERE id = @id LIMIT 1");
}
}
private static void PerformDatabaseCleanup(SqlDatabaseClient MySqlClient)
{
MySqlClient.ExecuteNonQuery("UPDATE rooms SET current_users = 0");
MySqlClient.SetParameter("timestamp", UnixTimestamp.GetCurrent());
MySqlClient.ExecuteNonQuery("UPDATE room_visits SET timestamp_left = @timestamp WHERE timestamp_left = 0");
MySqlClient.ExecuteNonQuery("UPDATE characters SET auth_ticket = ''");
}
private static void OnFriendRequestAccept(Session Session, ClientMessage Message)
{
int Amount = Message.PopWiredInt32();
// Precaution: limit queries to 50.
if (Amount > 50)
{
Amount = 50;
}
List <Session> SessionsToUpdate = new List <Session>()
{
Session
};
for (int i = 0; i < Amount; i++)
{
uint RequestId = Message.PopWiredUInt32();
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
MySqlClient.SetParameter("user1", Session.CharacterId);
MySqlClient.SetParameter("user2", RequestId);
MySqlClient.SetParameter("confirmed", 1);
int Affected = MySqlClient.ExecuteNonQuery("UPDATE messenger_friendships SET confirmed = @confirmed WHERE user_1_id = @user1 AND user_2_id = @user2 LIMIT 1");
if (Affected > 0)
{
MySqlClient.SetParameter("user1", RequestId);
MySqlClient.SetParameter("user2", Session.CharacterId);
MySqlClient.SetParameter("confirmed", 1);
MySqlClient.ExecuteNonQuery("INSERT INTO messenger_friendships (user_1_id,user_2_id,confirmed) VALUES (@user1,@user2,@confirmed)");
Session.MessengerFriendCache.AddToCache(RequestId);
Session TargetSession = SessionManager.GetSessionByCharacterId(RequestId);
if (TargetSession != null)
{
TargetSession.MessengerFriendCache.AddToCache(Session.CharacterId);
SessionsToUpdate.Add(TargetSession);
}
}
}
}
for (int i = 0; i < 2; i++)
{
foreach (Session SessionToUpdate in SessionsToUpdate)
{
ForceMessengerUpdateForSession(SessionToUpdate);
}
}
}
public static void DeleteRoom(SqlDatabaseClient MySqlClient, uint RoomId)
{
MySqlClient.SetParameter("id", RoomId);
MySqlClient.ExecuteNonQuery("DELETE FROM rooms WHERE id = @id LIMIT 1");
MySqlClient.SetParameter("id", RoomId);
MySqlClient.ExecuteNonQuery("DELETE FROM navigator_frontpage WHERE room_id = @id");
RoomInfoLoader.RemoveFromCache(RoomId);
Navigator.ReloadOfficialItems(MySqlClient);
}
public static void DoUserWallItems(SqlDatabaseClient Phoenix, SqlDatabaseClient Butterfly)
{
DataTable items = Phoenix.ExecuteQueryTable("SELECT * FROM items WHERE room_id = 0 AND wall_pos LIKE ':w=%'");
foreach (DataRow item in items.Rows)
{
uint Id = (uint)item["id"];
int UserId = (int)item["user_id"];
int BaseItem = (int)item["base_item"];
Butterfly.ExecuteNonQuery("REPLACE INTO items_users(item_id, user_id) VALUES ('" + Id + "', '" + UserId + "')");
Butterfly.ExecuteNonQuery("REPLACE INTO items(item_id, base_id) VALUES ('" + Id + "', '" + BaseItem + "')");
items.Rows.Remove(item);
}
}
public void UpdateMotto(SqlDatabaseClient MySqlClient, string Motto)
{
this.string_2 = Motto;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("Motto", Motto);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET bocadillo = @Motto WHERE id = @id LIMIT 1");
}
private static void smethod_2(Session session_0, ClientMessage clientMessage_0)
{
string str = clientMessage_0.ReadString();
string s = clientMessage_0.ReadString();
uint num = clientMessage_0.ReadUnsignedInteger();
string str3 = clientMessage_0.ReadString();
int num2 = clientMessage_0.ReadInteger();
string str4 = clientMessage_0.ReadString();
string str5 = string.Empty;
string str6 = string.Empty;
SHA1 sha = SHA1.Create();
if ((((str.Length >= 1) && (s.Length >= 4)) && ((num2 >= 0) || (num2 <= 0x41))) && (str4.Length >= 4))
{
str5 = Convert.ToBase64String(sha.ComputeHash(Constants.DefaultEncoding.GetBytes(s)));
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
client.SetParameter("Username", str);
client.SetParameter("Password", str5);
client.SetParameter("Avatar", num);
client.SetParameter("Colors", str3);
client.SetParameter("Age", num2);
client.SetParameter("Email", str4);
client.SetParameter("CurrentTimestamp", UnixTimestamp.GetCurrent());
client.SetParameter("RemoteAddress", session_0.RemoteAddress);
client.SetParameter("Null", 0);
str6 = client.ExecuteScalar("INSERT INTO usuarios (`usuario`, `password`, `email`, `edad`, `tiempo_registrado`, `ip_registro`, `ip_actual`, `ultimo_login`, `tipo_avatar`, `colores_avatar`, `timestamp_monedas`) VALUES (@Username, @Password, @Email, @Age, @Null, @RemoteAddress, @RemoteAddress, @CurrentTimestamp, @Avatar, @Colors, @CurrentTimestamp); SELECT LAST_INSERT_ID();").ToString();
client.SetParameter("Id", (str6 == string.Empty) ? ((object)0) : ((object)uint.Parse(str6)));
client.ExecuteNonQuery("INSERT INTO rankings (`usuario`) VALUES (@Id)");
}
session_0.TryAuthenticate(str, str5, session_0.RemoteAddress, true);
}
}
/// <summary>
/// Removes the SSO (Single Sign On) ticket from the database after a successful login attempt.
/// </summary>
/// <param name="UserId">The character id to remove the ticket from.</param>
private static void RemoveTicket(SqlDatabaseClient MySqlClient, uint UserId, string AddressToLog)
{
MySqlClient.SetParameter("id", UserId);
MySqlClient.SetParameter("lastip", AddressToLog);
MySqlClient.SetParameter("lastonline", UnixTimestamp.GetCurrent());
MySqlClient.ExecuteNonQuery("UPDATE characters SET auth_ticket = '', last_ip = @lastip, timestamp_lastvisit = @lastonline WHERE id = @id LIMIT 1");
}
private static void smethod_9(Session session_0, ClientMessage clientMessage_0)
{
uint num = clientMessage_0.ReadUnsignedInteger();
string str = InputFilter.FilterString(clientMessage_0.ReadString(), false).Trim();
if ((((num > 0) && (str.Length >= 1)) && (num != session_0.CharacterId)) && session_0.LaptopFriendCache.Friends.Contains(num))
{
Session sessionByCharacterId = SessionManager.GetSessionByCharacterId(num);
if (sessionByCharacterId == null)
{
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
client.SetParameter("sender", session_0.CharacterId);
client.SetParameter("receptor", num);
client.SetParameter("text", str);
client.SetParameter("time", UnixTimestamp.GetCurrent());
client.SetParameter("color", session_0.CharacterInfo.Staff);
client.ExecuteNonQuery("INSERT INTO laptop_mensajes (emisor, receptor, contenido, timestamp, color, leido) VALUES (@sender, @receptor, @text, @time, @color, 0)");
}
}
else
{
sessionByCharacterId.SendData(LaptopMessageComposer.Compose(session_0.CharacterId, str, session_0.CharacterInfo.Staff), false);
}
}
}
public void Unmute(SqlDatabaseClient MySqlClient)
{
mModerationMutedUntil = 0;
MySqlClient.SetParameter("id", mId);
MySqlClient.ExecuteNonQuery("UPDATE characters SET moderation_muted_until_timestamp = 0 WHERE id = @id LIMIT 1");
}
public WiredData(uint ItemId, int Type)
{
mItemId = ItemId;
mType = Type;
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
MySqlClient.SetParameter("id", ItemId);
DataRow Row = MySqlClient.ExecuteQueryRow("SELECT * FROM wired_items WHERE item_id = @id LIMIT 1");
if (Row != null)
{
GenerateWiredFromRow(Row);
}
else
{
MySqlClient.SetParameter("id", ItemId);
MySqlClient.ExecuteNonQuery("INSERT INTO wired_items (item_id, data1, data2, data3, data4, data5, time) VALUES (@id, '','0','0', '0','', '0')");
mData1 = "";
mData2 = 0;
mData3 = 0;
mData4 = 0;
mData5 = "";
mTime = 0;
}
}
}
public void ApplyDecoration(SqlDatabaseClient MySqlClient, string Key, string Value)
{
lock (mSyncRoot)
{
if (!mDecorations.ContainsKey(Key))
{
mDecorations.Add(Key, Value);
}
else
{
mDecorations[Key] = Value;
}
StringBuilder DecorationString = new StringBuilder();
foreach (KeyValuePair <string, string> Decoration in mDecorations)
{
if (DecorationString.Length > 0)
{
DecorationString.Append('|');
}
DecorationString.Append(Decoration.Key);
DecorationString.Append('=');
DecorationString.Append(Decoration.Value);
}
MySqlClient.SetParameter("id", mId);
MySqlClient.SetParameter("decorations", DecorationString);
MySqlClient.ExecuteNonQuery("UPDATE rooms SET decorations = @decorations WHERE id = @id LIMIT 1");
}
}
private static void OnFriendRequestDecline(Session Session, ClientMessage Message)
{
bool HandleAll = Message.PopWiredBoolean();
int Amount = Message.PopWiredInt32();
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
if (HandleAll)
{
MySqlClient.SetParameter("userid", Session.CharacterId);
MySqlClient.SetParameter("confirmed", 0);
MySqlClient.SetParameter("amount", Amount);
MySqlClient.ExecuteNonQuery("DELETE FROM messenger_friendships WHERE user_1_id = @userid AND confirmed = @confirmed");
}
else
{
// Precaution: limit queries to 50
if (Amount > 50)
{
Amount = 50;
}
for (int i = 0; i < Amount; i++)
{
uint RequestId = Message.PopWiredUInt32();
DestroyFriendship(MySqlClient, Session.CharacterId, RequestId);
}
}
}
}
private static void smethod_23(Session session_0, ClientMessage clientMessage_0)
{
string str = clientMessage_0.ReadString();
uint num = clientMessage_0.ReadUnsignedInteger();
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
client.SetParameter("name", str);
if (client.ExecuteQueryRow("SELECT id FROM islas WHERE nombre = @name AND id_parent = '0' LIMIT 1") != null)
{
session_0.SendData(CreateIslandComposer.TakenNameComposer(), false);
}
else
{
client.SetParameter("name", str);
client.SetParameter("model", num);
client.SetParameter("userid", session_0.CharacterId);
client.ExecuteNonQuery("INSERT INTO islas (nombre,modelo_area,id_usuario) VALUES (@name, @model, @userid)");
client.SetParameter("name", str);
DataRow row2 = client.ExecuteQueryRow("SELECT id FROM islas WHERE nombre = @name AND id_parent = '0' LIMIT 1");
if (row2 != null)
{
session_0.SendData(CreateIslandComposer.Compose((uint)row2["id"]), false);
}
}
}
}
public static int InsertNewAdministratorToDBFromExistingUser(LocalUser user, byte[] password)
{
int count = 0;
try
{
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
string sql = "INSERT INTO Administrator (member_id, password_hash) VALUES(@member_id, @password_hash);";
client.SetParameter("@member_id", user.UserID);
client.SetParameter("@password_hash", password);
count = client.ExecuteNonQuery(sql);
}
}
catch (DbException e)
{
if (e.Message.Contains("Administrator_FKIndex1"))
{
return(-4);
}
else if (e.Message.Contains("unique_member_administrator_ck"))
{
return(-3);
}
else
{
Logger.WriteLine(e.ToString(), Logger.LOG_LEVEL.WARN);
}
}
return(count);
}
public void UpdateSilverCreditsBalance(SqlDatabaseClient MySqlClient, int Amount)
{
this.int_1 += Amount;
MySqlClient.SetParameter("id", this.uint_0);
MySqlClient.SetParameter("credits", this.int_1);
MySqlClient.ExecuteNonQuery("UPDATE usuarios SET creditos_plata = @credits WHERE id = @id LIMIT 1");
}
public void Stop(SqlDatabaseClient MySqlClient)
{
if (Stopped)
{
return;
}
mSocket.Close();
mSocket = null;
if (Authenticated)
{
mCharacterInfo.SynchronizeStatistics(MySqlClient);
if (CurrentRoomId > 0)
{
RoomManager.RemoveUserFromRoom(this, false);
}
MessengerHandler.MarkUpdateNeeded(this, 0, true);
MySqlClient.ExecuteNonQuery("UPDATE characters SET online = '0' WHERE id = " + CharacterId + " LIMIT 1");
}
Output.WriteLine("Stopped and disconnected client " + Id + ".", OutputLevel.DebugInformation);
mStoppedTimestamp = UnixTimestamp.GetCurrent();
}
public static void DeleteIsland(SqlDatabaseClient MySqlClient, uint IslandId)
{
MySqlClient.SetParameter("id", IslandId);
MySqlClient.ExecuteNonQuery("DELETE FROM escenarios WHERE id = @id LIMIT 1");
SpaceInfoLoader.RemoveFromCache(IslandId);
Navigator.ReloadOfficialItems(MySqlClient);
}
public void RemoveBadge(string BadgeCode)
{
lock (mSyncRoot)
{
foreach (Badge badge in mStaticBadges)
{
if (badge.Code == BadgeCode)
{
mIndexCache.Remove(badge.Code);
mStaticBadges.Remove(badge);
foreach (KeyValuePair <int, Badge> EquipData in mEquippedBadges)
{
if (EquipData.Value.Code == BadgeCode)
{
mEquippedBadges.Remove(EquipData.Key);
break;
}
}
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
MySqlClient.SetParameter("userid", mUserId);
MySqlClient.SetParameter("badgecode", BadgeCode);
MySqlClient.ExecuteNonQuery("DELETE FROM user_badges WHERE user_id = @userid AND badge_code = @badgecode");
}
break;
}
}
}
}
private static void smethod_0(SqlDatabaseClient sqlDatabaseClient_0, uint uint_0, string string_0)
{
sqlDatabaseClient_0.SetParameter("id", uint_0);
sqlDatabaseClient_0.SetParameter("lastip", string_0);
sqlDatabaseClient_0.SetParameter("lastonline", UnixTimestamp.GetCurrent());
sqlDatabaseClient_0.ExecuteNonQuery("UPDATE usuarios SET ip_actual = @lastip, ultimo_login = @lastonline WHERE id = @id LIMIT 1");
}
public static int InsertNewLog(string info)
{
int count = 0;
uint userId = LocalUser.GetFirstAdministratorAccount();
if (userId > 0)
{
try
{
using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
{
string sql = "INSERT INTO Entry (member_id, info) VALUES(@member_id, @info);";
client.SetParameter("@member_id", userId);
client.SetParameter("@info", info);
count = client.ExecuteNonQuery(sql);
}
}
catch (DbException e)
{
if (e.Message.Contains("Entry_FKIndex1"))
{
return(-1);
}
else
{
Logger.WriteLine(e.ToString(), Logger.LOG_LEVEL.WARN);
}
}
}
return(count);
}