Execute($getNews) or die(); $news_entry = array(); if($getNewsResults->NumRows() > 0){ while($getNewsResults && $row = $getNewsResults->FetchRow()){ $news_data = new stdClass(); $news_data->title = $row['title_'.$hl]; $text = strip_tags($row['text_'.$hl]); $string_limit = 100; if(mb_strlen($text, 'utf-8') > $string_limit) { $pos = mb_strpos($text, ' ', $string_limit, 'utf-8'); $text = mb_substr($text, 0, ($pos ? $pos : $string_limit), 'utf-8').'...'; } $news_data->text = $text; $time = strtotime($row['date']); $news_data->date = date('d/m/Y', $time); $news_data->url = gen_url($hl.'/news/'.$row['id'].'/'.pretty_url($news_data->title)); $news_entry[] = $news_data; } } $this->smarty->assign_by_ref('news_data', $news_entry); $this->smarty->assign('title',$this->Lang('friendlyname')); $this->smarty->assign('view_all',''.$this->Lang('view_all').''); echo $this->ProcessTemplate('view_random.tpl');