vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   1 Site, 2 DBs (https://vborg.vbsupport.ru/showthread.php?t=42604)

Hwulex 08-22-2002 08:44 AM
1 Site, 2 DBs
 
Ok, I've just finished programming v1 of my new site and, naturally, it has a vB forum on it, but I'm now going to work on integrating the two a little, so that the home page will show who's on the forums etc.

Am I going to have to have everything in the one DB to do this? Or can I use two different DBs.

My site programming and structure works in the same way vB does ($db->query, etc), so the db from my site has template, style, tables the same as vB does. So integrating them will be a pain, but do-able.

Hwulex 08-22-2002 09:05 AM
What I'm trying to do now is insert the loading script for vB into my files to load the vB database into $db_Site (coz mine's on $db) but it's not working :(

The server details are the same for both so just used my config.php for both

PHP Code:
// ###################### Start init #######################

// load config
require ("./admin/config.php");

// init db

    // load db class
    require ("./admin/class.php");

    $db =  new mysql_actions;

    $db->host = "$servername";
    $db->db = "$dbname";
    $db->username = "$dbusername";
    $db->password = "$dbpassword";

    $db->connect();

// end init db


// ###################### Start init #######################

//load config
require('./admin/config.php');

// init db **********************

    // load db class
    require ("./forums/admin/db_mysql.php");

    $DB_site = new DB_Sql_vb;

    $DB_site->appname='vBulletin';
    $DB_site->appshortname='vBulletin (forum)';
    $DB_site->database='testvb';
    $DB_site->server=$servername;
    $DB_site->user=$dbusername;
    $DB_site->password=$dbpassword;

    $DB_site->connect();

// end init db 
I just get this error:
Quote:
Warning: Supplied argument is not a valid MySQL result resource in c:\webdev\Weird\admin\class.php on line 44
You have an error in your SQL syntax near '))' at line 3
Class.php:
PHP Code:
41- function query_first($query) {
42-    // does a query and returns first row
43-    $query = mysql_query($query);
44-    $returnarray = mysql_fetch_array($query);
45-    return $returnarray;
46- } 
I normally get this error when the $db isn't working properly, so is telling me it's not.

Help! :(

Xenon 08-22-2002 10:19 AM
Hwulex, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.

Hwulex 08-22-2002 01:20 PM
Hi, I have done that once, but it's gone for some reason.
I have emailed vBulletin for my license because I lost them in a HDD failure.
I'm still waiting for them to send me my license details :(

Hwulex 08-26-2002 06:06 PM
Help!
Please! :(


All times are GMT. The time now is 10:45 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.01002 seconds
  • Memory Usage 1,733KB
  • 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_php_printable
  • (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