[MOD] Search, Tag, Word Cloud
Posted by essexboyracer
|
Re: [MOD] Search, Tag, Word Cloud September 06, 2007 01:52AM |
A tag cloud could be verry verry cool to show the most search terms ! Thanks a lot. I'll try your mod as soon as I will finish my Sphider's installation !
ps : Almost all, keep your mod updated and compatible with futures Sphider upgrades please
...
ps : Almost all, keep your mod updated and compatible with futures Sphider upgrades please
...
|
Re: [MOD] Search, Tag, Word Cloud July 19, 2008 06:53PM |
ajaysangha, insert your table prefix, in settings/database.php
Example
With prefix search_)
$query = "SELECT query AS tag, COUNT(*) AS quantity
FROM db248038120.query_log
WHERE results > 0
GROUP BY query
ORDER BY query ASC
LIMIT 10";
Try
$query = "SELECT query AS tag, COUNT(*) AS quantity
FROM db248038120.search_query_log
WHERE results > 0
GROUP BY query
ORDER BY query ASC
LIMIT 10";
Example
With prefix search_)
$query = "SELECT query AS tag, COUNT(*) AS quantity
FROM db248038120.query_log
WHERE results > 0
GROUP BY query
ORDER BY query ASC
LIMIT 10";
Try
$query = "SELECT query AS tag, COUNT(*) AS quantity
FROM db248038120.search_query_log
WHERE results > 0
GROUP BY query
ORDER BY query ASC
LIMIT 10";
|
Re: [MOD] Search, Tag, Word Cloud December 11, 2008 12:35PM |
Hi all,
modified the TS-post a bit, to take advantage of the predefined variables in Sphider.
Simply create a file called cloud.php and copy/paste the following:
Just upload the file to the main-map of Sphider.
Now edit the very bottom of search.php like so:
Original:
And Enjoy the SearchCloud !
Hope it helps anyone.
Grts
Edited 1 time(s). Last edit at 12/11/2008 12:58PM by OrBeX.
modified the TS-post a bit, to take advantage of the predefined variables in Sphider.
Simply create a file called cloud.php and copy/paste the following:
Quote
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[www.w3.org];
<html xmlns="[www.w3.org];
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>SearchCloud</title>
<style>
#tags {
float: none;
width: 220px;
margin: 10px 0px;
padding: 10px;
background:#ececec;
color:#333;
border: 1px dashed #cccccc;
text-align: justify;
}
#tags .title {
font-family:arial;
font-size:16px;
font-weight:bold;
background-color: transparent;
padding: 4px 4px;
color:#808080;
}
#tags a {
color:#39c;
background-color: transparent;
padding: 2px 4px;
white-space: nowrap;
text-decoration: none;
font-family:arial;
}
#tags a:hover {
color:#39c;
background: silver;
text-decoration: none;
}
</style>
</head>
<body>
<div id="tags">
<div class="title">Populaire Zoektermen</div>
<?php
$include_dir = "./include";
$template_dir = "./templates";
$settings_dir = "./settings";
$language_dir = "./languages";
require_once("$settings_dir/database.php";
require_once("$language_dir/en-language.php"
require_once("$include_dir/searchfuncs.php"
require_once("$include_dir/categoryfuncs.php"
include "$settings_dir/conf.php";
// Snippet taken from [prism-perfect.net]
// include "/path/to/public_html/search/settings/database.php";
// include "/path/to/public_html/search/settings/conf.php";
// In the SQL below, change these three things:
// thing is the column name that you are making a tag cloud for
// id is the primary key
// my_table is the name of the database table
// added by essexboyracer:
// dont return zero result words and limit the cloud to 10 phrases
$query = "SELECT query AS tag, COUNT(*) AS quantity
FROM ".$mysql_table_prefix."query_log
WHERE results > 0
GROUP BY query
ORDER BY query ASC
LIMIT 10";
$result = mysql_query($query) or die(mysql_error());
// here we loop through the results and put them into a simple array:
// $tag['thing1'] = 12;
// $tag['thing2'] = 25;
// etc. so we can use all the nifty array functions
// to calculate the font-size of each tag
while ($row = mysql_fetch_array($result)) {
$tags[$row['tag']] = $row['quantity'];
}
// change these font sizes if you will
$max_size = 30; // max font size in %
$min_size = 11; // min font size in %
// get the largest and smallest array values
$max_qty = max(array_values($tags));
$min_qty = min(array_values($tags));
// find the range of values
$spread = $max_qty - $min_qty;
if (0 == $spread) { // we don't want to divide by zero
$spread = 1;
}
// determine the font-size increment
// this is the increase per tag quantity (times used)
$step = ($max_size - $min_size)/($spread);
// loop through our tag array
foreach ($tags as $key => $value) {
// calculate CSS font-size
// find the $value in excess of $min_qty
// multiply by the font-size increment ($size)
// and add the $min_size set above
$size = $min_size + (($value - $min_qty) * $step);
// uncomment if you want sizes in whole %:
// $size = ceil($size);
// you'll need to put the link destination in place of the #
// (assuming your tag links to some sort of details page)
echo '<a href="./search.php?query='.$key.'&search=1" style="font-size: '.$size.'px"';
// perhaps adjust this title attribute for the things that are tagged
echo ' title="'.$value.' things tagged with '.$key.'"';
echo '>'.$key.'</a> ';
// notice the space at the end of the link
}
?>
</div>
</body>
</html>
Just upload the file to the main-map of Sphider.
Now edit the very bottom of search.php like so:
Original:
Change to this:Quote
break;
}
include "$template_dir/$template/footer.html";
?>
Quote
break;
}
echo '<div align=center>';
include "cloud.php";
echo '</div>';
include "$template_dir/$template/footer.html";
?>
And Enjoy the SearchCloud !
Hope it helps anyone.
Grts
Edited 1 time(s). Last edit at 12/11/2008 12:58PM by OrBeX.
|
Re: [MOD] Search, Tag, Word Cloud November 24, 2011 10:37PM |
Does anybody have another tag cloud? Have you tested this tag cloud? It works for some number of words but then when you search a word several times, it doesn't even show up
|
Re: [MOD] Search, Tag, Word Cloud November 28, 2011 08:07PM |
test-sphider Wrote:
-------------------------------------------------------
> Does anybody have another tag cloud? Have you
> tested this tag cloud? It works for some number of
> words but then when you search a word several
> times, it doesn't even show up
Been using it for years without any problems. Words only show up in the cloud if there are search results. If a word isn't indexed it won't show up.
-------------------------------------------------------
> Does anybody have another tag cloud? Have you
> tested this tag cloud? It works for some number of
> words but then when you search a word several
> times, it doesn't even show up
Been using it for years without any problems. Words only show up in the cloud if there are search results. If a word isn't indexed it won't show up.
|
Re: [MOD] Search, Tag, Word Cloud November 29, 2011 03:37PM |
Convergence Wrote:
-------------------------------------------------------
> test-sphider Wrote:
> --------------------------------------------------
> -----
> > Does anybody have another tag cloud? Have you
> > tested this tag cloud? It works for some number
> of
> > words but then when you search a word several
> > times, it doesn't even show up
>
> Been using it for years without any problems.
> Words only show up in the cloud if there are
> search results. If a word isn't indexed it won't
> show up.
I guess the problem is with non-english characters. Whem I search for a word that belongs to latin5 charset, it doesn't show up..
-------------------------------------------------------
> test-sphider Wrote:
> --------------------------------------------------
> -----
> > Does anybody have another tag cloud? Have you
> > tested this tag cloud? It works for some number
> of
> > words but then when you search a word several
> > times, it doesn't even show up
>
> Been using it for years without any problems.
> Words only show up in the cloud if there are
> search results. If a word isn't indexed it won't
> show up.
I guess the problem is with non-english characters. Whem I search for a word that belongs to latin5 charset, it doesn't show up..
Sorry, only registered users may post in this forum.