hello, i am having problem with my custom quests the problem is when i take the quest that requires me to get items + killing boss ita buggs out when you relog or put the item for the quest in bank when i do that i couldnt complete the quest its shows me in questlog that the quest is complete but the npc shows me gray question mark any solution for that ..?
-
This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev
TrinityCore Custom quest bug
- Thread starter q8rakan
- Start date
I use emudevs sql generation to create my quests and nope i dont use any C++ script for the quest
TrinityCore rev. 7c25f3cffd0c+ and yea TC world database TDB 335.61
but still its the same as TDB 60 i mean the columns
Sylica
Exalted Member
I'll make a custom quest with the generator to see if it gives me any issues. I'm still 70% sure its the generator. Lets debug the issue. Please post any errors or warnings that it gives you.
-- Update --
Can you post the structures with no data for me that are listed in the SQL query file? I'm currently not having any issues on my end. Hopefully we can find the problem and make a possible fix for it.
There should be 105 columns for quest_template.
Last edited:
Code:
CREATE TABLE `quest_template` (
`ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`QuestType` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2',
`QuestLevel` SMALLINT(3) NOT NULL DEFAULT '1',
`MinLevel` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`QuestSortID` SMALLINT(6) NOT NULL DEFAULT '0',
`QuestInfoID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`SuggestedGroupNum` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionId1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardNextQuest` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardXPDifficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardMoney` INT(11) NOT NULL DEFAULT '0',
`RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RewardDisplaySpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardSpell` INT(11) NOT NULL DEFAULT '0',
`RewardHonor` INT(11) NOT NULL DEFAULT '0',
`RewardKillHonor` FLOAT NOT NULL DEFAULT '0',
`StartItem` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RequiredPlayerKills` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIContinent` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIx` FLOAT NOT NULL DEFAULT '0',
`POIy` FLOAT NOT NULL DEFAULT '0',
`POIPriority` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardTitle` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardFactionID1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`TimeAllowed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`AllowableRaces` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`LogTitle` TEXT NULL,
`LogDescription` TEXT NULL,
`QuestDescription` TEXT NULL,
`AreaDescription` TEXT NULL,
`QuestCompletionLog` TEXT NULL,
`RequiredNpcOrGo1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`Unknown0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`ObjectiveText1` TEXT NULL,
`ObjectiveText2` TEXT NULL,
`ObjectiveText3` TEXT NULL,
`ObjectiveText4` TEXT NULL,
`VerifiedBuild` SMALLINT(5) NULL DEFAULT '0',
PRIMARY KEY (`ID`)
)
COMMENT='Quest System'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;Yup there is 105 columns
Sylica
Exalted Member
It looks the same, but lets run a check though.
Code:
SELECT ID, QuestType, QuestLevel, MinLevel, QuestSortID, QuestInfoID, SuggestedGroupNum, RequiredFactionId1, RequiredFactionId2, RequiredFactionValue1, RequiredFactionValue2, RewardNextQuest, RewardXPDifficulty, RewardMoney, RewardBonusMoney, RewardDisplaySpell, RewardSpell, RewardHonor, RewardKillHonor, StartItem, Flags, RequiredPlayerKills, RewardItem1, RewardAmount1, RewardItem2, RewardAmount2, RewardItem3, RewardAmount3, RewardItem4, RewardAmount4, ItemDrop1, ItemDropQuantity1, ItemDrop2, ItemDropQuantity2, ItemDrop3, ItemDropQuantity3, ItemDrop4, ItemDropQuantity4, RewardChoiceItemID1, RewardChoiceItemQuantity1, RewardChoiceItemID2, RewardChoiceItemQuantity2, RewardChoiceItemID3, RewardChoiceItemQuantity3, RewardChoiceItemID4, RewardChoiceItemQuantity4, RewardChoiceItemID5, RewardChoiceItemQuantity5, RewardChoiceItemID6, RewardChoiceItemQuantity6, POIContinent, POIx, POIy, POIPriority, RewardTitle, RewardTalents, RewardArenaPoints, RewardFactionID1, RewardFactionValue1, RewardFactionOverride1, RewardFactionID2, RewardFactionValue2, RewardFactionOverride2, RewardFactionID3, RewardFactionValue3, RewardFactionOverride3, RewardFactionID4, RewardFactionValue4, RewardFactionOverride4, RewardFactionID5, RewardFactionValue5, RewardFactionOverride5, TimeAllowed, AllowableRaces, LogTitle, LogDescription, QuestDescription, AreaDescription, QuestCompletionLog, RequiredNpcOrGo1, RequiredNpcOrGo2, RequiredNpcOrGo3, RequiredNpcOrGo4, RequiredNpcOrGoCount1, RequiredNpcOrGoCount2, RequiredNpcOrGoCount3, RequiredNpcOrGoCount4, RequiredItemId1, RequiredItemId2, RequiredItemId3, RequiredItemId4, RequiredItemId5, RequiredItemId6, RequiredItemCount1, RequiredItemCount2, RequiredItemCount3, RequiredItemCount4, RequiredItemCount5, RequiredItemCount6, Unknown0, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, VerifiedBuild FROM quest_template;If successful, should show this : Found rows: 9,464
Have you tried clearing your client cache and re-accepting the quest?
When doing the quest, does the server output errors?
Do you have custom items/drops?
Can you post the script you made for me to test? Just going through all the debugs I do when working with MySQL.
Last edited:
MrPixelMC
Member
After you relog, if you put the required items in bank and then get them back, does the question mark turn yellow (meaning you are able to complete the quest)?
If so, I've seen this bug happen too, not sure what is causing it but most likely it's got to do with core, I think.
yup the one u sent works without error but its shows me more than that rows cause of my custom quests i think
and yup i tried to delete cache and relog to fix it but nope didnt at the first and which script?
- - - Updated - - -
exactly that is my problem
MrPixelMC
Member
It's a TC issue I believe, I'm not really sure what causes it or how to fix it, though.
I dont know maybe its the core itself but i will try to check the source codes..
Sylica
Exalted Member
Don't know if I asked yet, but what kind of quest is it?
I ran into an issue with a few types of quest types, and want to get some more information from you, so I might be able to make a possible fix.
One I have logged, is a kill quest to retrieve an item, some but not all objective quests.
Its a quest need to kill few bosses + farming items but its take long time to do it like the boss respawn every 4 hours and the chance of the item drop low and yes i use custom boss and custom items in the quest
Sylica
Exalted Member
Yea, but I can't reproduce this at all on queue and I think this might be random. Tested this on multiple revisions of TrinityCore clean database and core. 2 of 50 custom quests I made had some issues at some point, so I dropped them and required them again with out problems.
Here are some ways of fixing these problems.
- Try compiling a clean core and database
- Try trace logging all process that are executed by the server
- Check all queries to make sure correct flags and data are present
MrPixelMC
Member
Were you using custom items in your quest? It seems like it happens randomly (most likely it's not random though, just an unknown reason), but only happens with custom items. It's happened to me before too.
Okay gonna test that