How to proper filter Gameobjects only for regular quests and reduce the respawn timer? #17110
ghost
started this conversation in
Guides & Tips
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I did something like
SELECT gq.GameObjectEntry , g.spawntimesecs , gq.ItemId FROM acore_world.gameobject g INNER JOIN gameobject_questitem gq on gq.GameObjectEntry = g.id ORDER BY spawntimesecs desc
And it gives me a list of what I assume are all the game objects related to quest collection.
So my next move would be update g.spawntimesecs to a low value, but I see there are many 60min, 45min, 30min quest item game object, so I am afraid of messing up bigger things and other events that are not regular leveling quests. All I want to achieve is to reduce the regular NPC quests the player gets while leveling, I think those >30min timers are for stuff I have no knowledge about, no regular leveling quest has 30min spawn... So how should I filter this SQL, what should be in the WHERE clause so i can safely edit only game objects that belong to leveling quests (can even include dungeon ones)?
Beta Was this translation helpful? Give feedback.
All reactions