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+'&amp;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}&amp;events_page={$prevPage}", 'dynamic' => true, 'class' => 'backMembers');
             $sBackC = _t('_Back');
             /*$ret .= <<<EOF
             	<a href="{$_SERVER['PHP_SELF']}?events_mode={$mode}&amp;events_page={$prevPage}" class="backMembers" onclick="getHtmlData( 'show_events', this.href+'&amp;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}&amp;events_page={$nextPage}", 'dynamic' => true, 'class' => 'moreMembers');
             /*$sNextC = _t('_Next');
             				$ret .= <<<EOF
             	<a href="{$_SERVER['PHP_SELF']}?events_mode={$mode}&amp;events_page={$nextPage}" class="moreMembers" onclick="getHtmlData( 'show_events', this.href+'&amp;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'));
        }
    }