Help with DB query for postbit.

[tinycg]

I'm attempting to add my members Xbox Live Gamerscore as pulled by the gXboxlive mod which stores the gamerscore in the gboxlive.score table with the userid the same as user.userid.

So this was my thinking:

PHP Code:

$gmscore = $db->query("SELECT " . TABLE_PREFIX . "gxboxlive.*, " . TABLE_PREFIX . "gxboxlive.score AS score, FROM " . TABLE_PREFIX . "gxboxlive WHERE " . TABLE_PREFIX . "gxboxlive.userid = " . $vbulletin->userinfo['userid'] . " LIMIT 1");
$player = $db->fetch_array ($gmscore); 


I realize now that by looking at some other things that

PHP Code:

$vbulletin->userinfo['userid'] 


Is bringing up the logged in user and not the post's userid, so that's part of the problem, does anyone know the right way I should be querying this in vB?

I've been up late on this, but could use some help with it, I'm naive with vb's code, but am trying to produce a query to pull the score based on the userid, then add it to the postbit with

PHP Code:

$player[score] 


I had the query seemingly working with an odd join based on the gboxlive code but it still wasn't printing the score out in the template.