classes/class.ilNestedSetXML.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2001 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

require_once "./classes/class.ilXML2DOM.php";

class ilNestedSetXML
{
    // {{{ Vars

    var $db;

    var $LEFT = 0;
    var $RIGHT = 0;
    
    var $DEPTH = 0;
    
    var $obj_id;
    
    var $obj_type;
    
    var $xml_parser;
    
    var $lastTag = "";
    
    var $ilias;
        
        var $dom;
        
    // }}}

    function ilNestedSetXML() 
        {
        global $ilias;

                $this->ilias =& $ilias;
        
        $this->db =& $this->ilias->db;
        $this->LEFT = 0;
        $this->RIGHT = 0;
        $this->DEPTH = 0;

                $this->param_modifier = "";
    }


    function startElement($parser, $name, $attrs) 
        {
        // {{{
        
        $this->lastTag = $name;
        $this->LEFT += 1;
        $this->RIGHT = $this->LEFT + 1;
        $this->DEPTH++;
        
        $this->db->query("INSERT INTO xmltags ( tag_name,tag_depth ) VALUES ('".$name."','".$this->DEPTH."') ");
        // $pk = mysql_insert_id();
        $r = $this->db->query("SELECT LAST_INSERT_ID()");
        $row = $r->fetchRow();

        $pk = $row[0];

        $Q = "UPDATE NestedSetTemp SET ns_r=ns_r+2 WHERE ns_r>='".($this->LEFT)."' AND ns_book_fk='".$this->obj_id."' ";
        $this->db->query($Q);

        $Q = "INSERT INTO NestedSetTemp (ns_book_fk,ns_type,ns_tag_fk,ns_l,ns_r) VALUES ('".$this->obj_id."','".$this->obj_type."','".$pk."',".$this->LEFT.",".$this->RIGHT.") ";
        $this->db->query($Q);
        
                $this->clean($attrs);
        if (is_array($attrs) && count($attrs)>0)
                {
            reset ($attrs);
            while (list ($key, $val) = each ($attrs)) 
                        {
                  $this->db->query("INSERT INTO xmlparam ( tag_fk,param_name,param_value ) VALUES ('".$pk."','$key','".addslashes($val)."') ");
            }
        }
        
        return($pk);
        // }}}
    }

    function characterData($parser, $data) 
        {
        // {{{
        static $value_pk;
        
        if(trim($data)!="") {

            if ($this->lastTag == "TAGVALUE")
                        {
                $Q = "UPDATE xmlvalue SET tag_value=concat(tag_value,'".addslashes($data)."') WHERE tag_value_pk='".$value_pk."' ";
                $this->db->query($Q);
            } 
            else 
            {
                $tag_pk = $this->startElement($this->xml_parser,"TAGVALUE",array());
                $this->endElement($this->xml_parser,"TAGVALUE");
            
                $Q = "INSERT INTO xmlvalue (tag_fk,tag_value) VALUES ('".$tag_pk."','".addslashes($data)."') ";
                $this->db->query($Q);
                
                $Q = "SELECT LAST_INSERT_ID()";
                                $r = $this->db->query($Q);
                                $row = $r->fetchRow();
                                $value_pk = $row[0];

                $this->lastTag = "TAGVALUE";
            }
            
        }
        // }}}
    }

    function endElement($parser, $name)
        {
        // {{{
        $this->DEPTH--;
        $this->LEFT += 1;
        $this->lastTag = "";
        // }}}
    }

    function import($xmldata, $obj_id, $obj_type)
        {
        // {{{
        $this->db->query("DROP TABLE IF EXISTS NestedSetTemp");
        
        $Q = "CREATE TEMPORARY TABLE NestedSetTemp (
          ns_book_fk int(11)  NOT NULL,
          ns_type char(50) NOT NULL,
          ns_tag_fk int(11)  NOT NULL,
          ns_l int(11)  NOT NULL,
          ns_r int(11)  NOT NULL,
          KEY ns_tag_fk (ns_tag_fk),
          KEY ns_l (ns_l),
          KEY ns_r (ns_r),
          KEY ns_book_fk (ns_book_fk)
        ) TYPE=MyISAM ";
        $this->db->query($Q);

        $this->obj_id = $obj_id;
        $this->obj_type = $obj_type;
                $this->DEPTH = 0;
                $this->LEFT = 0;
                $this->RIGHT = 0;

        $this->db->query("DELETE FROM NestedSetTemp");

        $this->xml_parser = xml_parser_create("UTF-8");
        xml_parser_set_option($this->xml_parser, XML_OPTION_CASE_FOLDING, false);
        xml_set_object($this->xml_parser,$this);
        xml_set_element_handler($this->xml_parser, "startElement", "endElement");
        xml_set_character_data_handler($this->xml_parser, "characterData");

        if (!xml_parse($this->xml_parser, $xmldata)) {
            die(sprintf("XML error: %s at line %d",     xml_error_string(xml_get_error_code($this->xml_parser)),xml_get_current_line_number($this->xml_parser)));
        }
        xml_parser_free($this->xml_parser);

        $this->deleteAllDbData();

