Compare sql informations

[Noturn]

Hello everyone, I have one doubt about sql comparisons...

So, I have one custon table like this:

 

query_sql "insert into `char_info` (`account_id`, `char_id`, `name`) values ('"+ getcharid(3) +"', '"+ getcharid(0) +"', '" + strcharinfo(0) + "')";

 

 

How can I know if the char_id on custom table is the same of who is using the script? How can I compare this two things?

Thanks.

[Emistry]

..... WHERE `char_id` = "+getcharid(0)+" ........

[Enthr]

Its done using a select and putting a WHERE like the one that Emistry do, but i really dont understand why you did this custom table, because al the information that you put there you can have it instantly in any script whitout doing a sql query, with the strcharinfo and getcharid that you just doed to put that information in the table...

in any case, if you put another thing i might understand... 

[Noturn]

Its done using a select and putting a WHERE like the one that Emistry do, but i really dont understand why you did this custom table, because al the information that you put there you can have it instantly in any script whitout doing a sql query, with the strcharinfo and getcharid that you just doed to put that information in the table...

in any case, if you put another thing i might understand... 

Well, it's because I'm trying to do @kick command on label OnPCDieEvent, but the big problem here is that it have to happend even if the player is in autotrade mode (out of the game).

 

So, I thought that maybe if I save the char information on sql it can work. I really need help with this, so if you can help me.

 

 

 

 

..... WHERE `char_id` = "+getcharid(0)+" ........

 

 

I did this:

 

if (query_sql "SELECT `char_id` FROM `char_info` WHERE `char_id` = "+getcharid(0)+""))

 

but doesn't work at all, I have tried a lot of combinations, but really doesn't work.

 

 

 

My label is like this:

 

OnPCDieEvent:

 

if (query_sql "SELECT `char_id` FROM `char_info` WHERE `char_id` = "+getcharid(0)+"")){                           //It will be true just if had found player data on sql table right?

atcommand "@kick "+getcharid(0);

}

end;

 

 

@EDIT

 

It's working, thanks guys. Source modification was needed .

Edited February 19, 2016 by Noturn

[Emistry]

it doesnt need src mod to compare in SQL query.

 

if i recall correctly, @kick should only work for char name, and not char id ?

[Noturn]

it doesnt need src mod to compare in SQL query.

 

if i recall correctly, @kick should only work for char name, and not char id ?

 

Work for both char name and char ID, i did src modification on my custom command, cause a realize that I actually don't need sql script.

 

Thanks