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;
