Bonjour, Voici ma version de Minecraft: Thermos 1.7.10, Version de Skript la dernière dispo pour la 1.7.10
J'ai un problème avec mon skript que j'utilisais et qui ne fonctionne plus actuellement avec ce code
d'erreur "update (yes/no) is not a boolean" Voici une ligne d'erreur "
> [21:09:04 ERROR]: 'update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"' is not a boolean (yes/no) (administration.sk, line 297: update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"')"
Voici le code : "
script options:
$ init com.mysql.jdbc.Driver
$ db url jdbc: //Caché\\
$ db username //Caché\\
$ db password //Caché\\
options:
logo-erreur: &7-={&cErreur&7}=-
logo: &7-={&3AlyniaRP&7}=-
logo-mesinfos: &7-={&cMes Informations&7}=&l&m-
aliases:
BluePane= 160:11
WhitePane= 160
RedPane= 160:14
GrayPane= 160:7
ManageRang= 4589
Clear= 4310:14
AdministrateurRang= 4607
ResponsableRang= 4591
DéveloppeurRang= 4599
ModérateurRang= 4325
BuildeurRang= 4323
AssistantRang= 4574
VipplusRang= 4549
MegaVipRang= 4550
YoutubeurRang= 4608:1075
idcard= 9124
command /mesinfo:
aliases: /mesinfos, /mes-info, /mes-infos
trigger:
set {_alltime} to the first element out of objects in column "alltime" from result of query "SELECT `alltime` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'"
set {_getime} to the first element out of objects in column "getime" from result of query "SELECT `getime` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'"
set {_h-all} to 0
set {_h-ge} to 0
loop 900 times:
set {_remove-ge} to 60*{_h-ge}
set {_reste-ge} to {_getime}-{_remove-ge}
if {_reste-ge} is less than 60:
stop loop
else:
set {_h-ge} to {_h-ge}+1
loop 900 times:
set {_remove-all} to 60*{_h-all}
set {_reste-all} to {_alltime}-{_remove-all}
if {_reste-all} is less than 60:
stop loop
else:
set {_h-all} to {_h-all}+1
send "&7&l&m-------------{@logo-mesinfos}---------------" to player
send "" to player
if {prenom.%player%} is not set:
send "&r &7&l➡ &6Prénom, Nom, Age&7: &cInconnu" to player
send "&r &7&l➡ &6Origine&7: &cInconnue" to player
else:
send "&r &7&l➡ &6Prénom, Nom, Age&7: &f%{prenom.%player%}% %{nom.%player%}%&7, &f%{age.%player%}% ans" to player
send "&r &7&l➡ &6Origine&7: &f%{origine.%player%}%" to player
send "" to player
if {_reste-all} is less than 10:
send "&7 &7&l➡ &6Temps de jeu&7: &f%{_h-all}%&7H&f0%{_reste-all}%" to player
else:
send "&7 &7&l➡ &6Temps de jeu&7: &f%{_h-all}%&7H&f%{_reste-all}%" to player
if {_reste-ge} is less than 10:
send "&7 &7&l➡ &6Temps en gendarme&7: &f%{_h-ge}%&7H&f0%{_reste-ge}%" to player
else:
send "&7 &7&l➡ &6Temps Gendarme&7: &f%{_h-ge}%&7H&f%{_reste-ge}%" to player
send "" to player
send "&7&l&m---------------------------------------------" to player
on weather change:
cancel event
every 1 minutes:
loop all players:
set {_alltime} to the first element out of objects in column "alltime" from result of query "SELECT `alltime` FROM `minecraft_playerInfo` WHERE `uuid` = '%loop-player's uuid%'"
set {_alltime} to {_alltime}+1
update "UPDATE `minecraft_playerInfo` SET `alltime` = '%{_alltime}%' WHERE `uuid` = '%loop-player's uuid%'"
if {tempjob.%loop-player%} is "Gendarme":
set {_getime} to the first element out of objects in column "getime" from result of query "SELECT `alltime` FROM `minecraft_playerInfo` WHERE `uuid` = '%loop-player's uuid%'"
set {_getime} to {_getime}+1
update "UPDATE `minecraft_playerInfo` SET `getime` = '%{_getime}%' WHERE `uuid` = '%loop-player's uuid%'"
on quit:
clear {rang.%player%}
clear {identity.create.chat.%player%}
clear {prenom.%player%}
clear {nom.%player%}
clear {age.%player%}
clear {origine.%player%}
on join:
add objects in column "pseudo" from result of query "SELECT * FROM `minecraft_playerInfo` WHERE `pseudo` = '%player%'" and close to {_check::*}
if {_check::*} is not set:
update "INSERT INTO `minecraft_playerInfo` (`pseudo`, `uuid`) VALUES ('%player%', '%player's uuid%')"
else:
set {rang.%player%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'" and close
set {prenom.%player%} to the first element out of objects in column "prenom" from result of query "SELECT `prenom` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'" and close
set {nom.%player%} to the first element out of objects in column "nom" from result of query "SELECT `nom` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'" and close
set {age.%player%} to the first element out of objects in column "age" from result of query "SELECT `age` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'" and close
set {origine.%player%} to the first element out of objects in column "origine" from result of query "SELECT `origine` FROM `minecraft_playerInfo` WHERE `uuid` = '%player's uuid%'" and close
on chat:
if {identity.create.chat.%player%} is set:
if message is set:
if message is "annuler" or "cancel":
send "{@logo} &cAnnulation de la création de votre identité !" to player
cancel event
else:
if {prenom.%player%} is not set:
cancel event
set {prenom.%player%} to message
send "{@logo} &aVeuillez entrer votre &cNom de Famille&a."
else if {nom.%player%} is not set:
cancel event
set {nom.%player%} to message
send "{@logo} &aVeuillez entrer votre &cAge&a."
else if {age.%player%} is not set:
cancel event
set {age.%player%} to message
send "{@logo} &aVeuillez entrer votre &cOrigine&a."
send "{@logo} &a&oVous pouvez avoir plusieurs origines, pour les mettres faites comme dans l'exemple : &6&oBelge, Française"
else if {origine.%player%} is not set:
cancel event
set {origine.%player%} to message
update "UPDATE `minecraft_playerInfo` SET `prenom` = '%{prenom.%player%}%', `nom` = '%{nom.%player%}%', `origine` = '%{origine.%player%}%', `age` = '%{age.%player%}%' WHERE `uuid` = '%player's uuid%'"
send "{@logo} &aVous venez de recevoir votre carte d'identité."
give idcard named "&aCarte d'identité" with lore "&7-= &aPrénom &7: &e%{prenom.%player%}% &7=-||&7-= &aNom &7: &e%{nom.%player%}% &7=-||&7-= &aAge &7: &e%{age.%player%}% Ans &7=-||&7-= &aOrigine &7: &e%{origine.%player%}% &7=-||&7-= &aSurnom &7: &c%player% &7=-" to player
clear {identity.create.chat.%player%}
on rightclick on entity:
set {_loc} to location of clicked entity
if x-coordinate of {_loc} is -47.5:
if y-coordinate of {_loc} is 70.0:
if z-coordinate of {_loc} is 422.5:
if {prenom.%player%} is not set:
send "{@logo} &7La création de votre carte d'identité commence dans 5 secondes." to player
wait 5 seconds
send "{@logo} &7Pour annuler le processus écrivez &cannuler" to player
set {identity.create.chat.%player%} to true
send "{@logo} &aVeuillez entrer votre &cPrénom&a." to player
else:
if player's inventory contains idcard:
send "{@logo} &cVous avez déjà une carte d'identité sur vous !" to player
else:
give idcard named "&aCarte d'identité" with lore "&7-= &aPrénom &7: &e%{prenom.%player%}% &7=-||&7-= &aNom &7: &e%{nom.%player%}% &7=-||&7-= &aAge &7: &e%{age.%player%}% Ans &7=-||&7-= &aOrigine &7: &e%{origine.%player%}% &7=-||&7-= &aSurnom &7: &c%player% &7=-" to player
every 6 second:
loop all players:
add 1 to {_nb}
loop all players:
display board named "{@logo}" to loop-player
make score "&d " in board of loop-player to 10
make score "&eRang&7:" in board of loop-player to 9
if {rang.%loop-player%} is not "Joueur":
if {rang.%loop-player%} is not "Youtubeur":
if {rang.%loop-player%} is not "VIP":
if {rang.%loop-player%} is not "VIPPLUS":
if {rang.%loop-player%} is not "MEGAVIP":
if {rang.%loop-player%} is "Administrateur":
make score "➡ &cAdmin" in board of loop-player to 8
if {rang.%loop-player%} is "Responsable":
make score "➡ &9Responsable" in board of loop-player to 8
if {rang.%loop-player%} is "Développeur":
make score "➡ &bDéveloppeur" in board of loop-player to 8
if {rang.%loop-player%} is "Modérateur":
make score "➡ &6Modérateur" in board of loop-player to 8
if {rang.%loop-player%} is "Buildeur":
make score "➡ &2Buildeur" in board of loop-player to 8
if {rang.%loop-player%} is "Assistant":
make score "➡ &aAssistant" in board of loop-player to 8
else:
make score "➡ &eMega-VIP" in board of loop-player to 8
else:
make score "➡ &eVIP+" in board of loop-player to 8
else:
make score "➡ &eVIP" in board of loop-player to 8
else:
make score "➡ You&4Tubeur" in board of loop-player to 8
else:
make score "➡ &dJoueur" in board of loop-player to 8
make score "&6 " in board of loop-player to 7
make score "&2Connectés&7:" in board of loop-player to 6
make score "➡ &a%{_nb}%&7/&a50" in board of loop-player to 5
make score "&6 " in board of loop-player to 4
make score "&dMétier&7:" in board of loop-player to 3
if {tempjob.%loop-player%} is set:
make score "➡ &6%{tempjob.%loop-player%}%" in board of loop-player to 2
else:
make score "➡ &aChomeur" in board of loop-player to 2
make score "&6 " in board of loop-player to 1
make score "&7------------" in board of loop-player to 0
move display of loop-player to sidebar
command /manage [<player>] [<text>] [<text>] [<text>]:
trigger:
if player has permission "alynia.manage.use":
if arg 1 is set:
wait 2 tick
open chest with 1 rows named "&cGestion &8: &b%arg-1%" to player
wait 1 tick
format slot 0 of player with GrayPane named "&c" to be unstealable
format slot 1 of player with GrayPane named "&c" to be unstealable
format slot 2 of player with idcard named "&cSuppression de l'identité" with lore " &7➡ &bPermet de supprimer l'identité rp du joueur" to run [make player execute command "manage %arg-1% identité clear"]
format slot 3 of player with GrayPane named "&c" to be unstealable
format slot 4 of player with ManageRang named "&cRang" with lore " &7➡ &bPermet de gérer le rang du joueur" to run [make player execute command "manage %arg-1% rang"]
format slot 5 of player with GrayPane named "&c" to be unstealable
format slot 6 of player with idcard named "&cSuppression de l'identité" with lore " &7➡ &bPermet de supprimer l'identité rp du joueur" to run [make player execute command "manage %arg-1% identité clear"]
format slot 7 of player with GrayPane named "&c" to be unstealable
format slot 8 of player with GrayPane named "&c" to be unstealable
if arg 2 is "identité":
if arg 3 is "clear":
update "UPDATE `minecraft_playerInfo` SET `prenom` = NULL, `nom` = NULL, `origine` = NULL, `age` = NULL WHERE `pseudo` = '%arg-1%'"
send "{@logo} &6Vous venez de supprimer l'identité roleplay de %arg-1%" to player
send "{@logo} &6Votre identité roleplay vient d'être supprimée par %player%" to arg-1
clear {prenom.%arg-1%}
clear {nom.%arg-1%}
clear {age.%arg-1%}
clear {origine.%arg-1%}
# Menu des Rangs
if arg 2 is "rang":
if arg 3 is not set:
wait 2 tick
open chest with 6 rows named "&cGestion &8: &b%arg-1%" to player
wait 1 tick
format slot 0 of player with GrayPane named "&c" to be unstealable
format slot 1 of player with GrayPane named "&c" to be unstealable
format slot 2 of player with GrayPane named "&c" to be unstealable
format slot 3 of player with GrayPane named "&c" to be unstealable
format slot 4 of player with GrayPane named "&c" to be unstealable
format slot 5 of player with GrayPane named "&c" to be unstealable
format slot 6 of player with GrayPane named "&c" to be unstealable
format slot 7 of player with GrayPane named "&c" to be unstealable
format slot 8 of player with GrayPane named "&c" to be unstealable
format slot 9 of player with GrayPane named "&c" to be unstealable
format slot 10 of player with AdministrateurRang named "&cAdministrateur" to close then run [make player execute command "manage %arg-1% rang add Administrateur"]
format slot 11 of player with GrayPane named "&c" to be unstealable
format slot 12 of player with ResponsableRang named "&bResponsable" to close then run [make player execute command "manage %arg-1% rang add Responsable"]
format slot 13 of player with GrayPane named "&c" to be unstealable
format slot 14 of player with DéveloppeurRang named "&3Développeur" to close then run [make player execute command "manage %arg-1% rang add Développeur"]
format slot 15 of player with GrayPane named "&c" to be unstealable
format slot 16 of player with ModérateurRang named "&6Modérateur" to close then run [make player execute command "manage %arg-1% rang add Modérateur"]
format slot 17 of player with GrayPane named "&c" to be unstealable
format slot 18 of player with GrayPane named "&c" to be unstealable
format slot 19 of player with GrayPane named "&c" to be unstealable
format slot 20 of player with BuildeurRang named "&2Buildeur" to close then run [make player execute command "manage %arg-1% rang add Buildeur"]
format slot 21 of player with GrayPane named "&c" to be unstealable
format slot 22 of player with YoutubeurRang named "&f&lYou&4&lTubeur" to close then run [make player execute command "manage %arg-1% rang add Youtubeur"]
format slot 23 of player with GrayPane named "&c" to be unstealable
format slot 24 of player with AssistantRang named "&9Assistant" to close then run [make player execute command "manage %arg-1% rang add Assistant"]
format slot 25 of player with GrayPane named "&c" to be unstealable
format slot 26 of player with GrayPane named "&c" to be unstealable
format slot 27 of player with GrayPane named "&c" to be unstealable
format slot 28 of player with GrayPane named "&c" to be unstealable
format slot 29 of player with GrayPane named "&c" to be unstealable
format slot 30 of player with Clear of unbreaking 999 named "&cSuppression des rangs" to close then run [make player execute command "manage %arg-1% rang clear"]
format slot 31 of player with GrayPane named "&c" to be unstealable
format slot 32 of player with Clear of unbreaking 999 named "&cSuppression des rangs" to close then run [make player execute command "manage %arg-1% rang clear"]
format slot 33 of player with GrayPane named "&c" to be unstealable
format slot 34 of player with GrayPane named "&c" to be unstealable
format slot 35 of player with GrayPane named "&c" to be unstealable
format slot 36 of player with GrayPane named "&c" to be unstealable
format slot 37 of player with diamond named "&eVIP" to close then run [make player execute command "manage %arg-1% rang add VIP"]
format slot 38 of player with GrayPane named "&c" to be unstealable
format slot 39 of player with GrayPane named "&c" to be unstealable
format slot 40 of player with VipplusRang named "&eVIP+" to close then run [make player execute command "manage %arg-1% rang add VIPPlus"]
format slot 41 of player with GrayPane named "&c" to be unstealable
format slot 42 of player with GrayPane named "&c" to be unstealable
format slot 43 of player with MegaVipRang named "&eMegaVIP" to close then run [make player execute command "manage %arg-1% rang add MegaVIP"]
format slot 44 of player with GrayPane named "&c" to be unstealable
format slot 45 of player with GrayPane named "&c" to be unstealable
format slot 46 of player with GrayPane named "&c" to be unstealable
format slot 47 of player with GrayPane named "&c" to be unstealable
format slot 48 of player with GrayPane named "&c" to be unstealable
format slot 49 of player with GrayPane named "&c" to be unstealable
format slot 50 of player with GrayPane named "&c" to be unstealable
format slot 51 of player with GrayPane named "&c" to be unstealable
format slot 52 of player with GrayPane named "&c" to be unstealable
format slot 53 of player with GrayPane named "&c" to be unstealable
# Ajouts des Rangs
if arg 3 is "add":
# Rang STAFF
if arg 4 is "administrateur":
make console execute command "manuadd %arg-1% Administrateur world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "responsable":
make console execute command "manuadd %arg-1% Responsable world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "développeur":
make console execute command "manuadd %arg-1% Dev world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "modérateur":
make console execute command "manuadd %arg-1% Modérateur world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "buildeur":
make console execute command "manuadd %arg-1% Buildeur world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "assistant":
make console execute command "manuadd %arg-1% Assistant world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
# Rang Joueur
if arg 4 is "vip":
if arg-1 has permission "rang.staff":
make console execute command "manuaddsub %arg-1% VIP"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
else:
make console execute command "manuadd %arg-1% VIP world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "vipplus":
if arg-1 has permission "rang.staff":
make console execute command "manuaddsub %arg-1% VIP+"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
else:
make console execute command "manuadd %arg-1% VIP+ world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "megavip":
if arg-1 has permission "rang.staff":
make console execute command "manuaddsub %arg-1% Mega-VIP"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
else:
make console execute command "manuadd %arg-1% Mega-VIP world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
if arg 4 is "youtubeur":
if arg-1 has permission "rang.staff":
make console execute command "manuaddsub %arg-1% Youtubeur"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
else:
make console execute command "manuadd %arg-1% Youtubeur world"
send "{@logo} &6Tu viens de &cmettre&6 le rang &c%arg-4% &6à &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &amettre&6 le rang &c%arg-4%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = '%arg-4%' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
# Suppression des rangs d'un joueur bien précis
if arg 3 is "clear":
if {rang.%arg-1%} is not set:
send "{@logo-erreur} &cLe joueur &3%arg 1% &cn'a aucun rang" to player
else:
make console execute command "manuadd %arg-1% Civil"
send "{@logo} &6Tu viens de &csupprimer&6 le rang de &3%arg 1%" to player
send "{@logo} &6Le joueur &3%player% &6viens de te &csupprimer&6 ton rang de &3%{rang.%arg-1%}%" to arg-1
update "UPDATE `minecraft_playerInfo` SET `rang` = 'joueur' WHERE `pseudo` = '%arg-1%'"
set {rang.%arg-1%} to the first element out of objects in column "rang" from result of query "SELECT `rang` FROM `minecraft_playerInfo` WHERE `pseudo` = '%arg-1%'" and close
else:
send "{@logo-erreur} &cVeuillez saisir le pseudo d'un joueur connecté !" to player
else:
send "{@logo-erreur} &cVous n'avez pas la permission d'exécuter cette commande !" to player
"
Merci d'avance !