[BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Suggested Hosts
sotis
Registered User
Posts: 294
Joined: Tue Oct 17, 2006 4:56 pm
Location: Bulgaria
Contact:

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by sotis » Mon Sep 21, 2009 5:08 am

I receive this. I have column "post_bot_respond" in users table.

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 't.post_bot_respond' in 'where clause' [1054]

SQL

SELECT * FROM (SELECT a.* FROM phpbb_posts a, phpbb_forums b WHERE a.forum_id='' AND a.forum_id=b.forum_id AND a.poster_id<>'2310' AND a.post_time>0 AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') ORDER BY a.post_id) as t WHERE LOCATE('*315190 ',t.post_bot_respond)=0 group by t.topic_id ORDER BY t.post_id DESC LIMIT 10

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: ai/posting_bot2.php
LINE: 173
CALL: dbal_mysql->sql_query()

FILE: ai/bot_ai.php
LINE: 17
CALL: include('ai/posting_bot2.php')

FILE: index.php
LINE: 439
CALL: include('ai/bot_ai.php')

User avatar
petrocad3d
Registered User
Posts: 68
Joined: Wed Apr 08, 2009 2:40 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by petrocad3d » Mon Sep 21, 2009 3:06 pm

sotis wrote:I receive this. I have column "post_bot_respond" in users table.

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 't.post_bot_respond' in 'where clause' [1054]

SQL

SELECT * FROM (SELECT a.* FROM phpbb_posts a, phpbb_forums b WHERE a.forum_id='' AND a.forum_id=b.forum_id AND a.poster_id<>'2310' AND a.post_time>0 AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') ORDER BY a.post_id) as t WHERE LOCATE('*315190 ',t.post_bot_respond)=0 group by t.topic_id ORDER BY t.post_id DESC LIMIT 10

I need the version of your mysql.

I amnot sure about this error, but try with this

SELECT * FROM (SELECT a.* FROM phpbb_posts a, phpbb_forums b
WHERE a.forum_id='' AND a.forum_id=b.forum_id AND a.poster_id<>'2310'
AND a.post_time>0 AND (b.forum_name<>'trigger by message' AND
b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss')
ORDER BY a.post_id) t WHERE LOCATE('*315190 ',t.post_bot_respond)=0
group by t.topic_id ORDER BY t.post_id DESC LIMIT 10

in the line 5, i delete the word 'as'

:ugeek:

sotis
Registered User
Posts: 294
Joined: Tue Oct 17, 2006 4:56 pm
Location: Bulgaria
Contact:

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by sotis » Tue Sep 22, 2009 3:01 pm

I receive the same error after changes.

My mysql version is: MySQL 5.1.33-community

User avatar
petrocad3d
Registered User
Posts: 68
Joined: Wed Apr 08, 2009 2:40 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by petrocad3d » Wed Sep 23, 2009 9:34 am

sotis wrote:I receive the same error after changes.

My mysql version is: MySQL 5.1.33-community
I forget this instruction :
FIND : 'test'
DELAT : 1-3min
FORUM TARJET : test_forum

Maybe your mysql doesnt like SELECT OF SELECT.

Try with it

SELECT a.* FROM phpbb_posts a JOIN phpbb_forums b ON a.forum='' AND
a.forum_id=b.forum_id AND a.poster_id<>'2310' AND a.post_time>0 AND
(b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') AND
LOCATE('*315190 ',a.post_bot_respond)=0
GROUP BY a.topic_id ORDER BY a.post_id DESC LIMIT 10

REPLACE THE LINE 181 and 186 in the file posting_bot2.php with these

$sql = "SELECT a.* FROM " . POSTS_TABLE . " a JOIN " . FORUMS_TABLE . " b ON a.forum_id='$donde' AND a.forum_id=b.forum_id AND a.poster_id<>'$user_id' AND a.post_time>$desdeaqui AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') AND
LOCATE('$IDXX',a.post_bot_respond)=0
GROUP BY a.topic_id ORDER BY a.post_id DESC LIMIT $limitus";

$sql = "SELECT a.* FROM " . POSTS_TABLE . " a JOIN " . FORUMS_TABLE . " b ON a.forum_id='$donde' AND a.forum_id=b.forum_id AND a.poster_id<>'$user_id' AND a.post_time>$desdeaqui AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') AND
(post_bot_respond IS NULL or a.post_bot_respond='')
GROUP BY a.topic_id ORDER BY a.post_id DESC LIMIT $limitus";$numpo=0;

:o

User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by muggins » Wed Sep 23, 2009 3:11 pm

petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.
Muggins

User avatar
petrocad3d
Registered User
Posts: 68
Joined: Wed Apr 08, 2009 2:40 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by petrocad3d » Wed Sep 23, 2009 4:32 pm

muggins wrote:petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.
This part 'trigger by message' is in development. It is very dificult for me to test this part of the mod, because it has a delay.

it isnot my fault that people try to install in very old versions of php or mysql.(also phpbb)

'Select by Select' is not supported in version before Mysql 4.0.0. I get the solution, but i need the other person say the code works or not to work.

I tested the mod in phpbb 3.0.3 and 3.0.5, offline and online, i didnt receive any king of rutime error.

I noticed that one tryied to install phpbb 2.0.x, i knew it, but i helped him, i got the code for that problem. Others had beed downloaded that version(modbot_v0.2.3b.zip), i am sure it works for phpbb 3.0.x, but i didnt like that situation.

I appreciate your suggestion, i will do it, when people say me this mod works very well. 8-)

:ugeek:

User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by muggins » Wed Sep 23, 2009 9:28 pm

Your mod works better than some, sir. :D

It is much easier to document changes to the instructions, and to correct them as needed, when we have the install.xml file to aid us in installation and upgrade...
Muggins

User avatar
lachlan438
Registered User
Posts: 72
Joined: Sat Jun 14, 2008 7:40 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by lachlan438 » Tue Sep 29, 2009 5:04 pm

I am getting this error I have disabled all the bots but Hal just for testing and stuff you can find my very newest work in progress here http://lance4681.x10hosting.com/forums/right now this is on free hosting until I build it so it might be down or slow just a heads up
SQL ERROR [ mysql4 ]


MySQL server has gone away [2006]

SQL

SELECT user_id FROM phpbb_users WHERE username_clean = 'hal9000'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: posting_bot.php
LINE: 1031
CALL: dbal_mysql->sql_query()

User avatar
lachlan438
Registered User
Posts: 72
Joined: Sat Jun 14, 2008 7:40 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by lachlan438 » Tue Sep 29, 2009 7:18 pm

Ok, Hal9000 Seems to be the problem if I turn him off all the problems fade away. think is I like Hal :cry: I have played around with Hal before and he was kind of kool so if anyone knows a fix that would be sick.

My second problem is. How do I train up
Ralf and Alissa so how can I add AIML files to there brains? :twisted:

Once Again thanks for this very cool Mod :)

Its always good to suck up when asking for support lol

Petesat
Registered User
Posts: 63
Joined: Thu Apr 10, 2008 8:42 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by Petesat » Wed Sep 30, 2009 10:34 am

I get this error..
General Error
SQL ERROR [ mysql4 ]

Unknown column 'post_bot_respond' in 'field list' [1054]

SQL

SELECT post_bot_respond FROM posts WHERE post_id = 19618

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: posting_bot.php
LINE: 1005
CALL: dbal_mysql->sql_query()
I have
Apache version 2.2.13 (Unix)
PHP version 4.4.9
MySQL version 5.0.81-community-
log
Architecture x86_64

And am running PHPBB3.05 with loads of mods..
I have emulated my live board to test this mod..

I also do not get option to tick who answers..

Pete

User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by muggins » Wed Sep 30, 2009 12:10 pm

The instruction:

Code: Select all

ALTER TABLE `phpbb_users` ADD post_bot_respond varchar(250) NULL default "";
Should be:

Code: Select all

ALTER TABLE `phpbb_posts` ADD post_bot_respond varchar(250) NULL default "";
As to why you don't get the question, I don't know. :?
Muggins

Petesat
Registered User
Posts: 63
Joined: Thu Apr 10, 2008 8:42 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by Petesat » Sat Oct 03, 2009 8:05 pm

Yes, this fixed the prob, going to try again from scratch though as I said it was on a forum duplicate..

So I have now deleted the database and am going to add the mod with admin CP as well this time..

Thanks for the MOD as I think it is fun..

Pete

User avatar
petrocad3d
Registered User
Posts: 68
Joined: Wed Apr 08, 2009 2:40 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by petrocad3d » Sun Oct 04, 2009 1:29 am

muggins wrote:petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.
No problem, i will do it, thank for your suggestion. :D
lachlan438 wrote:Ok, Hal9000 Seems to be the problem if I turn him off all the problems fade away. think is I like Hal :cry: I have played around with Hal before and he was kind of kool so if anyone knows a fix that would be sick.

My second problem is. How do I train up
Ralf and Alissa so how can I add AIML files to there brains? :twisted:

Once Again thanks for this very cool Mod :)

Its always good to suck up when asking for support lol
In order to add more AIML files you can go to this URL, I think it is the best of AIML files sources, it has funny AIML files like board games, horoscope, alot fun AIMLs. 8-)
For Ralf, go to http://www.verbots.com

:ugeek:

User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by muggins » Sun Oct 04, 2009 3:49 am

Excellent, sir!

I will visit Square Bear's site, too. Thank you!
Muggins

Petesat
Registered User
Posts: 63
Joined: Thu Apr 10, 2008 8:42 am

Re: [BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

Post by Petesat » Sun Oct 04, 2009 5:55 am

Where do these file go then?

Pete

Locked

Return to “[3.0.x] MODs in Development”