/[cvs]/nfo/site/htdocs/inc/cms/cms.php.inc

Diff of /nfo/site/htdocs/inc/cms/cms.php.inc

Parent Directory | Revision Log | View Patch Patch

-revision 1.2 by bd,
Mon Aug 30 04:03:25 2004 UTC
+revision 1.5 by rabit,
Mon Sep  6 00:15:28 2004 UTC
 Line 4
  --- Content management functions include file.
  --------------------------------------------------------------------------------
  --- rabit, 01:04 27.08.2004
- --- $$id$$
+ --- $Id$
  ------------------------------------------------------------------------------*/
- //----------------------------------------------------------
  function cms_getcontent($type, $keyname, $language_id = 0) {
-   $sql = "SELECT
+   $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;";
- 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;
-Line 35 
 LIMIT 0,1;";
+Line 21 
 LIMIT 0,1;";
     '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 = common_dbc_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 = common_dbc_query($sql);
+   $rowcount = 0;
+   while($row = mysql_fetch_assoc($res)) $rows[$rowcount++] = $row;
+   return $rows;
+ }
+ //----------------------------------------------------------
+ function cms_query($querycmd, &$response) {
+ //------------------
+ $operationindices = array(
+  'LIST' => 0,
+  'GET' => 1
+ );
+ //------------------
+ $sourceindices = array(
+  'contenttypes' => 0,
+  'languages' => 1,
+  'contents' => 2
+ );
+ //------------------
+   $querycmd = str_replace("\r\n", ' ', $querycmd);
+   $querycmd = str_replace("\n", ' ', $querycmd);
+   $querycmd = trim($querycmd);
+   $d1 = strpos($querycmd, ' ');
+   $operation = substr($querycmd, 0, $d1);
+   if(isset($operationindices[$operation])) {
+     $operationindex = $operationindices[$operation];
+   } else {
+     $response = cms_create_respose(1, null, null, null, $querycmd, $operation);
+     return false;
+   }
+   switch($operationindex) {
+     case 0: // "LIST"
+       $d2 = strpos($querycmd, ' WITH ', $d1 + 1);
+       if($d2) {
+         $source = substr($querycmd, $d1 + 1, $d2 - $d1 - 1);
+         $conditionlist = substr($querycmd, $d2 + 6);
+       } else {
+         $source = substr($querycmd, $d1 + 1);
+         $conditionlist = '';
+       }
+       if(isset($sourceindices[$source])) {
+         $sourceindex = $sourceindices[$source];
+       } else {
+         $response = cms_create_respose(2, null, null, null, $querycmd, $operation, $source, $conditionlist);
+         return false;
+       }
+       $sqlconditions = '';
+       if($conditionlist) {
+         $conditions = split(',', $conditionlist);
+         $sqlconditions .= ' WHERE';
+         for($c = 0; $c < count($conditions); $c++) {
+           list($conditionname, $conditionvalue) = split('=', $conditions[$c]);
+           $condition = trim($conditionname) . '=\'' . trim($conditionvalue) . '\'';
+           $sqlconditions .= ($c ? ' AND' : '') . ' ' . $condition;
+         }
+       }
+       $sql = 'SELECT id FROM ' . $source . $sqlconditions . ';';
+       $res = common_dbc_query($sql);
+       $columnnames = array('id');
+       $resultlist = array();
+       while($row = mysql_fetch_row($res)) array_push($resultlist, $row);
+       $response = cms_create_respose(0, $resultlist, $columnnames, 0, $querycmd, $operation, $source, $conditionlist);
+       return true;
+       break;
+     case 1: // "GET"
+       $d2 = strpos($querycmd, 'FROM') + 4;
+       $idlist = trim(substr($querycmd, $d1, $d2 - $d1 - 4));
+       $source = trim(substr($querycmd, $d2));
+       if(isset($sourceindices[$source])) {
+         $sourceindex = $sourceindices[$source];
+       } else {
+         $response = cms_create_respose(2, null, null, null, $querycmd, $operation, $source);
+         return false;
+       }
+       switch($sourceindex) {
+         case 0: // "contenttypes"
+           $fieldlist = 'id, name';
+           $columnnames = array('id', 'name');
+           break;
+         case 1: // "languages"
+           $fieldlist = 'id, name, abbreviation';
+           $columnnames = array('id', 'name', 'abbreviation');
+           break;
+         case 2: // "contents"
+           $fieldlist = 'id, keyname, type, creator_id, language_id, description, content';
+           $columnnames = array('id', 'keyname', 'contenttype', 'creator_id', 'language_id', 'description', 'content');
+           break;
+       }
+       $sqlconditions = '';
+       if($idlist) {
+         $ids = split(',', $idlist);
+         $sqlconditions .= ' WHERE';
+         for($i = 0; $i < count($ids); $i++) {
+           $condition = ' id=\'' . intval(trim($ids[$i])) . '\'';
+           $sqlconditions .= ($i ? ' OR' : '') . $condition;
+         }
+       } else {
+         // ERROR
+       }
+       $sql = "SELECT $fieldlist FROM " . $source . $sqlconditions . ';';
+       $res = common_dbc_query($sql);
+       $resultlist = array();
+       while($row = mysql_fetch_row($res)) array_push($resultlist, $row);
+       $response = cms_create_respose(0, $resultlist, $columnnames, 0, $querycmd, $operation, $source);
+ //      $response = cms_create_respose(0, $resultlist, $columnnames, 0, $sql, $operation, $source);
+       return true;
+       break;
+   }
+ }
+ //----------------------------------------------------------
+ function cms_create_respose(
+  $errornumber,
+  $resultlist,
+  $columnnames,
+  $firstrow = 0,
+  $querycmd = '',
+  $operation = '',
+  $source = '',
+  $conditionlist = ''
+ ) {
+ //------------------
+ $errortexts = array(
+=> 'No error',
+=> 'Unknown base operation',
+=> 'Unknown data source name'
+ );
+ //------------------
+   $response = array(
+    // Result information:
+=> array(
+     'error' => $errornumber,
+     'errortext' => $errortexts[$errornumber],
+     'columncount' => (isset($columnnames) ? count($columnnames) : null),
+     'firstrow' => $firstrow,
+     'rowcount' => count($resultlist),
+     'querycmd' => $querycmd,
+     'operation' => $operation,
+     'source' => $source,
+     'conditionlist' => $conditionlist
+    ),
+    // Result list:
+=> $resultlist,
+    // Column names:
+=> $columnnames
+   );
+   return $response;
+ }
  //------------------------------------------------------------------------------
  ?>

 Legend:



Removed from v.1.2
 


changed lines


 
Added in v.1.5
 Legend:



Removed from v.1.2
 


changed lines


 
Added in v.1.5
-Removed from v.1.2
+Added in v.1.5

MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26