''";
$result = cpg_db_query($query);
$i = 0;
if ($result->numRows()) {
if ($output) { starttable('100%', $lang_gallery_admin_menu['key_lnk']); }
cpg_db_query("TRUNCATE TABLE {$CONFIG['TABLE_DICT']}");
while ($row = $result->fetchAssoc()) {
$keyArr = explode($CONFIG['keyword_separator'], html_entity_decode($row['keywords']));
foreach ($keyArr as $keyword) {
$keyword = trim($keyword);
if (empty($keyword)) {
continue;
}
$query = "SELECT null FROM {$CONFIG['TABLE_DICT']} WHERE keyword = '$keyword'";
$result2 = cpg_db_query($query);
if (!$result2->numRows(true)) {
$query = "INSERT INTO {$CONFIG['TABLE_DICT']} (keyword) VALUES ('$keyword')";
cpg_db_query($query);
if ($output) { echo '| ' . $keyword . ' |
'; }
$i++ ;
}
}
}
if ($output) { endtable(); }
}
$result->free();
if ($output) {
echo "{$lang_editpics_php['new_keywords']}: $i
";
pagefooter_mini();
} else {
header("Location: $CPG_REFERER");
}
//EOF