コード例 #1
0
ファイル: Builder.cs プロジェクト: Kinzcool/WowPacketParser
        public static void DumpSQL(string prefix, string fileName, string header)
        {
            var units       = Storage.Objects.IsEmpty() ? null : Storage.Objects.Where(obj => obj.Value.Item1.Type == ObjectType.Unit && obj.Key.GetHighType() != HighGuidType.Pet).ToDictionary(obj => obj.Key, obj => obj.Value.Item1 as Unit);
            var gameObjects = Storage.Objects.IsEmpty() ? null : Storage.Objects.Where(obj => obj.Value.Item1.Type == ObjectType.GameObject).ToDictionary(obj => obj.Key, obj => obj.Value.Item1 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);

            if (units != null)
            {
                foreach (var unit in units)
                {
                    unit.Value.LoadValuesFromUpdateFields();
                }
            }

            using (var store = new SQLFile(fileName))
            {
                Trace.WriteLine("01/24 - Write WDBTemplates.GameObject"); store.WriteData(WDBTemplates.GameObject());
                Trace.WriteLine("02/24 - Write Spawns.GameObject"); if (gameObjects != null)
                {
                    store.WriteData(Spawns.GameObject(gameObjects));
                }
                Trace.WriteLine("03/24 - Write WDBTemplates.Quest"); store.WriteData(WDBTemplates.Quest());
                Trace.WriteLine("04/24 - Write QuestOffer.QuestPOI"); store.WriteData(QuestMisc.QuestPOI());
                Trace.WriteLine("05/24 - Write WDBTemplates.Npc"); store.WriteData(WDBTemplates.Npc());
                Trace.WriteLine("06/24 - Write UnitMisc.NpcTemplateNonWDB"); if (units != null)
                {
                    store.WriteData(UnitMisc.NpcTemplateNonWDB(units));
                }
                Trace.WriteLine("07/24 - Write UnitMisc.Addon"); if (units != null)
                {
                    store.WriteData(UnitMisc.Addon(units));
                }
                Trace.WriteLine("08/24 - Write UnitMisc.ModelData"); if (units != null)
                {
                    store.WriteData(UnitMisc.ModelData(units));
                }
                Trace.WriteLine("09/24 - Write UnitMisc.SpellsX"); store.WriteData(UnitMisc.SpellsX());
                Trace.WriteLine("10/24 - Write UnitMisc.CreatureText"); store.WriteData(UnitMisc.CreatureText());
                Trace.WriteLine("11/24 - Write Spawns.Creature"); if (units != null)
                {
                    store.WriteData(Spawns.Creature(units));
                }
                Trace.WriteLine("12/24 - Write UnitMisc.NpcTrainer"); store.WriteData(UnitMisc.NpcTrainer());
                Trace.WriteLine("13/24 - Write UnitMisc.NpcVendor"); store.WriteData(UnitMisc.NpcVendor());
                Trace.WriteLine("14/24 - Write WDBTemplates.PageText"); store.WriteData(WDBTemplates.PageText());
                Trace.WriteLine("15/24 - Write WDBTemplates.NpcText"); store.WriteData(WDBTemplates.NpcText());
                Trace.WriteLine("16/24 - Write UnitMisc.Gossip"); store.WriteData(UnitMisc.Gossip());
                Trace.WriteLine("17/24 - Write UnitMisc.Loot"); store.WriteData(UnitMisc.Loot());
                Trace.WriteLine("18/24 - Write Miscellaneous.SniffData"); store.WriteData(Miscellaneous.SniffData());
                Trace.WriteLine("19/24 - Write Miscellaneous.StartInformation"); store.WriteData(Miscellaneous.StartInformation());
                Trace.WriteLine("20/24 - Write Miscellaneous.ObjectNames"); store.WriteData(Miscellaneous.ObjectNames());
                Trace.WriteLine("21/24 - Write UnitMisc.CreatureEquip"); if (units != null)
                {
                    store.WriteData(UnitMisc.CreatureEquip(units));
                }
                Trace.WriteLine("22/24 - Write UnitMisc.CreatureMovement"); if (units != null)
                {
                    store.WriteData(UnitMisc.CreatureMovement(units));
                }
                Trace.WriteLine("23/24 - Write QuestOffer.QuestOffers"); store.WriteData(QuestMisc.QuestOffer());
                Trace.WriteLine("24/24 - Write QuestOffer.QuestRewards"); store.WriteData(QuestMisc.QuestReward());

                Trace.WriteLine(store.WriteToFile(header)
                                    ? String.Format("{0}: Saved file to '{1}'", prefix, fileName)
                                    : "No SQL files created -- empty.");
            }
        }
