[ query_sql ] How to create a data like this

[hakuren]

how can mysql receive data like char.sql i like to make a npc that has a sql function

ex. npc has categories like "Jumping, Pushing, Hiding"

when player A talks to that npc all the chosen categories will record to sql

can someone help me with this

 

sql table must like this char_id | selections

 

or tell me if this can be done or not

thank you in advance

Edited December 13, 2013 by hakuren

[AnnieRuru]

/*
create table npc_categories (
char_id int(11),
categories varchar(20)
) engine = innodb;
*/

prontera,156,189,6	script	kjdhfksdjf	100,{
	mes "blah";
	next;
	.@s = select(.menu$) -1;
	mes .string$[.@s];
	query_sql "insert into npc_categories values ( "+ getcharid(0) +", '"+ escape_sql( .string$[.@s] ) +"' )";
	close;
OnInit:
	setarray .string$, "Jumping", "Pushing", "Hiding";
	for ( .@i = 0; .@i < 3; .@i++ )
		.menu$ = .menu$ + .string$[.@i] +":";
	end;
}

start learn sql from here

http://www.w3schools.com/sql/

[Patskie]

Refer to query_sql command

[hakuren]

Refer to query_sql command

yes sir but how can i create a data like that can you make me one for example purposes please?

[15peaces]

query_sql "<your sql commandline>",<your output variable>;

...

[hakuren]

query_sql "<your sql commandline>",<your output variable>;

...

so sir how can i make a sql table? can you make me that example please

Edited December 13, 2013 by hakuren

[hakuren]

/*
create table npc_categories (
char_id int(11),
categories varchar(20)
) engine = innodb;
*/

prontera,156,189,6	script	kjdhfksdjf	100,{
	mes "blah";
	next;
	.@s = select(.menu$) -1;
	mes .string$[.@s];
	query_sql "insert into npc_categories values ( "+ getcharid(0) +", '"+ escape_sql( .string$[.@s] ) +"' )";
	close;
OnInit:
	setarray .string$, "Jumping", "Pushing", "Hiding";
	for ( .@i = 0; .@i < 3; .@i++ )
		.menu$ = .menu$ + .string$[.@i] +":";
	end;
}

start learn sql from here

http://www.w3schools.com/sql/

 

wow it works! thank you!