The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
new thread through mysql?
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 |
#2
|
|||
|
|||
ok for the mysql addon look on this code from functions_newpost.php
Code:
$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 |
#3
|
||||
|
||||
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 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|