function getLatestFile() { $aWhere[] = "1"; foreach ($this->aCurrent['restriction'] as $sKey => $aValue) { if (isset($aValue['value'])) { switch ($sKey) { case 'featured': case 'owner': if ((int) $aValue['value'] != 0) { $aWhere[] = "`{$this->aCurrent['table']}`.`{$aValue['field']}` = '" . (int) $aValue['value'] . "'"; } break; case 'category': case 'tag': if (strlen($aValue['value']) > 0) { $aWhere[] = "MATCH(`{$this->aCurrent['table']}`.`{$aValue['field']}`) AGAINST ('" . trim(process_db_input($aValue['value'], BX_TAGS_STRIP)) . "')"; } break; case 'allow_view': if (is_array($aValue['value'])) { $sqlJoin = "LEFT JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`{$this->aCurrent['table']}`.`{$this->aCurrent['ident']}`\n LEFT JOIN `sys_albums` ON `sys_albums_objects`.`id_album`=`sys_albums`.`ID`\n "; $sqlCode = "`AllowAlbumView` IN("; foreach ($aValue['value'] as $sValue) { $sqlCode .= "{$sValue}, "; } $aWhere[] = rtrim($sqlCode, ", ") . ')'; } break; } } } $sqlWhere = "WHERE " . implode(' AND ', $aWhere) . " AND `{$this->aCurrent['table']}`.`Status`= 'approved'"; $sqlQuery = "SELECT `{$this->aCurrent['table']}`.`{$this->aCurrent['ident']}` as `{$this->aCurrent['ident']}` FROM `{$this->aCurrent['table']}` {$sqlJoin} {$sqlWhere} ORDER BY `{$this->aCurrent['ident']}` DESC LIMIT 1"; $iFileId = db_value($sqlQuery); $sCode = ''; if ($iFileId != 0) { $this->oTemplate->addCss('view.css'); $oRate = new BxTemplVotingView($this->aCurrent['name'], $aInfo['medID']); $aInfo = $this->oModule->_oDb->getFileInfo(array('fileId' => $iFileId)); $aDraw = array('file' => $this->oTemplate->getFileConcept($aInfo['medID'], array('ext' => $aInfo['medExt'], 'source' => $aInfo['medSource'])), 'file_url' => $this->getCurrentUrl('file', $aInfo['medID'], $aInfo['medUri']), 'title' => $aInfo['medTitle'], 'rate' => $oRate->getSmallVoting(0), 'date' => defineTimeInterval($aInfo['medDate']), 'owner_url' => getProfileLink($aInfo['medProfId']), 'owner_nick' => getNickName($aInfo['medProfId'])); $sCode = $this->oTemplate->parseHtmlByName('latest_file.html', $aDraw); } return $sCode; }
function showPreviousRated($iPhotoID) { global $site; global $oTemplConfig; global $max_thumb_width; global $max_thumb_height; $iBarWidth = $oTemplConfig->iRateSmallRatingBar; $iBarNum = $oTemplConfig->iRateSmallRatingBarNum; $query = "\r\n\t\tSELECT\r\n\t\t\t`media`.`med_id`,\r\n\t\t\t`med_prof_id`,\r\n\t\t\t`med_file`,\r\n\t\t\t`med_title`,\r\n\t\t\t`med_rating_count`,\r\n\t\t\t`med_rating_sum`,\r\n\t\t\t`Profiles`.`NickName`\r\n\t\tFROM `media`\r\n\t\tLEFT JOIN `media_rating` USING (`med_id`)\r\n\t\tLEFT JOIN `Profiles` ON\r\n\t\t\t(`Profiles`.`ID`=`media`.`med_prof_id`)\r\n\t\tWHERE\r\n\t\t\t`med_status` = 'active'\r\n\t\t\tAND `media`.`med_id` = {$iPhotoID}\r\n\t\t"; $ph_arr = db_arr($query); if (!$ph_arr) { return ''; } $urlImg = "{$site['profileImage']}{$ph_arr['med_prof_id']}/thumb_{$ph_arr['med_file']}"; $urlSpacer = getTemplateIcon('spacer.gif'); $sProfLink = getProfileLink($ph_arr['med_prof_id']); $sRatingBar = ''; $oVotingView = new BxTemplVotingView('media', (int) $iPhotoID); if ($oVotingView->isEnabled()) { $sRatingBar = $oVotingView->getSmallVoting(false); } $ret .= <<<EOJ \t<div class="rate_prev_photo_block"> \t\t<div class="thumbnail_block" style="float:none;"> \t\t\t<a href="{$site['url']}photos_gallery.php?ID={$ph_arr['med_prof_id']}&photoID={$ph_arr['med_id']}" title="{$ph_arr['med_title']}"> \t\t\t\t<img style="width:{$max_thumb_width}px;height:{$max_thumb_height}px;background-image:url({$urlImg});" src="{$urlSpacer}" /> \t\t\t</a> \t\t</div> \t\t<div class="rate_prev_photo_nickname"> \t\t\t<a href="{$sProfLink}">{$ph_arr['NickName']}</a> \t\t</div> \t\t<div style="position:relative; width:50%; height:30px; overflow:visible; margin-top:10px;"> \t\t\t<div style="position:absolute; right:-94px; width:400px; height:30px;"> \t\t\t\t{$sRatingBar} \t\t\t</div>\t\t\t \t\t</div> \t</div> EOJ; return DesignBoxContent(_t('_Previous rated'), $ret, 1); }
function getBlockCode_SharedMedia($iUser = 0) { $iUser = (int) $iUser; $aManage = array('medID', 'medExt', 'medTitle', 'medUri'); $max_num = (int) getParam("top_photos_max_num"); $mode = process_db_input(getParam("top_photos_mode")); $mode = $_GET['sh_' . $this->sType . 'Mode']; if ($mode != 'rand' && $mode != 'top' && $mode != 'last') { $mode = 'last'; } $aCond['sqlWhere'] = " WHERE `{$this->aTableFields['Approved']}`='true'"; if ($iUser != 0) { $aCond['sqlWhere'] .= " AND `{$this->aTableFields['medProfId']}`='{$iUser}'"; } $sqlFrom = " FROM `{$this->sMainTable}`"; $aDBTopMenu = array(); foreach (array('last', 'top', 'rand') as $myMode) { switch ($myMode) { case 'last': if ($mode == $myMode) { $aCond['sqlOrder'] = "\r\n\t\t \t\tORDER BY `{$this->aTableFields['medDate']}` DESC"; } $modeTitle = '_Latest'; break; case 'rand': if ($mode == $myMode) { $aCond['sqlOrder'] = "\r\n\t\t \t\tORDER BY RAND()"; } $modeTitle = '_Random'; break; case 'top': if ($mode == $myMode) { $oVotingView = new BxTemplVotingView('g' . $this->sType, 0, 0); $aSql = $oVotingView->getSqlParts('`' . $this->sMainTable . '`', '`' . $this->aTableFields['medID'] . '`'); $sHow = "DESC"; $aCond['sqlOrder'] = $oVotingView->isEnabled() ? "ORDER BY `voting_rate` {$sHow}, `voting_count` {$sHow}, `{$this->aTableFields['medDate']}` {$sHow}" : $aCond['sqlOrder']; $aCond['rateFields'] = $aSql['fields']; $aCond['rateJoin'] = $aSql['join']; $sqlFrom .= $aSql['join']; } $modeTitle = '_Top'; break; } if (basename($_SERVER['PHP_SELF']) == 'rewrite_name.php' || basename($_SERVER['PHP_SELF']) == 'profile.php') { $sLink = "profile.php?ID={$iUser}&"; } else { $sLink = "{$_SERVER['PHP_SELF']}?"; } $sLink .= "sh_" . $this->sType . "Mode={$myMode}"; $aDBTopMenu[$modeTitle] = array('href' => $sLink, 'dynamic' => true, 'active' => $myMode == $mode); } $aNum = db_arr("SELECT COUNT(`{$this->sMainTable}`.`{$this->aTableFields['medID']}`) {$sqlFrom} {$aCond['sqlWhere']}"); $num = (int) $aNum[0]; $ret = ''; if ($num) { $pages = ceil($num / $max_num); $page = (int) $_GET['page']; if ($page < 1 or $mode == 'rand') { $page = 1; } if ($page > $pages) { $page = $pages; } $sqlLimitFrom = ($page - 1) * $max_num; $aCond['sqlLimit'] = "LIMIT {$sqlLimitFrom}, {$max_num}"; $rData = $this->getFilesList($aCond, $aManage); $ret .= '<div class="clear_both"></div>'; $iCounter = 1; $sAddon = ''; while ($aData = mysql_fetch_array($rData)) { $sTitle = strlen($aData['medTitle']) > 0 ? $aData['medTitle'] : _t("_Untitled"); $sHref = $this->getFileUrl($aData['medID'], $aData['medUri']); $oVotingView = new BxTemplVotingView('g' . $this->sType, $aData['medID']); if ($oVotingView->isEnabled()) { $sRate = $oVotingView->getSmallVoting(0); $sShowRate = '<div class="galleryRate">' . $sRate . '</div>'; } switch ($this->sType) { case 'photo': $sImage = $this->sFilesUrl . $aData['medID'] . '_t.' . $aData['medExt']; $sPic = '<div class="lastFilesPic" style="background-image: url(\'' . $sImage . '\');"> <a href="' . $sHref . '"><img src="' . $this->aConfigSite['images'] . 'spacer.gif" alt="" width="110" height="110"></a></div><div class="clear_both"></div>'; break; case 'music': $sPic = '<div class="lastMusicPic"><a href="' . $sHref . '"><img src="' . $this->aConfigSite['images'] . 'music.png"></a></div>'; break; case 'video': $sPic = '<div class="lastVideoPic"><a href="' . $sHref . '"><img src="' . $this->sFilesUrl . $aData['medID'] . '.jpg" width="112px" height="80px"></a></div>'; break; } $ret .= '<div class="sharePhotosContent_1">'; $ret .= $sPic . '<div class="shareMediaAdd"><a href="' . $sHref . '">' . $sTitle . '</a></div>' . $sShowRate . '</div>'; } $ret .= '<div class="clear_both"></div>'; $aDBBottomMenu = array(); if ($pages > 1) { if ($page > 1) { $prevPage = $page - 1; $aDBBottomMenu[_t('_Back')] = array('href' => "{$_SERVER['PHP_SELF']}?sh_" . $this->sType . "Mode={$mode}&page={$prevPage}", 'dynamic' => true, 'class' => 'backMembers'); } if ($page < $pages) { $nextPage = $page + 1; $aDBBottomMenu[_t('_Next')] = array('href' => "{$_SERVER['PHP_SELF']}?sh_" . $this->sType . "Mode={$mode}&page={$nextPage}", 'dynamic' => true, 'class' => 'moreMembers'); } $sAllUrl = $this->isPermalinkEnabled() ? $this->aConfigSite['url'] . $this->sType . '/all/10/1' : $this->aConfigSite['url'] . 'browse' . ucfirst($this->sType) . '.php'; $aDBBottomMenu[_t('_View All')] = array('href' => "{$sAllUrl}", 'class' => 'viewAllMembers'); } } return array($ret, $aDBTopMenu, $aDBBottomMenu); }
function PageCompLastFiles() { global $site; global $aFile; $iLimit = 2; $sQuery = "SELECT `ID` as `medID`,\r\n\t\t\t\t\t `Title` as `medTitle`,\r\n\t\t\t\t\t `Date` as `medDate`,\r\n\t\t\t\t\t `Views` as `medViews`\r\n\t\t\t\t\t FROM `RayMovieFiles` \r\n\t\t\t\t\t WHERE `Owner`='{$aFile['medProfId']}' \r\n\t\t\t\t\t AND `ID`<>'{$aFile['medID']}' AND `Approved`='true' ORDER BY `Date` DESC LIMIT {$iLimit}"; $rLast = db_res($sQuery); $sLinkMore = ''; if ($aFile['medCount'] - 1 > $iLimit) { $sLinkMore = '<a href="browseVideo.php?userID=' . $aFile['medProfId'] . '">' . _t("_See all videos of this user") . '</a>'; } $sCode = '<div id="lastFiles">'; while ($aLast = mysql_fetch_array($rLast)) { $sTitle = strlen($aLast['medTitle']) > 0 ? $aLast['medTitle'] : _t("_Untitled"); $oVotingView = new BxTemplVotingView('gvideo', $aLast['medID']); if ($oVotingView->isEnabled()) { $sRate = $oVotingView->getSmallVoting(0); $sShowRate = '<div class="galleryRate">' . $sRate . '</div>'; } $sCode .= '<div class="lastFileUnit">'; $sCode .= '<div class="lastFilesPic">'; $sCode .= '<a href="' . $site['url'] . 'viewVideo.php?fileID=' . $aLast['medID'] . '">'; $sCode .= '<img src="' . $site['url'] . 'ray/modules/movie/files/' . $aLast['medID'] . '_small.jpg">'; $sCode .= '</a>'; $sCode .= '</div>'; $sCode .= '<div><a href="' . $site['url'] . 'viewVideo.php?fileID=' . $aLast['medID'] . '"><b>' . $sTitle . '</b></a></div>'; $sCode .= '<div>' . _t("_Added") . ': <b>' . defineTimeInterval($aLast['medDate']) . '</b></div>'; $sCode .= '<div>' . _t("_Views") . ': <b>' . $aLast['medViews'] . '</b></div>'; $sCode .= $sShowRate; $sCode .= '</div>'; $sCode .= '<div class="clear_both"></div>'; } $sCode .= '<div class="lastFilesLink">' . $sLinkMore . '</div>'; $sCode .= '</div>'; return $sCode; }
function PageCompPageMainCode() { global $site; global $rData; global $iTotalPages; global $iCurPage; global $iPerPage; global $member; $sCode = '<div style="position: relative; float: left;">'; if (mysql_num_rows($rData)) { while ($aData = mysql_fetch_array($rData)) { $sImage = $site['sharingImages'] . $aData['medID'] . '_t.' . $aData['medExt']; $sProfLink = '<div>' . _t("_By") . ': <a href="' . getProfileLink($aData['medProfId']) . '">' . $aData['NickName'] . '</a></div>'; $oVotingView = new BxTemplVotingView('gphoto', $aData['medID']); if ($oVotingView->isEnabled()) { $sRate = $oVotingView->getSmallVoting(0); $sShowRate = '<div class="galleryRate">' . $sRate . '</div>'; } $sHref = $site['url'] . 'viewPhoto.php?fileID=' . $aData['medID']; $sImg = '<div class="lastFilesPic" style="background-image: url(\'' . $sImage . '\');"> <a href="' . $sHref . '"><img src="' . $site['images'] . 'spacer.gif" width="110" height="110"></a></div>'; $sPicTitle = strlen($aData['medTitle']) > 0 ? $aData['medTitle'] : _t("_Untitled"); $sDelLink = $member['ID'] == $aData['medProfId'] ? '<div><a href="' . $_SERVER['PHP_SELF'] . '?action=del&fileID=' . $aData['medID'] . '" onClick="return confirm( \'' . _t("_are you sure?") . '\');">' . _t("_Delete") . '</a></div>' : ""; $sCode .= '<div class="browseUnit">'; $sCode .= $sImg; $sCode .= '<div><a href="' . $sHref . '"><b>' . $sPicTitle . '</b></a></div>'; $sCode .= $sProfLink; $sCode .= '<div>' . _t("_Added") . ': <b>' . defineTimeInterval($aData['medDate']) . '</b></div>'; $sCode .= '<div>' . _t("_Views") . ': <b>' . $aData['medViews'] . '</b></div>'; $sCode .= $sShowRate; $sCode .= $sDelLink; $sCode .= '</div>'; } } $sCode .= '<div class="clear_both"></div>'; // generate pagination if ($iTotalPages > 1) { $sRequest = $_SERVER['PHP_SELF'] . '?'; $aFields = array('userID', 'tag', 'rate'); foreach ($aFields as $field) { if (isset($_GET[$field])) { $sRequest .= "&{$field}=" . htmlentities(process_pass_data($_GET[$field])); } } $pagination = '<div style="text-align: center; position: relative;">' . _t("_Results per page") . ': <select name="per_page" onchange="window.location=\'' . $sRequest . '&per_page=\' + this.value;"> <option value="10"' . ($iPerPage == 10 ? ' selected="selected"' : '') . '>10</option> <option value="20"' . ($iPerPage == 20 ? ' selected="selected"' : '') . '>20</option> <option value="50"' . ($iPerPage == 50 ? ' selected="selected"' : '') . '>50</option> <option value="100"' . ($iPerPage == 100 ? ' selected="selected"' : '') . '>100</option> </select></div>' . genPagination($iTotalPages, $iCurPage, $sRequest . '&page={page}&per_page=' . $iPerPage); } else { $pagination = ''; } return $sCode . $pagination . '</div>'; }
function PageCompShareMusicContent($sCaption, $iID = 0) { global $site; $max_num = (int) getParam("top_photos_max_num"); $mode = process_db_input(getParam("top_photos_mode")); $mode = $_GET['shMusicMode']; if ($mode != 'rand' && $mode != 'top' && $mode != 'last') { $mode = 'last'; } $sqlSelect = "SELECT `ID` as `medID`,\r\n\t\t\t\t\t\t `Title` as `medTitle`,\r\n\t\t\t\t\t\t `Date` as `medDate`\r\n\t\t\t\t\t\t "; $sqlFrom = " FROM `RayMusicFiles`"; if ($iID != 0) { $sqlWhere = " WHERE `Approved`='true' AND `Owner`='{$iID}'"; } $menu = '<div class="dbTopMenu">'; foreach (array('last', 'top', 'rand') as $myMode) { switch ($myMode) { case 'last': if ($mode == $myMode) { $sqlOrder = "\r\n\t \t\tORDER BY `medDate` DESC"; } $modeTitle = _t('_Latest'); break; case 'rand': if ($mode == $myMode) { $sqlOrder = "\r\n\t \t\tORDER BY RAND()"; } $modeTitle = _t('_Random'); break; case 'top': if ($mode == $myMode) { $oVotingView = new BxTemplVotingView('gmusic', 0, 0); $aSql = $oVotingView->getSqlParts('`RayMusicFiles`', '`ID`'); $sHow = "DESC"; $sqlOrderBy = $oVotingView->isEnabled() ? "ORDER BY `voting_rate` {$sHow}, `voting_count` {$sHow}, `medDate` {$sHow}" : $sqlOrderBy; $sqlFields = $aSql['fields']; $sqlLJoin = $aSql['join']; $sqlSelect .= $sqlFields; $sqlFrom .= $sqlLJoin; $sqlOrder = $sqlOrderBy; } $modeTitle = _t('_Top'); break; } //if( $_SERVER['PHP_SELF'] == 'rewrite_name.php' ) if ($myMode == $mode) { $menu .= "<div class=\"active\">{$modeTitle}</div>"; } else { if (basename($_SERVER['PHP_SELF']) == 'rewrite_name.php' || basename($_SERVER['PHP_SELF']) == 'profile.php') { $menu .= "<div class=\"notActive\"><a href=\"profile.php?ID={$iID}&shMusicMode={$myMode}\" class=\"top_members_menu\" onclick=\"getHtmlData( 'show_shareMusic', this.href+'&show_only=shareMusic'); return false;\">{$modeTitle}</a></div>"; } else { $menu .= "<div class=\"notActive\"><a href=\"{$_SERVER['PHP_SELF']}?shMusicMode={$myMode}\" class=\"top_members_menu\" onclick=\"getHtmlData( 'show_shareMusic', this.href+'&show_only=shareMusic'); return false;\">{$modeTitle}</a></div>"; } } } $menu .= '</div>'; $aNum = db_arr("SELECT COUNT(`RayMusicFiles`.`ID`) {$sqlFrom} {$sqlWhere}"); $num = (int) $aNum[0]; $ret = ''; if ($num) { $pages = ceil($num / $max_num); $page = (int) $_GET['page_p']; if ($page < 1 or $mode == 'rand') { $page = 1; } if ($page > $pages) { $page = $pages; } $sqlLimitFrom = ($page - 1) * $max_num; $sqlLimit = "\r\n\t\tLIMIT {$sqlLimitFrom}, {$max_num}"; $rData = db_res($sqlSelect . $sqlFrom . $sqlWhere . $sqlOrder . $sqlLimit); $sAddon = ''; $iCounter = 1; $ret .= '<div class="clear_both"></div>'; while ($aData = mysql_fetch_array($rData)) { $sHref = $site['url'] . 'viewMusic.php?fileID=' . $aData['medID']; $sVidTitle = strlen($aData['medTitle']) > 0 ? $aData['medTitle'] : _t("_Untitled"); $sImg = '<a href="' . $sHref . '"><img src="' . $site['images'] . 'music.png"></a>'; $oVotingView = new BxTemplVotingView('gmusic', $aData['medID']); if ($oVotingView->isEnabled()) { $sRate = $oVotingView->getSmallVoting(0); $sShowRate = '<div class="galleryRate">' . $sRate . '</div>'; } if ($iCounter % 3 != 0) { $ret .= '<div class="shareMusicContent_1">'; } else { $ret .= '<div class="shareMusicContent_2">'; $sAddon = '<div class="clear_both"></div>'; } $ret .= '<div class="lastMusicPic">' . $sImg . '</div>'; $ret .= '<div><a href="' . $sHref . '">' . $sVidTitle . '</a></div>'; $ret .= $sShowRate . '</div>'; $ret .= $sAddon; $sAddon = ''; $iCounter++; } $ret .= '<div class="clear_both"></div>'; $ret = DesignBoxContent(_t($sCaption), $ret, 1, $menu); } return $ret; }
function PageCompLastFiles() { global $site; global $aFile; $iLimit = 2; $sQuery = "SELECT `medID`,\r\n\t\t\t\t\t `medTitle`,\r\n\t\t\t\t\t UNIX_TIMESTAMP(`medDate`) as `medDate`,\r\n\t\t\t\t\t `medExt`,\r\n\t\t\t\t\t `medViews`\r\n\t\t\t\t\t FROM `sharePhotoFiles` \r\n\t\t\t\t\t WHERE `medProfId`='{$aFile['medProfId']}' \r\n\t\t\t\t\t AND `medID`<>'{$aFile['medID']}' AND `Approved`='true' ORDER BY `medDate` DESC LIMIT {$iLimit}"; $rLast = db_res($sQuery); $sLinkMore = ''; if ($aFile['medCount'] - 1 > $iLimit) { $sLinkMore = '<a href="browsePhoto.php?userID=' . $aFile['medProfId'] . '">' . _t("_See all photos of this user") . '</a>'; } $sCode = '<div id="lastFiles">'; while ($aLast = mysql_fetch_array($rLast)) { $sImage = $site['sharingImages'] . $aLast['medID'] . '_t.' . $aLast['medExt']; $sTitle = strlen($aLast['medTitle']) > 0 ? $aLast['medTitle'] : _t("_Untitled"); $oVotingView = new BxTemplVotingView('gphoto', $aLast['medID']); if ($oVotingView->isEnabled()) { $sRate = $oVotingView->getSmallVoting(0); $sShowRate = '<div class="galleryRate">' . $sRate . '</div>'; } $sCode .= '<div class="lastFileUnit">'; $sCode .= '<a href="' . $site['url'] . 'viewPhoto.php?fileID=' . $aLast['medID'] . '">'; $sCode .= '<img class="lastFilesPic" style="background-image: url(\'' . $sImage . '\');" src="' . getTemplateIcon('spacer.gif') . '" />'; $sCode .= '</a>'; $sCode .= '<div><a href="' . $site['url'] . 'viewPhoto.php?fileID=' . $aLast['medID'] . '"><b>' . $sTitle . '</b></a></div>'; $sCode .= '<div>' . _t("_Added") . ': <b>' . defineTimeInterval($aLast['medDate']) . '</b></div>'; $sCode .= '<div>' . _t("_Views") . ': <b>' . $aLast['medViews'] . '</b></div>'; $sCode .= $sShowRate; $sCode .= '</div>'; $sCode .= '<div class="clear_both"></div>'; } $sCode .= '<div class="lastFilesLink">' . $sLinkMore . '</div>'; $sCode .= '</div>'; return $sCode; }
/** * Top Rated Profiles block (Leaders) */ function getBlockCode_Leaders() { global $site; global $max_voting_mark; global $index_progressbar_w; global $getBlockCode_TopRated_db_num; global $max_thumb_height; global $max_thumb_width; global $oTemplConfig; // most rated profiles // $rate_max = get_max_votes_profile(); $oVoting = new BxTemplVotingView('profile', 0, 0); $iIdMonth = $oVoting->getTopVotedItem(30, '`Profiles`', '`ID`', "AND `Profiles`.`Status` = 'Active'"); $iIdWeek = $oVoting->getTopVotedItem(7, '`Profiles`', '`ID`', "AND `Profiles`.`Status` = 'Active' AND `ID`<>{$iIdMonth}"); $iIdDay = $oVoting->getTopVotedItem(1, '`Profiles`', '`ID`', "AND `Profiles`.`Status` = 'Active' AND `ID`<>{$iIdMonth} AND `ID`<>{$iIdWeek}"); $oVotingMonth = new BxTemplVotingView('profile', $iIdMonth); $oVotingWeek = new BxTemplVotingView('profile', $iIdWeek); $oVotingDay = new BxTemplVotingView('profile', $iIdDay); $rate_memb_month = getProfileInfo($iIdMonth); //db_arr( "SELECT Headline, NickName, ID, Pic_0_addon FROM Profiles WHERE `ID` = '$iIdMonth' LIMIT 1" ); $rate_memb_week = getProfileInfo($iIdWeek); //db_arr( "SELECT Headline, NickName, ID, Pic_0_addon FROM Profiles WHERE `ID` = '$iIdWeek' LIMIT 1" ); $rate_memb_day = getProfileInfo($iIdDay); //db_arr( "SELECT Headline, NickName, ID, Pic_0_addon FROM Profiles WHERE `ID` = '$iIdDay' LIMIT 1" ); //$rate_memb_month = db_arr( "SELECT Headline, NickName, Member, COUNT(*) AS `count`, SUM(Mark)/COUNT(*) AS mark, ID, Pic_0_addon FROM `Votes` INNER JOIN Profiles ON (ID = Member) WHERE Status = 'Active' AND TO_DAYS(NOW()) - TO_DAYS(`Date`) <= 30 GROUP BY Member ORDER BY Mark DESC,`count` DESC LIMIT 1" ); //$rate_memb_week = db_arr( "SELECT Headline, NickName, Member, COUNT(*) AS `count`, SUM(Mark)/COUNT(*) AS mark, ID, Pic_0_addon FROM `Votes` INNER JOIN Profiles ON (ID = Member) WHERE Status = 'Active' AND TO_DAYS(NOW()) - TO_DAYS(`Date`) <= 7 GROUP BY Member ORDER BY Mark DESC,`count` DESC LIMIT 1" ); $ret = ''; //##################################################################### $ret .= '<div class="clear_both"></div>'; $ret .= '<div id="prof_of_month">'; $ret .= '<div class="top_rated_head">'; $ret .= _t("_Month"); $ret .= '</div>'; if (0 < $rate_memb_month['ID']) { $ret .= get_member_thumbnail($rate_memb_month['ID'], 'none'); $ret .= '<div class="rate_block_position">'; $ret .= $oVotingMonth->getSmallVoting(0); $ret .= '</div>'; } else { $ret .= '<div class="top_prof_not_avail">'; $ret .= '<div class="no_result">'; $ret .= '<div>'; $ret .= _t("_no_top_month"); $ret .= '</div>'; $ret .= '</div>'; $ret .= '</div>'; } $ret .= '<div class="clear_both"></div></div>'; //##################################################################### $ret .= '<div id="prof_of_week">'; $ret .= '<div class="top_rated_head">'; $ret .= _t("_Week"); $ret .= '</div>'; if (0 < $rate_memb_week['ID']) { $ret .= get_member_thumbnail($rate_memb_week['ID'], 'none'); $ret .= '<div class="rate_block_position">'; $ret .= $oVotingWeek->getSmallVoting(0); $ret .= '</div>'; } else { $ret .= '<div class="top_prof_not_avail">'; $ret .= '<div class="no_result">'; $ret .= '<div>'; $ret .= _t("_no_top_week"); $ret .= '</div>'; $ret .= '</div>'; $ret .= '</div>'; } $ret .= '<div class="clear_both"></div></div>'; //##################################################################### $ret .= '<div id="prof_of_day">'; $ret .= '<div class="top_rated_head">'; $ret .= _t("_Day"); $ret .= '</div>'; if (0 < $rate_memb_day['ID']) { $ret .= get_member_thumbnail($rate_memb_day['ID'], 'none'); $ret .= '<div class="rate_block_position">'; $ret .= $oVotingDay->getSmallVoting(0); $ret .= '</div>'; } else { $ret .= '<div class="top_prof_not_avail">'; $ret .= '<div class="no_result">'; $ret .= '<div>'; $ret .= _t("_no_top_day"); $ret .= '</div>'; $ret .= '</div>'; $ret .= '</div>'; } $ret .= '<div class="clear_both"></div></div>'; $ret .= '<div class="clear_both"></div>'; return $ret; }
function getMediaBlock($iMediaID = 0) { global $site; global $votes_pic; $ret = ''; if ($this->iMediaCount > 0) { $iMediaID = $iMediaID > 0 ? $iMediaID : $this->aMedia['0']['PrimPhoto']; $aCurPhoto = $this->getElementArrayByID($iMediaID); if (empty($aCurPhoto)) { $sPhotoUrl = getTemplateIcon($this->sSexPic); } else { $iPhotoID = $aCurPhoto['med_id']; $sPhotoUrl = $this->sMediaUrl . 'photo_' . $aCurPhoto['med_file']; } } else { $sPhotoUrl = getTemplateIcon($this->sSexPic); } $ret .= $this->getJSCode($aCurPhoto); $ret .= '<div class="photoBlock" id="photoKeeper">'; $style = 'width:' . $this->aMediaConfig['size']['photoWidth'] . 'px;' . 'height:' . $this->aMediaConfig['size']['photoHeight'] . 'px;' . 'background-image:url(' . $sPhotoUrl . ');'; $ret .= '<a href="' . $site['url'] . 'photos_gallery.php?ID=' . $this->iProfileID . '" id="temThumbLink">'; $ret .= '<img src="' . getTemplateIcon('spacer.gif') . '" style="' . $style . '" class="photo" alt="" id="temThumbID" />'; //$ret .= '<img src="' . getTemplateIcon('spacer.gif') . '" style="' . $style . '" class="photo" alt="" onload="return setThumb();" id="temThumbID" />'; $ret .= '</a>'; $ret .= '</div>'; $ret .= '<div id="temPhotoTitle" class="photo_title">' . stripslashes($aCurPhoto['med_title']) . '</div>'; $sJsIconsArray = ''; $iCountPhotos = 0; $sIcons = $this->_getIconsList2($sJsIconsArray, $iCountPhotos); $oVotingView = new BxTemplVotingView('media', (int) $aCurPhoto['med_id']); if ($iCountPhotos && $votes_pic && $oVotingView->isEnabled()) { $ret .= $oVotingView->getSmallVoting(); } $ret .= '<div class="clear_both"></div>'; if (strlen($sIcons)) { $ret .= '<div class="scrollIconContainer">'; $ret .= '<div class="scrollCont" id="scrollCont">'; $ret .= '<div class="scrollLeft" onmouseover="moveScrollLeftAuto( \'iconBlock\', 1 );" onmouseout="moveScrollLeftAuto( \'iconBlock\', 0 );"><img src="' . getTemplateIcon('left_arrow.gif') . '"/></div>'; $ret .= '<div class="scrollRight" onmouseover="moveScrollRightAuto( \'iconBlock\', 1 );" onmouseout="moveScrollRightAuto( \'iconBlock\', 0 );"><img src="' . getTemplateIcon('right_arrow.gif') . '"/></div>'; $ret .= '<div class="clear_both"></div>'; $ret .= '</div>'; $ret .= '<div class="iconBlockCont">'; $ret .= '<div id="iconBlock" class="iconBlock">'; $ret .= $sIcons; $ret .= '</div>'; $ret .= '</div>'; $ret .= '</div>'; } $ret .= '<script type="text/javascript">' . $sJsIconsArray . '</script>'; return $ret; }
function getMediaBlock($iMediaID = 0, $bCouple = false) { global $site; global $votes_pic; $ret = ''; if ($this->iMediaCount > 0) { $iMediaID = $iMediaID > 0 ? $iMediaID : $this->aMedia['0']['PrimPhoto']; $aCurPhoto = $this->getElementArrayByID($iMediaID); if (empty($aCurPhoto)) { $sPhotoUrl = getTemplateIcon($this->sSexPic); } else { $iPhotoID = $aCurPhoto['med_id']; $sPhotoUrl = $this->sMediaUrl . 'photo_' . $aCurPhoto['med_file']; } } else { $sPhotoUrl = getTemplateIcon($this->sSexPic); } $bUseFeature = getParam("profile_gallery_feature") == "on" ? true : false; //$bUseFeature = true; $bSUseFeature = $bUseFeature ? 'true' : 'false'; $ret .= $this->getJSCode($aCurPhoto, $bSUseFeature); $sFeature = ''; if ($bUseFeature) { for ($i = 0; $i < $this->aMediaConfig['max']['photo']; $i++) { $sIconSrc = $this->sMediaDir . 'photo_' . $this->aMedia[$i]['med_file']; if (extFileExists($sIconSrc)) { $sIconUrl = $this->sMediaUrl . 'photo_' . $this->aMedia[$i]['med_file']; //$atrib = "'{$this -> aMedia[$i]['med_id']}'"; //$sFeatImgs .= '<a href="' . $site['url'] . 'photos_gallery.php?ID=' . $this -> iProfileID . '">'; $sFeatImgs .= '<img src="' . getTemplateIcon('spacer.gif') . '" style="width:' . $this->aMediaConfig['size']['photoWidth'] . 'px; height:' . $this->aMediaConfig['size']['photoHeight'] . 'px; background-image:url(' . $sIconUrl . ');position:absolute;" alt="" class="icons" />'; //$sFeatImgs .= '</a>'; } } $sFeatTotalHeight = $this->aMediaConfig['size']['photoHeight'] + 30; $sFeature = <<<EOF <script type="text/javascript" src="{$site['url']}inc/js/jquery.dolPromoT.js"></script> <script type="text/javascript"> \t\$(document).ready( function() { \t\t\$( '#iiPPhoto' ).dolPromo( 3000, 1 ); \t} ); </script> <div style="position:relative;width:100%;height:{$sFeatTotalHeight}px;overflow:hidden;"> \t<div id="iiPPhoto"> \t\t{$sFeatImgs} \t</div> </div> EOF; $ret .= $sFeature; } else { $ret .= '<div class="photoBlock" id="photoKeeper">'; $style = 'width:' . $this->aMediaConfig['size']['photoWidth'] . 'px;' . 'height:' . $this->aMediaConfig['size']['photoHeight'] . 'px;' . 'background-image:url(' . $sPhotoUrl . ');'; $ret .= '<a href="' . $site['url'] . 'photos_gallery.php?ID=' . $this->iProfileID . '" id="temThumbLink">'; $ret .= '<img src="' . getTemplateIcon('spacer.gif') . '" style="' . $style . '" class="photo" alt="" id="temThumbID" />'; //$ret .= '<img src="' . getTemplateIcon('spacer.gif') . '" style="' . $style . '" class="photo" alt="" onload="return setThumb();" id="temThumbID" />'; $ret .= '</a>'; $ret .= '</div>'; } $ret .= '<div id="temPhotoTitle" class="photo_title">' . stripslashes($aCurPhoto['med_title']) . '</div>'; if ($bCouple) { return $ret . '<div class="clear_both"></div>'; } $sJsIconsArray = ''; $iCountPhotos = 0; $sIcons = $this->_getIconsList2($sJsIconsArray, $iCountPhotos); $oVotingView = new BxTemplVotingView('media', (int) $aCurPhoto['med_id']); if ($iCountPhotos && $votes_pic && $oVotingView->isEnabled()) { $ret .= $oVotingView->getSmallVoting(); } $ret .= '<div class="clear_both"></div>'; if (strlen($sIcons)) { $ret .= '<div class="scrollIconContainer">'; $ret .= '<div class="scrollCont" id="scrollCont">'; $ret .= '<div class="scrollLeft" onmouseover="moveScrollLeftAuto( \'iconBlock\', 1 );" onmouseout="moveScrollLeftAuto( \'iconBlock\', 0 );"><img src="' . getTemplateIcon('left_arrow.gif') . '"/></div>'; $ret .= '<div class="scrollRight" onmouseover="moveScrollRightAuto( \'iconBlock\', 1 );" onmouseout="moveScrollRightAuto( \'iconBlock\', 0 );"><img src="' . getTemplateIcon('right_arrow.gif') . '"/></div>'; $ret .= '<div class="clear_both"></div>'; $ret .= '</div>'; $ret .= '<div class="iconBlockCont">'; $ret .= '<div id="iconBlock" class="iconBlock">'; $ret .= $sIcons; $ret .= '</div>'; $ret .= '</div>'; $ret .= '</div>'; } $ret .= '<script type="text/javascript">' . $sJsIconsArray . '</script>'; return $ret; }