public void Blockchange1(Player p, ushort x, ushort y, ushort z, byte type)
{
p.ClearBlockchange();
CatchPos cpos = (CatchPos)p.blockchangeObject;
cpos.message = cpos.message.Replace("'", "\\'");
DataTable Messages = MySQL.fillData("SELECT * FROM `Messages" + p.level.name + "` WHERE X=" + (int)x + " AND Y=" + (int)y + " AND Z=" + (int)z);
Messages.Dispose();
if (Messages.Rows.Count == 0)
{
MySQL.executeQuery("INSERT INTO `Messages" + p.level.name + "` (X, Y, Z, Message) VALUES (" + (int)x + ", " + (int)y + ", " + (int)z + ", '" + cpos.message + "')");
}
else
{
MySQL.executeQuery("UPDATE `Messages" + p.level.name + "` SET Message='" + cpos.message + "' WHERE X=" + (int)x + " AND Y=" + (int)y + " AND Z=" + (int)z);
}
Player.SendMessage(p, "Message block placed.");
p.level.Blockchange(p, x, y, z, cpos.type);
p.SendBlockchange(x, y, z, cpos.type);
if (p.staticCommands)
{
p.Blockchange += new Player.BlockchangeEventHandler(Blockchange1);
}
}
public void showMBs(Player p)
{
p.showMBs = !p.showMBs;
DataTable Messages = new DataTable("Messages");
Messages = MySQL.fillData("SELECT * FROM `Messages" + p.level.name + "`");
int i;
if (p.showMBs)
{
for (i = 0; i < Messages.Rows.Count; i++)
{
p.SendBlockchange((ushort)Messages.Rows[i]["X"], (ushort)Messages.Rows[i]["Y"], (ushort)Messages.Rows[i]["Z"], Block.MsgWhite);
}
Player.SendMessage(p, "Now showing &a" + i.ToString() + Server.DefaultColor + " MBs.");
}
else
{
for (i = 0; i < Messages.Rows.Count; i++)
{
p.SendBlockchange((ushort)Messages.Rows[i]["X"], (ushort)Messages.Rows[i]["Y"], (ushort)Messages.Rows[i]["Z"], p.level.GetTile((ushort)Messages.Rows[i]["X"], (ushort)Messages.Rows[i]["Y"], (ushort)Messages.Rows[i]["Z"]));
}
Player.SendMessage(p, "Now hiding MBs.");
}
Messages.Dispose();
}
public override void Use(Player p, string message)
{
if (message == "")
{
Help(p); return;
}
if (message.IndexOf("'") != -1)
{
Player.SendMessage(p, "Cannot parse request."); return;
}
DataTable playerDb = MySQL.fillData("SELECT Name FROM Players WHERE IP='" + message + "'");
if (playerDb.Rows.Count == 0)
{
Player.SendMessage(p, "Could not find anyone with this IP"); return;
}
string playerNames = "Players with this IP: ";
for (int i = 0; i < playerDb.Rows.Count; i++)
{
playerNames += playerDb.Rows[i]["Name"] + ", ";
}
playerNames = playerNames.Remove(playerNames.Length - 2);
Player.SendMessage(p, playerNames);
playerDb.Dispose();
}
public override void Use(Player p, string message)
{
int bancount = Group.findPerm(LevelPermission.Banned).playerList.All().Count;
DataTable count = MySQL.fillData("SELECT COUNT(id) FROM players");
Player.SendMessage(p, "A total of " + count.Rows[0]["COUNT(id)"] + " unique players have visited this server.");
Player.SendMessage(p, "Of these players, " + bancount + " have been banned.");
count.Dispose();
int playerCount = 0;
int hiddenCount = 0;
foreach (Player pl in Player.players)
{
if (!pl.hidden || p.group.Permission > LevelPermission.AdvBuilder || Server.devs.Contains(p.name.ToLower()))
{
playerCount++;
if (pl.hidden && (p.group.Permission > LevelPermission.AdvBuilder || Server.devs.Contains(p.name.ToLower())))
{
hiddenCount++;
}
}
}
if (playerCount == 1)
{
if (hiddenCount == 0)
{
Player.SendMessage(p, "There is 1 player currently online.");
}
else
{
Player.SendMessage(p, "There is 1 player currently online (" + hiddenCount + " hidden).");
}
}
else
{
if (hiddenCount == 0)
{
Player.SendMessage(p, "There are " + playerCount + " players online.");
}
else
{
Player.SendMessage(p, "There are " + playerCount + " players online (" + hiddenCount + " hidden).");
}
}
}
