Ajuda gesior

Postado Junho 26, 2017 7 anos

Não estou conseguindo colocar meu site online.. ele da o seguinte problema

Citar

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\pages\latestnews.php on line 86

Configurações que eu coloquei em C:\xampp\htdocs\htdocs\config.ini

Citar

install = "yes"server_path = "D:\OT 2017\OT/"
signatures = "1"

Configuração C:\xampp\htdocs\config.ini

Citar

install = "yes"server_path = "D:\OT 2017\OT/"
signatures = "1"

Configuração C:\xampp\htdocs\config.php

Citar

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "D:\OT 2017\OT/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'Helltera');
$towns_list[0] = array(5 => 'Thais',4 => 'Kazordoon', 1 => 'Yalahar', 3 => 'Abdendriel', 2 => 'Carlin');

$config['site']['outfit_images_url'] = '/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/960/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';
$config['site']['players_group_id_block'] = 3;
$config['site']['limitDeath'] = 5;
$config['site']['levelVideo'] = 150;

# PAGE: donate.php
$config['site']['usePagseguro'] = true; //true show / false hide
$config['site']['usePaypal'] = true;   //true show / false hide
$config['site']['useDeposit'] = true;   //true show / false hide
$config['site']['useZaypay'] = true;   //true show / false hide
$config['site']['useContenidopago'] = true;   //true show / false hide
$config['site']['useOnebip'] = true;   //true show / false hide

# Pagseguro config By IVENSPONTES
$config['pagSeguro']['email'] = "[email protected]"; //Email Pagseguro
$config['pagSeguro']['token'] = "C05E31D66406438D84A667BB279B5F25"; // TOKEN
$config['pagSeguro']['urlRedirect'] = 'http://helltera-global.servegame.com:8090/?subtopic=donate&action=final'; //turn off redirect and notifications in pagseguro.com.br
$config['pagSeguro']['urlNotification'] = 'http://helltera-global.servegame.com:8090/retpagseguro.php'; //your return location

$config['pagSeguro']['productName'] = 'Premium Points';
$config['pagSeguro']['productValue'] = 1.00;    // 1.50 = R$ 1,50 etc...
$config['pagSeguro']['doublePoints'] = false;    ## Double points - true is on / false is off

$config['pagSeguro']['host'] = 'localhost';       ## YOUR HOST
$config['pagSeguro']['database'] = 'tibia';   ## DATABASE
$config['pagSeguro']['databaseUser'] = 'root';   ## USER
$config['pagSeguro']['databasePass'] = '5tpuhfkiaj';       ## PASSWORD

# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 999;
$config['site']['send_register_email'] = false;

# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'][0] = array(1, 2, 3, 4, 5);
$config['site']['max_players_per_account'] = 15;
$config['site']['show_health_information'] = 1; //Show health bar
$config['site']['show_mana_information'] = 1; //Show mana bar
$config['site']['show_exp_information'] = 1; //Show exp bar
$config['site']['number_of_advances'] = 5; // number of latest skill advances to show on character page

# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "smtp.xxxxx.com.br";
$config['site']['smtp_port'] = 587;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxx";

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/

# PAGE: characters.php
$config['site']['quests'] = array('Annihilator' => 5010,'Demon Helmet' => 50025,'Pits of Inferno' => 10547,'Blue Legs' => 7616,'Inquisition' => 8560,'Demon Oak' => 12900,'Yalahar' => 50001,'Quest VIP' => 1670);
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 0;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['generate_new_reckey'] = true;
$config['site']['generate_new_reckey_price'] = 500;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 1;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;
$config['site']['access_tickers'] = 3;
$config['site']['access_admin_painel'] = 3;
$config['site']['access_staff_painel'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6, 7);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: shopsystem.php
$config['site']['shop_system'] = true;
$config['site']['shopguild_system'] = 1;

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

# Layout Config
$config['site']['layout'] = 'tibiarl';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;

Citar

Mention

Postado Junho 26, 2017 7 anos

Poste aqui o código que tem no arquivo latestnews.php (fica em htdocs/pages/ )

