public string CreatureSpawns()
{
if (!_storage.Objects.Any(wowObject => wowObject.Value.Type == ObjectType.Unit && wowObject.Key.GetHighType() != HighGuidType.Pet))
return string.Empty;
var units = _storage.Objects.Where(wowObject => wowObject.Value.Type == ObjectType.Unit && wowObject.Key.GetHighType() != HighGuidType.Pet);
const string tableName = "creature";
uint count = 0;
units = units.OrderBy(unit => unit.Key.GetEntry());
var rows = new List<QueryBuilder.SQLInsertRow>();
foreach (var unit in units)
{
var row = new QueryBuilder.SQLInsertRow();
var creature = unit.Value;
if (Settings.AreaFilters.Length > 0)
if (!(creature.Area.ToString(CultureInfo.InvariantCulture).MatchesFilters(Settings.AreaFilters)))
continue;
row.CommentOut = creature.IsTemporarySpawn();
var spawnTimeSecs = creature.GetDefaultSpawnTime();
var movementType = 0; // TODO: Find a way to check if our unit got random movement
var spawnDist = (movementType == 1) ? 5 : 0;
row.AddValue("guid", "@GUID+" + count, noQuotes: true);
row.AddValue("id", unit.Key.GetEntry());
row.AddValue("map", creature.Map);
row.AddValue("spawnMask", 1);
row.AddValue("phaseMask", creature.PhaseMask);
row.AddValue("position_x", creature.Movement.Position.X);
row.AddValue("position_y", creature.Movement.Position.Y);
row.AddValue("position_z", creature.Movement.Position.Z);
row.AddValue("orientation", creature.Movement.Orientation);
row.AddValue("spawntimesecs", spawnTimeSecs);
row.AddValue("spawndist", spawnDist);
row.AddValue("MovementType", movementType);
row.Comment = StoreGetters.GetName(StoreNameType.Unit, (int) unit.Key.GetEntry(), false);
row.Comment += " (Area: " + StoreGetters.GetName(StoreNameType.Area, creature.Area, false) + ")";
if (row.CommentOut)
row.Comment += " - !!! might be temporary spawn !!!";
else
++count;
rows.Add(row);
}
var result = new StringBuilder();
// delete query for GUIDs
var delete = new QueryBuilder.SQLDelete(new Tuple<uint, uint>(0, count), "guid", tableName, "@GUID+");
result.Append(delete.Build());
result.Append(Environment.NewLine);
var sql = new QueryBuilder.SQLInsert(tableName, rows);
result.Append(sql.Build());
return result.ToString();
}
public string GameObjectSpawns()
{
if (!_storage.Objects.Any(wowObject => wowObject.Value.Type == ObjectType.GameObject))
return string.Empty;
var gameobjects = _storage.Objects.Where(x => x.Value.Type == ObjectType.GameObject);
const string tableName = "gameobject";
uint count = 0;
gameobjects = gameobjects.OrderBy(go => go.Key.GetEntry());
var rows = new List<QueryBuilder.SQLInsertRow>();
foreach (var gameobject in gameobjects)
{
var row = new QueryBuilder.SQLInsertRow();
var go = gameobject.Value;
if (Settings.AreaFilters.Length > 0)
if (!(go.Area.ToString(CultureInfo.InvariantCulture).MatchesFilters(Settings.AreaFilters)))
continue;
row.CommentOut = go.IsTemporarySpawn();
uint animprogress = 0;
var state = 0;
UpdateField uf;
if (go.UpdateFields.TryGetValue(UpdateFields.GetUpdateField(GameObjectField.GAMEOBJECT_BYTES_1), out uf))
{
var bytes = uf.Int32Value;
state = (bytes & 0x000000FF);
animprogress = Convert.ToUInt32((bytes & 0xFF000000) >> 24);
}
var spawnTimeSecs = go.GetDefaultSpawnTime();
row.AddValue("guid", "@GUID+" + count, noQuotes: true);
row.AddValue("id", gameobject.Key.GetEntry());
row.AddValue("map", go.Map);
row.AddValue("spawnMask", 1);
row.AddValue("phaseMask", go.PhaseMask);
row.AddValue("position_x", go.Movement.Position.X);
row.AddValue("position_y", go.Movement.Position.Y);
row.AddValue("position_z", go.Movement.Position.Z);
row.AddValue("orientation", go.Movement.Orientation);
row.AddValue("rotation0", go.Movement.Rotation.X);
row.AddValue("rotation1", go.Movement.Rotation.Y);
row.AddValue("rotation2", go.Movement.Rotation.Z);
row.AddValue("rotation3", go.Movement.Rotation.W);
row.AddValue("spawntimesecs", spawnTimeSecs);
row.AddValue("animprogress", animprogress);
row.AddValue("state", state);
row.Comment = StoreGetters.GetName(StoreNameType.GameObject, (int) gameobject.Key.GetEntry(), false);
row.Comment += " (Area: " + StoreGetters.GetName(StoreNameType.Area, go.Area, false) + ")";
if (row.CommentOut)
row.Comment += " - !!! might be temporary spawn !!!";
else
++count;
rows.Add(row);
}
var result = new StringBuilder();
// delete query for GUIDs
var delete = new QueryBuilder.SQLDelete(new Tuple<uint, uint>(0, count), "guid", tableName, "@GUID+");
result.Append(delete.Build());
result.Append(Environment.NewLine);
var sql = new QueryBuilder.SQLInsert(tableName, rows);
result.Append(sql.Build());
return result.ToString();
}