private static void DumpSQLs(string prefix, string fileName, Builder builder, SQLOutputFlags sqlOutput)
{
if (builder == null)
return;
var store = new SQLStore(fileName);
if (sqlOutput.HasAnyFlag(SQLOutputFlags.GameObjectTemplate))
store.WriteData(builder.GameObjectTemplate());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.GameObjectSpawns))
store.WriteData(builder.GameObjectSpawns());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.QuestTemplate))
store.WriteData(builder.QuestTemplate());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.QuestPOI))
store.WriteData(builder.QuestPOI());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureTemplate))
store.WriteData(builder.NpcTemplate());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureSpawns))
store.WriteData(builder.CreatureSpawns());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcTrainer))
store.WriteData(builder.NpcTrainer());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcVendor))
store.WriteData(builder.NpcVendor());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcText))
store.WriteData(builder.PageText());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.PageText))
store.WriteData(builder.NpcText());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.Gossip))
store.WriteData(builder.Gossip());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.Loot))
store.WriteData(builder.Loot());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.SniffData | SQLOutputFlags.SniffDataOpcodes))
store.WriteData(builder.SniffData());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.StartInformation))
store.WriteData(builder.StartInformation());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.ObjectNames))
store.WriteData(builder.ObjectNames());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureEquip))
store.WriteData(builder.CreatureEquip());
Trace.WriteLine(string.Format("{0}: Saved file to '{1}'", prefix, fileName));
store.WriteToFile();
}
public static void DumpSQL(string prefix, string fileName, SQLOutputFlags sqlOutput)
{
var units = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Unit && obj.Key.GetHighType() != HighGuidType.Pet).ToDictionary(obj => obj.Key, obj => obj.Value as Unit);
var gameObjects = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.GameObject).ToDictionary(obj => obj.Key, obj => obj.Value as GameObject);
//var pets = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Unit && obj.Key.GetHighType() == HighGuidType.Pet).ToDictionary(obj => obj.Key, obj => obj.Value as Unit);
//var players = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Player).ToDictionary(obj => obj.Key, obj => obj.Value as Player);
//var items = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Item).ToDictionary(obj => obj.Key, obj => obj.Value as Item);
foreach (var unit in units)
unit.Value.LoadValuesFromUpdateFields();
using (var store = new SQLStore(fileName))
{
if (sqlOutput.HasAnyFlag(SQLOutputFlags.GameObjectTemplate))
store.WriteData(WDBTemplates.GameObject());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.GameObjectSpawns))
store.WriteData(Spawns.GameObject(gameObjects));
if (sqlOutput.HasAnyFlag(SQLOutputFlags.QuestTemplate))
store.WriteData(WDBTemplates.Quest());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.QuestPOI))
store.WriteData(QuestMisc.QuestPOI());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureTemplate))
{
store.WriteData(WDBTemplates.Npc());
store.WriteData(UnitMisc.NpcTemplateNonWDB(units));
//store.WriteData(UnitMisc.Addon(units));
store.WriteData(UnitMisc.ModelData(units));
store.WriteData(UnitMisc.SpellsX());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureSpawns))
store.WriteData(Spawns.Creature(units));
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcTrainer))
store.WriteData(UnitMisc.NpcTrainer());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcVendor))
store.WriteData(UnitMisc.NpcVendor());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.PageText))
store.WriteData(WDBTemplates.PageText());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcText))
store.WriteData(WDBTemplates.NpcText());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.Gossip))
store.WriteData(UnitMisc.Gossip());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.Loot))
store.WriteData(UnitMisc.Loot());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.StartInformation))
store.WriteData(Miscellaneous.StartInformation());
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureEquip))
store.WriteData(UnitMisc.CreatureEquip(units));
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureMovement))
store.WriteData(UnitMisc.CreatureMovement(units));
Trace.WriteLine(store.WriteToFile()
? String.Format("{0}: Saved file to '{1}'", prefix, fileName)
: "No SQL files created -- empty.");
}
}
public static void DumpSQL(string prefix, string fileName, SQLOutputFlags sqlOutput)
{
var units = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Unit && obj.Key.GetHighType() != HighGuidType.Pet).ToDictionary(obj => obj.Key, obj => obj.Value as Unit);
var gameObjects = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.GameObject).ToDictionary(obj => obj.Key, obj => obj.Value as GameObject);
//var pets = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Unit && obj.Key.GetHighType() == HighGuidType.Pet).ToDictionary(obj => obj.Key, obj => obj.Value as Unit);
//var players = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Player).ToDictionary(obj => obj.Key, obj => obj.Value as Player);
//var items = Storage.Objects.Where(obj => obj.Value.Type == ObjectType.Item).ToDictionary(obj => obj.Key, obj => obj.Value as Item);
foreach (var unit in units)
{
unit.Value.LoadValuesFromUpdateFields();
}
using (var store = new SQLStore(fileName))
{
if (sqlOutput.HasAnyFlag(SQLOutputFlags.GameObjectTemplate))
{
store.WriteData(WDBTemplates.GameObject());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.GameObjectSpawns))
{
store.WriteData(Spawns.GameObject(gameObjects));
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.QuestTemplate))
{
store.WriteData(WDBTemplates.Quest());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.QuestPOI))
{
store.WriteData(QuestMisc.QuestPOI());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureTemplate))
{
store.WriteData(WDBTemplates.Npc());
store.WriteData(UnitMisc.NpcTemplateNonWDB(units));
//store.WriteData(UnitMisc.Addon(units));
store.WriteData(UnitMisc.ModelData(units));
store.WriteData(UnitMisc.SpellsX());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureSpawns))
{
store.WriteData(Spawns.Creature(units));
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcTrainer))
{
store.WriteData(UnitMisc.NpcTrainer());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcVendor))
{
store.WriteData(UnitMisc.NpcVendor());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.PageText))
{
store.WriteData(WDBTemplates.PageText());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.NpcText))
{
store.WriteData(WDBTemplates.NpcText());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.Gossip))
{
store.WriteData(UnitMisc.Gossip());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.Loot))
{
store.WriteData(UnitMisc.Loot());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.StartInformation))
{
store.WriteData(Miscellaneous.StartInformation());
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureEquip))
{
store.WriteData(UnitMisc.CreatureEquip(units));
}
if (sqlOutput.HasAnyFlag(SQLOutputFlags.CreatureMovement))
{
store.WriteData(UnitMisc.CreatureMovement(units));
}
Trace.WriteLine(store.WriteToFile()
? String.Format("{0}: Saved file to '{1}'", prefix, fileName)
: "No SQL files created -- empty.");
}
}