Author Topic: Multi bot db setup. (Read 6506 times)

Diablo · « **on:** August 03, 2007, 10:46:56 pm »

Hello I am running several bots that are linked and using the same db but i need to know what to set the tables prefixes and master tablenames for the bots. They are using same database and i have the table prefixes set to the bots name. Just not sure the proper way to set these up. Do i need to set each botname for the master_tablename also. Thanks

Diablo · « **Reply #1 on:** August 03, 2007, 10:59:15 pm »

Also wanted to make sure this is the only way to have it so online shows who is on from all the linked orgs.

Nytridr · « **Reply #2 on:** August 04, 2007, 09:44:16 am »

what I do is in bot.conf is just name it what the bots name is.. and then in <botname>_tablenames is where you can set it for each bot in the DB to either share the table or not. I have most of mine sharing except for the security stuff, members, ext.. and it seems to work well for me.

Like blacklist, online, ban, and so on I have removed in the tablename table the bot name and instead of true I put in false. and to show all the people across all bots that use the shared db do !settings online and you will see the setting for it.

Alreadythere · « **Reply #3 on:** August 04, 2007, 10:52:01 am »

Easiest way to do this is just setup your account info in Bot.conf, enter the information about the MySQL server in the MySQL.conf, and comment out $table_prefix and $master_tablename by putting // in front of the lines. That way the bot will automatically use $botname as prefix, and $botname_mastertable as mastertable.

With those settings just let all bots use the same database and then do /tell bot1 !set Online OtherBots bot2,bot3,bot4, while replacing the names with the names of your bots. Just make sure you don't include the name of the bot you are currently setting up in the otherbots list.

Diablo · « **Reply #4 on:** August 05, 2007, 07:27:10 pm »

So alreadytheres way would show every org linked on the online list and the security settings would be ok. Thanks

Alreadythere · « **Reply #5 on:** August 05, 2007, 07:37:29 pm »

Not sure what you mean about security - each bot will have it's own security.

Diablo · « **Reply #6 on:** August 05, 2007, 07:42:08 pm »

Ok thats what i was wondering just wanted to make sure they didnt share the same settings.

Diablo · « **Reply #7 on:** August 06, 2007, 02:13:35 am »

Ok i set everything up that way by commenting out the last two but i still cant see the linked bots org in the online list. Do i need the comma at the end of the bot list for the online part? They are using the same db name so not sure what else i could be missing. I added the relay bot in settings, is there anywhere else i should list it. Do i need to add the three bots to the ignore list in the bot.conf file?

Alreadythere · « **Reply #8 on:** August 06, 2007, 10:48:21 am »

If the bots share a database and you have set OtherBots correctly it should work. And no, you don't need a comma at the end of OtherBots, though it shouldn't harm as the online only uses valid character names in the OtherBots list.

kuznechik · « **Reply #9 on:** August 06, 2007, 03:59:12 pm »

Well, only problem with few bots sharing one DB for online is that it wipes online list every now and then, i.e. you start 1st bot, it marks all as offline and then get all online people marked as on in 1st org. Then second bot goes in and repeats. As result every1 in 1st org will be marked offline.

P.S.: Not checked how 0.4 acting now, 0.3 experience here, I ended up modifying online module a little adding org column to table and every bot was operating only his own org in online list.

Alreadythere · « **Reply #10 on:** August 06, 2007, 04:34:02 pm »

That's been a bug, it's fixed in 0.4.

Diablo · « **Reply #11 on:** August 06, 2007, 07:28:14 pm »

I noticed it shows all the bots in the online list since they were made members of it. Do i need to add them to notify list or something? Do I need to add the other bots to ignore lists or will that affect relay? Should the relaybot be set as raidbot or guild and does it need to be in one of the orgs? Thanks

Alreadythere · « **Reply #12 on:** August 06, 2007, 10:29:29 pm »

Quote from: Diablo on August 06, 2007, 07:28:14 pm

I noticed it shows all the bots in the online list since they were made members of it. Do i need to add them to notify list or something?

Which online list? Notify in which bot? The relaying bots don't need to be in the members list of each other, adding to guest list or some special security group with enough rights is sufficient.

Quote from: Diablo on August 06, 2007, 07:28:14 pm

Do I need to add the other bots to ignore lists or will that affect relay?

That would affect relaying, see above. The receiving bot needs to allow all possible sending bots to call the command !gcr.

Quote from: Diablo on August 06, 2007, 07:28:14 pm

Should the relaybot be set as raidbot or guild and does it need to be in one of the orgs?

Easiest is to create a pure raidbot, strip down to a minimum of modules, and have it handle nothing else. The bots in the relay need to be on autoinvite of the relaybot, and then just set in the org bots relay:relay to the name of the inviting bot.

Ebag333 · « **Reply #13 on:** August 06, 2007, 11:54:16 pm »

Make sure you disable as many commands as possible on the relaybot, you really don't want people being able to !join it as they can see all chat in there.

If you use the relay bot, you can actually set it up to relay many different orgs to each other. IE: you have orgs A, B, C, D, and E. Org's A and B can see each other (because Org A's bot has allowed Org B's bot access to !gcr and vice-versa), same for org's C and D, and org E see's everyone (but can't talk back to them because no one has given org E's bot access to !gcr).

If that doesn't make sense to you, and you only need to setup a 2 bot relay, just use the old tells. Though using a relay bot *IS* much faster, and keeps the bot from being too laggy.

Diablo · « **Reply #14 on:** August 07, 2007, 12:18:03 am »

I have 3 org bots and one relay bot. They are set to relay everything to each other so everyone see all chat and can talk back. When you do !online in bot1 it shows bot1 org online not the other two orgs. It does show bot2 and bot3 in the online list as well as the relay bot. I have set all the bots as members to each others bots. What i want is when you do !online in bot1 or bot2 etc. to show everyone who is online from bot1,bot2,and bot3. I have set them all to same db and them all up in the otherbot settings. But the !online still only shows online from the bot is was sent from.

Also confused on the gcr help it says to download relay.php and turn off the other two this is not needed right. I had read in forum that its already been put in files.
If it would help maybe someone could help me make sure its setup right. Thanks

Author Topic: Multi bot db setup. (Read 6506 times)

Diablo

Multi bot db setup.

Diablo

Re: Mulit bot db setup.

Nytridr

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

kuznechik

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

Ebag333

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.