Pasted

// https://rathena.org/board/topic/107002-want-to-make-script-comeback-is-real-npc/
 
/*
ALTER TABLE `login` ADD `last_login_date` DATETIME;
UPDATE `login` SET `last_login_date` = `last_login` WHERE `last_login_date` IS NULL
*/
 
-   script  sample  -1,{
    
    OnInit:
        .day_count = 365;
        end;
        
    OnPCLoginEvent:
        // sleep2 1000;
        query_sql("SELECT DATEDIFF(CURRENT_DATE, `last_login_date`) FROM `login` WHERE `account_id` = "+getcharid(3)+" LIMIT 1", .@daycount);
        if (.@daycount && .@daycount >= .day_count && .day_count) {
            getitem 512, 1;
            getitem 512, 2;
            getitem 512, 3;
            mes "You gained rewards for comeback after "+.day_count+" day(s).";
            close;
        }
        end;
        
    OnPCLogoutEvent:
        query_sql("UPDATE `login` SET `last_login_date` = CURRENT_DATE WHERE `account_id` = "+getcharid(3)+" LIMIT 1");
        end;
}