/[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.4 by joko,
Tue Aug 31 09:42:06 2004 UTC
+revision 1.5 by rabit,
Mon Sep  6 00:15:28 2004 UTC
 Line 35 
 function cms_getlist($types, $keynames,
    $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);
+   $res = common_dbc_query($sql);
    $rowcount = 0;
 Line 49 
 function cms_getlist($types, $keynames,
  function cms_getindex($type) {
-   $sql = "
+   $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;";
- 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);
+   $res = common_dbc_query($sql);
    $rowcount = 0;
-Line 68 
 WHERE contents.type='$type' AND users.id
+Line 63 
 WHERE contents.type='$type' AND users.id
  //----------------------------------------------------------
+ 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.4
 


changed lines


 
Added in v.1.5
 Legend:



Removed from v.1.4
 


changed lines


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

MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26