/*

CREATE TABLE IF NOT EXISTS `gm_reward` (
	`id` int(11) unsigned NOT NULL auto_increment,
	`name` varchar(24) NOT NULL default '',
	`nameid` int(11) unsigned NOT NULL default '0',
	`amount` int(11) unsigned NOT NULL default '0',
	`time` datetime NOT NULL default '0000-00-00 00:00:00',
	PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

*/

prontera,155,181,5	script	Sample#reward	757,{
mes "I am rewarder.";
next;
switch( select( "Claim Reward",( getgmlevel() < 99 )?"":"[GM] Sent Reward" ) ){
	case 1:
		query_sql( "SELECT `id`,`nameid`,`amount` FROM `gm_reward` WHERE `time` = '0000-00-00 00:00:00' LIMIT 10",.@id,.@nameid,.@amount );
		set .@size,getarraysize( .@id );
		if( .@size ){
			for( set .@i,0; .@i < .@size; set .@i,.@i + 1 )
				set .@menu$,.@menu$ + getitemname( .@nameid[.@i] )+" x "+.@amount[.@i] +":";
			set .@i,select( .@menu$ ) - 1;
			mes "Claim "+getitemname( .@nameid[.@i] )+" x "+.@amount[.@i]+" ?";
			if( select( "Yes","No" ) == 1 ){
				getitem .@nameid[.@i],.@amount[.@i];
				mes "You gained item.";
				query_sql( "UPDATE `gm_reward` SET `time` = NOW() WHERE `id` = "+.@id[.@i] );
			}
		}
		else{
			mes "You dont have any reward.";
		}
		break;
	case 2:
		mes "Enter Player Name :";
		while( input( .@player$,4,24 ) );
		mes "Pick an Item:";
		set .@item,select( .item_menu$ ) - 1;
		mes "How many "+getitemname( .item_list[.@item] )+" ? ";
		input .@amount,0,30000;
		if( .@amount )
			if( select( "Confirm Reward??","Cancel" ) == 1 ){
				query_sql( "INSERT INTO `gm_reward` ( `name`,`nameid`,`amount` ) VALUES ( '"+escape_sql( .@player$ )+"',"+.item_list[.@item]+","+.@amount+" )" );
				mes "Reward sent.";
				message .@player$,"You received a Reward.";
			}
	default: break;
}
close;

OnInit:
// list of item sent by GM.
setarray .item_list,512,607,608,501,502;

set .@item_list_size,getarraysize( .item_list );
for( set .@i,0; .@i < .@item_list_size; set .@i,.@i + 1 )
	set .item_menu$,.item_menu$ + getitemname( .item_list[.@i] ) +":";
end;
}