Home

Welcome to the FeedbackUI wiki!

How to get FeedbackUI fields from the database

FeedbackUI sends a JSON string to the server that is stored as a text into the character -> bugreport db table

You can use the following query (Still not complete) to extract the data and create a view:

select
`type`->>'$.text' as `text`,
`type`->>'$.addonTitle' as addonTitle,
`type`->>'$.addonVersion' as addonVersion,
`type`->>'$.name' as playerName,
`type`->>'$.race' as playerRace,
`type`->>'$.class' as playerClass,
`type`->>'$.level' as playerLevel,
`type`->>'$.realm' as realm,
`type`->>'$.reportCalendar' as reportCalendar,
`type`->>'$.reportDate' as reportDate,
`type`->>'$.reportGameTime' as reportGameTime,
`type`->>'$.reportSubjectId' as reportSubjectId,
`type`->>'$.reportSubjectType' as reportSubjectType,
`type`->>'$.reportSubjectSubType' as reportSubjectSubType,
`type`->>'$.currentWorldMapAreaId' as currentWorldMapAreaId,
`type`->>'$.currentWorldMapZoneId' as currentWorldMapZoneId,
`type`->>'$.currentWorldMapMapId' as currentWorldMapMapId,
`type`->>'$.currentDungeonMapLevel' as currentDungeonMapLevel,
`type`->>'$.currentDungeonMapLevelCount' as currentDungeonMapLevelCount,
`type`->>'$.currentCorpsePosition' as currentCorpsePosition,
`type`->>'$.currentMinimapZoneText' as currentMinimapZoneText,
`type`->>'$.currentRealZoneText' as currentRealZoneText,
`type`->>'$.currentSubZoneText' as currentSubZoneText,
`type`->>'$.currentZoneText' as currentZoneText,
`type`->>'$.currentZonePvPType' as currentZonePvPType,
`type`->>'$.currentZonePvPisFFA' as currentZonePvPisFFA,
`type`->>'$.currentZonePvPfaction' as currentZonePvPfaction,
`type`->>'$.instanceName' as instanceName,
`type`->>'$.instanceType' as instanceType,
`type`->>'$.instanceDifficultyIndex' as instanceDifficultyIndex,
`type`->>'$.instanceDifficultyName' as instanceDifficultyName,
`type`->>'$.instanceMaxPlayers' as instanceMaxPlayers,
`type`->>'$.instancePlayerDifficulty' as instancePlayerDifficulty,
`type`->>'$.instanceIsDynamic' as instanceIsDynamic,
`type`->>'$.playerGUID' as playerGUID,
`type`->>'$.playerPosition' as playerPosition,
`type`->>'$.playerIsDeadOrGhost' as playerIsDeadOrGhost,
`type`->>'$.playerMana' as playerMana,
`type`->>'$.playerManaMax' as playerManaMax,
`type`->>'$.playerIsOnTaxi' as playerIsOnTaxi,
`type` as metadata, -- Contains all other metadata that are not extracted above
`content`  -- Contains more info about the user
from bugreport
where JSON_VALID(`type`)