Jump to content

Utility: Ragnarok Guild Package NPC


benching

Recommended Posts


  • Group:  Members
  • Topic Count:  26
  • Topics Per Day:  0.01
  • Content Count:  350
  • Reputation:   43
  • Joined:  09/07/12
  • Last Seen:  

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
  • Submitted
    12/05/2015
  • Category
  • Video
  • Content Author
    benching

 

  • Upvote 1
  • MVP 1
Link to comment
Share on other sites

  • 3 months later...

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   1
  • Joined:  04/19/13
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  26
  • Topics Per Day:  0.01
  • Content Count:  350
  • Reputation:   43
  • Joined:  09/07/12
  • Last Seen:  

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 by benching
Link to comment
Share on other sites

  • 6 months later...

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  4
  • Reputation:   0
  • Joined:  10/28/16
  • Last Seen:  

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 by blood99
Link to comment
Share on other sites

  • 8 months later...

  • Group:  Members
  • Topic Count:  257
  • Topics Per Day:  0.08
  • Content Count:  737
  • Reputation:   18
  • Joined:  11/21/15
  • Last Seen:  

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

Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  197
  • Topics Per Day:  0.07
  • Content Count:  883
  • Reputation:   28
  • Joined:  02/13/17
  • Last Seen:  

this need sql files?? where is it??

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  257
  • Topics Per Day:  0.08
  • Content Count:  737
  • Reputation:   18
  • Joined:  11/21/15
  • Last Seen:  

sql files will be generated automatically

 

  • Upvote 1
Link to comment
Share on other sites

  • 2 months later...

  • Group:  Members
  • Topic Count:  31
  • Topics Per Day:  0.01
  • Content Count:  114
  • Reputation:   1
  • Joined:  01/22/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  257
  • Topics Per Day:  0.08
  • Content Count:  737
  • Reputation:   18
  • Joined:  11/21/15
  • Last Seen:  

still none but im using it 

Link to comment
Share on other sites


  • Group:  Content Moderator
  • Topic Count:  55
  • Topics Per Day:  0.02
  • Content Count:  1676
  • Reputation:   703
  • Joined:  12/21/14
  • Last Seen:  

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$);

 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  257
  • Topics Per Day:  0.08
  • Content Count:  737
  • Reputation:   18
  • Joined:  11/21/15
  • Last Seen:  

ill try this one later thnx sader1992

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...