/*
CREATE TABLE IF NOT EXISTS `E-Donation` (
	`id` int(11) NOT NULL auto_increment,
	`donor_name` varchar(30) NOT NULL default '',
	`item` tinyint(3) unsigned NOT NULL default '0',
	`status` tinyint(2) NOT NULL default '0',
	PRIMARY KEY  (`id`)
) ENGINE=MyISAM;
*/

prontera,155,171,5	script	Donation Claimer	757,{
mes "This is where you claim POD Tickets from DONATIONS. Remember to use your MAIN CHARACTER you indicated in your DONATION EMAIL or FAX when talking to me. All Donations are process everyday";
next;
switch( select( "Claim Donation",( getgmlevel() < 0 )?"":"Add New Donor" ) ){
	Case 1:
		if( query_sql( "SELECT `item` FROM `E-Donation` WHERE `donor_name`='"+escape_sql(strcharinfo(0))+"' AND `status` = '0'",.@item ) ){
			mes "Claim all donation items ?";
			for( set .@i,0; .@i < getarraysize( .@item ); set .@i,.@i + 1 )
				mes "^777777"+.donation$[.@item[.@i]]+"^000000";
			if( select("Claim All:Cancel") == 1 ){
				for( set .@i,0; .@i < getarraysize( .@item ); set .@i,.@i + 1 )
					switch( .@item[.@i] ){
						Case 0: getitem 7227,1; break;	// Donation 1
						Case 1: getitem 7227,3; break;	// Donation 2
						Case 2: getitem 7227,4; break;	// Donation 3
						Case 3: getitem 7227,2; break;	// Donation 4
						Case 4: getitem 7227,2; break;	// Promotion 1
						Case 5: getitem 7227,2; break;	// Promotion 2
						default:
							debugmes "Error Donation Item Code # "+.@item[.@i]+"";
							break;
					}
				query_sql( "UPDATE `E-Donation` SET `status`='1' WHERE `donor_name`='"+escape_sql(strcharinfo(0))+"' AND `status` = '0'" );
			}

		}else{
			mes "Sorry, you don't have any POD on pending.";
		}
		break;

	Case 2:
		mes "Please input new  Donor Char name :";
		input .@name$;
		set .@donation,select( .donation_menu$ ) - 1;
		next;
		mes "Donor Name : ";
		mes "^0055FF ~ "+.@name$+"^000000";
		mes "Donation Item : ";
		mes "^0055FF ~ "+.donation$[.@donation]+"^000000";
		if( select("Confirm:Cancel") == 1 ){
			mes "Added Successfully.";
			query_sql( "INSERT INTO `E-Donation` ( `donor_name`,`item` ) VALUES ( '"+escape_sql(.@name$)+"','"+.@donation+"' ) ");
		}
	default: break;
}
close;

OnInit:
waitingroom "Claim your Donation here",0;

// donation name
setarray .donation$[0],"Donation 1","Donation 2","Donation 3","Donation 4","Promotion 1","Promotion 2";


// dont edit belows...
set .donation_size,getarraysize( .donation$ );
for( set .@i,0; .@i < .donation_size; set .@i,.@i + 1 )
	set .donation_menu$,.donation_menu$ + .donation$[.@i] + ":";
end;

}