Guild Package Script

[Syndicate-Jhay]

Guild Package*

 

This Guild Package is per account, must be consist of 10 Players and must be Level 50 Guild..

 

Thanks in Advance

[sader1992]

this with guild level

prontera,154,95,4	script	test	50,{
query_sql "SELECT `guild_lv` FROM `guild` WHERE `guild_id`="+getcharid(2)+"",@glvl;
	if(@glvl == 50 ){
		if( !#GuildPackage3 ){
			set #GuildPackage3,1;
			getitem 512,10;
			}else{
			mes "You can't get it twice!";
			}
		close;
	}else{
	mes"your guild level too low";
	close;
	}
}

getitem item,amount;

getitem item,amount;

getitem item,amount;

getitem item,amount;

 

 

you can do this script with any and more then one from the guild sql

name
char_id
master
guild_lv
connect_member
max_member
average_lv
exp
next_exp
skill_point
mes1
mes2
emblem_len
emblem_id
emblem_data

just edit this like the Example on connect_member

 

query_sql "SELECT `guild_lv`,`connect_member` FROM `guild` WHERE `guild_id`="+getcharid(2)+"",@glvl,@cmember;

and edit the if 

if(@glvl == 50 || @cmember == 10 )

i hope i helped you 

[Syndicate-Jhay]

Thank you

Sir how about, If I want the 10 Members are Max Level 255? how will I do it?

[sader1992]

average_lv on the guild sql

the average_lv is the Average level of the guild members

you can control that

like if there 10 members 5 = 250 and 5 = 200 the Average will be 225

i don't if there is another way to set it 

and i don't think there is way to set the guild members number