SQL Script support
Hi, I am making myself an SQL Script,
now, how do i insert the character name to the sql_query? tried putting the exact name there but i got an error?
INSERT INTO `points` (char_id,name,points) VALUES (150000,????,1)
will it work if i made it like this
query_sql (INSERT INTO `points` (char_id,name,points) VALUES (150000,strcharinfo(0),1))
meh only teach advance scripting techniques xD
create table test_point (
char_id int(11) unsigned primary key,
name varchar(24),
points int(11),
key (name)
) engine = innodb;
prontera,155,182,4 script kjsdfksdjfhs 100,{
query_sql "select points from test_point where char_id = "+ getcharid(0), .@points;
mes "you currently have "+ .@points +" points";
close;
OnNPCKillEvent:
if ( killedrid != 1002 ) end;
.@points = rand(10);
query_sql "insert into test_point values ( "+ getcharid(0) +", '"+