Feliz daquele que ensina o que sabe, e aprende o que ensina.

Citar

Mention

Postado Junho 26, 2017 7 anos

Autor

Citar
<?php
$main_content .= '
<div align="center">
                   <p>
                       <strong>
                           <font style="text-decoration: inherit; text-shadow:#000 1px -1px 2px, #000 -1px 1px 2px, #000 1px 1px 2px, #000 -1px -1px 2px" size="4px" color="white">Bem vindo ao <font color="#00FF00">'.$config['server']['serverName'].'</font></font>
                       </strong><br />
                       <strong>
                           IP:<u>'.$config['server']['ip'].'</u>
                       </strong><br />

                       <strong>
                           Cliente: 8.60
                       </strong><br />
                       <strong>
                           Porta: '.$config['server']['loginPort'].'
                       </strong></div><br>
<div class="InnerTableContainer">
   <table>
       <tbody>
           <tr>
               <td>
                   <div class="TableShadowContainerRightTop">
                       <div class="TableShadowRightTop" style="background-image: url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
                   </div>
                       <div class="TableContentAndRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-rm.gif);">

<div class="TableContentContainer">
                               <table class="TableContent" style="border: 1px solid #faf0d7;">
                                   <tbody>
                                       <tr style="background-color: #505050;">
                                       </tr>
                                           <tr class="Table" style="background-color: #d4c0a1;">
                                               <td style="width: 800; border: 1px; border-style: solid; border-color: #FAF0D7;">
                                                   <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"><a href="?subtopic=guildwar"><font color="white">Most powerful guilds</font></a></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`.`guild_logo` 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, 4;') 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 /><font color="black">' . $guild['name'] . '</font></a><br />' . $guild['frags'] . ' kills
                                                   </td>';
                                               $main_content .= '

                                                                           </tr>
                                                                       </table>
                                                                   </td>
                                                               </tr>
                                                           </tbody>
                                                       </table>
                                                   </div>
                                               </div>
                                           <div class="TableShadowContainer">
                                       <div class="TableBottomShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bm.gif);">
                                   <div class="TableBottomLeftShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
                               <div class="TableBottomRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
                           </div>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div>
<br />
';
if(!defined('INITIALIZED'))
   exit;

