/** * Print news */ function printNewsList() { global $news_limit_chars; global $short_date_format; global $tmpl; $bNewsFriendly = getParam('permalinks_news') == 'on' ? true : false; $res = getNewsList(); ob_start(); if (!mysql_num_rows($res)) { ?> <div class="no_news"> <?php echo _t("_No news available"); ?> </div> <?php } else { while ($news_arr = mysql_fetch_array($res)) { ?> <div class="news_cont"> <div class="clear_both"></div> <div class="news_header"> <a href="<?php echo getNewsUrl($news_arr['newsID'], $news_arr['NewsUri'], $bNewsFriendly); ?> "> <?php echo process_line_output($news_arr['Header']); ?> </a> </div> <div class="news_date"><?php echo date(str_replace('%', '', $short_date_format), $news_arr['Date']); ?> </div> <div class="news_snippet"> <?php echo process_html_output($news_arr['Snippet']); ?> </div> <div class="clear_both"></div> </div> <?php } } return ob_get_clean(); }
function MemberPrintNews() { global $site; global $short_date_format; $bNewsFriendly = getParam('permalinks_news') == 'on' ? true : false; $res = getNewsList(); if (!$res) { return; } echo "<table cellspacing=1 cellpadding=2 class=small width='100%'>\n"; if (!mysql_num_rows($res)) { echo "<tr class=panel><td align=center>No news available.</td></tr>\n"; } while ($news_arr = mysql_fetch_array($res)) { $news_header = process_line_output($news_arr['Header']); $sNewsUrl = getNewsUrl($news_arr['newsID'], $news_arr['NewsUri'], $bNewsFriendly); echo "\r\n\t\t\t<tr >\r\n\t\t\t\t<td align=center width=15%>\r\n\t\t\t\t\t<a href=\"news.php?edit_id={$news_arr['newsID']}\">Edit</a> |\r\n\t\t\t\t\t<a href=\"news.php?action=delete&delete_id={$news_arr['newsID']}\">Delete</a>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td align=center width=15%>" . date(str_replace('%', '', $short_date_format), $news_arr['Date']) . "</td>\r\n\t\t\t\t<td aling=left> <a target='_blank' href='{$sNewsUrl}'>{$news_header}</a></td>\r\n\t\t\t</tr>\n"; } echo "</table>\n"; }
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 newsHome() { if (isset($_GET['Page'])) { $page = $_GET['Page']; } else { $page = 1; } if (isset($_GET['NewsType'])) { $listType = $_GET['NewsType']; if ($listType == "Search") { $criteria = $_GET['criteria']; $results = getGeneralNewsSearch($criteria, $page); $emailCountTemp = getNewsListCountSearch($criteria); //url for moving to different pages $queryUrl = "NewsType=Search&criteria={$criteria}"; } } else { //get the news items for the proper page, and display $results = getNewsList($page); $newsCountTemp = getNewsListCount(); } if (count($results) == 0) { //no news items are found, returns nothing $errorMsg = "No Items were found."; include '../view/errorPage.php'; } else { if (count($results) == 1) { $row = $results[0]; include '../view/newsDisp.php'; } else { //$emailCountTemp is part of an array, only index $newsCount = ceil($newsCountTemp[0] / 50); include '../view/news.php'; } } }
insertNews($db, $_POST['title'], $_POST['newscontent'], $usr->getProperty('user_id')); } else { updateNewsContent($db, $_POST['id'], $_POST['title'], $_POST['newscontent'], $usr->getProperty('user_id')); } } } $category = 'general'; if (isset($_GET['mode']) && $_GET['mode'] == "edit") { if (!isset($_GET['id']) && !is_numeric($_GET['id'])) { die('Missing news id'); } $news = getNewsContent($db, $_GET['id']); } elseif (isset($_GET['mode']) && $_GET['mode'] == "insert") { $news = getNewsContent($db, 0); } else { $news = getNewsList($db, $category); } $tpl =& new HTML_Template_IT('./'); $tpl->loadTemplatefile('admin.tpl', true, true); // assign the content to the vars $tpl->setVariable('USER', $usr->getProperty('handle')); $tpl->setVariable('NEWS', $news); $tpl->show(); /** * Returns news list * for a given category * * @param object &$db a reference to a db connection object * @param string $category news category */ function getNewsList(&$db, $category)
echo date('d/m/Y - H.i', strtotime($blog['registered'])); ?> </td></tr> <?php // print_r($active); ?> <?php } print '</table>'; break; case 'newsList': include 'xtecfunc.php'; $ipp = 20; print '<h2 style="color: #1C4387; font-size: 1.3em; background-image: none; border: none; margin-bottom: 1em; margin-top: 1em;">Llista de notícies publicades</h2>'; $init = isset($_REQUEST['init']) && $_REQUEST['init'] != '' ? $_REQUEST['init'] : 1; $newsList = getNewsList(); print '<div style="text-align:right; padding-right:60px;">' . $pager . '</div><br/ >'; print '<table>'; print '<th align="left" valign="top">Títol</th><th align="left" valign="top">Data de publicació</th>'; $bgcolor = "#e5f2fe"; foreach ($newsList as $new) { $bgcolor = $bgcolor == '#e5f2fe' ? '#ffffff' : '#e5f2fe'; ?> <tr bgcolor="<?php echo $bgcolor; ?> "> <td width="250"><a href=index.php?id=<?php echo $new['newId']; ?> title="Vés a la notícia"><?php
echo '尚未指定關鍵字,關鍵字格式:keyword1,keyword2,keyword3...'; } else { $three_month_before_str = date("Y-m-d", strtotime("-3 month")); $year_str = substr($three_month_before_str, 0, 4); $month_str = substr($three_month_before_str, 5, 2); $temp_key = $_POST["MyKeywordLList"]; //echo 'temp_key:'.$temp_key; $keyword_array = explode(",", $temp_key); $conn = getConnection('news_db'); $data_list = array(); for ($i = 0; $i < sizeof($keyword_array); $i++) { $data_list[$i] = getNewsStatistics_V1($year_str, $month_str, $conn, $keyword_array[$i]); } $ary = array(); for ($i = 0; $i < sizeof($keyword_array); $i++) { $ary = getNewsList($conn, $keyword_array[$i], $ary); //var_dump($ary); } $newslist = $ary; //$newslist=getNewsList($conn); } ?> <form action="./news.php" method="post" id="mform" class="form-horizontal"> <div class="row"> <div class='col-md-12'> <div class="form-group"> <label>請指定關鍵字</label> <div class='input-group date' id='my_keyword'> <input type='text' class="form-control" id="MyKeyword" name="MyKeywordLList" value=""/>
{ $sql = "select YEAR(n.ndate), MONTH(n.ndate) from newsarticles n group by YEAR(n.ndate),MONTH(n.ndate) order by YEAR(n.ndate) asc ,MONTH(n.ndate) asc"; $result = mysql_query($sql) or die('MySQL query error'); $ary = array(); while ($row = mysql_fetch_array($result)) { $ary[] = $row[0]; $ary[] = $row[1]; } mysql_free_result($result); return $ary; } $conn = getConnection('jared'); $newsdlist = getNewsDateList($conn); $ary1 = getNewsStatistics($conn, '麗嬰房'); $ary2 = getNewsStatistics($conn, '奇哥'); $newslist = getNewsList($conn); ?> <link href="./assets/c3.css" rel="stylesheet" type="text/css"> <script src="./assets/d3.min.js" charset="utf-8"></script> <script src="./assets/c3.min.js"></script> <script src="./assets/js/jQDateRangeSlider.js"></script> <script> $(document).ready(function () { $("#slider").dateRangeSlider(); }); </script> <div id="chart"></div> <div class="row"> <div class="col-sm-2"></div>