BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.3 support => Topic started by: Temar on June 23, 2007, 12:24:22 am

Title: privgroup
Post by: Temar on June 23, 2007, 12:24:22 am
i want a module like
http://bebot.link/index.php/topic,222.0.html
i know this new bot has some faction restriction etc but after like 5 tries i still havnt got a clue wat im doin with this flexible thing or if its what i want
Title: Re: privgroup
Post by: Alreadythere on June 23, 2007, 02:07:10 pm
Let's try a step-by-step guide :)


Now minlevel and faction allow you to set guest status to your bot on general terms. Just a slight warned, guests defined by those settings can use all GUEST and ANONYMOUS commands of the bot.
Title: Re: privgroup
Post by: Temar on June 23, 2007, 02:44:55 pm
Once i done that can any 1 with the right faction and level use !join when i have it set to guest?
Title: Re: privgroup
Post by: Alreadythere on June 23, 2007, 02:48:31 pm
Yes.

It counts anyone that meets the faction and level requirement as a member of the Guests group, which means they got the access rights defined by the group (in the above listing GUEST rights).

So they can use every command GUEST is allowed to use.
Title: Re: privgroup
Post by: Temar on June 23, 2007, 03:37:39 pm
it doesnt seem to be working
i did exactly wat u said
set faction to clan
and leminlevel to 140
!join is set to guest
i tryed to use !join with a 143 clan crat
and got
I only listen to members of this bot.
Title: Re: privgroup
Post by: Alreadythere on June 23, 2007, 04:20:42 pm
Do /tell botname !security whois name on an admin, with name the name of the crat.
It should return GUEST.

And /tell botname !help with a GUEST character to check which commands guest can use.

And check /tell botname !flexible to make sure the group exists AND-combined and contains two conditions, level and faction.
Title: Re: privgroup
Post by: Ebag333 on June 23, 2007, 06:07:53 pm
it doesnt seem to be working
i did exactly wat u said
set faction to clan
and leminlevel to 140
!join is set to guest
i tryed to use !join with a 143 clan crat
and got
I only listen to members of this bot.


It would be more helpful if you listed out the commands you used.

Also, check out the Wiki: http://bebot.link/wiki/flexible_security
Title: Re: privgroup
Post by: Temar on June 24, 2007, 02:13:43 am
it seem the setting arnt changeing
Quote
To [Battle150]: !minlevel
[Battle150]: Minimum level is currently set to 220.
To [Battle150]: !minlevel 100
[Battle150]: Minimum level is now set to 100.
To [Battle150]: !minlevel
[Battle150]: Minimum level is currently set to 220.
To [Battle150]: !faction
[Battle150]: Faction is currently set to exclude all.
To [Battle150]: !faction clan
[Battle150]: Faction is now set to  clan.
To [Battle150]: !faction
[Battle150]: Faction is currently set to exclude all.
Title: Re: privgroup
Post by: Temar on June 24, 2007, 04:29:45 am
this is wat i got in console
Quote
Battle150 [2007-06-24 02:25:56]   [TELL]   [INC]   Temarfix: !faction clan
MySQL error (# 2) on query: INSERT INTO Battle150_security_flexible (gid, field, condition, compareto) VALUES (4, 'faction', '=', 'clan')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, compareto) VALUES (4, 'faction', '=', 'clan')' at line 1
Battle150 [2007-06-24 02:25:56]   [TELL]   [OUT]   -> Temarfix: Faction is now set to  clan.
Battle150 [2007-06-24 02:25:58]   [TELL]   [INC]   Temarfix: !faction
MySQL error (# 3) on query: SELECT condition, compareto FROM Battle150_security_flexible WHERE gid = 4 AND field = 'faction'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, compareto FROM Battle150_security_flexible WHERE gid = 4 AND field = '' at line 1
MySQL error (# 4) on query: INSERT INTO Battle150_security_flexible (gid, field, condition, compareto) VALUES (4, 'faction', '!=', 'all')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, compareto) VALUES (4, 'faction', '!=', 'all')' at line 1
Battle150 [2007-06-24 02:25:58]   [TELL]   [OUT]   -> Temarfix: Faction is currently set to exclude all.
Title: Re: privgroup
Post by: Temar on June 24, 2007, 05:11:59 am
MySQL version 5.0.32
gnight cya tomorrow :D
Title: Re: privgroup
Post by: Alreadythere on June 24, 2007, 11:21:54 am
Forgot about that error in the 0.3.4 version (as it's fixed since shortly after release in SVN).

condition is a reserved word in mysql 5, so you need to escape it.
If you replace all instances of condition with `condition` the flexible security gui should work.
Title: Re: privgroup
Post by: Temar on June 24, 2007, 03:25:53 pm
i added ` to all condition in mysql things
now it seem to set the info but still not listen
from mysql - flexible_security
Quote
gid   field            compareto   condition   
5    faction    clan                =
5    level             140                >=
from mysql - flexible_groups
Quote
gid   name             description                access_level   
1    superadmin    Super Administrators    255
2    admin              Administrators        192
3    leader               Raid Leaders         128
5    guests              The group for guests set by minlevel and faction    1
the bot tell me that the faction is clan and minlevel is 140
!join is set to G
Test Subject is a 143 Clan
Quote
To [Battle150]: !join
[Battle150]: I only listen to members of this bot.
Title: Re: privgroup
Post by: Alreadythere on June 24, 2007, 05:32:22 pm
I think you didn't create a flexible extension, the two steps below.

  • Open the flexible group configuration with /tell botname !flexible
  • Create an AND-combined flexible extension for the Guests group by clicking on the [AND-combined] link.

Then there should be a third entry in your table, field = 'join', op = '&&'
Title: Re: privgroup
Post by: Temar on June 25, 2007, 01:02:09 am
ah yes now it works it is prob related to the mysql prob cuz i asumed the rest was done so only did !faction and !minlevel after i fixed the module
Title: Re: privgroup
Post by: Ebag333 on June 26, 2007, 05:43:05 pm
I would really suggest dropping the existing table, nabbing the SVN version of this, and redoing it.

I had a lot of problems with the condition column name, and as well the SVN version has a lot more error checking. :)
Title: Re: privgroup
Post by: Temar on June 26, 2007, 11:28:56 pm
Well i tried the SVN and it come up with error during bot boot up
so i just added ' to all the mysql queries with condition and it works fine
SimplePortal 2.3.7 © 2008-2025, SimplePortal