function printNewsPanel($iLimit = 0, $iPreview = 128)
{
global $site;
$php_date_format = getParam('php_date_format');
// news
$news_limit_chars = getParam("max_news_preview");
$bNewsFriendly = getParam('permalinks_news') == 'on' ? true : false;
$news_res = getNewsList($iLimit);
$news_count = db_arr("SELECT COUNT(*) FROM `News`");
$news_counter = $news_count['0'];
$ret = '';
if ($news_counter > 0) {
while ($news_arr = mysql_fetch_assoc($news_res)) {
$ret .= '<div class="newsWrap">';
$ret .= '<div class="newsHead">';
$ret .= '<a href="' . getNewsUrl($news_arr['newsID'], $news_arr['NewsUri'], $bNewsFriendly) . '">';
$ret .= process_line_output($news_arr['Header']);
$ret .= '</a>';
$ret .= '</div>';
//$ret .= '<div class="newsInfo"><img src="' . getTemplateIcon( 'clock.gif' ) . '" />' . date( $php_date_format, $news_arr['Date'] ) . '</div>';
$ret .= '<div class="newsInfo"><img src="' . getTemplateIcon('clock.gif') . '" />' . LocaledDataTime($news_arr['Date']) . '</div>';
$ret .= '<div class="newsText">';
//$ret .= process_text_withlinks_output( $news_arr['Snippet'] );
$ret .= process_html_output($news_arr['Snippet']);
$ret .= '</div>';
$ret .= '</div>';
}
if ($news_counter > $max_news_on_home) {
$sNewsLink = $bNewsFriendly ? $site['url'] . 'news/' : $site['url'] . 'news.php';
$ret .= '<div class="newsReadMore">';
$ret .= '<a href="' . $sNewsLink . '">' . _t("_Read news in archive") . '</a>';
$ret .= '</div>';
}
} else {
$ret .= '<div class="no_result"><div>' . _t("_No news available") . '</div></div>';
}
return $ret;
}
function GenAnyBlockContent($sOrder = 'last', $iProfileID = 0, $sLimit = "LIMIT 5")
{
global $site;
global $short_date_format;
$php_date_format = getParam('php_date_format');
$iBlogLimitChars = (int) getParam("max_blog_preview");
$sClockIcon = getTemplateIcon('clock.gif');
$sOrderS = '';
switch ($sOrder) {
case 'last':
$sOrderS = "ORDER BY `EventStart` DESC";
break;
case 'latest':
$sOrderS = "ORDER BY `EventStart` DESC";
break;
case 'rand':
$sOrderS = "ORDER BY RAND()";
break;
case 'first':
$sOrderS = "ORDER BY `EventStart` ASC";
break;
}
$sProfileS = $iProfileID > 0 ? "(`SDatingEvents`.`ResponsibleID` = '{$iProfileID}' OR `SDatingParticipants`.`IDMember` = '{$iProfileID}')" : '1';
$sQuery = "\r\n\t\t\tSELECT DISTINCT `SDatingEvents`. * , `Profiles`.`NickName` ,\r\n\t\t\tUNIX_TIMESTAMP( `SDatingEvents`.`EventStart` ) AS `DateTime_f` \r\n\t\t\tFROM `SDatingEvents` \r\n\t\t\tINNER JOIN `Profiles` ON `Profiles`.`ID` = `SDatingEvents`.`ResponsibleID` \r\n\t\t\tLEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent` = `SDatingEvents`.`ID` \r\n\t\t\tWHERE {$sProfileS}\r\n\t\t\tAND `SDatingEvents`.`Status` = 'Active'\r\n\t\t\t{$sOrderS}\r\n\t\t\t{$sLimit}\r\n\t\t";
$rBlogs = db_res($sQuery);
if (!mysql_num_rows($rBlogs)) {
return MsgBox(_t('_Sorry, nothing found'));
}
$sBlocks = '';
while ($aBlog = mysql_fetch_assoc($rBlogs)) {
$sPic = $this->GetEventPicture($aBlog['ID']);
$sGenUrl = $this->genUrl($aBlog['ID'], $aBlog['EntryUri']);
$sLinkMore = '';
if (strlen($aBlog['Description']) > $iBlogLimitChars) {
$sLinkMore = "... <a href=\"{$sGenUrl}\">" . _t('_Read more') . "</a>";
}
$sBlogSnippet = mb_substr(strip_tags($aBlog['Description']), 0, $iBlogLimitChars) . $sLinkMore;
//$sDataTimeFormatted = date( $php_date_format, $aBlog['DateTime_f'] );
$sDataTimeFormatted = LocaledDataTime($aBlog['DateTime_f']);
$sBlocks .= <<<EOF
<div class="blog_block">
\t<div class="icon_block">
\t\t{$sPic}
\t</div>
\t<div class="blog_wrapper_n">
\t\t<div class="blog_subject_n">
\t\t\t<a href="{$sGenUrl}" class="bottom_text">
\t\t\t\t{$aBlog['Title']}
\t\t\t</a>
\t\t</div>
\t\t<div class="blogInfo">
\t\t\t<span><img src="{$sClockIcon}" alt="" />{$sDataTimeFormatted} </span>
\t\t</div>
\t\t<div class="blogSnippet">
\t\t\t{$sBlogSnippet}
\t\t</div>
\t</div>
</div>
<div class="clear_both"></div>
EOF;
}
if ($sBlocks == '') {
$sBlocks = MsgBox(_t('_Sorry, nothing found'));
}
return $sBlocks;
}
function GenAnyBlockContent($sOrder = 'last', $iProfileID = 0, $sLimit = "LIMIT 5")
{
global $site;
global $short_date_format;
$php_date_format = getParam('php_date_format');
$iBlogLimitChars = (int) getParam("max_blog_preview");
$sClockIcon = getTemplateIcon('clock.gif');
$sOrderS = '';
switch ($sOrder) {
case 'last':
$sOrderS = "ORDER BY `BlogPosts`.`PostDate` DESC";
break;
case 'latest':
$sOrderS = "ORDER BY `BlogPosts`.`PostDate` DESC";
break;
case 'rand':
$sOrderS = "ORDER BY RAND()";
break;
case 'top':
$sOrderS = "ORDER BY `CommentsNum` DESC";
break;
}
$sProfileS = $iProfileID > 0 ? "`BlogCategories`.`OwnerID` = '{$iProfileID}'" : '1';
$oCmts = new BxDolCmts('blogposts', 0, 0);
$sQuery = "\n\t\t\tSELECT DISTINCT\n\t\t\t\t`BlogPosts`.`PostID`,\n\t\t\t\t`BlogPosts`.`CategoryID`,\n\t\t\t\t`BlogCategories`.`OwnerID`,\n\t\t\t\t`BlogPosts`.`PostText`,\n\t\t\t\tUNIX_TIMESTAMP( `BlogPosts`.`PostDate` ) AS `PostDate_f`,\n\t\t\t\t`BlogPosts`.`PostCaption`,\n\t\t\t\t`BlogPosts`.`PostUri`,\n\t\t\t\t`BlogCategories`.`CategoryName`,\n\t\t\t\t`BlogCategories`.`CategoryUri`,\n\t\t\t\t`Profiles`.`ID` AS `ProfID`,\n\t\t\t\t`Profiles`.`NickName` AS `NickName`,\n\t\t\t\tCOUNT( `tc`.`cmt_id` ) AS `CommentsNum`\n\t\t\tFROM `BlogCategories`\n\t\t\tLEFT JOIN `BlogPosts`\n\t\t\t\tON `BlogPosts`.`CategoryID` = `BlogCategories`.`CategoryID`\n\t\t\tINNER JOIN `Profiles`\n\t\t\t\tON `BlogCategories`.`OwnerID` = `Profiles`.`ID`\n\t\t\tLEFT JOIN `" . $oCmts->getCommentsTableName() . "` AS `tc` ON\n\t\t\t\t`BlogPosts`.`PostID` = `tc`.`cmt_object_id`\n\t\t\tWHERE\n\t\t\t\t{$sProfileS} AND\n\t\t\t\t`BlogPosts`.`PostReadPermission` = 'public' AND\n\t\t\t\t`BlogPosts`.`PostStatus` = 'approval'\n\t\t\tGROUP BY `BlogPosts`.`PostID`\n\t\t\t{$sOrderS}\n\t\t\t{$sLimit}\n\t\t";
$rBlogs = db_res($sQuery);
if (!mysql_num_rows($rBlogs)) {
return MsgBox(_t('_Sorry, nothing found'));
}
$sBlocks = '';
while ($aBlog = mysql_fetch_assoc($rBlogs)) {
$sLinkMore = '';
$aUser = array('Permalink' => $aBlog['NickName'], 'Link' => $aBlog['OwnerID']);
$aPost = array('Permalink' => $aBlog['PostUri'], 'Link' => $aBlog['PostID']);
$aCat = array('Permalink' => $aBlog['CategoryUri'], 'Link' => $aBlog['CategoryID']);
$sLinkMoreUrl = $this->genBlogLink('show_member_post', $aUser, '', $aPost);
$sCatLink = $this->genBlogLink('show_member_blog', $aUser, $aCat);
if (strlen($aBlog['PostText']) > $iBlogLimitChars) {
$sLinkMore = "... <a href=\"" . $sLinkMoreUrl . "\">" . _t('_Read more') . "</a>";
}
$sBlogSnippet = mb_substr(strip_tags($aBlog['PostText']), 0, $iBlogLimitChars) . $sLinkMore;
//$sDataTimeFormatted = date( $php_date_format, $aBlog['PostDate_f'] );
$sDataTimeFormatted = LocaledDataTime($aBlog['PostDate_f']);
$sCategF = _t('_in Category', getTemplateIcon('folder_small.png'), $sCatLink, $aBlog['CategoryName']);
$sCommF = _t('_comments N', getTemplateIcon('add_comment.gif'), $aBlog['CommentsNum']);
$sProfileF = $iProfileID > 0 ? '' : '<span>' . _t('_By Author', $aBlog['NickName'], $aBlog['NickName']) . '</span>';
$sBlocks .= <<<EOF
<div class="blogBlock">
\t<div class="blogHead">
\t\t<a href="{$sLinkMoreUrl}" class="bottom_text">
\t\t\t{$aBlog['PostCaption']}
\t\t</a>
\t</div>
\t<div class="blogInfo">
\t\t{$sProfileF}
\t\t<span><img src="{$sClockIcon}" alt="" />{$sDataTimeFormatted}</span>
\t\t<span>{$sCategF} </span>
\t\t<span>{$sCommF}</span>
\t</div>
\t<div class="blogSnippet">
\t\t{$sBlogSnippet}
\t</div>
</div>
<div class="clear_both"></div>
EOF;
}
if ($sBlocks == '') {
$sBlocks = MsgBox(_t('_Sorry, nothing found'));
}
return $sBlocks;
}
function GenAnyBlockContent($sOrder = 'latest', $iProfileID = 0, $sLimit = "LIMIT 5")
{
global $site;
$php_date_format = getParam('php_date_format');
$iBlogLimitChars = (int) getParam("max_blog_preview");
$sClockIcon = getTemplateIcon('clock.gif');
$sOrderS = '';
switch ($sOrder) {
case 'latest':
$sOrderS = 'ORDER BY `Groups`.`created` DESC';
break;
case 'rand':
$sOrderS = 'ORDER BY RAND()';
break;
}
$sProfileS = '1';
$sGrpJoin = '';
if ($iProfileID > 0) {
$sGrpJoin = 'INNER JOIN `GroupsMembers` ON `GroupsMembers`.`groupID`=`Groups`.`ID` ';
$sProfileS = <<<EOF
`GroupsMembers`.`memberID` = '{$iProfileID}' AND
`GroupsMembers`.`status` = 'Active'
EOF;
} else {
$sProfileS = "`Groups`.`Status` = 'Active'";
}
//INNER JOIN `GroupsCateg` ON `GroupsCateg`.`ID` = `Groups`.`categID`
//`GroupsCateg`.`Name` AS 'CategName', `GroupsCateg`.`Uri` as `CategUri`
$sQuery = "\r\n\t\t\tSELECT DISTINCT `Groups`.`ID`, `Groups`.`Name`, `Groups`.`Uri`, `Groups`.`categID` AS `CategID`,\r\n\t\t\tLEFT(`Groups`.`Desc`, {$iBlogLimitChars}) as 'Desc_f', \r\n\t\t\tUNIX_TIMESTAMP( `Groups`.`created` ) as `DateTime_f`,\r\n\t\t\t`Profiles`.`NickName`\r\n\t\t\tFROM `Groups`\r\n\t\t\tINNER JOIN `Profiles` ON `Profiles`.`ID` = `Groups`.`creatorID` \r\n\t\t\t{$sGrpJoin}\r\n\t\t\tWHERE\r\n\t\t\t{$sProfileS}\r\n\t\t\t{$sOrderS}\r\n\t\t\t{$sLimit}\r\n\t\t";
$rBlog = db_res($sQuery);
if (!mysql_num_rows($rBlog)) {
return MsgBox(_t('_Sorry, nothing found'));
}
$sRet = '';
$sFolderIco = getTemplateIcon('folder_small.png');
//$sRet .= '<div class="clear_both"></div>';
while ($arr = mysql_fetch_array($rBlog)) {
$sPic = $this->GetGroupPicture($arr['ID']);
$aCategInfo = db_arr("SELECT `GroupsCateg`.`Name` AS 'CategName', `GroupsCateg`.`Uri` as `CategUri` FROM `GroupsCateg` WHERE `ID`='{$arr['CategID']}' LIMIT 1;");
$sCategName = $aCategInfo['CategName'];
$sCategUri = $aCategInfo['CategUri'];
$sLinkMore = '';
$sGroupLink = $this->getGroupUrl($arr['ID'], $arr['Uri']);
if (strlen($arr['Desc']) == $iBlogLimitChars) {
$sLinkMore = "... <a href=\"" . $sGroupLink . "\">" . _t('_Read more') . "</a>";
}
$sAuthor = $iProfileID > 0 ? '' : '<span>' . _t('_By Author', $arr['NickName'], $arr['NickName']) . '</span>';
$sName = process_line_output($arr['Name']);
//$sDateF = date( $php_date_format, $arr['DateTime_f'] );
$sDateF = LocaledDataTime($arr['DateTime_f']);
//$sDateF = LocaledDataTime( $arr['DateTime_f'], 3 );
$sCategory = _t('_in Category', $sFolderIco, $this->getGroupsCategUrl($arr['CategID'], $sCategUri), process_line_output($sCategName));
$sDescr = strip_tags(process_html_output($arr['Desc_f']));
$sRet .= <<<EOF
<div>
\t<div class="icon_block">
\t\t{$sPic}
\t</div>
\t<div class="blog_wrapper_n">
\t\t<div class="blog_subject_n">
\t\t\t<a href="{$sGroupLink}" class="bottom_text">
\t\t\t\t{$sName}
\t\t\t</a>
\t\t</div>
\t\t<div class="blogInfo">
\t\t\t{$sAuthor}
\t\t\t<span>
\t\t\t\t<img src="{$sClockIcon}" alt="" />{$sDateF}
\t\t\t</span>
\t\t\t<span>{$sCategory}</span>
\t\t</div>
\t\t<div class="blog_text">
\t\t\t{$sDescr}{$sLinkMore}
\t\t</div>
\t</div>
</div>
<div class="clear_both"></div>
EOF;
}
if ($sBlocks == '') {
$sBlocks = MsgBox(_t('_Sorry, nothing found'));
}
return $sRet;
}
function GenAnyBlockContent($sOrder = 'last', $iProfileID = 0, $sLimit = "LIMIT 5")
{
global $site;
global $short_date_format;
$php_date_format = getParam('php_date_format');
$iBlogLimitChars = (int) getParam("max_blog_preview");
$sClockIcon = getTemplateIcon('clock.gif');
$sOrderS = '';
switch ($sOrder) {
case 'last':
$sOrderS = "ORDER BY `DateTime` DESC";
break;
case 'latest':
$sOrderS = "ORDER BY `DateTime` DESC";
break;
case 'rand':
$sOrderS = "ORDER BY RAND()";
break;
case 'top':
$sOrderS = "ORDER BY `CommCount` DESC";
break;
}
$sProfileS = $iProfileID > 0 ? "`ClassifiedsAdvertisements`.`IDProfile` = '{$iProfileID}'" : '1';
$sTimeAddon = $iProfileID > 0 ? '' : "AND DATE_ADD(`ClassifiedsAdvertisements`.`DateTime` , INTERVAL `ClassifiedsAdvertisements`.`LifeTime` DAY) > NOW()";
$oCmts = new BxDolCmts('classifieds', 0, 0);
$sQuery = "\r\n\t\t\tSELECT DISTINCT\r\n\t\t\t`ClassifiedsAdvertisements`.`ID`,\r\n\t\t\t`ClassifiedsAdvertisements`.`Subject`,\r\n\t\t\t`ClassifiedsAdvertisements`.`EntryUri`,\r\n\t\t\t`ClassifiedsAdvertisements`.`Media`,\r\n\t\t\t`Profiles`.`NickName`,\r\n\t\t\tUNIX_TIMESTAMP( `ClassifiedsAdvertisements`.`DateTime` ) as `DateTime_f`,\r\n\t\t\t`ClassifiedsAdvertisements`.`DateTime`,\r\n\t\t\t`Classifieds`.`Name`, `Classifieds`.`CEntryUri`, `Classifieds`.`ID` AS `CatID`,\r\n\t\t\t`ClassifiedsSubs`.`NameSub`, `ClassifiedsSubs`.`SEntryUri`, `ClassifiedsSubs`.`ID` AS `SubCatID`,\r\n\t\t\t`ClassifiedsAdvertisements`.`Message`,\r\n\t\t\tCOUNT(`tc`.`cmt_id`) AS 'CommCount'\r\n\t\t\tFROM `ClassifiedsAdvertisements`\r\n\t\t\tLEFT JOIN `ClassifiedsSubs`\r\n\t\t\tON `ClassifiedsSubs`.`ID`=`ClassifiedsAdvertisements`.`IDClassifiedsSubs`\r\n\t\t\tLEFT JOIN `Classifieds`\r\n\t\t\tON `Classifieds`.`ID`=`ClassifiedsSubs`.`IDClassified`\r\n\t\t\tLEFT JOIN `Profiles` ON `Profiles`.`ID`=`ClassifiedsAdvertisements`.`IDProfile`\r\n\t\t\tLEFT JOIN `" . $oCmts->getCommentsTableName() . "` AS `tc` ON `tc`.`cmt_object_id`=`ClassifiedsAdvertisements`.`ID`\r\n\t\t\tWHERE\r\n\t\t\t{$sProfileS}\r\n\t\t\tAND `ClassifiedsAdvertisements`.`Status` = 'active'\r\n\t\t\t{$sTimeAddon}\r\n\t\t\tGROUP BY `ClassifiedsAdvertisements`.`ID`\r\n\t\t\t{$sOrderS}\r\n\t\t\t{$sLimit}\r\n\t\t";
$rBlogs = db_res($sQuery);
if (!mysql_num_rows($rBlogs)) {
return MsgBox(_t('_Sorry, nothing found'));
}
$sBlocks = '';
while ($aBlog = mysql_fetch_assoc($rBlogs)) {
if ($sOrder == 'top' && $aBlog['CommCount'] == 0) {
continue;
}
$sPic = $this->getImageCode($aBlog['Media'], TRUE);
$sGenUrl = $this->genUrl($aBlog['ID'], $aBlog['EntryUri']);
$sGenCUrl = $this->bUseFriendlyLinks && $this->bAdminMode == false ? $site['url'] . 'ads/cat/' . $aBlog['CEntryUri'] : "{$this->sCurrBrowsedFile}?bClassifiedID={$aBlog['CatID']}";
$sGenSCUrl = $this->bUseFriendlyLinks && $this->bAdminMode == false ? $site['url'] . 'ads/subcat/' . $aBlog['SEntryUri'] : "{$this->sCurrBrowsedFile}?bSubClassifiedID={$aBlog['SubCatID']}";
$sLinkMore = '';
if (strlen($aBlog['Message']) > $iBlogLimitChars) {
$sLinkMore = "... <a href=\"{$sGenUrl}\">" . _t('_Read more') . "</a>";
}
$sBlogSnippet = mb_substr(strip_tags($aBlog['Message']), 0, $iBlogLimitChars) . $sLinkMore;
//$sDataTimeFormatted = date( $php_date_format, $aBlog['DateTime_f'] );
$sDataTimeFormatted = LocaledDataTime($aBlog['DateTime_f']);
$sInCatFormatted = _t('_in Category', getTemplateIcon('ad_category.gif'), $sGenCUrl, process_line_output($aBlog['Name']));
$sSubNameF = process_line_output($aBlog['NameSub']);
$sCommentsF = _t('_comments N', getTemplateIcon('add_comment.gif'), $aBlog['CommCount']);
$sSubjectF = process_line_output($arr['Subject']);
$sBlocks .= <<<EOF
<div class="blog_block">
\t<div class="icon_block">
\t\t<div class="thumbnail_block" style="float:left;">
\t\t\t<a href="{$sGenUrl}" class="bottom_text">
\t\t\t\t{$sPic}
\t\t\t</a>
\t\t</div>
\t</div>
\t<div class="blog_wrapper_n">
\t\t<div class="blog_subject_n">
\t\t\t<a href="{$sGenUrl}" class="bottom_text">
\t\t\t\t{$sSubjectF}
\t\t\t</a>
\t\t</div>
\t\t<div class="blogInfo">
\t\t\t<span><img src="{$sClockIcon}" alt="" />{$sDataTimeFormatted} </span>
\t\t\t<span>{$sInCatFormatted} / <a href="{$sGenCUrl}">{$sSubNameF}</a></span>
\t\t\t<span>{$sCommentsF}</span>
\t\t</div>
\t\t<div class="blogSnippet">
\t\t\t{$sBlogSnippet}
\t\t</div>
\t</div>
</div>
<div class="clear_both"></div>
EOF;
}
if ($sBlocks == '') {
$sBlocks = MsgBox(_t('_Sorry, nothing found'));
}
return $sBlocks;
}
function getBlockCode_Articles()
{
$php_date_format = getParam('php_date_format');
$oArticles = new BxDolArticles(false);
$iArticlesLimit = (int) getParam('number_articles');
$iArticlesLimit = $iArticlesLimit != 0 ? $iArticlesLimit : 1;
$rArticles = $oArticles->getArticlesResource($iArticlesLimit);
$ret = '';
$iArticlesIndex = mysql_num_rows($rArticles);
if ($iArticlesIndex) {
while ($aArticle = mysql_fetch_assoc($rArticles)) {
//$sDate = date( $php_date_format, strtotime( $aArticle['Date'] ) );
$sDate = LocaledDataTime($aArticle['Date_UTS']);
$sCategUrl = $oArticles->getArticleCatUrl($aArticle['CategoryID']);
$sArticleUrl = $oArticles->getArticleUrl($aArticle['ArticlesID']);
$sText = strip_tags($aArticle['Text']);
if (strlen($sText) > 200) {
$sText = mb_substr($sText, 0, 200) . '[...]';
}
$ret .= '<div class="rss_item_wrapper">';
$ret .= '<div class="rss_item_header">';
$ret .= '<a href="' . $sArticleUrl . '">';
$ret .= htmlspecialchars_adv($aArticle['Title']);
$ret .= '</a>';
$ret .= '</div>';
$ret .= '<div class="rss_item_info">';
$ret .= '<span><img src="' . getTemplateIcon('clock.gif') . '" alt="" />' . $sDate . '</span><span>' . _t('_in Category', getTemplateIcon('folder_small.png'), $sCategUrl, htmlspecialchars_adv($aArticle['CategoryName'])) . '</span>';
$ret .= '</div>';
$ret .= '<div class="rss_item_desc">';
$ret .= $sText;
$ret .= '</div>';
$ret .= '</div>';
}
$iArticlesCount = db_value("SELECT COUNT(*) FROM `Articles`");
$sMoreLink = $oArticles->isPermalinkEnabled() ? 'articles/' : 'articles.php';
if ($iArticlesCount > $iArticlesIndex) {
$ret .= '<div class="rss_read_more">';
$ret .= '<a href="' . $GLOBALS['site']['url'] . $sMoreLink . '">';
$ret .= _t('_Read All Articles');
$ret .= '</a>';
$ret .= '</div>';
}
} else {
$ret .= '<div class="no_result"><div>';
$ret .= _t("_No articles available");
$ret .= '</div></div>';
}
return $ret;
}
