本文整理汇总了C#中IQueryAdapter.runFastQuery方法的典型用法代码示例。如果您正苦于以下问题:C# IQueryAdapter.runFastQuery方法的具体用法?C# IQueryAdapter.runFastQuery怎么用?C# IQueryAdapter.runFastQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IQueryAdapter
的用法示例。
在下文中一共展示了IQueryAdapter.runFastQuery方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
lock (items)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.item.Id + "'");
foreach (RoomItem i in items)
{
WiredUtillity.SaveTrigger(dbClient, (int)item.Id, (int)i.Id);
}
}
}
示例2: SaveTriggerItem
internal static void SaveTriggerItem(IQueryAdapter dbClient, int triggerID, string triggerInput, string triggerData2, string triggerData, bool allUsertriggerable)
{
dbClient.runFastQuery("DELETE FROM trigger_item WHERE trigger_id = " + triggerID);
dbClient.setQuery("INSERT INTO trigger_item (trigger_id,trigger_input,trigger_data,trigger_data_2,all_user_triggerable) VALUES (@id,@triggerinput,@trigger_data,@trigger_data_2,@triggerable)");
dbClient.addParameter("id", triggerID);
dbClient.addParameter("triggerinput", triggerInput);
dbClient.addParameter("trigger_data", triggerData);
dbClient.addParameter("trigger_data_2", triggerData2);
dbClient.addParameter("triggerable", allUsertriggerable ? 1 : 0);
dbClient.runQuery();
}
示例3: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
if (dbClient.dbType == Pici.Storage.Database.DatabaseType.MSSQL)
{
dbClient.runFastQuery("DELETE FROM trigger_item WHERE trigger_id = " + item.Id);
dbClient.setQuery("REPLACE INTO trigger_item SET trigger_id = @id, trigger_input = 'integer', trigger_data = @trigger_data , all_user_triggerable = 0");
}
else
dbClient.setQuery("REPLACE INTO trigger_item SET trigger_id = @id, trigger_input = 'integer', trigger_data = @trigger_data , all_user_triggerable = 0");
dbClient.addParameter("id", (int)this.item.Id);
dbClient.addParameter("trigger_data", timeout);
dbClient.runQuery();
}
示例4: DeleteFromDatabase
public void DeleteFromDatabase(IQueryAdapter dbClient)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.item.Id + "'");
}
示例5: LoadPendingTickets
internal void LoadPendingTickets(IQueryAdapter dbClient)
{
dbClient.runFastQuery("TRUNCATE TABLE moderation_tickets");
}
示例6: DatabaseCleanup
internal static void DatabaseCleanup(IQueryAdapter dbClient)
{
//dbClient.runFastQuery("TRUNCATE TABLE user_tickets");
dbClient.runFastQuery("TRUNCATE TABLE user_online");
dbClient.runFastQuery("TRUNCATE TABLE room_active");
dbClient.runFastQuery("UPDATE server_status SET status = 1, users_online = 0, rooms_loaded = 0, server_ver = '" + FirewindEnvironment.PrettyVersion + "', stamp = '" + FirewindEnvironment.GetUnixTimestamp() + "' ");
}
示例7: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
WiredUtillity.SaveTriggerItem(dbClient, (int)item.Id, "integer", string.Empty, requiredCycles.ToString(), false);
lock (items)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.item.Id + "'");
foreach (RoomItem i in items)
{
WiredUtillity.SaveTrigger(dbClient, (int)item.Id, (int)i.Id);
}
}
}
示例8: RunDBUpdate
internal void RunDBUpdate(IQueryAdapter dbClient)
{
dbClient.runFastQuery("UPDATE users SET last_online = '" + SilverwaveEnvironment.GetUnixTimestamp() + "', activity_points = '" + ActivityPoints + "', credits = '" + Credits +"'" +", belcredits = '" + BelCredits + "' WHERE id = '" + Id + "' LIMIT 1; ");
}
示例9: DeleteFromDatabase
public void DeleteFromDatabase(IQueryAdapter dbClient)
{
dbClient.runFastQuery("DELETE FROM trigger_item WHERE trigger_id = '" + this.itemID + "'");
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.itemID +"'");
dbClient.runFastQuery("DELETE FROM trigger_rotation WHERE item_id = '" + this.itemID + "'");
}
示例10: RunDBUpdate
internal void RunDBUpdate(IQueryAdapter dbClient)
{
dbClient.runFastQuery(string.Concat(new object[]
{
"UPDATE users SET last_online = '",
CyberEnvironment.GetUnixTimestamp(),
"', activity_points = '",
this.ActivityPoints,
"', credits = '",
this.Credits,
"', seasonal_currency = '",
this.BelCredits,
"' WHERE id = '",
this.Id,
"' LIMIT 1; "
}));
}
示例11: DatabaseCleanup
internal static void DatabaseCleanup(IQueryAdapter dbClient)
{
dbClient.runFastQuery("UPDATE `users` SET online = '0'");
dbClient.runFastQuery("TRUNCATE TABLE user_tickets");
dbClient.runFastQuery("TRUNCATE TABLE user_roomvisits");
dbClient.runFastQuery("TRUNCATE TABLE user_online");
dbClient.runFastQuery("TRUNCATE TABLE room_active");
dbClient.runFastQuery("UPDATE server_status SET status = '1', users_online = '0', rooms_loaded = '0', server_ver = 'Butterfly Emulator R105', stamp = '" + ButterflyEnvironment.GetUnixTimestamp() + "' ");
}
示例12: LoadPendingTickets
internal void LoadPendingTickets(IQueryAdapter dbClient)
{
dbClient.runFastQuery("TRUNCATE TABLE moderation_tickets");
//dbClient.setQuery("SELECT moderation_tickets.*, p1.username AS sender_username, p2.username AS reported_username, p3.username AS moderator_username FROM moderation_tickets LEFT OUTER JOIN users AS p1 ON moderation_tickets.sender_id = p1.id LEFT OUTER JOIN users AS p2 ON moderation_tickets.reported_id = p2.id LEFT OUTER JOIN users AS p3 ON moderation_tickets.moderator_id = p3.id WHERE moderation_tickets.status != 'resolved'");
//DataTable Data = dbClient.getTable();
//if (Data == null)
//{
// return;
//}
//foreach (DataRow Row in Data.Rows)
//{
// SupportTicket Ticket = new SupportTicket(Convert.ToUInt32(Row["id"]), (int)Row["score"], (int)Row["type"], Convert.ToUInt32(Row["sender_id"]), Convert.ToUInt32(Row["reported_id"]), (String)Row["message"], Convert.ToUInt32(Row["room_id"]), (String)Row["room_name"], (Double)Row["timestamp"], Row["sender_username"], Row["reported_username"], Row["moderator_username"]);
// if (Row["status"].ToString().ToLower() == "picked")
// {
// Ticket.Pick(Convert.ToUInt32(Row["moderator_id"]), false);
// }
// Tickets.Add(Ticket);
//}
}
示例13: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
WiredUtillity.SaveTriggerItem(dbClient, (int)itemID, "integer", string.Empty, "0", false);
lock (items)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.itemID + "'");
State.Clear();
Pos.Clear();
Rot.Clear();
foreach (RoomItem i in items)
{
if (i != null)
{
if (WiredUtillity.TypeIsWired(i.GetBaseItem().InteractionType))
MatchState = 0;
dbClient.setQuery("INSERT INTO trigger_in_place (original_trigger,triggers_item, extradata) VALUES (@my_id,@trigger_item,@extra)");
dbClient.addParameter("my_id", itemID);
dbClient.addParameter("trigger_item", i.Id);
dbClient.addParameter("extra", MatchState + "-" + i.ExtraData + ";" + MatchRot + "-" + i.Rot + ";" + MatchPos + "-" + i.GetX + "," + i.GetY);
dbClient.runQuery();
if (MatchPos == 1)
{
Pos.Add(i, new Point(i.GetX, i.GetY));
}
if (MatchRot == 1)
{
Rot.Add(i, i.Rot);
}
if (MatchState == 1)
{
State.Add(i, i.ExtraData);
}
}
}
}
}
示例14: DatabaseCleanup
internal static void DatabaseCleanup(IQueryAdapter dbClient)
{
dbClient.runFastQuery("UPDATE users SET online = '0' WHERE online <> '0'");
dbClient.runFastQuery("UPDATE rooms SET users_now = 0 WHERE users_now <> 0");
dbClient.runFastQuery("UPDATE server_status SET status = 1, users_online = 0, rooms_loaded = 0, server_ver = 'Mercury Emulator', stamp = '" + MercuryEnvironment.GetUnixTimestamp() + "' ");
}
示例15: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
WiredUtillity.SaveTriggerItem(dbClient, (int)item.Id, "integer", string.Empty, delay.ToString(), false);
lock (items)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.item.Id + "'");
foreach (RoomItem i in items)
{
WiredUtillity.SaveTrigger(dbClient, (int)item.Id, (int)i.Id);
}
//Console.WriteLine("save trigger 'updatestate' items: " + items.Count);
}
}