inc.meta_data_converter.php

Go to the documentation of this file.

<?php

function ilMDConvert($table,$fields,$key)
{
        global $ilDB;

        $where = "WHERE ";
        $where .= implode(" LIKE '%\%' ESCAPE '�' OR ", ilUtil::quoteArray($fields));
        $where .= " LIKE '%\\%' ESCAPE '�'";

        $query = "SELECT * FROM ".$table." ".
                $where;

        $res = $ilDB->query($query);
        while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
        {
                $query = "UPDATE $table ";

                $counter = 0;
                foreach($fields as $field)
                {
                        if($counter++)
                                $query .= ", ";
                        else
                                $query .= "SET ";

                        $query .= ($field ." = ".$ilDB->quote(stripslashes($row->$field))." ");
                }
                $query .= (" WHERE ".$key." = ".$ilDB->quote($row->$key));

                // Perform the query
                $ilDB->query($query);
        }
}