[c4smok]

I seem to be getting a database error for the forum system when I try to use that.


This is the current code I use to bring over vars from other tables in the same database.

$uservar = $vbulletin->db->query_first("
    SELECT *
    FROM `table_servusers`
    WHERE `username` = '" . $vbulletin->userinfo['username'] . "'
    LIMIT 1
");

This is the changes I made based on your advice which I may not be doing correctly. The user for both databases have the same access also.

$uservar = $vbulletin->db->query_first("
    SELECT *
    FROM `mysite_database2.table_servusers`
    WHERE `username` = '" . $vbulletin->userinfo['username'] . "'
    LIMIT 1
");

The Error msg

Invalid SQL:

    SELECT *
    FROM `mysite_database2.table_servusers`
    WHERE `username` = 'c4smok'
    LIMIT 1;

MySQL Error   : Incorrect table name 'mysite_database2.table_servusers
Error Number  : 1103

Thanks for your time again,
c4smok