Marc,
I am using version 1.0.4
I did as you said and posted the problem over at phpBB.com.
The thread can be viewed here:
http://www.phpbb.com/community/viewtopi ... &t=1865025
I have rebuilt my search index and it has made no difference. I am using Fulltext native as my search backend as it says 'Wordgraph does not work when fulltext mysql is selected as the search backend' on the ACP Wordgraph settings.
I have left my Wordgraph in place so you can see for yourself what the problem is.
http://www.border-forums.com
Here is my wordgraph.php:
<?php
/**
*
* @package - Board3portal
* @version $Id: wordgraph.php 523 2009-08-27 21:41:08Z christian_n $
* @copyright (c) kevin / saint (
www.board3.de/ ), (c) Ice, (c) nickvergessen (
www.flying-bits.org/ ), (c) redbull254 (
www.digitalfotografie-foren.de ), (c) Christian_N (
www.phpbb-projekt.de )
* @based on: phpBB3 Portal by Sevdin Filiz,
www.phpbb3portal.com
* @license
http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
if (!defined('IN_PHPBB') || !defined('IN_PORTAL'))
{
exit;
}
$words_array = array();
// Get words and number of those words
$sql = 'SELECT l.word_text, COUNT(*) AS word_count
FROM ' . SEARCH_WORDLIST_TABLE . ' AS l, ' . SEARCH_WORDMATCH_TABLE . ' AS m
WHERE m.word_id = l.word_id
GROUP BY m.word_id
ORDER BY word_count DESC';
$result = $db->sql_query_limit($sql, $portal_config['portal_wordgraph_max_words']);
while ($row = $db->sql_fetchrow($result))
{
$word = strtolower($row['word_text']);
$words_array[$word] = $row['word_count'];
}
$db->sql_freeresult($result);
$minimum = 1000000;
$maximum = -1000000;
foreach ( array_keys($words_array) as $word )
{
if ( $words_array[$word] > $maximum )
{
$maximum = $words_array[$word];
}
if ( $words_array[$word] < $minimum )
{
$minimum = $words_array[$word];
}
}
// ratio
$ratio = $portal_config['portal_wordgraph_ratio'] / ( $maximum - $minimum +1);
$words = array_keys($words_array);
sort($words);
foreach ( $words as $word )
{
$template->assign_block_vars('wordgraph', array(
'WORD' => ($portal_config['portal_wordgraph_word_counts']) ? $word . '(' . $words_array[$word] . ')' : $word,
'WORD_FONT_SIZE' => (int) ( 9 + ( $words_array[$word] * $ratio ) ),
'WORD_SEARCH_URL' => append_sid("{$phpbb_root_path}search.$phpEx", 'keywords=' . urlencode($word)),
));
}
$template->assign_vars(array(
'S_DISPLAY_WORDGRAPH' => true,
'L_WORDGRAPH' => $user->lang['WORDGRAPH'],
)
);
?>
Regards
fujcube
