Utility: Guild Pack Giver

[ShogS]

File Name: Guild Pack Giver

File Submitter: ShogS

File Submitted: 05 Sep 2012

File Category: Utilities

Content Author: ShogS

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.

Click here to download this file

[Mad Walker]

Hey bro is it possible that the npc will check if the player has a guild or not?

Edited September 7, 2012 by Qube Eks

[ShogS]

Hey bro is it possible that the npc will check if the player has a guild or not?

No sir. all you need to do is to recall the guild who needs a Package. and the only person who can do that in that map is the Admin only. so first if you required a Guild should consist 10+ members so you need to count them first before recalling them.

Suggestions are appreciated. for Script Updates

[Bin4ry]

Try using this to check if character has a guild.

set .@GID,getcharid(2);
if (.@GID <= 0) {
mes "You have no guild!";
close;
}

Edited September 7, 2012 by darristan

[zXoOm]

thanks darristan. that works!

[Dvrstle]

so is this already fixed? i mean revised?

[PapaZola]

thanks darristan. that works!

sir can post full script here?

[jpnazar]

How to make this per account not per IP

//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

[jaBote]

How to make this per account not per IP

//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

 

By quickly revising the script, I think you're good to go if you just don't install that SQL table and comment (or delete) anything from the first to the last SQL query. I mean, you have to comment/delete those lines:

 

				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$ + "')");

Didn't test it though, but should work.

[chromus28]

Hi there shogs...I tried already this script but it doesn't read the IP of the player its just reading the account..Can you please give me some Scripts that it can read the IP? and it can read if they have a guild or not..thanks

[Boy]

Hi there shogs...I tried already this script but it doesn't read the IP of the player its just reading the account..Can you please give me some Scripts that it can read the IP? and it can read if they have a guild or not..thanks

Hi all

 

Any solution about this script? I got a same problem.