function getBlockCode_Classifieds()
{
if ($this->iMember > 0) {
$sqlQuery = "\r\n\t\t\t\tSELECT DISTINCT\r\n\t\t\t\tCOUNT(`ClassifiedsAdvertisements`.`ID`)\r\n\t\t\t\tFROM `ClassifiedsAdvertisements`\r\n\t\t\t\tWHERE\r\n\t\t\t\t`ClassifiedsAdvertisements`.`IDProfile` = '{$this->iMember}' AND `ClassifiedsAdvertisements`.`Status` = 'active'\r\n\t\t\t\tGROUP BY `ClassifiedsAdvertisements`.`ID`\r\n\t\t\t";
$iBlogs = db_value($sqlQuery);
if ($iBlogs > 0) {
$oClassifieds = new BxDolClassifieds();
$sBlocks = $oClassifieds->GenAnyBlockContent('last', $this->iMember);
$ret = <<<EOF
<div id="container_classifieds">
\t{$sBlocks}
</div>
EOF;
$show_hide = $this->genShowHideItem('container_classifieds');
$sShowHide = $show_hide;
return $ret;
} else {
return '';
}
} else {
return MsgBox(_t('_im_textNoCurrUser'));
}
}
function showBlockClassifieds($sCaption, $bNoDB = false)
{
global $site;
$ID = $this->_iProfileID;
if ($ID > 0) {
$sQuery = "\r\n\t\t\t\tSELECT DISTINCT\r\n\t\t\t\tCOUNT(*)\r\n\t\t\t\tFROM `ClassifiedsAdvertisements`\r\n\t\t\t\tWHERE\r\n\t\t\t\t`ClassifiedsAdvertisements`.`IDProfile` = '{$ID}' AND `ClassifiedsAdvertisements`.`Status` = 'active'\r\n\t\t\t\tGROUP BY `ClassifiedsAdvertisements`.`ID`\r\n\t\t\t";
$iBlogs = db_value($sQuery);
if ($iBlogs > 0) {
$oClassifieds = new BxDolClassifieds();
$sBlocks = $oClassifieds->GenAnyBlockContent('last', $ID);
$ret = <<<EOF
<div id="container_classifieds">
\t{$sBlocks}
</div>
EOF;
$show_hide = $this->genShowHideItem('container_classifieds');
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_Classifieds()
{
global $site;
$mode = $_REQUEST['classifieds_mode'];
if ($mode != 'rand' and $mode != 'latest' and $mode != 'top') {
$mode = 'latest';
}
$aDBTopMenu = array();
//$menu = '<div class="dbTopMenu">';
foreach (array('latest', 'top', 'rand') as $myMode) {
switch ($myMode) {
case 'top':
$sTabTitle = _t('_Top');
break;
case 'latest':
$sTabTitle = _t('_Latest');
break;
case 'rand':
$sTabTitle = _t('_Random');
break;
}
$aDBTopMenu[$sTabTitle] = array('href' => "{$_SERVER['PHP_SELF']}?classifieds_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']}?classifieds_mode=$myMode\" class=\"top_members_menu\" onclick=\"getHtmlData( 'show_classifieds', this.href+'&show_only=classifieds'); return false;\">$sTabTitle</a>
</div>";
}*/
}
/*$menu .= '
<div class="clear_both"></div>
</div>';*/
$iTotalNum = db_value("SELECT COUNT(*) FROM `ClassifiedsAdvertisements`\r\n\t\t\t\tWHERE DATE_ADD( `ClassifiedsAdvertisements`.`DateTime` , INTERVAL `ClassifiedsAdvertisements`.`LifeTime` DAY ) > NOW( )\r\n\t\t\t\tAND `ClassifiedsAdvertisements`.`Status` = 'active'\r\n\t\t\t");
$oClassifieds = new BxDolClassifieds();
$oClassifieds->UseDefaultCF();
if ($iTotalNum) {
$iResPerPage = (int) getParam("max_blogs_on_home");
$iTotalPages = ceil($iTotalNum / $iResPerPage);
$page = (int) $_REQUEST['classifieds_page'];
if ($page < 1 or $mode == 'rand') {
$page = 1;
}
if ($page > $iTotalPages) {
$page = $iTotalPages;
}
$sqlLimitFrom = ($page - 1) * $iResPerPage;
$sBlocks = $oClassifieds->GenAnyBlockContent($mode, 0, "LIMIT {$sqlLimitFrom}, {$iResPerPage}");
$ret = $sBlocks;
} else {
$ret .= '<div class="no_result"><div>' . _t("_No classifieds 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']}?classifieds_mode={$mode}&classifieds_page={$prevPage}", 'dynamic' => true, 'class' => 'backMembers');
//$sBackC = _t('_Back');
/*$retR .= <<<EOF
<a href="{$_SERVER['PHP_SELF']}?classifieds_mode={$mode}&classifieds_page={$prevPage}" class="backMembers" onclick="getHtmlData( 'show_classifieds', this.href+'&show_only=classifieds'); return false;">
{$sBackC}
</a>
EOF;*/
}
if ($page < $iTotalPages) {
$nextPage = $page + 1;
$aDBBottomMenu[_t('_Next')] = array('href' => "{$_SERVER['PHP_SELF']}?classifieds_mode={$mode}&classifieds_page={$nextPage}", 'dynamic' => true, 'class' => 'moreMembers');
/*$sNextC = _t('_Next');
$retR .= <<<EOF
<a href="{$_SERVER['PHP_SELF']}?classifieds_mode={$mode}&classifieds_page={$nextPage}" class="moreMembers" onclick="getHtmlData( 'show_classifieds', this.href+'&show_only=classifieds'); return false;">
{$sNextC}
</a>
EOF;*/
}
$sBMViewAllLink = $oClassifieds->bUseFriendlyLinks ? "{$site['url']}ads/" : "{$site['url']}classifieds.php?Browse=1";
$aDBBottomMenu[_t('_View All')] = array('href' => $sBMViewAllLink, 'dynamic' => false, 'class' => 'viewAllMembers');
//$ret .= '<div class="clear_both"></div></div>';
}
//return $ret;
return array($ret, $aDBTopMenu, $aDBBottomMenu);
}
