Jump to content
  • 0

Quota System


nelax

Question


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  41
  • Reputation:   0
  • Joined:  08/16/13
  • Last Seen:  

Good guys need a quota system, a npc in prontera which is connected to the database which I will include a value eg £ 200.00 and will be seen by players in npc.

Link to comment
Share on other sites

7 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  2044
  • Reputation:   682
  • Joined:  10/09/12
  • Last Seen:  

prontera,156,184,5	script	Quota	100,{
	mes "[Quota System]";
	mes "£ 200.00";
	close;
}

 

 

tell us more about this "Quota" system that you are talking about x.x

Edited by AnnieRuru
  • Upvote 3
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  41
  • Reputation:   0
  • Joined:  08/16/13
  • Last Seen:  

prontera,156,184,5	script	Quota	100,{
	mes "[Quota System]";
	mes "£ 200.00";
	close;
}
tell us more about this "Quota" system that you are talking about x.x

 

 

 

 

Have no means of making connection using the database does not? For whenever entering a new value to modify the npc I would have to give reloadscript the database would no longer be necessary to reload this.

It goes something like WHAT I need.

Will have an NPC in prontera that you'll be inform how much we have in this month of $ cash and how much we need and will be bound to a table in the DB as well No need to reloadscript whenever I modify this table.

 

EX:

 

Hello John Doe! Our goal for this month is $ 150.00 and already have £ 120.00, helps the server!

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  11
  • Topics Per Day:  0.00
  • Content Count:  318
  • Reputation:   54
  • Joined:  12/23/12
  • Last Seen:  

You want an NPC, that shows the amount of donation money your server has received within a certain time frame?

You do understand to make this automated you would need to setup a new table where both NPC and Control Panel connect to.

It may just be easier to use AnnieRuru's example and just update every day.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  41
  • Reputation:   0
  • Joined:  08/16/13
  • Last Seen:  

Thus I said is easier not need to change the script

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  11
  • Topics Per Day:  0.00
  • Content Count:  318
  • Reputation:   54
  • Joined:  12/23/12
  • Last Seen:  

We can make the NPC reload itself everyday but if you choose the database option, it can be done too.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  2044
  • Reputation:   682
  • Joined:  10/09/12
  • Last Seen:  

ok, I understand what he said, because I have did similar stuff before
http://www.eathena.ws/board/index.php?s=&showtopic=272409&view=findpost&p=1492359 -> update [paste=21hkxkuvt6dl]
what he wants is something that can change the message/value in-game without having to login the game at all
so he just need to do remote access the server, open MySQL Workbench, and change the value in the Sql table, and the in-game message will changed
*query_sql script command can do this

script
[paste=1flvas7upfip]

forget about that `id` field ... for some reason if you want to use EDIT on the table, must have a primary key field
so just change the `reach` field to your currently quota, and `goal` ... self explainable

using this script has to update manually though
or do you already having an existing table that already list out all the donors on your server ?
just do select sum(donate) from donor_table where left( donate_date, 7 ) = '2014-01'

Edited by AnnieRuru
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
Answer this question...

×   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...