sesskey_protected = false; // This action doesn't need sesskey protection /// Get needed strings $this->loadStrings(array( 'change' => 'xmldb', 'vieworiginal' => 'xmldb', 'viewedited' => 'xmldb', 'yes' => '', 'no' => '', 'back' => 'xmldb' )); } /** * Invoke method, every class will have its own * returns true/false on completion, setting both * errormsg and output as necessary */ function invoke() { parent::invoke(); $result = true; /// Set own core attributes $this->does_generate = ACTION_GENERATE_HTML; /// These are always here global $CFG, $XMLDB; /// Do the job, setting result as needed /// Get the dir containing the file $dirpath = required_param('dir', PARAM_PATH); $dirpath = $CFG->dirroot . stripslashes_safe($dirpath); /// Get the correct dirs if (!empty($XMLDB->dbdirs)) { $dbdir =& $XMLDB->dbdirs[$dirpath]; } else { return false; } if (!empty($XMLDB->editeddirs)) { $editeddir =& $XMLDB->editeddirs[$dirpath]; $structure =& $editeddir->xml_file->getStructure(); } /// ADD YOUR CODE HERE /// Fetch request data $tableparam = required_param('table', PARAM_CLEAN); if (!$table =& $structure->getTable($tableparam)) { $this->errormsg = 'Wrong table specified: ' . $tableparam; return false; } $fieldparam = required_param('field', PARAM_CLEAN); if (!$field =& $table->getField($fieldparam)) { /// Arriving here from a name change, looking for the new field name $fieldparam = required_param('name', PARAM_CLEAN); $field =& $table->getField($fieldparam); } $dbdir =& $XMLDB->dbdirs[$dirpath]; $origstructure =& $dbdir->xml_file->getStructure(); /// Add the main form $o = '
'; $o.= '
'; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; /// XMLDB field name /// If the field has dependencies, we cannot change its name $disabled = ''; if ($structure->getFieldUses($table->getName(), $field->getName())) { $o.= ' '; $o.= ' '; } else { $o.= ' '; } /// XMLDB field comment $o.= ' '; /// XMLDBField Type $typeoptions = array (XMLDB_TYPE_INTEGER => $field->getXMLDBTypeName(XMLDB_TYPE_INTEGER), XMLDB_TYPE_NUMBER => $field->getXMLDBTypeName(XMLDB_TYPE_NUMBER), XMLDB_TYPE_FLOAT => $field->getXMLDBTypeName(XMLDB_TYPE_FLOAT), XMLDB_TYPE_DATETIME=> $field->getXMLDBTypeName(XMLDB_TYPE_DATETIME), XMLDB_TYPE_CHAR => $field->getXMLDBTypeName(XMLDB_TYPE_CHAR), XMLDB_TYPE_TEXT => $field->getXMLDBTypeName(XMLDB_TYPE_TEXT), XMLDB_TYPE_BINARY => $field->getXMLDBTypeName(XMLDB_TYPE_BINARY)); /// If current field isnt float, delete such column type to avoid its creation from the interface /// Note that float fields are supported completely but it's possible than in a next future /// we delete them completely from Moodle DB, using, exlusively, number(x,y) types if ($field->getType() != XMLDB_TYPE_FLOAT) { unset ($typeoptions[XMLDB_TYPE_FLOAT]); } /// Also we hide datetimes. Only edition of them is allowed (and retrofit) but not new creation if ($field->getType() != XMLDB_TYPE_DATETIME) { unset ($typeoptions[XMLDB_TYPE_DATETIME]); } $o.= ' '; $o.= ' '; /// XMLDBField Length $o.= ' '; $o.= ' '; /// XMLDBField Decimals $o.= ' '; $o.= ' '; /// XMLDBField Unsigned $unsignedoptions = array (0 => 'signed', 1 => 'unsigned'); $o.= ' '; $o.= ' '; /// XMLDBField NotNull $notnulloptions = array (0 => 'null', 'not null'); $o.= ' '; $o.= ' '; /// XMLDBField Sequence $sequenceoptions = array (0 => $this->str['no'], 1 => 'auto-numbered'); $o.= ' '; $o.= ' '; /// XMLDBField Enum and enumvalues $enumoptions = array (0 => $this->str['no'], 1 => $this->str['yes']); $o.= ' '; $o.= ' '; if (is_array($field->getEnumValues())) { $enumvalues = implode(', ', $field->getEnumValues()); } else { $enumvalues = ''; } $o.= ' '; /// XMLDBField Default $o.= ' '; $o.= ' '; /// Change button $o.= ' '; $o.= '
Name:' . s($field->getName()) . '
' . choose_from_menu($typeoptions, 'type', $field->getType(), '', '', '', true) . '
' . choose_from_menu($unsignedoptions, 'unsigned', $field->getUnsigned(), '', '', '', true) . '
' . choose_from_menu($notnulloptions, 'notnull', $field->getNotNull(), '', '', '', true) . '
' . choose_from_menu($sequenceoptions, 'sequence', $field->getSequence(), '', '', '', true) . '
' . choose_from_menu($enumoptions, 'enum', $field->getEnum(), '', '', '', true) . '
 
'; $o.= '
'; /// Calculate the buttons $b = '

'; /// The view original XML button if ($table->getField($fieldparam)) { $b .= ' [' . $this->str['vieworiginal'] . ']'; } else { $b .= ' [' . $this->str['vieworiginal'] . ']'; } /// The view edited XML button if ($field->hasChanged()) { $b .= ' [' . $this->str['viewedited'] . ']'; } else { $b .= ' [' . $this->str['viewedited'] . ']'; } /// The back to edit table button $b .= ' [' . $this->str['back'] . ']'; $b .= '

'; $o .= $b; $this->output = $o; /// Launch postaction if exists (leave this here!) if ($this->getPostAction() && $result) { return $this->launch($this->getPostAction()); } /// Return ok if arrived here return $result; } } ?>