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&amp;keywords=on&amp;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