How remove only '/set' on Status 32

[[GM]Precious]

Hi,

I would like to remove the '/set' command only on Status 32.

Im Using [dbo].[usp_Insert_Chat_Log_E].
Replacing '/set' to 'any text' before it is processed.

Here is what I've done something wrong that is why its not working.

DECLARE @userstat smallint
DECLARE @usercmd varchar(128)

SELECT @userstat=Status FROM PS_UserData.dbo.Users_Master WHERE @UserUID=UserUID

IF (@userstat = 32)
BEGIN
SELECT @ChatData=ChatData,@CharID=CharID FROM inserted
SELECT @usercmd= SUBSTRING(@ChatData,0, CHARINDEX(' ',@ChatData))
IF (@usercmd='/set')
BEGIN
SET @ChatData = 'Not Allowed Command'
END
END

Anyone can point me to the right direction?

[nubness]

EP4.5 ps_game.exe:
00471F57 - cmp byte ptr [ebx+00005768],02

EP5.4 ps_game.exe:
00480D40 - cmp byte ptr [esi+00005808],02

DB Status	ps_game Status
16	1
32	2
48	3
64	4
80	5
0	11

[[GM]Precious]

Originally Posted by nubness

EP4.5 ps_game.exe:
00471F57 - cmp byte ptr [ebx+00005768],02

EP5.4 ps_game.exe:
00480D40 - cmp byte ptr [esi+00005808],02

Thank you Nubness!

I did on the following but can't figure it out.

[ENABLE]
alloc(newmem,2048)
label(returnhere)
label(originalcode)
label(exit)

newmem:
cmp byte ptr [ebx+00005768],02
je 00471F57

originalcode:
cmp byte ptr [ebx+00005768],02

exit:
jmp returnhere

00471F57:
nop
nop
returnhere:

[DISABLE]
dealloc(newmem)
00471F57:
cmp byte ptr [ebx+00005768],02

[nubness]

[ENABLE]

00471F57:
cmp byte ptr [ebx+00005768],01

[DISABLE]

00471F57:
cmp byte ptr [ebx+00005768],02

or

[ENABLE]

00471F5D:
db 01

[DISABLE]

00471F5D:
db 02

[[GM]Precious]

Brilliant! Can't say anything else but thanks a LOT.