        $this->db->query("INSERT INTO xmlnestedset SELECT * FROM NestedSetTemp");
        $this->db->query("DROP TABLE IF EXISTS NestedSetTemp");
        // }}}
    }

        function setParameterModifier(&$a_object, $a_method)
        {
                $this->param_modifier =& $a_object;
                $this->param_modifier_method = $a_method;
        }

        function export($obj_id, $type)
        {
                // {{{
                $query = "SELECT * FROM xmlnestedset,xmltags WHERE ns_tag_fk=tag_pk AND ns_book_fk='$obj_id' AND ns_type='$type' ORDER BY ns_l";
                $result = $this->db->query($query);
                if (DB::isError($result))
                {
                        die($this->className."::checkTable(): ".$result->getMessage().":<br>".$q);
                }

                $xml = "";
                $lastDepth = -1;

                while (is_array($row = $result->fetchRow(DB_FETCHMODE_ASSOC) ) )
        {

                        // {{{ tags
                        $Anfang = "<".$row[tag_name];
            $query = "SELECT * FROM xmlparam WHERE tag_fk='$row[tag_pk]'";
                        $result_param = $this->db->query($query);
                        while (is_array($row_param = $result_param->fetchRow(DB_FETCHMODE_ASSOC) ) )
                        {
                                $param_value = $row_param[param_value];
                                if (is_object($this->param_modifier))
                                {
                                        $obj =& $this->param_modifier;
                                        $method = $this->param_modifier_method;
                                        $param_value = $obj->$method($row[tag_name], $row_param[param_name], $param_value);
                                }
                                $Anfang .= " ".$row_param[param_name]."=\"".$param_value."\"";
                        }

                        $Anfang .= ">";
                        $Ende = "</".$row[tag_name].">";
                        // }}}

                        // {{{ TagValue
                        if ($row[tag_name]=="TAGVALUE") 
            {
                $query = "SELECT * FROM xmlvalue WHERE tag_fk='$row[tag_pk]' ";
                                $result_value = $this->db->query($query);
                                $row_value = $result_value->fetchRow(DB_FETCHMODE_ASSOC);
                                $Anfang = $row_value["tag_value"];
                                $Ende = "";

                                $Anfang = htmlspecialchars($Anfang);
                                // $Anfang = utf8_encode($Anfang);
                        }
                        // }}}

                        $D = $row[tag_depth];

                        if ($D==$lastDepth) 
            {
                                $xml .= $xmlE[$D];
                                $xml .= $Anfang;
                                $xmlE[$D] = $Ende;
                        } 
            else if ($D>$lastDepth)
            {
                                $xml .= $Anfang;
                                $xmlE[$D] = $Ende;
                        } 
            else 
            {
                                for ($i=$lastDepth;$i>=$D;$i--) 
                {
                                        $xml .= $xmlE[$i];
                                }
                                $xml .= $Anfang;
                                $xmlE[$D] = $Ende;
                        }

                        $lastDepth = $D;

                }

                for ($i=$lastDepth;$i>0;$i--) 
        {
                        $xml .= $xmlE[$i];
                }

                return($xml);
                // }}}
        }

    function init($obj_id,$obj_type)
        {
        // {{{
                $query = "SELECT * FROM xmlnestedset,xmltags WHERE ns_book_fk='".$obj_id."' AND ns_type='".
                        $obj_type."' AND ns_tag_fk=tag_pk ORDER BY ns_l LIMIT 1";
        $result = $this->db->query($query);
        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);

        $this->LEFT = $row["ns_l"];
        $this->RIGHT = $row["ns_r"];
        $this->DEPTH = $row["tag_depth"];
        $this->obj_id = $obj_id;
        $this->obj_type = $obj_type;
        // }}}
    }

    function getTagName()
        {

        $query = "SELECT * FROM xmlnestedset,xmltags WHERE ns_book_fk='".$this->obj_id."' AND ns_type='".$this->obj_type."' AND ns_l='".$this->LEFT."' AND ns_r='".$this->RIGHT."' AND ns_tag_fk=tag_pk LIMIT 1";
                $result = $this->db->query($query);
        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);

        return($row["tag_name"]);
        
    }

    function setTagName($tagName)
        {
        
                $query = "SELECT * FROM xmlnestedset WHERE ns_book_fk='".$this->obj_id."' AND ns_type='".$this->obj_type."' AND ns_l='".$this->LEFT."' AND ns_r='".$this->RIGHT."' LIMIT 1";
        $result = $this->db->query($query);
        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
        
                $query = "UPDATE xmltags SET tag_name='$tagName' WHERE tag_pk='".$row["ns_tag_fk"]."'";
        $this->db->query($query);
        
        return($row["tagName"]);
        
    }
    
    
    function getTagValue() 
        {
        
        $V = array();
        
        $query = "SELECT * FROM xmlnestedset,xmltags WHERE ns_tag_fk=tag_pk AND ns_book_fk='".$this->obj_id."' AND ns_type='".$this->obj_type."' AND ns_l>='".$this->LEFT."' AND ns_r<='".$this->RIGHT."' AND tag_depth='".($this->DEPTH+1)."' ORDER BY ns_l";
                $result = $this->db->query($query);
        while (is_array($row = $result->fetchRow(DB_FETCHMODE_ASSOC) ) )
                {
            if ($row[tag_name]=="TAGVALUE") 
                        {
                                $query = "SELECT * FROM xmlvalue WHERE tag_fk='".$row[tag_pk]."' ";
                $result2 = $this->db->query($query);
                $row2 = $result2->fetchRow(DB_FETCHMODE_ASSOC);
                $V[] = $row2[tag_value];
            }
                        else 
                        {
                $xml = new ilNestedSetXml();
                
                $xml->LEFT = $row["ns_l"];
                $xml->RIGHT = $row["ns_r"];
                $xml->DEPTH = $row["tag_depth"];
                $xml->obj_id = $obj_id;
                $xml->obj_type = $obj_type;
                
                $V[] = $xml;
                
            }
        }
        
        return($V);
    }
        
        function setTagValue($value) 
        {
        $V = array();

        $query = "SELECT * FROM xmlnestedset,xmltags
                                                LEFT JOIN xmlvalue ON xmltags.tag_pk=xmlvalue.tag_fk
                                                WHERE ns_tag_fk=tag_pk AND 
                                                        ns_book_fk='".$this->obj_id."' AND
                                                        ns_type='".$this->obj_type."' AND
                                                        ns_l>='".$this->LEFT."' AND
                                                        ns_r<='".$this->RIGHT."' AND
                                                        tag_depth='".($this->DEPTH+1)."' AND
                                                        tag_name = 'TAGVALUE'
                                                        ORDER BY ns_l";
                $result = $this->db->query($query);

        if (is_array($row = $result->fetchRow(DB_FETCHMODE_ASSOC) ) )
                {
                        
                        $query = "UPDATE xmlvalue SET tag_value='".addslashes($value)."' WHERE tag_value_pk='".$row["tag_value_pk"]."' ";
                        $this->db->query($query);
                        
                } 
        else 
        {
                        
                }
        }

        function getXpathNodes(&$doc, $qry)
        {
                if (is_object($doc))
                {
                        $xpath = $doc->xpath_init();
                        $ctx = $doc->xpath_new_context();
//echo "<br><b>ilNestedSetXML::getXpathNodes</b>";
                        $result = $ctx->xpath_eval($qry);
                        if (is_array($result->nodeset))
                        {
                                return($result->nodeset);
                        }
                }
                return Null;
        }

        function initDom()
        {
                $xml = $this->export($this->obj_id, $this->obj_type);

/*
        for testing
                $xml_test = '
                <MetaData>
                        <General Structure="Atomic">
                                <Identifier Catalog="ILIAS" Entry="34">Identifier 34 in ILIAS</Identifier>
                                <Identifier Catalog="ILIAS" Entry="45">Identifier 45 in ILIAS</Identifier>
                                <Identifier Catalog="ILIAS" Entry="67">Identifier 67 in ILIAS</Identifier>
                        </General>
                </MetaData>
                ';

                $xml = $xml_test;
*/

                if ($xml=="")
        {
                        return(false);
                }
        else 
        {
                        $this->dom = domxml_open_mem($xml);
                        return(true);
                }
        }

        function addXMLNode($xPath, $xml, $index = 0)
        {
                $newDOM = new XML2DOM($xml);
//echo "<br>addXMLNode:-".htmlspecialchars($this->dom->dump_mem(0));
                $nodes = $this->getXpathNodes($this->dom, $xPath);

                if (count($nodes) > 0)
                {
                        $newDOM->insertNode($this->dom, $nodes[$index]);
                        return true;
                }
                else
                {
                        return false;
                }
        }

        function getFirstDomContent($xPath)
        {
//echo "<br>ilNestedSetXML::getFirstDomContent-start-$xPath-"; flush();
                $content = "";
                if (is_object($this->dom))
                {
                        $node = $this->getXpathNodes($this->dom,$xPath);
                        if (is_array($node))
                        {
                                $c = $node[0]->children();
                                //$content = $c[0]->content;            // ## changed
                                if (is_object($c[0]))
                                {
                                        $content = $c[0]->get_content();                // ## changed
                                }
                        }
                }
//echo "<br>ilNestedSetXML::getFirstDomContent-stop-$content-"; flush();
                return($content);
        }       
        
        function deleteDomNode($xPath, $name, $index = 0) 
        {
                if ($index == "")
                {
                        $index = 0;
                }
                if (strpos($index, ","))
                {
                        $indices = explode(",", $index);
                        $nodes = $this->getXpathNodes($this->dom, $xPath);
                        if (count($nodes) > 0)
                        {
                                $children = $nodes[$indices[0]]->child_nodes();
                                if (count($children) > 0)
                                {
                                        $j = 0;
                                        for ($i = 0; $i < count($children); $i++)
                                        {
                                                if ($children[$i]->node_name() == $name)
                                                {
                                                        if ($j == $indices[1])
                                                        {
                                                                $children[$i]->unlink_node();
                                                                return true;
                                                        }
                                                        $j++;
                                                }
                                        }
                                }
                        }
                }
                else
                {
                        $nodes = $this->getXpathNodes($this->dom, $xPath . "/" . $name);
                        if (count($nodes) > 0)
                        {
                                $nodes[$index]->unlink_node();
                                return true;
                        }
                }
                return false;
        }       
        
        function addDomNode($xPath, $name, $value = "", $attributes = "", $index = 0) 
        {
                $nodes = $this->getXpathNodes($this->dom, $xPath);
                if (count($nodes) > 0)
                {
                        $node = $this->dom->create_element($name);
                        if ($value != "")
                        {
                                $node->set_content(utf8_encode($value));
                        }
                        if (is_array($attributes))
                        {
                                for ($i = 0; $i < count($attributes); $i++)
                                {
                                        $node->set_attribute($attributes[$i]["name"], utf8_encode($attributes[$i]["value"]));
                                }
                        }
                        $nodes[$index]->append_child($node);
                        return true;
                }
                else
                {
                        return false;
                }
        }       
        
        function clean(&$meta)
        {
                if(is_array($meta))
                {
                        foreach($meta as $key => $value)
                        {
                                if(is_array($meta[$key]))
                                {
                                        $this->clean($meta[$key]);
                                }
                                else
                                {
                                        $meta[$key] = preg_replace("/&(?!amp;|lt;|gt;|quot;)/","&amp;",$meta[$key]);
                                        $meta[$key] = preg_replace("/\"/","&quot;",$meta[$key]);
                                        $meta[$key] = preg_replace("/</","&lt;",$meta[$key]);
                                        $meta[$key] = preg_replace("/>/","&gt;",$meta[$key]);
                                }
                        }
                }
                return true;
        }
        function updateDomNode($xPath, $meta, $no = 0)
        {
                $this->clean($meta);
                $update = false;
                if ($xPath == "//Bibliography")
                {
                        $nodes = $this->getXpathNodes($this->dom, $xPath . "/BibItem[" . ($no+1) . "]");
                }
                else
                {
                        $nodes = $this->getXpathNodes($this->dom, $xPath);
                }
                if (count($nodes) > 0)
                {

                        /* BibItem */
                        if ($nodes[0]->node_name() == "BibItem")
                        {
                                $xml = '<BibItem Type="' . ilUtil::stripSlashes($meta["Type"]) . '" Label="' . ilUtil::stripSlashes($meta["Label"]["Value"]) . '">';
                                $xml .= '<Identifier Catalog="' . ilUtil::stripSlashes($meta["Identifier"]["Catalog"]) . '" Entry="' .  str_replace("\"", "", ilUtil::stripSlashes($meta["Identifier"]["Entry"])) . '"/>';
                                for ($i = 0; $i < count($meta["Language"]); $i++)
                                {
                                        $xml .= '<Language Language="' . ilUtil::stripSlashes($meta["Language"][$i]["Language"]) . '"/>';
                                }
                                for ($i = 0; $i < count($meta["Author"]); $i++)
                                {
                                        $xml .= '<Author>';
#                                       for ($j = 0; $j < count($meta["Author"][$i]["FirstName"]); $j++)
#                                       {
                                                $xml .= '<FirstName>' . ilUtil::stripSlashes($meta["Author"][$i]["FirstName"]) . '</FirstName>';
#                                       }
#                                       for ($j = 0; $j < count($meta["Author"][$i]["MiddleName"]); $j++)
#                                       {
                                                $xml .= '<MiddleName>' . ilUtil::stripSlashes($meta["Author"][$i]["MiddleName"]) . '</MiddleName>';
#                                       }
#                                       for ($j = 0; $j < count($meta["Author"][$i]["LastName"]); $j++)
#                                       {
                                                $xml .= '<LastName>' . ilUtil::stripSlashes($meta["Author"][$i]["LastName"]) . '</LastName>';
#                                       }
                                        $xml .= '</Author>';
                                }
                                $xml .= '<Booktitle Language="' . ilUtil::stripSlashes($meta["Booktitle"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Booktitle"]["Value"]) . '</Booktitle>';
                                for ($i = 0; $i < count($meta["CrossRef"]); $i++)
                                {
                                        $xml .= '<CrossRef>' . ilUtil::stripSlashes($meta["CrossRef"][$i]["Value"]) . '</CrossRef>';
                                }
                                $xml .= '<Edition>' . ilUtil::stripSlashes($meta["Edition"]["Value"]) . '</Edition>';
                                for ($i = 0; $i < count($meta["Editor"]); $i++)
                                {
                                        $xml .= '<Editor>' . ilUtil::stripSlashes($meta["Editor"][$i]["Value"]) . '</Editor>';
                                }
                                $xml .= '<HowPublished Type="' . ilUtil::stripSlashes($meta["HowPublished"]["Type"]) . '"/>';
                                for ($i = 0; $i < count($meta["WherePublished"]); $i++)
                                {
                                        $xml .= '<WherePublished>' . ilUtil::stripSlashes($meta["WherePublished"][$i]["Value"]) . '</WherePublished>';
                                }
                                for ($i = 0; $i < count($meta["Institution"]); $i++)
                                {
                                        $xml .= '<Institution>' . ilUtil::stripSlashes($meta["Institution"][$i]["Value"]) . '</Institution>';
                                }
                                if (is_array($meta["Journal"]))
                                {
                                        $xml .= '<Journal Note="' . ilUtil::stripSlashes($meta["Journal"]["Note"]) . '" Number="' . ilUtil::stripSlashes($meta["Journal"]["Number"]) . '" Organization="' . ilUtil::stripSlashes($meta["Journal"]["Organization"]) . '"/>';
                                }
                                for ($i = 0; $i < count($meta["Keyword"]); $i++)
                                {
                                        $xml .= '<Keyword Language="' . ilUtil::stripSlashes($meta["Keyword"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Keyword"][$i]["Value"]) . '</Keyword>';
                                }
                                if (is_array($meta["Month"]))
                                {
                                        $xml .= '<Month>' . ilUtil::stripSlashes($meta["Month"]["Value"]) . '</Month>';
                                }
                                if (is_array($meta["Pages"]))
                                {
                                        $xml .= '<Pages>' . ilUtil::stripSlashes($meta["Pages"]["Value"]) . '</Pages>';
                                }
                                $xml .= '<Publisher>' . ilUtil::stripSlashes($meta["Publisher"]["Value"]) . '</Publisher>';
                                for ($i = 0; $i < count($meta["School"]); $i++)
                                {
                                        $xml .= '<School>' . ilUtil::stripSlashes($meta["School"][$i]["Value"]) . '</School>';
                                }
                                if (is_array($meta["Series"]))
                                {
                                        $xml .= '<Series>';
                                        $xml .= '<SeriesTitle>' . ilUtil::stripSlashes($meta["Series"]["SeriesTitle"]) . '</SeriesTitle>';
#                                       for ($i = 0; $i < count($meta["Series"]["SeriesEditor"]); $i++)
                                        if (isset($meta["Series"]["SeriesEditor"]))
                                        {
#                                               $xml .= '<SeriesEditor>' . ilUtil::stripSlashes($meta["Series"]["SeriesEditor"][$i]) . '</SeriesEditor>';
                                                $xml .= '<SeriesEditor>' . ilUtil::stripSlashes($meta["Series"]["SeriesEditor"]) . '</SeriesEditor>';
                                        }
                                        if (isset($meta["Series"]["SeriesVolume"]))
                                        {
                                                $xml .= '<SeriesVolume>' . ilUtil::stripSlashes($meta["Series"]["SeriesVolume"]) . '</SeriesVolume>';
                                        }
                                        $xml .= '</Series>';
                                }
                                $xml .= '<Year>' . ilUtil::stripSlashes($meta["Year"]["Value"]) . '</Year>';
                                if ($meta["URL_ISBN_ISSN"]["Type"] == "URL")
                                {
                                        $xml .= '<URL>' . ilUtil::stripSlashes($meta["URL_ISBN_ISSN"]["Value"]) . '</URL>';
                                }
                                else if ($meta["URL_ISBN_ISSN"]["Type"] == "ISBN")
                                {
                                        $xml .= '<ISBN>' . ilUtil::stripSlashes($meta["URL_ISBN_ISSN"]["Value"]) . '</ISBN>';
                                }
                                else if ($meta["URL_ISBN_ISSN"]["Type"] == "ISSN")
                                {
                                        $xml .= '<ISSN>' . ilUtil::stripSlashes($meta["URL_ISBN_ISSN"]["Value"]) . '</ISSN>';
                                }
                                $xml .= '</BibItem>';
#                               echo htmlspecialchars($xml);

                                $update = true;
                        }

                        /* General */
                        else if ($nodes[0]->node_name() == "General")
                        {

                                $xml = '<General Structure="' . ilUtil::stripSlashes($meta["Structure"]) . '">';
                                for ($i = 0; $i < count($meta["Identifier"]); $i++)
                                {
                                        $xml .= '<Identifier Catalog="' . ilUtil::stripSlashes($meta["Identifier"][$i]["Catalog"]) . '" Entry="' .  str_replace("\"", "", ilUtil::stripSlashes($meta["Identifier"][$i]["Entry"])) . '"/>';
                                }
                                $xml .= '<Title Language="' . ilUtil::stripSlashes($meta["Title"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Title"]["Value"]) . '</Title>';
                                for ($i = 0; $i < count($meta["Language"]); $i++)
                                {
                                        $xml .= '<Language Language="' . ilUtil::stripSlashes($meta["Language"][$i]["Language"]) . '"/>';
                                }
                                for ($i = 0; $i < count($meta["Description"]); $i++)
                                {
                                        $xml .= '<Description Language="' . ilUtil::stripSlashes($meta["Description"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Description"][$i]["Value"]) . '</Description>';
                                }
                                for ($i = 0; $i < count($meta["Keyword"]); $i++)
                                {
                                        $xml .= '<Keyword Language="' . ilUtil::stripSlashes($meta["Keyword"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Keyword"][$i]["Value"]) . '</Keyword>';
                                }
                                if ($meta["Coverage"] != "")
                                {
                                        $xml .= '<Coverage Language="' . ilUtil::stripSlashes($meta["Coverage"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Coverage"]["Value"]) . '</Coverage>';
                                }
                                $xml .= '</General>';
//echo "<br><br>".htmlspecialchars($xml);

                                $update = true;
                        }

                        /* Lifecycle */
                        else if ($nodes[0]->node_name() == "Lifecycle")
                        {
                                $xml = '<Lifecycle Status="' . $meta["Status"] . '">';
                                $xml .= '<Version Language="' . ilUtil::stripSlashes($meta["Version"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Version"]["Value"]) . '</Version>';
                                for ($i = 0; $i < count($meta["Contribute"]); $i++)
                                {
                                        $xml .= '<Contribute Role="' . ilUtil::stripSlashes($meta["Contribute"][$i]["Role"]) . '">';
                                        $xml .= '<Date>' . ilUtil::stripSlashes($meta["Contribute"][$i]["Date"]) . '</Date>';
                                        for ($j = 0; $j < count($meta["Contribute"][$i]["Entity"]); $j++)
                                        {
                                                $xml .= '<Entity>' . ilUtil::stripSlashes($meta["Contribute"][$i]["Entity"][$j]) . '</Entity>';
                                        }
                                        $xml .= '</Contribute>';
                                }
                                $xml .= '</Lifecycle>';
#                               echo htmlspecialchars($xml);

                                $update = true;
                        }

                        /* Meta-Metadata */
                        else if ($nodes[0]->node_name() == "Meta-Metadata")
                        {

                                $xml = '<Meta-Metadata MetadataScheme="LOM v 1.0" Language="' . ilUtil::stripSlashes($meta["Language"]) . '">';
                                for ($i = 0; $i < count($meta["Identifier"]); $i++)
                                {
                                        $xml .= '<Identifier Catalog="' . ilUtil::stripSlashes($meta["Identifier"][$i]["Catalog"]) . '" Entry="' .  str_replace("\"", "", ilUtil::stripSlashes($meta["Identifier"][$i]["Entry"])) . '"/>';
                                }
                                for ($i = 0; $i < count($meta["Contribute"]); $i++)
                                {
                                        $xml .= '<Contribute Role="' . ilUtil::stripSlashes($meta["Contribute"][$i]["Role"]) . '">';
                                        $xml .= '<Date>' . ilUtil::stripSlashes($meta["Contribute"][$i]["Date"]) . '</Date>';
                                        for ($j = 0; $j < count($meta["Contribute"][$i]["Entity"]); $j++)
                                        {
                                                $xml .= '<Entity>' . ilUtil::stripSlashes($meta["Contribute"][$i]["Entity"][$j]) . '</Entity>';
                                        }
                                        $xml .= '</Contribute>';
                                }
                                $xml .= '</Meta-Metadata>';
#                               echo htmlspecialchars($xml);

                                $update = true;
                        }

                        /* Technical */
                        else if ($nodes[0]->node_name() == "Technical")
                        {

                                $xml = '<Technical>';
                                for ($i = 0; $i < count($meta["Format"]); $i++)
                                {
                                        $xml .= '<Format>' . ilUtil::stripSlashes($meta["Format"][$i]) . '</Format>';
                                }
                                if ($meta["Size"] != "")
                                {
                                        $xml .= '<Size>' . ilUtil::stripSlashes($meta["Size"]) . '</Size>';
                                }
                                for ($i = 0; $i < count($meta["Location"]); $i++)
                                {
                                        $xml .= '<Location Type="' . ilUtil::stripSlashes($meta["Location"][$i]["Type"]) . '">' . ilUtil::stripSlashes($meta["Location"][$i]["Value"]) . '</Location>';
                                }
                                if (is_array($meta["Requirement"]))
                                {
                                        for ($i = 0; $i < count($meta["Requirement"]); $i++)
                                        {
                                                $xml .= '<Requirement>';
                                                $xml .= '<Type>';
                                                if (is_array($meta["Requirement"][$i]["Type"]["OperatingSystem"]))
                                                {
                                                        $xml .= '<OperatingSystem Name="' . ilUtil::stripSlashes($meta["Requirement"][$i]["Type"]["OperatingSystem"]["Name"]) . '" MinimumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["Requirement"][$i]["Type"]["OperatingSystem"]["MinimumVersion"])) . '" MaximumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["Requirement"][$i]["Type"]["OperatingSystem"]["MaximumVersion"])) . '"/>';
                                                }
                                                if (is_array($meta["Requirement"][$i]["Type"]["Browser"]))
                                                {
                                                        $xml .= '<Browser Name="' . ilUtil::stripSlashes($meta["Requirement"][$i]["Type"]["Browser"]["Name"]) . '" MinimumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["Requirement"][$i]["Type"]["Browser"]["MinimumVersion"])) . '" MaximumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["Requirement"][$i]["Type"]["Browser"]["MaximumVersion"])) . '"/>';
                                                }
                                                $xml .= '</Type>';
                                                $xml .= '</Requirement>';
                                        }
                                }
                                else if (is_array($meta["OrComposite"]))
                                {
                                        for ($j = 0; $j < count($meta["OrComposite"]); $j++)
                                        {
                                                $xml .= '<OrComposite>';
                                                for ($i = 0; $i < count($meta["OrComposite"][$j]["Requirement"]); $i++)
                                                {
                                                        $xml .= '<Requirement>';
                                                        $xml .= '<Type>';
                                                        if (is_array($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["OperatingSystem"]))
                                                        {
                                                                $xml .= '<OperatingSystem Name="' . ilUtil::stripSlashes($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["OperatingSystem"]["Name"]) . '" MinimumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["OperatingSystem"]["MinimumVersion"])) . '" MaximumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["OperatingSystem"]["MaximumVersion"])) . '"/>';
                                                        }
                                                        if (is_array($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["Browser"]))
                                                        {
                                                                $xml .= '<Browser Name="' . ilUtil::stripSlashes($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["Browser"]["Name"]) . '" MinimumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["Browser"]["MinimumVersion"])) . '" MaximumVersion="' . str_replace("\"", "", ilUtil::stripSlashes($meta["OrComposite"][$j]["Requirement"][$i]["Type"]["Browser"]["MaximumVersion"])) . '"/>';
                                                        }
                                                        $xml .= '</Type>';
                                                        $xml .= '</Requirement>';
                                                }
                                                $xml .= '</OrComposite>';
                                        }
                                }
                                if (is_array($meta["InstallationRemarks"]))
                                {
                                        $xml .= '<InstallationRemarks Language="' . ilUtil::stripSlashes($meta["InstallationRemarks"]["Language"]) . '">' . ilUtil::stripSlashes($meta["InstallationRemarks"]["Value"]) . '</InstallationRemarks>';
                                }
                                if (is_array($meta["OtherPlattformRequirements"]))
                                {
                                        $xml .= '<OtherPlattformRequirements Language="' . ilUtil::stripSlashes($meta["OtherPlattformRequirements"]["Language"]) . '">' . ilUtil::stripSlashes($meta["OtherPlattformRequirements"]["Value"]) . '</OtherPlattformRequirements>';
                                }
                                if ($meta["Duration"] != "")
                                {
                                        $xml .= '<Duration>' . ilUtil::stripSlashes($meta["Duration"]) . '</Duration>';
                                }
                                $xml .= '</Technical>';
#                               echo htmlspecialchars($xml);

                                $update = true;
                        }

                        /* Educational */
                        else if ($nodes[0]->node_name() == "Educational")
                        {

                                $xml = '<Educational InteractivityType="' . ilUtil::stripSlashes($meta["InteractivityType"]) . '" LearningResourceType="' . ilUtil::stripSlashes($meta["LearningResourceType"]) . '" InteractivityLevel="' . ilUtil::stripSlashes($meta["InteractivityLevel"]) . '" SemanticDensity="' . ilUtil::stripSlashes($meta["SemanticDensity"]) . '" IntendedEndUserRole="' . ilUtil::stripSlashes($meta["IntendedEndUserRole"]) . '" Context="' . ilUtil::stripSlashes($meta["Context"]) . '" Difficulty="' . ilUtil::stripSlashes($meta["Difficulty"]) . '">';
                                $xml .= '<TypicalLearningTime>' . ilUtil::stripSlashes($meta["TypicalLearningTime"]) . '</TypicalLearningTime>';
                                for ($i = 0; $i < count($meta["TypicalAgeRange"]); $i++)
                                {
                                        $xml .= '<TypicalAgeRange Language="' . ilUtil::stripSlashes($meta["TypicalAgeRange"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["TypicalAgeRange"][$i]["Value"]) . '</TypicalAgeRange>';
                                }
                                for ($i = 0; $i < count($meta["Description"]); $i++)
                                {
                                        $xml .= '<Description Language="' . ilUtil::stripSlashes($meta["Description"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Description"][$i]["Value"]) . '</Description>';
                                }
                                for ($i = 0; $i < count($meta["Language"]); $i++)
                                {
                                        $xml .= '<Language Language="' . ilUtil::stripSlashes($meta["Language"][$i]["Language"]) . '"/>';
                                }
                                $xml .= '</Educational>';

                                $update = true;
                        }

                        /* Rights */
                        else if ($nodes[0]->node_name() == "Rights")
                        {

                                $xml = '<Rights Cost="' . ilUtil::stripSlashes($meta["Cost"]) . '" CopyrightAndOtherRestrictions="' . ilUtil::stripSlashes($meta["CopyrightAndOtherRestrictions"]) . '">';
                                for ($i = 0; $i < count($meta["Description"]); $i++)
                                {
                                        $xml .= '<Description Language="' . ilUtil::stripSlashes($meta["Description"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Description"][$i]["Value"]) . '</Description>';
                                }
                                $xml .= '</Rights>';

                                $update = true;
                        }

                        /* Relation */
                        else if ($nodes[0]->node_name() == "Relation")
                        {

#                               for ($j = 0; $j < count($meta["Relation"]); $j++)
#                               {
                                        $meta["Relation"][0] = $meta;
                                        $j = 0;
                                        $xml = '<Relation Kind="' . ilUtil::stripSlashes($meta["Relation"][$j]["Kind"]) . '">';
                                        $xml .= '<Resource>';
                                        for ($i = 0; $i < count($meta["Relation"][$j]["Resource"]["Identifier"]); $i++)
                                        {
                                                $xml .= '<Identifier_ Catalog="' . ilUtil::stripSlashes($meta["Relation"][$j]["Resource"]["Identifier"][$i]["Catalog"]) . '" Entry="' . str_replace("\"", "", ilUtil::stripSlashes($meta["Relation"][$j]["Resource"]["Identifier"][$i]["Entry"])) . '"/>';
                                        }
                                        for ($i = 0; $i < count($meta["Relation"][$j]["Resource"]["Description"]); $i++)
                                        {
                                                $xml .= '<Description Language="' . ilUtil::stripSlashes($meta["Relation"][$j]["Resource"]["Description"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Relation"][$j]["Resource"]["Description"][$i]["Value"]) . '</Description>';
                                        }
                                        $xml .= '</Resource>';
                                        $xml .= '</Relation>';
#                                       echo htmlspecialchars($xml);
#                               }

                                $update = true;
                        }

                        /* Annotation */
                        else if ($nodes[0]->node_name() == "Annotation")
                        {

#                               for ($i = 0; $i < count($meta["Annotation"]); $i++)
#                               {
                                        $meta["Annotation"][0] = $meta;
                                        $i = 0;
                                        $xml = '<Annotation>';
                                        $xml .= '<Entity>' . ilUtil::stripSlashes($meta["Annotation"][$i]["Entity"]) . '</Entity>';
                                        $xml .= '<Date>' . ilUtil::stripSlashes($meta["Annotation"][$i]["Date"]) . '</Date>';
                                        $xml .= '<Description Language="' . ilUtil::stripSlashes($meta["Annotation"][$i]["Description"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Annotation"][$i]["Description"]["Value"]) . '</Description>';
                                        $xml .= '</Annotation>';
#                                       echo htmlspecialchars($xml);
#                               }

                                $update = true;
                        }

                        /* Classification */
                        else if ($nodes[0]->node_name() == "Classification")
                        {

#                               for ($j = 0; $j < count($meta["Classification"]); $j++)
#                               {
                                        $meta["Classification"][0] = $meta;
                                        $j = 0;
                                        $xml = '<Classification Purpose="' . ilUtil::stripSlashes($meta["Classification"][$j]["Purpose"]) . '">';
                                        for ($k = 0; $k < count($meta["Classification"][$j]["TaxonPath"]); $k++)
                                        {
                                                $xml .= '<TaxonPath>';
                                                $xml .= '<Source Language="' . ilUtil::stripSlashes($meta["Classification"][$j]["TaxonPath"][$k]["Source"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Classification"][$j]["TaxonPath"][$k]["Source"]["Value"]) . '</Source>';
                                                for ($i = 0; $i < count($meta["Classification"][$j]["TaxonPath"][$k]["Taxon"]); $i++)
                                                {
                                                        $xml .= '<Taxon Language="' . ilUtil::stripSlashes($meta["Classification"][$j]["TaxonPath"][$k]["Taxon"][$i]["Language"]) . '" Id="' . str_replace("\"", "", ilUtil::stripSlashes($meta["Classification"][$j]["TaxonPath"][$k]["Taxon"][$i]["Id"])) . '">' . ilUtil::stripSlashes($meta["Classification"][$j]["TaxonPath"][$k]["Taxon"][$i]["Value"]) . '</Taxon>';
                                                }
                                                $xml .= '</TaxonPath>';
                                        }
                                        $xml .= '<Description Language="' . ilUtil::stripSlashes($meta["Classification"][$j]["Description"]["Language"]) . '">' . ilUtil::stripSlashes($meta["Classification"][$j]["Description"]["Value"]) . '</Description>';
                                        for ($i = 0; $i < count($meta["Classification"][$j]["Keyword"]); $i++)
                                        {
                                                $xml .= '<Keyword Language="' . ilUtil::stripSlashes($meta["Classification"][$j]["Keyword"][$i]["Language"]) . '">' . ilUtil::stripSlashes($meta["Classification"][$j]["Keyword"][$i]["Value"]) . '</Keyword>';
                                        }
                                        $xml .= '</Classification>';
#                                       echo htmlspecialchars($xml);
#                               }

                                $update = true;
                        }

                        if ($update)
                        {
                                $nodes[0]->unlink_node();

                                if ($xPath != "//Bibliography")
                                {
                                        $xPath = "//MetaData";
                                }
//echo "<br><br>savedA:".htmlspecialchars($this->dom->dump_mem(0));
                                $this->addXMLNode($xPath, $xml);
//echo "<br><br>savedB:".htmlspecialchars($this->dom->dump_mem(0));
                        }
                        return true;
                }
                else
                {
                        return false;
                }
        }

        function getDomContent($xPath, $name = "", $index = 0)
        {
                if ($index == "")
                {
                        $index = 0;
                }
#               echo "Index: " . $index . " | Path: " . $xPath . " | Name: " . $name . "<br>\n";
                $nodes = $this->getXpathNodes($this->dom, $xPath);
                if (count($nodes) > 0)
                {
                        $children = $nodes[$index]->child_nodes();
                        if (count($children) > 0)
                        {
                                $k = 0;
                                for ($i = 0; $i < count($children); $i++)
                                {
//echo "<br>ilNestedSetXML::getDomContent-".$children[$i]->node_name()."-".$name;
                                        if ($name == "" ||
                                                $children[$i]->node_name() == $name)
                                        {
                                                $content[$k]["value"] = $children[$i]->get_content();
                                                $a = $children[$i]->attributes();
                                                for ($j = 0; $j < count($a); $j++)
                                                {
                                                        $content[$k][$a[$j]->name()] = $a[$j]->value();
                                                }
                                                $k++;
                                        }
                                }
#                               vd($content);
                                return($content);
                        }
                }
                return false;
        }       

        function replaceDomContent($xPath, $name = "", $index = 0, $newNode) 
        {
#               echo "Index: " . $index . " | Path: " . $xPath . " | Name: " . $name . "<br>\n";
                $nodes = $this->getXpathNodes($this->dom, $xPath);
                if (count($nodes) > 0)
                {
                        $children = $nodes[$index]->child_nodes();
                        if (count($children) > 0)
                        {
                                for ($i = 0; $i < count($children); $i++)
                                {
                                        if ($children[$i]->node_name() == $name &&
                                                is_array($newNode))
                                        {
                                                foreach ($newNode as $key => $val)
                                                {
                                                        if ($key == "value")
                                                        {
                                                                $this->replace_content($children[$i], $val);
                                                        }
                                                        else
                                                        {
                                                                $children[$i]->set_attribute($key, $val);
                                                        }
                                                }
                                        }
                                }
                        }
                }
        }
        
        function replace_content( &$node, &$new_content )
        {
                $newnode =& $this->dom->create_element( $node->tagname() );
                $newnode->set_content( $new_content );
                $atts =& $node->attributes();
                foreach ( $atts as $att )
                {
                        $newnode->set_attribute( $att->name(), $att->value() );
                }
                $kids =& $node->child_nodes();
                foreach ( $kids as $kid )
                {
                        if ( $kid->node_type() != XML_TEXT_NODE )
                        {
                                $newnode->append_child( $kid );
                        }
                }
                $node->replace_node( $newnode );
        }

        function updateDomContent($xPath, $name = "", $index = 0, $newNode) 
        {
#               echo "Index: " . $index . " | Path: " . $xPath . " | Name: " . $name . "<br>\n";
                $nodes = $this->getXpathNodes($this->dom, $xPath);
                if (count($nodes) > 0)
                {
                        $children = $nodes[$index]->child_nodes();
                        if (count($children) > 0)
                        {
                                for ($i = 0; $i < count($children); $i++)
                                {
                                        if ($children[$i]->node_name() == $name &&
                                                is_array($newNode))
                                        {
                                                foreach ($newNode as $key => $val)
                                                {
                                                        if ($key == "value")
                                                        {
                                                                $children[$i]->set_content($val);
                                                        }
                                                        else
                                                        {
                                                                $children[$i]->set_attribute($key, $val);
                                                        }
                                                }
                                        }
                                }
                        }
                }
        }

        function getFirstDomNode($xPath)
        {
                $node = $this->getXpathNodes($this->dom,$xPath);
                return($node[0]);
        }

        function updateFromDom()
        {
                $this->deleteAllDbData();
                $xml = $this->dom->dump_mem(0);
                $this->import($xml,$this->obj_id,$this->obj_type);

        }

        function deleteAllDbData()
        {
                global $ilBench;

                #$ilBench->start('NestedSet','deleteAllDBData');
                $res = $this->db->query("SELECT * FROM xmlnestedset WHERE ns_book_fk='".$this->obj_id."' AND ns_type='".$this->obj_type."' ");
                while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $this->db->query("DELETE FROM xmlparam WHERE tag_fk='".$row["ns_tag_fk"]."' ");
                        $this->db->query("DELETE FROM xmlvalue WHERE tag_fk='".$row["ns_tag_fk"]."' ");
                        $this->db->query("DELETE FROM xmltags WHERE tag_pk='".$row["ns_tag_fk"]."' ");
                }
                $this->db->query("DELETE FROM xmlnestedset WHERE ns_book_fk='".$this->obj_id."' AND ns_type='".$this->obj_type."' ");
                #$ilBench->stop('NestedSet','deleteAllDBData');

        }

        function _deleteAllChildMetaData($a_ids)
        {
                global $ilBench,$ilDB;

                #$ilBench->start('NestedSet','deleteAllChildMetaData');

                // STEP TWO: DELETE ENTRIES IN xmlnestedset GET ALL tag_fks
                $in = " IN ('";
                $in .= implode("','", $a_ids);
                $in .= "')";

                $query = "SELECT ns_tag_fk FROM xmlnestedset ".
                        "WHERE ns_book_fk ".$in;
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $tag_fks[$row->ns_tag_fk] = $row->ns_tag_fk;
                }
                $ilDB->query("DELETE FROM xmlnestedset WHERE ns_book_fk ".$in);


                // FINALLY DELETE
                $in = " IN ('";
                $in .= implode("','", $tag_fks);
                $in .= "')";
                
                $ilDB->query("DELETE FROM xmlparam WHERE tag_fk ".$in);
                $ilDB->query("DELETE FROM xmlvalue WHERE tag_fk ".$in);
                $ilDB->query("DELETE FROM xmltags  WHERE tag_pk ".$in);

                #$ilBench->stop('NestedSet','deleteAllChildMetaData');
                return true;
        } 

        function _getAllChildIds($a_obj_id)
        {
                global $ilDB;

                $query = "SELECT obj_id FROM lm_data WHERE lm_id = '".$a_obj_id."'";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $ids[$row->obj_id] = $row->obj_id;
                }
                $ids[$a_obj_id] = $a_obj_id;

                return $ids ? $ids : array();
        }
                

    // }}}
    
}

?>