GodKnows Jhomz Posted July 27, 2014 Group: Members Topic Count: 38 Topics Per Day: 0.01 Content Count: 333 Reputation: 68 Joined: 09/05/12 Last Seen: June 13, 2023 Share Posted July 27, 2014 Anyone have this kind of Guild Package NPC? Need in a Guild Need Guild Level 50 Need Minimum 10 Online Members (Total 11 Including Guild Master) Need 255/120 All Members One Guild Package Per Account Can be set the Reward for Guild Members And for Guild Master. I hope someone have this script and share it with me and for anyone who needs it.Thanks! Quote Link to comment Share on other sites More sharing options...
Normynator Posted July 27, 2014 Group: Developer Topic Count: 7 Topics Per Day: 0.00 Content Count: 292 Reputation: 199 Joined: 05/03/13 Last Seen: May 26, 2023 Share Posted July 27, 2014 //Script by Normynator v1.0 prontera,163,172,4 script Guild Reward 79,{ mes "Hi"; query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id); //mes .@guild_id; query_sql( "SELECT `name`, `guild_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv ); .@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ ); for( .@i = 0; .@i < .@size; .@i++ ){ if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++; } mes "Guild Name: " + .@name$; mes "Guild Level: " + .@guild_lv; mes "Members online: " + .@m; if(.@guild_lv == 50 && .@m == 11){ next; if (#GuildReward){ mes "You already got your item."; close; } set #GuildReward, 1; mes "A Berry for you"; getitem 607, 1; close; } close; } 255/120 all members, or only the members which are online? Quote Link to comment Share on other sites More sharing options...
GodKnows Jhomz Posted July 27, 2014 Group: Members Topic Count: 38 Topics Per Day: 0.01 Content Count: 333 Reputation: 68 Joined: 09/05/12 Last Seen: June 13, 2023 Author Share Posted July 27, 2014 //Script by Normynator v1.0 prontera,163,172,4 script Guild Reward 79,{ mes "Hi"; query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id); //mes .@guild_id; query_sql( "SELECT `name`, `guild_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv ); .@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ ); for( .@i = 0; .@i < .@size; .@i++ ){ if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++; } mes "Guild Name: " + .@name$; mes "Guild Level: " + .@guild_lv; mes "Members online: " + .@m; if(.@guild_lv == 50 && .@m == 11){ next; if (#GuildReward){ mes "You already got your item."; close; } set #GuildReward, 1; mes "A Berry for you"; getitem 607, 1; close; } close; } 255/120 all members, or only the members which are online? Yes, 255/120 all members. Even its offline Quote Link to comment Share on other sites More sharing options...
Normynator Posted July 27, 2014 Group: Developer Topic Count: 7 Topics Per Day: 0.00 Content Count: 292 Reputation: 199 Joined: 05/03/13 Last Seen: May 26, 2023 Share Posted July 27, 2014 //Script by Normynator v1.1 prontera,163,172,4 script Guild Reward 79,{ mes "Hi"; query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id); //mes .@guild_id; query_sql( "SELECT `name`, `guild_lv`, `average_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv, .@guild_av ); .@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ ); for( .@i = 0; .@i < .@size; .@i++ ){ if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++; } mes "Guild Name: " + .@name$; mes "Guild Level: " + .@guild_lv; mes "Guild Average Level: " + .@guild_av; mes "Members online: " + .@m; if(.@guild_lv == 50 && .@m == 11 && .@guild_av == 255){ next; if (#GuildReward){ mes "You already got your item."; close; } set #GuildReward, 1; mes "A Berry for you"; getitem 607, 1; close; } close; } Hope it works Quote Link to comment Share on other sites More sharing options...
GodKnows Jhomz Posted July 27, 2014 Group: Members Topic Count: 38 Topics Per Day: 0.01 Content Count: 333 Reputation: 68 Joined: 09/05/12 Last Seen: June 13, 2023 Author Share Posted July 27, 2014 //Script by Normynator v1.1 prontera,163,172,4 script Guild Reward 79,{ mes "Hi"; query_sql( "SELECT `guild_id` FROM `rathena`.`char` WHERE `char_id` = "+ getcharid(0) , .@guild_id); //mes .@guild_id; query_sql( "SELECT `name`, `guild_lv`, `average_lv` FROM `guild` WHERE `guild_id`= '"+ .@guild_id +"'", .@name$, .@guild_lv, .@guild_av ); .@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id +"'", .@name_m$ ); for( .@i = 0; .@i < .@size; .@i++ ){ if( getcharid( 0,.@name_m$[ .@i ] ) ) .@m++; } mes "Guild Name: " + .@name$; mes "Guild Level: " + .@guild_lv; mes "Guild Average Level: " + .@guild_av; mes "Members online: " + .@m; if(.@guild_lv == 50 && .@m == 11 && .@guild_av == 255){ next; if (#GuildReward){ mes "You already got your item."; close; } set #GuildReward, 1; mes "A Berry for you"; getitem 607, 1; close; } close; } Hope it works Thanks for this. Gonna try this tomorrow and i'll tell you if it works. Quote Link to comment Share on other sites More sharing options...
Question
GodKnows Jhomz
Anyone have this kind of Guild Package NPC?
Need in a Guild
Need Guild Level 50
Need Minimum 10 Online Members (Total 11 Including Guild Master)
Need 255/120 All Members
One Guild Package Per Account
Can be set the Reward for Guild Members And for Guild Master.
I hope someone have this script and share it with me and for anyone who needs it.
Thanks!
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.