$tickerSql = $SQL->query("SELECT ");
//NEWSTICKER
$time = time();
$vTick = $SQL->query("SELECT " .$SQL->fieldName('date'). " FROM " .$SQL->tableName('z_news_tickers'). " WHERE " .$SQL->fieldName('hide_ticker'). " = '0'")->fetch();
if(isset($vTick['date'])){

$news_content .= '
   <div id="NewsTicker" class="Box">
   <div class="Corner-tl" style="background-image: url('.$layout_name.'/images/content/corner-tl.gif);"></div>
   <div class="Corner-tr" style="background-image: url('.$layout_name.'/images/content/corner-tr.gif);"></div>
   <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>
   <div class="BorderTitleText" style="background-image: url('.$layout_name.'/images/content/title-background-green.gif);"></div>
   <img class="Title" src="'.$layout_name.'/images/header/headline-newsticker.gif" alt="Contentbox headline" />
       <div class="Border_2">
           <div class="Border_3">
           <div class="BoxContent" style="background-image: url('.$layout_name.'/images/content/scroll.gif);">';
                   //##################### ADD NEW TICKER #####################
                   if($action == "newticker") {
                       if($group_id_of_acc_logged >= $config['site']['access_tickers']) {
                           $ticker_text = stripslashes(trim($_POST['new_ticker']));
                           $ticker_icon = (int) $_POST['icon_id'];
                           if(empty($ticker_text)) {
                               $news_content .= 'You can\'t add empty ticker.';
                           }
                           else
                           {
                           if(empty($ticker_icon)) {
                               $news_icon = 0;
                           }
                   $SQL->query('INSERT INTO '.$SQL->tableName('z_news_tickers').' (date, author, image_id, text, hide_ticker) VALUES ('.$SQL->quote($time).', '.$account_logged->getId().', '.$ticker_icon.', '.$SQL->quote($ticker_text).', 0)');
                   $news_content .= '
                       <center>
                           <h2>
                               <font color="red">Added new ticker:</font>
                           </h2>
                       </center>
                       <hr/>
                       <div id="newsticker" class="Box">
                           <div id="TickerEntry-1" class="Row" onclick=\'TickerAction("TickerEntry-1")\'>
                               <div class="Odd">
                               <div class="NewsTickerIcon" style="background-image: url('.$layout_name.'/images/news/icon_'.$ticker['image_id'].'.gif);"></div>
                               <div id="TickerEntry-1-Button" class="NewsTickerExtend" style="background-image: url('.$layout_name.'/images/general/plus.gif);"></div>
                               <div class="NewsTickerText">
                                       <span class="NewsTickerDate">'.date("d/m/Y", $time).' -</span>
                                       <div id="TickerEntry-1-ShortText" class="NewsTickerShortText">';
                   $news_content .= '
                       <a href="?subtopic=latestnews&action=deleteticker&id='.$time.'">
                           <img src="'.$layout_name.'/images/news/delete.png" border="0">
                       </a>';
                   $news_content .= short_text($ticker_text, 60).'</div>
                   <div id="TickerEntry-1-FullText" class="NewsTickerFullText">';
                   $news_content .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$time.'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';
                   $news_content .= $ticker_text.'
                       </div>
               </div>
               </div>
           </div>
       </div>
   <hr/>';
   }
}
else
{
   $news_content .= 'You don\'t have admin rights. You can\'t add new ticker.';
}
   $news_content .= '<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form>';
}
//#################### DELETE (HIDE only!) TICKER ############################
if($action == "deleteticker") {
if($group_id_of_acc_logged >= $config['site']['access_tickers']) {
header("Location: ");
$date = (int) $_REQUEST['id'];
$SQL->query('UPDATE '.$SQL->tableName('z_news_tickers').' SET hide_ticker = 1 WHERE '.$SQL->fieldName('date').' = '.$date.';');
$news_content .= '<center>News tickets with <b>date '.date("j F Y, g:i a", $date).'</b> has been deleted.<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center></div></div>
</div>
<div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>
<div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>
<div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div>
</div>';
}
else
{
$news_content .= '<center>You don\'t have admin rights. You can\'t delete tickers.<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}
}
//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 5;');
$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("d/m/Y", $ticker['date']).' -</span>
<div id="TickerEntry-'.$number_of_tickers.'-ShortText" class="NewsTickerShortText">';
//if admin show button to delete (hide) ticker
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
$tickers_to_add .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$ticker['date'].'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';
}
$tickers_to_add .= short_text($ticker['text'], 60).'</div>
<div id="TickerEntry-'.$number_of_tickers.'-FullText" class="NewsTickerFullText">';
//if admin show button to delete (hide) ticker
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
$tickers_to_add .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$ticker['date'].'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';
}
$tickers_to_add .= $ticker['text'].'</div>
</div>
</div>
</div>';
$number_of_tickers++;
}
}
}

