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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
INSERT INTO ts2_server_privileges (
i_sp_server_id,
s_sp_usergroup,
b_sp_AccessWebAdminServer,
b_sp_AccessTcpServer,
b_sp_AccessVoice,
b_sp_AdminRegisterPlayer,
b_sp_AdminSetServerPermissions,
b_sp_AdminAddServer,
b_sp_AdminDeleteServer,
b_sp_AdminEditServerIpPort,
b_sp_AdminEditServerWebpostUrl,
b_sp_AdminEditServerName,
b_sp_AdminEditServerWelcomeMessage,
b_sp_AdminEditServerPassword,
b_sp_AdminEditServerType,
b_sp_AdminEditServerAllodCodecs,
b_sp_AdminBanIp,
b_sp_AdminMovePlayer,
b_sp_AdminListDBUsers,
b_sp_AdminChangeOwnPassword,
b_sp_AdminChangeUserPassword,
b_sp_AdminListDBServers,
b_sp_AdminEditServerMaxUsers,
b_sp_AdminStopServer,
b_sp_AdminStartServer,
b_sp_ChannelJoinRegisterred,
b_sp_ChannelCreateRegisterred,
b_sp_ChannelCreateUnregisterred,
b_sp_ChannelCreateDefault,
b_sp_ChannelCreateSubchannels,
b_sp_ChannelCreateModerated,
b_sp_ChannelDelete,
b_sp_ChannelEditName,
b_sp_ChannelEditPassword,
b_sp_ChannelEditTopic,
b_sp_ChannelEditDescription,
b_sp_ChannelEditOrder,
b_sp_ChannelEditMaxUsers,
b_sp_ChannelEditCodec,
b_sp_ChannelJoinChannelWithoutPassword,
b_sp_PrivilegeGrantSA,
b_sp_PrivilegeGrantCA,
b_sp_PrivilegeGrantAutoOp,
b_sp_PrivilegeGrantOp,
b_sp_PrivilegeGrantAutoV,
b_sp_PrivilegeGrantV,
b_sp_PrivilegeGrantAllowRegistration,
b_sp_PrivilegeRevokeSA,
b_sp_PrivilegeRevokeCA,
b_sp_PrivilegeRevokeAutoOp,
b_sp_PrivilegeRevokeOp,
b_sp_PrivilegeRevokeAutoV,
b_sp_PrivilegeRevokeV,
b_sp_PrivilegeRevokeAllowRegistration,
b_sp_PrivilegeAdminPlayerRegister,
b_sp_PrivilegePlayerDelete,
b_sp_PrivilegeRegisterSelfByDefault,
b_sp_SendTextToAll,
b_sp_SendTextToOwnChannel,
b_sp_SendTextToAllChannel,
b_sp_SendTextToPlayer,
b_sp_KickPlayerFromServer,
b_sp_KickPlayerFromChannel,
b_sp_AllowChannelCommanderStatus
)
VALUES (
:iServerID,
:sGroup,
:bAccessWebAdminServer,
:bAccessTcpServer,
:bAccessVoice,
:bAdminRegisterPlayer,
:bAdminSetServerPermissions,
:bAdminAddServer,
:bAdminDeleteServer,
:bAdminEditServerIpPort,
:bAdminEditServerWebpostUrl,
:bAdminEditServerName,
:bAdminEditServerWelcomeMessage,
:bAdminEditServerPassword,
:bAdminEditServerType,
:bAdminEditServerAllodCodecs,
:bAdminBanIp,
:bAdminMovePlayer,
:bAdminListDBUsers,
:bAdminChangeOwnPassword,
:bAdminChangeUserPassword,
:bAdminListDBServers,
:bAdminEditServerMaxUsers,
:bAdminStopServer,
:bAdminStartServer,
:bChannelJoinRegisterred,
:bChannelCreateRegisterred,
:bChannelCreateUnregisterred,
:bChannelCreateDefault,
:bChannelCreateSubchannels,
:bChannelCreateModerated,
:bChannelDelete,
:bChannelEditName,
:bChannelEditPassword,
:bChannelEditTopic,
:bChannelEditDescription,
:bChannelEditOrder,
:bChannelEditMaxUsers,
:bChannelEditCodec,
:bChannelJoinChannelWithoutPassword,
:bPrivilegeGrantSA,
:bPrivilegeGrantCA,
:bPrivilegeGrantAutoOp,
:bPrivilegeGrantOp,
:bPrivilegeGrantAutoV,
:bPrivilegeGrantV,
:bPrivilegeGrantAllowRegistration,
:bPrivilegeRevokeSA,
:bPrivilegeRevokeCA,
:bPrivilegeRevokeAutoOp,
:bPrivilegeRevokeOp,
:bPrivilegeRevokeAutoV,
:bPrivilegeRevokeV,
:bPrivilegeRevokeAllowRegistration,
:bPrivilegeAdminPlayerRegister,
:bPrivilegePlayerDelete,
:bPrivilegeRegisterSelfByDefault,
:bSendTextToAllPlayers,
:bSendTextToOwnChannel,
:bSendTextToAllChannel,
:bSendTextToPlayer,
:bKickPlayerFromServer,
:bKickPlayerFromChannel,
:bAllowChannelCommanderStatus
) ;
|
