Tyson12302
New Member
- Joined
- Aug 6, 2014
- Messages
- 264
- Reaction score
- 4
I been looking at forums for such a long time and i tried all but the News Ticker still doesn't appear. Here are my codes/scripts
newsticker.js
latestnews.php
basic.css
newsticker.js
Code:
// status of the news ticker entries (0 = closed / 1 = open)
state = new Array("0", "0", "0", "0", "0");
function TickerAction(id) {
var line = id.substr(12, 1);
if(state[line] == "0") {
state[line] = "1";
OpenNews(id);
}
else {
state[line] = "0";
CloseNews(id);
}
}
function OpenNews(id)
{
var div = document.getElementById(id)
var idShort = id.concat("-ShortText");
var idMore = id.concat("-FullText");
var idButton = id.concat("-Button");
document.getElementById(idShort).style.display = "none";
document.getElementById(idMore).style.display = "block";
document.getElementById(idButton).style.backgroundImage = "url('<?PHP echo $layout_name; ?>/images/general/minus.gif')";
}
function CloseNews(id)
{
var div = document.getElementById(id)
var idShort = id.concat("-ShortText");
var idMore = id.concat("-FullText");
var idButton = id.concat("-Button");
document.getElementById(idShort).style.display = "block";
document.getElementById(idMore).style.display = "none";
document.getElementById(idButton).style.backgroundImage = "url('<?PHP echo $layout_name; ?>/images/general/plus.gif')";
}
[code]
basic.css
[code]
/* News Ticker */
.Content #NewsTicker .BoxContent {
padding: 5px;
min-height: 90px;
height: auto !important;
height: 100px;
}
.Content #NewsTicker .BoxContent .Row {
position: relative;
width: 100%;
}
.Content #NewsTicker .NewsTickerIcon {
position: absolute;
top: 1px;
left: 1px;
height: 16px;
width: 16px;
background-repeat: no-repeat;
}
.Content #NewsTicker .NewsTickerText {
font-size: 9pt;
position: relative;
margin-left: 20px;
}
.Content #NewsTicker .NewsTickerDate {
font-size: 7pt;
position: absolute;
top: 0px;
float: left;
}
.Content #NewsTicker .NewsTickerShortText {
margin-left: 85px;
height: 14px;
}
.Content #NewsTicker .NewsTickerFullText {
margin-left: 85px;
margin-right: 20px;
display: none;
}
.Content #NewsTicker .NewsTickerExtend {
position: relative;
right: 0px;
top: 1px;
right: 1px;
height: 12px;
width: 12px;
background-repeat: no-repeat;
float: right;
cursor: pointer;
z-index: 10;
}
latestnews.php
PHP:
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
$query = $SQL->query("SELECT * FROM `players` ORDER BY `experience` DESC")->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
//$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
///End Queries ///
// top kills - guilds
$main_content .= '<div class="NewsHeadline">
<div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
<table border="0">
<tr>
<td style="text-align: center; font-weight: bold;">
<font color="white">Most powerfull guilds</font>
</td>
</tr>
</table>
</div>
</div>
<table border="0" cellspacing="3" cellpadding="4" width="100%">
<tr>';
foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 3;') as $guild)
$main_content .= ' <td style="width: 25%; text-align: center;">
<a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guild_image.php?id=' . $guild['id'] . '" width="64" height="64" border="0"/> <br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills
</td>';
$main_content .= ' </tr>
</table>';
$main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Welcome to Neuofia
<tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>, player number '.$query2['id'].'. Welcome and wish you a nice game!</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
<table border=0 cellpadding=0 cellspacing=1 width=100%>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$housesfree[0].'</center></td>
<td><center><b>Rented Houses:</b> '.$housesrented[0].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>
<td><center><b>Players</b> in database: '.$players[0].'</center></td></tr>
<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Banned</b> accounts: '.$banned[0].'</center></td>
<td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr>
</table></td></tr></table>';
if($action == "") {
//show tickers if any in database or not blocked (tickers limit = 0)
$tickers = $SQL->query('SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;');
$number_of_tickers = 0;
if(is_object($tickers)) {
foreach($tickers as $ticker) {
if(is_int($number_of_tickers / 2))
$color = "Odd";
else
$color = "Even";
$tickers_to_add .= '<div id="TickerEntry-'.$number_of_tickers.'" class="Row" onclick=\'TickerAction("TickerEntry-'.$number_of_tickers.'")\'>
<div class="'.$color.'">
<div class="NewsTickerIcon" style="background-image: url('.$layout_name.'/images/news/icon_'.$ticker['image_id'].'.gif);"></div>
<div id="TickerEntry-'.$number_of_tickers.'-Button" class="NewsTickerExtend" style="background-image: url('.$layout_name.'/images/general/plus.gif);"></div>
<div class="NewsTickerText">
<span class="NewsTickerDate">'.date("j M Y", $ticker['date']).' -</span>
<div id="TickerEntry-'.$number_of_tickers.'-ShortText" class="NewsTickerShortText">';
basic.css
Code:
/* News Ticker */
.Content #NewsTicker .BoxContent {
padding: 5px;
min-height: 90px;
height: auto !important;
height: 100px;
}
.Content #NewsTicker .BoxContent .Row {
position: relative;
width: 100%;
}
.Content #NewsTicker .NewsTickerIcon {
position: absolute;
top: 1px;
left: 1px;
height: 16px;
width: 16px;
background-repeat: no-repeat;
}
.Content #NewsTicker .NewsTickerText {
font-size: 9pt;
position: relative;
margin-left: 20px;
}
.Content #NewsTicker .NewsTickerDate {
font-size: 7pt;
position: absolute;
top: 0px;
float: left;
}
.Content #NewsTicker .NewsTickerShortText {
margin-left: 85px;
height: 14px;
}
.Content #NewsTicker .NewsTickerFullText {
margin-left: 85px;
margin-right: 20px;
display: none;
}
.Content #NewsTicker .NewsTickerExtend {
position: relative;
right: 0px;
top: 1px;
right: 1px;
height: 12px;
width: 12px;
background-repeat: no-repeat;
float: right;
cursor: pointer;
z-index: 10;
}