Author Topic: Delete members from bot ( and their alts ) (Read 11082 times)

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

Jiheld · « **Reply #1 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.

snyder · « **Reply #2 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

Jiheld · « **Reply #3 on:** August 16, 2009, 11:35:34 pm »

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

Cheerz

Jih.

snyder · « **Reply #4 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

Jiheld · « **Reply #5 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

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

Cheerz Jih.

Alreadythere · « **Reply #6 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.

Khalem · « **Reply #7 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.

snyder · « **Reply #8 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

) and users are also added in config.php

please report bugs if any

p.s. link is still same in first post

njoy,
bruno