gm spawner

dewata,162,274,4	script	GMSPAWNER	990,{
query_sql "SELECT `group_id` FROM `login` WHERE `account_id` ="+getcharid(3),.@getgroupid;
if(.@getgroupid >3)
{
mes "Spawn Monster or Get Item";
	switch(select("Monster:Item")) {
Case 1:	mes "[ ^FF0000Enter Monster ID^000000 ]";
	mes "Refer From Ratemyserver.net";
	next;
	input .@monsterid$;
	next;
	mes "[ ^FF0000Enter Amount^000000 ]";
	next;
	input .@amount$;
	mes "[ ^FF0000Enter Map name^000000 ]";
	mes "Refer From Ratemyserver.net";
	mes "example pay_fild04";
	next;
	input .@map$;
	mes "[ ^FF0000Enter Valid Reason^000000 ]";
	mes "Be responsible with your spawning";
	next;
	input .@reason$;
	query_sql "INSERT INTO `gmspawner` (`char_id`,`gmname`,`monsterid`,`amount`,`map`,`reason`,`TimeandDate`) VALUES (" + getcharid(0) + ",'" + strcharinfo(0) + "','"+.@monsterid$+"','"+.@amount$+"','"+.@map$+"','"+.@reason$+"','" + gettimestr("%A %B %d %Y - %I:%M %p",40) + "')";
	mes "your summoning was successfull";
	monster .@Map$,0,0,"SPAWNED BY A GM",.@monsterid$,.@amount$,"GMSPAWNER::OnSpecialKill";
	close;
	end;

end;
Case 2: mes "[ ^FF0000Enter Item ID^000000 ]";
	mes "Refer From Ratemyserver.net";
	next;
	input .@itemid;
	next;
	mes "[ ^FF0000Enter Amount^000000 ]";
	next;
	input .@amount;
	mes "[ ^FF0000Enter Valid Reason^000000 ]";
	mes "Be responsible with the item your getting";
	next;
	input .@reason$;
	query_sql "INSERT INTO `gmitem` (`char_id`,`gmname`,`itemid`,`amount`,`reason`,`TimeandDate`) VALUES (" + getcharid(0) + ",'" + strcharinfo(0) + "','"+.@itemid+"','"+.@amount+"','"+.@reason$+"','" + gettimestr("%A %B %d %Y - %I:%M %p",40) + "')";
	mes "your summoning was successfull";
	getitem .@itemid,.@amount;
	close;
	end;
}
}
mes "only staffs can do transaction with me";
close;
end;

OnInit:
	query_sql("CREATE TABLE IF NOT EXISTS `gmspawner` (`char_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `gmname` varchar(255) NOT NULL DEFAULT '0', `monsterid` varchar(255) NOT NULL DEFAULT '0', `amount` varchar(255) NOT NULL DEFAULT '0', `map` varchar(255) NOT NULL DEFAULT '0', `reason` varchar(255) NOT NULL DEFAULT '0', `TimeandDate` varchar(255) NOT NULL DEFAULT '0', KEY `char_id` (`char_id`)) ENGINE=MyISAM");
	query_sql("CREATE TABLE IF NOT EXISTS `gmitem` (`char_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `gmname` varchar(255) NOT NULL DEFAULT '0', `itemid` varchar(255) NOT NULL DEFAULT '0', `amount` varchar(255) NOT NULL DEFAULT '0', `reason` varchar(255) NOT NULL DEFAULT '0', `TimeandDate` varchar(255) NOT NULL DEFAULT '0', KEY `char_id` (`char_id`)) ENGINE=MyISAM");
	end;

}