samsoncms / api

    }

    /** @return array Collection of navigation additional fields */

    protected function navigationFields($navigationID)

    {

        $return = array();

        // TODO: Optimize queries make one single query with only needed data

        foreach ($this->database->fetch('SELECT * FROM `structurefield` WHERE `StructureID` = "' . $navigationID . '" AND `Active` = "1"') as $fieldStructureRow) {

            foreach ($this->database->fetch('SELECT * FROM `field` WHERE `FieldID` = "' . $fieldStructureRow['FieldID'] . '"') as $fieldRow) {

                $return[$fieldRow['FieldID']] = $fieldRow;

            }

        }

        return $return;

    }

    /**

     * Get correct field name.

    }

    /** @return array Collection of navigation additional fields */

    protected function navigationFields($navigationID)

    {

        $return = array();

        // TODO: Optimize queries make one single query with only needed data

        foreach ($this->database->fetch('SELECT * FROM `structurefield` WHERE `StructureID` = "' . $navigationID . '" AND `Active` = "1"') as $fieldStructureRow) {

            foreach ($this->database->fetch('SELECT * FROM `field` WHERE `FieldID` = "' . $fieldStructureRow['FieldID'] . '"') as $fieldRow) {

                $return[$fieldRow['FieldID']] = $fieldRow;

            }

        }

        return $return;

    }

    /**

     * Get correct field name.