"; */ #error_reporting(E_ALL); #ini_set('display_errors', 1); setlocale(LC_ALL, 'de_DE@UTF8', 'de_DE', 'de', 'ge'); function further_publication($lid, $user_admin, $template) { include_once 'classes/lg-on_Smarty.class.php'; $smarty = new lgon_Smarty(); require_once("config.inc.php"); $templatename = "further_publication.html"; # bei dynamischem Inhalt nimmt er ansicht.html $db = dbconnect(); $query = "SELECT eid, upper(stichwort) upper_stichwort, stichwort, case_sensitive FROM lue_stichworte"; $result = $db->query($query) or die("Cannot execute query"); while ($row = $result->fetch_array()) { if($row['case_sensitive'] == 'N'){ $result1 = $db->query("SELECT count(*) Anz FROM quelle WHERE UPPER(Inhalt) REGEXP '[[:<:]]$row[upper_stichwort][[:>:]]' AND lid = $lid"); $row1 = $result1->fetch_array(); }else{ $result1 = $db->query("SELECT count(*) Anz FROM quelle WHERE BINARY Inhalt REGEXP '[[:<:]]$row[stichwort][[:>:]]' AND lid = $lid"); $row1 = $result1->fetch_array(); } if ($row1['Anz'] > 0) { $eids[] = $row['eid']; } } if (isset($eids)) { $eid_in = ""; for ($i = 0; $i < count($eids); $i++) { $eid_in .= "$eids[$i],"; } #echo substr($eid_in,0,-1); $query2 = "SELECT DISTINCT eid, thema, bezeichnung FROM lue_quelle a, lue_art b WHERE a.lueaid = b.lueaid AND a.eid IN (" . substr($eid_in, 0, -1) . ") ORDER BY eid DESC "; $result2 = $db->query($query2); while ($row2 = $result2->fetch_array()) { $value[] = $row2; } // Assign this array to smarty... $smarty->assign('table_data', $value); return $smarty->fetch("$template/$templatename"); }else{ return 0; } } #$lid = 5514; #$user_admin = 'schwaral'; #$template = 'standard'; #echo further_publication($lid, $user_admin, $template); ?>