Adding multiple SQL Values using insert

[Pandoras]

I'm not sure where to start but how to add multiple lines/value on SQL Insert Into.

I want to give rewards to a list of players with 3 different rewards 1 apple, 2 red potions, 30 flywings for example

I have a separate table for rewards to insert the items.

Here is my code:

set .@count, query_sql("SELECT `account_id` FROM `cp_createlog` WHERE `reg_date` BETWEEN '2017-10-24 00:00:00' AND '2017-10-26 23:59:59'", .@account_id);
set .@eventname$ = "Testing";
setarray .@prize[0],14532,14592,14001,16682,2751,12210;
setarray .@pamount[0],3,3,5,1,1,5;
for(set .i, 0; .i < getarraysize(.@count); set .i,.i+1)
for(set .j, 0; .j < getarraysize(.@prize); set .j,.j+1)
for(set .k, 0; .k < getarraysize(.@pamount); set .k,.k+1)
set .@reward$, "( .@account_id[.i], '.@eventname$', .@prize[.j], .@pamount[.k], 0)";
query_sql("INSERT INTO `event_rewards` ( `account_id`, `event_name`, `id`, `amount`, `value` ) VALUES '"+ .@reward$ +"' ");

the .@reward$ stands as the value input to the sql insert value.

how can i make .@reward$ output to something this:

( 200000, 'Testing', 14532, 3, 0),
( 200000, 'Testing', 14592, 3, 0),
( 200000, 'Testing', 14001, 5, 0),
( 200001, 'Testing', 14532, 3, 0),
( 200001, 'Testing', 14592, 3, 0),
( 200001, 'Testing', 14001, 5, 0)

how can I make this possible?

[Skorm]

query_sql("INSERT INTO `event_rewards` ( `account_id`, `event_name`, `id`, `amount`, `value` ) VALUES ( "+.@account_id[.i]+", '"+.@eventname$+"', "+.@prize[.j]+", "+.@pamount[.k]+", 0) ");

 

[Pandoras]

  On 10/30/2017 at 8:20 PM, Skorm said:

query_sql("INSERT INTO `event_rewards` ( `account_id`, `event_name`, `id`, `amount`, `value` ) VALUES ( "+.@account_id[.i]+", '"+.@eventname$+"', "+.@prize[.j]+", "+.@pamount[.k]+", 0) ");

 

Expand  

Thank you!