threadBOT: The Thread Provider

WHAT:
This hack will create threads at regualar intervals in the forum you specify and with the body text you specify on a thread by thread basis

WHY:
Because your forums are probably dead or you just wanna make sure you continue in the persut of quality topic-specific threads

WHEN:
Whenever you set it to because we're cron like that

WHERE:
In your forums

HOW:
Easily, theirs like one file edit and that's one of the files this comes with, we call it super plug-in power-o

ANYTHING ELSE:
Yes if jilly didn't make the request i would've never got round to spending the few hours it took to create this, though i got distracted alot and so it took me like 5 hours over 3 weeks.

Installation
Unpack to the directories stated and then run the installer @ http://www.yourdomain.com/forums/ins...ck_install.php and follow all the instructions.

Upgrading
Replace the cron file.

[jilly]

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

[jilly]

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

[TTG]

Originally Posted by sabret00the

ok, did you tick any of the tick boxes when you went to hack_install.php

threadBOT 1.00 & Generate Files

[sabret00the]

Originally Posted by TTG

threadBOT 1.00 & Generate Files

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

[sabret00the]

Originally Posted by jilly

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

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]

[jilly]

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

[jilly]

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?

[sabret00the]

Originally Posted by jilly

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.

[sabret00the]

Originally Posted by jilly

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

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

[jilly]

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?