Auto-creation of threads?

[Andreas]

Basic code to post a new thread (as any user you want):

PHP Code:

chdir('/path/to/forum/root');

// Load vB-Backend
require('./global.php');
require(./includes/functions_newpost.php');

$userid = 1234; // The user creating the thread
$forumid = 12; // The forum where the thread should be posted

// Get forum & user info
$foruminfo = fetch_foruminfo($forumid);
$bbuserinfo = fetch_userinfo($userid);

// Setup the thread
$post[title] = 'Some foobar title';
$post[message] = 'Some foobar message text';
$post[poststarttime] = TIMENOW;
$post[posthash] = md5($post[poststarttime] . $bbuserinfo['userid'] . $bbuserinfo['salt']);

// build the thread
build_new_post('thread', $foruminfo, array(), 0, $post, $errors);

// Errors?
if (sizeof($errors) > 0)) {
  // error processing
} 


[Wired1]

Originally Posted by version2

All right. I am done talking to myself. Hopefully this will help someone in the future. I got around the cookie problem by declaring the username and then grabbing the bbuserinfo using that username. I am also using init.php and not global.php. Everything seems to be working. All counts are being update, etc.

Mind sharing that bit of code? That'll save tons of work for me, eheh.

As for the rest, Finally no errors! Wait.... yep, found one! This one's minor though, can be taken care of with the bot account. For some reason, it auto subscribes me to the threads created with that script, yet not when I make one normally. Are you being auto subscribed to your threads?

Then again, not sure I want massive amounts of subscriptions in the bot's acct. Yes, auto subscribe for the acct is turned off.

Next thing to tackle is an if stmt in the postbit that if picture is part of data, pic will be displayed in the thread. That's cake, but I've been experimenting with pics and text in a post. Only way I can figure out a way to wrap the text around the pic is with table cells. Crude, but should work just fine.

Next thing I'm going to be working on is how to grab the newly created threadID (maybe even post ID) after the thread/post is made.

I'm also looking into how to auto create a forum/sub forum, but for security reasons, I think I might not let the bot have this access, and find out how to do it with normal mySQL statements. Any suggestions/tips?

[Andreas]

Originally Posted by Wired1

Next thing I'm going to be working on is how to grab the newly created threadID (maybe even post ID) after the thread/post is made.

If you are manually dealing with the database:
$DB_site->insert_id();

[Wired1]

Kirby, thanks! That's solved the posterid prob, but it also auto-subscribes the account to the thread.

$DB_site->insert_id();

hhmm.... not quite sure how that's supposed to be used. Mind giving me an example, or a place in the vB code (or a thread here) that explains that?

[version2]

Originally Posted by Wired1

Mind sharing that bit of code? That'll save tons of work for me, eheh.?

Dont mind at all! But, I think I have been beaten to the punch. Kirby already posted it:

PHP Code:

$userid = 2;
$bbuserinfo = fetch_userinfo($userid); 


Kirby's code is about what I ended up with.

[Wired1]

Thanks as well version2! BTW, I'm grabbing the threadID after it is created automatically so that I can place it into another table I created, so that another page will auto-create links to certain threads based on other criteria.

[version2]

Originally Posted by Wired1

Kirby, thanks! That's solved the posterid prob, but it also auto-subscribes the account to the thread.

PHP Code:

$post['emailupdate'] = 9999; 


That'll fix the subscribe.

[Andreas]

@Wired1:

PHP Code:

$post['emailupdate'] = 9999; 


before calling build_new_post() should avoid subscribing the thread.

If you use this function to create the thread you can use
$post['threadid'] and $post['postid'] afterwards - the ID's will be there.

[Wired1]

Wahooo!!!!! Now to understand $DB_site->insert_id();

[Wired1]

But I can only use $post['threadid'] and $post['postid'] after the build_new_post is hit in the code, correct? I think that'll save me 1 query

This look right?

PHP Code:

// Load vB-Backend 
require('./global.php'); 
require('./includes/functions_newpost.php'); 

$userid = 5; // The user creating the thread 
$forumid = 10; // The forum where the thread should be posted 

// Get forum & user info 
$foruminfo = fetch_foruminfo($forumid); 
$bbuserinfo = fetch_userinfo($userid); 

// Setup the thread 
$post[title] = 'Some foobar sssstitle'; 
$post[message] = 'Some foobar message text'; 
$post[poststarttime] = TIMENOW; 
$post[posthash] = md5($post[poststarttime] . $bbuserinfo['userid'] . $bbuserinfo['salt']); 
$post['emailupdate'] = 9999; 

// build the thread 
build_new_post('thread', $foruminfo, array(), 0, $post, $errors); 

// Errors? 
if (sizeof($errors) > 0) { 
  // error processing 
}
ThreadID = $post['threadid']; 
PostID = $post['postid']; 


ThreadID and PostID are columns in a table I have created.