yss6y8YY

1on script load:
2	set {database} to the database "mysql://5.200.16.212:3306/thefloxe_bungeecoins?user=thefloxe_minecraft&password=ggtuGy86TEP7e3mY&useSSL=false"
3	execute "CREATE TABLE IF NOT EXISTS `playerinfo` (`Name` varchar(32), `UUID` varchar(64), `Rank` varchar(32), `Language` varchar(32), `FirstLogin` varchar(64), `LatestLogin` varchar(64))" in {database}
4
5on join:
6	execute "UPDATE playerinfo SET Name = %name of player% WHERE UUID = %uuid of player%" in {database}
7	execute console command "d1u2114 %player%"
8
9command /d1u2114 [<player>]:
10	executable by: CONSOLE
11	trigger:
12		access "getValue" from "%name of player%" and "playerinfo" and "Rank" and "Language" and "FirstLogin" and "LatestLogin"
13		broadcast "test"
14		if {_getValue} is not set:
15			execute "INSERT INTO playerinfo (`Name`, `UUID`, `Rank`, `Language`, `FirstLogin`, `LatestLogin`) VALUES (%name of player%, %uuid of player%, Member, English, %now%, %now%)" in {database}