vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Query from board B to board A. (https://vborg.vbsupport.ru/showthread.php?t=190678)

kleinschwanz 09-11-2008 06:58 PM

Query from board B to board A.
 
Query from board B to board A. Is this possible and how?

Ok to explain it before there is many questions.

I am planning to use two boards in near future, as the one-board system userright elements and will not grip in this case.

Board B should only register on invite AND when the invited user has same email with a certain postcount (or maybe activity level) in board A. I have a good old invite hack working and I only need the information if it is possible to do this query from one board to another and how.

Thank you for your patience

Eikinskjaldi 09-11-2008 10:29 PM

If both boards are on the same mysql server then all you have to do is prefix tables with the database name

e.g.

Select blah from database1.table1
join database2.table1
on (database1.table1.id = database2.table1.id)

If the mysql servers are on different machines then you will need to replicate the vb DB class and set the second up to talk to that machine. You cannot cross query directly in that instance, but you could use php as an intermediate

$db1stuff = select blah from db1
$db2 stuff = select blah from db2 where field in ($db1stuff)

kleinschwanz 09-12-2008 11:22 AM

thanx a lot :D I will try to get that in my brain LOL


All times are GMT. The time now is 08:39 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.00957 seconds
  • Memory Usage 1,706KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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