script options:
    $ db url jdbc:mysql://xx.xxx.xxx.xxx:3306/xxxxxxxxxxxxxxxxxx
    $ db username xxxxxxxxxxxxxxxxxx
    $ db password xxxxxxxxxxxxxxxxxx

options:
	table_prefix: stats_
	refresh: 10

On load:
	if {Stats-Reloader} is set:
		set {_period} to difference between {Stats-Reload-sec} and now
		send "&9SkStats >>  &7The skript have been reload in &a%{_period}%" to {Stats-Reloader}
		clear {Stats-Reloader}

command /stats [<text=help>] [<text>]:
	permission: SkStats.commands.player
	executable by: console and players
	trigger:
		if arg-1 is "help":
			send "&9&l╔&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&9&l[ &6&lStats &9&l]&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l╗"
			send "   &bCommandes des joueurs:"
			send "    &9/Stats Check &7Regarder vos statistiques"
			if player have permission "SkStats.commands.admin":
				send "   &cCommandes des admins:"
				send "    &9/Stats purge &7Réinitialiser les statsitiques. &4&lIRRÉVERSIBLE"
				send "    &9/Stats reload &7Reload bcstats"
				send "    &9/Stats sync &7Synchronise les données avec la base de données MYSQL"

		if arg-1 is "check":
			send "&9&l╔&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&9&l[ &6&lStats &9&l]&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l═&3&l═&9&l╗"
			send "  &bVos statistiques:"
			send "    &3Kills: &7%{newkills-%player%}%"
			send "    &3Deaths: &7%{newdeaths-%player%}%"
			send "    &3Block détruits: &7%{newbreak-%player%}%"
			send "    &3Block placés: &7%{newplace-%player%}%"
			send "    &3Distance parcourue à la marche: &7%{newwalk-%player%}%"
			send "    &3Tokens: &7%{tokens-%player%}%"
			send "    &3Argent: &7%{money-%player%}%"

		if arg 1 is "reload":
			set {Stats-Reload-sec} to now
			set {Stats-Reloader} to player
			make console execute command "/skript reload bcstats"

		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 {walk-%loop-value%} to 0
					set {tokens-%loop-value%} to 0
					set {money-%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
					set {newwalk-%loop-value%} to 0
					set {newtokens-%loop-value%} to 0
					set {newmoney-%loop-value%} to 0
				update "TRUNCATE TABLE `{@table_prefix}Player`"

		if arg-1 is "sync":
			if player have permission "SkStats.commands.sync":
				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 `Player`.`{@table_prefix}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%'"
					update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Walk` = `Walk`+%{walk-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
					update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Tokens` = `Tokens`+%{tokens-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
					update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Money` = `Money`+%{money-%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 {newwalk-%loop-player%} to {newwalk-%loop-player%} + {walk-%loop-player%}
					set {newtokens-%loop-player%} to {newtokens-%loop-player%} + {tokens-%loop-player%}
					set {newmoney-%loop-player%} to {newmoney-%loop-player%} + {money-%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
					set {walk-%loop-player%} to 0
					set {tokens-%loop-player%} to placeholder parse "%%tokenenchant_tokens%%" as player
					set {money-%loop-player%} to placeholder parse "%%vaulteco_balance%%" as player
				send "&9SkStats >>  &aThe stats have been synced with the mysql database"

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),`Walk` varchar(255),`Tokens` varchar(255),`Money` varchar(255))"

On join:
	if {firstjoin-%player%} is not set:
		set {tokens-%player%} to placeholder parse "%%tokenenchant_tokens%%" as player
		set {money-%player%} to placeholder parse "%%vaulteco_balance%%" as player

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 5 ticks:
	loop all players:
		if {walk-%loop-player%-loc} is not set:
			set {walk-%loop-player%-loc} to location of block below loop-player
			add 1 to {walk-%loop-player%}
		else if {walk-%loop-player%-loc} is not location of block below loop-player:
			set {walk-%loop-player%-loc} to location of block below loop-player
			add 1 to {walk-%loop-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%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Walk` = `Walk`+%{walk-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Tokens` = `Tokens`+%{tokens-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Money` = `Money`+%{money-%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 {newwalk-%loop-player%} to {newwalk-%loop-player%} + {walk-%loop-player%}
		set {newtokens-%loop-player%} to {newtokens-%loop-player%} + {tokens-%loop-player%}
		set {newmoney-%loop-player%} to {newmoney-%loop-player%} + {money-%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
		set {walk-%loop-player%} to 0
		set {tokens-%loop-player%} to 0
		set {money-%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%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Walk` = `Walk`+%{walk-%player%}% WHERE `{@table_prefix}Player`.`Player` = '%player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Tokens` = `Tokens`+%{tokens-%player%}% WHERE `{@table_prefix}Player`.`Player` = '%player%'"
		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Money` = `Money`+%{money-%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 {newwalk-%player%} to {newwalk-%player%} + {walk-%player%}
		set {newtokens-%player%} to {newtokens-%player%} + {tokens-%player%}
		set {newmoney-%player%} to {newmoney-%player%} + {money-%player%}
		set {deaths-%player%} to 0
		set {kills-%player%} to 0
		set {break-%player%} to 0
		set {place-%player%} to 0
		set {walk-%player%} to 0
		set {tokens-%player%} to 0
		set {money-%player%}  to 0