#
#Title: SkStats
#Version: 1.0
#Author: MinePlugins
#
# IMPORTANT MYSQL A MODIFIER
script options:
    $ db url jdbc:mysql://xxx.xxx.xxx.xx:3306/xxxxxxxxxxx
    $ db username xxxxxxxxxxx
    $ db password xxxxxxxxxxx

options:
	table_prefix: Stats_
	refresh: 500


command /stats [<text>]:
	permission: SkStats.commands.player
	trigger:
		if arg 1 is "reload":
			make console execute command "/sk reload SkStats"
			message "&4SkStats vient d'être reload"

		if arg-1 is not set:
			play "NOTE_PLING" to player at volume 100
			wait 2 ticks
			set {_head} to "%player%"
			open chest with 1 row named "&1Mes stats" to player
			format slot 4 of player with player's skull named "&4Mes stats" with lore "&5Blocs brisés: &6%{newbreak-%player%}%||&5Blocs placés: &6%{newplace-%player%}%||&5Kills: &6%{newkills-%player%}%||&5Morts: &6%{newdeaths-%player%}%" to be unstealable

		if arg-1 is "purge":
			if player have permission "SkStats.commands.purge":
				loop {statslistplayer::*}:
					set {deaths-%loop-value%} to 0
					set {kills-%loop-value%} to 0
					set {break-%loop-value%} to 0
					set {place-%loop-value%} to 0
					set {newdeaths-%loop-value%} to 0
					set {newkills-%loop-value%} to 0
					set {newbreak-%loop-value%} to 0
					set {newplace-%loop-value%} to 0
				update "TRUNCATE TABLE `{@table_prefix}Player`"

On script load:
	update "CREATE TABLE IF NOT EXISTS `{@table_prefix}Player` (`Player` varchar(255),`Kills` varchar(255),`Deaths` varchar(255),`Breaks` varchar(255),`Placed` varchar(255))"
On join:
	if {firstjoin-%player%} is not set:
		set {deaths-%player%} to 0
		set {kills-%player%} to 0
		set {break-%player%} to 0
		set {place-%player%} to 0
		set {newdeaths-%player%} to 0
		set {newkills-%player%} to 0
		set {newbreak-%player%} to 0
		set {newplace-%player%} to 0
		update "INSERT INTO `{@table_prefix}Player` (`Player`, `Kills`, `Deaths`, `Breaks`, `Placed`) VALUES ('%player%', '0', '0', '0', '0')"
On death:
	attacker is player
	victim is player
	add 1 to {deaths-%victim%}
	add 1 to {kills-%attacker%}
On break:
	add 1 to {break-%player%}
On place:
	add 1 to {place-%player%}
every {@refresh} seconds:
	loop all players:
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Deaths` = `Deaths`+%{deaths-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Kills` = `Kills`+%{kills-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Breaks` = `Breaks`+%{break-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Placed` = `Placed`+%{place-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
		set {newdeaths-%loop-player%} to {newdeaths-%loop-player%} + {deaths-%loop-player%}
		set {newkills-%loop-player%} to {newkills-%loop-player%} + {kills-%loop-player%}
		set {newbreak-%loop-player%} to {newbreak-%loop-player%} + {break-%loop-player%}
		set {newplace-%loop-player%} to {newplace-%loop-player%} + {place-%loop-player%}
		set {deaths-%loop-player%} to 0
		set {kills-%loop-player%} to 0
		set {break-%loop-player%} to 0
		set {place-%loop-player%} to 0
On quit:
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Deaths` = `Deaths`+%{deaths-%player%}% WHERE `{@table_prefix}Player`.`Player` = '%player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Kills` = `Kills`+%{kills-%player%}% WHERE `{@table_prefix}Player`.`Player` = '%player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Breaks` = `Breaks`+%{break-%player%}% WHERE `{@table_prefix}Player`.`Player` = '%player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Placed` = `Placed`+%{place-%player%}% WHERE `{@table_prefix}Player`.`Player` = '%player%'"
		set {newdeaths-%player%} to {newdeaths-%player%} + {deaths-%player%}
		set {newkills-%player%} to {newkills-%player%} + {kills-%player%}
		set {newbreak-%player%} to {newbreak-%player%} + {break-%player%}
		set {newplace-%player%} to {newplace-%player%} + {place-%player%}
		set {deaths-%player%} to 0
		set {kills-%player%} to 0
		set {break-%player%} to 0
		set {place-%player%} to 0