Contributors:

HiiqhFive

Supported Minecraft Versions:

• 1.7, 1.8, 1.9, 1.10, 1.11

SQL COINS
for Skript 2.2

This script implements a currency with MySQL Integration of skQuery.
PS: I hate designing ressource threads, thats why it's looking shitty. lol.


DEPENDENCIES

• Skript (at least version 2.2)
• SkQuery
• A MySQL Database


HOW TO INSTALL

1. Install Skript v2.2 on your Spigot/Bukkit server.
2. Go to "plugins\Skript\scripts"
3. upload the required file.
4. open the mentioned file and set up the database connection (example inside the config)
5. Restart your server or type "/sk reload <script name>"
(in this case: /sk reload SQL-COINS_1.0.000)



PICTURES





COMMANDS & PERMISSIONS

• /money [<player>] » Displays the cash of a player.
• /eco » Displays admin commands.


CONFIG
​

​

Spoiler: Open Config

Code (Skript):

1. options:
2.     prefix: &8[&cSQLC&8]
3.     # If you have a server with more than 20 players, it's recommended to activate this option. (Available: True, False)
4.     run_async: "true"
5.     # Do you want to allow cheating commands? (Available: True, False)
6.     allow_admincmd: "true"
7.  
8.     # messages
9.     addcoins_success: &aCoins added to target's account.
10.     addcoins_setsuccess: &aTarget's cash was set to given amount.
11.     remcoins_removesuccess:    &aRemoved Coins from target's account.
12.     remcoins_resetsuccess:    &aReset target's account.
13.    
14.     show_cash_me: &aYou have &e[AMOUNT] &aCoins available.
15.     show_cash_player: &aPlayer &6[PLAYER] &ahas &e[AMOUNT] &aCoins available.
16.    
17.     version: 1.0.000

​

Spoiler: Setting up a MySQL database connection

Code (Skript):

1. # /*
2. # * Before using this script, you have to set up your database connection.
3. # * Here is a little example how to configure it:
4. # *    $ db url jdbc:mysql://127.0.0.1:3306/coins
5. # *    $ db username hiiqhfive
6. # *    $ db password ouas0998b
7. # */

​

API
​

Code (Skript):

1. checkCoins(target player)
2. # Example: checkCoins(player)
3. # Returns a number. (Cash of target player)
4.  
5. hasAmount(target player, amount of cash)
6. # Example: hasAmount(player, 5000)
7. # Returns a boolean.
8.  
9. addCoins(target player, amount of cash, [setting option])
10. # Examples:
11. #    Without setting to a specific number: addCoins(player, 3000)
12. #    With setting to a specific number: addCoins(player, 3000, 1)
13. #    --> Account will be set to given amount at arg 2.
14. # Returns a message.
15.  
16. removeCoins(target player, amount of cash, [reset option])
17. # Examples:
18. #    Without reset: removeCoins(player, 1234)
19. #    With reset: removeCoins(player, 0, 1)
20. #    --> Account will be reset to 0 coins
21. # Returns a message.

If you have any suggestions, post it in comments!
Have fun! ​