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...-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 [DATE]1277839213[/DATE] at [TIME]1277839213[/TIME] ---------------

Solved it! I just had to rebuild Forum Info.