Opcodes

EQ2Emulator Development forum.

Moderator: Team Members

Post Reply
Jabantiz
Lead Developer
Posts: 2912
Joined: Wed Jul 25, 2007 2:52 pm
Location: California

Opcodes

Post by Jabantiz » Thu May 15, 2014 5:43 pm

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:
Top
User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:
Contact John Adams

Re: Opcodes

Post by John Adams » Fri May 16, 2014 1:09 pm

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".
Top
Jabantiz
Lead Developer
Posts: 2912
Joined: Wed Jul 25, 2007 2:52 pm
Location: California

Re: Opcodes

Post by Jabantiz » Fri May 16, 2014 1:50 pm

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.
Top
Post Reply

Return to “Server Development”

Who is online

Users browsing this forum: No registered users and 0 guests