Release: Sader Attendance Requirement

[sader1992]

View File

Sader Attendance Requirement

---

this patch make the player must have a variable true to claim his attendance reward

 

the variable is

#Attendance_YYYYMMDD

ofc the variable change each day

this will allow you to create a script to make for example a quest that the player must do every day to claim the attendance

like for example the player must kill 500 monster before he can claim his attendance

or must gather items

or must be x level

or must player x amount of time in the day so he can claim the reward

of all the above

the file include an information script file

that have 2 function , one to set the variable and one to get the variable value (if you want to use them , just add them to your rathena/npc/other/Global_Functions.txt)

it also include 2 example quests for you to get some inspiration to create your own script

 

 

TODO: create function for gepard

 

---

• Submitter
  sader1992
• Submitted
  07/27/2019
• Category
  Source Modifications
• Video
• Content Author
  sader1992

 

[LearningRO]

nice this feature good !! for PSRO have multi client so every player must do something before claim the reward ::
thank you sader!!

[Phaige]

How to set this up.. player x amount of time in the day so he can claim the reward

 

[Badarosk0]

@sader1992 I am testing your script and sometimes it says the player has already redeemed the reward without redeeming it. I tested for 20 days and it occurred sometimes. Did you realize that?

"You have already collected your reward today." < The message appears a few times without the player redeeming it.

I created an extra check for Unique_ID when the player logs in:

 

OnPCLoginEvent:

        .@charid = 0;
        query_sql("SELECT `last_unique_id` FROM `login` WHERE `account_id` = '"+getcharid(3)+"'", .@last_unique_id$);
        query_sql("SELECT `char_id` FROM `Attendance_unique_id` WHERE `unique_id` = '"+.@last_unique_id$+"'", .@charid);
        if(.@charid != 0)
        {
            //dispbottom "Attendance has already been collected.";
        }
        else
        {        
            //dispbottom "Attendance ready to be collected.";
            query_sql("delete from `Attendance_unique_id` where `unique_id` = '"+.@last_unique_id$+"'");
            query_sql("INSERT INTO `Attendance_unique_id` (`unique_id`,`char_id`) VALUES ('"+.@last_unique_id$+"', '"+getcharid(0)+"')");
            set_attendance_requirement();
        }

end;

OnClock0001:
    query_sql "TRUNCATE TABLE `Attendance_unique_id`";
end;

 

Edited September 5, 2019 by Badarosk0

[sader1992]

15 minutes ago, Badarosk0 said:

@sader1992 I am testing your script and sometimes it says the player has already redeemed the reward without redeeming it. I tested for 20 days and it occurred sometimes. Did you realize that?

"You have already collected your reward today." < The message appears a few times without the player redeeming it.

I created an extra check for Unique_ID when the player logs in:

 

OnPCLoginEvent:

        .@charid = 0;
        query_sql("SELECT `last_unique_id` FROM `login` WHERE `account_id` = '"+getcharid(3)+"'", .@last_unique_id$);
        query_sql("SELECT `char_id` FROM `Attendance_unique_id` WHERE `unique_id` = '"+.@last_unique_id$+"'", .@charid);
        if(.@charid != 0)
        {
            //dispbottom "Attendance has already been collected.";
        }
        else
        {        
            //dispbottom "Attendance ready to be collected.";
            query_sql("delete from `Attendance_unique_id` where `unique_id` = '"+.@last_unique_id$+"'");
            query_sql("INSERT INTO `Attendance_unique_id` (`unique_id`,`char_id`) VALUES ('"+.@last_unique_id$+"', '"+getcharid(0)+"')");
            set_attendance_requirement();
        }

end;

OnClock0001:
    query_sql "TRUNCATE TABLE `Attendance_unique_id`";
end;

 

this src mode only allow the player to redeem the reward , it does not auto redeem for the player , the player must redeem the reward hem self

the script you use will allow the first account with the gepard id given to redeem the reward , and if he didn't redeem it with that account , he can't redeem it with another account , he only can redeem it with that account (the first account he login with in the day)

 

 

i will soon create a function for gepard as planed , if you don't want to wait for god knows how long , the key is this , if the player did redeem the reward , the variable #AttendanceDate would be the date of that day

[Badarosk0]

3 hours ago, sader1992 said:

this src mode only allow the player to redeem the reward , it does not auto redeem for the player , the player must redeem the reward hem self

the script you use will allow the first account with the gepard id given to redeem the reward , and if he didn't redeem it with that account , he can't redeem it with another account , he only can redeem it with that account (the first account he login with in the day)

 

 

i will soon create a function for gepard as planed , if you don't want to wait for god knows how long , the key is this , if the player did redeem the reward , the variable #AttendanceDate would be the date of that day

Yes, what I did just allowed him to click if he didn't get another account on the day. But the next day the sql table was deleted. I think what I did has nothing to do with this problem.

[Deku]

It works great, I'm looking forward to Gepard Function