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; }