HTML Code:
If (@TargetCharName like 'ChangeTitle' and @Message = 'captain') begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 1 where CharName16 = @SenderCharName end
If (@TargetCharName like 'ChangeTitle' and @Message = 'captain')
begin
if SRO_VT_SHARD.dbo._Char @SenderCharName Hwanlvl = 1 Then
Do Nothing
Else
update SRO_VT_SHARD.dbo._Char set HwanLevel = 1 where CharName16 = @SenderCharName
end
End
i USed To Coding in .Net i Dunno ANy Thing About SQL So
Any One Can Help Me To Make it Work ?!
Simply i wanna after Check the TargetCharName & his Msg
i wanna another Check About his Current Hwanlvl if it =1 . No Reaction or exit Sub
if his Hwan lvl =2 or moree . Update his hwan lvl with the New thing !
its a simply question about using IF statment in MySql !
So waiting Help ! <3