Page 1 of 1

Opcodes

Posted: Thu May 15, 2014 5:43 pm
by Jabantiz
Just put a bunch of opcodes on the DB patcher to get rid of the missing opcode spam at startup, all were set to invalid opcode (9999), for those interested here is my sql.

Code: Select all

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_OpenCharCust", 9999),
	(839, 844, "OP_OpenCharCust", 9999),
	(908, 927, "OP_OpenCharCust", 9999),
	(1008, 1011, "OP_OpenCharCust", 9999),
	(1045, 1046, "OP_OpenCharCust", 9999),
	(1096, 1096, "OP_OpenCharCust", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_CharacterMerc", 9999),
	(839, 844, "OP_CharacterMerc", 9999),
	(908, 927, "OP_CharacterMerc", 9999),
	(1008, 1011, "OP_CharacterMerc", 9999),
	(1045, 1046, "OP_CharacterMerc", 9999),
	(1096, 1096, "OP_CharacterMerc", 9999);
	
INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_AfterInvSpellUpdate", 9999),
	(839, 844, "OP_AfterInvSpellUpdate", 9999),
	(908, 927, "OP_AfterInvSpellUpdate", 9999),
	(1008, 1011, "OP_AfterInvSpellUpdate", 9999),
	(1045, 1046, "OP_AfterInvSpellUpdate", 9999),
	(1096, 1096, "OP_AfterInvSpellUpdate", 9999);
	
INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_CharacterCreatedDungeons", 9999),
	(839, 844, "OP_CharacterCreatedDungeons", 9999),
	(908, 927, "OP_CharacterCreatedDungeons", 9999),
	(1008, 1011, "OP_CharacterCreatedDungeons", 9999),
	(1045, 1046, "OP_CharacterCreatedDungeons", 9999),
	(1096, 1096, "OP_CharacterCreatedDungeons", 9999);
	
INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_CharacterHousingList", 9999),
	(839, 844, "OP_CharacterHousingList", 9999),
	(908, 927, "OP_CharacterHousingList", 9999),
	(1008, 1011, "OP_CharacterHousingList", 9999),
	(1045, 1046, "OP_CharacterHousingList", 9999),
	(1096, 1096, "OP_CharacterHousingList", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_HouseItemsList", 9999),
	(839, 844, "OP_HouseItemsList", 9999),
	(908, 927, "OP_HouseItemsList", 9999),
	(1008, 1011, "OP_HouseItemsList", 9999),
	(1045, 1046, "OP_HouseItemsList", 9999),
	(1096, 1096, "OP_HouseItemsList", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_CharacterMounts", 9999),
	(839, 844, "OP_CharacterMounts", 9999),
	(908, 927, "OP_CharacterMounts", 9999),
	(1008, 1011, "OP_CharacterMounts", 9999),
	(1045, 1046, "OP_CharacterMounts", 9999),
	(1096, 1096, "OP_CharacterMounts", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_LoadCalendarEvents", 9999),
	(839, 844, "OP_LoadCalendarEvents", 9999),
	(908, 927, "OP_LoadCalendarEvents", 9999),
	(1008, 1011, "OP_LoadCalendarEvents", 9999),
	(1045, 1046, "OP_LoadCalendarEvents", 9999),
	(1096, 1096, "OP_LoadCalendarEvents", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_LoadWelcomeWindow", 9999),
	(839, 844, "OP_LoadWelcomeWindow", 9999),
	(908, 927, "OP_LoadWelcomeWindow", 9999),
	(1008, 1011, "OP_LoadWelcomeWindow", 9999),
	(1045, 1046, "OP_LoadWelcomeWindow", 9999),
	(1096, 1096, "OP_LoadWelcomeWindow", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_DungeonMakerItemRequest", 9999),
	(839, 844, "OP_DungeonMakerItemRequest", 9999),
	(908, 927, "OP_DungeonMakerItemRequest", 9999),
	(1008, 1011, "OP_DungeonMakerItemRequest", 9999),
	(1045, 1046, "OP_DungeonMakerItemRequest", 9999),
	(1096, 1096, "OP_DungeonMakerItemRequest", 9999);
	
INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_SysClient", 9999),
	(839, 844, "OP_SysClient", 9999),
	(908, 927, "OP_SysClient", 9999),
	(1008, 1011, "OP_SysClient", 9999),
	(1045, 1046, "OP_SysClient", 9999),
	(1096, 1096, "OP_SysClient", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_LFGGroupSearch", 9999),
	(839, 844, "OP_LFGGroupSearch", 9999),
	(908, 927, "OP_LFGGroupSearch", 9999),
	(1008, 1011, "OP_LFGGroupSearch", 9999),
	(1045, 1046, "OP_LFGGroupSearch", 9999),
	(1096, 1096, "OP_LFGGroupSearch", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_MarketPlacePrices", 9999),
	(839, 844, "OP_MarketPlacePrices", 9999),
	(908, 927, "OP_MarketPlacePrices", 9999),
	(1008, 1011, "OP_MarketPlacePrices", 9999),
	(1045, 1046, "OP_MarketPlacePrices", 9999),
	(1096, 1096, "OP_MarketPlacePrices", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_MarketFundsUpdate", 9999),
	(839, 844, "OP_MarketFundsUpdate", 9999),
	(908, 927, "OP_MarketFundsUpdate", 9999),
	(1008, 1011, "OP_MarketFundsUpdate", 9999),
	(1045, 1046, "OP_MarketFundsUpdate", 9999),
	(1096, 1096, "OP_MarketFundsUpdate", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_MarketAddFundsRequest", 9999),
	(839, 844, "OP_MarketAddFundsRequest", 9999),
	(908, 927, "OP_MarketAddFundsRequest", 9999),
	(1008, 1011, "OP_MarketAddFundsRequest", 9999),
	(1045, 1046, "OP_MarketAddFundsRequest", 9999),
	(1096, 1096, "OP_MarketAddFundsRequest", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_ZoneBgInstanceList", 9999),
	(839, 844, "OP_ZoneBgInstanceList", 9999),
	(908, 927, "OP_ZoneBgInstanceList", 9999),
	(1008, 1011, "OP_ZoneBgInstanceList", 9999),
	(1045, 1046, "OP_ZoneBgInstanceList", 9999),
	(1096, 1096, "OP_ZoneBgInstanceList", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_UIEvent", 9999),
	(839, 844, "OP_UIEvent", 9999),
	(908, 927, "OP_UIEvent", 9999),
	(1008, 1011, "OP_UIEvent", 9999),
	(1045, 1046, "OP_UIEvent", 9999),
	(1096, 1096, "OP_UIEvent", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_EQHearThreatCmd", 9999),
	(839, 844, "OP_EQHearThreatCmd", 9999),
	(908, 927, "OP_EQHearThreatCmd", 9999),
	(1008, 1011, "OP_EQHearThreatCmd", 9999),
	(1045, 1046, "OP_EQHearThreatCmd", 9999),
	(1096, 1096, "OP_EQHearThreatCmd", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_Weakness", 9999),
	(839, 844, "OP_Weakness", 9999),
	(908, 927, "OP_Weakness", 9999),
	(1008, 1011, "OP_Weakness", 9999),
	(1045, 1046, "OP_Weakness", 9999),
	(1096, 1096, "OP_Weakness", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_SavageBarInitMsg", 9999),
	(839, 844, "OP_SavageBarInitMsg", 9999),
	(908, 927, "OP_SavageBarInitMsg", 9999),
	(1008, 1011, "OP_SavageBarInitMsg", 9999),
	(1045, 1046, "OP_SavageBarInitMsg", 9999),
	(1096, 1096, "OP_SavageBarInitMsg", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_PetOptionsResponse", 9999),
	(839, 844, "OP_PetOptionsResponse", 9999),
	(908, 927, "OP_PetOptionsResponse", 9999),
	(1008, 1011, "OP_PetOptionsResponse", 9999),
	(1045, 1046, "OP_PetOptionsResponse", 9999),
	(1096, 1096, "OP_PetOptionsResponse", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_CurrentPet", 9999),
	(839, 844, "OP_CurrentPet", 9999),
	(908, 927, "OP_CurrentPet", 9999),
	(1008, 1011, "OP_CurrentPet", 9999),
	(1045, 1046, "OP_CurrentPet", 9999),
	(1096, 1096, "OP_CurrentPet", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_JournalQuestStoryline", 9999),
	(839, 844, "OP_JournalQuestStoryline", 9999),
	(908, 927, "OP_JournalQuestStoryline", 9999),
	(1008, 1011, "OP_JournalQuestStoryline", 9999),
	(1045, 1046, "OP_JournalQuestStoryline", 9999),
	(1096, 1096, "OP_JournalQuestStoryline", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_EQHearDispellCmd", 9999),
	(839, 844, "OP_EQHearDispellCmd", 9999),
	(908, 927, "OP_EQHearDispellCmd", 9999),
	(1008, 1011, "OP_EQHearDispellCmd", 9999),
	(1045, 1046, "OP_EQHearDispellCmd", 9999),
	(1096, 1096, "OP_EQHearDispellCmd", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_LikeOption", 9999),
	(839, 844, "OP_LikeOption", 9999),
	(908, 927, "OP_LikeOption", 9999),
	(1008, 1011, "OP_LikeOption", 9999),
	(1045, 1046, "OP_LikeOption", 9999),
	(1096, 1096, "OP_LikeOption", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_Launchpad", 9999),
	(839, 844, "OP_Launchpad", 9999),
	(908, 927, "OP_Launchpad", 9999),
	(1008, 1011, "OP_Launchpad", 9999),
	(1045, 1046, "OP_Launchpad", 9999),
	(1096, 1096, "OP_Launchpad", 9999),
	(1193, 1195, "OP_Launchpad", 9999),
	(1198, 1199, "OP_Launchpad", 9999),
	(1204, 1205, "OP_Launchpad", 9999),
	(1208, 1208, "OP_Launchpad", 9999),
	(57000, 57002, "OP_Launchpad", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_ClearForLandingMsg", 9999),
	(839, 844, "OP_ClearForLandingMsg", 9999),
	(908, 927, "OP_ClearForLandingMsg", 9999),
	(1008, 1011, "OP_ClearForLandingMsg", 9999),
	(1045, 1046, "OP_ClearForLandingMsg", 9999),
	(1096, 1096, "OP_ClearForLandingMsg", 9999),
	(1193, 1195, "OP_ClearForLandingMsg", 9999),
	(1198, 1199, "OP_ClearForLandingMsg", 9999),
	(1204, 1205, "OP_ClearForLandingMsg", 9999),
	(1208, 1208, "OP_ClearForLandingMsg", 9999),
	(57000, 57002, "OP_ClearForLandingMsg", 9999);

INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_RecipeListUnknown", 9999),
	(839, 844, "OP_RecipeListUnknown", 9999),
	(908, 927, "OP_RecipeListUnknown", 9999),
	(1008, 1011, "OP_RecipeListUnknown", 9999),
	(1045, 1046, "OP_RecipeListUnknown", 9999),
	(1096, 1096, "OP_RecipeListUnknown", 9999),
	(1193, 1195, "OP_RecipeListUnknown", 9999),
	(1198, 1199, "OP_RecipeListUnknown", 9999),
	(1204, 1205, "OP_RecipeListUnknown", 9999),
	(1208, 1208, "OP_RecipeListUnknown", 9999),
	(57000, 57002, "OP_RecipeListUnknown", 9999),
	(57003, 57014, "OP_RecipeListUnknown", 9999),
	(57015, 57031, "OP_RecipeListUnknown", 9999);
	
INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_DailyObjectives", 9999),
	(839, 844, "OP_DailyObjectives", 9999),
	(908, 927, "OP_DailyObjectives", 9999),
	(1008, 1011, "OP_DailyObjectives", 9999),
	(1045, 1046, "OP_DailyObjectives", 9999),
	(1096, 1096, "OP_DailyObjectives", 9999),
	(1193, 1195, "OP_DailyObjectives", 9999),
	(1198, 1199, "OP_DailyObjectives", 9999),
	(1204, 1205, "OP_DailyObjectives", 9999),
	(1208, 1208, "OP_DailyObjectives", 9999),
	(57000, 57002, "OP_DailyObjectives", 9999),
	(57003, 57014, "OP_DailyObjectives", 9999),
	(57015, 57031, "OP_DailyObjectives", 9999),
	(57032, 57047, "OP_DailyObjectives", 9999);
	
INSERT INTO `opcodes` (`version_range1`, `version_range2`, `name`, `opcode`) VALUES
	(0, 0, "OP_HeritageMsg", 9999),
	(839, 844, "OP_HeritageMsg", 9999),
	(908, 927, "OP_HeritageMsg", 9999),
	(1008, 1011, "OP_HeritageMsg", 9999),
	(1045, 1046, "OP_HeritageMsg", 9999),
	(1096, 1096, "OP_HeritageMsg", 9999),
	(1193, 1195, "OP_HeritageMsg", 9999),
	(1198, 1199, "OP_HeritageMsg", 9999),
	(1204, 1205, "OP_HeritageMsg", 9999),
	(1208, 1208, "OP_HeritageMsg", 9999),
	(57000, 57002, "OP_HeritageMsg", 9999),
	(57003, 57014, "OP_HeritageMsg", 9999),
	(57015, 57031, "OP_HeritageMsg", 9999),
	(57032, 57047, "OP_HeritageMsg", 9999),
	(57048, 57079, "OP_HeritageMsg", 9999),
	(57080, 57095, "OP_HeritageMsg", 9999),
	(57107, 57109, "OP_HeritageMsg", 9999),
	(57121, 58525, "OP_HeritageMsg", 9999);
BTW it sucked doing this :evil:

Re: Opcodes

Posted: Fri May 16, 2014 1:09 pm
by John Adams
I thought we implemented a flag to hide those invalid opcodes? I had asked Xinux to fix those years ago, but I believe his response was "they aren't bothering me".

Re: Opcodes

Posted: Fri May 16, 2014 1:50 pm
by Jabantiz
They can be hidden by setting logs right but I like to have most enabled around 5 so I can catch every thing to debug.