- Posts: 13
- Thank you received: 1
Kunena 7.0.4 Released
The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0
Question php-fusion v6x -> Kunena 1.5 90% completed
15 years 6 months ago #66582
by Baldcat
php-fusion v6x -> Kunena 1.5 90% completed was created by Baldcat
Howdy folks, well it has been a long time, and we have just about finished the code.. So I'll start posting it up and folk can use it, upgrade it imporve it etc etc..
What it converts
- forum
- Articles
- user data
** use at your own risk, code is a little commented, and really don't have instructions as yet..
Step one,
Install fusionbridge plugin - php-fusion usesdouble hash and some salt from memory (been awhile) anyway, install plugin and enable, this will allow your transfered fusion users to be able to use their exsisting password.... YAY
Step two
upload the \fusion_joomla folder to the root of your joomla directory
Step three
browse to this directory, and select "Settings"
Setup the info.. source db, destination db prefix etc etc
Step, run through each of the steps..
Clear And Convert Users (this will delete all users in joomla, permissions will come across, so if you are a super admin in fusion you will be a super admin in joomla ** ensure you have the auth plugin installed first..)
Convert New Users (doesn't work
)
Clear And Convert Articles (As it states - doesn't delete exsisting articles)
Convert New Articles
Clear And Convert Forums (this will blow away anythign you have in your kunena install)
Clear And Convert Threads & Posts (This is automaticlly followed into after the previous step)
Clear And Convert Message Bodies Only (As it states, this also begins the transfer os attachment records, yet is yet to be finished)
Do Some Tidying Up (encoded char, smiles etc etc add any modifications you want in here)
remember to delete the convertor after use, as your db settings are stored in the .dat file
What it converts
- forum
- Articles
- user data
** use at your own risk, code is a little commented, and really don't have instructions as yet..
Step one,
Install fusionbridge plugin - php-fusion usesdouble hash and some salt from memory (been awhile) anyway, install plugin and enable, this will allow your transfered fusion users to be able to use their exsisting password.... YAY
Step two
upload the \fusion_joomla folder to the root of your joomla directory
Step three
browse to this directory, and select "Settings"
Setup the info.. source db, destination db prefix etc etc
Step, run through each of the steps..
Clear And Convert Users (this will delete all users in joomla, permissions will come across, so if you are a super admin in fusion you will be a super admin in joomla ** ensure you have the auth plugin installed first..)
Convert New Users (doesn't work
Clear And Convert Articles (As it states - doesn't delete exsisting articles)
Convert New Articles
Clear And Convert Forums (this will blow away anythign you have in your kunena install)
Clear And Convert Threads & Posts (This is automaticlly followed into after the previous step)
Clear And Convert Message Bodies Only (As it states, this also begins the transfer os attachment records, yet is yet to be finished)
Do Some Tidying Up (encoded char, smiles etc etc add any modifications you want in here)
remember to delete the convertor after use, as your db settings are stored in the .dat file
The following user(s) said Thank You: Laacis
Please Log in or Create an account to join the conversation.
15 years 5 months ago #68765
by Laacis
Replied by Laacis on topic Re: php-fusion v6x -> Kunena 1.5 90% completed
Thank You for this tool.
works fine with php-fusion v7
There is just one bug to fix- all forum convert went well,but something is with forum topic (subject) - they didn't convert at all, there is just space in subject! (look in pic)
How to fix that?
p.s. Sorry for my English!
works fine with php-fusion v7
There is just one bug to fix- all forum convert went well,but something is with forum topic (subject) - they didn't convert at all, there is just space in subject! (look in pic)
How to fix that?
p.s. Sorry for my English!
Please Log in or Create an account to join the conversation.
15 years 5 months ago #70263
by Laacis
Replied by Laacis on topic Re: php-fusion v6x -> Kunena 1.5 90% completed
Sorry for double-post,but can someone help with this?
Please Log in or Create an account to join the conversation.
15 years 4 months ago #74469
by Baldcat
Replied by Baldcat on topic Re: php-fusion v6x -> Kunena 1.5 90% completed
hiya, it is probably due to you using php fusion 7.. I've never looked at ver 7 , but it is probably something as simple as a different field name or something, especially if everything else has worked fine.. have a little dig around in the Clear And Convert Threads & Posts php file and find where it grabs the subject field..
Please Log in or Create an account to join the conversation.
15 years 4 months ago #74471
by Baldcat
Replied by Baldcat on topic Re: php-fusion v6x -> Kunena 1.5 90% completed
if I get time tmw, I'll take a bit of a look for you. Can you please post the forum table structure of fusion 7 ?
Please Log in or Create an account to join the conversation.
15 years 4 months ago - 15 years 4 months ago #74472
by Laacis
Replied by Laacis on topic Re: php-fusion v6x -> Kunena 1.5 90% completed
Thank you for helping...
Did you mean this:
Table structure for table `fusion_forums` = This is categories
Table structure for table `fusion_posts` = Post messages
Table structure for table `fusion_threads` = and here are subjects and other stuff
Did you mean this:
Table structure for table `fusion_forums` = This is categories
Warning: Spoiler!
`forum_id` mediumint(
unsigned NOT NULL AUTO_INCREMENT,
`forum_cat` mediumint(
unsigned DEFAULT '0',
`forum_name` varchar(100) NOT NULL DEFAULT '',
`forum_order` smallint(5) unsigned NOT NULL DEFAULT '0',
`forum_description` text NOT NULL,
`forum_moderators` text NOT NULL,
`forum_access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`forum_post` smallint(3) unsigned DEFAULT '101',
`forum_poll` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_vote` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_reply` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_attach` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`forum_postcount` mediumint(
unsigned NOT NULL DEFAULT '0',
`forum_threadcount` mediumint(
unsigned NOT NULL DEFAULT '0',
`forum_lastuser` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`forum_id`),
KEY `forum_order` (`forum_order`),
KEY `forum_lastpost` (`forum_lastpost`),
KEY `forum_postcount` (`forum_postcount`),
KEY `forum_threadcount` (`forum_threadcount`)
`forum_cat` mediumint(
`forum_name` varchar(100) NOT NULL DEFAULT '',
`forum_order` smallint(5) unsigned NOT NULL DEFAULT '0',
`forum_description` text NOT NULL,
`forum_moderators` text NOT NULL,
`forum_access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`forum_post` smallint(3) unsigned DEFAULT '101',
`forum_poll` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_vote` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_reply` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_attach` smallint(3) unsigned NOT NULL DEFAULT '0',
`forum_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`forum_postcount` mediumint(
`forum_threadcount` mediumint(
`forum_lastuser` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`forum_id`),
KEY `forum_order` (`forum_order`),
KEY `forum_lastpost` (`forum_lastpost`),
KEY `forum_postcount` (`forum_postcount`),
KEY `forum_threadcount` (`forum_threadcount`)
Table structure for table `fusion_posts` = Post messages
Warning: Spoiler!
`forum_id` mediumint(
unsigned DEFAULT '0',
`thread_id` mediumint(
unsigned DEFAULT '0',
`post_id` mediumint(
unsigned NOT NULL AUTO_INCREMENT,
`post_message` text COLLATE utf8_unicode_ci NOT NULL,
`post_showsig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`post_smileys` tinyint(1) unsigned NOT NULL DEFAULT '1',
`post_author` smallint(5) unsigned NOT NULL DEFAULT '0',
`post_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
`post_ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0.0.0',
`post_edituser` smallint(5) unsigned NOT NULL DEFAULT '0',
`post_edittime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`post_id`),
KEY `thread_id` (`thread_id`),
KEY `post_datestamp` (`post_datestamp`),
KEY `post_datestamp_2` (`post_datestamp`)
`thread_id` mediumint(
`post_id` mediumint(
`post_message` text COLLATE utf8_unicode_ci NOT NULL,
`post_showsig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`post_smileys` tinyint(1) unsigned NOT NULL DEFAULT '1',
`post_author` smallint(5) unsigned NOT NULL DEFAULT '0',
`post_datestamp` int(10) unsigned NOT NULL DEFAULT '0',
`post_ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0.0.0',
`post_edituser` smallint(5) unsigned NOT NULL DEFAULT '0',
`post_edittime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`post_id`),
KEY `thread_id` (`thread_id`),
KEY `post_datestamp` (`post_datestamp`),
KEY `post_datestamp_2` (`post_datestamp`)
Table structure for table `fusion_threads` = and here are subjects and other stuff
Warning: Spoiler!
`forum_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`thread_subject` varchar(100) NOT NULL DEFAULT '',
`thread_author` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_views` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`thread_lastpostid` mediumint(
unsigned NOT NULL DEFAULT '0',
`thread_postcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_lastuser` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_poll` tinyint(1) unsigned NOT NULL DEFAULT '0',
`thread_sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
`thread_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`thread_id`),
KEY `thread_postcount` (`thread_postcount`),
KEY `thread_lastpost` (`thread_lastpost`),
KEY `thread_views` (`thread_views`)
`thread_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`thread_subject` varchar(100) NOT NULL DEFAULT '',
`thread_author` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_views` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`thread_lastpostid` mediumint(
`thread_postcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_lastuser` smallint(5) unsigned NOT NULL DEFAULT '0',
`thread_poll` tinyint(1) unsigned NOT NULL DEFAULT '0',
`thread_sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
`thread_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`thread_id`),
KEY `thread_postcount` (`thread_postcount`),
KEY `thread_lastpost` (`thread_lastpost`),
KEY `thread_views` (`thread_views`)
Last edit: 15 years 4 months ago by Laacis.
Please Log in or Create an account to join the conversation.
Time to create page: 0.252 seconds