Register for your free account! | Forgot your password?

You last visited: Today at 23:27

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


[Question] in MySql Codes

Discussion on [Question] in MySql Codes within the SRO PServer Ask the Experts forum part of the SRO PServer - Discussions / Questions category.

Reply
 
Old   #1
 
elite*gold: 85
Join Date: Aug 2010
Posts: 1,249
Received Thanks: 465
[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,249
Received Thanks: 465
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,249
Received Thanks: 465
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,249
Received Thanks: 465
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
12/12/2012 - EO PServer Hosting - 7 Replies
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 Example... I Try This : insert into cq_action values (001, 002, 004,Type,0000, 'level == 255'), (002, 003, 000,1001,0000,'level += -254'),
[Question]Which MySQL manager?
03/10/2010 - CO2 PServer - Discussions / Questions - 10 Replies
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. Now my question to you guys is Which MySQL GUI Tools Navicat, SQLyog or another one? And why that MySQL GUI Tools? Hope you guys have good tips for me!
[Question] Mysql 5165
01/03/2010 - CO2 PServer - Discussions / Questions - 6 Replies
Is possivel put mysql in source 5165? is it is how i can do that?
MYSQL SERVER QUESTION? PLEASE HELP!
03/29/2008 - EO PServer Hosting - 9 Replies
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. The first thing wich is SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test'); after I press enter is says query ok.. Then I go to the next step... by putting in ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; then its says..
Error in MySql Line codes
01/13/2008 - EO PServer Hosting - 3 Replies
: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 only when I put the codes in MySql line. Is all normal, everything is working properly, but I need put these codes to can: Make a password line 32 VACHAR> Make a account with 32 lines to connect to my server. I deleted the netbar_ip as force told me, but nafthen happens.. The error is here again =/ Who can help me?!



All times are GMT +1. The time now is 23:27.


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

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