Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Daily Search Counts...

Sep 8, 2002, 12:34 PM

SeanP

User (456 posts)

Sep 8, 2002, 12:34 PM

Post #1 of 11

Shortcut

Daily Search Counts...

Is there an easy way to display the total search count for the day? I have the SearchLogger plugin installed, but I'm not sure if that info is stored anywhere else...

Sean

Sep 9, 2002, 3:12 AM

Andy

Veteran / Moderator (18441 posts)

Sep 9, 2002, 3:12 AM

Post #2 of 11

Shortcut

Re: [SeanP] Daily Search Counts... In reply to

Interesting idea...I may write a simple plugin to do this...possibly with the option to view stats for the last week or something. Did you want it for admin, or user side statistics?

Andy (mod)
andy@ultranerds.co.uk

Sep 9, 2002, 6:48 AM

SeanP

User (456 posts)

Sep 9, 2002, 6:48 AM

Post #3 of 11

Shortcut

Re: [Andy] Daily Search Counts... In reply to

I guess I wanted it for both. I want to know how many total searches I get in a day, and also have a tag off of the main page to display the count. For an example, go to http://www.searchhippo.com and look at the "Queries today" line at the bottom of the page...

Sean

Sep 9, 2002, 7:14 AM

Andy

Veteran / Moderator (18441 posts)

Sep 9, 2002, 7:14 AM

Post #4 of 11

Shortcut

Re: [SeanP] Daily Search Counts... In reply to

Ok, heres what I'm planning. Let me know what you think :p

+ Search Counts - daily, and last 7 days...
+ Top 10 search phrases (this is going to be an option, as it could take up a lot of space)
+ A tag that can be called, to show total search queries, weekly and daily...
+ An admin option, to show more stats...

What do you think? It will be tomorrow, or wednesday before I can start it though, as I have some other stuff I need to get completed first Smile

Andy (mod)
andy@ultranerds.co.uk

Sep 9, 2002, 7:18 AM

SeanP

User (456 posts)

Sep 9, 2002, 7:18 AM

Post #5 of 11

Shortcut

Re: [Andy] Daily Search Counts... In reply to

I think that would be excellent. Then we can all compare daily search totals and brag when we have a higher number then someone else. Laugh

Sean

Sep 9, 2002, 7:24 AM

Andy

Veteran / Moderator (18441 posts)

Sep 9, 2002, 7:24 AM

Post #6 of 11

Shortcut

Re: [SeanP] Daily Search Counts... In reply to

I'm just wondering though, should it be free? MAybe the original will be, until all bugs have been ironed out, and after that, say $15 for it?

Andy (mod)
andy@ultranerds.co.uk

Sep 9, 2002, 7:34 AM

SeanP

User (456 posts)

Sep 9, 2002, 7:34 AM

Post #7 of 11

Shortcut

Re: [Andy] Daily Search Counts... In reply to

Sounds fair to me...

Sep 9, 2002, 10:04 AM

pugdog

Veteran / Moderator (6956 posts)

Sep 9, 2002, 10:04 AM

Post #8 of 11

Shortcut

Re: [SeanP] Daily Search Counts... In reply to

Hi,

I thought I released some thing like this with mye top ten searchs.

In order to do it, it keeps tabs of daily searches, vs total searchs.

Search the FORUM if it's not in the DOWNLOADS area. There was a discussion about it not too long ago.

PUGDOG� Enterprises, Inc.

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

Sep 9, 2002, 10:14 AM

pugdog

Veteran / Moderator (6956 posts)

Sep 9, 2002, 10:14 AM

Post #9 of 11

Shortcut

Re: [pugdog] Daily Search Counts... In reply to

Try here http://www.gossamer-threads.com/...orum.cgi?post=175351

PUGDOG� Enterprises, Inc.

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

Sep 11, 2002, 6:59 AM

SeanP

User (456 posts)

Sep 11, 2002, 6:59 AM

Post #10 of 11

Shortcut

Re: [pugdog] Daily Search Counts... In reply to

I've already got that installed (thanks btw)... How do you display the daily total of searches on the home page?

Sean

Sep 21, 2002, 9:25 PM

SeanP

User (456 posts)

Sep 21, 2002, 9:25 PM

Post #11 of 11

Shortcut

Re: [pugdog] Daily Search Counts... In reply to

Here is a global to produce a daily search count:

daily_query_total =>

Code:
sub {  
my ($total) = $DB->table('SearchLogDaily')->select(['SUM(HitCount)'])->fetchrow_array;  

  if ($total < 1){ 
    $total = '0'; 
  } 

return $total;  
}

and then use <%daily_query_total%> in your template.