From: <txm...@us...> - 2015-04-21 17:28:10
|
Revision: 13040 http://sourceforge.net/p/xoops/svn/13040 Author: txmodxoops Date: 2015-04-21 17:27:59 +0000 (Tue, 21 Apr 2015) Log Message: ----------- Updated Fixed bugs for field main Work in progress Modified Paths: -------------- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/fields.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateArchitecture.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateStructure.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/admin/AdminPages.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/classes/ClassFormElements.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/user/UserPages.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadio.php XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/sql/mysql.sql XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/templates/admin/tdmcreate_fields.tpl Added Paths: ----------- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/language/english/mail_template/ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/language/english/mail_template/index.html Removed Paths: ------------- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/assets/images/icons/ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadioCopia.php Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/fields.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/fields.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/fields.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -253,8 +253,8 @@ $check_field_block->addOption(1, _AM_TDMCREATE_FIELD_BLOCK); $parameters_tray->addElement($check_field_block); - $main = ($table_autoincrement == 1) ? 2 : 1; - $check_field_main = new TDMCreateFormRadio('', 'field_main', $i, $main);//['.$i.'] + $field_main = ($table_autoincrement == 1) ? 2 : 1; + $check_field_main = new TDMCreateFormRadio('', 'field_main', $field_main); $check_field_main->addOption($i, _AM_TDMCREATE_FIELD_MAINFIELD ); $parameters_tray->addElement($check_field_main); @@ -294,8 +294,7 @@ // Get the list of fields $criteria = new CriteriaCompo(); $criteria->add(new Criteria('field_mid', $field_mid)); - $criteria->add(new Criteria('field_tid', $field_tid)); - //$criteria->add(new Criteria('field_numb', $field_numb)); + $criteria->add(new Criteria('field_tid', $field_tid)); $criteria->setSort('field_id'); //added by goffy $fields = $this->tdmcreate->getHandler('fields')->getObjects($criteria); unset($criteria); @@ -383,7 +382,7 @@ $parameters_tray->addElement($check_field_block); $field_main = ($field->getVar('field_main') == 1) ? $id : 1; - $check_field_main = new TDMCreateFormRadio('', 'field_main', $id, $field_main); + $check_field_main = new TDMCreateFormRadio('', 'field_main', $field_main); $check_field_main->addOption($id, _AM_TDMCREATE_FIELD_MAINFIELD ); $parameters_tray->addElement($check_field_main); Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateArchitecture.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateArchitecture.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateArchitecture.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -197,7 +197,6 @@ } } } - var_dump($indexFile); } /* Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateStructure.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateStructure.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/TDMCreateStructure.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -170,7 +170,7 @@ } /* * @public function copy file - * @param string $foldername + * @param string $folderName * @param string $fromFile * @param string $toFile */ Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/admin/AdminPages.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/admin/AdminPages.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/admin/AdminPages.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -133,10 +133,10 @@ case 8: $ret .= $this->adminobjects->getSelectUserGetVar($lpFieldName, $rpFieldName, $tableName, $fieldName); break; - case 11: + case 12: $ret .= $this->adminobjects->getUploadImageGetVar($lpFieldName, $rpFieldName, $tableName, $fieldName); break; - case 13: + case 14: $ret .= $this->adminobjects->getTextDateSelectGetVar($lpFieldName, $rpFieldName, $tableName, $fieldName); break; default: @@ -145,22 +145,22 @@ $fieldElements = $this->tdmcreate->getHandler('fieldelements')->get($fieldElement); $fieldElementTid = $fieldElements->getVar('fieldelement_tid'); $fieldElementName = $fieldElements->getVar('fieldelement_name'); - $rpFieldElementName = strtolower(str_replace('Table : ', '', $fieldElementName)); - } - // - $fieldNameParent = $fieldName; - // - $criteriaFieldsTopic = new CriteriaCompo(); - $criteriaFieldsTopic->add(new Criteria('field_tid', $fieldElementTid)); - $fieldsTopic = $this->tdmcreate->getHandler('fields')->getObjects($criteriaFieldsTopic); - unset($criteriaFieldsTopic); - foreach(array_keys($fieldsTopic) as $ft) - { - if( $fieldsTopic[$ft]->getVar('field_main') == 1 ) { - $fieldNameTopic = $fieldsTopic[$ft]->getVar('field_name'); + $rpFieldElementName = strtolower(str_replace('Table : ', '', $fieldElementName)); + // + $fieldNameParent = $fieldName; + // + $criteriaFieldsTopic = new CriteriaCompo(); + $criteriaFieldsTopic->add(new Criteria('field_tid', $fieldElementTid)); + $fieldsTopic = $this->tdmcreate->getHandler('fields')->getObjects($criteriaFieldsTopic); + unset($criteriaFieldsTopic); + foreach(array_keys($fieldsTopic) as $ft) + { + if( $fieldsTopic[$ft]->getVar('field_main') == 1 ) { + $fieldNameTopic = $fieldsTopic[$ft]->getVar('field_name'); + } } + $ret .= $this->adminobjects->getTopicGetVar($lpFieldName, $rpFieldName, $tableName, $rpFieldElementName, $fieldNameParent, $fieldNameTopic); } - $ret .= $this->adminobjects->getTopicGetVar($lpFieldName, $rpFieldName, $tableName, $rpFieldElementName, $fieldNameParent, $fieldNameTopic); } else { $ret .= $this->adminobjects->getSimpleGetVar($lpFieldName, $rpFieldName, $tableName, $fieldName); } Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/classes/ClassFormElements.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/classes/ClassFormElements.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/classes/ClassFormElements.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -167,6 +167,31 @@ return $ret; } /* + * @private function getXoopsFormTextFile + * @param string $language + * @param string $moduleDirname + * @param string $fieldName + * @param string $fieldDefault + * @param string $fieldElement + * @param string $required + */ + private function getXoopsFormTextFile($language, $moduleDirname, $fieldName, $fieldDefault, $fieldElement, $required = 'false') { + if($fieldElement == 11 ) { + $f_text = $fieldName; + $f_default = $fieldDefault; + } + $ret = <<<EOT + // Form Text File + \$formTextFile = new XoopsFormElementTray({$language}FORM_FILE,'<br /><br />'); + \$field_text = \$this->isNew() ? '{$f_default}' : \$this->getVar('{$f_text}'); + \$formText = new XoopsFormText({$language}FORM_TEXT, '{$f_text}', 75, 255, \$field_text); + \$formTextFile->addElement(\$formText{$required} ); + \$formTextFile->addElement(new XoopsFormFile({$language}FORM_UPLOAD , 'attachedfile', \$this->{$moduleDirname}->getConfig('maxsize')){$required}); + \$form->addElement(\$formTextFile);\n +EOT; + return $ret; + } + /* * @private function getXoopsFormUploadImage * @param string $language * @param string $moduleDirname @@ -279,7 +304,7 @@ private function getXoopsFormTable($language, $moduleDirname, $tableName, $fieldName, $fieldElement, $required = 'false') { $ucfTableName = ucfirst($tableName); - if($fieldElement > 13) { + if($fieldElement > 14) { $fElement = $this->tdmcreate->getHandler('fieldelements')->get($fieldElement); $rpFieldelementName = strtolower(str_replace('Table : ', '', $fElement->getVar('fieldelement_name'))); } @@ -347,6 +372,7 @@ foreach(array_keys($fields) as $f) { $fieldName = $fields[$f]->getVar('field_name'); + $fieldDefault = $fields[$f]->getVar('field_default'); $fieldElement = $fields[$f]->getVar('field_element'); $fieldParent = $fields[$f]->getVar('field_parent'); $fieldInForm = $fields[$f]->getVar('field_inform'); @@ -396,12 +422,15 @@ $ret .= $this->getXoopsFormImageList($language_funct, $moduleDirname, $tableName, $fieldName, $required); break; case 11: + $ret .= $this->getXoopsFormTextFile($language, $moduleDirname, $fieldName, $fieldDefault, $fieldElement, $required); + break; + case 12: $ret .= $this->getXoopsFormUploadImage($language_funct, $moduleDirname, $tableName, $required); break; - case 12: + case 13: $ret .= $this->getXoopsFormUploadFile($language, $moduleDirname, $tableName, $fieldName, $required); break; - case 13: + case 14: $ret .= $this->getXoopsFormTextDateSelect($language, $moduleDirname, $fieldName, $required); break; default: @@ -411,7 +440,7 @@ } break; } - if ($fieldElement > 13) { + if ($fieldElement > 14) { if($table->getVar('table_category') == 1) { $ret .= $this->getXoopsFormTopic($language, $moduleDirname, $table, $fields, $required); } else { Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/user/UserPages.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/user/UserPages.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/files/user/UserPages.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -125,22 +125,22 @@ $fieldElements = $this->tdmcreate->getHandler('fieldelements')->get($fieldElement); $fieldElementTid = $fieldElements->getVar('fieldelement_tid'); $fieldElementName = $fieldElements->getVar('fieldelement_name'); - $rpFieldElementName = strtolower(str_replace('Table : ', '', $fieldElementName)); - } - // - $fieldNameParent = $fieldName; - // - $criteriaFieldsTopic = new CriteriaCompo(); - $criteriaFieldsTopic->add(new Criteria('field_tid', $fieldElementTid)); - $fieldsTopic = $this->tdmcreate->getHandler('fields')->getObjects($criteriaFieldsTopic); - unset($criteriaFieldsTopic); - foreach(array_keys($fieldsTopic) as $ft) - { - if( $fieldsTopic[$ft]->getVar('field_main') == 1 ) { - $fieldNameTopic = $fieldsTopic[$ft]->getVar('field_name'); + $rpFieldElementName = strtolower(str_replace('Table : ', '', $fieldElementName)); + // + $fieldNameParent = $fieldName; + // + $criteriaFieldsTopic = new CriteriaCompo(); + $criteriaFieldsTopic->add(new Criteria('field_tid', $fieldElementTid)); + $fieldsTopic = $this->tdmcreate->getHandler('fields')->getObjects($criteriaFieldsTopic); + unset($criteriaFieldsTopic); + foreach(array_keys($fieldsTopic) as $ft) + { + if( $fieldsTopic[$ft]->getVar('field_main') == 1 ) { + $fieldNameTopic = $fieldsTopic[$ft]->getVar('field_name'); + } } + $ret .= $this->userobjects->getTopicGetVar($lpFieldName, $rpFieldName, $tableName, $rpFieldElementName, $fieldNameParent, $fieldNameTopic); } - $ret .= $this->userobjects->getTopicGetVar($lpFieldName, $rpFieldName, $tableName, $rpFieldElementName, $fieldNameParent, $fieldNameTopic); } else { $ret .= $this->userobjects->getSimpleGetVar($lpFieldName, $rpFieldName, $tableName, $fieldName); } Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadio.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadio.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadio.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -28,14 +28,6 @@ var $_options = array(); /** - * Pre-selected id - * - * @var integer - * @access private - */ - var $_id = null; - - /** * Pre-selected value * * @var string @@ -67,11 +59,10 @@ * @param string $value Pre-selected value * @param string $delimeter */ - function TDMCreateFormRadio($caption, $name, $id, $value = null, $delimeter = ' ') + function TDMCreateFormRadio($caption, $name, $value = null, $delimeter = ' ') { $this->setCaption($caption); $this->setName($name); - $this->setId($id); if (isset($value)) { $this->setValue($value); } @@ -98,29 +89,8 @@ { $this->_value = $value; } - - /** - * Get the "_id" attribute - * - * @param null - * @return string - */ - function getId() - { - return $this->_id; - } /** - * Set the pre-selected id - * - * @param $_id string - */ - function setId($_id) - { - $this->_id = $_id; - } - - /** * Add an option * * @param string $value "value" attribute - This gets submitted as form-data. @@ -189,31 +159,29 @@ { $ret = ''; $ele_name = $this->getName(); - $ele_id = $this->getId(); $ele_title = $this->getTitle(); $ele_value = $this->getValue(); $ele_options = $this->getOptions(); $ele_extra = $this->getExtra(); $ele_delimeter = empty($this->columns) ? $this->getDelimeter() : ''; if (! empty($this->columns)) { - $ret .= '<table><tr>'; + $ret .= '<table class="table table-bordered"><tr>'; } $i = 0; - + $id_ele = 0; foreach ($ele_options as $value => $name) { + $id_ele++; if (! empty($this->columns)) { if ($i % $this->columns == 0) { $ret .= '<tr>'; } - $ret .= '<td>'; + $ret .= '<td class="radio">'; } - $ent_title = htmlspecialchars($ele_title, ENT_QUOTES); - $ent_value = htmlspecialchars($value, ENT_QUOTES); - $ret .= "<input type='radio' name='{$ele_name}' id='{$ele_name}[{$ele_id}]' title='{$ent_title}' value='{$ent_value}'"; + $ret .= '<input type="radio" name="' . $ele_name . '" id="' . $ele_name . '[' .$value. ']' . $id_ele. '" title = "' . htmlspecialchars($ele_title, ENT_QUOTES) . '" value="' . htmlspecialchars($value, ENT_QUOTES) . '"'; if (isset($ele_value) && $value == $ele_value) { - $ret .= " checked='checked'"; + $ret .= ' checked="checked"'; } - $ret .= $ele_extra . " />" . "<label name='xolb_{$ele_name}[{$ent_value}]' for='{$ele_name}[{$ele_id}]'>{$name}</label>" . $ele_delimeter ; + $ret .= $ele_extra . ' />' . "<label name='xolb_{$ele_name}' for='" . $ele_name . '[' .$value. ']' . $id_ele. "'><span><span></span></span>" . $name . "</label>" . $ele_delimeter ; if (! empty($this->columns)) { $ret .= '</td>'; if (++ $i % $this->columns == 0) { @@ -227,6 +195,7 @@ } $ret .= '</table>'; } + return $ret; } } \ No newline at end of file Deleted: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadioCopia.php =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadioCopia.php 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/class/form/TDMCreateFormRadioCopia.php 2015-04-21 17:27:59 UTC (rev 13040) @@ -1,220 +0,0 @@ -<?php -/** - * XOOPS form radio compo - * - * You may not change or alter any portion of this comment or credits - * of supporting developers from this source code or any supporting source code - * which is considered copyrighted (c) material of the original comment or credit authors. - * 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. - * - * @copyright The XOOPS project http://www.xoops.org/ - * @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html) - * @package tdmcreate - * @since 1.91 - * @author Kazumi Ono (AKA onokazu) http://www.myweb.ne.jp/, http://jp.xoops.org/ - * @author Taiwen Jiang <ph...@us...> - * @version $Id: TDMCreateFormRadio.php 12360 2014-12-06 13:18:22Z timgno $ - */ -class TDMCreateFormRadio extends XoopsFormElement -{ - /** - * Array of Options - * - * @var array - * @access private - */ - private $_options = array(); - - /** - * Pre-selected value - * - * @var integer - * @access private - */ - private $_id = null; - - /** - * Pre-selected value - * - * @var string - * @access private - */ - private $_value = null; - - /** - * Checked for selection - * - * @var boolean - * @access private - */ - private $checked; - - /** - * HTML to seperate the elements - * - * @var string - * @access private - */ - private $_delimeter; - - /** - * Column number for rendering - * - * @var int - * @access public - */ - public $columns; - - /** - * Constructor - * - * @param string $caption Caption - * @param string $name "name" attribute - * @param integer $id "id" attribute - * @param string $value Pre-selected value - * @param string $delimeter - */ - function TDMCreateFormRadio($caption, $name, $value = null, $checked = false, $delimeter = ' ') - { - $this->setCaption($caption); - $this->setName($name); - if (isset($value)) { - $this->setValue($value); - } - $this->checked = $checked; - $this->_delimeter = $delimeter; - } - - /** - * Get the "value" attribute - * - * @param bool $encode To sanitizer the text? - * @return string - */ - function getValue($encode = false) - { - return ($encode && $this->_value !== null) ? htmlspecialchars($this->_value, ENT_QUOTES) : $this->_value; - } - - /** - * Set the pre-selected value - * - * @param $value string - */ - function setValue($value) - { - $this->_value = $value; - } - - /** - * Add an option - * - * @param string $value "value" attribute - This gets submitted as form-data. - * @param string $name "name" attribute - This is displayed. If empty, we use the "value" instead. - */ - function addOption($value, $name = '') - { - if ($name != '') { - $this->_options[$value] = $name; - } else { - $this->_options[$value] = $value; - } - } - - /** - * Adds multiple options - * - * @param array $options Associative array of value->name pairs. - */ - function addOptionArray($options) - { - if (is_array($options)) { - foreach ($options as $k => $v) { - $this->addOption($k, $v); - } - } - } - - /** - * Get an array with all the options - * - * @param bool|int $encode To sanitizer the text? potential values: 0 - skip; 1 - only for value; 2 - for both value and name - * - * @return array Associative array of value->name pairs - */ - function getOptions($encode = false) - { - if (! $encode) { - return $this->_options; - } - $value = array(); - foreach ($this->_options as $val => $name) { - $value[$encode ? htmlspecialchars($val, ENT_QUOTES) : $val] = ($encode > 1) ? htmlspecialchars($name, ENT_QUOTES) : $name; - } - - return $value; - } - - /** - * Get the delimiter of this group - * - * @param bool $encode To sanitizer the text? - * @return string The delimiter - */ - function getDelimeter($encode = false) - { - return $encode ? htmlspecialchars(str_replace(' ', ' ', $this->_delimeter)) : $this->_delimeter; - } - - /** - * Prepare HTML for output - * - * @return string HTML - */ - function render() - { - $ret = ''; - $ele_name = $this->getName(); - $ele_id = $this->getId(); - $ele_value = $this->getValue(); - $ele_options = $this->getOptions(); - $ele_extra = $this->getExtra(); - $ele_delimeter = empty($this->columns) ? $this->getDelimeter() : ''; - if (! empty($this->columns)) { - $ret .= '<table><tr>'; - } - $i = 0; - foreach ($ele_options as $value => $name) { - if (! empty($this->columns)) { - if ($i % $this->columns == 0) { - $ret .= '<tr>'; - } - $ret .= '<td>'; - } - if (isset($ele_value) && $value == $ele_value) { - $check = " checked='checked'"; - } - if ($this->checked) { - $ret .= "<input type='radio' name='{$ele_name}' id='{$ele_id}' value='{$value}'{$check}"; - } else { - $ret .= "<input type='radio' name='{$ele_name}' id='{$ele_id}' value='{$value}'"; - } - $ret .= $ele_extra . " />" . "<label name='xolb_{$ele_name}' for='" . $ele_name . $ele_value. "'>" . $name . "</label>" . $ele_delimeter ; - if (! empty($this->columns)) { - $ret .= '</td>'; - if (++ $i % $this->columns == 0) { - $ret .= '</tr>'; - } - } - } - if (! empty($this->columns)) { - if ($span = $i % $this->columns) { - $ret .= '<td colspan="' . ($this->columns - $span) . '"></td></tr>'; - } - $ret .= '</table>'; - } - return $ret; - } -} \ No newline at end of file Added: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/language/english/mail_template/index.html =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/language/english/mail_template/index.html (rev 0) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/language/english/mail_template/index.html 2015-04-21 17:27:59 UTC (rev 13040) @@ -0,0 +1 @@ +<script>history.go(-1);</script> \ No newline at end of file Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/sql/mysql.sql =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/sql/mysql.sql 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/sql/mysql.sql 2015-04-21 17:27:59 UTC (rev 13040) @@ -1,259 +1,260 @@ -# SQL Dump for tdmcreate module -# PhpMyAdmin Version: 4.0.4 -# http://www.phpmyadmin.net -# -# Host: localhost -# Generated on: Thu Jen 02, 2014 to 19:12 -# Server version: 5.5.24-log -# PHP Version: 5.3.13 - -# -# Table structure for table `tdmcreate_modules` 38 -# - -CREATE TABLE `tdmcreate_modules` ( - `mod_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `mod_name` VARCHAR(255) NOT NULL DEFAULT '', - `mod_dirname` VARCHAR(100) NOT NULL DEFAULT '', - `mod_version` VARCHAR(5) NOT NULL DEFAULT '1.0', - `mod_since` VARCHAR(5) NOT NULL DEFAULT '1.0', - `mod_min_php` VARCHAR(5) NOT NULL DEFAULT '5.3', - `mod_min_xoops` VARCHAR(5) NOT NULL DEFAULT '2.5.7', - `mod_min_admin` VARCHAR(5) NOT NULL DEFAULT '1.1', - `mod_min_mysql` VARCHAR(5) NOT NULL DEFAULT '5.0.7', - `mod_description` TEXT, - `mod_author` VARCHAR(255) NOT NULL DEFAULT 'TDM XOOPS', - `mod_author_mail` VARCHAR(255) NOT NULL DEFAULT 'in...@em...', - `mod_author_website_url` VARCHAR(255) NOT NULL DEFAULT 'http://', - `mod_author_website_name` VARCHAR(255) NOT NULL DEFAULT '', - `mod_credits` VARCHAR(255) NOT NULL DEFAULT 'TDM XOOPS', - `mod_license` VARCHAR(255) NOT NULL DEFAULT 'GNU', - `mod_release_info` VARCHAR(255) NOT NULL DEFAULT '', - `mod_release_file` VARCHAR(255) NOT NULL DEFAULT '', - `mod_manual` VARCHAR(255) NOT NULL DEFAULT '', - `mod_manual_file` VARCHAR(255) NOT NULL DEFAULT '', - `mod_image` VARCHAR(255) NOT NULL DEFAULT '', - `mod_demo_site_url` VARCHAR(255) NOT NULL DEFAULT 'http://', - `mod_demo_site_name` VARCHAR(255) NOT NULL DEFAULT '', - `mod_support_url` VARCHAR(255) NOT NULL DEFAULT 'http://', - `mod_support_name` VARCHAR(255) NOT NULL DEFAULT '', - `mod_website_url` VARCHAR(255) NOT NULL DEFAULT 'http://', - `mod_website_name` VARCHAR(255) NOT NULL DEFAULT '', - `mod_release` VARCHAR(11) NOT NULL DEFAULT '00-00-0000', - `mod_status` VARCHAR(150) NOT NULL DEFAULT 'Beta 1', - `mod_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', - `mod_user` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', - `mod_blocks` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', - `mod_search` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `mod_comments` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `mod_notifications` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `mod_permissions` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `mod_inroot_copy` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', - `mod_donations` VARCHAR(50) NOT NULL DEFAULT '6KJ7RW5DR3VTJ', - `mod_subversion` VARCHAR(10) NOT NULL DEFAULT '12550', - PRIMARY KEY (`mod_id`), - KEY `mod_name` (`mod_name`), - UNIQUE KEY `mod_dirname` (`mod_dirname`) -)ENGINE =MyISAM; - - -CREATE TABLE `tdmcreate_tables` ( - `table_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `table_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0', - `table_category` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_name` VARCHAR(150) NOT NULL DEFAULT '', - `table_fieldname` VARCHAR(150) NOT NULL DEFAULT '', - `table_nbfields` INT(5) UNSIGNED NOT NULL DEFAULT '0', - `table_image` VARCHAR(150) NOT NULL DEFAULT '', - `table_autoincrement` TINYINT(1) NOT NULL DEFAULT '1', - `table_blocks` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', - `table_user` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_submenu` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_submit` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_tag` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_broken` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_search` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_comments` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_notifications` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_permissions` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_rate` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_print` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_pdf` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_rss` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_single` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - `table_visit` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (`table_id`), - KEY `table_mid` (`table_mid`), - UNIQUE KEY `table_name` (`table_name`) -)ENGINE =MyISAM; - -# -# Table structure for table `tdmcreate_fields` 21 -# - -CREATE TABLE `tdmcreate_fields` ( - `field_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT, - `field_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0', - `field_tid` INT(5) UNSIGNED NOT NULL DEFAULT '0', - `field_numb` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `field_order` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0', - `field_name` VARCHAR(255) NOT NULL DEFAULT '', - `field_type` VARCHAR(100) NOT NULL DEFAULT '', - `field_value` CHAR(4) NOT NULL DEFAULT '', - `field_attribute` VARCHAR(50) NOT NULL DEFAULT '', - `field_null` CHAR(10) NOT NULL DEFAULT '', - `field_default` VARCHAR(150) NOT NULL DEFAULT '', - `field_key` CHAR(10) NOT NULL DEFAULT '', - `field_element` VARCHAR(150) NOT NULL DEFAULT '', - `field_parent` TINYINT(1) NOT NULL DEFAULT '0', - `field_inlist` TINYINT(1) NOT NULL DEFAULT '0', - `field_inform` TINYINT(1) NOT NULL DEFAULT '0', - `field_admin` TINYINT(1) NOT NULL DEFAULT '0', - `field_user` TINYINT(1) NOT NULL DEFAULT '0', - `field_block` TINYINT(1) NOT NULL DEFAULT '0', - `field_main` TINYINT(1) NOT NULL DEFAULT '0', - `field_search` TINYINT(1) NOT NULL DEFAULT '0', - `field_required` TINYINT(1) NOT NULL DEFAULT '0', - PRIMARY KEY (`field_id`), - KEY `field_mid` (`field_mid`), - KEY `field_tid` (`field_tid`), - KEY `field_name` (`field_name`) -)ENGINE =MyISAM; - -# -# Table structure for table `tdmcreate_languages` 5 -# - -CREATE TABLE `tdmcreate_languages` ( - `lng_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `lng_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0', - `lng_file` VARCHAR(255) NOT NULL DEFAULT '', - `lng_define` VARCHAR(255) NOT NULL DEFAULT '', - `lng_description` VARCHAR(255) NOT NULL DEFAULT '', - PRIMARY KEY (`lng_id`), - KEY `lng_mid` (`lng_mid`) -)ENGINE =MyISAM; - -# -# Table structure for table `tdmcreate_fieldtype` 2 -# - -CREATE TABLE `tdmcreate_fieldtype` ( - `fieldtype_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `fieldtype_name` VARCHAR(100) NOT NULL DEFAULT '', - `fieldtype_value` VARCHAR(100) NOT NULL DEFAULT '', - PRIMARY KEY (`fieldtype_id`), - KEY `fieldtype_name` (`fieldtype_name`) -)ENGINE =MyISAM; - -INSERT INTO `tdmcreate_fieldtype` (`fieldtype_id`, `fieldtype_name`, `fieldtype_value`) VALUES - (1, '...', ''), - (2, 'INT', 'INT'), - (3, 'TINYINT', 'TINYINT'), - (4, 'MEDIUMINT', 'MEDIUMINT'), - (5, 'SMALLINT', 'SMALLINT'), - (6, 'FLOAT', 'FLOAT'), - (7, 'DOUBLE', 'DOUBLE'), - (8, 'DECIMAL', 'DECIMAL'), - (9, 'SET', 'SET'), - (10, 'ENUM', 'ENUM'), - (11, 'EMAIL', 'EMAIL'), - (12, 'URL', 'URL'), - (13, 'CHAR', 'CHAR'), - (14, 'VARCHAR', 'VARCHAR'), - (15, 'TEXT', 'TEXT'), - (16, 'TINYTEXT', 'TINYTEXT'), - (17, 'MEDIUMTEXT', 'MEDIUMTEXT'), - (18, 'LONGTEXT', 'LONGTEXT'), - (19, 'DATE', 'DATE'), - (20, 'DATETIME', 'DATETIME'), - (21, 'TIMESTAMP', 'TIMESTAMP'), - (22, 'TIME', 'TIME'), - (23, 'YEAR', 'YEAR'); - -# -# Table structure for table `tdmcreate_fieldattributes` 3 -# - -CREATE TABLE `tdmcreate_fieldattributes` ( - `fieldattribute_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `fieldattribute_name` VARCHAR(100) NOT NULL DEFAULT '', - `fieldattribute_value` VARCHAR(100) NOT NULL DEFAULT '', - PRIMARY KEY (`fieldattribute_id`), - KEY `fieldattribute_name` (`fieldattribute_name`) -)ENGINE =MyISAM; - -INSERT INTO `tdmcreate_fieldattributes` (`fieldattribute_id`, `fieldattribute_name`, `fieldattribute_value`) VALUES - (1, '...', ''), - (2, 'BINARY', 'BINARY'), - (3, 'UNSIGNED', 'UNSIGNED'), - (4, 'UNSIGNED_ZEROFILL', 'UNSIGNED_ZEROFILL'), - (5, 'CURRENT_TIMESTAMP', 'CURRENT_TIMESTAMP'); - -# -# Table structure for table `tdmcreate_fieldnull` 3 -# - -CREATE TABLE `tdmcreate_fieldnull` ( - `fieldnull_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `fieldnull_name` VARCHAR(100) NOT NULL DEFAULT '', - `fieldnull_value` VARCHAR(100) NOT NULL DEFAULT '', - PRIMARY KEY (`fieldnull_id`), - KEY `fieldnull_name` (`fieldnull_name`) -)ENGINE =MyISAM; - -INSERT INTO `tdmcreate_fieldnull` (`fieldnull_id`, `fieldnull_name`, `fieldnull_value`) VALUES - (1, '...', ''), - (2, 'NOT NULL', 'NOT NULL'), - (3, 'NULL', 'NULL'); - -# -# Table structure for table `tdmcreate_fieldkey` 3 -# - -CREATE TABLE `tdmcreate_fieldkey` ( - `fieldkey_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `fieldkey_name` VARCHAR(100) NOT NULL DEFAULT '', - `fieldkey_value` VARCHAR(100) NOT NULL DEFAULT '', - PRIMARY KEY (`fieldkey_id`), - KEY `fieldkey_name` (`fieldkey_name`) -)ENGINE =MyISAM; - -INSERT INTO `tdmcreate_fieldkey` (`fieldkey_id`, `fieldkey_name`, `fieldkey_value`) VALUES - (1, '...', ''), - (2, 'PRIMARY', 'PRIMARY'), - (3, 'UNIQUE', 'UNIQUE'), - (4, 'KEY', 'KEY'), - (5, 'INDEX', 'INDEX'), - (6, 'FULLTEXT', 'FULLTEXT'); - -# -# Table structure for table `tdmcreate_fieldelements` 5 -# - -CREATE TABLE `tdmcreate_fieldelements` ( - `fieldelement_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, - `fieldelement_mid` INT(11) UNSIGNED NOT NULL DEFAULT '0', - `fieldelement_tid` INT(11) UNSIGNED NOT NULL DEFAULT '0', - `fieldelement_name` VARCHAR(100) NOT NULL DEFAULT '', - `fieldelement_value` VARCHAR(100) NOT NULL DEFAULT '', - PRIMARY KEY (`fieldelement_id`), - KEY `fieldelement_mid` (`fieldelement_mid`), - KEY `fieldelement_tid` (`fieldelement_tid`) -)ENGINE =MyISAM; - -INSERT INTO `tdmcreate_fieldelements` (`fieldelement_id`, `fieldelement_mid`, `fieldelement_tid`, `fieldelement_name`, `fieldelement_value`) VALUES - (1, 0, 0, '...', ''), - (2, 0, 0, 'Text', 'XoopsFormText'), - (3, 0, 0, 'TextArea', 'XoopsFormTextArea'), - (4, 0, 0, 'DhtmlTextArea', 'XoopsFormDhtmlTextArea'), - (5, 0, 0, 'CheckBox', 'XoopsFormCheckBox'), - (6, 0, 0, 'RadioYN', 'XoopsFormRadioYN'), - (7, 0, 0, 'SelectBox', 'XoopsFormSelect'), - (8, 0, 0, 'SelectUser', 'XoopsFormSelectUser'), - (9, 0, 0, 'ColorPicker', 'XoopsFormColorPicker'), - (10, 0, 0, 'ImageList', 'XoopsFormImageList'), - (11, 0, 0, 'UploadImage', 'XoopsFormUploadImage'), - (12, 0, 0, 'UploadFile', 'XoopsFormUploadFile'), - (13, 0, 0, 'TextDateSelect', 'XoopsFormTextDateSelect'); \ No newline at end of file +# SQL Dump for tdmcreate module +# PhpMyAdmin Version: 4.0.4 +# http://www.phpmyadmin.net +# +# Host: localhost +# Generated on: Thu Jen 02, 2014 to 19:12 +# Server version: 5.5.24-log +# PHP Version: 5.3.13 + +# +# Table structure for table `tdmcreate_modules` 38 +# + +CREATE TABLE `tdmcreate_modules` ( + `mod_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `mod_name` VARCHAR(255) NOT NULL DEFAULT '', + `mod_dirname` VARCHAR(100) NOT NULL DEFAULT '', + `mod_version` VARCHAR(5) NOT NULL DEFAULT '1.0', + `mod_since` VARCHAR(5) NOT NULL DEFAULT '1.0', + `mod_min_php` VARCHAR(5) NOT NULL DEFAULT '5.3', + `mod_min_xoops` VARCHAR(5) NOT NULL DEFAULT '2.5.7', + `mod_min_admin` VARCHAR(5) NOT NULL DEFAULT '1.1', + `mod_min_mysql` VARCHAR(5) NOT NULL DEFAULT '5.0.7', + `mod_description` TEXT, + `mod_author` VARCHAR(255) NOT NULL DEFAULT 'TDM XOOPS', + `mod_author_mail` VARCHAR(255) NOT NULL DEFAULT 'in...@em...', + `mod_author_website_url` VARCHAR(255) NOT NULL DEFAULT 'http://', + `mod_author_website_name` VARCHAR(255) NOT NULL DEFAULT '', + `mod_credits` VARCHAR(255) NOT NULL DEFAULT 'TDM XOOPS', + `mod_license` VARCHAR(255) NOT NULL DEFAULT 'GNU', + `mod_release_info` VARCHAR(255) NOT NULL DEFAULT '', + `mod_release_file` VARCHAR(255) NOT NULL DEFAULT '', + `mod_manual` VARCHAR(255) NOT NULL DEFAULT '', + `mod_manual_file` VARCHAR(255) NOT NULL DEFAULT '', + `mod_image` VARCHAR(255) NOT NULL DEFAULT '', + `mod_demo_site_url` VARCHAR(255) NOT NULL DEFAULT 'http://', + `mod_demo_site_name` VARCHAR(255) NOT NULL DEFAULT '', + `mod_support_url` VARCHAR(255) NOT NULL DEFAULT 'http://', + `mod_support_name` VARCHAR(255) NOT NULL DEFAULT '', + `mod_website_url` VARCHAR(255) NOT NULL DEFAULT 'http://', + `mod_website_name` VARCHAR(255) NOT NULL DEFAULT '', + `mod_release` VARCHAR(11) NOT NULL DEFAULT '00-00-0000', + `mod_status` VARCHAR(150) NOT NULL DEFAULT 'Beta 1', + `mod_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', + `mod_user` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', + `mod_blocks` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', + `mod_search` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `mod_comments` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `mod_notifications` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `mod_permissions` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `mod_inroot_copy` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', + `mod_donations` VARCHAR(50) NOT NULL DEFAULT '6KJ7RW5DR3VTJ', + `mod_subversion` VARCHAR(10) NOT NULL DEFAULT '12550', + PRIMARY KEY (`mod_id`), + KEY `mod_name` (`mod_name`), + UNIQUE KEY `mod_dirname` (`mod_dirname`) +)ENGINE =MyISAM; + + +CREATE TABLE `tdmcreate_tables` ( + `table_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `table_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0', + `table_category` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_name` VARCHAR(150) NOT NULL DEFAULT '', + `table_fieldname` VARCHAR(150) NOT NULL DEFAULT '', + `table_nbfields` INT(5) UNSIGNED NOT NULL DEFAULT '0', + `table_image` VARCHAR(150) NOT NULL DEFAULT '', + `table_autoincrement` TINYINT(1) NOT NULL DEFAULT '1', + `table_blocks` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1', + `table_user` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_submenu` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_submit` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_tag` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_broken` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_search` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_comments` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_notifications` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_permissions` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_rate` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_print` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_pdf` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_rss` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_single` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + `table_visit` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`table_id`), + KEY `table_mid` (`table_mid`), + UNIQUE KEY `table_name` (`table_name`) +)ENGINE =MyISAM; + +# +# Table structure for table `tdmcreate_fields` 21 +# + +CREATE TABLE `tdmcreate_fields` ( + `field_id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT, + `field_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0', + `field_tid` INT(5) UNSIGNED NOT NULL DEFAULT '0', + `field_numb` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `field_order` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0', + `field_name` VARCHAR(255) NOT NULL DEFAULT '', + `field_type` VARCHAR(100) NOT NULL DEFAULT '', + `field_value` CHAR(4) NOT NULL DEFAULT '', + `field_attribute` VARCHAR(50) NOT NULL DEFAULT '', + `field_null` CHAR(10) NOT NULL DEFAULT '', + `field_default` VARCHAR(150) NOT NULL DEFAULT '', + `field_key` CHAR(10) NOT NULL DEFAULT '', + `field_element` VARCHAR(150) NOT NULL DEFAULT '', + `field_parent` TINYINT(1) NOT NULL DEFAULT '0', + `field_inlist` TINYINT(1) NOT NULL DEFAULT '0', + `field_inform` TINYINT(1) NOT NULL DEFAULT '0', + `field_admin` TINYINT(1) NOT NULL DEFAULT '0', + `field_user` TINYINT(1) NOT NULL DEFAULT '0', + `field_block` TINYINT(1) NOT NULL DEFAULT '0', + `field_main` TINYINT(1) NOT NULL DEFAULT '0', + `field_search` TINYINT(1) NOT NULL DEFAULT '0', + `field_required` TINYINT(1) NOT NULL DEFAULT '0', + PRIMARY KEY (`field_id`), + KEY `field_mid` (`field_mid`), + KEY `field_tid` (`field_tid`), + KEY `field_name` (`field_name`) +)ENGINE =MyISAM; + +# +# Table structure for table `tdmcreate_languages` 5 +# + +CREATE TABLE `tdmcreate_languages` ( + `lng_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `lng_mid` INT(5) UNSIGNED NOT NULL DEFAULT '0', + `lng_file` VARCHAR(255) NOT NULL DEFAULT '', + `lng_define` VARCHAR(255) NOT NULL DEFAULT '', + `lng_description` VARCHAR(255) NOT NULL DEFAULT '', + PRIMARY KEY (`lng_id`), + KEY `lng_mid` (`lng_mid`) +)ENGINE =MyISAM; + +# +# Table structure for table `tdmcreate_fieldtype` 2 +# + +CREATE TABLE `tdmcreate_fieldtype` ( + `fieldtype_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `fieldtype_name` VARCHAR(100) NOT NULL DEFAULT '', + `fieldtype_value` VARCHAR(100) NOT NULL DEFAULT '', + PRIMARY KEY (`fieldtype_id`), + KEY `fieldtype_name` (`fieldtype_name`) +)ENGINE =MyISAM; + +INSERT INTO `tdmcreate_fieldtype` (`fieldtype_id`, `fieldtype_name`, `fieldtype_value`) VALUES + (1, '...', ''), + (2, 'INT', 'INT'), + (3, 'TINYINT', 'TINYINT'), + (4, 'MEDIUMINT', 'MEDIUMINT'), + (5, 'SMALLINT', 'SMALLINT'), + (6, 'FLOAT', 'FLOAT'), + (7, 'DOUBLE', 'DOUBLE'), + (8, 'DECIMAL', 'DECIMAL'), + (9, 'SET', 'SET'), + (10, 'ENUM', 'ENUM'), + (11, 'EMAIL', 'EMAIL'), + (12, 'URL', 'URL'), + (13, 'CHAR', 'CHAR'), + (14, 'VARCHAR', 'VARCHAR'), + (15, 'TEXT', 'TEXT'), + (16, 'TINYTEXT', 'TINYTEXT'), + (17, 'MEDIUMTEXT', 'MEDIUMTEXT'), + (18, 'LONGTEXT', 'LONGTEXT'), + (19, 'DATE', 'DATE'), + (20, 'DATETIME', 'DATETIME'), + (21, 'TIMESTAMP', 'TIMESTAMP'), + (22, 'TIME', 'TIME'), + (23, 'YEAR', 'YEAR'); + +# +# Table structure for table `tdmcreate_fieldattributes` 3 +# + +CREATE TABLE `tdmcreate_fieldattributes` ( + `fieldattribute_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `fieldattribute_name` VARCHAR(100) NOT NULL DEFAULT '', + `fieldattribute_value` VARCHAR(100) NOT NULL DEFAULT '', + PRIMARY KEY (`fieldattribute_id`), + KEY `fieldattribute_name` (`fieldattribute_name`) +)ENGINE =MyISAM; + +INSERT INTO `tdmcreate_fieldattributes` (`fieldattribute_id`, `fieldattribute_name`, `fieldattribute_value`) VALUES + (1, '...', ''), + (2, 'BINARY', 'BINARY'), + (3, 'UNSIGNED', 'UNSIGNED'), + (4, 'UNSIGNED_ZEROFILL', 'UNSIGNED_ZEROFILL'), + (5, 'CURRENT_TIMESTAMP', 'CURRENT_TIMESTAMP'); + +# +# Table structure for table `tdmcreate_fieldnull` 3 +# + +CREATE TABLE `tdmcreate_fieldnull` ( + `fieldnull_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `fieldnull_name` VARCHAR(100) NOT NULL DEFAULT '', + `fieldnull_value` VARCHAR(100) NOT NULL DEFAULT '', + PRIMARY KEY (`fieldnull_id`), + KEY `fieldnull_name` (`fieldnull_name`) +)ENGINE =MyISAM; + +INSERT INTO `tdmcreate_fieldnull` (`fieldnull_id`, `fieldnull_name`, `fieldnull_value`) VALUES + (1, '...', ''), + (2, 'NOT NULL', 'NOT NULL'), + (3, 'NULL', 'NULL'); + +# +# Table structure for table `tdmcreate_fieldkey` 3 +# + +CREATE TABLE `tdmcreate_fieldkey` ( + `fieldkey_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `fieldkey_name` VARCHAR(100) NOT NULL DEFAULT '', + `fieldkey_value` VARCHAR(100) NOT NULL DEFAULT '', + PRIMARY KEY (`fieldkey_id`), + KEY `fieldkey_name` (`fieldkey_name`) +)ENGINE =MyISAM; + +INSERT INTO `tdmcreate_fieldkey` (`fieldkey_id`, `fieldkey_name`, `fieldkey_value`) VALUES + (1, '...', ''), + (2, 'PRIMARY', 'PRIMARY'), + (3, 'UNIQUE', 'UNIQUE'), + (4, 'KEY', 'KEY'), + (5, 'INDEX', 'INDEX'), + (6, 'FULLTEXT', 'FULLTEXT'); + +# +# Table structure for table `tdmcreate_fieldelements` 5 +# + +CREATE TABLE `tdmcreate_fieldelements` ( + `fieldelement_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, + `fieldelement_mid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `fieldelement_tid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `fieldelement_name` VARCHAR(100) NOT NULL DEFAULT '', + `fieldelement_value` VARCHAR(100) NOT NULL DEFAULT '', + PRIMARY KEY (`fieldelement_id`), + KEY `fieldelement_mid` (`fieldelement_mid`), + KEY `fieldelement_tid` (`fieldelement_tid`) +)ENGINE =MyISAM; + +INSERT INTO `tdmcreate_fieldelements` (`fieldelement_id`, `fieldelement_mid`, `fieldelement_tid`, `fieldelement_name`, `fieldelement_value`) VALUES + (1, 0, 0, '...', ''), + (2, 0, 0, 'Text', 'XoopsFormText'), + (3, 0, 0, 'TextArea', 'XoopsFormTextArea'), + (4, 0, 0, 'DhtmlTextArea', 'XoopsFormDhtmlTextArea'), + (5, 0, 0, 'CheckBox', 'XoopsFormCheckBox'), + (6, 0, 0, 'RadioYN', 'XoopsFormRadioYN'), + (7, 0, 0, 'SelectBox', 'XoopsFormSelect'), + (8, 0, 0, 'SelectUser', 'XoopsFormSelectUser'), + (9, 0, 0, 'ColorPicker', 'XoopsFormColorPicker'), + (10, 0, 0, 'ImageList', 'XoopsFormImageList'), + (11, 0, 0, 'TextFile', 'XoopsFormTextFile'), + (12, 0, 0, 'UploadImage', 'XoopsFormUploadImage'), + (13, 0, 0, 'UploadFile', 'XoopsFormUploadFile'), + (14, 0, 0, 'TextDateSelect', 'XoopsFormTextDateSelect'); \ No newline at end of file Modified: XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/templates/admin/tdmcreate_fields.tpl =================================================================== --- XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/templates/admin/tdmcreate_fields.tpl 2015-04-19 20:33:25 UTC (rev 13039) +++ XoopsModules/TDMCreate/branches/timgno/1.91a1/tdmcreate/templates/admin/tdmcreate_fields.tpl 2015-04-21 17:27:59 UTC (rev 13040) @@ -43,7 +43,7 @@ <a href="tables.php?op=edit&table_mid=<{$table.mid}>&table_id=<{$table.id}>" title="<{$smarty.const._AM_TDMCREATE_EDIT_TABLE}>"> <img src="<{xoModuleIcons16 edit.png}>" alt="<{$smarty.const._AM_TDMCREATE_EDIT_TABLE}>" /> </a> - <a href="fields.php?op=edit&field_mid=<{$table.mid}>&field_tid=<{$table.id}>" title="<{$smarty.const._AM_TDMCREATE_EDIT_FIELDS}>"> + <a href="fields.php?op=edit&field_mid=<{$table.mid}>&field_tid=<{$table.id}>&field_numb=<{$table.nbfields}>" title="<{$smarty.const._AM_TDMCREATE_EDIT_FIELDS}>"> <img src="<{xoModuleIcons16 inserttable.png}>" alt="<{$smarty.const._AM_TDMCREATE_EDIT_FIELDS}>" /> </a> <a href="fields.php?op=delete&field_tid=<{$table.id}>" title="<{$smarty.const._DELETE}>"> |