View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000008Return of ReckoningGeneralpublic2023-08-13 02:202023-08-13 02:20
ReporterReturnOfReckoning Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionopen 
Summary0000008: Quests with items that must be clicked
DescriptionReporter: JeFawk

- Ported issue
- Created by nalgol

Fix for Quests that need items to be clicked
2 things need to be done in sql:
1. update the `objcetid` in `questsobjectivs` to match the clickable item
   like
   `UPDATE test.quests_objectives SET ObjID='561' WHERE Guid='2783';`
2. to make the item clickable its kind of a hack
   change `Unks` from `7680 0 14080 1312 706 563` to `7680 1 18079 1316 1228 19835`
   like
   `UPDATE test.gameobject_protos SET Unks='7680 1 18079 1316 1228 19835' WHERE Entry='561';`

The example is fromthe Destruction quest Pillaging, first quest hub.

http://youtu.be/edPFurEBcqk
TagsDatabase, Quests

Activities

ReturnOfReckoning

ReturnOfReckoning

2023-08-13 02:20

reporter   ~0000024

Commenter: JeFawk

- Ported comment
- Created by MaxHayman

The object spawn info will be good :) However the quest object thing seems confusing, i'm gonna have a read through it some time. To see if we don't have to modify any of the quest db info. Or does this fix all the object quests?
ReturnOfReckoning

ReturnOfReckoning

2023-08-13 02:20

reporter   ~0000025

Commenter: JeFawk

- Ported comment
- Created by nalgol

the c# code fixes all quests of that type however we need to check all questconditions since all `object_ids` never match with the `gameobject_protos entry (id)` its no biggy though with my tool
ReturnOfReckoning

ReturnOfReckoning

2023-08-13 02:20

reporter   ~0000026

Commenter: JeFawk

- Ported comment
- Created by MaxHayman

Ok. Ive implemented this the proper way (havent commited yet). Although there is 1 problem, when we sniffed the gameobejects we don't get their id, so we will manually have to change the to the correct object in the database. And with some objects behind doors this can get somewhat annoying.

Issue History

Date Modified Username Field Change
2023-08-13 02:20 ReturnOfReckoning New Issue
2023-08-13 02:20 ReturnOfReckoning Tag Attached: Database
2023-08-13 02:20 ReturnOfReckoning Tag Attached: Quests
2023-08-13 02:20 ReturnOfReckoning Note Added: 0000024
2023-08-13 02:20 ReturnOfReckoning Note Added: 0000025
2023-08-13 02:20 ReturnOfReckoning Note Added: 0000026
2023-08-13 02:20 ReturnOfReckoning Status new => closed