Help Needed

[ChrisBaktis]

Does anyone know a way to take the numerical value of a custom profile field of all the members and add them up and print it out?

[ChrisBaktis]

anyone?

[Marco van Herwaarden]

SELECT SUM(fieldx) from userfield

[ChrisBaktis]

Is there a way for this total to show on one of my pages on the site (home page for example)?

[Marco van Herwaarden]

On any vB powered page (script) you could add a:
$sum_userfield = $DB_site->query("SELECT SUM(fieldx) FROM " . TABLE_PREFIX . "userfield");
Now you can use $sum_userfield in your template or echo it out on another way.

[ChrisBaktis]

in a template would I just need to put '$sum_suerfield' where I want it to show up or do I need to use something like $post?

[Marco van Herwaarden]

If you make sure the above code is in the script that evaluate the template, and that it is executed before the template is called, then yes.

[ChrisBaktis]

Sorry to be a pain but yes to which one - using $sum_userfield by itself or using it like $post[sum_userfield] ?

My plans for now (while the board is smaller) to put this in the Navigational Bar - I will add your code to the global.php file. Can you tell me what I would need to use based on that info?

Anyone?

[Marco van Herwaarden]

Change that query to:
$sum_userfield = $DB_site->query_first("SELECT SUM(fieldx) as total FROM " . TABLE_PREFIX . "userfield");
Then use $sum_userfield[total] in your template.

[ChrisBaktis]

Thanks!

[ChrisBaktis]

Where in the global.php file can I put the above db query? seems no matter where I put it it messes up the page.

[Guest190829]

What do you mean by messing up the page? Did you put it in a plug-in or are you editing the actual file?

[ChrisBaktis]

I was editing the file - Im very new to 3.5.1 and not sure how to do it as a plug in.

[Guest190829]

Well I'm not really sure what your doing but you would put that code in global_start or global_complete. Please note that will run the query on every page...

[ChrisBaktis]

I really only want this on the forum home page.

So to do the plug in can use the: forumhome_start

and the only code I would need is to put the above code?

All im trying to do is take the total from a custom profile field that all the members have and print out the total on the forum home page. Maybe you can clarify what I need to do.

[tnguy3n]

change the query to:
$sum_userfield = $db->query_first("SELECT SUM(fieldx) as total FROM " . TABLE_PREFIX . "userfield");

I would use forumhome_complete rather than forumhome_start.

In FORUMHOME template, place $sum_userfield in wherever you want to show it.

[Marco van Herwaarden]

The above code is for vB3.0. For 3.5 you would need something like:
$sum_userfield = $vbulletin->db->query_first("SELECT SUM(fieldx) as total FROM " . TABLE_PREFIX . "userfield");

[ChrisBaktis]

works like a charm - thanks for all the help!