BeBot - An Anarchy Online and Age Of Conan chat automaton

General => General discussion => Topic started by: snyder on August 16, 2009, 02:52:56 pm

Title: Delete members from bot ( and their alts )
Post by: snyder on August 16, 2009, 02:52:56 pm

i dont know if this exists or not, but since i didnt find it, i made my own member and alt delete script.

its small, simple, ugly, but works :)

http://www.cro-guild.com/razno/usermanager.zip
just run it from computer where bebot is.

you need to change 2 main things for this to work
database access

Code: [Select]

private $dbname = 'bebot'; // database name
private $dbpass = ''; // database password
private $dbuser = 'root'; // database username
private $dbserv = 'localhost';// database server

bot name in small letters

Code: [Select]

// bot name
private $botname = 'shonjo';

in include/usermanager.class.php

njoy, and feel free to make it even better and post updates!

bruno

Title: Re: Delete members from bot ( and their alts )
Post by: Jiheld on August 16, 2009, 06:54:46 pm

hi m8, think it looks nice, but it doesnt work for me,

Quote

File: usermanager.class.php
Line: 57
Message: Error on query!!

SQL:
select count(u.id) as num from aocbot_users as u

MySQL error: Table 'bot.aocbot_users' doesn't exist

MySQL error number: 1146

The db name is bot.
the name of the bot is embot.

But in my DB

Quote

Server: localhost   Database: bot   Table: aocbot__users

I do something wrong?

thnx,

Jih.

Title: Re: Delete members from bot ( and their alts )
Post by: snyder on August 16, 2009, 07:35:58 pm

wrong bot name? :)
if its embot then

Code: [Select]

Server: localhost   Database: bot   Table: [b]embot[/b]_users
post those 5 config lines

Title: Re: Delete members from bot ( and their alts )
Post by: Jiheld on August 16, 2009, 11:35:34 pm

got it working, nice work m8 and thnx for the help.

Cheerz

Jih.

Title: Re: Delete members from bot ( and their alts )
Post by: snyder on September 02, 2009, 11:37:10 am

updated with checkboxes for each alt char (when you select one from list to delete)
it should work (didnt test it yet, but it was minor change)

njoy,
bruno

Title: Re: Delete members from bot ( and their alts )
Post by: Jiheld on September 02, 2009, 12:28:01 pm

Thanks for the change m8, i made it password protected, so not all people can delete people.

http://www.enragedmessiahs.nl/download/usermanager.rar (http://www.enragedmessiahs.nl/download/usermanager.rar)

Just open password_protect.php and change the logins and passwords.

Cheerz Jih.

Title: Re: Delete members from bot ( and their alts )
Post by: Alreadythere on September 03, 2009, 07:54:16 am

Haven't tested it, but sounds like a nice idea.

Just one sidenote: the changes won't be active for the bot until the next time the members and alts table are read into the caches again. Alts are done once per hours, I don't know about the members caches offhand though.

Title: Re: Delete members from bot ( and their alts )
Post by: Khalem on September 03, 2009, 10:16:00 am

We should probably provide a way to force the bot to reload settings/cache in the future allowing for better integration with a web interface.

Title: Re: Delete members from bot ( and their alts )
Post by: snyder on September 03, 2009, 12:08:52 pm

i updated script a little. now there is nothing to config in usermanager.class.php, all is written in config.php in root.

i added user login (sry jih :P) and users are also added in config.php

please report bugs if any :)

p.s. link is still same in first post

njoy,
bruno