$userinf = getProfileInfo($userid); $usersex = $userinf['Sex']; $aDefFields = array( 'ID', 'NickName', 'Couple', 'Sex' ); $sCode = ''; $iOnlineTime = (int)getParam( "member_online_time" ); //main fields $sqlMainFields = ""; foreach ($aDefFields as $iKey => $sValue) $sqlMainFields .= "`Profiles`. `$sValue`, "; $sqlMainFields .= "if(`DateLastNav` > SUBDATE(NOW(), INTERVAL $iOnlineTime MINUTE ), 1, 0) AS `is_online`"; $sqlOrder = ""; if($usersex == "female"){ // possible conditions $sqlCondition = "WHERE `Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`) and ( `Profiles`.`Sex` = 'male')"; $aParams = array(); if (is_array($aParams)) { foreach ($aParams as $sField => $sValue) $sqlCondition .= " AND `Profiles`.`$sField` = '$sValue'"; } $sqlCondition .= " AND `Profiles`.`DateLastNav` > SUBDATE(NOW(), INTERVAL ".$iOnlineTime." MINUTE)"; $sqlOrder = " ORDER BY RAND()";} else{ // possible conditions $sqlCondition = "WHERE `Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`) and ( `Profiles`.`Sex` = 'female')"; $aParams = array(); if (is_array($aParams)) { foreach ($aParams as $sField => $sValue) $sqlCondition .= " AND `Profiles`.`$sField` = '$sValue'"; } $sqlCondition .= " AND `Profiles`.`DateLastNav` > SUBDATE(NOW(), INTERVAL ".$iOnlineTime." MINUTE)"; $sqlOrder = " ORDER BY RAND()"; } if (empty($sqlLJoin)) $sqlLJoin = ''; $iCount = (int)db_value("SELECT COUNT(`Profiles`.`ID`) FROM `Profiles` $sqlLJoin $sqlCondition"); $aData = array(); $sqlQuery = "SELECT " . $sqlMainFields . " FROM `Profiles` $sqlLJoin $sqlCondition $sqlOrder LIMIT 10"; $rData = db_res($sqlQuery); if ($iCount) { $aOnline = $aTmplVars = array(); while ($aData = mysql_fetch_assoc($rData)) { $aOnline['is_online'] = $aData['is_online']; $aTmplVars[] = array( 'thumbnail' => get_member_thumbnail($aData['ID'], 'none', true, 'visitor', $aOnline) ); } $sCode = $GLOBALS['oSysTemplate']->parseHtmlByName('members_list.html', array( 'bx_repeat:list' => $aTmplVars )); } else { $sCode = MsgBox(_t("_Empty")); } echo $sCode;