Need to display VBulletin items on pages outside vbulletin

[SlackerAPM]

Im sure this is a question that is asked time and time again, but i have searched and searched and am coming up with nothing.

I have a Wordpress page and in the sidebar I want to display X # of recent posts from all the forums that are available to the viewer who is viewing the page. I have the Wordpress to VBulletin bridge running, and the login runs just fine on the wordpress page, so I dont think that will be an issue.

I know a lot about coding for wordpress, but coding for VBulletin I know pretty much nothing about. So what code to use to set up the queries and all that, its all lost on me.

Heres what I want:

--------

Latest Forum posts

Thread Title
Posted by User* on Day Time
Post preview

*Ideally clicking on the username would take you to their profile.
--------

What query do I use to call those posts? Do I need a hook, I barely even understand what a hook is. Then what code generates the bolded areas? Actually I think i can get that part on my own, its really the query that i have no idea how to implement on a separate page.

I have been able to make this work like i want to using external.php?type=js but it doesnt allow me to link to the user profile or insert the post preview, and thats what I really want.

Any help you can give would be appreciated, or point me in the direction of any tutorials. like I said, im not sure what I need so im not exactly sure what to search for.

Thanks.

[BBR-APBT]

newest post or threads?

[SlackerAPM]

posts would be best, but either would work.

[BBR-APBT]

<a href="https://vborg.vbsupport.ru/showthread.php?t=176297" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=176297</a>

That does exactly what you want.

[SlackerAPM]

Originally Posted by BBR-APBT

https://vborg.vbsupport.ru/showthread.php?t=176297

That does exactly what you want.

Thanks, ive got the settings as they need to be and im getting this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/wordpress/wp-content/themes/TVCY/includes/newstopics.inc.php on line 47

What do i need to do?

[BBR-APBT]

Originally Posted by SlackerAPM

Thanks, ive got the settings as they need to be and im getting this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/wordpress/wp-content/themes/TVCY/includes/newstopics.inc.php on line 47

What do i need to do?

Did you edit this line?

$vbprefix = 'vb3_'; // The prefix you are using for vbulletin.

if you have no prefix leave it blank.

[SlackerAPM]

Originally Posted by BBR-APBT

Did you edit this line?

$vbprefix = 'vb3_'; // The prefix you are using for vbulletin.

if you have no prefix leave it blank.

When I leave it blank, nothing displays. The config.php file in the vbulletin includes folder lists this field as blank. Am I looking in the right place?

Why do I need to do all this setup for the connection settings? I can insert

PHP Code:

        <?php global $vbulletin;

echo "Welcome, " . $vbulletin->userinfo['username']; ?>

into a wordpress template and it calls the logged in username just fine without all that stuff.

[Dismounted]

My guess: You have setup to use MySQLi. The modification in question does not use the proper vBulletin abstractions and calls the original MySQL API.

In config.php, have you selected MySQLi?