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


on join:
	add objects in column "Objet" from result of query "SELECT Objet FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.item::*}
	add objects in column "Nom" from result of query "SELECT Nom FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.name::*}
	add objects in column "Lore" from result of query "SELECT Lore FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.lore::*}
	add objects in column "Montant" from result of query "SELECT Montant FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.amount::*}
	update "DELETE FROM `EC_Player` WHERE Player = '%player%'"

on disconnect:
	loop {ec2.%player%.item::*}:
		update "INSERT INTO {@table_prefix}Player (Slot, Player, Objet, Montant, Nom, Lore) VALUES ('%{ec2.%player%.slot::%loop-index%}-1%','%player%','%loop-value%','%{ec2.%player%.amount::%loop-index%}%','%{ec2.%player%.name::%loop-index%}%','%{ec2.%player%.lore::%loop-index%}%')"
	delete {ec2.%player%.item::*}
	delete {ec2.%player%.name::*}
	delete {ec2.%player%.lore::*}
	delete {ec2.%player%.amount::*}

on inventory close:
	{db1.openedenderchest.%player%} is true
	if inventory name of current inventory of player is "Coffre du Néant II":
		clear {ec2.%player%.item::*}
		clear {ec2.%player%.amount::*}
		clear {ec2.%player%.name::*}
		clear {ec2.%player%.lore::*}
		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 {ec2.%player%.slot::%loop-number - 1%} to loop-number
				set {ec2.%player%.item::%loop-number - 1%} to type of slot "%loop-number - 1%" parsed as an integer of current inventory of player
				set {ec2.%player%.name::%loop-number - 1%} to name of slot "%loop-number - 1%" parsed as an integer of current inventory of player
				set {ec2.%player%.lore::%loop-number - 1%} to lore 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 {ec2.%player%.amount::%loop-number - 1%} to the first 2 character of "%{_temp}%"
				replace " " in {ec2.%player%.amount::%loop-number - 1%} with ""
				set {ec2.%player%.amount::%loop-number - 1%} to {ec2.%player%.amount::%loop-number - 1%} parsed as integer
				if {ec2.%player%.amount::%loop-number - 1%} isn't an integer:
					set {ec2.%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 "ec1":
		{db1.openedenderchest.%player%} is false
		cancel event
		open chest with 3 rows named "Coffre du Néant II" 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 {ec2.%player%.item::*}:
			if "%{ec2.%player%.name::%loop-index%}%" is "<none>":
				set {_item} to "%loop-value%" parsed as an item type
				add {ec2.%player%.amount::%loop-index%} of {_item} with lore {ec2.%player%.lore::%loop-index%} to current inventory of player
				message "%{ec2.%player%.amount::%loop-index%}%"
			else:
				set {_item} to "%loop-value%" parsed as an item type
				add {ec2.%player%.amount::%loop-index%} of {_item} named {ec2.%player%.name::%loop-index%} with lore {ec2.%player%.lore::%loop-index%} to current inventory of player
				message "%{ec2.%player%.amount::%loop-index%}%"
		while inventory name of current inventory of player is "Coffre du Néant II":
			make the event-block appear open
			wait 2 tick