Last Post Link not working for auto created threads.

[brtev]

Here's the code I'm using


//CREATE FORUM THREAD

//Associate category with a forum
if ($entry[catid] == 2) {
$forumid = 7;
}

if ($entry[catid] == 3) {
$forumid = 30;
}

if ($entry[catid] == 4) {
$forumid = 56;
}

//Create forum thread
$db->query_write("
INSERT INTO ".TABLE_PREFIX."thread
(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, iconid, visible)
VALUES(
'" . addslashes(htmlspecialchars($entry['title'])) . "',
" . TIMENOW . ",
$forumid,
1,
0,
'". addslashes($entry['username']) ."',
" . $entry['userid'] . ",
'". addslashes($entry['username']) ."',
" . TIMENOW . ",
0,
1
)");

$threadinfo['threadid'] = $db->insert_id();
$url = "LINK";
// Creating Post
$db->query_write("
INSERT INTO ".TABLE_PREFIX."post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible)
VALUES(
$threadinfo[threadid],
0,
'" . addslashes(htmlspecialchars($entry['title'])) . "',
'" . addslashes($entry['username']) . "',
" . $entry['userid'] . ",
" . TIMENOW . ",
'". addslashes($url) . "',
1,
1,
0,
0,
1
)");

$post['postid'] = $db->insert_id();
$db->query_write("UPDATE ".TABLE_PREFIX."thread SET firstpostid = $post[postid] WHERE threadid = $threadinfo[threadid]");
require_once('./includes/functions_databuild.php');

build_post_index($post['postid'], $foruminfo, iif($type == 'thread', 1, 0));

// update forum stuff
$db->query_write("UPDATE " . TABLE_PREFIX . "forum
SET replycount = replycount + 1, threadcount = threadcount + 1, lastpost = " . TIMENOW . ", lastposter = '" . addslashes($entry[username]) . "', lastthread = '" . addslashes(htmlspecialchars($entry[title])) . "', lastthreadid = $threadinfo[threadid] WHERE forumid = $forumid");
$newtid = $db->query_first("SELECT dateline, threadid FROM ".TABLE_PREFIX."thread WHERE postuserid = '$entry[userid]' ORDER BY dateline DESC");
$_POST['message']=$_POST['message']."\n ";

// link forum thread to comments
$db->query_write("UPDATE " . ADV_DYNA_TABLE_PREFIX . "entries
SET linkedthread = $threadinfo[threadid] WHERE entryid = $newentryid");


// ###### END CREATE NEW THREAD ######


Basically this code auto creates a thread and links it to my VBA Dynamics articles. Everything works but the last post/new post links on my forum page.

http://virtualfaqs.com/forum/virtual-faqs/290-welcome-virtual-faqs-new-post.html
The link doesn't work unless you remove "new-post"

And my last post link for this thread shows:
http://virtualfaqs.com/forum/showthread.php?p=0#post0

Anyone have any ideas? Thanks!

--------------- Added 1277839213 at 1277839213 ---------------

Solved it! I just had to rebuild Forum Info.