Query to recount the number of images into profile albums

[tintin74]

Originally Posted by 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).

Great! Thank you very much kh99! It solve the problem. This is the end of my nightmare ;-)

Originally Posted by Boofo

Admin CP -> Maintenance -> Update Counters -> Rebuild Recently Updated Albums

No Boofo, this process doesn't count the album profile images. I hope It will be added in the future release by vbulletin team.