public string GetCommand(Race race, Class clss, int map, int zone, Vector3 pos)
{
var builder = new CommandBuilder("playercreateinfo");
builder.AddColumnValue("race", (int)race);
builder.AddColumnValue("class", (int)clss);
builder.AddColumnValue("map", map);
builder.AddColumnValue("zone", zone);
builder.AddColumnValue("position_x", pos.X);
builder.AddColumnValue("position_y", pos.Y);
builder.AddColumnValue("position_z", pos.Z);
return builder.BuildInsert(true);
}
public string GetCommand(uint entry, int map, int phaseMask, Vector3 pos, float orient)
{
var builder = new CommandBuilder("gameobject");
builder.AddColumnValue("id", entry);
builder.AddColumnValue("map", map);
builder.AddColumnValue("spawnMask", 1);
builder.AddColumnValue("phaseMask", phaseMask);
builder.AddColumnValue("position_x", pos.X);
builder.AddColumnValue("position_y", pos.Y);
builder.AddColumnValue("position_z", pos.Z);
builder.AddColumnValue("orientation", orient);
builder.AddColumnValue("rotation0", 0);
builder.AddColumnValue("rotation1", 0);
builder.AddColumnValue("rotation2", 0);
builder.AddColumnValue("rotation3", 0);
builder.AddColumnValue("spawntimesecs", 120);
builder.AddColumnValue("animprogress", 0);
builder.AddColumnValue("state", 1);
return builder.BuildInsert(true);
}
public string GetCommand(uint entry, int map, int phaseMask, Vector3 position, float orient)
{
var builder = new CommandBuilder("creature");
builder.AddColumnValue("id", entry);
builder.AddColumnValue("map", map);
builder.AddColumnValue("spawnMask", 1);
builder.AddColumnValue("phaseMask", "0x" + phaseMask.ToString("X8"));
builder.AddColumnValue("modelid", 0);
builder.AddColumnValue("equipment_id", 0);
builder.AddColumnValue("position_x", position.X);
builder.AddColumnValue("position_y", position.Y);
builder.AddColumnValue("position_z", position.Z);
builder.AddColumnValue("orientation", orient);
builder.AddColumnValue("spawntimesecs", 120);
builder.AddColumnValue("spawndist", 0.0f);
builder.AddColumnValue("currentwaypoint", 0);
builder.AddColumnValue("curhealth", 1);
builder.AddColumnValue("curmana", 0);
builder.AddColumnValue("DeathState", 0);
builder.AddColumnValue("MovementType", 0);
return builder.BuildInsert(true);
}
public bool Equals(Vector3 other)
{
return other.X == X && other.Y == Y && other.Z == Z;
}
