/*************************************************************************** * Dolphin Smart Community Builder * ----------------- * begin : Mon Mar 23 2006 * copyright : (C) 2006 BoonEx Group * website : http://www.boonex.com/ * This file is part of Dolphin - Smart Community Builder * * Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License. * http://creativecommons.org/licenses/by/3.0/ * * Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. * See the Creative Commons Attribution 3.0 License for more details. * You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin, * see license.txt file; if not, write to marketing@boonex.com ***************************************************************************/ require_once( 'inc/header.inc.php' ); require_once( BX_DIRECTORY_PATH_INC . 'design.inc.php' ); require_once( BX_DIRECTORY_PATH_INC . 'profiles.inc.php' ); $_page['name_index'] = 60; $_page['header'] = _t("_Browse Profiles", $site['title']); $_page['header_text'] = _t("_Browse Profiles"); $_page['css_name'] = 'browse.css'; if ( !( $logged['admin'] = member_auth( 1, false ) ) ) if ( !( $logged['member'] = member_auth( 0, false ) ) ) if ( !( $logged['aff'] = member_auth( 2, false )) ) $logged['moderator'] = member_auth( 3, false ); // ================================================ parse variables ================ // ================================================================================= foreach( $_GET as $key => $value ) { if ( 'sex' == substr($key,0,3) ) $sex_sel .= $value . ','; else if ( 'country' == $key ) $country_sel = $value; else if ( 'age' == substr($key,0,3) ) { if ( 'start' == substr($key,4) ) $age_start_sel = (int)$value; if ( 'end' == substr($key,4) ) $age_end_sel = (int)$value; } else if ( 'online_only' == $key ) $onl_only = 'on'; else if ( 'photo_only' == $key ) $pic_only = 'on'; } // ================================================================================= // ================================================================================= $_ni = $_page['name_index']; $_page_cont[$_ni]['page_main_code'] = PageCompPageMainCode(); PageCode(); function PageCompPageMainCode() { global $sex_sel; global $country_sel; global $age_start_sel; global $age_end_sel; global $onl_only; global $pic_only; global $site; global $p_num; global $page; global $pages_num; global $p_per_page; global $page_first_p; global $pages_num; global $search_start_age; global $search_end_age; global $max_thumb_width; global $max_thumb_height; $query = "SELECT * FROM ProfilesDesc WHERE `name` IN ( 'Sex', 'Country')"; $res = db_res($query); while ( $arr = mysql_fetch_array( $res ) ) { switch ( $arr['name'] ) { case 'Sex' : $sex_sel = $sex_sel ? $sex_sel : 'male,female'; $sex_options = makeCheckbox( 'sex', $arr['extra'], $sex_sel ); break; case 'Country' : $country_sel = $country_sel ? $country_sel : 'all'; //getParam('default_country'); $country_options = makeList( 'country', '' , $arr['extra'], $country_sel, 'onchange="javascript: flagImage = document.getElementById(\'flagImageId\'); if (this.value == \'all\') {flagImage.src = \''. $site['images'] .'spacer.gif\';} else {flagImage.src = \''. $site['flags'] .'\' + this.value.toLowerCase() + \'.gif\';}"' ); break; default: break; } } $age_start_sel = $age_start_sel ? $age_start_sel : $search_start_age; $age_end_sel = $age_end_sel ? $age_end_sel : $search_end_age; $age_option_start = makeList( 'age_start', "{$search_start_age}-{$search_end_age}", '', $age_start_sel); $age_option_end = makeList( 'age_end', "{$search_start_age}-{$search_end_age}", '', $age_end_sel); $photo_only_check = ''; $online_only_check = ''; $country_def_flag = ($country_sel == 'all' ? $site['images'].'spacer.gif' : $site['flags'] . strtolower($country_sel).'.gif'); $ret = '
'; //==================================================================================================== //----------------------- search results ------------------------------------------------- //==================================================================================================== $page = (int)$_GET[page]; $p_per_page = (int)$_GET[p_per_page]; $aVar = array(30,60,90); if ( !$page ) $page = 1; if ( !$p_per_page ) $p_per_page = 30; $real_first_p = (int)($page - 1) * $p_per_page; $page_first_p = $real_first_p + 1; $temp_arr = explode(',', $sex_sel); foreach ( $temp_arr as $value ) if ( $value ) $sex_add .= " `Sex` = '$value' OR "; if ( $country_sel && 'all' != $country_sel ) $country_add = " `Country` = '{$country_sel}' AND "; if ( $age_start_sel ) $age_add .= " ( (YEAR(NOW()) - {$age_start_sel}) >= YEAR(`DateofBirth`) ) AND "; if ( $age_end_sel ) $age_add .= " ( (YEAR(NOW()) - {$age_end_sel}) <= YEAR(`DateofBirth`) ) AND "; if ( $pic_only ) $pic_add = " AND `Picture` = '1' "; if ( $onl_only ) $onl_add = " AND (LastNavTime > SUBDATE(NOW(), INTERVAL " . getParam( "member_online_time" ) . " MINUTE)) "; $sex_add = $sex_add ? '(' . $sex_add . ' 1=0 ) AND ' : ''; $age_add = $age_add ? '(' . $age_add . ' 1=1 )' : ''; $sql_add = $sex_add . $country_add . $age_add . $pic_add . $onl_add; $p_num = db_arr( "SELECT COUNT(*) FROM Profiles WHERE $sql_add AND `Status` = 'Active'" ); $p_num = $p_num[0]; $pages_num = ceil( $p_num / $p_per_page ); $profiles_list_query = "SELECT `ID`, `NickName`, `Sex`, `DateOfBirth` FROM Profiles WHERE $sql_add AND `status`='Active' ORDER BY `Picture` DESC LIMIT $real_first_p, $p_per_page;"; $function = ' $ret = \'?\'; foreach ( $_GET as $key => $value ) if ( $value ) $ret .= $key . \'=\' . $value . \'&\'; return $ret; '; $ret .= '