Help Needed

[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.

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.

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:

PHP Code:

$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:

PHP Code:

$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!