gm_subsurvey
Stores results of individual GM-Survey questions. worldserver.conf setting
GM.TicketSystem.ChanceOfGMSurveymust be > 0 to allow for surveys.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| surveyId | int | unsigned | PRI | NO | auto_increment | ||
| questionId | int | unsigned | PRI | NO | 0 | ||
| answer | int | unsigned | NO | 0 | |||
| answerComment | text | NO | |||||
Description of fields
surveyId
references gm_survey.surveyId.
questionId
GMSurveyQuestion ID Should be limited to questions defined by mainSurvey, pointing to GMSurveySurveys ID
answer
A GMSurveyAnswers SortIndex limited by questionId. (Range: 0 – 11)
answerComment
A player composed comment.