Hi-

I'm trying to create a Global Tag that would allow me to show users the total numer of hits they have for all of their links. I currently use the following global to show the total number of hits for my site:

total_hits =>

sub { my ($total) = $DB->table('Links')->select(['SUM(Hits)'])->fetchrow_array; return $total;}

I can't seem to modify this correctly for a new global tag called total_user_hits to get it to show the total number of hits for a specific user that is logged in. Basically, I just want it to show the SUM(Hits) WHERE Username='---Currently Logged in Username--'. Does anyone know the proper syntax to do this in a global? It would be much appreciated!

-FrankM

sub { my ($total) = $DB->table('Links')->select({'Linkowner => $Linkowner'}, ['SUM(Hits)'])->fetchrow_array; return $total;}

This assumes you know how to get $LinkOwner or whatever the var is

Thanks for the reply. Somehow, I couldn't get this to work. Do you know how I would get the $LinkOwner var? I would only be using this global tag on template pages when the user is logged in.

-FrankM

maybe via $USER->$LinkOwner?

Thanks again...

I tried that and various other combinations, but I couldn't get it to work. It's probably something really simple, but I just can't seem to get it to work...

-Frank M.

Try:


In your template you'd use:

<%MyGlobal(Username)%>

...where Username is the tag used to display the username of the logged in user.

Thanks very much for your help. I tried the code you provided for the global which I named: user_hits. But when I put the tag: <%user_hits%> on a page it doesn't return any value for the total number of hits. (It does show a proper value for the tag: <%Username%>, though). I wonder what the problem might be? When I log in under the username, the user definitely has a number of validated links that have Hits recorded for them.

-FrankM

Try:

<%user_hits($Username)%>

Thanks very much! That worked great. I should have followed your instructions more closely the first time.

-FrankM

You're getting pretty quick with those one-liners ;)


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

>>
You're getting pretty quick with those one-liners ;)
<<

They are fun :)