JyenRPSR

1script options:
2    $ db url jdbc:mysql://ewolveplay.eu:3306/ewolveplay_login
3    $ db username ewolveplay_login
4    $ db password lT4ePjHdGB43UoG
5
6options:
7	table_prefix: Skyblock_
8	refresh: 300
9on script load:
10	update "CREATE TABLE IF NOT EXISTS '{@table_prefix}Level` (`Player` varchar(255),`level` varchar(255))"
11on join:
12	set {level-%player%} to placeholder parse "%%player_health%%"
13	update "INSERT INTO `{@table_prefix}Player` (`Player`, `level`) VALUES ('%player%', '0')"
14every 5 ticks:
15	loop all players:
16		set {level-%loop-player%} to placeholder parse "%%player_health%%"
17		update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Level` = `0`+%{level-%loop-player%}% WHERE `{@table_prefix}Player`.`Player` = '%loop-player%'"