Comment reset un joueur sur Le PhpMyAdmin


#1

Bonsoir à tous,

Alors voilà je suis administrateur d’un serveur RP sur FiveM et actuellement je doit " reset " un utilisateur de mon serveur mais malheureusement je ne sais plus comment faire :sweat_smile:

Et j’aimerai bien savoir comment faire si vous le savez merci encore et bonne soirée a tous :wink:


#2

Tu dois supprimer tous les éléments qui contiennent le steamID64 (Hexadecimal) du joueur en question des différents tableaux contenu dans ta base de données.


#3

Oui je sais bien mais il me semble qu’il y avais une manip avec rechercher etc est c’est ça que je chercher


#4

Ahh, alors la je n’en ai aucune idée l’ami, désolé ! :roll_eyes:


#5

CTRL + F et tu colle le steam ID du joueur. Après pour moi c’est comme ça, mais je conseil de créer une requête SQL ou tu as juste à entrer l’ID du joueur et qui supprime toutes ces infos. C’est très simple à faire et ça te facilite la tache de manière exponentielle.


#6

slt tu va dans ta base de données et ensuite dans la table user et tu cherche l’utilisateur en question et tu le supprime


#7

Saluut avec ceci simplement faut juste que tu modifie le noms des tables par celle de ta bdd

– replace ‘steam:110000xxxxxx’ by steam of the one you want to delete

DELETE FROM addon_account_data WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM addon_inventory_items WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM billing WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM billing WHERE sender = ‘steam:110000xxxxxx’;
DELETE FROM datastore_data WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM jsfour_atm WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM open_car WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM owned_properties WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM owned_vehicles WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM owned_boats WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM rented_vehicles WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM rented_dock WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM rented_aircraft WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM open_car WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM user_accounts WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM phone_calls WHERE owner = ‘xxx-xxxx’;
DELETE FROM phone_messages WHERE transmitter = ‘xxx-xxxx’;
DELETE FROM phone_messages WHERE receiver = ‘xxx-xxxx’;
DELETE FROM phone_users_contacts WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM phone_users_contacts WHERE number = ‘xxx-xxxx’;
DELETE FROM playerstattoos WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM user_inventory WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM user_licenses WHERE owner = ‘steam:110000xxxxxx’;
DELETE FROM user_parkings WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM characters WHERE identifier = ‘steam:110000xxxxxx’;
DELETE FROM users WHERE identifier = ‘steam:110000xxxxxx’;


#8

Salut je n’y connais vraiment rien possible d’avoir quelque screen ou même une vidéo ?