Utility: Ragnarok Guild Package NPC

[benching]

View File

Ragnarok Guild Package NPC

---

Guild package Redeemer NPC

[NPC Information]

Includes:

1.Package Code Generator

2.Package Code ( for Guild with Players of the same IP )

3.Different Package set for Guild Master.

4.Different Package set for Guild Member.

To Redeem the guild package:

1.Should be a Guild Master

2.Required Minimum Guild Member. (8 default)

3.All Guild Members should be Online

4.Non Duplicate IP Check ( to avoid multiple login of single player )

5.Duplicate IP Check ( Use the code to bypass IP check )

6.Online Status Check

7.First time to Redeem GPack (IP Based)

---

• Submitter
  benching
• Submitted
  12/05/2015
• Category
  Utilities
• Video
• Content Author
  benching

 

[Emmanskillz]

Nice script sir! but btw what if the guild are playing in a computer shop. can they avail the guild package using this script? thanks   

[benching]

yes, just give them a package code that you can generate via same npc,
that code will allow them to claim gpack on same ip's, but all members should be online.

Edited April 18, 2016 by benching

[Dev Emonizer]

hi there i've changed the default members to 10 players, but only 8 members has claimed the gpack the other 2 players didn't 

Edited November 1, 2016 by blood99

[AinsLord]

hello i have some error on your script

 

[SQL]: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`SELECT `name` FROM `guild` WHERE `guild_id` = '10'' at line 1
[Debug]: at script.c:16506 - `SELECT `name` FROM `guild` WHERE `guild_id` = '10'
[Debug]: Source (NPC): Guild Master at morocc (155,91)

NPC is working but everytime i check the code that will show up on console

thnx for  the help

[Quesooo]

this need sql files?? where is it??

[AinsLord]

sql files will be generated automatically

 

[MelMel]

On 7/20/2017 at 11:52 AM, whodhell said:

hello i have some error on your script

 

[SQL]: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`SELECT `name` FROM `guild` WHERE `guild_id` = '10'' at line 1
[Debug]: at script.c:16506 - `SELECT `name` FROM `guild` WHERE `guild_id` = '10'
[Debug]: Source (NPC): Guild Master at morocc (155,91)

NPC is working but everytime i check the code that will show up on console

thnx for  the help

Is there a fix for this issues yet?

 

Thank you in advance

[AinsLord]

still none but im using it 

[sader1992]

query_sql("`SELECT `name` FROM `guild` WHERE `guild_id` = '"+.@glist[@ei]+"'",.@gn$);

to

query_sql("SELECT `name` FROM `guild` WHERE `guild_id` = '"+.@glist[@ei]+"'",.@gn$);

 

[AinsLord]

ill try this one later thnx sader1992