Hall of Fame

[OliverJ]

Hey, i want to exclude some Channel/categroy from my Homepage Block newest Videos ,how can i do this ?
Because i dont, want that my Visitors see this videos

I use PHPVibe 3.3

[PHPVibe A.]

Give me the categorie(s) id(s) for exclusion so I can make you the code.

[OliverJ]

Hey do you mean this : /channel/anime/2/
Category ID : 2 (Mysql)

[PHPVibe A.]

Yes.

tpl/main/home.php:

(newest block example)

change:

Code Select Expand

else:
$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id WHERE ".DB_PREFIX."videos.views >= 0 and pub > 0 $c_add ORDER BY ".DB_PREFIX."videos.id DESC ".this_offset($limit);
endif;

to

Code Select Expand

else:
$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id WHERE ".DB_PREFIX."videos.views >= 0 and pub > 0 AND category <> 2 $c_add ORDER BY ".DB_PREFIX."videos.id DESC ".this_offset($limit);
endif;

Notice

Code Select Expand

AND category <>

you can add it the same way to the other blocks.