• TibiaFace

    Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...

    .
    demo menumenu

    Afiliados



    Votar:

    [Web] 8.60 Gessior 2012 Version 2017

    Compartir:

    Ver el tema anterior Ver el tema siguiente Ir abajo  Mensaje (Página 1 de 1.)

    1[Web] 8.60 Gessior 2012 Version 2017 Empty [Web] 8.60 Gessior 2012 Version 2017 Sáb Jun 10, 2017 9:56 pm

    Invitado

    Anonymous
    Invitado
    Hola mi amigo,
    Estoy aquí para compartir con ustedes un proyecto Gęsior 2012 Editado !!!

    Se tomo una buena editada el menú , con un estilo de gradiente.

    [Web] 8.60 Gessior 2012 Version 2017 Site

    Download:
    [Tienes que estar registrado y conectado para ver este vínculo]
    Scan: [Tienes que estar registrado y conectado para ver este vínculo]

    Creditos: Por Traerlo

    3 participantes

    2[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Sáb Jun 10, 2017 10:01 pm

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    que bien un aporte mas para la seccion de descargas de web (y)



    [Web] 8.60 Gessior 2012 Version 2017 YNU5B25
    3 participantes
    http://www.tibiaface.com

    3[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Lun Jul 31, 2017 9:58 am

    cimmeria

    cimmeria
    Miembro
    Miembro
    me sale este error

    Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\web2\pages\latestnews.php on line 43

    Fatal error: Call to a member function fetch() on boolean in C:\xampp\htdocs\web2\pages\latestnews.php on line 73


    Código:
    <?php

    $main_content .= '
    <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">Most powerful 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, 4;') as $guild)
            $main_content .= '              <td style="width: 25%; text-align: center;">
                            <a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img class="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>
    </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">';
                            $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'].'"></a>';
                            }
                            
                                                                    $news_content .= '
                                                                    <div id="TeaserText">
                                                                            <b>IP:</b> HardStyller.com</font> - <b>VERSION:</b> 8.60 - <b>PORT:</b> 7171 <b><a href="./downloads/pvp.exe">CLIENTE PR&Oacute;PRIO 8.60</a></b><br><br>
                                                                            &nbsp&nbsp&nbsp&nbsp&nbsp&nbspUtilizamos <b>Mapa Styller</b> várias quests, hunts, eventos e sistemas que irão tornar esse jogo um <b>Novo</b> mundo para vocês tibianos.<br>
                                                                            Faça parte dessa história, marque sua presença, e chame seu Team!!! Você não pode perder !!!<br>
                                                                            Possuímos <b>Bônus para iniciantes</b> no baú do templo, e <b>Dias Donate no Shop Guild</b> para times que entrarem.. Aproveite !!<br>
                                                                    </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, '[code]') !== false && stripos($text, '[/code]') !== false )
        {
            $code = substr($text, stripos($text, '[code]')+6, stripos($text, '[/code]') - stripos($text, '[code]') - 6);
            if(!is_int($rows / 2)) { $bgcolor = 'ABED25'; } else { $bgcolor = '23ED25'; } $rows++;
            $text = str_ireplace('[code]'.$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, '[quote]') !== false && stripos($text, '[/quote]') !== false )
        {
            $quote = substr($text, stripos($text, '[quote]')+7, stripos($text, '[/quote]') - stripos($text, '[quote]') - 7);
            if(!is_int($rows / 2)) { $bgcolor = 'AAAAAA'; } else { $bgcolor = 'CCCCCC'; } $rows++;
            $text = str_ireplace('[quote]'.$quote.'[/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);
        }
        $rows = 0;
        while(stripos($text, '[url]') !== false && stripos($text, '[/url]') !== false )
        {
            $url = substr($text, stripos($text, '[url]')+5, stripos($text, '[/url]') - stripos($text, '[url]') - 5);
            $text = str_ireplace('[url]'.$url.'[/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, '[img]') !== false && stripos($text, '[/img]') !== false )
        {
            $img = substr($text, stripos($text, '[img]')+5, stripos($text, '[/img]') - stripos($text, '[img]') - 5);
            $text = str_ireplace('[img]'.$img.'[/img]', '<img src="'.$img.'">', $text);
        }
        while(stripos($text, '[b]') !== false && stripos($text, '[/b]') !== false )
        {
            $b = substr($text, stripos($text, '[b]')+3, stripos($text, '[/b]') - stripos($text, '[b]') - 3);
            $text = str_ireplace('[b]'.$b.'[/b]', '<b>'.$b.'</b>', $text);
        }
        while(stripos($text, '[i]') !== false && stripos($text, '[/i]') !== false )
        {
            $i = substr($text, stripos($text, '[i]')+3, stripos($text, '[/i]') - stripos($text, '[i]') - 3);
            $text = str_ireplace('[i]'.$i.'[/i]', '<i>'.$i.'</i>', $text);
        }
        while(stripos($text, '[u]') !== false && stripos($text, '[/u]') !== false )
        {
            $u = substr($text, stripos($text, '[u]')+3, stripos($text, '[/u]') - stripos($text, '[u]') - 3);
            $text = str_ireplace('[u]'.$u.'[/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']) . '<br><p align="right"><a href="?subtopic=forum&action=show_thread&id=' . $thread['id'] . '">Comment click Here</a></p></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>';[/code][quote][url][img][b][i]
    [url][img][/img][/url]

    3 participantes
    http://sayayinz.ddns.net

    4[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Lun Jul 31, 2017 12:09 pm

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    cimmeria escribió:me sale este error

    Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\web2\pages\latestnews.php on line 43

    Fatal error: Call to a member function fetch() on boolean in C:\xampp\htdocs\web2\pages\latestnews.php on line 73


    Código:
    <?php

    $main_content .= '
    <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">Most powerful 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, 4;') as $guild)
            $main_content .= '              <td style="width: 25%; text-align: center;">
                            <a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img class="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>
    </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">';
                            $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'].'"></a>';
                            }
                            
                                                                    $news_content .= '
                                                                    <div id="TeaserText">
                                                                            <b>IP:</b> HardStyller.com</font> - <b>VERSION:</b> 8.60 - <b>PORT:</b> 7171 <b><a href="./downloads/pvp.exe">CLIENTE PR&Oacute;PRIO 8.60</a></b><br><br>
                                                                            &nbsp&nbsp&nbsp&nbsp&nbsp&nbspUtilizamos <b>Mapa Styller</b> várias quests, hunts, eventos e sistemas que irão tornar esse jogo um <b>Novo</b> mundo para vocês tibianos.<br>
                                                                            Faça parte dessa história, marque sua presença, e chame seu Team!!! Você não pode perder !!!<br>
                                                                            Possuímos <b>Bônus para iniciantes</b> no baú do templo, e <b>Dias Donate no Shop Guild</b> para times que entrarem.. Aproveite !!<br>
                                                                    </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, '[code]') !== false && stripos($text, '[/code]') !== false )
        {
            $code = substr($text, stripos($text, '[code]')+6, stripos($text, '[/code]') - stripos($text, '[code]') - 6);
            if(!is_int($rows / 2)) { $bgcolor = 'ABED25'; } else { $bgcolor = '23ED25'; } $rows++;
            $text = str_ireplace('[code]'.$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, '[quote]') !== false && stripos($text, '[/quote]') !== false )
        {
            $quote = substr($text, stripos($text, '[quote]')+7, stripos($text, '[/quote]') - stripos($text, '[quote]') - 7);
            if(!is_int($rows / 2)) { $bgcolor = 'AAAAAA'; } else { $bgcolor = 'CCCCCC'; } $rows++;
            $text = str_ireplace('[quote]'.$quote.'[/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);
        }
        $rows = 0;
        while(stripos($text, '[url]') !== false && stripos($text, '[/url]') !== false )
        {
            $url = substr($text, stripos($text, '[url]')+5, stripos($text, '[/url]') - stripos($text, '[url]') - 5);
            $text = str_ireplace('[url]'.$url.'[/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, '[img]') !== false && stripos($text, '[/img]') !== false )
        {
            $img = substr($text, stripos($text, '[img]')+5, stripos($text, '[/img]') - stripos($text, '[img]') - 5);
            $text = str_ireplace('[img]'.$img.'[/img]', '<img src="'.$img.'">', $text);
        }
        while(stripos($text, '[b]') !== false && stripos($text, '[/b]') !== false )
        {
            $b = substr($text, stripos($text, '[b]')+3, stripos($text, '[/b]') - stripos($text, '[b]') - 3);
            $text = str_ireplace('[b]'.$b.'[/b]', '<b>'.$b.'</b>', $text);
        }
        while(stripos($text, '[i]') !== false && stripos($text, '[/i]') !== false )
        {
            $i = substr($text, stripos($text, '[i]')+3, stripos($text, '[/i]') - stripos($text, '[i]') - 3);
            $text = str_ireplace('[i]'.$i.'[/i]', '<i>'.$i.'</i>', $text);
        }
        while(stripos($text, '[u]') !== false && stripos($text, '[/u]') !== false )
        {
            $u = substr($text, stripos($text, '[u]')+3, stripos($text, '[/u]') - stripos($text, '[u]') - 3);
            $text = str_ireplace('[u]'.$u.'[/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']) . '<br><p align="right"><a href="?subtopic=forum&action=show_thread&id=' . $thread['id'] . '">Comment click Here</a></p></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>';[/code][quote][url][img][b][i]
    [url][img][/img][/url]



    no tienes las tablas---- frags y ------- z_news_tickers



    [Web] 8.60 Gessior 2012 Version 2017 YNU5B25
    3 participantes
    http://www.tibiaface.com

    5[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Lun Jul 31, 2017 2:48 pm

    cimmeria

    cimmeria
    Miembro
    Miembro
    me podrias pasar las tablas que no las encuentro

    3 participantes
    http://sayayinz.ddns.net

    6[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Vie Nov 17, 2017 9:48 pm

    "♣Marre♣™"

    [Web] 8.60 Gessior 2012 Version 2017 462-68
    Miembro
    Miembro
    Me tira este error:
    Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\pages\latestnews.php on line 267

    esta es la linea que tira error
    $featured_article = $SQL->query("SELECT * FROM z_featured_article ORDER BY id DESC LIMIT 1")->fetchAll();

    3 participantes

    7[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Vie Nov 17, 2017 9:52 pm

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    "♣️Marre♣️™️" escribió:Me tira este error:
    Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\pages\latestnews.php on line 267

    esta es la linea que tira error
    $featured_article = $SQL->query("SELECT * FROM z_featured_article ORDER BY id DESC LIMIT 1")->fetchAll();

    aqui tienes

    Código:
    CREATE TABLE IF NOT EXISTS `z_featured_article` (
    `id` int(11) NOT NULL,
      `title` varchar(50) NOT NULL,
      `text` varchar(255) NOT NULL,
      `date` varchar(30) NOT NULL,
      `author` varchar(50) NOT NULL,
      `read_more` varchar(100) NOT NULL
    ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;



    [Web] 8.60 Gessior 2012 Version 2017 YNU5B25
    3 participantes
    http://www.tibiaface.com

    8[Web] 8.60 Gessior 2012 Version 2017 Empty Re: [Web] 8.60 Gessior 2012 Version 2017 Dom Nov 19, 2017 2:23 pm

    "♣Marre♣™"

    [Web] 8.60 Gessior 2012 Version 2017 462-68
    Miembro
    Miembro
    Este este pequeño error cuando trato de entrar a los highscores
    quien me puede ayudar Aqui el error
    [Web] 8.60 Gessior 2012 Version 2017 Sin_ty11

    Aqui este el Databaselist.php
    Código:
    <?php
    if(!defined('INITIALIZED'))
       exit;

    class DatabaseList extends DatabaseHandler implements Iterator, Countable
    {
       public $data;
       public $iterator = 0;
       public $class;
       public $table;
       public $tables = array();
       public $fields = array();
       public $extraFields = array();
       public $filter;
       public $orders = array();
       public $limit;
       public $offset = 0;

       public function __construct($class = null)
       {
          if($class !== null)
             $this->setClass($class);
       }

       public function load()
       {
          $fieldsArray = array();

          if(count($this->fields) > 0)
             foreach($this->fields as $fieldName)
                   $fieldsArray[$fieldName] = $this->getDatabaseHandler()->tableName($this->table) . '.' . $this->getDatabaseHandler()->fieldName($fieldName);

          if(count($this->extraFields) > 0)
             foreach($this->extraFields as $field)
                if(!$field->hasAlias())
                   $fieldsArray[] = $this->getDatabaseHandler()->tableName($field->getTable()) . '.' . $this->getDatabaseHandler()->fieldName($field->getName());
                else
                   $fieldsArray[] = $this->getDatabaseHandler()->tableName($field->getTable()) . '.' . $this->getDatabaseHandler()->fieldName($field->getName()) . ' AS ' . $this->getDatabaseHandler()->fieldName($field->getAlias());

          $tables = array();
          foreach($this->tables as $table)
             $tables[] = $this->getDatabaseHandler()->tableName($table);

          $filter = '';
          if($this->filter !== null)
             $filter = ' WHERE ' .$this->filter->__toString();

          $order = '';
          $orders = array();
          if(count($this->orders) > 0)
          {
             foreach($this->orders as $_tmp_order)
                $orders[] = $_tmp_order->__toString();
             if(count($orders) > 0)
                $order = ' ORDER BY ' . implode(', ', $orders);
          }

          $limit = '';
          if($this->limit !== null)
             $limit = ' LIMIT ' . (int) $this->limit;

          $offset = '';
          if($this->offset > 0)
             $offset = ' OFFSET ' . (int) $this->offset;

          $query = 'SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . implode(', ', $tables) . $filter . $order . $limit . $offset;

          $this->data = $this->getDatabaseHandler()->query($query)->fetchAll();
       }

       public function getResult($id)
       {
          if(!isset($this->data))
             $this->load();
          if(isset($this->data[$id]))
          {
             if(!is_object($this->data[$id]))
             {
                $_tmp = new $this->class();
                $_tmp->loadData($this->data[$id]);
                return $_tmp;
             }
             else
                return $this->data[$id];
          }
          else
             return false;
       }

       public function addExtraField($field)
       {
          $this->extraFields[] = $field;
          $this->addTables($field->getTable());
       }

       public function addOrder($order)
       {
          $this->orders[] = $order;
       }

       public function setClass($class)
       {
          $this->class = $class;
          $instance = new $this->class();
          $this->fields = $instance::$fields;
          if(isset($instance::$extraFields))
             foreach($instance::$extraFields as $extraField)
             {
                if(!isset($extraField[2]))
                   $this->extraFields[] = new SQL_Field($extraField[0], $extraField[1]);
                else
                   $this->extraFields[] = new SQL_Field($extraField[0], $extraField[1], $extraField[2]);
                $this->tables[$extraField[1]] = $extraField[1];
             }
          $this->table = $instance::$table;
          $this->tables[$instance::$table] = $instance::$table;
       }

       public function setFilter($filter)
       {
          $this->addTables($filter->getTables());
          $this->filter = $filter;
       }

       public function setLimit($limit)
       {
          $this->limit = $limit;
       }

       public function setOffset($offset)
       {
          $this->offset = $offset;
       }

       public function addTables($tables)
       {
          if(is_array($tables))
          {
             foreach($tables as $table)
                if($table != '' && !in_array($table, $this->tables))
                   $this->tables[$table] = $table;
          }
          elseif($tables != '' && !in_array($tables, $this->tables))
             $this->tables[$tables] = $tables;
       }

        public function current()
        {
            return $this->getResult($this->iterator);
        }

        public function rewind()
        {
          if(!isset($this->data))
             $this->load();
            $this->iterator = 0;
        }

        public function next()
        {
            ++$this->iterator;
        }

        public function key()
        {
            return $this->iterator;
        }

        public function valid()
        {
            return isset($this->data[$this->iterator]);
        }

        public function count()
        {
          if(!isset($this->data))
             $this->load();
            return count($this->data);
        }
    }

    3 participantes

    Contenido patrocinado


    3 participantes

    Ver el tema anterior Ver el tema siguiente Volver arriba  Mensaje (Página 1 de 1.)

    Permisos de este foro:
    No puedes responder a temas en este foro.

     

    BienvenidosTibiaFace es una comunidad de Open Tibia. Para participar debes estar registrado (click para Regístrate).