Show users rooms:
PHP Code:
#region Fr // Show's owners rooms
case "Fr":
{
using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient())
{
#region MySQL
string UserSession = dbClient.ReadString("SELECT name FROM members WHERE ip = '" + IPAddress + "'");
dbClient.AddParamWithValue("usession", UserSession);
DataTable DataQuery = dbClient.ReadDataTable("SELECT * FROM private_rooms WHERE owner = @usession;");
StringBuilder Navi = new StringBuilder();
if (DataQuery != null)
{
Navi.Append(wireEncoding.encodeVL64(5));
Navi.Append(wireEncoding.encodeVL64(1));
Navi.Append(Convert.ToChar(2));
Navi.Append(wireEncoding.encodeVL64(DataQuery.Rows.Count)); // Room count
foreach (DataRow Row in DataQuery.Rows)
{
Navi.Append(wireEncoding.encodeVL64((int)Row["id"]));
Navi.Append(wireEncoding.encodeVL64(1));
Navi.Append((string)Row["name"]);
Navi.Append(Convert.ToChar(2));
Navi.Append((string)Row["owner"]);
Navi.Append(Convert.ToChar(2));
Navi.Append(wireEncoding.encodeVL64((int)Row["room_status"]));
Navi.Append(wireEncoding.encodeVL64((int)Row["current_inroom"]));
Navi.Append(wireEncoding.encodeVL64((int)Row["max_inroom"]));
Navi.Append((string)Row["description"]);
Navi.Append(Convert.ToChar(2));
Navi.Append(wireEncoding.encodeVL64(0));
Navi.Append(wireEncoding.encodeVL64((int)Row["can_trade"]));
Navi.Append(wireEncoding.encodeVL64((int)Row["rating"]));
Navi.Append(wireEncoding.encodeVL64((int)Row["category"]));
Navi.Append("N/A"); // Date that the event started =D
Navi.Append(Convert.ToChar(2));
Navi.Append(wireEncoding.encodeVL64(0));
Navi.Append((string)Row["thumbnail"]);
Navi.Append(wireEncoding.encodeVL64(0));
}
SendMessage("GC" + Navi.ToString());
Navi.Clear();
}
}
break;
}
#endregion