[Question] in MySql Codes

[Eslam Galull]

i Just Wanna Edit THis Query :-

If (@TargetCharName like 'ChangeTitle' and @Message = 'captain')
 begin
update SRO_VT_SHARD.dbo._Char set HwanLevel = 1 where CharName16 = @SenderCharName
 end

SOme Thing Like THat

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

[FL0wshY]

I should kill myself after seeing that. It wouldn't change anything, It'll set his HwanLevel to 1 anyway..

[Eslam Galull]

Dude you didnt understand what i mean

i just want when he send msg to Him self with titlename which he wanna

i just wanna before give him the hwanlvl Number ( which have the title ) i wanna check his current hwan lvl .. For ex. My Non Donaters have hwan lvl 1 . i won't them change it

you got it ?!

[radde94]

Can you give the entire system instead of sending pieces?

[Eslam Galull]

Fixed >> USING BRAIN.EXE <3

[Certus]

still missing the "mysql code"

[Eslam Galull]

Originally Posted by Certus

still missing the "mysql code"

Fixed & Already Released TO Help Ppl !