SQL Script Support

[Virtue]

Hi Everybody,

 

I got another question on sql scripting.

 

I want to get a value from the login db, and add it to another db. so would this work?

 

set @nb, query_sql("select last_mac from `login` , @last_mac$);

[Emistry]

INSERT INTO `table` ( `column`,`column`,`column` ) VALUES ( data,data,data );

 

 

after you select all the data...then you can try use a loop to repeat the insert process

[Virtue]

so far what i have is this. i am making a custom referal system though, its for harmony servers only.

 

 

 

query_sql("SELECT `last_mac` FROM `login` WHERE `account_id`="+getcharid(3), .@mac$);
set .@hours,1;
query_sql "insert into rfs values ( "+ getcharid(3) +", "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ escape_sql(  .@mac$ ) +"', "+ .@hours +" ) on duplicate key update hours = hours + "+ .@hours;