1<?php 2/************************* 3 Coppermine Photo Gallery 4 ************************ 5 Copyright (c) 2003-2016 Coppermine Dev Team 6 v1.0 originally written by Gregory Demar 7 8 This program is free software; you can redistribute it and/or modify 9 it under the terms of the GNU General Public License version 3 10 as published by the Free Software Foundation. 11 12 ******************************************** 13 Coppermine version: 1.6.03 14 $HeadURL$ 15**********************************************/ 16 17if (!defined('IN_COPPERMINE')) die('Not in Coppermine...'); 18 19// ADDED QUICK KEYWORDS FUNCTIONALITY 20 21$icon_array['edit'] = cpg_fetch_icon('ok', 2); 22 23get_meta_album_set(0); 24$result = cpg_db_query("SELECT keywords FROM {$CONFIG['TABLE_PICTURES']} AS r $RESTRICTEDWHERE AND keywords <> '' $ALBUM_SET"); 25if ($result->numRows()) { 26 27 // Grab all keywords 28 print '<br />'; 29 starttable("100%", $lang_search_php['keyword_list_title']); 30 31 32 // Find unique keywords 33 $keywords_array = array(); 34 $keyword_count = array(); 35 36 while (list($keywords) = $result->fetchRow()) { 37 $array = explode($CONFIG['keyword_separator'], html_entity_decode($keywords)); 38 39 foreach($array as $word) { 40 if (!in_array($word = utf_strtolower($word), $keywords_array)) { 41 $keywords_array[] = $word; 42 $keyword_count[$word] = 1; 43 } else { 44 $keyword_count[$word]++; 45 } 46 } 47 } 48 $result->free(); 49 50 // Sort selected keywords 51 sort($keywords_array); 52 $count = count($keywords_array); 53 54 $maxQuantity = max($keyword_count); 55 $minQuantity = min($keyword_count); 56 57 $spread = $maxQuantity - $minQuantity; 58 59 //spread should be greater than zero 60 if ($spread == 0) { 61 $spread = 1; 62 } 63 64 $step = (25 - 10) / sqrt($spread); 65 66 // Result to table 67 echo '<tr><td class="tableb">'; 68 for ($i = 0; $i < $count; $i++) { 69 if ($keywords_array[$i]) { // Eliminates Null Keywords 70 71 $fontSize = round(10 + sqrt($keyword_count[$keywords_array[$i]] - $minQuantity) * $step); 72 $keyword_param = urlencode($keywords_array[$i]); 73 echo '<a href="thumbnails.php?album=search&keywords=on&search='.$keyword_param.'" style="font-size: '.$fontSize.'px;">'.htmlspecialchars($keywords_array[$i]).'</a>'; 74 if ($i<$count-1) { // Don't keep space after last keyword 75 echo ' '; 76 } 77 } 78 } 79 echo '</td></tr>'; 80 if (GALLERY_ADMIN_MODE == true) { 81 $url = basename($CPG_PHP_SELF); 82 if ($url != 'keywordmgr.php'){ 83 echo '<tr><td class="tableb" align="center">'; 84 echo '<a href="keywordmgr.php" class="button">' . $icon_array['edit'] . $lang_search_php['edit_keywords'] . '</a>'; 85 echo '</td></tr>'; 86 } 87 } else { 88 echo '<tr><td class="tableb" align="center">'; 89 echo $lang_search_php['keyword_msg']; 90 echo '</td></tr>'; 91 } 92 93 endtable(); 94} 95//EOF