I know i have not released in a while, here is a nypd backup
Feel free to press the thanks button
Code:
#region :backup
case "backup":
{
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
int getCorp = int.Parse(dbClient.getString("SELECT corp_id FROM users WHERE name = '" + _Username + "'"));
int working = int.Parse(dbClient.getString("SELECT working FROM users WHERE name = '" + _Username + "'"));
if (getCorp == 1 && working == 1)
{
Room.sendSaying(roomUser, "\n\n*" + _Username + " calls for backup* " + "" + " \n\n " + _Username + " calls for backup*");
string messageLength = Text.Substring(3);
if (messageLength == "")
return false;
string cfhMessage = Text.Substring(3);
int cfhID;
string roomName;
dbClient.AddParamWithValue("username", _Username);
dbClient.AddParamWithValue("message", "Backup Needed NOW!.");
dbClient.AddParamWithValue("date", DateTime.Now);
dbClient.AddParamWithValue("roomid", _roomID.ToString());
roomName = dbClient.getString("SELECT name FROM rooms WHERE id = @roomid");
roomName = dbClient.getString("SELECT name FROM rooms WHERE id = '" + _roomID + "'");
userManager.sendToCop("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));
}
}
}
break;
#endregion
Feel free to press the thanks button