cool - got it! Going to put one in now, and then go make the cron run now, and see what happens

Okay, i tried this, and got this error message:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO thread_bank(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('Who is your favorite Family Guy Character?', NULL, 34, 1, 0, 'ThreadBot', 224, 'ThreadBot', NULL, 1, 0)

mysql error: Table 'bmww.thread_bank' doesn't exist

mysql error number: 1146

Date: Saturday 14th of May 2005 05:32:39 PM
Script: http://www.bmww.org/forums/feed_threadBOT.php
Referer: http://www.bmww.org/forums/feed_threadBOT.php
Username: jilly

threadBOT 1.00 & Generate Files

you don't need to tick anything, i.e. leave everything unticked bar "threadBOT 1.00"

ok that's a problem with the queries, run these two in phpmyadmin

[sql]CREATE TABLE `thread_bank` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`lastpost` int(10) unsigned NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` tinyint(4) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(50) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '',
`dateline` int(10) unsigned NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`firstpostid` int(10) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
PRIMARY KEY (`threadid`),
KEY `iconid` (`iconid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
FULLTEXT KEY `title` (`title`)
);[/sql]

and

[sql]
CREATE TABLE `post_bank` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NULL default '0',
`pagetext` mediumtext NOT NULL,
`allowsmilie` smallint(6) NOT NULL default '0',
`showsignature` smallint(6) NOT NULL default '0',
`ipaddress` varchar(16) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`visible` smallint(6) NOT NULL default '0',
`parentid` int(10) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `iconid` (`iconid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`),
FULLTEXT KEY `title` (`title`,`pagetext`)
);[/sql]

while running the first query, i got this error message:

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'collate latin1_general_ci NOT NULL default '',
`lastpost` in

okay, in the admin cp > vbulletin options > threadBOT, there is this option:

threadBOT Hour Limit
This is the setting to see how often you're going to run the threadBOT (0 to run hourly)

what exactly does this do? Don't we set this already in the cron job?
What is the difference between this setting and the cron job setting?
:)

just set that to zero, it was something i tried to be clever with which failed.

post edited, re-run the queries
https://vborg.vbsupport.ru/showpost....3&postcount=35

Okay, got the queries to run fine.

Now I went to feedthreadBOT_php, and put in two threads - they both showed up right away! D'oh! I was hoping they would go into the database, and then at cron run time (5pm i think) , a thread would get randomly selected from the database and be posted

what next?