BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => 0.5.x Custom/Unofficial Modules => Topic started by: Temar on January 19, 2008, 07:59:55 am

Title: BeBot 0.5.0 (SVN)
Post by: Temar on January 19, 2008, 07:59:55 am
This is a Clean Copy of SVN as it is today - 1 April 2008

Please be warned that this is not a stable release codebase. If you are not familiar with MySQL and know how to edit your database DO NOT USE THIS RELEASE.
The codebase works for me without issues (unless otherwise stated in the changelog), but that doesnt mean it will work just fine for you.
Changes (right click and Save as, the Attachment Already Includes these changes)

* 0.5 Released!
Title: Re: BeBot 0.5.0 (SVN)
Post by: Nogoal on March 19, 2008, 06:13:31 pm
I updated my bots with current SVN today (1326) and everything is working fine atm except news_on_log_on.

I tried to change default to on or reset but looks like it doesn't work with alts, gonna try with main when I'll be back home.

To [Aotn]: !preferences set default News 5 On
[Angels of the Night] Aotn: [2008-03-19 15:34:31] [PREFS] [SECURITY] Mygoal attempted to change default value with out required authoroty!
Aotn:  You have insufficient authoroty to reset this preference!

To [Aotn]: !preferences reset 5
[Angels of the Night] Aotn: [2008-03-19 15:57:04] [PREFS] [SECURITY] Mygoal attempted to reset preferences with out required authoroty!
Aotn:  You have insufficient authoroty to reset this preference!

Also mail blob crash aorc. Some ' are missing to close href. Lines 206, 210, 231, 232, ...
Title: Re: BeBot 0.5.0 (SVN)
Post by: Alreadythere on March 19, 2008, 06:36:14 pm
Thanks, added the missing ' and corrected those typos.

Didn't look into the preferences myself yet though.
Title: Re: BeBot 0.5.0 (SVN)
Post by: Temar on March 26, 2008, 08:22:31 pm
Bump for Big Update
Title: Re: BeBot 0.5.0 (SVN)
Post by: clashbot on March 27, 2008, 02:28:17 pm
just out of curiosity, what sort of changes to the db are required to update 4.3 to 5? I take it , it is not as simple as extracting 5 and setting it up to use the same db as 4.3?
Title: Re: BeBot 0.5.0 (SVN)
Post by: Alreadythere on March 27, 2008, 02:45:04 pm
Migration from 0.4.3 to 0.5 will be seamless DB wise if you use the same config file. All tables get updated to the newest versions.

Moving back to 0.4.3 will be impossible without direct changes to some tables then though. And 0.5 brings a couple more tables I think.

If you want to run a testbot besides your existing 0.4.3 bot(s) it shouldn't cause any problem, I can't remember any of the global tables being touched. This is without any guarantees though, there were a couple of hundred changes to trunk :)
Title: Re: BeBot 0.5.0 (SVN)
Post by: Dracutza on March 27, 2008, 03:26:36 pm
upgraded our test 4.x bot to 5.0 without incident this morning.

Very! Nice!
Title: Re: BeBot 0.5.0 (SVN)
Post by: Blueeagle on March 27, 2008, 03:36:37 pm
Well then you've been damned lucky. Because 0.5 has been broken much lately. :p
Title: Re: BeBot 0.5.0 (SVN)
Post by: Dracutza on March 27, 2008, 04:06:44 pm
Quote from: Blueeagle on March 27, 2008, 03:36:37 pm
Well then you've been damned lucky. Because 0.5 has been broken much lately. :p


didn't try the IRC mod yet (which I need to before moving the org bot to 5, but zero brokeness (as far as I can tell) with the 26/3 zip.
Title: Re: BeBot 0.5.0 (SVN)
Post by: Dracutza on March 29, 2008, 06:17:34 pm
a few things I've been seeing and not sure if it's an issue or not really

