vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Talkerbot V2.2.3 (AI Posting Bot) (https://vborg.vbsupport.ru/showthread.php?t=126386)

Romeos Tune 09-24-2006 02:21 AM

Ok, got it up and running but now when you make a post the result is this:

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO session (userid,lastactivity,host) VALUE ('604',1159067932,'127.0.0.1');

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUE ('604',1159067932,'127.0.0.1')' at line 1
Error Number : 1064
Date : Saturday, September 23rd 2006 @ 10:18:31 PM
Script : http://battlewang.net/forum/newthrea...ostthread&f=19
Referrer : http://battlewang.net/forum/newthrea...newthread&f=19
IP Address : xxx.xx.xxxx
Username : Storm
Classname : vb_database

Any ideas anyone?

Romeos Tune 09-24-2006 02:22 AM

Oh, btw......The post is made and the bot responds but that error pops up so that will definitely cause problems.

Spin Doctor 09-24-2006 04:53 AM

Quote:

Im sorry but I was not able to form a reply right now
thats all he says!

gooberface 09-24-2006 08:21 AM

I have set both of the paths as instructed, and have spent hours confirming they are correct because the botloader won't work. I have chmod everything to 0777. I can't figure out what the deal is, but I saw this error many times throughout the thread:

Quote:

?php /* Program E Copyright 2002, Paul Rydell This file is part of Program E. Program E is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. Program E is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with Program E; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ //Disable Error Reporting Since this code needs alot of work to become completely clean and error free under stict php setups. //error_reporting(0); # Turn this off in case people have it on. set_magic_quotes_runtime(0); # Can't turn off magic quotes gpc so just redo what it did if it is on. if (get_magic_quotes_gpc()) { foreach($_GET as $k=>$v) $_GET[$k] = stripslashes($v); foreach($_POST as $k=>$v) $_POST[$k] = stripslashes($v); foreach($_COOKIE as $k=>$v) $_COOKIE[$k] = stripslashes($v); } define("LOOPINGERRORMSG", "Oops. I wasn't paying attention. Tell me again what is going on."); define("LOOPINGLIMIT",75); // -1 for no limit define("RANDOMCHANCECLEAN",200); // -1 to never check define("MINUTESTOKEEPDATA",300); // -1 to keep forever # This is where all the AIML and startup.xml resides $rootdir= "/home/dkaid/public_html/forums/alice/aiml/"; require('/home/dkaid/public_html/forums/includes/config.php'); $DB_HOST=$config['MasterServer']['servername']; $DB_UNAME=$config['MasterServer']['username']; $DB_PWORD=$config['MasterServer']['password']; $DB_DB=$config['Database']['dbname']; $boterrors=""; mysql_connect($DB_HOST,$DB_UNAME,$DB_PWORD) or $boterrors = $boterrors . "Could not connect to database.\n"; @mysql_select_db($DB_DB) or $boterrors = $boterrors . "Unable to select database\n"; ?>
Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 27

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 27

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 31

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 31

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 35

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 35

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 44

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 44

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 59

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 59
Loading startup.xml

Warning: fopen(startup.xml) [function.fopen]: failed to open stream: No such file or directory in /home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 508
could not open XML input
that is my error. I have confirmed everything correct. I have reuploaded everything, painstakingly followed the instructions letter for letter...

What could be the problem?

Gizmo5h1t3 09-24-2006 08:54 AM

are you sure your filepath is "forums", and not "forum"??

Quote:

/home/dkaid/public_html/forums/alice/src/admin/botloaderfuncs.php on line 508

gooberface 09-24-2006 09:08 AM

Yes, it is forums. Thanks though. Does anybody have ANY sort of idea it could be? I've read this entire thread at least 3 times now, and quintuple checked everything. This is killing me! This bot would be awesome.

hotwheels 09-24-2006 12:40 PM

gooberface, try reuploading all of the files and overwrite them, be sure to only set the "/home/dkaid/public_html/forums/alice/aiml/"; '/home/dkaid/public_html/forums/includes/config.php' and nothing else, reupload the xml in your admincp, then run the bot loader......

Neal-UK 09-24-2006 12:59 PM

How can I uninstall this product please, such as the db alterations and phrases?

gooberface 09-24-2006 03:40 PM

Ok, I reuploaded everything AGAIN, and this time it went a little further. I don't understand where the difference would have been, but it did make a change. Here is the new errors I am seeing:

Quote:

Warning: main(home/dkaid/public_html/forums/includes/config.php) [function.main]: failed to open stream: No such file or directory in /home/dkaid/public_html/forums/alice/src/admin/dbprefs.php on line 49

Warning: main(home/dkaid/public_html/forums/includes/config.php) [function.main]: failed to open stream: No such file or directory in /home/dkaid/public_html/forums/alice/src/admin/dbprefs.php on line 49

Fatal error: main() [function.require]: Failed opening required 'home/dkaid/public_html/forums/includes/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dkaid/public_html/forums/alice/src/admin/dbprefs.php on line 49
Any clue what this means?

nitro 09-24-2006 05:05 PM

Could be your missing the preceding / from the path(s) you entered ? as it should read /home/... not home/...

RichieBoy67 09-24-2006 05:10 PM

I am sorry if this has been covered but I do not have the time to reread the entire thread...

I had this script running fine for the most part. In certain forums users were not being redirected properly. Another words, you would make a post in one of these forums and you would get an unfound page instead of being redirected to the thread. I had to disabl;e the product because of this...

It was working though and my members loved it..

If I can get this fixed I would be glad to let people see it in action on my site.....

Anyone cover this bug yet???

Thanks

Gizmo5h1t3 09-24-2006 05:38 PM

Quote:

Originally Posted by nitro
Could be your missing the preceding / from the path(s) you entered ? as it should read /home/... not home/...

that could be it, i had the same thing happened, and i put the "/" before "home"...and it worked fine

eXtremeTim 09-24-2006 06:19 PM

This hack does not change the redirection system. So therefor I can not see how it would cuase it to redirect to a non existing page. If you could give more information about your setup I will try and see if maybe there is a conflict between this hack and another.

gooberface 09-24-2006 06:21 PM

Everyone, thank you. Nitro spotted it. After the reload, I left a leading "/" off of ONE of the two. Thanks everyone, I really appreacite the help.

RichieBoy67 09-24-2006 06:31 PM

I am getting this error now...

PHP Code:

Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO session (userid,lastactivity,hostVALUE ('2019',1159126146,'127.0.0.1');

MySQL Error  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUE ('2019',1159126146,'127.0.0.1')' at line 1
Error Number 
1064
Date         
SundaySeptember 24th 2006 03:29:08 PM
Script       
http://www.talkandmore.net/newthread.php?do=postthread&f=40
Referrer     http://www.talkandmore.net/newthread.php?do=newthread&f=40
IP Address   : *********
Username     : *******
Classname    vb_database 

Help please....lol


I think that I can modify this code right here
PHP Code:

$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."session SET lastactivity = '"TIMENOW ."' WHERE (userid = '".$vbulletin->options['ewt_talkerbot_botuid']."')");
                    if (
$vbulletin->db->affected_rows() == 0)
                    {
                        
$ip "127.0.0.1";
                        
$vbulletin->db->query_write("INSERT INTO ".TABLE_PREFIX."session (userid,lastactivity,host) VALUE ('".$vbulletin->options['ewt_talkerbot_botuid']."',".TIMENOW.",'$ip')");
                    }

                    
$userdata =& datamanager_init('User'$vbulletinERRTYPE_STANDARD);
                    
$userdata->set_existing($botinfo);
                    
$userdata->set('lastactivity'TIMENOW);
                    
$userdata->set('lastvisit'TIMENOW 1);
                    
$userdata->save();

                } 

This is in the ewt_talkerbot.php --

Can anyone give me a hand coming up with this fix?

Romeos Tune 09-24-2006 08:01 PM

I am getting the same error when posting in a bot forum. Anyone??

RichieBoy67 09-24-2006 08:07 PM

Can you help me rewrite this block? I think I almost got it..

hotwheels 09-24-2006 08:10 PM

hey richie, let me look at my ew real quick and i will get back to ya.......Meantime, could you do me a favor and on the post you made a few steps back, delete your ip addy and just put ****** in its place, same with your username..........

hotwheels 09-24-2006 08:16 PM

try this on richie.........it is the one i am currently running and my bot is working.

RichieBoy67 09-24-2006 08:18 PM

Oh yeah, thanks for catching that. Sorry, I should no better...

Thanks :)

hotwheels 09-24-2006 08:21 PM

that's alright bro..........just watching out for each other.

hotwheels 09-24-2006 08:32 PM

also richie and romeos, what happens if you run this:

http ://www.youforums.com/forums/alice/src/talk.php?what+is+your+name?

RichieBoy67 09-24-2006 08:33 PM

Thanks

Same error though unfortunatly..

PHP Code:

Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO session (userid,lastactivity,hostVALUE ('2019',1159133564,'127.0.0.1');

MySQL Error  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUE ('2019',1159133564,'127.0.0.1')' at line 1
Error Number 
1064
Date         
SundaySeptember 24th 2006 05:32:45 PM
Script       
http://www.talkandmore.net/newreply.php?do=postreply&t=112460
Referrer     http://www.talkandmore.net/showthread.php?t=112460
IP Address   
Username     :
Classname    vb_database 


RichieBoy67 09-24-2006 08:34 PM

Yeah, That works fine for me on my site...

Actually I take that back... I get nothing from that... Blank page..

nitro 09-24-2006 08:49 PM

This part
PHP Code:

".TABLE_PREFIX." 

should be like this
PHP Code:

" . TABLE_PREFIX . " 


RichieBoy67 09-24-2006 08:57 PM

You know Nitro... I think that actually did the trick!! Man, always the simple things...

How do you think this happened only for a few of us? I did not touch this code before these errors started happening... Was the white space somehow stripped durring compression or something???

hotwheels 09-24-2006 09:04 PM

It may just be a bug that has to do with 3.6.1, maybe.......

I have attatched nitro's suggestion fix here.

RichieBoy67 09-24-2006 09:14 PM

Guess what..... Not working again....

unitedpunjab 09-24-2006 09:18 PM

i am having quick reply problem

warnmar10 09-24-2006 09:25 PM

Attempting to install locally and get this:
Code:

Loading startup.xml
Loading data aiml file: 1.aiml

Notice: Undefined offset: 8 in d:\easyphp\www\forums\alice\src\admin\botloaderfuncs.php on line 187

Notice: Undefined offset: 8 in d:\easyphp\www\forums\alice\src\admin\botloaderfuncs.php on line 187

Notice: Undefined offset: 8 in d:\easyphp\www\forums\alice\src\admin\botloaderfuncs.php on line 187

Notice: Undefined offset: 8 in d:\easyphp\www\forums\alice\src\admin\botloaderfuncs.php on line 187

Notice: Undefined offset: 7 in d:\easyphp\www\forums\alice\src\admin\botloaderfuncs.php on line 187

Notice: Undefined offset: 7 in d:\easyphp\www\forums\alice\src\admin\botloaderfuncs.php on line 187
...goes on forever...

Thoughts anyone?

nitro 09-24-2006 10:12 PM

Quote:

Originally Posted by RichieBoy67
You know Nitro... I think that actually did the trick!! Man, always the simple things...

How do you think this happened only for a few of us? I did not touch this code before these errors started happening... Was the white space somehow stripped durring compression or something???

More likely a typo really, its a common error, done it myself before. :)

Why affect some and not others ? 2 possibilities come to mind, your version of mysql, do you have a table prefix ? if so it would definatley have affected it.

RichieBoy67 09-24-2006 10:30 PM

This is what I have

PHP version 4.3.10
MySQL version 4.0.27-standard

No prefix's... I have spent over 2 hours trying to fix the errors associated with this mod and I have been unable to find a fix.. I am bumming because I love this mod...

Thanks for trying...

Rich

Romeos Tune 09-24-2006 11:40 PM

When I try that the bot responds "What is your favorite color?"

nitro 09-24-2006 11:41 PM

Think the spaces are missing from these aswell

PHP Code:

".$vbulletin->options['ewt_talkerbot_botuid']." 

Should be
PHP Code:

" . $vbulletin->options['ewt_talkerbot_botuid'] . " 


Romeos Tune 09-25-2006 12:01 AM

Still get the same error here after that......

gooberface 09-25-2006 06:17 PM

Is there anyway to assign the bot to a certain thread? So I could make a "talk to the bot" thread?

EDIT: I actually searched the thread and saw that this might be in the next version. Awesome, that would be a great feature.

hotwheels 09-25-2006 07:38 PM

What i did goober face was assign him his own forum area, that way, he is only in one spot and people can start different threads in his forum and chat away.......

hotwheels 09-25-2006 09:36 PM

Hey Nitro, have you had a chance to look at this code? creating your own teaching feeds. It has great possibilities once tim get's it running....

nitro 09-26-2006 12:56 AM

Quote:

Originally Posted by hotwheels
Hey Nitro, have you had a chance to look at this code? creating your own teaching feeds. It has great possibilities once tim get's it running....

Not yet, looking at some other changes, like multibot (should be easy to change it back to how I did that before pretty much and select a random bot based on membergroups so they can still apear as regular regged users), and then see if I can plug it into articlebot will be next. ;)

PS, the session code from this seems to work well, I snipped and modded that part slightly and added it to articlebot's core file and voila they appear in online and visted toddays users aswell. :)

hotwheels 09-26-2006 01:20 AM

really? You gonna share yet?

I would love to try it..........hehehehe


All times are GMT. The time now is 03:19 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01948 seconds
  • Memory Usage 1,872KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (7)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete