FJJwXES9

1script options:
2    $ db url jdbc:mysql://localhost:3306/skriptGTA2
3    $ db username root
4    $ db password craft
5options:
6	table_prefix: EC_   
7On script load:
8	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))"
9
10
11on join:
12	add objects in column "Objet" from result of query "SELECT Objet FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.item::*}
13	add objects in column "Nom" from result of query "SELECT Nom FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.name::*}
14	add objects in column "Lore" from result of query "SELECT Lore FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.lore::*}
15	add objects in column "Montant" from result of query "SELECT Montant FROM {@table_prefix}Player WHERE Player = '%player%'" to {ec2.%player%.amount::*}
16	update "DELETE FROM `EC_Player` WHERE Player = '%player%'"
17
18on disconnect:
19	loop {ec2.%player%.item::*}:
20		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%}%')"
21	delete {ec2.%player%.item::*}
22	delete {ec2.%player%.name::*}
23	delete {ec2.%player%.lore::*}
24	delete {ec2.%player%.amount::*}
25	
26on inventory close:
27	{db1.openedenderchest.%player%} is true
28	if inventory name of current inventory of player is "Coffre du Néant II":
29		clear {ec2.%player%.item::*}
30		clear {ec2.%player%.amount::*}
31		clear {ec2.%player%.name::*}
32		clear {ec2.%player%.lore::*}
33		loop 27 times:
34			set {_air} to slot "%loop-number - 1%" parsed as an integer of current inventory of player
35			if "%{_air}%" isn't "air":
36				set {ec2.%player%.slot::%loop-number - 1%} to loop-number
37				set {ec2.%player%.item::%loop-number - 1%} to type of slot "%loop-number - 1%" parsed as an integer of current inventory of player
38				set {ec2.%player%.name::%loop-number - 1%} to name of slot "%loop-number - 1%" parsed as an integer of current inventory of player
39				set {ec2.%player%.lore::%loop-number - 1%} to lore of slot "%loop-number - 1%" parsed as an integer of current inventory of player
40				set {_temp} to slot "%loop-number - 1%" parsed as an integer of current inventory of player
41				set {ec2.%player%.amount::%loop-number - 1%} to the first 2 character of "%{_temp}%"
42				replace " " in {ec2.%player%.amount::%loop-number - 1%} with ""
43				set {ec2.%player%.amount::%loop-number - 1%} to {ec2.%player%.amount::%loop-number - 1%} parsed as integer
44				if {ec2.%player%.amount::%loop-number - 1%} isn't an integer:	
45					set {ec2.%player%.amount::%loop-number - 1%} to 1
46		set {db1.openedenderchest.%player%} to false
47		stop
48		
49on rightclick on ender chest:
50	if difference between {db1.openedenderchest.time.%player%} and now is less than 2 seconds:
51		send player title "" with subtitle "&1[&3Police&1] &7Pas bien le spam !" for 10 ticks
52		cancel event
53		stop
54	if "%region at event-block%" contains "ec1":
55		{db1.openedenderchest.%player%} is false
56		cancel event
57		open chest with 3 rows named "Coffre du Néant II" to player
58		set {db1.openedenderchest.time.%player%} to now
59		set {db1.openedenderchest.%player%} to true
60		make the event-block appear open
61		wait 1 tick
62		loop {ec2.%player%.item::*}:
63			if "%{ec2.%player%.name::%loop-index%}%" is "<none>":
64				set {_item} to "%loop-value%" parsed as an item type
65				add {ec2.%player%.amount::%loop-index%} of {_item} with lore {ec2.%player%.lore::%loop-index%} to current inventory of player
66				message "%{ec2.%player%.amount::%loop-index%}%"
67			else:
68				set {_item} to "%loop-value%" parsed as an item type
69				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
70				message "%{ec2.%player%.amount::%loop-index%}%"
71		while inventory name of current inventory of player is "Coffre du Néant II":
72			make the event-block appear open
73			wait 2 tick