Mango, can you code the gang commands pls? They are partly done in phoenix cms 2.0 but not finished. So i dunno what to do with them tbh. Wuld be nice if you could complete, or any others. SuperBoogie said he was going to do it, but if you can do it right this minute, would be better
#region :ganginvite <user>
case "ganginvite":
{
virtualUser User = userManager.getUser(args[1]);
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
dbClient.runQuery("SELECT id FROM gang WHERE id = '" + User.userID + "'");
}
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
dbClient.runQuery("SELECT name FROM gangs WHERE id = '" + "gangdata" + "'");
dbClient.runQuery("SELECT owner FROM gangs WHERE id = '" + "gangdata" + "'");
dbClient.runQuery("SELECT id FROM gangs WHERE id = '" + "gangdata" + "'");
dbClient.runQuery("INSERT INTO gangmembers(gangid,uid,iscurrent,id) VALUES ('" + "gangdata" + "','" + _Username + "','0','" + userID + "')");
}
User.sendData("BK" + "You have recieved Request From " + _Username + " to their gang to accept type :gangaccept <gangname>!" + Convert.ToChar(2));
sendData("BK" + "You have successfully sent a request for " + User._Username + " to join your gang." + Convert.ToChar(2));
Room.Refresh(roomUser);
User.refreshAppearance(true, true, true);
User.refreshValueables(true, false);
break;
}
#endregion
#region :gangaccept
case "gangaccept":
{
virtualUser User = userManager.getUser(args[1]);
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
dbClient.runQuery("SELECT id FROM gang WHERE id = '" + User.userID + "'");
dbClient.runQuery("SELECT name FROM gangs WHERE id = '" + "gangdata" + "'");
dbClient.runQuery("SELECT owner FROM gangs WHERE id = '" + "gangdata" + "'");
dbClient.runQuery("SELECT id FROM gangs WHERE id = '" + "gangdata" + "'");
dbClient.runQuery("UPDATE gangmembers SET iscurrent = '1' WHERE id = '" + User.userID + "'");
}
sendData("BK" + "You've succesfully added" + User._Username + " to your Gang." + Convert.ToChar(2));
Room.sendSaying(roomUser, "*Joins " + User._Username + "gang*");
Room.Refresh(roomUser);
User.refreshAppearance(true, true, true);
User.refreshValueables(true, false);
break;
}
#endregion
#region :gangform <name>
case "gangform":
{
string Message = Text.Substring(10);
virtualUser User = userManager.getUser(args[1]);
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
dbClient.runQuery("INSERT INTO gang(owner,name,id) VALUES ('" + _Username + "','" + Message + "','" + userID + "')");
dbClient.runQuery("INSERT INTO gangmembers(gangid,uid,iscurrent,id) VALUES ('" + userID + "','" + _Username + "','1','" + userID + "')");
}
sendData("BK" + "You Have Formed Gang " + Message + " If Your Name Is Missing First Letter Say :deletegang And Put 2 Spaces Bettween :gangform And Your Chosen Name!. " + Convert.ToChar(2));
Room.sendSaying(roomUser, "*" + _Username + " Just Formed Gang Called " + Message + "*");
break;
}
#endregion
#region :gangdelete
case "gangdelete":
{
string Message = Text.Substring(10);
virtualUser User = userManager.getUser(args[1]);
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
dbClient.runQuery("DELETE FROM gang WHERE id = '" + userID + "' LIMIT 1");
}
sendData("BK" + "You Have Your Deleted Gang." + Convert.ToChar(2));
Room.sendSaying(roomUser, "*" + _Username + " Just Deleted His Gang*");
break;
}
#endregion