PDA

View Full Version : No delete effect


Georgie
27-01-2004, 22:59
Hello M8.
Ilogg as supadmin and since a few days, im unable to delete some user.
help me please.
Best regards
Geo:rolleyes:

Dummer Sack
28-01-2004, 13:30
Have you tried to restart the server?
It also can be that the database got corrupt.
You can try to open the server.dbs file with sqlite (google for it) and delete the user in question with SQL commands:

select * from ts2_clients where s_client_name='LoginnameOfUser';

Note down i_client_id (I will call it client_id form now on) and i_client_server_id (I will call it server_id form now on) of the user you want to delete. Then do:

delete from ts2_clients where i_client_id=client_id and i_client_server_id=server_id;
delete from ts2_channel_privileges where i_cp_client_id=client_id and i_cp_server_id=server_id;

Backup server.dbs before you do that and also stop the server before editing the database.

Georgie
28-01-2004, 18:26
Thx so much i'll try right now:o :D