Outputting Threads Onto Non-vB Page

For my site i am trying to make a review system using the base of vBulletin, so i thought the easiest way would be to just add fields to the New Thread thing, now i got more fields added, but one thing i would like to be able to do would be to do would be to be able to output the threads onto a Non-vB PHP File, something like this

http://localhost/forums/showthread.php?s=&threadid=1168

would become

http://localhost/showreview.php?s=&threadid=1168
(preferably shorter, i'm not sure how far i can go with shortening the url, although once i get it sorted out i would like to output it into static html files)

What would i have to put into a PHP file to be able to call this stuff out?

[assassingod]

Trigunflame, that is a very complex way of doing it - you are using so much unnessacary code there.

If you were to require global.php, you could use a query to extract the last x threads, then eval a template in a while loop.

[Trigunflame]

Yes but, I was taking into account the forum might have been on another server (which is often), so making my own small mysql class works for a persons benefit.

Ive been coding for nearly 7 years and have been contracted on big projects in excess of $500 for a script. My knowledge of coding need not be questioned by you.

ps. I dont like using eval why use another function when i can simply <?php and ?> around things.

Thanks

[assassingod]

Originally Posted by Trigunflame

Yes but, I was taking into account the forum might have been on another server (which is often), so making my own small mysql class works for a persons benefit.

Ive been coding for nearly 7 years and have been contracted on big projects in excess of $500 for a script. My knowledge of coding need not be questioned by you.

ps. I dont like using eval why use another function when i can simply <?php and ?> around things.

Thanks

I did not mean to offend by my post. I was merely suggesting that a more efficient way to it was to use something like (this is code from my portal, it wont work with vB2 so dont try it)

PHP Code:

        $news = $DB_site->query("
        SELECT thread.threadid,thread.title,thread.replycount,thread.postusername,thread.postuserid,thread.dateline,thread.views,thread.iconid,post.pagetext
        FROM " . TABLE_PREFIX . "thread
        LEFT JOIN post ON (post.threadid = thread.threadid AND post.dateline = thread.dateline)
        WHERE forumid = '$vboptions[ap_news_forumid]'
        ORDER BY thread.dateline DESC
        LIMIT $vboptions[ap_news_numofnews]
    ");
        while ($newss = $DB_site->fetch_array($news))
        {
            $newss['dateline'] = vbdate($vboptions['dateformat'], $newss['dateline'], 1);
            $newss['pagetext'] = parse_bbcode($newss['pagetext']);
            eval('$portal_news .= "' . fetch_template('portal_news') . '";');
        } 


Its almost the same with vB2, although I do believe it will require editing newreply.php but thats it.

[ULTIMATESSJ]

that would be for showing the last x threads though, right?

hell, i can't do this so i'm just not gonna bother, helps way out of my reach for this, and i don't feel like paying someone a load of money for something thats easily done

[Sylvus]

There is hope! Someone is putting the finishing touches on an article review system for vBulletin. There was a thread about it just posted recently on this site from what I can recall.

Patience!

Syl...

[ULTIMATESSJ]

Originally Posted by Sylvus

There is hope! Someone is putting the finishing touches on an article review system for vBulletin. There was a thread about it just posted recently on this site from what I can recall.

Patience!

Syl...

I know about that, but by that time, the web will be plastered with article systems meaning originality in that factor will be dead, making my system pretty pointness. I don't care for anyone elses system, all i want is to output my threads, i have my own article system made on my forums, i just need to know how to output the threads, and before someone releases an Article System and it gets plastered all over the net

EDIT: I used TrigunFlames code, worked perfectly, so thanks to TrigunFlame for solving a problem i've had for months