Quote
bot [2008-03-29 16:07:53]    [SETTINGS]      [LOAD]  Loaded settings from database.
bot [2008-03-29 16:07:53]    [MAIN]  [LOAD]  06_Settings.php
MySQL error (# 0) on query: CREATE TABLE IF NOT EXISTS access_control_saves (
                                        name varchar(50) NOT NULL default '',
                                        description varchar(150) NULL,
                                        commands TEXT NOT NULL default '',
                                        PRIMARY KEY (name)
                                )
BLOB/TEXT column 'commands' can't have a default value
bot [2008-03-29 16:07:53]    [SETTINGS]      [SAVED] schemaversion for module accesscontrol set to 3 as datatype int
Quote
bot [2008-03-29 16:07:56]    [SETTINGS]      [SAVED] schemaversion for module timer set to 3 as datatype int
bot [2008-03-29 16:07:57]    [MAIN]  [LOAD]  15_Timer_Core.php
bot [2008-03-29 16:07:57]    [CORE]  [ERROR] Module 'ini' does not exist or is not loaded.
bot [2008-03-29 16:07:57]    [CORE]  [ERROR] Module 'ini' does not exist or is not loaded.

Quote
bot [2008-03-29 16:08:05]    [MOD]   [LOAD]  ModulesControlGUI.php
// bot [2008-03-29 16:08:05] [MOD]   [LOAD]  News.php
bot [2008-03-29 16:08:05]    [MOD]   [LOAD]  Notify.php
Title: Re: BeBot 0.5.0 (SVN)
Post by: Dracutza on March 29, 2008, 06:36:32 pm
buddylist in a raidbot

Quote
bot [2008-03-29 16:30:28]    [TELL]  [INC]   Dracutza: buddylist

Warning: asort() expects parameter 1 to be array, null given in P:\bot\modules\Roster.php on line 282

Warning: Invalid argument supplied for foreach() in P:\bot\modules\Roster.php on line 284

bot [2008-03-29 16:30:28]    [TELL]  [OUT]   -> Dracutza: 0 buddies in bot's buddylist :: [link]click to view[/link]
Title: Re: BeBot 0.5.0 (SVN)
Post by: Alreadythere on March 29, 2008, 06:47:17 pm
Quote from: Dracutza on March 29, 2008, 06:17:34 pm
Quote
bot [2008-03-29 16:07:53]    [SETTINGS]      [LOAD]  Loaded settings from database.
bot [2008-03-29 16:07:53]    [MAIN]  [LOAD]  06_Settings.php
MySQL error (# 0) on query: CREATE TABLE IF NOT EXISTS access_control_saves (
                                        name varchar(50) NOT NULL default '',
                                        description varchar(150) NULL,
                                        commands TEXT NOT NULL default '',
                                        PRIMARY KEY (name)
                                )
BLOB/TEXT column 'commands' can't have a default value
bot [2008-03-29 16:07:53]    [SETTINGS]      [SAVED] schemaversion for module accesscontrol set to 3 as datatype int
Fixed in SVN.

Quote from: Dracutza on March 29, 2008, 06:17:34 pm
Quote
bot [2008-03-29 16:07:56]    [SETTINGS]      [SAVED] schemaversion for module timer set to 3 as datatype int
bot [2008-03-29 16:07:57]    [MAIN]  [LOAD]  15_Timer_Core.php
bot [2008-03-29 16:07:57]    [CORE]  [ERROR] Module 'ini' does not exist or is not loaded.
bot [2008-03-29 16:07:57]    [CORE]  [ERROR] Module 'ini' does not exist or is not loaded.
This one is strange, I just checked, and there is no call to core("ini") before it's created.

Quote from: Dracutza on March 29, 2008, 06:17:34 pm
Quote
bot [2008-03-29 16:08:05]    [MOD]   [LOAD]  ModulesControlGUI.php
// bot [2008-03-29 16:08:05] [MOD]   [LOAD]  News.php
bot [2008-03-29 16:08:05]    [MOD]   [LOAD]  Notify.php
Fixed the output in SVN, it's just visual though.