//adding news
if($action == "newnews") {
if($group_id_of_acc_logged >= $config['site']['access_news']) {
$text = ($_REQUEST['text']);
$char_id = (int) $_REQUEST['char_id'];
$post_topic = stripslashes(trim($_REQUEST['topic']));
$smile = (int) $_REQUEST['smile'];
$news_icon = (int) $_REQUEST['icon_id'];
if(empty($news_icon)) {
$news_icon = 0;
}
if(empty($post_topic)) {
$an_errors[] .= 'You can\'t add news without topic.';
}
if(empty($text)) {
$an_errors[] .= 'You can\'t add empty news.';
}
if(empty($char_id)) {
$an_errors[] .= 'Select character.';
}
//execute query
if(empty($an_errors)) {
$SQL->query("INSERT INTO `z_forum` (`id` ,`first_post` ,`last_post` ,`section` ,`replies` ,`views` ,`author_aid` ,`author_guid` ,`post_text` ,`post_topic` ,`post_smile` ,`post_date` ,`last_edit_aid` ,`edit_date`, `post_ip`, `icon_id`) VALUES ('NULL', '0', '".time()."', '1', '0', '0', '".$account_logged->getId()."', '".(int) $char_id."', ".$SQL->quote($text).", ".$SQL->quote($post_topic).", '".(int) $smile."', '".time()."', '0', '0', '".$_SERVER['REMOTE_ADDR']."', '".$news_icon."')");
$thread_id = $SQL->lastInsertId();
$SQL->query("UPDATE `z_forum` SET `first_post`=".(int) $thread_id." WHERE `id` = ".(int) $thread_id);//show added data
$main_content .= '<form action="index.php?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form>';
}
else
{
//show errors
$main_content .= '<div class="SmallBox" > <div class="MessageContainer" > <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="ErrorMessage" > <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';
foreach($an_errors as $an_error) {
   $main_content .= '<li>'.$an_error;
}
$main_content .= '</div> <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> </div></div><br/>';
//okno edycji newsa z wpisanymi danymi przeslanymi wczesniej
$main_content .= '<form action="index.php?subtopic=latestnews&action=newnews" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="'.$layout_name.'/images/news/icon_0.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_1.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_2.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_3.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="F1E0C6"><b>Topic:</b></td><td><input type="text" name="topic" maxlenght="50" style="width: 300px" value="'.$post_topic.'"></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>News<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="text" rows="6" cols="60">'.$text.'</textarea></td></tr><tr><td width="180"><b>Character:</b></td><td><select name="char_id"><option value="0">(Choose character)</option>'.$str.'</select></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="CancelAddNews" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="location.href=\'index.php?subtopic=latestnews\';" alt="CancelAddNews" /></div></div></td></tr></table>';
}
}
else
{
$main_content .= 'You don\'t have site-admin rights. You can\'t add news.';}
}

if(!empty($tickers_to_add)) {
//show table with tickers

if($group_id_of_acc_logged >= $config['site']['access_admin_panel'] && $action!=newticker)
$news_content .= '<script type="text/javascript">
var showednewticker_state = "0";
function showNewTickerForm()
{
if(showednewticker_state == "0") {
document.getElementById("newtickerform").innerHTML = \'<form action="?subtopic=latestnews&action=newticker" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="images/news/icon_0.gif" width="20"></td><td><img src="images/news/icon_1.gif" width="20"></td><td><img src="images/news/icon_2.gif" width="20"></td><td><img src="images/news/icon_3.gif" width="20"></td><td><img src="images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>New<br>ticker<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="new_ticker" rows="3" cols="45"></textarea></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></td></tr></table>\';
document.getElementById("jajo").innerHTML = \'\';
showednewticker_state = "1";
}
else {
document.getElementById("newtickerform").innerHTML = \'\';
document.getElementById("jajo").innerHTML = \'<div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div>\';
showednewticker_state = "0";
}
}
</script><div id="newtickerform"></div><div id="jajo"><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></div><hr/>';
//add tickers list
$news_content .= $tickers_to_add;
//koniec
$news_content .= '</div>
</div>
</div>
<div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>
<div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>
<div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div>
</div>';
}
//NEWSTICKER END

//FEATURED ARTICLE
$featured_article = $SQL->query("SELECT * FROM z_featured_article ORDER BY id DESC LIMIT 1")->fetchAll();

