Create new thread script

[leeherron]

Anyone know of an external script I can dissect that creates a new thread? (besides VBB)

I'm working on a news editor that is limited to approved writers, but with each news article, there will be a link to discuss the article on the forum (vbb2). So, when the article is written, the same process will need to create a thread in the VBB2 forum for future discussion. Before I jump in to this part of my project, thought I would seek advice/ideas from you guys.

[Admin]

Take a look at newthread.php. It pretty much has everything you need, and you can get rid of the permissions stuff if you make sure only the right people can access your script.

[leeherron]

> Take a look at newthread.php.

Thanks for the tip. It didn't have everything needed, but got me started. I don't know if anyone else could use this code, but thought I'd post it at least .. some times you just got to give sump'm back.

===== NewsBot Code Begins ======
<?php

echo "Running auto posting process ... ";

$dbhost = "localhost"; // dbServer
$dbuser = "xxxx"; // user
$dbpass = "xxxxxx"; // password
$dbname = "vbdforum"; // forum name

/* Connect to db server and select database */
MYSQL_CONNECT($dbhost, $dbuser, $dbpass) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbname") or die( "Unable to select database");

/* Varibles to post */

$forumid="2"; // Forum number to post in
$iconid="1"; // Post icon

$tempsubject = "New Section ..";
$message="NewsBot shows signs of life.: \"NewsBot v.02\" More to come.";

$subject="NewsBot: ".$tempsubject;

$postusername = 'NewsBot'; // Existing Username
$userid='3'; // ID number of user (for profile)

/* Insert values into the THREAD table, retain threadid */
$sql = "INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,postuserid,lastpos ter,dateline,iconid,visible,attach) VALUES (NULL,'$subject','".time()."','$forumid','1','0',' $postusername','$userid','$pos tusername','".time()."','$iconid','1','0')";
$result = mysql_query($sql);
$threadid = mysql_insert_id();

/* Insert values into the POST able */
$sql = "INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmili e,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes($subject)."','".ad dslashes($postusername)."','$u serid','".time()."','$attachmentid','".addslashes( $message)."','$allowsmilie','$ signature','$ipaddress','$iconid','1')";
$result = mysql_query($sql);
$postid = mysql_insert_id();

/* Update the Post / Thread count in Forum */
$sql = "SELECT * FROM forum WHERE forumid='$forumid'";
$forum_query = mysql_query($sql) or die(mysql_error());
$forum_row = mysql_fetch_Array($forum_query);

$sql = "UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='".time()."',lastpost er='".addslashes($postusername)."' WHERE forumid IN ($forum_row[parentlist])";
$result = mysql_query($sql);

echo "process complete!";

?>

===== End of Code =====

[!!freebsddude]

Can this script be run standalone, i.e. other than being invoked as a web page ? If so, how do you run it from a command line ?

Thanks!

[leeherron]

> Can this script be run standalone ..?

As I understand it, pHp requires being compiled specifically to allow standalone execution .. my installation does not include this option so I can not test this for you. The code you see above is a very simple use of the queries required to post a thread and update the relevant data regarding it. I used it to test the theory and give a guideline of what was needed, but I executed it via http.