Need help trying to insert thread to db

[DRJ]

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

// ### 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

[AN-net]

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

[DRJ]

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

// ### 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]
");

?>

[Marco van Herwaarden]

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

[DRJ]

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