Comment reset un joueur sur Le PhpMyAdmin

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:

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.

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

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

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.

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

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’;

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