Integration Joomla / vBulletin

Hello guys!

Pardon me, but I need of our help with some problems...now:

I use on my Community a bridge of BBPixel, who integration between Portal Joomla and vBulletin Forum : P2PSIN

BBpixel after the integration has released some Joomla's modules and component, type:

[Module] jvbPlugin Latest Post 1.1

This module show on Portal Joomla recent X=number of posts on forum vBulletin; links of this module don't support vBSeo rewrite in .html but are again with forumdisplay.php and showthread.php

Code Module Latest Post:

<?php
/*
+--------------------------------------------------------------------------
| Project: Integration script for Joomla and vBulletin
+--------------------------------------------------------------------------
| For Joomla 1.0.x and vBulletin 3.6.x
| (C) 2005-2007 BBPIXEL
| BBPixel.com - Integration scripts for your Xoops, Joomla, IPB, vBulletin, Vwar..
+---------------------------------------------------------------------------
| > Module: Latest vBulletin's Posts
+---------------------------------------------------------------------------
*/

defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

//Params
$forumArray = trim( $params->get( 'forum_array' ));
$numberOfPost = intval($params->get( 'number_of_post', 5 ));
$compactMod = intval($params->get( 'compact_mod', 0 ));
$maxTitleLength = intval($params->get( 'title_length', 0 ));
$introText = $params->get( 'intro_text', '' );
$dateFormat = $params->get( 'date_format', 'm/d/y' );

//Load services for IPB
$content = "{$introText}";

global $bbpixelPPS;

//.. Get lasted topic
$whereForum = "";
if(strlen($forumArray) > 0){
$whereForum = "AND f.forumid NOT IN ({$forumArray})";
}

$query = "SELECT t.*, f.forumid as fid, f.title as fname
FROM {$bbpixelPPS->_vb_db_prefix}thread t,
{$bbpixelPPS->_vb_db_prefix}forum f
WHERE t.forumid = f.forumid {$whereForum}
ORDER BY t.lastpost DESC
LIMIT {$numberOfPost}";

$database->setQuery($query);
$topiclist = $database->loadObjectList();
$enum = 0;
if(is_array($topiclist)){
$row = "";
foreach ($topiclist as $topic){
$style = " class='sectiontableentry1' ";
if($enum%2 == 0){
$style = " class='sectiontableentry2' ";
}

//Title, does it need to cut
if(($maxTitleLength > 0) && strlen($topic->title)>$maxTitleLength){
$title = substr($topic->title, 0, $maxTitleLength)."..";
}else{
$title = $topic->title;
}

if (!$bbpixelPPS->wrapperID) {
$urlTopic = $bbpixelPPS->_vb_forum_url."/showthread.php?t={$topic->threadid}";
$urlLastPost = $bbpixelPPS->_vb_forum_url."/showthread.php?t={$topic->threadid}&amp;goto=newpost";
$urlForum = $bbpixelPPS->_vb_forum_url."/forumdisplay.php?f={$topic->fid}";
$urlUser = $bbpixelPPS->_vb_forum_url."/member.php?u={$topic->postuserid}";
$urlBoard = $bbpixelPPS->_vb_forum_url;
} else {
$urlTopic = $mosConfig_live_site."/index.php?option=com_wrapper&amp;Itemid=".$bbpixel PPS->wrapperID."&amp;bbact=showthread.php?t-{$topic->threadid}";
$urlLastPost = $mosConfig_live_site."/index.php?option=com_wrapper&amp;Itemid=".$bbpixel PPS->wrapperID."&amp;bbact=showthread.php?t-{$topic->threadid}&amp;goto=newpost";
$urlForum = $mosConfig_live_site."/index.php?option=com_wrapper&amp;Itemid=".$bbpixel PPS->wrapperID."&amp;bbact=forumdisplay.php?f-{$topic->fid}";
$urlUser = $mosConfig_live_site."/index.php?option=com_wrapper&amp;Itemid=".$bbpixel PPS->wrapperID."&amp;bbact=member.php?u-{$topic->postuserid}";
$urlBoard = $mosConfig_live_site."/index.php?option=com_wrapper&amp;Itemid=".$bbpixel PPS->wrapperID."&amp;bbact=";
}
$topic->lastpost = date($dateFormat, $topic->lastpost);

if($compactMod == 1){
$row .= "
<div {$style}>
<a href=\"$urlUser\">{$topic->postusername}</a>: <a href='{$urlTopic}' title='{$topic->fname}: {$topic->title}'>{$title}</a><br/>
@ {$topic->lastpost} by {$topic->lastposter}
</div>
";
}else {
$row .= "<tr {$style}>
<td>
<a href='{$urlTopic}' title='{$topic->title}'>{$title}</a><br/>
In: <a href='{$urlForum}'>{$topic->fname}</a>
</td>
<td><a href='{$urlUser}'>{$topic->postusername}</a></td>
<td>{$topic->views}</td>
<td>{$topic->replycount}</td>
<td>
<a href='{$urlLastPost}' title='get last comment..'>{$topic->lastpost}</a><br/>
by <b><i>{$topic->lastposter}</i></b>
</td>
</tr>";
}


$enum++;
}
if($enum>0){
if($compactMod == 1){
$content .= "{$row}";

}else{
$content .= "
<table width='100%'>
<tr>
<td class='sectiontableheader'><b>Thread</b></td>
<td class='sectiontableheader'><b>Author</b></td>
<td class='sectiontableheader'><b>Views</b></td>
<td class='sectiontableheader'><b>Posts</b></td>
<td class='sectiontableheader'><b>Last Comment</b></td>
</tr>
{$row}
<tr>
<td colspan='2'>
<a href='{$urlBoard}'>Visit our forum</a>
</td>
<td colspan='2' align='right'>
&copy; <a href='http://bbpixel.com' title='Powered by BBPixel jvbPlugin - Integration script for your Joomla and vBulletin' target='_blank'>BBPixel.com</a>
</td>
</tr>
</table>";
}

}
}
?>

