function getBlockCode_Events() { global $site; $mode = $_REQUEST['events_mode']; if ($mode != 'rand' and $mode != 'latest') { $mode = 'latest'; } $aDBTopMenu = array(); //$menu = '<div class="dbTopMenu">'; foreach (array('latest', 'rand') as $myMode) { switch ($myMode) { case 'latest': $sTabTitle = _t('_Latest'); break; case 'rand': $sTabTitle = _t('_Random'); break; } /*if( $mode == $myMode ) { $menu .= "<div class=\"active\">$sTabTitle</div>"; } else { $menu .= " <div class=\"notActive\"> <a href=\"{$_SERVER['PHP_SELF']}?events_mode=$myMode\" class=\"top_members_menu\" onclick=\"getHtmlData( 'show_events', this.href+'&show_only=events'); return false;\">$sTabTitle</a> </div>"; }*/ $aDBTopMenu[$sTabTitle] = array('href' => "{$_SERVER['PHP_SELF']}?events_mode={$myMode}", 'dynamic' => true, 'active' => $myMode == $mode); } /*$menu .= ' <div class="clear_both"></div> </div>';*/ $iTotalNum = db_value("SELECT COUNT(*) AS 'Cnt' FROM `SDatingEvents` WHERE `Status` = 'Active'"); $oEvents = new BxDolEvents(); if ($iTotalNum) { $iResPerPage = (int) getParam("max_blogs_on_home"); $iTotalPages = ceil($iTotalNum / $iResPerPage); $page = (int) $_REQUEST['events_page']; if ($page < 1 or $mode == 'rand') { $page = 1; } if ($page > $iTotalPages) { $page = $iTotalPages; } $sqlLimitFrom = ($page - 1) * $iResPerPage; $sBlocks = $oEvents->GenAnyBlockContent($mode, 0, "LIMIT {$sqlLimitFrom}, {$iResPerPage}"); $ret = $sBlocks; } else { $ret .= '<div class="no_result"><div>' . _t("_No events available") . '</div></div>'; } $aDBBottomMenu = array(); if ($iTotalPages > 1) { //$ret .= '<div class="dbBottomMenu">'; if ($page > 1) { $prevPage = $page - 1; $aDBBottomMenu[_t('_Back')] = array('href' => "{$_SERVER['PHP_SELF']}?events_mode={$mode}&events_page={$prevPage}", 'dynamic' => true, 'class' => 'backMembers'); $sBackC = _t('_Back'); /*$ret .= <<<EOF <a href="{$_SERVER['PHP_SELF']}?events_mode={$mode}&events_page={$prevPage}" class="backMembers" onclick="getHtmlData( 'show_events', this.href+'&show_only=events'); return false;"> {$sBackC} </a> EOF;*/ } if ($page < $iTotalPages) { $nextPage = $page + 1; $aDBBottomMenu[_t('_Next')] = array('href' => "{$_SERVER['PHP_SELF']}?events_mode={$mode}&events_page={$nextPage}", 'dynamic' => true, 'class' => 'moreMembers'); /*$sNextC = _t('_Next'); $ret .= <<<EOF <a href="{$_SERVER['PHP_SELF']}?events_mode={$mode}&events_page={$nextPage}" class="moreMembers" onclick="getHtmlData( 'show_events', this.href+'&show_only=events'); return false;"> {$sNextC} </a> EOF;*/ } $sBMViewAllLink = $oEvents->bUseFriendlyLinks ? "{$site['url']}events/" : "{$site['url']}events.php?show_events=all&action=show"; $aDBBottomMenu[_t('_View All')] = array('href' => $sBMViewAllLink, 'dynamic' => false, 'class' => 'viewAllMembers'); //$ret .= '<div class="clear_both"></div></div>'; } return array($ret, $aDBTopMenu, $aDBBottomMenu); //return $ret; }
function showBlockEvents($sCaption, $bNoDB = false) { global $site; $ID = $this->_iProfileID; if ($ID > 0) { $sQuery = "\r\n\t\t\t\tSELECT COUNT(`SDatingEvents`.`ID`) AS 'Cnt'\r\n\t\t\t\tFROM `SDatingEvents` \r\n\t\t\t\tLEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent` = `SDatingEvents`.`ID` \r\n\t\t\t\tWHERE (`SDatingEvents`.`ResponsibleID` = '{$ID}' OR `SDatingParticipants`.`IDMember` = '{$ID}')\r\n\t\t\t\tAND `SDatingEvents`.`Status` = 'Active'\r\n\t\t\t"; $iBlogs = db_value($sQuery); if ($iBlogs > 0) { $oEvents = new BxDolEvents(); $sBlocks = $oEvents->GenAnyBlockContent('last', $ID); $ret = <<<EOF <div id="container_events"> \t{$sBlocks} </div> EOF; $show_hide = $this->genShowHideItem('container_events'); if ($bNoDB) { return $ret; } else { echo DesignBoxContent(_t($sCaption), $ret, 1, $show_hide); } } else { return; } } else { if ($bNoDB) { return MsgBox(_t('_im_textNoCurrUser')); } else { echo MsgBox(_t('_im_textNoCurrUser')); } } }
function getBlockCode_Events() { if ($this->iMember > 0) { $sqlQuery = "\r\n\t\t\t\tSELECT COUNT(`SDatingEvents`.`ID`) AS 'Cnt'\r\n\t\t\t\tFROM `SDatingEvents` \r\n\t\t\t\tLEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent` = `SDatingEvents`.`ID` \r\n\t\t\t\tWHERE (`SDatingEvents`.`ResponsibleID` = '{$this->iMember}' OR `SDatingParticipants`.`IDMember` = '{$this->iMember}')\r\n\t\t\t\tAND `SDatingEvents`.`Status` = 'Active'\r\n\t\t\t"; $iBlogs = db_value($sqlQuery); if ($iBlogs > 0) { $oEvents = new BxDolEvents(); $sBlocks = $oEvents->GenAnyBlockContent('last', $this->iMember); $ret = <<<EOF <div id="container_events"> \t{$sBlocks} </div> EOF; $show_hide = $this->genShowHideItem('container_events'); $sShowHide = $show_hide; return $ret; } else { return ''; } } else { return MsgBox(_t('_im_textNoCurrUser')); } }