Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. // Fixed:
  2.  
  3. internal void UpdateVar(int RoomId, string Var, Object e, bool Param)
  4. {
  5. using (IQueryAdapter Adapter = DuckEnvironment.GetAdapter())
  6. {
  7. Adapter.setQuery("UPDATE private_rooms SET " + Var.ToLower() + " = @" + Var + " WHERE id = '" + RoomId + "' LIMIT 1");
  8. Adapter.addParameter(Var, e.ToString());
  9. Adapter.runQuery();
  10. }
  11. }
  12.  
  13. // En zo zou je het eigenlijk moeten doen:
  14.  
  15. internal void updateRoom(int roomID, string roomName, string roomDescription, string ownerName, bla bla..)
  16. {
  17. using (IQueryAdapter Adapter = DuckEnvironment.GetAdapter())
  18. {
  19. Adapter.setQuery("UPDATE private_rooms SET name = @room_name, description = @room_description, owner = @room_owner WHERE id = @room_id LIMIT 1");
  20. Adapter.addParameter("room_id", roomID);
  21. Adapter.addParameter("room_name", roomName);
  22. Adapter.addParameter("room_description", roomDescription);
  23. Adapter.addParameter("room_owner", ownerName);
  24. Adapter.runQuery();
  25. }
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement