Featured Photos box but no photos?

[TL408]

Can someone pleaes help me figure out why there are no photos under my "Featured Photos" box? Below is the link to my forum. Your help is greatly appreciated.

http://www.houstonstreetscene.com/forum/index.php

-Tuan

[Chuck S]

The inc_features.php file does not pull photos from the members gallery it pulls from other cats you set up

If you want to show member gallery photos you would need to open inc_features.php and remove this from the queries

AND cat != 500

[TL408]

Under the inc_features.php file, this is what I removed (in bold) but it still doesn't work.

http://www.houstonstreetscene.com/forum/


switch ($q_switch) {
case "most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.height,p.width,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY views DESC";
break;

case "latest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.height,p.width,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY date DESC";
break;

default:
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.height,p.width,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY RAND()";

[Chuck S]

Well check your category permissions

http://www.reeftalk.com/forums

[TL408]

This is what it looks like. I've made sure everyone able to view the pictures in that category. But still doesn't work.

http://img260.echo.cx/img260/711/category6gg.jpg

[Chuck S]

The ViewPerms are pretty specific check every cat and make sure all groups have view permissions