Advertisement
Guest User

Untitled

a guest
Mar 26th, 2015
245
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. public void SaveWired(WiredItem Item)
  2. {
  3. using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
  4. {
  5. string Items = "";
  6. int i = 0;
  7. foreach (RoomItem IItem in Item.Items)
  8. {
  9. if (i != 0)
  10. Items += ";";
  11.  
  12. Items += IItem.Id;
  13.  
  14. i++;
  15. }
  16.  
  17. dbClient.setQuery("REPLACE INTO wired_items VALUES (@id, @items, @delay, @string, @bool)");
  18. dbClient.addParameter("id", Item.Item.Id);
  19. dbClient.addParameter("items", Items);
  20. dbClient.addParameter("delay", Item.Delay);
  21. dbClient.addParameter("string", Item.OtherString);
  22. dbClient.addParameter("bool", Item.OtherBool);
  23. dbClient.runQuery();
  24. }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement