Code: Select all
<?
require('../includes/prepare.php');
if ($settings['last_update_number'] < 49) die("This script is for version 49 and up");
$q = db_query("SELECT id from rot_groups");
while ($d = db_fetch_assoc($q)) {
echo "Selecting tags for group {$d['id']} " . PHP_EOL;
$tag_str = '';
$q_best_tags = db_query("SELECT t.tag_name, count(*) as total_tag_hits from rot_gal2tag as g2t
JOIN rot_tags as t on t.tag_id = g2t.tag_id
where g2t.gallery_md5 IN (SELECT gallery_md5 FROM rot_galleries where id IN (SELECT id FROM rot_gal2group WHERE group_id = {$d['id']}) )
group by g2t.tag_id order by total_tag_hits desc
limit 5 ");
while ($tag_d = db_fetch_assoc($q_best_tags)) {
$tag_str .= $tag_d['tag_name'] . ' ';
}
if ($tag_str) {
db_query("UPDATE rot_groups_data SET group_custom_var1 = '".addslashes($tag_str)."' WHERE group_id = '{$d['id']}' ");
echo "Setting tags " . PHP_EOL;
}
}