Hall of Fame

[vingar]

Hi @ll,  i have a problem, when user publish a video and later remove the video,  totals video count for user not change. Solutions?

[PHPVibe A.]

Hi, did you clear site cache?

[vingar]

yes, but the problem not resolved.
if you try register to http://www.videoscriptdemo.com/   add a video and later remove the video.
Total count from  http: //xxx.xxx.xxx/me not change.
is a PHPVIBE BUG?

[vingar]

up 

[PHPVibe A.]

Don't bump threads, you'll just get an later answer, since I see and answer them chronologically by last reply.

I don't see an issue on a first look, it's counts them by query in profile.php

Code Select Expand

<?php 
$vd = $cachedb->get_row("SELECT count(*) as nr FROM ".DB_PREFIX."videos where user_id='".$profile->id."'");
$vvd = $cachedb->get_row("SELECT sum(views) as nr FROM ".DB_PREFIX."videos where user_id='".$profile->id."'");
$ad = $cachedb->get_row("SELECT count(*) as nr FROM ".DB_PREFIX."activity where user='".$profile->id."'");
?>

The only thing is that the query is cached, not real time.