help with this freebies npc

[Brynner]

how to make this freebies script will only gave freebies for those account credited after account id 2000735? below that account will not be given any freebies.

 

brasilis,203,185,4	script	Freebies	112,{
	delwaitingroom;
	waitingroom "Free Item Here!",0;   // Look on the configuration!
if( !Freebies ){
set Freebies,1;
mes "Welcome...this is your gift...";
getitem2 2320,1,1,7,0,0,0,0,0; // +7 formal suit[1]
getitem2 2504,1,1,7,0,0,0,0,0; // +7 muffler[1]
getitem2 2104,1,1,7,0,0,0,0,0; // +7 buckler[1]
getitem2 2102,1,1,7,0,0,0,0,0; // +7 Guard[1]
getitem2 2404,1,1,7,0,0,0,0,0; // +7 Shoes[1]
getitem 12210, 5;
getitem 14533, 5;
getitem 12622, 1;
getitem 4142, 1;
getitem 4147, 1;
}else{
mes "You have claim the Reward already.";
}
close;
}

 

Edited August 14, 2013 by Brynner

[Patskie]

Try this one. Note that `ragnarok` is the name of the database. Change that to your database name : 

brasilis,203,185,4    script    Freebies    112,{
    delwaitingroom;
    waitingroom "Free Item Here!",0;   // Look on the configuration!
    query_sql "SELECT `account_id` FROM `ragnarok`.`char` WHERE `char_id` = '" + getcharid(0) + "'", .@id;
    if( !Freebies && ( .@id > 2000735 ) ){
        set Freebies,1;
        mes "Welcome...this is your gift...";
        getitem2 2320,1,1,7,0,0,0,0,0; // +7 formal suit[1]
        getitem2 2504,1,1,7,0,0,0,0,0; // +7 muffler[1]
        getitem2 2104,1,1,7,0,0,0,0,0; // +7 buckler[1]
        getitem2 2102,1,1,7,0,0,0,0,0; // +7 Guard[1]
        getitem2 2404,1,1,7,0,0,0,0,0; // +7 Shoes[1]
        getitem 12210, 5;
        getitem 14533, 5;
        getitem 12622, 1;
        getitem 4142, 1;
        getitem 4147, 1;
    } else {
        mes "You have claim the Reward already.";
    }
    close;
}

[Brynner]

thanks for the reply. but already got a solution.

[Emistry]

you dont really have to go through the SQL database and retrieve there information there...

 

we got getcharid ...

 

  if( !Freebies && getcharid(3) > 2000735 ){

[dhaisuke]

hi

 

you dont really have to go through the SQL database and retrieve there information there...

 

we got getcharid ...

 

  if( !Freebies && getcharid(3) > 2000735 ){

 

what is the use of 2000735?

[Emistry]

@dhaishuke

how to make this freebies script will only gave freebies for those account credited after account id 2000735? below that account will not be given any freebies.

[Checkmate]

2000735?

The number refer to id number sql on Brynner player id....