if(isset($featured_article[0]))
{
foreach($featured_article as $featured)
{

           $news_content .= '
               <div id="FeaturedArticle" class="Box">
                   <div class="Corner-tl" style="background-image:url('.$layout_name.'/images/content/corner-tl.gif);"></div>
                   <div class="Corner-tr" style="background-image:url('.$layout_name.'/images/content/corner-tr.gif);"></div>
                   <div class="Border_1" style="background-image:url('.$layout_name.'/images/content/border-1.gif);"></div>
                   <div class="BorderTitleText" style="background-image:url('.$layout_name.'/images/content/title-background-green.gif);"></div>
                   <img id="ContentBoxHeadline" class="Title" src="'.$layout_name.'/images/header/headline-featuredarticle.gif" alt="Contentbox headline" />
                   <div class="Border_2">
                       <div class="Border_3">
                           <div class="BoxContent" style="background-image:url('.$layout_name.'/images/content/scroll.gif);">
                               <div id="TeaserThumbnail">';
                               if(!empty($featured['read_more'])){
                                   $news_content .= '
                                   <a href="'.$featured['read_more'].'">';
                               }
                               $news_content .= '
                                       <img src="'.$layout_name.'/images/news/announcement.jpg" width="150" height="100" border=0 alt="" />';
                               if(!empty($featured['read_more'])){
                               $news_content .= '
                                   </a>';
                                   }
                           $news_content .= '
                               </div>';
                               if(!empty($featured['read_more'])){
                               $news_content .= '
                               <a id="Link" href="'.$featured['read_more'].'">» read more</a>';
                               }
                               $news_content .= '
                               <div id="TeaserText">
                                   <div style="position: relative; top: -2px; margin-bottom: 2px;" >
                                       <b>'.$featured['title'].'</b>
                                   </div>
                                   '.$featured['text'].'
                               </div>
                           </div>
                       </div>
                   </div>
                   <div class="Border_1" style="background-image:url('.$layout_name.'/images/content/border-1.gif);"></div>
                   <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image:url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>
                   <div class="CornerWrapper-b"><div class="Corner-br" style="background-image:url('.$layout_name.'/images/content/corner-br.gif);"></div></div>
               </div>
           ';
       }
   }
//FEATURED ARTICLE END

function replaceSmile($text, $smile)
{
$smileys = array(
                       ':p' => 1,
                       ':eek:' => 2,
                       ':rolleyes:' => 3,
                       ';)' => 4,
                       ':o' => 5,
                       ':D' => 6,
                       ':(' => 7,
                       ':mad:' => 8,
                       ':)' => 9,
                       ':cool:' => 10
                   );
if($smile == 1)
return $text;
else
{
foreach($smileys as $search => $replace)
$text = str_replace($search, '<img src="layouts/tibiarl/images/forum/smile/'.$replace.'.gif" />', $text);
return $text;
}
}

