<?php

define('IN_COPPERMINE', true);

require('include/init.inc.php');

global $CONFIG;

$query = cpg_db_query("ALTER TABLE {$CONFIG['TABLE_ALBUMS']} CHANGE COLUMN pic_count file_count INTEGER  NOT NULL DEFAULT 0, ADD COLUMN last_pid INT(11) NOT NULL AFTER thumb");
$query = cpg_db_query("ALTER TABLE {$CONFIG['TABLE_CATEGORIES']} ADD COLUMN theme VARCHAR(255) AFTER stat_uptodate");

$sql = "SELECT aid,COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} GROUP BY aid";
$result = cpg_db_query($sql);
$tmp = cpg_db_fetch_rowset($result);
foreach($tmp as $tmp2) {
	$sql2 = "SELECT pid,ctime FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = {$tmp2["aid"]} ORDER BY ctime DESC LIMIT 1";
	$result2 = cpg_db_query($sql2);
	$tmp3 = cpg_db_fetch_rowset($result2);
	$query = cpg_db_query("UPDATE {$CONFIG['TABLE_ALBUMS']} SET file_count = {$tmp2["COUNT(*)"]}, last_addition = \"" . date("Y-m-d H:m:s", $tmp3[0]["ctime"]) . "\", last_pid = {$tmp3[0]["pid"]} WHERE aid = {$tmp2["aid"]}");
}

echo "Done !!!";
?>