skUnity Parser

# █▀▀ █▀▀█ █░░ █▀▀ █▀▀█ ░▀░ █▀▀▄ █▀▀
# ▀▀█ █░░█ █░░ █░░ █░░█ ▀█▀ █░░█ ▀▀█
# ▀▀▀ ▀▀▀█ ▀▀▀ ▀▀▀ ▀▀▀▀ ▀▀▀ ▀░░▀ ▀▀▀
#
# author: HiiqhFive
# version: 1.0.000

# Dependencies: Skript 2.2, skQuery

# ----------------- SETTINGS ----------------- #
options:
	prefix: &8[&cSQLC&8]
	# If you have a server with more than 20 players, it's recommended to activate this option. (Available: True, False)
	run_async: "true"
	# Do you want to allow cheating commands? (Available: True, False)
	allow_admincmd: "true"

# messages
	addcoins_success: &aCoins added to target's account.
	addcoins_setsuccess: &aTarget's cash was set to given amount.
	remcoins_removesuccess:	&aRemoved Coins from target's account.
	remcoins_resetsuccess:	&aReset target's account.
	
	show_cash_me: &aYou have &e[AMOUNT] &aCoins available.
	show_cash_player: &aPlayer &6[PLAYER] &ahas &e[AMOUNT] &aCoins available.
	
	version: 1.0.000

# Setting up the database connection.
script options:
    $ db url jdbc:mysql://HOST:3306/DATABASE
    $ db username USERNAME
    $ db password PASSWORD
# ----------------- SETTINGS ----------------- #

# Creating Database if not exists.
on script load:
	{@run_async} is not "true" or "false":
		send "{@prefix} &4Error: Option ""run_async"" is not configured as required." to console
		send "{@prefix} &4Error: Disabling script..." to console
		send "{@prefix} &4An error occurred while enabling the script." to all players
		send "{@prefix} &4Check console for more information." to all players
		execute console command "/sk disable %script%"
	{@allow_admincmd} is not "true" or "false":
		send "{@prefix} &4Error: Option ""allow_admincmd"" is not configured as required." to console
		send "{@prefix} &4Error: Disabling script..." to console
		send "{@prefix} &4An error occurred while enabling the script." to all players
		send "{@prefix} &4Check console for more information." to all players
		execute console command "/sk disable %script%"
		
	update "CREATE TABLE IF NOT EXISTS `cash` (`uuid` varchar(255), `amount` float(20))"
	
	# AFTER INSTALLING THIS SCRIPT YOU CAN DISABLE THESE TWO LINES FOR AVOIDING THE "DUPLICATE COLUMN 'id'" ERROR.
	update "ALTER table `cash` ADD id int NOT NULL AUTO_INCREMENT primary key FIRST"
	update "ALTER table `cash` ADD UNIQUE (id, uuid)"
	
	
function checkCoins(target: offline player) :: number:
	# getting saved amount of cash from target player	
	set {_result::*} to objects in column "amount" from result of query "SELECT amount FROM cash WHERE uuid = '%uuid of {_target}%'" and close
	set {_amount} to "%{_result::*}%" parsed as number
	"%{_result::*}%" is "<none>":
		update "INSERT INTO cash (`uuid`, `amount`) VALUES ('%uuid of {_target}%', '0')"
		set {_amount} to 0
	return {_amount}
	
function hasAmount(target: offline player, amount: number) :: boolean:
	set {_result::*} to objects in column "amount" from result of query "SELECT amount FROM cash WHERE uuid = '%uuid of {_target}%'" and close
	"%{_result::*}%" is "<none>":
		update "INSERT INTO cash (`uuid`, `amount`) VALUES ('%uuid of {_target}%', '0')"
		set {_amount} to 0
	set {_targetamount} to "%{_result::*}%" parsed as number
	if {_targetamount} >= {_amount}:
		return true
	else:
		return false
	
function addCoins(target: offline player, amount: number, set: integer=0) :: text:
	set {_result::*} to objects in column "amount" from result of query "SELECT amount FROM cash WHERE uuid = '%uuid of {_target}%'" and close
	set {_targetamount} to "%{_result::*}%" parsed as number
	add {_amount} to {_targetamount}
	{_set} is 0:
		update "UPDATE cash SET `amount` = '%{_targetamount}%' WHERE uuid = '%uuid of {_target}%'"
		return "{@prefix} {@addcoins_success}"
	else:
		update "UPDATE cash SET `amount` = '%{_amount}%' WHERE uuid = '%uuid of {_target}%'"
		return "{@prefix} {@addcoins_setsuccess}"
	
function removeCoins(target: offline player, amount: number, reset: integer=0) :: text:
	set {_result::*} to objects in column "amount" from result of query "SELECT amount FROM cash WHERE uuid = '%uuid of {_target}%'" and close
	set {_targetamount} to "%{_result::*}%" parsed as number
	remove {_amount} from {_targetamount}
	{_reset} is 0:
		update "UPDATE cash SET `amount` = '%{_targetamount}%' WHERE uuid = '%uuid of {_target}%'"
		return "{@prefix} {@remcoins_removesuccess}"
	else:
		update "UPDATE cash SET `amount` = '0' WHERE uuid = '%uuid of {_target}%'"
		return "{@prefix} {@remcoins_resetsuccess}"
	