Please, is possibile modificate this module with vBSeo format?

Very thanks and pardon for my bad english

Hello Jarod,

you can use vBSEO Functions for Extensibility for that

Hello Oleg

Pardon me..But I Have tried but sincerely do not succeed ... could not give us a look also you, please?

You can try the following:
FIND:

PHP Code:

$topiclist = $database->loadObjectList(); 


ADD ABOVE:

PHP Code:

include_once 'forum/includes/functions_vbseo.php'; // put correct path according to your forum location here
vbseo_startup(); 


FIND:

PHP Code:

$urlTopic = $bbpixelPPS->_vb_forum_url."/showthread.php?t={$topic->threadid}";
$urlLastPost = $bbpixelPPS->_vb_forum_url."/showthread.php?t={$topic->threadid}&goto=newpost";
$urlForum = $bbpixelPPS->_vb_forum_url."/forumdisplay.php?f={$topic->fid}";
$urlUser = $bbpixelPPS->_vb_forum_url."/member.php?u={$topic->postuserid}"; 


REPLACE WITH:

PHP Code:

$urlTopic = $bbpixelPPS->_vb_forum_url."/".
vbseo_thread_url_row(array( 
'threadid'=>$topic->threadid,
'title'=>$topic->title,
'forumid'=>$topic->fid
));


$urlLastPost = $bbpixelPPS->_vb_forum_url."/".
vbseo_thread_url_row_spec(array( 
'threadid'=>$topic->threadid,
'title'=>$topic->title,
'forumid'=>$topic->fid
),VBSEO_URL_THREAD_LASTPOST);

$urlForum = $bbpixelPPS->_vb_forum_url."/".vbseo_forum_url($topic->fid);
$urlUser = $bbpixelPPS->_vb_forum_url."/member.php?u=".vbseo_member_url_row($topic->postuserid, $topic->postusername); 


It’s little complicated for me to solve
But I am looking in deep & will contact you later
By the way, you can also contact any professional joomla developers like

you can try with [COLOR=#000000]$topiclist = $database->loadObjectList[COLOR=#007700]();