How to not display on homepage not active photo?

In your file templates/tmpl_xxx/scripts/index.php look for an SQL query like that:

$featured_res = db_res( "SELECT `Profiles`.`ID`, `Pic_0_addon`, `ProfileType`, `NickName`, `Headline`, `Sex`, `Country`, `DateOfBirth`, `DateOfBirth2` FROM `Profiles` WHERE `Status` = 'Active' AND `Featured` = '1' ORDER BY RAND() LIMIT $feature_num" );

and change it to:

$featured_res = db_res( "SELECT `Profiles`.`ID`, `Pic_0_addon`, `ProfileType`, `NickName`, `Headline`, `Sex`, `Country`, `DateOfBirth`, see more `DateOfBirth2` FROM `Profiles` WHERE `Status` = 'Active' AND `Featured` = '1' <b>AND `Picture` = '1'</b> ORDER BY RAND() LIMIT $feature_num" );

You can add this code - AND `Picture` = '1' - to other SQL queries, depends of your needs...

thk's a lot :O)

My solution is another for more security:

on file

inc/shared.inc.php

before

$aNum = db_arr( "SELECT COUNT(`sharePhotoFiles`.`medID`) $sqlFrom $sqlWhere" );
$aNum = db_arr( "SELECT COUNT(`RayMovieFiles`.`ID`) $sqlFrom $sqlWhere" );
$aNum = db_arr( "SELECT COUNT(`RayMusicFiles`.`ID`) $sqlFrom $sqlWhere" );

add

if ($sqlWhere=="") $sqlWhere = " WHERE `Approved`='true' ";

and add in query viewPhoto.php add: AND `sharePhotoFiles`.`Approved`='true'
and see more add in query viewMusic.php add: AND `RayMusicFiles`.`Approved`='true'
and add in query viewVideo.php add: AND `RayMovieFiles`.`Approved`='true'