Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

top 5 search terms global

(Page 2 of 2)
> >
Quote Reply
Re: [waxxie] top 5 search terms global In reply to
Hi, Rik;

What was the global you used to get the top 5 search terms?

I've had the same problem.Tongue
Quote Reply
Re: [webslicer] top 5 search terms global In reply to
I see the problem now.

Change:

||

to

:
Quote Reply
Re: [webslicer] top 5 search terms global In reply to
Hi webslicer, I picked it up somewhere on the forum but can't find it anymore :P

Here it is, I copied it from my global section:

Code:
sub { my $db = $DB->table('SearchLog');
my $x = 5;
my $output;
$db->select_options("ORDER BY HitCount DESC", "LIMIT $x");
my $sth = $db->select('Term');




while (my $res = $sth->fetchrow_hashref) {
$output .= qq|<a href="$CFG->{db_cgi_url}/search.cgi?query=$res->{Term}">$res->{Term}</a><br>|;}




return $output;

}


Regards, Rik
Quote Reply
Re: [waxxie] top 5 search terms global In reply to
I don't have this table called "SearchLog" in the mysql database. I am using linksql 2.1.2
Quote Reply
Re: [gundamz] top 5 search terms global In reply to
You need the searchlogger free plugin. It is available at no charge, installs easily and quickly.

Go to the links admin - plugins - and search for the script.
Quote Reply
Re: [gundamz] top 5 search terms global In reply to
If it's the advanced logger, you'll have to search the forums. I made a whole bunch of mods to the original program, but posted it in the forum about 2 years ago, not the plugins area. There are a few threads about it.

see 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.
Quote Reply
Re: [pugdog] top 5 search terms global In reply to
Hi

I am using G Link 3.0.4

I made the Global:
top_search_terms

And in the search_results.html template, I added:
<%top_search_terms%>

I rebuild, and made a search, and the following error es showing:

A fatal error has occured:

GT::SQL (1816): File '/home/myweb.com/cgi/admin/defs/glinks_SearchLog.def' does not exist or the permissions are set incorrectly at (eval 40) line 5.

Please enable debugging in setup for more details.


What is missing?


Thanks
Quote Reply
Re: [tenoch] top 5 search terms global In reply to
You have to install the search logger for it to work. The plugin is available from the download area.

I'll have the updated version, my "advanced" version available along with the other plugins I'm fixing up.

It gives you some extra options on the search page, and lets you plug in several "top" keys. The major difference between my version and the one GT released, is that I track daily as well as total searches.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] top 5 search terms global In reply to
Thank You pugdog

Where can I download your advanced version?

thanks
Quote Reply
Re: [tenoch] top 5 search terms global In reply to
Hi,

Sorry for the delay here.

I'm not sure where it can be downloaded <G>

I have to maybe upload the current GL3 version, although I sort of remember doing that before the holidays.

I haven't changed it since before thanksgiving.

I'll make sure it's available from somewhere today or tomorrow.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [katabd] top 5 search terms global In reply to
What code and tag works with Gossamer Links 3.3.0?
http://www.hopeforyou.com

Quote Reply
Re: [HopeForYou] top 5 search terms global In reply to
You REALLY should check out ULTRAGlobals. Its got the answer to pretty much all the questions you've just asked.

Last_Searched_Words()
Top_Search_Words()

Its linked in my signature, if you don't alread have it.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
> >