function getBlockCode_Groups()
{
global $site;
$mode = $_REQUEST['groups_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;
}
$aDBTopMenu[$sTabTitle] = array('href' => "{$_SERVER['PHP_SELF']}?groups_mode={$myMode}", 'dynamic' => true, 'active' => $myMode == $mode);
/*if( $mode == $myMode ) {
$menu .= "<div class=\"active\">$sTabTitle</div>";
} else {
$menu .= "
<div class=\"notActive\">
<a href=\"{$_SERVER['PHP_SELF']}?groups_mode=$myMode\" class=\"top_members_menu\" onclick=\"getHtmlData( 'show_groups', this.href+'&show_only=groups'); return false;\">$sTabTitle</a>
</div>";
}*/
}
/*$menu .= '
<div class="clear_both"></div>
</div>';*/
$iTotalNum = db_value("SELECT COUNT(*) AS 'Cnt' FROM `Groups` WHERE `status` = 'Active'");
$oGroups = new BxDolGroups();
if ($iTotalNum) {
$iResPerPage = (int) getParam("max_blogs_on_home");
$iTotalPages = ceil($iTotalNum / $iResPerPage);
$page = (int) $_REQUEST['groups_page'];
if ($page < 1 or $mode == 'rand') {
$page = 1;
}
if ($page > $iTotalPages) {
$page = $iTotalPages;
}
$sqlLimitFrom = ($page - 1) * $iResPerPage;
$sBlocks = $oGroups->GenAnyBlockContent($mode, 0, "LIMIT {$sqlLimitFrom}, {$iResPerPage}");
$ret = $sBlocks;
} else {
$ret .= '<div class="no_result"><div>' . _t("_No groups 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']}?groups_mode={$mode}&groups_page={$prevPage}", 'dynamic' => true, 'class' => 'backMembers');
/*$sBackC = _t('_Back');
$retR .= <<<EOF
<a href="{$_SERVER['PHP_SELF']}?groups_mode={$mode}&groups_page={$prevPage}" class="backMembers" onclick="getHtmlData( 'show_groups', this.href+'&show_only=groups'); return false;">
{$sBackC}
</a>
EOF;*/
}
if ($page < $iTotalPages) {
$nextPage = $page + 1;
$aDBBottomMenu[_t('_Next')] = array('href' => "{$_SERVER['PHP_SELF']}?groups_mode={$mode}&groups_page={$nextPage}", 'dynamic' => true, 'class' => 'moreMembers');
/*$sNextC = _t('_Next');
$retR .= <<<EOF
<a href="{$_SERVER['PHP_SELF']}?groups_mode={$mode}&groups_page={$nextPage}" class="moreMembers" onclick="getHtmlData( 'show_groups', this.href+'&show_only=groups'); return false;">
{$sNextC}
</a>
EOF;*/
}
$sBMViewAllLink = $oGroups->bUseFriendlyLinks ? "{$site['url']}groups/all/" : "{$site['url']}grp.php";
$aDBBottomMenu[_t('_View All')] = array('href' => $sBMViewAllLink, 'dynamic' => false, 'class' => 'viewAllMembers');
//$ret .= '<div class="clear_both"></div></div>';
}
return array($ret, $aDBTopMenu, $aDBBottomMenu);
}
function showBlockGroups($sCaption, $bNoDB = false)
{
global $site;
$ID = $this->_iProfileID;
if ($ID > 0) {
$sQuery = "\r\n\t\t\t\tSELECT COUNT(`Groups`.`ID`) AS 'Cnt'\r\n\t\t\t\tFROM `GroupsMembers`, `Groups`\r\n\t\t\t\tWHERE \r\n\t\t\t\t`Groups`.`status` = 'Active' AND\r\n\t\t\t\t`GroupsMembers`.`memberID` = {$ID} AND\r\n\t\t\t\t`GroupsMembers`.`groupID` = `Groups`.`ID` AND\r\n\t\t\t\t`GroupsMembers`.`status` = 'Active'\r\n\t\t\t";
$iBlogs = db_value($sQuery);
if ($iBlogs > 0) {
$oGroups = new BxDolGroups();
$sBlocks = $oGroups->GenAnyBlockContent('last', $ID);
$ret = <<<EOF
<div id="container_groups">
\t{$sBlocks}
</div>
EOF;
$show_hide = $this->genShowHideItem('container_groups');
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_Groups()
{
if ($this->iMember > 0) {
$sqlQuery = "\r\n\t\t\t\tSELECT COUNT(`Groups`.`ID`) AS 'Cnt'\r\n\t\t\t\tFROM `GroupsMembers`, `Groups`\r\n\t\t\t\tINNER JOIN `GroupsCateg` ON `GroupsCateg`.`ID` = `Groups`.`categID` \r\n\t\t\t\tWHERE\r\n\t\t\t\t`GroupsMembers`.`memberID` = '{$this->iMember}' AND `GroupsMembers`.`groupID` = `Groups`.`ID` AND `GroupsMembers`.`status` = 'Active'\r\n\t\t\t";
$iBlogs = db_value($sqlQuery);
if ($iBlogs > 0) {
$oGroups = new BxDolGroups();
$sBlocks = $oGroups->GenAnyBlockContent('latest', $this->iMember);
$ret = <<<EOF
<div id="container_groups">
\t{$sBlocks}
</div>
EOF;
$show_hide = $this->genShowHideItem('container_groups');
$sShowHide = $show_hide;
return $ret;
} else {
return '';
}
} else {
return MsgBox(_t('_im_textNoCurrUser'));
}
}