How to get the site name in the comp. installation process

MaTraX · 09.02.2005, 15:15

Hi
I have question just like in the thread title.
This is part of my .xml installation file:

PHP Code:

   <queries>

                        <query>CREATE TABLE IF NOT EXISTS `#__mycomponent` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(100) NOT NULL default '',

  `option1` text,

  `option2` varchar(50) NOT NULL default '',

  `option3` varchar(50) NOT NULL default '',

  `option4` varchar(8) NOT NULL default '',

  `option5` varchar(8) NOT NULL default '',

  `option6` varchar(8) NOT NULL default '',

  `option7` varchar(8) NOT NULL default '',

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=9 ;

                        </query>

                        <query>INSERT INTO `#__mycomponent` (`id`, `name`, `option1`, `option2`, `option3`, `option4`, `option5`, `option6`, `option7`) VALUES ('', 'Sitename', 'Sitename', '500', '100%', '#000000', '#ffffff', '#000000', '#ffffff')</query>

                        </queries>

My problem is that in the place of Sitename I would like the component to insert the real site name taken from the mambo database. Is it possible and if yes - please tell me how to do it.

Thank you in advance