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 ;
