| brtev |
06-29-2010 05:42 AM |
Last Post Link not working for auto created threads.
Here's the code I'm using
Code:
//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. |
More Information