· 10 years ago · Jul 03, 2016, 12:30 PM
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 'Skyblock_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%'"