Latest posts on NON VB Homepage

[MetalMilitia]

I know it's probably pretty simple but I was wondering if someone could help find me a hack that would show like the latest XX of threads on my joomla powered main site. I used to have the hack long, long ao - but the ones I've tried thus far haven't been working correctly.

Anyone got some thoughts?

Thanks in advance!

[Lynne]

See these threads for methods to pull threads via javascript:
[HowTo] Display your latest threads on an external page using an RSS2 feed (http://www.vbulletin.com/forum/showthread.php?t=159044)
[HowTo] Display your latest threads on an external page using an XML feed (http://www.vbulletin.com/forum/showthread.php?t=158934)
[HowTo] Display your latest threads on an external page using an RSS feed (http://www.vbulletin.com/forum/showthread.php?t=158916)

[Ohiosweetheart]

Those explanations are confusing Lynne. My first question would be.... near the top of what php page?? And what if you aren't using a php page, but an html page?

[gsmph]

if ($vbulletin->userinfo['userid']!=0) {


$newposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post AS post " . iif($vbulletin->options['threadmarking'], 'LEFT JOIN ' . TABLE_PREFIX . 'threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = ' . $vbulletin->userinfo['userid'] . ')') . " WHERE dateline >= " . $vbulletin->userinfo['lastvisit'] . iif($vbulletin->options['threadmarking'], ' AND dateline > IF(threadread.readtime IS NULL, ' . (TIMENOW - ($vbulletin->options['markinglimit'] * 86400)) . ', threadread.readtime)'));
$newposts = vb_number_format($newposts['count']);

echo"<a href=\"".$forumpath."search.php?$session[sessionurl]do=getnew\">$vbphrase[new_posts]</a>: $newposts<br />";}


add this code anywhere you like on your joomla index


if am wrong please do correct me :(


i hope this helps..

br
gsmph

[RLShare]

You are wrong, 1. he/she is asking to list the latest threads from VB in a joomla page. Not a link to the latest posts 2. Depending on the bridge being used(if a bridge is being used), it is more then likely that the VB dependent variables would not be defined.

@OhioSweetheart
To do what you want to do you should look up how to create a module in Joomla and use the code in the links provided above within the custom Joomla module. If you are not familiar with PHP programming as it seems you are not then you would first need to learn it or have someone else code it for you.

There is a module that does exactly what you want available for Joomla already but it costs $25 and only works on 1.0 installations. Google for it.


Edit: Here is the one I was talking about..
http://www.elearningforce.biz/bridges/vbulletin-module---last-posts.html

Edit Edit: I guess Im meant to refer that last statement to MetalMaliticia not Ohio Sweetheart


For a static HTML Ohio Sweetheart it would be pretty impossible, you would need some sort of server side language.

[Lynne]

Actually, for an html page, you can look at this thread - HowTo Display Latest Active Threads on ANY normal HTML page (http://www.vbulletin.com/forum/showthread.php?t=283817)