vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   new thread through mysql? (https://vborg.vbsupport.ru/showthread.php?t=69529)

Rebecca217 09-16-2004 04:02 PM
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

miz 09-17-2004 01:49 AM
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

Xenon 09-20-2004 12:46 PM
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 ;)


All times are GMT. The time now is 10:03 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01240 seconds
  • Memory Usage 1,721KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete