Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. #region :911
  2. case "911": // User sends CFH message
  3. {
  4. using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
  5. {
  6. string cfhMessage = Text.Substring(3);
  7. dbClient.runQuery("INSERT INTO cms_help (username,ip,message,date,picked_up,subject,roomid) VALUES ('" + _Username + "','" + connectionSocket.RemoteEndPoint.ToString().Split(Char.Parse(":"))[0] + "','" + cfhMessage + "','" + DateTime.Now + "','0','CFH message [hotel]','" + _roomID.ToString() + "')");
  8. int cfhID = dbClient.getInt("SELECT id FROM cms_help WHERE username = '" + _Username + "' AND picked_up = '0'");
  9. string roomName = dbClient.getString("SELECT name FROM rooms WHERE id = '" + _roomID + "'"); // H = Automated / I = Manual H = Hide Room ID / I = Show Room ID
  10. userManager.sendToCop(Config.Minimum_CFH_Rank, true, "BT" + Encoding.encodeVL64(cfhID) + Convert.ToChar(2) + "I" + "Sent: " + DateTime.Now + Convert.ToChar(2) + _Username + Convert.ToChar(2) + cfhMessage + Convert.ToChar(2) + Encoding.encodeVL64(_roomID) + Convert.ToChar(2) + roomName + Convert.ToChar(2) + "I" + Convert.ToChar(2) + Encoding.encodeVL64(_roomID));
  11. }
  12. break;
  13. }
  14. #endregion
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement