--- nfo/site/htdocs/inc/cms/cms.php.inc	2004/08/30 02:22:34	1.1
+++ nfo/site/htdocs/inc/cms/cms.php.inc	2004/08/31 09:42:06	1.4
@@ -4,30 +4,14 @@
 --- Content management functions include file.
 --------------------------------------------------------------------------------
 --- rabit, 01:04 27.08.2004
---- $$id$$
+--- $Id: cms.php.inc,v 1.4 2004/08/31 09:42:06 joko Exp $
 ------------------------------------------------------------------------------*/
 
-//----------------------------------------------------------
-
 function cms_getcontent($type, $keyname, $language_id = 0) {
 
-  $sql = "SELECT
-contents.content, contents.description, UNIX_TIMESTAMP(contents.timestamp), languages.name, users.name
-FROM
-contents, languages, users
-WHERE
-contents.type='$type'
-AND
-contents.keyname='$keyname'
-AND
-users.id=contents.creator_id
-AND
-languages.id=contents.language_id
-LIMIT 0,1;
-";
+  $sql = "SELECT contents.content, contents.description, UNIX_TIMESTAMP(contents.timestamp), languages.name, users.name, contents.keyname FROM contents, languages, users WHERE contents.type='$type' AND contents.keyname='$keyname'" . ($language_id ? " AND languages.id='$language_id'" : '') . " AND users.id=contents.creator_id AND languages.id=contents.language_id LIMIT 0,1;";
 
   $res = mysql_query($sql);
-
   if(!$res) return false;
 
   $row = mysql_fetch_row($res);
@@ -37,13 +21,53 @@
    'description' => $row[1],
    'unixtime' => $row[2],
    'language_name' => $row[3],
-   'creator_name' => $row[4]
+   'creator_name' => $row[4],
+   'keyname' => $row[5],
   );
 
   return $contentdata;
 
 }
 
+//----------------------------------------------------------
+
+function cms_getlist($types, $keynames, $daterange = '', $languageids = '', $languages = '') {
+
+  $sql = "SELECT contents.id, contents.description, UNIX_TIMESTAMP(contents.timestamp), languages.id, languages.name, users.name FROM contents, languages, users WHERE contents.type='$types' AND contents.keyname='$keynames' AND users.id=contents.creator_id AND languages.id=contents.language_id;";
+
+  $res = mysql_query($sql);
+
+  $rowcount = 0;
+
+  while($row = mysql_fetch_row($res)) $rows[$rowcount++] = $row;
+
+  return $rows;
+
+}
+
+//----------------------------------------------------------
+
+function cms_getindex($type) {
+
+  $sql = "
+SELECT contents.id, contents.keyname, contents.description, 
+	UNIX_TIMESTAMP(contents.timestamp) as timestamp, languages.id, 
+	languages.name as lang, users.name as creator
+FROM contents, languages, users 
+WHERE contents.type='$type' AND users.id=contents.creator_id AND languages.id=contents.language_id;";
+
+  $res = mysql_query($sql);
+
+  $rowcount = 0;
+
+  while($row = mysql_fetch_assoc($res)) $rows[$rowcount++] = $row;
+
+  return $rows;
+
+}
+
+//----------------------------------------------------------
+
 //------------------------------------------------------------------------------
 
 ?>