Author Topic: Deleting members that don't exist anymore (Read 2656 times)

MysterF · « **on:** March 31, 2009, 11:17:56 am »

As the thread sayz lately some of the members start deleting old chars before I had a chance to remove them from bot.

Now I got the following error:

Code: [Select]

MyBOT [ERROR]       [AOChatWrapper_Core]    I was unable to get the user id
for user: 'blablabla'

I tried to delete the member name from bot member list but still the error is there.
Is there anyway i can do it from bot commands or I need to do SQL surgery

?

Alreadythere · « **Reply #1 on:** April 02, 2009, 05:29:26 pm »

Right now there is no command to remove an entry of the member list.

Organizer · « **Reply #2 on:** April 02, 2009, 08:51:32 pm »

Hi m8, place the attached file in your /custom/modules/ folder and use the command in game to delete any user from your DB without further check or warnings. It deletes from USERS table only!

/tell botname deleteuser <username>

Note! Bebot itself normally don't delete FYI, it only marks the character as deleted. This script actually deletes the player from the DB. Should not cause any issue, though have in mind if you have used the Alt/Main system there might be references that are sort of trash data here and there.

MysterF · « **Reply #3 on:** April 03, 2009, 03:18:58 pm »

Ty mate!
I'm testing it right now, will reply later with an edit if worked or not.

LATER EDIT: WORKS GREAT
Will make further tests but I think this can be sticky it releases the bot from lot of useless info -)
yes but you can use altadmin to delete the inexisting alt from list then use !deleteuser

Organizer · « **Reply #4 on:** April 03, 2009, 08:25:54 pm »

Sure you can, that said there could be raid points and other tables as well... none the less I've deleted before like this and not had any real issues with that. Been using the bot since 10+ months or so now...