Query to recount the number of images into profile albums

[kh99]

It might be able to be done with a query, I'm not sure. But I put together this small script that should do it:

PHP Code:

<?php

error_reporting(E_ALL ^ E_NOTICE ^ 8192);

require('./global.php');

// Rebuild counts for all albums
$album_results = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "album");

$albums = array();

while ($album = $db->fetch_array($album_results))
    $albums[] = $album;

$db->free_result($album_results);

// update all albums that pictures were moved to
foreach ($albums as $album)
{
    $albumdata =& datamanager_init('Album', $vbulletin, ERRTYPE_SILENT);
    $albumdata->set_existing($album);

    $albumdata->rebuild_counts();
    $albumdata->save();
    unset($albumdata);
}
    
exit('Done');

Put that in a php file, upload it your forum directory, and point your browser to it. (Then probably delete it from the server).