vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Need to display VBulletin items on pages outside vbulletin (https://vborg.vbsupport.ru/showthread.php?t=211636)

SlackerAPM 04-19-2009 02:02 PM

Need to display VBulletin items on pages outside vbulletin
 
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 04-19-2009 02:38 PM

newest post or threads?

SlackerAPM 04-19-2009 02:45 PM

posts would be best, but either would work.

BBR-APBT 04-19-2009 02:58 PM

<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 04-19-2009 11:26 PM

Quote:

Originally Posted by BBR-APBT (Post 1794450)

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 04-19-2009 11:31 PM

Quote:

Originally Posted by SlackerAPM (Post 1794803)
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?

Code:

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

if you have no prefix leave it blank.

SlackerAPM 04-19-2009 11:59 PM

Quote:

Originally Posted by BBR-APBT (Post 1794805)
Did you edit this line?

Code:

$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 04-20-2009 05:54 AM

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?


All times are GMT. The time now is 02:14 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02529 seconds
  • Memory Usage 1,731KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete