Jump to content

stitzinger

Members
  • Content count

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    John Stitzinger
  1. stitzinger

    Information Pages Unlimited v1.0

    Upps The whole idea was to not specify the configuration_group_id in the last post!!! This should work better. INSERT INTO `configuration_group` (`configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('HTML-Editor', 'HTML-Editor Optionen', 16, 1); set @last_id=LAST_INSERT_ID(); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('FCKeditor verwenden', 'DESCRIPTION_EDITOR', 'ja', 'Soll der HTML-Editor für Beschreibungen benutzt werden?', @last_id, 1, '2008-03-20 22:40:05', '2007-05-13 06:37:14', NULL, 'tep_cfg_select_option(array(''ja'', ''nein''),'), ('Höhe FCKeditor', 'FCK_EDITOR_HEIGHT', '600', 'Höhe der Eingabefelder in Pixel bei Verwendung des FCK-Editors.', @last_id, 2, '2007-12-17 01:08:56', '2007-05-13 06:37:14', NULL, NULL);
  2. stitzinger

    Information Pages Unlimited v1.0

    It seems odd that this Add-on does not take advantage of the Auto_increment of the Id fields and the LAST_INSERT_ID() mysql function e.g: INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('HTML-Editor', 'HTML-Editor Optionen', 16, 1); set @last_id=LAST_INSERT_ID(); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('FCKeditor verwenden', 'DESCRIPTION_EDITOR', 'ja', 'Soll der HTML-Editor für Beschreibungen benutzt werden?', @last_id, 1, '2008-03-20 22:40:05', '2007-05-13 06:37:14', NULL, 'tep_cfg_select_option(array(''ja'', ''nein''),'), ('Höhe FCKeditor', 'FCK_EDITOR_HEIGHT', '600', 'Höhe der Eingabefelder in Pixel bei Verwendung des FCK-Editors.', @last_id, 2, '2007-12-17 01:08:56', '2007-05-13 06:37:14', NULL, NULL); or a more simple unrelated example mysql> create table test (id int NOT NULL auto_increment, value int(4), primary key (id)); mysql> insert into test (value) values (10); mysql> set @last_id=LAST_INSERT_ID(); mysql> insert into test (value) values (@last_id), (@last_id); mysql> select * from test; +----+-------+ | id | value | +----+-------+ | 4 | 10 | | 5 | 4 | | 6 | 4 | +----+-------+
×