private static void GetGroupBadges(Session Session, ClientMessage Message)
{
int groupid = 1;
uint uId = Message.PopWiredUInt32();
string badge = "b1101Xs21105s21103s211342d1e378ce1b2c021cc190f58003f484d";
RoomInstance Instance = RoomManager.GetInstanceByRoomId(Session.AbsoluteRoomId);
if (Instance == null)
{
return;
}
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
DataTable Table = MySqlClient.ExecuteQueryTable("SELECT * FROM groups_details");
foreach (DataRow Row in Table.Rows)
{
groupid = (int)Row["id"];
DataRow Description = MySqlClient.ExecuteQueryRow("SELECT * FROM groups_details where id = '" + groupid + "'");
badge = Description["badge"].ToString();
ServerMessage xMessage = new ServerMessage(309);
// count
// foreach => group id
// => string/wb badge code
xMessage.AppendBoolean(true); // something
xMessage.AppendInt32(groupid); // group id
xMessage.AppendStringWithBreak(badge); //badge code
Session.SendData(xMessage);
}
}
}
private static void SendMyGroup(Session Session, ClientMessage Message)
{
uint uId = Message.PopWiredUInt32();
string badge;
string desc;
string name;
string extra = "";
string employer;
int members;
int roomid;
int groupid;
RoomInstance Instance = RoomManager.GetInstanceByRoomId(Session.AbsoluteRoomId);
if (Instance == null)
{
return;
}
using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
{
DataRow Description = MySqlClient.ExecuteQueryRow("SELECT * FROM groups_details where id = '" + Session.CharacterInfo.GroupID + "'");
badge = (string)Description["badge"];
desc = (string)Description["description"];
name = (string)Description["name"];
roomid = (int)Description["roomid"];
members = int.Parse(MySqlClient.ExecuteScalar("SELECT COUNT(*) FROM characters WHERE groupid = '" + Session.CharacterInfo.GroupID + "'").ToString());
employer = (string)Description["employer"];
}
RoomInstance WorkRoom = RoomManager.GetInstanceByRoomId(uint.Parse(roomid.ToString()));
ServerMessage xMessage = new ServerMessage(311);
// count
// foreach => group id
// => string/wb badge code
groupid = Int32.Parse(uId.ToString());
xMessage.AppendInt32(groupid); // Group ID
xMessage.AppendStringWithBreak(name); // Group Name
if (roomid >= 1)
{
extra = " at ";
}
if (WorkRoom == null || WorkRoom == RoomManager.GetInstanceByRoomId(0))
{
xMessage.AppendStringWithBreak("This user works for " + employer); // Group Desc
}
else
{
xMessage.AppendStringWithBreak("This user works for " + employer + extra + WorkRoom.Info.Name + "."); // Group Desc
}
xMessage.AppendStringWithBreak(badge); // Hash (badge) maybe lol?
xMessage.AppendInt32(-1); // Room Id
xMessage.AppendStringWithBreak(""); // Room Name
xMessage.AppendBoolean(false);
xMessage.AppendInt32(members); // Members
xMessage.AppendBoolean(false);
Session.SendData(xMessage);
}
