Jump to content

Regarding sa sql query para sa npc script


Recommended Posts


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  100
  • Reputation:   0
  • Joined:  08/18/12
  • Last Seen:  

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;
}

Capture.JPG.2eace4d8d678e9cd712019b2b85f3fe6.JPG

Edited by aksehc
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  39
  • Topics Per Day:  0.01
  • Content Count:  100
  • Reputation:   0
  • Joined:  08/18/12
  • Last Seen:  

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 sqlCapture.JPG.628c09f233d1053cbdddb61809dbfbb7.JPG

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...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...