help with postbit / postbit_legacy upload stats hack

[Joe Pimms]

hello im haveing a problem with is code :

PHP Code:

$usernumUploads = $DB_site->query_first("select count(*) as `uploaded` from ".TABLE_PREFIX."attachment where userid={$bbuserinfo['userid']}"); 


here is the template mod:

PHP Code:

look for under postbit / postbit_legacy:
<div>
$vbphrase[posts]: $post[posts]
</div>

add under:

<div>
MY Files Uploaded: $usernumUploads
</div> 


what im wanting to do is display under postbit template the total number of attachments a user has uploaded to my site. now when when i run this i get it saying "Array" why is that ?

im wanting a real count not like the other user stats hacks on here please help

please see error of pic

thanks

[tgillespie]

<a href="http://us3.php.net/array" target="_blank">http://us3.php.net/array</a>

Count the values in the array.

[Marco van Herwaarden]

PHP Code:

MY Files Uploaded: $usernumUploads 


should be:

PHP Code:

MY Files Uploaded: $usernumUploads['uploaded'] 


[Joe Pimms]

Originally Posted by MarcoH64

PHP Code:

MY Files Uploaded: $usernumUploads 


should be:

PHP Code:

MY Files Uploaded: $usernumUploads['uploaded'] 


this did not work

[Colin F]

Originally Posted by Joe Pimms

this did not work

I'd have said the same as Marcoh64

[Zachery]

Where is that query being run?

What file?

[Joe Pimms]

this is being run on "functions_subscriptions.php" unless its the wrong file to edit ?

p.s.
sorry i was at work im now finished and im back now