new thread through mysql?

[Rebecca217]

I have a large number of articles, and I would like to insert them each of them into vB 3.03 as new threads. The articles were originally written in a program which validates off the vb database, so the articles' authors all have a correctly assigned user ID (which I will need to preserve.)

Is this possible, either through a modified form, or directly through MySQL? If so, can anyone offer suggestions on how to go about it?

I appreciate any help you can offer.

Rebecca

[miz]

ok for the mysql addon look on this code from functions_newpost.php


$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
iconid, visible, attach, similar)
VALUES
('" . addslashes($post['title']) . "', " . TIMENOW . ", " . intval($foruminfo['forumid']) . ",
1, 0, '" . addslashes($post['postusername']) . "', $bbuserinfo[userid],
'" . addslashes($post['postusername']) . "', " . TIMENOW . ", $post[iconid], $post[visible],
$totalattachments, '" . addslashes($similarthreads) . "')
");
$threadinfo['threadid'] = $DB_site->insert_id();
//############## now insert new post###########################
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
($threadinfo[threadid], $parentid, '" . addslashes($post['title']) . "',
'" . addslashes($post['postusername']) . "', $bbuserinfo[userid], " . TIMENOW . ",
'" . addslashes($post['message']) . "', $post[enablesmilies], $post[signature],
'" . addslashes($post['ipaddress']) . "', $post[iconid], $post[visible], $totalattachments)
");
$post['postid'] = $DB_site->insert_id();

// ######### update thread with post id ###########

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET firstpostid = $post[postid]
WHERE threadid = $threadinfo[threadid]
");




now, all you need to do is to replace the vars and thats it
about the user id, you can add user called bot take his userid and use it
or you just can add fake userid like 999999 or something

[Xenon]

the build_new_post() function does everything automatically, so if your script is integrated in vb, you don't have to care about the queries itself.

but if you need the queries, look above ;)