<?php

/*-------------------------------------------------------+

| NEWS TICKER PANEL V7.2

+--------------------------------------------------------+

| by Edan Boy Atun Pedragosa alias HACKERSOFT

| Web: http://hackersoft.biz

+--------------------------------------------------------+

| This program is released as free software under the

| Affero GPL license. You can redistribute it and/or

| modify it under the terms of this license which you

| can read by viewing the included agpl.txt or online

| at www.gnu.org/licenses/agpl.html. Removal of this

| copyright header is strictly prohibited without

| written permission from the original author(s).

+--------------------------------------------------------*/

if (!defined("IN_FUSION")) { die("Access Denied"); }

if (file_exists(INFUSIONS."news_ticker_panel/locale/".$settings['locale'].".php")) {

   include INFUSIONS."news_ticker_panel/locale/".$settings['locale'].".php";

} else {

   include INFUSIONS."news_ticker_panel/locale/English.php";

}

require_once INFUSIONS."news_ticker_panel/config.php";



$rows = dbcount("(news_id)", DB_NEWS, groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'");

if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }

if ($rows) {

   $result = dbquery(

      "SELECT tn.*, tc.*, user_id, user_name FROM ".DB_NEWS." tn

      LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id

      LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id

      WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'

      ORDER BY news_sticky DESC, news_datestamp DESC LIMIT ".$_GET['rowstart']."," . $NewsItemMax

   );

   $numrows = dbrows($result);

   $count = 0; 

   $NewsItems = '';

   while ($data = dbarray($result)) {

      $NewsItems .= "<li style='".($count == 0 ? "" : "display:none;")."'><a href='".BASEDIR."news.php?readmore=".$data['news_id']."'><i>" . showdate("%A, %d %B %Y ", $data['news_datestamp']) . "</i> - <b>" .  $data['news_subject'] . "</b></a></li>";

      $count = 1;

   }

}



opentable($locale['NTP_000']);

echo "<ul id='news_ticker' style='display:block; list-style-type: none; padding: 3px; margin: 0;font-size: 12px;'>".$NewsItems."</ul>";

closetable();

echo "<script language='JavaScript' type='text/javascript' src='".INFUSIONS."news_ticker_panel/scripts/jquery.innerfade.js'></script>";

echo "<script language='JavaScript' type='text/javascript'>$('ul#news_ticker').innerfade({

                  animationtype: '".$AnimationType."',

                  speed: ".$AnimationSpeed.",

                  timeout: ".$AnimationTimeout.",

                  type: '".$AnimationOrder."',

                  containerheight: '18px'

               });

   </script>";

?>