Foren / Cotonti / Support / Extra Fields (Pages) error

Twiebie
#31107 23. Oktober 2011, 16:50
--
-- Table structure for table `sed_extra_fields`
--

CREATE TABLE IF NOT EXISTS `sed_extra_fields` (
  `field_location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field_html` text COLLATE utf8_unicode_ci NOT NULL,
  `field_variants` text COLLATE utf8_unicode_ci NOT NULL,
  `field_description` text COLLATE utf8_unicode_ci NOT NULL,
  `field_default` text COLLATE utf8_unicode_ci NOT NULL,
  `field_required` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `field_parse` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'HTML',
  `field_params` text COLLATE utf8_unicode_ci NOT NULL,
  `field_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  KEY `field_location` (`field_location`),
  KEY `field_name` (`field_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sed_extra_fields`
--

INSERT INTO `sed_extra_fields` (`field_location`, `field_name`, `field_type`, `field_html`, `field_variants`, `field_description`, `field_default`, `field_required`, `field_parse`, `field_params`, `field_enabled`) VALUES
('pages', 'nick', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra2', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra3', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra4', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra5', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra6', 'textarea', '<textarea name="{$name}" rows="{$rows}" cols="{$cols}"{$attrs}>{$value}</textarea>{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra7', 'textarea', '<textarea name="{$name}" rows="{$rows}" cols="{$cols}"{$attrs}>{$value}</textarea>{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra8', 'textarea', '<textarea name="{$name}" rows="{$rows}" cols="{$cols}"{$attrs}>{$value}</textarea>{$error}', '', '', '', 0, 'HTML', '', 1),
('users', 'extra9', 'textarea', '<textarea name="{$name}" rows="{$rows}" cols="{$cols}"{$attrs}>{$value}</textarea>{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'guid', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'ipaddress', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'violation', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'server', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'viotime', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'viodate', 'select', '<select name="{$name}"{$attrs}>{$options}</select>{$error}', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31', '', '', 0, 'HTML', '', 1),
('pages', 'viomonth', 'select', '<select name="{$name}"{$attrs}>{$options}</select>{$error}', 'January,February,March,April,May,June,July,August,September,October,November,December', '', '', 0, 'HTML', '', 1),
('pages', 'vioyear', 'select', '<select name="{$name}"{$attrs}>{$options}</select>{$error}', '2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030', '', '', 0, 'HTML', '', 1),
('pages', 'viohours', 'select', '<select name="{$name}"{$attrs}>{$options}</select>{$error}', '00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24', '', '', 0, 'HTML', '', 1),
('pages', 'viomin', 'select', '<select name="{$name}"{$attrs}>{$options}</select>{$error}', '00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60', '', '', 0, 'HTML', '', 1),
('pages', 'viotimezone', 'select', '<select name="{$name}"{$attrs}>{$options}</select>{$error}', 'GMT-0,GMT-1,GMT-2,GMT-3,GMT-4,GMT-5,GMT-6,GMT-7,GMT-8,GMT-9,GMT-10,GMT-11,GMT-12,GMT+0,GMT+1,GMT+2,GMT+3,GMT+4,GMT+5,GMT+6,GMT+7,GMT+8,GMT+9,GMT+10,GMT+11,GMT+12', '', '', 0, 'HTML', '', 1),
('pages', 'vioserver', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('pages', 'vioserverip', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'HTML', '', 1),
('cot_users', 'icq', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'Text', '', 1),
('cot_users', 'msn', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'Text', '', 1),
('cot_users', 'irc', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'Text', '', 1),
('cot_users', 'website', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'Text', '', 1),
('cot_users', 'location', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'Text', '', 1),
('cot_users', 'occupation', 'input', '<input type="text" class="text" name="{$name}" value="{$value}"{$attrs} />{$error}', '', '', '', 0, 'Text', '', 1);