ciao a tutti
ho appena installato il mio joomla 1.5.8 e vorrei importare tutte le news presenti sul mio vecchio sito in xoops... nn mi interessa importare user o quant'altro solo le news... esiste uno script?
grazie !
ecco un es. di come è strutturato la tabella stories in xoops
--
-- Struttura della tabella `dM0Q0_stories`
--
CREATE TABLE IF NOT EXISTS `dM0Q0_stories` (
`storyid` int(
unsigned NOT NULL auto_increment,
`uid` int(5) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`created` int(10) unsigned NOT NULL default '0',
`published` int(10) unsigned NOT NULL default '0',
`expired` int(10) unsigned NOT NULL default '0',
`hostname` varchar(20) NOT NULL default '',
`nohtml` tinyint(1) NOT NULL default '0',
`nosmiley` tinyint(1) NOT NULL default '0',
`hometext` text NOT NULL,
`bodytext` text NOT NULL,
`keywords` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`counter` int(
unsigned NOT NULL default '0',
`topicid` smallint(4) unsigned NOT NULL default '1',
`ihome` tinyint(1) NOT NULL default '0',
`notifypub` tinyint(1) NOT NULL default '0',
`story_type` varchar(5) NOT NULL default '',
`topicdisplay` tinyint(1) NOT NULL default '0',
`topicalign` char(1) NOT NULL default 'R',
`comments` smallint(5) unsigned NOT NULL default '0',
`rating` double(6,4) NOT NULL default '0.0000',
`votes` int(11) unsigned NOT NULL default '0',
`imgspotlight` varchar(255) NOT NULL default '',
`imgauthor` varchar(255) NOT NULL default '',
PRIMARY KEY (`storyid`),
KEY `idxstoriestopic` (`topicid`),
KEY `ihome` (`ihome`),
KEY `uid` (`uid`),
KEY `published_ihome` (`published`,`ihome`),
KEY `title` (`title`(40)),
KEY `created` (`created`),
FULLTEXT KEY `search` (`title`,`hometext`,`bodytext`)
) TYPE=InnoDB AUTO_INCREMENT=367 ;
--
-- Dump dei dati per la tabella `dM0Q0_stories`
--
INSERT INTO `dM0Q0_stories` (`storyid`, `uid`, `title`, `created`, `published`, `expired`, `hostname`, `nohtml`, `nosmiley`, `hometext`, `bodytext`, `keywords`, `description`, `counter`, `topicid`, `ihome`, `notifypub`, `story_type`, `topicdisplay`, `topicalign`, `comments`, `rating`, `votes`, `imgspotlight`, `imgauthor`) VALUES
