znalezione w sieci http://michal.ozorkow.net/2008/05/26/jportal2joomla/ SQLowy skrypt do komentarzy :
TRUNCATE TABLE `jos_content`;
TRUNCATE TABLE `jos_content_frontpage`;
TRUNCATE TABLE `jos_akocomment`;
INSERT INTO jos_content (`id`, `title`, `introtext`, `fulltext`, `state`, `sectionid`, `catid`, `created`, `created_by`, `publish_up`) SELECT `id`, `title`, `text`, `textcd`, '1', '1', '1', `date`, '62', `date` FROM portalnews WHERE portalnews.stat != 3;
INSERT INTO jos_content_frontpage (`content_id`, `ordering`) SELECT `id`, 2782-`id` FROM portalnews WHERE portalnews.stat != 3;
INSERT INTO jos_akocomment (`name`, `title`, `comment`, `date`, `published`, `contentid`) SELECT `name`, `title`, `text`, `date`, '1', `wid` FROM portalcomments WHERE portalcomments.what = 'news';
UPDATE jos_content SET `title`= REPLACE(`title`, '\\"', '"'), `introtext`= REPLACE(`introtext`, '\\"', '"'), `fulltext`= REPLACE(`fulltext`, '\\"', '"');
UPDATE jos_akocomment SET `title`= REPLACE(`title`, '\\"', '"'), `comment`= REPLACE(`comment`, '\\"', '"');
UPDATE jos_content SET `introtext`= REPLACE(`introtext`, '', '<i>'), `introtext`= REPLACE(`introtext`, '', '</i>'), `introtext`= REPLACE(`introtext`, '', '<u>'), `introtext`= REPLACE(`introtext`, '', '</u>'), `introtext`= REPLACE(`introtext`, '', '<b>'), `introtext`= REPLACE(`introtext`, '', '</b>'), `fulltext`= REPLACE(`fulltext`, '', '<i>'), `fulltext`= REPLACE(`fulltext`, '', '</i>'), `fulltext`= REPLACE(`fulltext`, '', '<u>'), `fulltext`= REPLACE(`fulltext`, '', '</u>'), `fulltext`= REPLACE(`fulltext`, '', '<b>'), `fulltext`= REPLACE(`fulltext`, '', '</b>');
UPDATE jos_akocomment SET `comment`= REPLACE(`comment`, '', '<i>'), `comment`= REPLACE(`comment`, '', '</i>'), `comment`= REPLACE(`comment`, '', '<u>'), `comment`= REPLACE(`comment`, '', '</u>'), `comment`= REPLACE(`comment`, '', '<b>'), `comment`= REPLACE(`comment`, '', '</b>');
poza tym jeszcze potrzebowałem poprawić kodowanie:
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '³', 'ł');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '£', 'Ł');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'ó', 'ó');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Ó', 'Ó');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'ê', 'ę');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Ê', 'Ę');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '±', 'ą');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¡', 'Ą');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¶', 'ś');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¦', 'Ś');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'æ', 'ć');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Æ', 'Ć');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'ñ', 'ń');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Ñ', 'Ń');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¿', 'ż');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¯', 'Ż');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¼', 'ź');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¬', 'Ź');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '³', 'ł');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '£', 'Ł');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'ó', 'ó');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Ó', 'Ó');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'ê', 'ę');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Ê', 'Ę');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '±', 'ą');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¡', 'Ą');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¶', 'ś');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¦', 'Ś');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'æ', 'ć');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Æ', 'Ć');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'ñ', 'ń');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Ñ', 'Ń');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¿', 'ż');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¯', 'Ż');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¼', 'ź');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¬', 'Ź');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '³', 'ł');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '£', 'Ł');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'ó', 'ó');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Ó', 'Ó');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'ê', 'ę');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Ê', 'Ę');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '±', 'ą');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¡', 'Ą');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¶', 'ś');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¦', 'Ś');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'æ', 'ć');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Æ', 'Ć');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'ñ', 'ń');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Ñ', 'Ń');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¿', 'ż');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¯', 'Ż');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¼', 'ź');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¬', 'Ź');
vBulletin® v4.2.5, Prawa przedruku © 2024 vBulletin Solutions, Inc. Wszystkie prawa zastrzeżone.
Tłumaczenie: Polskie Centrum Joomla!