nelax Posted January 18, 2014 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 41 Reputation: 0 Joined: 08/16/13 Last Seen: Sunday at 10:53 PM Share Posted January 18, 2014 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. Quote Link to comment Share on other sites More sharing options...
AnnieRuru Posted January 18, 2014 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 2044 Reputation: 682 Joined: 10/09/12 Last Seen: December 20, 2020 Share Posted January 18, 2014 (edited) 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 January 15, 2019 by AnnieRuru 3 Quote Link to comment Share on other sites More sharing options...
-SkittleNugget- Posted January 18, 2014 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 318 Reputation: 54 Joined: 12/23/12 Last Seen: July 1, 2017 Share Posted January 18, 2014 Nice script AnnieRuru Quote Link to comment Share on other sites More sharing options...
nelax Posted January 18, 2014 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 41 Reputation: 0 Joined: 08/16/13 Last Seen: Sunday at 10:53 PM Author Share Posted January 18, 2014 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! Quote Link to comment Share on other sites More sharing options...
-SkittleNugget- Posted January 18, 2014 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 318 Reputation: 54 Joined: 12/23/12 Last Seen: July 1, 2017 Share Posted January 18, 2014 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. Quote Link to comment Share on other sites More sharing options...
nelax Posted January 18, 2014 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 41 Reputation: 0 Joined: 08/16/13 Last Seen: Sunday at 10:53 PM Author Share Posted January 18, 2014 Thus I said is easier not need to change the script Quote Link to comment Share on other sites More sharing options...
-SkittleNugget- Posted January 18, 2014 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 318 Reputation: 54 Joined: 12/23/12 Last Seen: July 1, 2017 Share Posted January 18, 2014 We can make the NPC reload itself everyday but if you choose the database option, it can be done too. Quote Link to comment Share on other sites More sharing options...
AnnieRuru Posted January 18, 2014 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 2044 Reputation: 682 Joined: 10/09/12 Last Seen: December 20, 2020 Share Posted January 18, 2014 (edited) ok, I understand what he said, because I have did similar stuff beforehttp://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 allso 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 thisscript[paste=1flvas7upfip]forget about that `id` field ... for some reason if you want to use EDIT on the table, must have a primary key fieldso just change the `reach` field to your currently quota, and `goal` ... self explainableusing this script has to update manually thoughor 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 January 18, 2014 by AnnieRuru Quote Link to comment Share on other sites More sharing options...
Question
nelax
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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.