vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Query to recount the number of images into profile albums (https://vborg.vbsupport.ru/showthread.php?t=267435)

tintin74 07-26-2011 08:02 AM
Query to recount the number of images into profile albums
 
Hello,

after importing image from a large photopost album into vbulletin profile album, I need to "recount" the total number images for each album but I don't know how to build a query to do this.

Vbulletin Maintenance doesn't have an option to do this.

Does anyboy could help me to build this query please?

Thank you in advance

tintin74 07-29-2011 12:02 PM
Uhm... is it impossible?

kh99 07-29-2011 01:07 PM
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).

Boofo 07-29-2011 01:10 PM
Admin CP -> Maintenance -> Update Counters -> Rebuild Recently Updated Albums

kh99 07-29-2011 01:18 PM
Quote:
Originally Posted by Boofo (Post 2226434)
Admin CP -> Maintenance -> Update Counters -> Rebuild Recently Updated Albums
That doesn't seem to update the count of pictures in each album, but maybe I misunderstood the question.

Boofo 07-29-2011 01:25 PM
Or I did.

tintin74 07-31-2011 07:17 AM
Quote:
Originally Posted by kh99 (Post 2226433)
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 ;-)

Quote:
Originally Posted by Boofo (Post 2226434)
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.

Boofo 07-31-2011 08:03 AM
My bad.


All times are GMT. The time now is 06:24 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01316 seconds
  • Memory Usage 1,743KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete