MFkTtmR8

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