m2FuwvNv

1On script load:
2	update "CREATE TABLE IF NOT EXISTS {@table_prefix}_Player (Arme varchar(255),Nom varchar(255),Degats varchar(255),Munition varchar(255),NomMunition varchar(255),MunMax TINYINT,Cadence TINYINT,Tchargement TINYINT,Balle varchar(255),VitesseB TINYINT,NombreB TINYINT,Durabilite SMALLINT,SonCh varchar(255),SonTir varchar(255))"
3	delete {{@table_prefix}.arme::*}
4	add objects in column "Arme" from result of query "SELECT Arme FROM {@table_prefix}_Player WHERE 1" to {{@table_prefix}.arme::*}
5	loop {{@table_prefix}.arme::*}:
6		set {{@table_prefix}.%loop-value%.Arme} to loop-value parsed as an item type
7		set {{@table_prefix}.%loop-value%.Nom} to the first element out of objects in column "Nom" from result of query "SELECT Nom FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
8		set {{@table_prefix}.%loop-value%.Nom} to {{@table_prefix}.%loop-value%.Nom} parsed as an text
9		set {{@table_prefix}.%loop-value%.NomMunition} to the first element out of objects in column "NomMunition" from result of query "SELECT NomMunition FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
10		set {{@table_prefix}.%loop-value%.NomMunition} to {{@table_prefix}.%loop-value%.NomMunition} parsed as an text
11		set {{@table_prefix}.%loop-value%.Munition} to the first element out of objects in column "Munition" from result of query "SELECT Munition FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
12		set {{@table_prefix}.%loop-value%.Munition} to {{@table_prefix}.%loop-value%.Munition} parsed as item type
13		set {{@table_prefix}.%loop-value%.Degats} to the first element out of objects in column "Degats" from result of query "SELECT Degats FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
14		set {{@table_prefix}.%loop-value%.Degats} to {{@table_prefix}.%loop-value%.Munition} parsed as an integer
15		set {{@table_prefix}.%loop-value%.MunMax} to the first element out of objects in column "MunMax" from result of query "SELECT MunMax FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
16		set {{@table_prefix}.%loop-value%.MunMax} to {{@table_prefix}.%loop-value%.MunMax} parsed as an integer
17		set {{@table_prefix}.%loop-value%.Cadence} to the first element out of objects in column "Cadence" from result of query "SELECT Cadence FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
18		set {{@table_prefix}.%loop-value%.Cadence} to "%{{@table_prefix}.%loop-value%.Cadence}% tick" parsed as an timespan
19		set {{@table_prefix}.%loop-value%.Tchargement} to the first element out of objects in column "Tchargement" from result of query "SELECT Tchargement FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
20		set {{@table_prefix}.%loop-value%.Tchargement} to "%{{@table_prefix}.%loop-value%.Tchargement}% tick" parsed as an timespan
21		set {{@table_prefix}.%loop-value%.Balle} to the first element out of objects in column "Balle" from result of query "SELECT Balle FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
22		set {{@table_prefix}.%loop-value%.Balle} to "%{{@table_prefix}.%loop-value%.Balle}% tick" parsed as entity type
23		set {{@table_prefix}.%loop-value%.VitesseB} to the first element out of objects in column "VitesseB" from result of query "SELECT VitesseB FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
24		set {{@table_prefix}.%loop-value%.VitesseB} to {{@table_prefix}.%loop-value%.VitesseB} parsed as an integer
25		set {{@table_prefix}.%loop-value%.NombreB} to the first element out of objects in column "NombreB" from result of query "SELECT NombreB FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
26		set {{@table_prefix}.%loop-value%.NombreB} to {{@table_prefix}.%loop-value%.NombreB} parsed as an integer
27		set {{@table_prefix}.%loop-value%.Durabilite} to the first element out of objects in column "Durabilite" from result of query "SELECT Durabilite FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
28		set {{@table_prefix}.%loop-value%.Durabilite} to {{@table_prefix}.%loop-value%.Durabilite} parsed as an integer
29		set {{@table_prefix}.%loop-value%.SonCh} to the first element out of objects in column "SonCh" from result of query "SELECT SonCh FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
30		set {{@table_prefix}.%loop-value%.SonCh} to {{@table_prefix}.%loop-value%.SonCh} parsed as an text
31		set {{@table_prefix}.%loop-value%.SonTir} to the first element out of objects in column "SonTir" from result of query "SELECT SonTir FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
32		set {{@table_prefix}.%loop-value%.SonTir} to {{@table_prefix}.%loop-value%.SonTir} parsed as an text
33		set {{@table_prefix}.%loop-value%.ChDura} to the first element out of objects in column "ChDura" from result of query "SELECT ChDura FROM {@table_prefix}_Player WHERE Arme = '%loop-value%'"
34		set {{@table_prefix}.%loop-value%.ChDura} to {{@table_prefix}.%loop-value%.ChDura} parsed as an integer