Troubleshooting vBulletin Problems Discuss sql and plugin in the vBulletinSetup Information forums; 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 . ...

[jackni]

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

[Michael Biddle]

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

[jackni]

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

[Michael Biddle]

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']
);

[jackni]

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

[Michael Biddle]

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

[Michael Biddle]

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]

[jackni]

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?

[Michael Biddle]

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

[jackni]

thankssss

[noppid]

Query first does the query and than puts the result in an array with mysql_fetch_array().

In your first example, mysql_query returns a mysql resource that you can grab the content of with mysql_fetch_array() and then access.

You should use the vB mysql wrapper when coding.

$vbulletin->db->query_first to get one row returned in an array.
$vbulletin->db->query_read to get multiple rows that you can then fetch and parse.
$vbulletin->db->query_write to write to tables.

[anuvenkatesh]

Hi i'm trying to do something similar.

Here is what i want to do...
i need to add a new field categoryid to the forum table.
Then i want to be able to use this categoryid (for each specific forum) in a plugin which will parse the contents of a page from another website of ours but needs this categoryid.


i tried the hook location 'global_start'
ob_start();
$categoryid = $foruminfo[categoryid];
include('[domainname]/API/ads.cfm?w=160&h=600&as=2&q=&f=0&categoryid=$catego ryid');
$includedphp = ob_get_contents();
ob_end_clean();

since $foruminfo[categoryid] doesn't print anything, how do i accomplish this.?