keywords,1); $related = array(); if(!empty($module->keywords) and !empty($module->keywords[0])) { $sql = $obj->frontListSql($site->id, 1,array()); $sql->limit(10,0); $q= array(); foreach($module->keywords as $v) { $q[] = " s.keywords ilike '%$v%' "; } $sql->where(' ( '.implode('or',$q).' ) '); $sql->where('s.id!='.$module->id); //echo $sql; $res = $obj->fetchAll($sql); $related = array(); //_dp($res); foreach($res as $v) { $related[] = array( 'title' => $v['name'], 'url' => Telekom_Cms_Url_Default::getUrl(array( 'siteId' => $site->id, 'subsiteId' => $v['id'], 'lang' => 'pl', 'name' => Telekom_Cms::disablePhpCode($v['name']), 'get' => null )), 'date' => cmsTplParam('Day'.date('N',strtotime($v->create_date))).', '.date('j',strtotime($v->create_date)).' '.cmsTplParam('Month'.date('m',strtotime($v->create_date))).' '.date('Y',strtotime($v->create_date)), ); } } //_dp($related,1); ?>