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;
}
that is my freebies npc script and i want to know if it is possible to make a query inside my script.. when i click the npc and receive my freebies i want to add new record in my sql table and is it possible to have 7 days expiration in my expiration date column(starting the day that they claim the freebies) and for the pass code will generate randomly?
please help me for this script thanks in advance
Question
Kudo
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;
}
that is my freebies npc script and i want to know if it is possible to make a query inside my script.. when i click the npc and receive my freebies i want to add new record in my sql table and is it possible to have 7 days expiration in my expiration date column(starting the day that they claim the freebies) and for the pass code will generate randomly?
Edited by aksehcplease help me for this script thanks in advance
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.