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
|
UPDATE ts2_server_privileges
SET b_sp_AccessWebAdminServer = :bAccessWebAdminServer,
b_sp_AccessTcpServer = :bAccessTcpServer,
b_sp_AccessVoice = :bAccessVoice,
b_sp_AdminRegisterPlayer = :bAdminRegisterPlayer,
b_sp_AdminSetServerPermissions = :bAdminSetServerPermissions,
b_sp_AdminAddServer = :bAdminAddServer,
b_sp_AdminDeleteServer = :bAdminDeleteServer,
b_sp_AdminEditServerIpPort = :bAdminEditServerIpPort,
b_sp_AdminEditServerWebpostUrl = :bAdminEditServerWebpostUrl,
b_sp_AdminEditServerName = :bAdminEditServerName,
b_sp_AdminEditServerWelcomeMessage = :bAdminEditServerWelcomeMessage,
b_sp_AdminEditServerPassword = :bAdminEditServerPassword,
b_sp_AdminEditServerType = :bAdminEditServerType,
b_sp_AdminEditServerAllodCodecs = :bAdminEditServerAllodCodecs,
b_sp_AdminBanIp = :bAdminBanIp,
b_sp_AdminMovePlayer = :bAdminMovePlayer,
b_sp_AdminListDBUsers = :bAdminListDBUsers,
b_sp_AdminChangeOwnPassword = :bAdminChangeOwnPassword,
b_sp_AdminChangeUserPassword = :bAdminChangeUserPassword,
b_sp_AdminListDBServers = :bAdminListDBServers,
b_sp_AdminEditServerMaxUsers = :bAdminEditServerMaxUsers,
b_sp_AdminStopServer = :bAdminStopServer,
b_sp_AdminStartServer = :bAdminStartServer,
b_sp_ChannelJoinRegisterred = :bChannelJoinRegisterred,
b_sp_ChannelCreateRegisterred = :bChannelCreateRegisterred,
b_sp_ChannelCreateUnregisterred = :bChannelCreateUnregisterred,
b_sp_ChannelCreateDefault = :bChannelCreateDefault,
b_sp_ChannelCreateSubchannels = :bChannelCreateSubchannels,
b_sp_ChannelCreateModerated = :bChannelCreateModerated,
b_sp_ChannelDelete = :bChannelDelete,
b_sp_ChannelEditName = :bChannelEditName,
b_sp_ChannelEditPassword = :bChannelEditPassword,
b_sp_ChannelEditTopic = :bChannelEditTopic,
b_sp_ChannelEditDescription = :bChannelEditDescription,
b_sp_ChannelEditOrder = :bChannelEditOrder,
b_sp_ChannelEditMaxUsers = :bChannelEditMaxUsers,
b_sp_ChannelEditCodec = :bChannelEditCodec,
b_sp_ChannelJoinChannelWithoutPassword = :bChannelJoinChannelWithoutPassword,
b_sp_PrivilegeGrantSA = :bPrivilegeGrantSA,
b_sp_PrivilegeGrantCA = :bPrivilegeGrantCA,
b_sp_PrivilegeGrantAutoOp = :bPrivilegeGrantAutoOp,
b_sp_PrivilegeGrantOp = :bPrivilegeGrantOp,
b_sp_PrivilegeGrantAutoV = :bPrivilegeGrantAutoV,
b_sp_PrivilegeGrantV = :bPrivilegeGrantV,
b_sp_PrivilegeGrantAllowRegistration = :bPrivilegeGrantAllowRegistration,
b_sp_PrivilegeRevokeSA = :bPrivilegeRevokeSA,
b_sp_PrivilegeRevokeCA = :bPrivilegeRevokeCA,
b_sp_PrivilegeRevokeAutoOp = :bPrivilegeRevokeAutoOp,
b_sp_PrivilegeRevokeOp = :bPrivilegeRevokeOp,
b_sp_PrivilegeRevokeAutoV = :bPrivilegeRevokeAutoV,
b_sp_PrivilegeRevokeV = :bPrivilegeRevokeV,
b_sp_PrivilegeRevokeAllowRegistration = :bPrivilegeRevokeAllowRegistration,
b_sp_PrivilegeAdminPlayerRegister = :bPrivilegeAdminPlayerRegister,
b_sp_PrivilegePlayerDelete = :bPrivilegePlayerDelete,
b_sp_PrivilegeRegisterSelfByDefault = :bPrivilegeRegisterSelfByDefault,
b_sp_SendTextToAll = :bSendTextToAllPlayers,
b_sp_SendTextToAllChannel = :bSendTextToAllChannel,
b_sp_SendTextToOwnChannel = :bSendTextToOwnChannel,
b_sp_SendTextToPlayer = :bSendTextToPlayer,
b_sp_KickPlayerFromServer = :bKickPlayerFromServer,
b_sp_KickPlayerFromChannel = :bKickPlayerFromChannel,
b_sp_AllowChannelCommanderStatus = :bAllowChannelCommanderStatus
WHERE i_sp_server_id = :iServerID
AND s_sp_usergroup = :sGroup ;
|