function replaceAll($text, $smile)
{
$rows = 0;
while(stripos($text, '
') !== false && stripos($text, '
') !== false )
{
$code = substr($text, stripos($text, '
')+6, stripos($text, '
') - stripos($text, '
') - 6);
		        if(!is_int($rows / 2)) { $bgcolor = 'ABED25'; } else { $bgcolor = '23ED25'; } $rows++;
		        $text = str_ireplace('[code]'.$code.'
', '<i>Code:</i><br /><table cellpadding="0" style="background-color: #'.$bgcolor.'; width: 480px; border-style: dotted; border-color: #CCCCCC; border-width: 2px"><tr><td>'.$code.'</td></tr></table>', $text);
}
$rows = 0;
while(stripos($text, '

') !== false && stripos($text, '

') !== false )
{
$quote = substr($text, stripos($text, '

')+7, stripos($text, '

') - stripos($text, '

') - 7);

if(!is_int($rows / 2)) { $bgcolor = 'AAAAAA'; } else { $bgcolor = 'CCCCCC'; } $rows++;
$text = str_ireplace('
}
$rows = 0;
while(stripos($text, '') !== false && stripos($text, '') !== false )
{
$url = substr($text, stripos($text, '')+5, stripos($text, '') - stripos($text, '') - 5);
$text = str_ireplace(''.$url.'', '<a href="'.$url.'" target="_blank">'.$url.'</a>', $text);
}
while(stripos($text, '[player]') !== false && stripos($text, '[/player]') !== false )
{
$player = substr($text, stripos($text, '[player]')+8, stripos($text, '[/player]') - stripos($text, '[player]') - 8);
$text = str_ireplace('[player]'.$player.'[/player]', '<a href="?subtopic=&name='.urlencode($player).'">'.$player.'</a>', $text);
}
   while(stripos($text, '[letter]') !== false && stripos($text, '[/letter]') !== false )
{
$letter = substr($text, stripos($text, '[letter]')+8, stripos($text, '[/letter]') - stripos($text, '[letter]') - 8);
$text = str_ireplace('[letter]'.$letter.'[/letter]', '<img src="images/letters/letter_martel_'.$letter.'.gif">', $text);
}
while(stripos($text, '') !== false )
{
$img = substr($text, stripos($text, '') - stripos($text, '') - 5);
$text = str_ireplace('', '<img src="'.$img.'">', $text);
}
while(stripos($text, '') !== false && stripos($text, '') !== false )
{
$b = substr($text, stripos($text, '')+3, stripos($text, '') - stripos($text, '') - 3);
$text = str_ireplace(''.$b.'', '<b>'.$b.'</b>', $text);
}
while(stripos($text, '') !== false && stripos($text, '') !== false )
{
$i = substr($text, stripos($text, '')+3, stripos($text, '') - stripos($text, '') - 3);
$text = str_ireplace(''.$i.'', '<i>'.$i.'</i>', $text);
}
while(stripos($text, '') !== false && stripos($text, '') !== false )
{
$u = substr($text, stripos($text, '')+3, stripos($text, '') - stripos($text, '') - 3);
$text = str_ireplace(''.$u.'', '<u>'.$u.'</u>', $text);
}
return replaceSmile($text, $smile);
}
function showPost($topic, $text, $smile)
{
$text = nl2br($text);
$post = '';
if(!empty($topic))
$post .= '<b>'.replaceSmile($topic, $smile).'</b>';
$post .= replaceAll($text, $smile);
return $post;
}

if($group_id_of_acc_logged >= $config['site']['access_admin_panel'] && $action != 'newnews')
   {
       $main_content .= '
           <font style="font-size: 16px; font-weight: bold; margin-left: 20px;">Adding News</font>
           <form action="index.php?subtopic=latestnews&action=newnews" method="post" >
               <table border="0">
                   <tr>
                       <td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td>
                       <td>
                           <table border="0">
                               <tr bgcolor="F1E0C6">
                                   <td><img src="'.$layout_name.'/images/news/icon_0.gif" width="20"></td>
                                   <td><img src="'.$layout_name.'/images/news/icon_1.gif" width="20"></td>
                                   <td><img src="'.$layout_name.'/images/news/icon_2.gif" width="20"></td>
                                   <td><img src="'.$layout_name.'/images/news/icon_3.gif" width="20"></td>
                                   <td><img src="'.$layout_name.'/images/news/icon_4.gif" width="20"></td>
                               </tr>
                               <tr bgcolor="D4C0A1">
                                   <td><input type="radio" name="icon_id" value="0" checked="checked"></td>
                                   <td><input type="radio" name="icon_id" value="1" /></td>
                                   <td><input type="radio" name="icon_id" value="2" /></td>
                                   <td><input type="radio" name="icon_id" value="3" /></td>
                                   <td><input type="radio" name="icon_id" value="4" /></td>
                               </tr>
                           </table>
                       </td>
                   </tr>
               <tr>
                   <td align="center" bgcolor="F1E0C6"><b>Topic:</b></td>
                   <td><input type="text" name="topic" maxlenght="50" style="width: 300px" ></td>
               </tr>
               <tr>
                   <td align="center" bgcolor="D4C0A1"><b>News<br>text:</b></td>';
               //Tiny Editor
               $main_content .= '
                   <script type="text/javascript" src="'.$layout_name.'/tiny_mce/tiny_mce.js"></script>
                   <script type="text/javascript">
                       tinyMCE.init({
                           // General options
                           mode : "textareas",
                           theme : "advanced",
                           plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave,visualblocks",

                           // Theme options
                           theme_advanced_buttons1 : "newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
                           theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,link,unlink,anchor,image,cleanup,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
                           theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,ltr,rtl",
                           theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft,visualblocks",
                           theme_advanced_toolbar_location : "top",
                           theme_advanced_toolbar_align : "left",
                           theme_advanced_statusbar_location : "bottom",
                           theme_advanced_resizing : true,

                           // Example content CSS (should be your site CSS)
                           content_css : "css/content.css",

                           // Drop lists for link/image/media/template dialogs
                           template_external_list_url : "lists/template_list.js",
                           external_link_list_url : "lists/link_list.js",
                           external_image_list_url : "lists/image_list.js",
                           media_external_list_url : "lists/media_list.js",

                           // Style formats
                           style_formats : [
                               {title : \'Bold text\', inline : \'b\'},
                               {title : \'Red text\', inline : \'span\', styles : {color : \'#ff0000\'}},
                               {title : \'Red header\', block : \'h1\', styles : {color : \'#ff0000\'}},
                               {title : \'Example 1\', inline : \'span\', classes : \'example1\'},
                               {title : \'Example 2\', inline : \'span\', classes : \'example2\'},
                               {title : \'Table styles\'},
                               {title : \'Table row 1\', selector : \'tr\', classes : \'tablerow1\'}
                           ],

                           // Replace values for the template plugin
                           template_replace_values : {
                               username : "Some User",
                               staffid : "991234"
                           }
                       });
                   </script>';
               $main_content .= '
                   <td bgcolor="F1E0C6">
                       <textarea name="text" id="elm1" rows="6" cols="60"></textarea>
                   </td>
               </tr>
               <tr>
                   <td width="180"><b>Character:</b></td>
                   <td>
                       <select name="char_id">
                       <option value="0">(Choose character)</option>';
                           foreach($account_logged->getPlayers() as $player)
                           {
                           $main_content .= '<option value="'.$player->getID().'">'.$player->getName().'</option>';
                           }
                           $main_content .= '
                       </select>
                   </td>
               </tr>
               <tr>
                   <td>
                       <div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div>
                       <input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" >
                   </div>
               </div>
           </form>
       </td>
   </tr>
</table>
<hr/>
';
}

$last_threads = $SQL->query('SELECT ' . $SQL->tableName('players') . '.' . $SQL->fieldName('name') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_text') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_topic') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('icon_id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_smile') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('replies') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_date') . ' FROM ' . $SQL->tableName('players') . ', ' . $SQL->tableName('z_forum') . ' WHERE ' . $SQL->tableName('players') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('author_guid') . ' AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('section') . ' = 1 AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('first_post') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ' ORDER BY ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('last_post') . ' DESC LIMIT ' . $config['site']['news_limit'])->fetchAll();

   //Here start news
if(isset($last_threads[0]))
{
foreach($last_threads as $thread)
{
$main_content .= '

               <div class="NewsHeadline">
                   <div class="NewsHeadlineBackground" style="background-image:url('.$layout_name.'/images/news/newsheadline_background.gif)">
                       <img src="'.$layout_name.'/images/news/icons/newsicon_'.$thread['icon_id'].'.gif" class="NewsHeadlineIcon" alt=\'\' />
                       <div class="NewsHeadlineDate">'.date('M m Y', $thread['post_date']).' -</div>
                   <div class="NewsHeadlineText">'.htmlspecialchars($thread['post_topic']).'</div>
                   </div>
               </div>


               <table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'>
               <tr>';
$main_content .= '
               <td style=\'padding-left:10px;padding-right:10px;\' >' . showPost('', $thread['post_text'], $thread['post_smile']) . '</td>';

           $main_content .= '
               <td>
                   <img src="'.$layout_name.'/images/global/general/blank.gif" width=10 height=1 border=0 alt=\'\' />
               </td>
           </tr>
       </table><br />';
       }
}
else
$main_content .= '<h3>No news. Go forum and make new thread on board News.</h3>';
   ?>

'.$quote.'

', '<table cellpadding="0" style="background-color: #'.$bgcolor.'; width: 480px; border-style: dotted; border-color: #007900; border-width: 2px"><tr><td>'.$quote.'</td></tr></table>', $text);