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

Ebag333 · « **Reply #15 on:** August 07, 2007, 03:47:22 am »

Don't worry about the help comment, that's older from when we had multiple relay plugins.

As for online, check: !settings online

There's a place in there to set what bots online lists you want to pull from (assuming all bots use the same online table).

Diablo · « **Reply #16 on:** August 07, 2007, 03:55:03 am »

Yea i checked those are set right. i commented out the last two options in mysql settings. That should make them all use same table right.

Diablo · « **Reply #17 on:** August 10, 2007, 02:51:14 pm »

Instead of commenting out the $table_prefix and $master_tablename should i just make them the same name like "bot1" and "bot1_tablenames"? I gone through all the other settings several times and they all seem ok its just like its not reading the same tables for online?

Alreadythere · « **Reply #18 on:** August 10, 2007, 03:05:04 pm »

Are you sure your bots are all using the same database?

Diablo · « **Reply #19 on:** August 10, 2007, 03:08:35 pm »

Yes just checked all three bots and they are using same db. Should the relaybot be using it too dont think that would affect it but never know?

Alreadythere · « **Reply #20 on:** August 10, 2007, 03:41:37 pm »

I prefer using just one database, but no, the relay bot shouldn't affect anything there.

Do you have more then one online table? Or just one global one?

Temar · « **Reply #21 on:** August 10, 2007, 03:55:20 pm »

i think by default the online table is seperate
to change to share online table you need to
you need to go on table botname_tablenames
find internal name online and change use prefix to false
for each of your bots
then restart your bots

i think this should be change to default false as it doesnt matter about shared online table with seperate bots as bots will ignore other names not set to there bot unless told to

Diablo · « **Reply #22 on:** August 10, 2007, 04:06:18 pm »

Yes i checked the tables and they are seperated by bots and i have three different bots_online tables.

Alreadythere · « **Reply #23 on:** August 10, 2007, 04:11:46 pm »

The default for the online table is one global online table, not one per bot. Pretty sure it was like that since the module got added.

But that's your problem, you have to change your setup to only use one global online table. Read Temar's post above how to do that.

Diablo · « **Reply #24 on:** August 10, 2007, 04:12:53 pm »

Ok um is that in the onlinedb.php where its $db -> define_tablename("online", "false")."
Thats how its set now.

Alreadythere · « **Reply #25 on:** August 10, 2007, 04:14:03 pm »

That's how it should look like.

But to get it to work you have either to remove the entries for the online table from the master tables of your bots, or do the editing Temar posted.

Edit: Both changes require a restart of your bot.

Diablo · « **Reply #26 on:** August 10, 2007, 04:36:52 pm »

So im supposed to change the onlinedb file in the core folder correct. It was set as false already when i opened it. Or do i edit the table itself under bots_tablenames?

Diablo · « **Reply #27 on:** August 10, 2007, 04:59:48 pm »

Ok i found in the mysql.php file , use_prefix VARCHAR (10) NOT NULL DEFAULT 'false')");

thats how all three bots where set by default.

Alreadythere · « **Reply #28 on:** August 10, 2007, 05:05:46 pm »

You have to modify the 3 bot_tablenames tables, best remove the entries for the online tables by doing DELETE FROM bot_tablenames WHERE internal_name = 'online'. Or use some tool like phpMyAdmin to edit the entries, and set use_prefix to talse.

Don't edit your MySQL.php or OnlineDB.php files, that's not needed.

Temar · « **Reply #29 on:** August 10, 2007, 05:06:14 pm »

false is what we want to be
after some testing
i removed botname_online
i removed online entry from botname_tablenames
restarted bot
and it made a table online
so that works
but then i added a new bot so it did the entire new bot add tables etc
i ended up with botname_online :/

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

Ebag333

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

Diablo

Re: Multi bot db setup.

Alreadythere

Re: Multi bot db setup.

Temar

Re: Multi bot db setup.

Diablo

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.

Temar

Re: Multi bot db setup.