if you have many files, then you can use this script to not send tens or hundreds of queries manually.
[CODE=php]$existing_album_id = 'YOUR existing ALBUM ID';
$dbh = new PDO('mysql:host=localhost;dbname=db_name', 'db_username', 'db_password');
foreach($dbh->query('SELECT `album_id` FROM `xf_mg_album`') as $row) {
$albumarr[] = $row[0];
}
foreach($dbh->query('SELECT `album_id` FROM `xf_mg_media_item`') as $row) {
if ($row[0] != 0) {
$mediaarr[] = $row[0];
}
}
foreach(array_unique($mediaarr) as $ID) {
if (!in_array($ID, $albumarr)) {
echo $ID . '<br />';
$stmt = $dbh->prepare('UPDATE `xf_mg_media_item` SET `album_id` = '.$existing_album_id.' WHERE `album_id` ='.$ID);
$stmt->execute();
}
}
$dbh = null;
[/CODE]
