Register for your free account! | Forgot your password?

You last visited: Today at 03:25

  • Please register to post and access all features, it's quick, easy and FREE!


[Question] in MySql Codes

Reply
 
Old   #1
 
elite*gold: 85
Join Date: Aug 2010
Posts: 1,248
Received Thanks: 463
[Question] in MySql Codes

i Just Wanna Edit THis Query :-


HTML Code:
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



Eslam Galull is offline  
Old 06/13/2014, 13:08   #2

 
elite*gold: 52
Join Date: Nov 2009
Posts: 201
Received Thanks: 71
I should kill myself after seeing that. It wouldn't change anything, It'll set his HwanLevel to 1 anyway..


FL0wshY is offline  
Old 06/13/2014, 13:54   #3
 
elite*gold: 85
Join Date: Aug 2010
Posts: 1,248
Received Thanks: 463
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 ?!
Eslam Galull is offline  
Old 06/14/2014, 20:29   #4
 
elite*gold: 0
Join Date: Apr 2009
Posts: 1,272
Received Thanks: 991
Can you give the entire system instead of sending pieces?


radde94 is offline  
Old 06/17/2014, 19:40   #5
 
elite*gold: 85
Join Date: Aug 2010
Posts: 1,248
Received Thanks: 463
Fixed >> USING BRAIN.EXE <3
Eslam Galull is offline  
Old 06/17/2014, 21:49   #6
 
elite*gold: 0
Join Date: Dec 2011
Posts: 498
Received Thanks: 189
still missing the "mysql code"
Certus is offline  
Old 06/20/2014, 00:29   #7
 
elite*gold: 85
Join Date: Aug 2010
Posts: 1,248
Received Thanks: 463
Quote:
Originally Posted by Certus View Post
still missing the "mysql code"
Fixed & Already Released TO Help Ppl !


Eslam Galull is offline  
Reply



« want to try making server lvl 130 - 140 | Help me with this !!! »

Similar Threads
[Question] I Have Question All, If You Know About MySql Please Visit
Hello All, I Have Question.... I Want To Make a Player Are Reborn And Get More Status... But... I Try, Its Not Working At The Level... For The...
7 Replies - EO PServer Hosting
[Question]Which MySQL manager?
Hey E*PvPs How you guys doing? Today i got a little question. I'm have a private server but im not sure about what MySQL GUI Tools i will use....
10 Replies - CO2 PServer - Discussions / Questions
[Question] Mysql 5165
Is possivel put mysql in source 5165? is it is how i can do that?
6 Replies - CO2 PServer - Discussions / Questions
MYSQL SERVER QUESTION? PLEASE HELP!
Im following forcers guide to making my own server. I have gottin to the 8th step. I have to put in a few queries in my mysql command line client....
9 Replies - EO PServer Hosting
Error in MySql Line codes
:confused: Hi Friends of Elitepvpers! Im New Here, and I facing problems with a creation of a new private server of Eudemons.. Im with problems...
3 Replies - EO PServer Hosting



All times are GMT +2. The time now is 03:25.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.