Hall of Fame

[SonicSync]

How to add pagination to the script and remove the auto load of more videos on scroll in Browse, Most Viewed etc?

[PHPVibe A.]

Similar to http://www.phprevolution.com/forum/troubleshooting-issues/videos-showing-per-category/msg14281/#msg14281

[SonicSync]

Hi Alex,

I tried that, it works for Channels, but wont work for Browse and other functions fetching from com_videolist.php.

I need a working code like this:

Code Select Expand

//Count
$count = $cachedb->get_row("Select count(*) as nr from ".DB_PREFIX."videos where category in (select cat_id from ".DB_PREFIX."channels where cat_id='".$id ."' or child_of = '".$id ."')");

Above worked for channels, need something like that for the com_videolist.php.

regards

[SonicSync]

nevermind got it, here is the code, add this code to the com_videolist.php:

Code Select Expand

//Count
$count = $cachedb->get_row("Select count(*) as nr from ".DB_PREFIX."videos where pub > 0 ");

[PHPVibe A.]

$count information should be sent from the component, as it's not a global count.

[fourdeltaOne]

may suggest? how to hide blocks on the next page?

example:  originally displayed in the category
top video views in this section and then recently added videos.

how to make the transition to the next page last added video did not show hide top video views!

hide blocks in the next page pagination.

roughly tried this method 

Code Select Expand

if(pagination){

TOP VIDEOS VIEWS (block)


Recent Uploads Video (block)

} else {

Recent Uploads Video (block)

}

not turned!  please help! 

[PHPVibe A.]

I don't understand at all what you need.

[fourdeltaOne]

I'm sorry it's hard to explain because I do not know English and translate through Google 

overall I remade the channel latest videos.

1) disable infinite scrolling and  pagination included
2) in each category display the most viewed video on this category!

Question! . I need to hide the most viewed video in the transition to the next page!


site.com/channel/movie-trailers/6/ - front page

is displayed in the category
1) top most viewed video
2) latest videos

site.com/channel/movie-trailers/6/&p=2 - the second page, and so on

is displayed in the category
1) top most viewed video - in the following pages, hidden
2) latest videos

[PHPVibe A.]

Code Select Expand

If(this_page() <> 1) {
//No longer on first page
}

This?

[fourdeltaOne]

Thank you very much Alex!