I run a modified script that I use an include command on my front page to pull posts out of a desinated forum as my news stories. I am trying to make it so I can create it how it works now on the front page.
If you go to this link:
<!-- m --><a class="postlink" href="http://www.sportsrant.com/post.php">http://www.sportsrant.com/post.php</a><!-- m --> and you will see when you click on the full story link it takes you to the forum.
This is the database call:
$threads = $DB_site->query("
SELECT $previewfield
thread.postuserid, thread.replycount, thread.threadid, thread.title, thread.lastposter, thread.lastpost, thread.postusername, thread.dateline, forum.forumid, forum.title AS forumtitle
FROM " . TABLE_PREFIX . "thread AS thread
$previewjoin
INNER JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE thread.forumid IN(" . implode(',', $forumids) . ") $forumchoice
AND thread.visible = 1
AND deletionlog.primaryid IS NULL
ORDER BY thread.dateline DESC
LIMIT 6
");
I want to make another similiar to this that when you click on full story, it would open the story (entire post) on its own page without going to the forums and not the rest of the comments, can this be done
Mikesure it can...
i imagine that you'd need to goto the showthread.php file and modify it ( of course save it as like showthread_1.php or something ) to reveal Only the post in question when it searches mysql for it...
then you could have the link open <a target="_blank"> for the post to open in it's own window
i, myself don't use vbulletin ( yet ) so i am unable to write the specific code for ya, sorry bout that
If you go to this link:
<!-- m --><a class="postlink" href="http://www.sportsrant.com/post.php">http://www.sportsrant.com/post.php</a><!-- m --> and you will see when you click on the full story link it takes you to the forum.
This is the database call:
$threads = $DB_site->query("
SELECT $previewfield
thread.postuserid, thread.replycount, thread.threadid, thread.title, thread.lastposter, thread.lastpost, thread.postusername, thread.dateline, forum.forumid, forum.title AS forumtitle
FROM " . TABLE_PREFIX . "thread AS thread
$previewjoin
INNER JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE thread.forumid IN(" . implode(',', $forumids) . ") $forumchoice
AND thread.visible = 1
AND deletionlog.primaryid IS NULL
ORDER BY thread.dateline DESC
LIMIT 6
");
I want to make another similiar to this that when you click on full story, it would open the story (entire post) on its own page without going to the forums and not the rest of the comments, can this be done
Mikesure it can...
i imagine that you'd need to goto the showthread.php file and modify it ( of course save it as like showthread_1.php or something ) to reveal Only the post in question when it searches mysql for it...
then you could have the link open <a target="_blank"> for the post to open in it's own window
i, myself don't use vbulletin ( yet ) so i am unable to write the specific code for ya, sorry bout that