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!