';
$img_WARN = '
';
$img_ERROR = '
';
$BR = '
';
//--install...
$db = & JFactory::getDBO();
$query = "DROP TABLE IF EXISTS `#__vxc`;";
$db->setQuery($query);
if( ! $db->query() )
{
echo $img_ERROR.JText::_('Unable to create table').$BR;
echo $db->getErrorMsg();
return FALSE;
}
$query = "CREATE TABLE `#__vxc` (
`id` int(11) NOT NULL auto_increment,
`greeting` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$db->setQuery($query);
if( ! $db->query() )
{
echo $img_ERROR.JText::_('Unable to create table').$BR;
echo $db->getErrorMsg();
return FALSE;
}
$query = "INSERT INTO `#__vxc` (`greeting`)
VALUES
('Hello, World!'),
('Bonjour, Monde!'),
('Ciao, Mondo!'),
('Hallo, Welt ;)');";
$db->setQuery($query);
if( ! $db->query() )
{
echo $img_ERROR.JText::_('Unable to create table').$BR;
echo $db->getErrorMsg();
return FALSE;
}
if( $errors )
{
return FALSE;
}
return TRUE;
}// function