summaryrefslogtreecommitdiff
path: root/docs/account_muted.md
blob: d3e19c9264f376e2664e9040905cf520cc8b46f2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# account\_muted

[<-Back-to:Auth](database-auth.md)

**The \`account\_muted\` table**

This table contains account IDs whose characters are assigned a ban chat (mute).

GM-Command: **.mute [$playerName] $timeInMinutes [$reason]**.

Disable chat messaging for any character from account of character $playerName (or currently selected) at $timeInMinutes minutes. Player can be offline.

**Structure**

| Field           | Type         | Attributes | Key | Null | Default | Extra | Comment                  |
| --------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------------------------ |
| [guid][1]       | INT          | UNSIGNED   | PRI | NO   | 0       |       | Global Unique Identifier |
| [mutedate][2]   | INT          | UNSIGNED   | PRI | NO   | 0       |       |                          |
| [mutetime][3]   | INT          | UNSIGNED   |     | NO   | 0       |       |                          |
| [mutedby][4]    | VARCHAR(50)  | SIGNED     |     | NO   |         |       |                          |
| [mutereason][5] | VARCHAR(255) | SIGNED     |     | NO   |         |       |                          |

[1]: #guid
[2]: #mutedate
[3]: #mutetime
[4]: #mutedby
[5]: #mutereason

**Description of the fields**

### guid

ID of muted [account](account#id), taken from muted character. All characters on this account will be muted for [mutetime](#mutetime).

### mutedate

The date then mute started. Used UNIX timestamp.

### mutetime

Mute duration in minutes.

### mutedby

Nickname of GM/moderator who issued the mute.

#### mutereason

Text field with description of mute's reason.