/*
CREATE TABLE IF NOT EXISTS `simbang_gabi` (
`id` int(11) unsigned NOT NULL DEFAULT '0',
`aid` int(11) unsigned NOT NULL DEFAULT '0',
`day` smallint(11) unsigned NOT NULL DEFAULT '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
*/
prt_church,91,122,4 script Ignacio 110,{
set .@aid,getcharid(3);
set .@month,gettime( 6 );
set .@hour,gettime( 4 );
if ( .can_use ) {
mes "[Father Ignacio]";
mes "1. ^008800Wisdom in Parable^000000";
mes "The Mass begins and ends with the greeting: ^008800May the Lord be with you!^000000 But to most of us, it does not mean anymore than ^008800Goodbye^000000 which actually is shorthand for ^008800God be with you.^000000 The reason is that we are not so sure that God is with us. It seems to be a pious wish and nothing more.";
next;
mes "[Father Ignacio]";
mes "2. ^008800Wisdom in Christmas^000000";
mes "The Book of Wisdom describes Wisdom as Gods presence in the world, especially in human beings. It says that ^008800She reaches mightily from one end of the earth to the other, and she orders all things well.^000000 (Wis. 8:1). ";
next;
mes "[Father Ignacio]";
mes "Then, ^008800Although she is but one, she can do all things, and while remaining in herself, she renew all things; in every generation she passes into holy souls and makes them friends of God^000000 (Wis. 7:27). ";
next;
mes "[Father Ignacio]";
mes "In our Gospel reading today, Jesus is described as the ^008800Emmanuel^000000 which means ^008800God is with us^000000 (Mt. 1:23). As you heard in the Gospel, ^008800the angel of the Lord said to Joseph that Mary has conceived through the Holy Spirit and she will bear a child and he ";
next;
mes "[Father Ignacio]";
mes "is to name him Jesus because he will save his people from their sins.^000000 And this took place to fulfill what the Lord had said through the prophet: ^008800Behold, the virgin shall be with child and bear a son, and they shall name him Emmanuel^000000 which means ";
next;
mes "[Father Ignacio]";
mes "^008800God is with us^000000 (Mt. 1:20-23). Therefore, Jesus is the Emmanuel and thus he is the presence of God in the world. ";
next;
mes "[Father Ignacio]";
mes "Jesus is the Incarnate Word of the Father who lived among us and his birth is what we celebrate during Christmas. His Incarnation is very important for us because this is the fulfillment of the promise of God for he is the one who will save us, ";
next;
mes "[Father Ignacio]";
mes "the people of God, form our sins through his suffering, death and resurrection. Jesus instituted the Sacrament of the Holy Eucharist as the memorial of his paschal mystery in order to continue his presence among us. ";
next;
mes "[Father Ignacio]";
mes "3. ^008800Wisdom in our Life^000000";
mes "I told you the story about human confusion whether God is with us; then we mentioned in the Book of Wisdom that God is present in the world, especially in humans. In the Gospel, we say that Jesus as the Emmanuel is the most concrete and perfect presence ";
next;
mes "[Father Ignacio]";
mes "of God in the world because He is the Incarnate Word of God, he instituted the Eucharist and sent the Holy Spirit. As a manifestation of our faith and love for God, we should value the creation, celebrate Christmas with proper devotion, worship ";
next;
mes "[Father Ignacio]";
mes "Jesus in the Eucharist, and respect ourselves and one another. ";
next;
mes "[Father Ignacio]";
mes "To end, let us always remember that Jesus is the Emmanuel, the presence of God in the world through His Incarnation, through the Eucharist and other sacraments, and through the Holy Spirit who ^008800renews all things and passes into holy souls and makes the people friends of God.^000000";
next;
if ( Weight > (MaxWeight/2) ) {
mes "You're overweight now, please ensure your character isnt overweight.";
close;
}
query_sql( "SELECT `day` FROM `simbang_gabi` WHERE `aid` = "+.@aid+" ORDER BY `day` DESC",.@day );
set .@day_size,getarraysize( .@day );
if ( .@day[0] != .current_date ) {
mes "^0000FF* Mass ongoing *^000000";
query_sql( "INSERT INTO `simbang_gabi` VALUES ( "+gettimetick(2)+","+.@aid+","+.current_date+",NOW() )" );
}
mes "[Father Ignacio]";
mes "Thank you for attending the Mass. Bless you.";
skilleffect 34,0; // Blessing
query_sql( "SELECT COUNT( `day` ) FROM `simbang_gabi` WHERE `aid` = "+.@aid,.@count );
if ( .@count >= .consecutive_login ) {
next;
query_sql( "DELETE FROM `simbang_gabi` WHERE `aid` = "+.@aid );
mes "[Father Ignacio]";
mes "Thank you for completing the Simbang Gabi "+.consecutive_login+" Masses, ^008800"+strcharinfo(0)+"^000000. As you have completed it faithfully, here are a couple of gifts for you!";
if ( Sex ) { // male
getitem 12355,30;
getitem 12194,2;
getitem 12537,2;
getitem 12491,10;
getitem 6153,5000;
}
else { // female
getitem 12355,30;
getitem 12194,2;
getitem 12537,2;
getitem 12491,10;
getitem 6153,5000;
}
}
}
else {
mes "[Father Ignacio]";
mes "Greetings, young one!";
mes "The Simbang Gabi are scheduled on these dates:";
mes "Date: December 16~25";
mes "Time: 6PM ~ 10AM";
next;
mes "[Father Ignacio]";
mes "Be sure to attend the 9 Masses and you shall be rewarded for completing all of them.";
}
close;
OnDay1226:
disablenpc strnpcinfo(0);
end;
OnInit:
// required how many attendance
set .consecutive_login,8;
// if ( gettime( 5 ) <= 16 && gettime( 4 ) < 10 )
// end;
OnClock1800:
set .current_date,gettime( 5 );
OnClock1000:
set .@month,gettime( 6 );
set .@day,gettime( 5 );
set .@hour,gettime( 3 );
// not december / date before 16th / date == 25th but after 10AM
set .can_use,!( .@month != 12 || ( .@day == 16 && .@hour <= 10 ) || ( .@day < 15 || .@day > 25 ) || ( .@hour >= 10 && .@hour < 18 ) || ( .@day == 25 && .@hour >= 10 ) || ( .@day <= 16 && .@hour < 18 ) );
debugmes "Current: Month = "+.@month+" | Day = "+.@day+" | Hour = "+.@hour;
npctalk ""+( (.can_use)?"Simbang Gabi Mass is on-going.":"Simbang Gabi Mass is not available right now." );
end;
}