コード例 #2
0
        public static void DumpSQL(string prefix, string fileName, string header)
        {
            var units       = Storage.Objects.IsEmpty() ? null : Storage.Objects.Where(obj => obj.Value.Item1.Type == ObjectType.Unit && obj.Key.GetHighType() != HighGuidType.Pet && !obj.Value.Item1.IsTemporarySpawn()).ToDictionary(obj => obj.Key, obj => obj.Value.Item1 as Unit);
            var gameObjects = Storage.Objects.IsEmpty() ? null : Storage.Objects.Where(obj => obj.Value.Item1.Type == ObjectType.GameObject).ToDictionary(obj => obj.Key, obj => obj.Value.Item1 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 obj in Storage.Objects)
            {
                obj.Value.Item1.LoadValuesFromUpdateFields();
            }

            // Ewwwww...
            var build = ClientVersion.BuildInt;

            if (!Storage.GameObjectTemplates.IsEmpty())
            {
                foreach (var obj in Storage.GameObjectTemplates)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.NpcTexts.IsEmpty())
            {
                foreach (var obj in Storage.NpcTexts)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.NpcTextsMop.IsEmpty())
            {
                foreach (var obj in Storage.NpcTextsMop)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.PageTexts.IsEmpty())
            {
                foreach (var obj in Storage.PageTexts)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.UnitTemplates.IsEmpty())
            {
                foreach (var obj in Storage.UnitTemplates)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.QuestTemplates.IsEmpty())
            {
                foreach (var obj in Storage.QuestTemplates)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.ItemTemplates.IsEmpty())
            {
                foreach (var obj in Storage.ItemTemplates)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.BroadcastTexts.IsEmpty())
            {
                foreach (var obj in Storage.BroadcastTexts)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.GameObjectTemplateDB2s.IsEmpty())
            {
                foreach (var obj in Storage.GameObjectTemplateDB2s)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }
            if (!Storage.GameObjectTemplatePositionDB2s.IsEmpty())
            {
                foreach (var obj in Storage.GameObjectTemplatePositionDB2s)
                {
                    obj.Value.Item1.VerifiedBuild = build;
                }
            }

            using (var store = new SQLFile(fileName))
            {
                // TODO: Rewrite this
                var       i   = 0;
                const int max = 33;
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.GameObject", ++i, max)); store.WriteData(WDBTemplates.GameObject());
                Trace.WriteLine(string.Format("{0}/{1} - Write Spawns.GameObject", ++i, max)); if (gameObjects != null)
                {
                    store.WriteData(Spawns.GameObject(gameObjects));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.Quest", ++i, max)); store.WriteData(WDBTemplates.Quest());
                Trace.WriteLine(string.Format("{0}/{1} - Write QuestOffer.QuestPOI", ++i, max)); store.WriteData(QuestMisc.QuestPOI());
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.Npc", ++i, max)); store.WriteData(WDBTemplates.Npc());
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.NpcName", ++i, max)); store.WriteData(WDBTemplates.NpcName());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.NpcTemplateNonWDB", ++i, max)); if (units != null)
                {
                    store.WriteData(UnitMisc.NpcTemplateNonWDB(units));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write Miscellaneous.GameObjectTemplateNonWDB", ++i, max)); if (gameObjects != null)
                {
                    store.WriteData(Miscellaneous.GameobjectTemplateNonWDB(gameObjects));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write DB2.GameObjectDB2", ++i, max)); store.WriteData(DB2.GameObjectDB2());
                Trace.WriteLine(string.Format("{0}/{1} - Write DB2.GameObjectDB2Position", ++i, max)); store.WriteData(DB2.GameObjectDB2Position());
                Trace.WriteLine(string.Format("{0}/{1} - Write DB2.CreatureDifficulty", ++i, max)); store.WriteData(DB2.CreatureDifficulty());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.Addon", ++i, max)); if (units != null)
                {
                    store.WriteData(UnitMisc.Addon(units));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.ModelData", ++i, max)); if (units != null)
                {
                    store.WriteData(UnitMisc.ModelData(units));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.SpellsX", ++i, max)); store.WriteData(UnitMisc.SpellsX());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.CreatureText", ++i, max)); store.WriteData(UnitMisc.CreatureText());
                Trace.WriteLine(string.Format("{0}/{1} - Write Spawns.Creature", ++i, max)); if (units != null)
                {
                    store.WriteData(Spawns.Creature(units, gameObjects));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.NpcTrainer", ++i, max)); store.WriteData(UnitMisc.NpcTrainer());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.NpcVendor", ++i, max)); store.WriteData(UnitMisc.NpcVendor());
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.PageText", ++i, max)); store.WriteData(WDBTemplates.PageText());
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.NpcText", ++i, max)); store.WriteData(WDBTemplates.NpcText());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.Gossip", ++i, max)); store.WriteData(UnitMisc.Gossip());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.Loot", ++i, max)); store.WriteData(UnitMisc.Loot());
                Trace.WriteLine(string.Format("{0}/{1} - Write Miscellaneous.SniffData", ++i, max)); store.WriteData(Miscellaneous.SniffData());
                Trace.WriteLine(string.Format("{0}/{1} - Write Miscellaneous.StartInformation", ++i, max)); store.WriteData(Miscellaneous.StartInformation());
                Trace.WriteLine(string.Format("{0}/{1} - Write Miscellaneous.ObjectNames", ++i, max)); store.WriteData(Miscellaneous.ObjectNames());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.CreatureEquip", ++i, max)); if (units != null)
                {
                    store.WriteData(UnitMisc.CreatureEquip(units));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.CreatureMovement", ++i, max)); if (units != null)
                {
                    store.WriteData(UnitMisc.CreatureMovement(units));
                }
                Trace.WriteLine(string.Format("{0}/{1} - Write QuestOffer.QuestOffers", ++i, max)); store.WriteData(QuestMisc.QuestOffer());
                Trace.WriteLine(string.Format("{0}/{1} - Write QuestOffer.QuestRewards", ++i, max)); store.WriteData(QuestMisc.QuestReward());
                Trace.WriteLine(string.Format("{0}/{1} - Write WDBTemplates.Item", ++i, max)); store.WriteData(WDBTemplates.Item());
                Trace.WriteLine(string.Format("{0}/{1} - Write UnitMisc.PointsOfInterest", ++i, max)); store.WriteData(UnitMisc.PointsOfInterest());
                Trace.WriteLine(string.Format("{0}/{1} - Write DB2.BroadcastText", ++i, max)); store.WriteData(DB2.BroadcastText());
                Trace.WriteLine(string.Format("{0}/{1} - Write Miscellaneous.DefenseMessage", ++i, max)); store.WriteData(Miscellaneous.DefenseMessage());

                Trace.WriteLine(store.WriteToFile(header)
                    ? String.Format("{0}: Saved file to '{1}'", prefix, fileName)
                    : "No SQL files created -- empty.");
            }
        }
コード例 #3
0
ファイル: Builder.cs プロジェクト: Undergarun/StrawberryTools
        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.");
            }
        }