collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18366
  • stats Total Topics: 2501
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

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

0 Members and 2 Guests are viewing this topic.

Offline Ebag333

  • Contributor
  • *******
  • Posts: 134
  • Karma: +0/-0
Re: Multi bot db setup.
« 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).

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.
« Last Edit: August 07, 2007, 03:57:06 am by Diablo »

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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?

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Multi bot db setup.
« Reply #18 on: August 10, 2007, 03:05:04 pm »
Are you sure your bots are all using the same database?

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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?

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Multi bot db setup.
« 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?

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Multi bot db setup.
« 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

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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?
« Last Edit: August 10, 2007, 04:44:58 pm by Diablo »

Offline Diablo

  • BeBot User
  • **
  • Posts: 67
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Multi bot db setup.
« 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.

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Multi bot db setup.
« 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 :/

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]

* Who's Online
  • Dot Guests: 448
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal