public string GetCommand(int questId, int idx, int objIndex, int pointX, int pointY)
{
var builder = new SQLInsert();
builder.Table = "quest_poi_points";
builder.AddValue("questId", questId);
builder.AddValue("id", idx);
builder.AddValue("x", pointX);
builder.AddValue("y", pointY);
builder.AddWhere("questId", questId);
return(builder.Build());
}
public string GetCommand(uint entry, uint map, int phaseMask, Vector3 position, float orient)
{
var builder = new SQLInsert();
builder.Table = "creature";
// If map is Eastern Kingdoms, Kalimdor, Outland, Northrend or Ebon Hold use a lower respawn time
// TODO: Rank and if npc is needed for quest kill should change spawntime aswell
var spawnTimeSecs = (map == 0 || map == 1 || map == 530 || map == 571 || map == 609) ? 120 : 7200;
var movementType = 0;
var spawnDist = (movementType == 1) ? 5 : 0;
builder.AddValue("guid", "@GUID+X");
builder.AddValue("id", entry);
builder.AddValue("map", map);
builder.AddValue("spawnMask", 1);
builder.AddValue("phaseMask", "0x" + phaseMask.ToString("X8"));
builder.AddValue("modelid", 0);
builder.AddValue("equipment_id", 0);
builder.AddValue("position_x", position.X);
builder.AddValue("position_y", position.Y);
builder.AddValue("position_z", position.Z);
builder.AddValue("orientation", orient);
builder.AddValue("spawntimesecs", spawnTimeSecs);
builder.AddValue("spawndist", spawnDist);
builder.AddValue("currentwaypoint", 0);
builder.AddValue("curhealth", 1);
builder.AddValue("curmana", 0);
builder.AddValue("MovementType", movementType);
builder.AddValue("npcflag", 0); // TODO: Check if they match updated creature_template value ?
builder.AddValue("unit_flags", 0);
builder.AddValue("dynamicflags", 0);
builder.AddWhere("guid", "@GUID+X");
builder.AddWhere("id", entry);
return(builder.Build());
}
