//Script Name: Guild Package NPC Giver
//Developer: ShogS
//Description:  This NPC will Give a Package for each Guild Member take Note: this NPC will record each player IP address to avoid abuse on players side by getting 2 Package in 1 IP
//Version: 1.0
//Some Explanation: Do not forget to set the items to a not tradeable Sample: 17638,91,99 = Can not be droped,sell,trade

//======================================================================================================
// - SQL TABLE
/*
CREATE TABLE IF NOT EXISTS `guildpack` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL default '0',
  `name` varchar(23) NOT NULL default '',
  `last_ip` varchar(100) NOT NULL default '',
  PRIMARY KEY (`account_id`),
  KEY (`id`)
) ENGINE=MyISAM;
*/
//======================================================================================================

map,x,x,x	script	GPack NPC	x,{

set .@frnd2$,strcharinfo(0);
if(##Gpack == 1) goto L_AG;
	mes "Hello There it seems you are belong to a Guild";
	mes "On our Server Let me Give you A Present for Joining and";
	mes "Playing On Our Server We Hope You will enjoy this Present";
	next;
	mes "These present are not tradable and not dropable";
	next;
	switch(select("Yes:No")) {
			case 1:

				query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lip$);	// recruits ip address
				query_sql("SELECT last_ip FROM `guildpack`", .@flip$);	// recruiter ip address and information
				if ( .@lip$ == .@flip$ ) {
					mes "^616D7EIt seems you and your Guild Mates are from IP Address: ^ff0000" + .@flip$ + "^000000. Sorry, but its not allowed.";
					close;
				}
				query_sql("INSERT INTO `guildpack` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lip$ + "')");
				
				//THIS PART WERE all items they will get

				getitem2 17638,1,1,8,0,0,0,0,0;
				getitem2 17639,1,1,8,0,0,0,0,0;
				getitem2 17640,1,1,8,0,0,0,0,0;
				getitem 17641,1;
				getitem2 17642,1,1,8,0,0,0,0,0;
				getitem 2449,1;
				getitem 17620,5;
				getitem 12202,20;
				getitem 12203,20;
				getitem 12204,20;
				getitem 12206,20;
				getitem 12207,20;
				set ##Gpack, 1;
				warp "prontera",157,157;
				close;

			case 2:
				mes "^616D7ENevermind~, You can come back again!";
				close;
		}end;

L_AG:
	mes "^616D7EYou Already Given a Package";
	close;

}

//==JUST RENAME or PLACE the Map Name here===//

mapname	mapflag	nocommand	99
mapname	mapflag	restricted	6
mapname	mapflag	nosave	SavePoint
mapname	mapflag	nomemo
mapname	mapflag	noreturn
mapname	mapflag	nobranch
mapname	mapflag	noloot
mapname	mapflag	noskill
mapname	mapflag	novending
mapname	mapflag	nowarpto	99