vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Connecting to new database inside admincp (https://vborg.vbsupport.ru/showthread.php?t=162578)

BamaStangGuy 11-13-2007 01:05 AM
Connecting to new database inside admincp
 
I have another database that I want to pull info from and show the stats on the vbulletin admincp when I login. What's the best way to connect to another database to do such things?

Analogpoint 11-13-2007 03:27 AM
mysql_connect
mysql_select_db
mysql_query

Not necessarily the best way, but probably the simplest.

BamaStangGuy 11-13-2007 05:02 AM
k, that was what I was planning on doing I just wanted to see if others had different methods.

Thanks.

Eikinskjaldi 11-14-2007 02:47 AM
Assuming its a database on the same server as the main vb one, you just need to add a database prefix to the sql. Mysql doesn't really care where tables live, and is even more than happy to join across databases.

select db1.table1.fieldA, db2.table2.fieldB
from db1.table1
join db2.table2 using (fieldC)

You can use the vb db wrapper for this ($vbulletin->db->query etc)

Analogpoint 11-14-2007 01:00 PM
Quote:
Originally Posted by Eikinskjaldi (Post 1382155)
Assuming its a database on the same server as the main vb one, you just need to add a database prefix to the sql. Mysql doesn't really care where tables live, and is even more than happy to join across databases.


select db1.table1.fieldA, db2.table2.fieldB
from db1.table1
join db2.table2 using (fieldC)


You can use the vb db wrapper for this ($vbulletin->db->query etc)
Assuming your vBulletin MySQL user has permission to access the other database, that's fine


All times are GMT. The time now is 03:48 PM.

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.00972 seconds
  • Memory Usage 1,717KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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