on script load:
	set {database} to the database "mysql://5.200.16.212:3306/thefloxe_bungeecoins?user=thefloxe_minecraft&password=ggtuGy86TEP7e3mY&useSSL=false"
	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}

on join:
	execute "UPDATE playerinfo SET Name = %name of player% WHERE UUID = %uuid of player%" in {database}
	execute console command "d1u2114 %player%"

command /d1u2114 [<player>]:
	executable by: CONSOLE
	trigger:
		access "getValue" from "%name of player%" and "playerinfo" and "Rank" and "Language" and "FirstLogin" and "LatestLogin"
		broadcast "test"
		if {_getValue} is not set:
			execute "INSERT INTO playerinfo (`Name`, `UUID`, `Rank`, `Language`, `FirstLogin`, `LatestLogin`) VALUES (%name of player%, %uuid of player%, Member, English, %now%, %now%)" in {database}