command /money [<offline player>]:
	trigger:
		arg 1 is not set:
			{@run_async} is "true":
				$ thread
			set {_amount} to checkCoins(player)
			set {_message} to "{@show_cash_me}"
			replace "[AMOUNT]" in {_message} with "%{_amount}%"
			send "{@prefix} %{_message}%"
		else:
			{@run_async} is "true":
				$ thread
			set {_amount} to checkCoins(arg 1)
			set {_message} to "{@show_cash_player}"
			replace "[AMOUNT]" in {_message} with "%{_amount}%"
			replace "[PLAYER]" in {_message} with "%arg 1%"
			send "{@prefix} %{_message}%"
			
command /eco [<text>] [<offline player>] [<number>]:
	permission: *
	trigger:
		{@allow_admincmd} is "true":
			arg 1 is not set:
				send "%newline%{@prefix} &e/eco &6reset &a<player> &8» &7Money reset."
				send "{@prefix} &e/eco &6set &a<player> &2<amount> &8» &7Set money."
				send "{@prefix} &e/eco &6give &a<player> &2<amount> &8» &7Add money."
				send "{@prefix} &e/eco &6rem(ove) &a<player> &2<amount> &8» &7Remove money."
				send "{@prefix} &8Thanks using this script by HiiqhFive (v{@version})."
			else:
				arg 1 is "reset":
					arg 2 is set:
						{@run_async} is "true":
							$ thread
						set {_message} to removeCoins(arg 2, 0, 1)
						send "%{_message}%"
					else:
						send "{@prefix} &e/eco &6reset &a<player> &8» &7Money reset."
						
				arg 1 is "set":
					arg 2 is set:
						arg 3 is set:
							{@run_async} is "true":
								$ thread
							set {_message} to addCoins(arg 2, arg 3, 1)
							send "%{_message}%"
						else:
							send "{@prefix} &e/eco &6set &a<player> &2<amount> &8» &7Set money."
					else:
						send "{@prefix} &e/eco &6set &a<player> &2<amount> &8» &7Set money."
				
				arg 1 is "give":
					arg 2 is set:
						arg 3 is set:
							{@run_async} is "true":
								$ thread
							set {_message} to addCoins(arg 2, arg 3)
							send "%{_message}%"
						else:
							send "{@prefix} &e/eco &6give &a<player> &2<amount> &8» &7Add money."
					else:
						send "{@prefix} &e/eco &6give &a<player> &2<amount> &8» &7Add money."
						
				arg 1 is "rem" or "remove":
					arg 2 is set:
						arg 3 is set:
							{@run_async} is "true":
								$ thread
							set {_message} to removeCoins(arg 2, arg 3)
							send "%{_message}%"
						else:
							send "{@prefix} &e/eco &6rem(ove) &a<player> &2<amount> &8» &7Remove money."
					else:
						send "{@prefix} &e/eco &6rem(ove) &a<player> &2<amount> &8» &7Remove money."
		else:
			send "{@prefix} &cThis command is disabled. Change in config."
			
command /addmecoins:
	trigger:
		set {_message} to addCoins(player, 1000)
		send {_message}
		
command /removecoins:
	trigger:
		set {_message} to removeCoins(player, 1000)
		send {_message}
		
command /hasamount <offline player> <number>:
	trigger:
		set {_message} to hasAmount(arg 1, arg 2)
		send "%{_message}%"

Paste Info

Paste ID: 191 / SQLCOINS [Skript 2.2, skQuery, MySQL]

Author: HiiqhFive

Privacy setting: anyone

Posted at: 03/04/2017 11:38:39pm

Indent Settings

Change how the Parser indents text. These settings are saved in your browser and will save when you change either option

Parse Results (0)

Write some code to get parse results

Commands (0)

No commands found

Functions (0)

No functions found

Detected Addons (0)

No addons detected

Variables (0)

No variables used yet

Skriptathon

Resource Search Spigot Resource Search

File Manager

Resource Search Spigot Resource Search

Resource Search

Search for Resources on the Forums and load them into the Parser

Enter a Resource ID or search for a Resource by its title

Spigot Resource Search

Search for Resources on Spigot and load them into the Parser

Search for a Resource by its title

Settings

Parser Experiments

Features currently in development for the Parser!

Features below can be tested before their full release. Please be aware that these features aren't fully tested, might be missing certain aspects such as frontend design or might not properly work. All feedback is gladly welcomed but negative comments for no reason won't be listened too. These features aren't intended to be released yet. Please note that when you enable or disable any Experiments, the page will refresh for the changes to take effect.

Manage Collections

Doing any changes to your Collections or creating a new Collection will refresh the page. Make sure you've saved any work beforehand.

Collection name

My Saves (1)

You don't have any pastes. Why not create one?

skUnity Connect

Shared with me (1)

There are no pastes shared with you.

Manage specific users

Intilising user management... please wait

Loading profile...

Public pastes skUnity Resources Forums profile

User Pastes

User skUnity Resources