inc/cms/cms.php.inc

<?php
/*------------------------------------------------------------------------------
--- www.netfrag.org
--- Content management functions include file.
--------------------------------------------------------------------------------
--- rabit, 01:04 27.08.2004
--- $$id$$
------------------------------------------------------------------------------*/

//----------------------------------------------------------

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;
";

  $res = mysql_query($sql);

  if(!$res) return false;

  $row = mysql_fetch_row($res);

  $contentdata = array(
   'content' => $row[0],
   'description' => $row[1],
   'unixtime' => $row[2],
   'language_name' => $row[3],
   'creator_name' => $row[4]
  );

  return $contentdata;

}

//------------------------------------------------------------------------------

?>
1	rabit	1.1	<?php
2			/*------------------------------------------------------------------------------
3			--- www.netfrag.org
4			--- Content management functions include file.
5			--------------------------------------------------------------------------------
6			--- rabit, 01:04 27.08.2004
7			--- $$id$$
8			------------------------------------------------------------------------------*/
9
10			//----------------------------------------------------------
11
12			function cms_getcontent($type, $keyname, $language_id = 0) {
13
14			$sql = "SELECT
15			contents.content, contents.description, UNIX_TIMESTAMP(contents.timestamp), languages.name, users.name
16			FROM
17			contents, languages, users
18			WHERE
19			contents.type='$type'
20			AND
21			contents.keyname='$keyname'
22			AND
23			users.id=contents.creator_id
24			AND
25			languages.id=contents.language_id
26			LIMIT 0,1;
27			";
28
29			$res = mysql_query($sql);
30
31			if(!$res) return false;
32
33			$row = mysql_fetch_row($res);
34
35			$contentdata = array(
36			'content' => $row[0],
37			'description' => $row[1],
38			'unixtime' => $row[2],
39			'language_name' => $row[3],
40			'creator_name' => $row[4]
41			);
42
43			return $contentdata;
44
45			}
46
47			//------------------------------------------------------------------------------
48
49			?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26