portal
Foro 
Members 
Calendario 
Información 
Shop TibiaFace
Editar Perfil 
Temas Recientes 
4REYES 
1
featured article en gesior Jue Oct 26, 2023 11:52 am
Hokku
Miembro
Hola buenas gente de tibia face, tengo un problema a la hora de ver el featured article en mi web. Uso TFS 1.1 y gesior 2012 editado
esta parte no consigo que saque los datos de la data base
La parte de mi latestnews:
La pagina en la db:
- Código:
$featured_article = $SQL->query("SELECT `z_featured_article`.`read_more` AS `read_more`, `z_featured_article`.`text` AS `text`, `z_featured_article`.`title` AS `title`, `z_featured_article`.`id` AS `id`, `z_featured_article`.`date` AS `date` FROM `z_featured_article` ORDER BY `date` DESC LIMIT 1;")->fetchAll();
esta parte no consigo que saque los datos de la data base
La parte de mi latestnews:
- Código:
//FEATURED ARTICLE
$featured_article = $SQL->query("SELECT `z_featured_article`.`read_more` AS `read_more`, `z_featured_article`.`text` AS `text`, `z_featured_article`.`title` AS `title`, `z_featured_article`.`id` AS `id`, `z_featured_article`.`date` AS `date` FROM `z_featured_article` ORDER BY `date` 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
La pagina en la db:
