''";
$result = cpg_db_query($query);
$i = 0;
if (mysql_num_rows($result)) {
if ($output) { starttable('100%', $lang_gallery_admin_menu['key_lnk']); }
cpg_db_query("TRUNCATE TABLE {$CONFIG['TABLE_DICT']}");
while ($row = mysql_fetch_assoc($result)) {
$keyArr = explode($CONFIG['keyword_separator'], $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 (!mysql_num_rows($result2)) {
$query = "INSERT INTO {$CONFIG['TABLE_DICT']} (keyword) VALUES ('$keyword')";
cpg_db_query($query);
if ($output) { echo '| ' . $keyword . ' |
'; }
$i++ ;
}
}
mysql_free_result($result2);
}
if ($output) { endtable(); }
mysql_free_result($result);
}
if ($output) {
echo "{$lang_editpics_php['new_keywords']}: $i
";
pagefooter_mini();
} else {
header("Location: $CPG_REFERER");
}
?>