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'
MichelSwiss
Sorry Pimpa... I misunderstood your question :-(

My code is to display only profiles with profile photos...
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.03902006149292