Regarding sa sql query para sa npc script

[Kudo]

paano po ako mag add ng new dyan sa sql gamit po ang npc script then dun po sa expire date nya possible po ba na automatic 7 days lang sya balak ko kasi sya ilagay sa freebies npc ko then gusto ko po dun sa expire date nya ay 7 days lang lahat ng mag claim ng freebies ang freebies ko po ay 1 per account lang
eto po ang script 

Spoiler

prontera,168,228,4    script    Solopack    832,{

    if(#sorry == 1) goto L_1;
    mes "You will receive Some Present as a reward for joining the server";
    mes "We're gladly thankful for your support in the future too.";
    next;
    if(checkweight(2504,1) == 0 ) goto L_OverWeight;
     getitem 3100,5;
    getitem 7227,5;
    getitem 6767,5;
    getitem 12103,10;
    getitem 13517,50;
    getitem 50000,1;
    getitem 12534,100;
    getitem 4142,1;
    getitem 4147,1;
    getitem 4302,1;    
    getitem2 1822,1,2,10,0,0,0,0,0;
    getitem2 1108,1,2,10,0,0,0,0,0;
    getitem2 1408,1,2,10,0,0,0,0,0;
    getitem2 1264,1,2,10,0,0,0,0,0;
    getitem2 1208,1,2,10,0,0,0,0,0;
    getitem2 1705,1,2,10,0,0,0,0,0;
    getitem2 1302,1,2,10,0,0,0,0,0;
    getitem2 1309,1,2,10,0,0,0,0,0;
    getitem2 1902,1,2,10,0,0,0,0,0;
    getitem2 1953,1,2,10,0,0,0,0,0;
    getitem2 13302,1,2,10,0,0,0,0,0;
    getitem2 13104,1,2,10,0,0,0,0,0;

    emotion ET_THANKS;
    set #sorry,1;
    close;

L_OverWeight:
    mes "Sorry, you are over weight";
    emotion ET_THANKS;
    close;

L_1:
    mes "You had already received before the gift.";
    emotion ET_HUK;
    close;
}

Edited July 7, 2020 by aksehc

[Kudo]

good day sir i need to know how can i put query on freebies npc to automatically send the info in my sql table here is my sql

and is it possible to do that after i receive freebies from npc the expiration date is 7 days only from the day that they click the npc. and the passcode is random generated account status remain 0
heres my freebies npc

Spoiler

prontera,168,228,4    script    Solopack    832,{

    if(#sorry == 1) goto L_1;
    mes "You will receive Some Present as a reward for joining the server";
    mes "We're gladly thankful for your support in the future too.";
    next;
    if(checkweight(2504,1) == 0 ) goto L_OverWeight;
     getitem 3100,5;
    getitem 7227,5;
    getitem 6767,5;
    getitem 12103,10;
    getitem 13517,50;
    getitem 50000,1;
    getitem 12534,100;
    getitem 4142,1;
    getitem 4147,1;
    getitem 4302,1;    
    getitem2 1822,1,2,10,0,0,0,0,0;
    getitem2 1108,1,2,10,0,0,0,0,0;
    getitem2 1408,1,2,10,0,0,0,0,0;
    getitem2 1264,1,2,10,0,0,0,0,0;
    getitem2 1208,1,2,10,0,0,0,0,0;
    getitem2 1705,1,2,10,0,0,0,0,0;
    getitem2 1302,1,2,10,0,0,0,0,0;
    getitem2 1309,1,2,10,0,0,0,0,0;
    getitem2 1902,1,2,10,0,0,0,0,0;
    getitem2 1953,1,2,10,0,0,0,0,0;
    getitem2 13302,1,2,10,0,0,0,0,0;
    getitem2 13104,1,2,10,0,0,0,0,0;

    emotion ET_THANKS;
    set #sorry,1;
    close;

L_OverWeight:
    mes "Sorry, you are over weight";
    emotion ET_THANKS;
    close;

L_1:
    mes "You had already received before the gift.";
    emotion ET_HUK;
    close;
}

thanks in advanced...