BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: Riccarr on June 03, 2009, 10:20:31 pm

Title: Member leaving ... auto removed?
Post by: Riccarr on June 03, 2009, 10:20:31 pm

Hello,

Age of Conan.

When a new member/guildee speaks in guild chat, the bot recognized them and adds them to the user list.

Question. How (or does) the user get removed if the person quietly leaves the guild? Am I support to do "!member delete" when they leave or does the bot get notified somehow?

Title: Re: Member leaving ... auto removed?
Post by: Alreadythere on June 03, 2009, 11:26:02 pm

I don't think there is any way for the bot to notice someone leaving the guild in AoC. So there is no save automatic way to update the member list.

Title: Re: Member leaving ... auto removed?
Post by: Poonjab on June 04, 2009, 12:40:48 am

What's the best / easiest way to manually remove someone that you know has left the guild?

Title: Re: Member leaving ... auto removed?
Post by: Riccarr on June 04, 2009, 01:03:47 am

Ok, does that include the buddy list?

In otherwords, does the bot still get "connect" events for buddies who have left the guild?  If not, how was the bot notified that they are not a buddy anymore?

Sorry for badgering on this topic, I just want to be clear on how that aspect works. Thanks for your time.

Title: Re: Member leaving ... auto removed?
Post by: Alreadythere on June 04, 2009, 11:51:11 pm

Unless a toon gets removed of notify the bot will keep tracking it.

!member del name should remove the membership as well as the notify.

Title: Re: Member leaving ... auto removed?
Post by: OTGBot on June 06, 2009, 12:26:45 am

I've been experiencing the same thing.

The !member remove doesn't remove them at all.  It marks them in the database as been deleted.
We still receive all login/logout messages for the removed members.

I've gone into the database directly and tried to remove them.  They still show up. 

Where exactly do I need to delete members permanently. 

If I know that, I can write a simple bash script that will go delete that member from every table in the bot.

Please help.

Title: Re: Member leaving ... auto removed?
Post by: OTGBot on June 08, 2009, 09:34:00 pm

Ok,

I've gone into the database and even wrote a script that will delete a name from 5 different tables.

You need to delete the name from these tables:

whois        field: nickname
online       field: nickname
alts           fields: alt, main
<botname>_users    fields char_name (I think).   

Confirm the field names before using below command.

I'm using the depot module, so I am removing from that as well.

mysql -u <mysql user> --password=<password> -e "delete from <tablename> where <fieldname>=\"<usertodelete>\";"


This will remove the character from the tables.

I have yet to confirm if this completely works or not.  I have deleted a bunch of old users/ex-guildies etc... and then tried a !whois command and it didn't come back with a response. 

BTW:  Those are commands from a unix system.  If you are running under windoze, your on your own there.