script options:
    $ db url jdbc:mysql://localhost:3306/skriptGTA2
    $ db username root
    $ db password craft
options:
	table_prefix: EC2_
	chest_suffix: II
On script load:
	update "CREATE TABLE IF NOT EXISTS {@table_prefix}Player (Slot TINYINT,Player varchar(255),Objet varchar(255),Montant TINYINT,Nbt varchar(255))"


on connect:
	if {join.%player%} is true:
		add objects in column "Objet" from result of query "SELECT Objet FROM {@table_prefix}Player WHERE Player = '%player%'" to {_temp.%player%.item::*}
		set {{@table_prefix}.%player%.item::*} to {_temp.%player%.item::*}
		add objects in column "Montant" from result of query "SELECT Montant FROM {@table_prefix}Player WHERE Player = '%player%'" to {_temp.%player%.amount::*}
		set {{@table_prefix}.%player%.amount::*} to {_temp.%player%.amount::*}
		add objects in column "Nbt" from result of query "SELECT Nbt FROM {@table_prefix}Player WHERE Player = '%player%'" to {_temp.%player%.Nbt::*}
		set {{@table_prefix}.%player%.Nbt::*} to {_temp.%player%.Nbt::*}
		update "DELETE FROM `{@table_prefix}Player` WHERE Player = '%player%'"
		set {join.%player%} to false
	if {join.%player%} is not set:
		add objects in column "Objet" from result of query "SELECT Objet FROM {@table_prefix}Player WHERE Player = '%player%'" to {_temp.%player%.item::*}
		set {{@table_prefix}.%player%.item::*} to {_temp.%player%.item::*}
		add objects in column "Montant" from result of query "SELECT Montant FROM {@table_prefix}Player WHERE Player = '%player%'" to {_temp.%player%.amount::*}
		set {{@table_prefix}.%player%.amount::*} to {_temp.%player%.amount::*}
		add objects in column "Nbt" from result of query "SELECT Nbt FROM {@table_prefix}Player WHERE Player = '%player%'" to {_temp.%player%.Nbt::*}
		set {{@table_prefix}.%player%.Nbt::*} to {_temp.%player%.Nbt::*}
		update "DELETE FROM `{@table_prefix}Player` WHERE Player = '%player%'"
		set {join.%player%} to false

on disconnect:
	if {join.%player%} is false:
		loop {{@table_prefix}.%player%.item::*}:
			update "INSERT INTO {@table_prefix}Player (Slot, Player, Objet, Montant, Nbt) VALUES ('%{{@table_prefix}.%player%.slot::%loop-index%}-1%','%player%','%loop-value%','%{{@table_prefix}.%player%.amount::%loop-index%}%','%{{@table_prefix}.%player%.Nbt::%loop-index%}%')"
		delete {{@table_prefix}.%player%.item::*}
		delete {{@table_prefix}.%player%.amount::*}
		delete {{@table_prefix}.%player%.Nbt::*}
		set {join.%player%} to true

on inventory close:
	{db1.openedenderchest.%player%} is true
	if inventory name of current inventory of player is "Coffre du Néant {@chest_suffix}":
		clear {{@table_prefix}.%player%.item::*}
		clear {{@table_prefix}.%player%.amount::*}
		clear {{@table_prefix}.%player%.Nbt::*}
		loop 27 times:
			set {_air} to slot "%loop-number - 1%" parsed as an integer of current inventory of player
			if "%{_air}%" isn't "air":
				set {{@table_prefix}.%player%.slot::%loop-number - 1%} to loop-number
				set {{@table_prefix}.%player%.item::%loop-number - 1%} to type of slot "%loop-number - 1%" parsed as an integer of current inventory of player
				set {{@table_prefix}.%player%.Nbt::%loop-number - 1%} to nbt of slot "%loop-number - 1%" parsed as an integer of current inventory of player
				set {_temp} to slot "%loop-number - 1%" parsed as an integer of current inventory of player
				set {{@table_prefix}.%player%.amount::%loop-number - 1%} to the first 2 character of "%{_temp}%"
				replace " " in {{@table_prefix}.%player%.amount::%loop-number - 1%} with ""
				set {{@table_prefix}.%player%.amount::%loop-number - 1%} to {{@table_prefix}.%player%.amount::%loop-number - 1%} parsed as integer
				if {{@table_prefix}.%player%.amount::%loop-number - 1%} isn't an integer:
					set {{@table_prefix}.%player%.amount::%loop-number - 1%} to 1
		set {db1.openedenderchest.%player%} to false
		stop

on rightclick on ender chest:
	if difference between {db1.openedenderchest.time.%player%} and now is less than 2 seconds:
		send player title "" with subtitle "&1[&3Police&1] &7Pas bien le spam !" for 10 ticks
		cancel event
		stop
	if "%region at event-block%" contains "EC_{@chest_suffix}":
		{db1.openedenderchest.%player%} is false
		cancel event
		open chest with 3 rows named "Coffre du Néant {@chest_suffix}" to player
		set {db1.openedenderchest.time.%player%} to now
		set {db1.openedenderchest.%player%} to true
		make the event-block appear open
		wait 1 tick
		loop {{@table_prefix}.%player%.item::*}:
			set {_item} to "%loop-value%" parsed as an item type
			add {{@table_prefix}.%player%.amount::%loop-index%} of {_item} with nbt "%{{@table_prefix}.%player%.Nbt::%loop-index%}%" to current inventory of player
		while inventory name of current inventory of player is "Coffre du Néant {@chest_suffix}":
			make the event-block appear open
			wait 2 tick