Quote from: Dracutza on March 29, 2008, 06:36:32 pm
Quote
bot [2008-03-29 16:30:28]    [TELL]  [INC]   Dracutza: buddylist

Warning: asort() expects parameter 1 to be array, null given in P:\bot\modules\Roster.php on line 282

Warning: Invalid argument supplied for foreach() in P:\bot\modules\Roster.php on line 284

bot [2008-03-29 16:30:28]    [TELL]  [OUT]   -> Dracutza: 0 buddies in bot's buddylist :: [link]click to view[/link]
Added a check for an empty buddylist.

Thanks for posting all those!
Title: Re: BeBot 0.5.0 (SVN)
Post by: Greengadget on March 29, 2008, 09:07:12 pm
i tried the latest 0.5 zip and i get this error

Fatal error: Cannot redeclare class AccessControl_Core in C:\Program Files\PHP\c
ore\AccessControl.php on line 62
Title: Re: BeBot 0.5.0 (SVN)
Post by: Temar on March 29, 2008, 09:27:52 pm
delete the 1 in core folder. Its now in main folder
Title: Re: BeBot 0.5.0 (SVN)
Post by: Alreadythere on March 29, 2008, 09:35:56 pm
Quote from: Greengadget on March 29, 2008, 09:07:12 pm
i tried the latest 0.5 zip and i get this error

Fatal error: Cannot redeclare class AccessControl_Core in C:\Program Files\PHP\core\AccessControl.php on line 62
Best use the zip as base for any custom modules, don't just copy it over any existing directory. Several files have different directories or slightly changed names.
Title: Re: BeBot 0.5.0 (SVN)
Post by: Dracutza on March 29, 2008, 08:34:24 pm
other than the ini thing, all load issues I've seen seem to be fixed now.

New thing though that I've seen A LOT in 5 as opposed to 4...

Quote
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048) in P:\bot\Sources\MySQL.php on line 96
MySQL error (# 0) on query: Cannot connect to the database server!

There is no rhyme or reason to this happening.  It seems to happen regularly when launching a new bot instance before an old one is 100% done loading, but that is not always the case.  Sometimes I can get several bots to launch at "the same time" with no error, and sometimes I get it even when it's the first instance getting loaded.

Eventually it works itself out and everything appears to load fine, but I never saw this happen on 4 in the quantity is does in 5.
Title: Re: BeBot 0.5.0 (SVN)
Post by: Greengadget on March 29, 2008, 08:56:59 pm
Quote from: Temar on March 29, 2008, 09:27:52 pm
delete the 1 in core folder. Its now in main folder

thx, works fine now
Title: Re: BeBot 0.5.0 (SVN)
Post by: Alreadythere on March 29, 2008, 09:02:11 pm
Quote from: Dracutza on March 29, 2008, 08:34:24 pm
Quote
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048) in P:\bot\Sources\MySQL.php on line 96
MySQL error (# 0) on query: Cannot connect to the database server!
I don't know what the problem with mysql itself it, maybe there is some connection per time limit.

The real reason this may happen is a change in the MySQL layer. The bot now calls mysql_connect() first, reestablishing any connection closed since the last SQL query. If the connection is still open it returns just the already existing connection, so no harm done then. As a result there may be a couple more mysql_connect() calls then before, the 0.4 version doesn't try to reconnect.
Title: Re: BeBot 0.5.0 (SVN)
Post by: Dracutza on March 30, 2008, 03:37:17 am
In the !mail module

Quote
bot: Message sendt to

sent
Title: Re: BeBot 0.5.0 (SVN)
Post by: Temar on March 30, 2008, 04:47:09 am
Fixed in SVN

Post Updated to 29th
SimplePortal 2.3.7 © 2008-2024, SimplePortal