/** * page show participants function * @return HTML presentation of data */ function PageSDatingShowParticipants() { global $site; global $oTemplConfig; $sYOC = _t('_y/o'); $sRetHtml = ''; $sEventParticipantsC = _t('_Event participants'); $sListOfParticipantsC = _t('_List') . ' ' . _t('_of') . ' ' . _t('_Participants'); // collect information about current member if ($logged['member']) { $aMember['ID'] = (int) $_COOKIE['memberID']; $aMemberData = getProfileInfo($aMember['ID']); } else { $aMember['ID'] = 0; } $aMembership = getMemberMembershipInfo($aMember['ID']); /*$iEventID = (int)$_REQUEST['event_id'];*/ $iEventID = $this->bUseFriendlyLinks ? (int) db_value("SELECT `ID` FROM `SDatingEvents` WHERE `EntryUri`='" . $this->process_html_db_input($_REQUEST['eventUri']) . "' LIMIT 1") : (int) $_REQUEST['event_id']; $sQuery = "\r\n\t\t\tSELECT `ID`, `Title`,\r\n\t\t\t\t(NOW() > `EventEnd` AND NOW() < DATE_ADD(`EventEnd`, INTERVAL `ChoosePeriod` DAY)) AS `ChooseActive`\r\n\t\t\tFROM `SDatingEvents`\r\n\t\t\tWHERE\r\n\t\t\t\t`ID` = {$iEventID} AND `Status` = 'Active' AND `AllowViewParticipants` = 1"; $aEventData = db_arr($sQuery); if (!$aEventData['ID']) { return DesignBoxContent('', '<center>' . _t('_Event is unavailable') . '</center>', $oTemplConfig->PageSDatingShowParticipants_db_num); } $sRetHtml .= '<div class="text">' . process_line_output($aEventData['Title']) . '</div>'; // list of participants $aSelfPart = db_arr("SELECT `ID` FROM `SDatingParticipants`\r\n\t\t\t\t\t\t\t\t\tWHERE `IDEvent` = {$iEventID}\r\n\t\t\t\t\t\t\t\t\tAND `IDMember` = {$aMember['ID']}"); $iPartPage = isset($_REQUEST['part_page']) ? (int) $_REQUEST['part_page'] : 1; $iPartPPerPage = isset($_REQUEST['part_p_per_page']) ? (int) $_REQUEST['part_p_per_page'] : 30; $iLimitFirst = (int) ($iPartPage - 1) * $iPartPPerPage; $vPartProfilesRes = db_res("SELECT `Profiles`.*, `SDatingParticipants`.`ParticipantUID` AS `UID`\r\n\t\t\t\t\t\t\t\t\t\tFROM `SDatingParticipants`\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN `Profiles` ON `SDatingParticipants`.`IDMember` = `Profiles`.`ID`\r\n\t\t\t\t\t\t\t\t\t\tWHERE `SDatingParticipants`.`IDEvent` = {$iEventID}\r\n\t\t\t\t\t\t\t\t\t\tORDER BY `Profiles`.`NickName`\r\n\t\t\t\t\t\t\t\t\t\tLIMIT {$iLimitFirst}, {$iPartPPerPage}"); $aTotal = db_arr("SELECT COUNT(*) FROM `SDatingParticipants`\r\n\t\t\t\t\t\t\t\t\tWHERE `SDatingParticipants`.`IDEvent` = {$iEventID}"); $iPartProfilesTotal = (int) $aTotal[0]; $iPagesNum = ceil($iPartProfilesTotal / $iPartPPerPage); $sGenUrlP = $this->genUrl($iEventID, '', 'part', true); $sPartGetUrl = $sGenUrlP . (isset($_REQUEST['part_p_per_page']) ? '&part_p_per_page=' . (int) $_REQUEST['part_p_per_page'] : ''); if ($iPartProfilesTotal == 0) { $sRetHtml .= _t('_There are no participants for this event'); } else { if ($iPagesNum > 1) { $sRetHtml .= '<div class="text">' . _t('_Pages') . ': '; for ($i = 1; $i <= $iPagesNum; $i++) { if ($i == $iPartPage) { $sRetHtml .= "[{$i}] "; } else { $sRetHtml .= "<a href=\"{$sPartGetUrl}&part_page={$i}\">{$i}</a> "; } } $sRetHtml .= '</div><br />'; } $sProfilesTrs = ''; while ($part_profiles_arr = mysql_fetch_assoc($vPartProfilesRes)) { $iUserIsOnline = get_user_online_status($part_profiles_arr[ID]); $sCont = get_member_thumbnail($part_profiles_arr['ID'], 'none') . '<br /><center>' . getProfileOnlineStatus($iUserIsOnline) . '</center>'; //$sProfilesTrs .= DesignBoxContentBorder( process_line_output( strmaxtextlen( $part_profiles_arr['NickName'], 11 ) ) . ': ' . age( $part_profiles_arr['DateOfBirth'] ) . ' ' . _t('_y/o'), $sCont ); $sThumb = get_member_thumbnail($part_profiles_arr['ID'], 'none'); $sProfLink = getProfileLink($part_profiles_arr['ID']); $sAge = age($part_profiles_arr['DateOfBirth']) . $sYOC; $sProfilesTrs .= <<<EOF <div style="float:left;text-align:center;margin-right:10px;position:relative;"> \t{$sThumb} \t<div class="browse_nick" style="width:{$this->iThumbSize}px;"> \t\t<a href="{$sProfLink}">{$part_profiles_arr['NickName']}</a>: {$sAge} \t</div> </div> EOF; } $sNicknameC = _t('_Nickname'); $sDateOfBirthC = _t('_DateOfBirth'); $sSexC = _t('_Sex'); $sEventUIDC = _t('_Event UID'); $sChooseParts = ''; // show 'choose participants' link only during choose period and if member is participant of this event // if ( $this->bAdminMode==FALSE || ($aEventData['ChooseActive'] && $aSelfPart['ID'] )) { // $sChooseParts = '<div class="text" align="center"><a href="'.$_SERVER['PHP_SELF'].'?action=select_match&event_id='.$iEventID.'">'._t('_Choose participants you liked').'</a></div><br />'; // } $sPagesHref = ''; if ($iPagesNum > 1) { $sPagesHref .= '<div class="text">' . _t('_Pages') . ': '; for ($i = 1; $i <= $iPagesNum; $i++) { if ($i == $iPartPage) { $sPagesHref .= "[{$i}] "; } else { $sPagesHref .= "<a href=\"{$sPartGetUrl}&part_page={$i}\">{$i}</a> "; } } $sPagesHref .= '</div><br />'; } $sRetHtml .= $sProfilesTrs . $sPagesHref; } $sRetHtml .= '<div class="clear_both"></div>'; return DesignBoxContent($sListOfParticipantsC, $sRetHtml, $oTemplConfig->PageSDatingShowParticipants_db_num); }
function get_member_thumbnail($ID, $float, $bDrawMargin = FALSE) { global $site; require_once BX_DIRECTORY_PATH_ROOT . 'profilePhotos.php'; $user_is_online = get_user_online_status($ID); //$sSexSql = "SELECT `Sex` FROM `Profiles` WHERE `ID` = '{$ID}'"; $aSexSql = getProfileInfo($ID); //db_arr( $sSexSql ); $oPhoto = new ProfilePhotos($ID); $oPhoto->getActiveMediaArray(); $aFile = $oPhoto->getPrimaryPhotoArray(); if (extFileExists($oPhoto->sMediaDir . 'thumb_' . $aFile['med_file'])) { $sFileName = $oPhoto->sMediaUrl . 'thumb_' . $aFile['med_file']; } else { if ($aSexSql['Sex'] == 'female' or $aSexSql['Sex'] == 'Female') { $sSexPic = 'woman_medium.gif'; } elseif ($aSexSql['Sex'] == 'male' or $aSexSql['Sex'] == 'Male') { $sSexPic = 'man_medium.gif'; } else { $sSexPic = 'visitor_medium.gif'; } $sFileName = getTemplateIcon($sSexPic); } $sMarginsAddon = $bDrawMargin ? " margin-right:10px;margin-bottom:10px; " : ''; $style = 'width:' . $oPhoto->aMediaConfig['size']['thumbWidth'] . 'px;' . 'height:' . $oPhoto->aMediaConfig['size']['thumbHeight'] . 'px;' . 'background-image:url(' . $sFileName . ');'; $ret = ''; $ret .= '<div class="thumbnail_block" style="float:' . $float . '; ">'; $ret .= getProfileOnlineStatus($user_is_online, $bDrawMargin); $ret .= "<a href=\"" . getProfileLink($ID) . "\">"; $ret .= '<img src="' . getTemplateIcon('spacer.gif') . '" style="' . $sMarginsAddon . $style . '" alt="' . process_line_output($aFileName['med_title']) . '" />'; $ret .= '</a>'; $ret .= '</div>'; return $ret; }
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 = '<input type="checkbox" name="photo_only" id="photo_only_id" ' . ($pic_only ? 'checked="checked"' : '') . ' /><label for="photo_only_id"><b>' . _t('_With photos only') . '</b></label>'; $online_only_check = '<input type="checkbox" name="online_only" id="online_only_id" ' . ($onl_only ? 'checked="checked"' : '') . ' /><label for="online_only_id"><b>' . _t('_online only') . '</b></label>'; $country_def_flag = $country_sel == 'all' ? $site['images'] . 'spacer.gif' : $site['flags'] . strtolower($country_sel) . '.gif'; $ret = ' <form id="browse_form" action="' . $_SERVER['PHP_SELF'] . '" method="get"> <div class="browse_form_wrapper"> <div class="browse_form_row"> <div class="clear_both"></div> <div class="label">' . _t('_Sex') . ':</div> <div class="value">' . $sex_options . '</div> <div class="clear_both"></div> </div> <div class="browse_form_row"> <div class="clear_both"></div> <div class="label">' . _t('_DateOfBirth') . ':</div> <div class="value">' . _t("from") . ' ' . $age_option_start . ' ' . _t("to") . ' ' . $age_option_end . '</div> <div class="clear_both"></div> </div> <div class="browse_form_row"> <div class="clear_both"></div> <div class="label">' . _t('_Country') . ':</div>' . '<div class="value">' . $country_options . ' <img id="flagImageId" src="' . $country_def_flag . '" alt="flag" /> </div> <div class="clear_both"></div> </div> <div class="only"> ' . $photo_only_check . ' ' . $online_only_check . ' </div> <div class="submit"> <input id="search" name="search" type="submit" value="' . _t('_Show') . '" /> </div> </div> </form> '; //==================================================================================================== //----------------------- 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 .= '<div id="container_result" style="border: 0px solid #000000">'; $ret .= '<div style="margin-bottom:10px;"><center>' . ResNavigationRet('ProfilesUpper', 0, $function, $aVar) . '</center></div>'; if ($p_num > 0) { $res = db_res($profiles_list_query); $iI = 1; while ($arr = mysql_fetch_array($res)) { $user_is_online = get_user_online_status($arr['ID']); if ($iI == 6) { $cont = '<div class="browse_thumb_thin">'; } else { $cont = '<div class="browse_thumb">'; } $cont .= getProfileOnlineStatus($user_is_online) . get_member_thumbnail($arr['ID'], 'none') . '<div class="browse_nick"><a href="' . getProfileLink($arr['ID']) . '">' . $arr['NickName'] . '</a></div></div>'; $ret .= $cont; $iI++; if ($iI > 6) { $iI = 1; } } } else { $ret .= '<div class="no_result">'; $ret .= '<div>' . _t('_No results found') . '</div>'; $ret .= '</div>'; } $ret .= '<div style="clear:both;margin-top:10px;"><center>' . ResNavigationRet('ProfilesLower', 0, $function, $aVar) . '</center></div>'; $ret .= '</div>'; return $ret; }