vb.org Archive - Need help trying to insert thread to db

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Need help trying to insert thread to db (https://vborg.vbsupport.ru/showthread.php?t=77116)

Need help trying to insert thread to db

I am trying to add a new thread. This is for a non-vb page and trying with the build thread function was not working because including global and was changing some of the session data for another program that we are using.

So I thought about just adding the post to the db directly. I found a few posts here and there about it, and put something together, but it is not working.

PHP Code:


		
			
<?php
 
// ### POST NEW THREAD ###
$post['title']='test title';
$post['postusername'] = 'test username';
$post['userid']=1264;
$foruminfo['forumid']=73;
$post['iconid']=0;
$post['visible']=1;
$totalattachments=0;
$similarthreads = '';
$post['postpoll']=0;
$post['message']='test message';
 
$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']) . "', $post['userid'], '" . addslashes($post['postusername']) . "', " . TIMENOW . ", $post['iconid'], $post['visible'], $totalattachments, '" . addslashes($similarthreads) . "')
");
$threadinfo['threadid'] = $DB_site->insert_id();
$post['threadid'] = $threadinfo['threadid'];
$threadinfo['visible'] = $post['visible'];
$threadinfo['forumid'] = $foruminfo['forumid'];
$threadinfo['title'] = $post['title'];
$threadinfo['pollid'] = $post['postpoll'];
$threadinfo['iconid'] = $post['iconid'];
$threadinfo['open'] = 1;
$threadinfo['sticky'] = 0;
$parentid = 0;
// ### POST 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']) . "', $post[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]
");
 
?>

I get this error for line 17 Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

Also I am not sure if this is even correct. Can someone please help me out?

Thanks

the best way is to use that function since it will correctly update and insert all the information;)

That's what I was hoping to do. But what we have is a seperate knowledge base and I want to post a thread when there is a new entry. But when we included global and functions_newpost is was messing with the session data for the knowledgebase and it stopped working. :(

Ok, I think I got past the first set of errors, but now I get a new error.

Fatal error: Call to a member function on a non-object on line 15

PHP Code:


		
			
<?php



// ### POST NEW THREAD ###

$post['title']='test title';

$post['postusername'] = 'test username';

$post[userid]=1264;

$foruminfo[forumid]=73;

$post[iconid]=0;

$post[visible]=1;

$totalattachments=0;

$similarthreads = '';

$post[postpoll]=0;

$post['message']='test message';



$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']) . "', $post[userid], '" . addslashes($post['postusername']) . "', " . TIMENOW . ", $post[iconid], $post[visible], $totalattachments, '" . addslashes($similarthreads) . "')

");

$threadinfo['threadid'] = $DB_site->insert_id();

$post['threadid'] = $threadinfo['threadid'];

$threadinfo[visible] = $post[visible];

$threadinfo['forumid'] = $foruminfo[forumid];

$threadinfo['title'] = $post['title'];

$threadinfo['pollid'] = $post[postpoll];

$threadinfo['iconid'] = $post[iconid];

$threadinfo['open'] = 1;

$threadinfo['sticky'] = 0;

$parentid = 0;

// ### POST 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']) . "', $post[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]

");



?>

You will need to require_once global.php, or you will not have access to the $DB_site functions.

Thanks. A friend of mine got it working fine now without the manual inserting. :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01037 seconds Memory Usage 1,779KB 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 (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages: