how do i show the rep in the navigation bar?
i added to navbar template this

Reputation: $reputation

and i made this plugin

$query = "SELECT reputation FROM" . TABLE_PREFIX . "WHERE userid=" . $bbuserinfo[userid] . );
$reputation .= mysql_query($query);

but on the site it only says "Reputation: " and blank.
my plugin is hooked on navbits, did i get the right location? or did i mess up the sql thx

try using $vbulletin->db->query_read rather then mysql_query

--------------------

it still doesn't work, should the hook be on navbits or something else?

Now that I look at it, it looks like you left table out. Try:

$reputation = $vbulletin->db->query_read("
SELECT reputation
FROM" . TABLE_PREFIX . "user
WHERE userid=" . $bbuserinfo['userid']
);

--------------------

it still doesn't work, where should the hook location be?

I am not sure, I have not used any hook in the navbits before.

--------------------

Ok I got it. Put this in a plugin at global_start:

// Globalize Variables
global $vbulletin;

// Query It!
$reputation = $vbulletin->db->query_first("
SELECT reputation
FROM " . TABLE_PREFIX . "user
WHERE userid = '" . $vbulletin->userinfo['userid'] . "'
");

// Use $reputation[reputation] in your templates.

And use this in your template:

$reputation[reputation]

--------------------

thanks it works, but can you tell me what -> means, how query_first differs from query_read and why use $reputation[reputation] instead just $reputation?

I use -> because it has to do with vbulletin operations. query_read is more for more then 1 field being pulled. and I use it like that because it is a query_first

--------------------

thankssss