数据库:characters数据库:gm_ticket
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 后一修订版 | 前一修订版 | ||
| 数据库:characters数据库:gm_ticket [2023/09/24 11:51] – 创建 admin | 数据库:characters数据库:gm_ticket [2023/09/24 11:54] (当前版本) – [resolvedBy] admin | ||
|---|---|---|---|
| 行 9: | 行 9: | ||
| **表结构** | **表结构** | ||
| ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ||
| - | |[[#id|id]]|INT|UNSIGNED|PRI|NO| | | | | + | |[[#Id|Id]]|INT|UNSIGNED|PRI|NO| |Auto increment| | |
| - | |[[#gmlevel|gmlevel]]|TINYINT|UNSIGNED| |NO| | | | | + | |[[#type|type]]|TINYINT|UNSIGNED| |NO|0| |0 open, 1 closed, 2 character deleted| |
| - | |[[#RealmID|RealmID]]|INT|SIGNED|PRI|NO|-1| | | | + | |[[#playerGuid|playerGuid]]|INT|UNSIGNED| |NO|0| |Global Unique Identifier of ticket creator| |
| - | |[[# | + | |[[# |
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| + | |[[# | ||
| 行 66: | 行 83: | ||
| ==== closedBy ==== | ==== closedBy ==== | ||
| - | 0 = Open | + | * 0 = Open |
| - | -1 = Closed by Console (not implemented on azerothcore yet) | + | * <del>-1 = Closed by Console</ |
| - | 0 = player who abandoned ticket or GM who closed ticket | + | * >0 = //player who abandoned ticket or GM who closed ticket// |
| ==== assignedTo ==== | ==== assignedTo ==== | ||
| 行 84: | 行 101: | ||
| ==== completed ==== | ==== completed ==== | ||
| - | 0 = not completed | + | * 0 = not completed |
| - | 1 = completed (will inform the user and show what is in response) | + | |
| ==== escalated ==== | ==== escalated ==== | ||
| - | 0 = ticket is not currently assigned to a gm | + | * 0 = ticket is not currently assigned to a gm |
| - | 1 = ticket is assigned to a normal gm | + | |
| - | 2 = ticket has been escalated after completion (a GM is supposed to contact the player back) | + | |
| ==== viewed ==== | ==== viewed ==== | ||
| - | 0 = no one has viewed the ticket. | + | * 0 = no one has viewed the ticket. |
| - | 0 = How many times the ticket has been viewed by GMs | + | * >0 = How many times the ticket has been viewed by GMs |
| ==== needMoreHelp ==== | ==== needMoreHelp ==== | ||
| 行 102: | 行 119: | ||
| ==== resolvedBy ==== | ==== resolvedBy ==== | ||
| - | 0 = Open | + | * 0 = Open |
| - | -1 = Resolved by Console (not supported on azerothcore yet cause of datatype in DB) | + | * <del>-1 = Resolved by Console</ |
| - | 0 = Character guid of the GM who resolved it (by closing the ticket or by completing the ticket) | + | * >0 = //Character guid of the GM who resolved it (by closing the ticket or by completing the ticket)// |
数据库/characters数据库/gm_ticket.1695527466.txt.gz · 最后更改: 2023/09/24 11:51 由 admin