本文整理汇总了C#中IQueryAdapter.RunFastQuery方法的典型用法代码示例。如果您正苦于以下问题:C# IQueryAdapter.RunFastQuery方法的具体用法?C# IQueryAdapter.RunFastQuery怎么用?C# IQueryAdapter.RunFastQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IQueryAdapter
的用法示例。
在下文中一共展示了IQueryAdapter.RunFastQuery方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DatabaseCleanup
/// <summary>
/// Databases the cleanup.
/// </summary>
/// <param name="dbClient">The database client.</param>
private static void DatabaseCleanup(IQueryAdapter dbClient)
{
dbClient.RunFastQuery("UPDATE users SET online = '0' WHERE online <> '0'");
dbClient.RunFastQuery("UPDATE rooms_data SET users_now = 0 WHERE users_now <> 0");
dbClient.RunFastQuery(
"UPDATE `server_status` SET status = '1', users_online = '0', rooms_loaded = '0', server_ver = 'Yupi Emulator', stamp = '" +
Yupi.GetUnixTimeStamp() + "' LIMIT 1;");
}
示例2: RemoveAllMessages
/// <summary>
/// Removes all messages.
/// </summary>
/// <param name="dbClient">The database client.</param>
/// <param name="toId">To identifier.</param>
internal static void RemoveAllMessages(IQueryAdapter dbClient, uint toId)
{
dbClient.RunFastQuery($"DELETE FROM messenger_offline_messages WHERE to_id={toId}");
}
示例3: RunDbUpdate
/// <summary>
/// Runs the database update.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal void RunDbUpdate(IQueryAdapter dbClient)
{
dbClient.RunFastQuery(string.Concat("UPDATE users SET last_online = '", Yupi.GetUnixTimeStamp(), "', activity_points = '", ActivityPoints, "', credits = '", Credits, "', diamonds = '", Diamonds, "' WHERE id = '", Id, "' LIMIT 1; "));
}
示例4: DatabaseCleanup
/// <summary>
/// Databases the cleanup.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal static void DatabaseCleanup(IQueryAdapter dbClient)
{
dbClient.RunFastQuery("UPDATE users SET online = '0' WHERE online <> '0'");
dbClient.RunFastQuery("UPDATE rooms_data SET users_now = 0 WHERE users_now <> 0");
dbClient.RunFastQuery(
string.Format(
"UPDATE server_status SET status = 1, users_online = 0, rooms_loaded = 0, server_ver = 'Azure emu', stamp = '{0}' ",
AzureEmulator.GetUnixTimeStamp()));
}
示例5: RemoveAllMessages
/// <summary>
/// Removes all messages.
/// </summary>
/// <param name="dbClient">The database client.</param>
/// <param name="ToId">To identifier.</param>
internal static void RemoveAllMessages(IQueryAdapter dbClient, uint ToId)
{
dbClient.RunFastQuery(string.Format("DELETE FROM messenger_offline_messages WHERE to_id={0}", ToId));
}
示例6: SaveFurniture
/// <summary>
/// Saves the furniture.
/// </summary>
/// <param name="dbClient">The database client.</param>
/// <param name="session">The session.</param>
public void SaveFurniture(IQueryAdapter dbClient, GameClient session = null)
{
try
{
if (!_updatedItems.Any() && !_removedItems.Any() && _room.GetRoomUserManager().PetCount <= 0)
return;
foreach (uint itemId in _removedItems)
dbClient.RunFastQuery($"UPDATE items_rooms SET room_id='0', x='0', y='0', z='0', rot='0' WHERE id = {itemId}");
foreach (RoomItem roomItem in _updatedItems.Select(GetItem).Where(roomItem => roomItem != null))
{
if (roomItem.GetBaseItem() != null && roomItem.GetBaseItem().IsGroupItem)
{
try
{
string[] gD = roomItem.GroupData.Split(';');
roomItem.ExtraData = roomItem.ExtraData + ";" + gD[1] + ";" + gD[2] + ";" + gD[3];
}
catch
{
roomItem.ExtraData = string.Empty;
}
}
if (roomItem.RoomId == 0)
continue;
if (roomItem.GetBaseItem().Name.Contains("wallpaper_single") ||
roomItem.GetBaseItem().Name.Contains("floor_single") ||
roomItem.GetBaseItem().Name.Contains("landscape_single"))
{
dbClient.RunFastQuery($"DELETE FROM items_rooms WHERE id = {roomItem.Id} LIMIT 1");
continue;
}
if (roomItem.IsFloorItem)
{
dbClient.SetQuery(
$"UPDATE items_rooms SET room_id={roomItem.RoomId}, [email protected], x={roomItem.X}, y={roomItem.Y}, z='{roomItem.Z.ToString(CultureInfo.InvariantCulture).Replace(',', '.')}', rot={roomItem.Rot} WHERE id={roomItem.Id}");
dbClient.AddParameter("extraData",
!string.IsNullOrEmpty(roomItem.ExtraData) ? roomItem.ExtraData : string.Empty);
dbClient.RunQuery();
}
else
{
dbClient.SetQuery(
$"UPDATE items_rooms SET room_id={roomItem.RoomId}, [email protected], [email protected] WHERE id={roomItem.Id}");
dbClient.AddParameter("extraData",
!string.IsNullOrEmpty(roomItem.ExtraData) ? roomItem.ExtraData : string.Empty);
dbClient.AddParameter("wallPos", roomItem.WallCoord);
dbClient.RunQuery();
}
}
_room.GetRoomUserManager().AppendPetsUpdateString(dbClient);
session?.GetHabbo().GetInventoryComponent().RunDbUpdate();
_updatedItems.Clear();
_removedItems.Clear();
}
catch (Exception ex)
{
ServerLogManager.LogCriticalException("Error during saving furniture for room " + _room.RoomId +
". Stack: " + ex);
}
}