Aktualno
### headlines.php - added [v1.12] // Automatically get $tpath to avoid possible security holes $tpath = realpath(__FILE__); $tpath = substr($tpath,0,strrpos($tpath,DIRECTORY_SEPARATOR)+1); // Check if the file exists on local server and include it if(file_exists($tpath . "cn_config.php")) { require_once($tpath . "cn_config.php"); } else { die("Could not include required configuration file"); } // Check if a connection to the database was established if(!isset($link)) { die("Please make sure the \"\$tpath\" veriable is the root path to where 'headlines.php' is on your server."); } // Page URL to link the news items if(!isset($page)) { $page = "/index.php"; } // Set limit for number of items displayed if(!isset($lim)) { $lim = "5"; } // Number of characters to cut news titles at if(!isset($charnum)) { $charnum = "200"; } // Get news items from database, and order them from newest to oldest if($c != "") { $t_news .= " WHERE cat = '$c'"; } //$q['info'] = mysql_query("SELECT * FROM $t_news ORDER BY date DESC LIMIT 0, $lim", $link); $q['info'] = mysql_query("select n.id, n.subject as subject, n.date as date, u.user as user, c.id as catid, c.name as name from cn_news n inner join cn_users u on n.author = u.id inner join cn_cats c on n.cat = c.id order by date desc limit 0, $lim", $link); while($h = mysql_fetch_array($q['info'], MYSQL_ASSOC)) { // Edit the HTML code below for the output of your headlines // Edit the HTML code between the dashed lines // ------------------------------------------------------------------ // format: //title with link - author - date
?>
» ?a= echo $h['id']; ?>" title=" echo $h['subject']; ?>"> echo cn_cutstr($h['subject'],"$charnum"); ?>
- echo $h['user']; ?> - echo date("j. n. Y", $h['date']); ?>
// ------------------------------------------------------------------
}
?>