ilScormEditorDBMigrationUtil Class Reference

DB Migration helper class. More...

Collaboration diagram for ilScormEditorDBMigrationUtil:

Public Member Functions
	__construct ()
	Constructor. More...
	addStyleClass ($a_class, $a_type, $a_tag, $a_parameters="", $a_hide=0)
	Add style class. More...

Static Public Member Functions
static	copyStyleClass ($a_orig_class, $a_class, $a_type, $a_tag, $a_hide=0)
	Create style class GlossaryLink, link, IntLink. More...

Protected Attributes
	$db

Detailed Description

DB Migration helper class.

Author

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version

$Id$ /

Definition at line 11 of file class.ilScormEditorDBMigrationUtil.php.

Constructor & Destructor Documentation

__construct()

ilScormEditorDBMigrationUtil::__construct

(

)

Constructor.

Definition at line 22 of file class.ilScormEditorDBMigrationUtil.php.

References $DIC.

    {
        global $DIC;

        $this->db = $DIC->database();
    }

Member Function Documentation

addStyleClass()

ilScormEditorDBMigrationUtil::addStyleClass	(		$a_class,
			$a_type,
			$a_tag,
			$a_parameters = "",
			$a_hide = 0
	)

Add style class.

Parameters

Definition at line 88 of file class.ilScormEditorDBMigrationUtil.php.

References $a_type, $db, and $ilDB.

    {
        $ilDB = $this->db;
        
        if ($a_parameters == "") {
            $a_parameters = array();
        }

        $set = $ilDB->query("SELECT * FROM object_data WHERE type = 'sty'");
        while ($rec = $ilDB->fetchAssoc($set)) {        // all styles
            $set2 = $ilDB->query("SELECT * FROM style_char WHERE " .
                "style_id = " . $ilDB->quote($rec["obj_id"], "integer") . " AND " .
                "characteristic = " . $ilDB->quote($a_class, "text") . " AND " .
                "type = " . $ilDB->quote($a_type, "text"));
            if (!$ilDB->fetchAssoc($set2)) {
                $q = "INSERT INTO style_char (style_id, type, characteristic, hide)" .
                    " VALUES (" .
                    $ilDB->quote($rec["obj_id"], "integer") . "," .
                    $ilDB->quote($a_type, "text") . "," .
                    $ilDB->quote($a_class, "text") . "," .
                    $ilDB->quote($a_hide, "integer") . ")";
    
                $ilDB->manipulate($q);
                foreach ($a_parameters as $k => $v) {
                    $spid = $ilDB->nextId("style_parameter");
                    $q = "INSERT INTO style_parameter (id, style_id, type, class, tag, parameter, value)" .
                        " VALUES (" .
                        $ilDB->quote($spid, "integer") . "," .
                        $ilDB->quote($rec["obj_id"], "integer") . "," .
                        $ilDB->quote($a_type, "text") . "," .
                        $ilDB->quote($a_class, "text") . "," .
                        $ilDB->quote($a_tag, "text") . "," .
                        $ilDB->quote($k, "text") . "," .
                        $ilDB->quote($v, "text") .
                        ")";
    
                    $ilDB->manipulate($q);
                }
            }
        }
    }

copyStyleClass()

static ilScormEditorDBMigrationUtil::copyStyleClass (   $a_orig_class,   $a_class,   $a_type,   $a_tag,   $a_hide = 0  )

static

Create style class GlossaryLink, link, IntLink.

Parameters

Definition at line 36 of file class.ilScormEditorDBMigrationUtil.php.

References $a_type, $DIC, and $ilDB.

    {
        global $DIC;

        $ilDB = $DIC->database();
    
        $set = $ilDB->query("SELECT * FROM object_data WHERE type = 'sty'");
        while ($rec = $ilDB->fetchAssoc($set)) {        // all styles
            $set2 = $ilDB->query("SELECT * FROM style_char WHERE " .
                "style_id = " . $ilDB->quote($rec["obj_id"], "integer") . " AND " .
                "characteristic = " . $ilDB->quote($a_class, "text") . " AND " .
                "type = " . $ilDB->quote($a_type, "text"));
            if (!$ilDB->fetchAssoc($set2)) {
                $q = "INSERT INTO style_char (style_id, type, characteristic, hide)" .
                    " VALUES (" .
                    $ilDB->quote($rec["obj_id"], "integer") . "," .
                    $ilDB->quote($a_type, "text") . "," .
                    $ilDB->quote($a_class, "text") . "," .
                    $ilDB->quote($a_hide, "integer") . ")";
                $ilDB->manipulate($q);
                
                $set3 = $ilDB->query(
                    "SELECT * FROM style_parameter WHERE " .
                    "style_id = " . $ilDB->quote($rec["obj_id"], "integer") . " AND " .
                    "type = " . $ilDB->quote($a_type, "text") . " AND " .
                    "class = " . $ilDB->quote($a_orig_class, "text") . " AND " .
                    "tag = " . $ilDB->quote($a_tag, "text")
                );
                while ($rec3 = $ilDB->fetchAssoc($set3)) {      // copy parameters
                    $spid = $ilDB->nextId("style_parameter");
                    $q = "INSERT INTO style_parameter (id, style_id, type, class, tag, parameter, value)" .
                        " VALUES (" .
                        $ilDB->quote($spid, "integer") . "," .
                        $ilDB->quote($rec["obj_id"], "integer") . "," .
                        $ilDB->quote($rec3["type"], "text") . "," .
                        $ilDB->quote($a_class, "text") . "," .
                        $ilDB->quote($a_tag, "text") . "," .
                        $ilDB->quote($rec3["parameter"], "text") . "," .
                        $ilDB->quote($rec3["value"], "text") .
                        ")";
                    $ilDB->manipulate($q);
                }
            }
        }
    }

Field Documentation

$db

ilScormEditorDBMigrationUtil::$db

protected

Definition at line 16 of file class.ilScormEditorDBMigrationUtil.php.

Referenced by addStyleClass().

---

The documentation for this class was generated from the following file:

• Modules/Scorm2004/classes/class.ilScormEditorDBMigrationUtil.php