Download mod phpbb2 => phpbb3

Support zu den Modifikationen (MODs) von Entwickler OXPUS für das phpBB 3.0.x
Bigbang95

Download mod phpbb2 => phpbb3

Beitrag von Bigbang95 »

Hi,

would be it possible to please convert the base of data of the MOD for phpbb2 towards the MOD phpbb3?

I have just converted my forum and anything was to recover (no category, no remote loading)

thank you very much
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Download mod phpbb2 => phpbb3

Beitrag von oxpus »

Yes, you can do this and very simple:

First install the mod as shown in the install instructions and after this, delete the installed tables from the download mod (and only them, do not undo the other changed on other phpBB tables which are done by this mod!).
After this, backup all tables from the Download Mod installation on your old forum and restore them in your new phpBB 3.
At least (re)upload the folder install from the mod and start the converting (the extra tab for this).
This script will convert all entries from the old tables into the new formats, used by the phpBB 3.

And don't forget to move all download files and folders under downloads/ (your old phpBB 2) to the new place dl_mod/downloads/ (in your new phpBB 3).
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Bigbang95

Re: Download mod phpbb2 => phpbb3

Beitrag von Bigbang95 »

yes but the new forum has already the MOD download v6.0.7 is installed…


thus I remove the tables of the MOD download forum phpbb 3 and I carry out the conversion of the forum phpbb2 towards phpbb3 and there the tables will be converted?


Sorry for my bad english, I speak french...


edit :

I remove the tables of the forum phpbb3:
DROP TABLE IF EXISTS `phpbb_dl_auth`;
CREATE TABLE `phpbb_dl_auth` (
`cat_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`auth_view` tinyint(1) NOT NULL default '1',
`auth_dl` tinyint(1) NOT NULL default '1',
`auth_up` tinyint(1) NOT NULL default '1',
`auth_mod` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `phpbb_dl_auth`
--

INSERT INTO `phpbb_dl_auth` (`cat_id`, `group_id`, `auth_view`, `auth_dl`, `auth_up`, `auth_mod`) VALUES
(1, 5, 1, 1, 1, 1),
(1, 6, 0, 0, 0, 0),
(1, 4, 1, 1, 1, 1),
(1, 1, 1, 0, 0, 0),
(1, 2, 1, 1, 0, 0),
(1, 3, 1, 1, 0, 0);

-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_banlist`
--

DROP TABLE IF EXISTS `phpbb_dl_banlist`;
CREATE TABLE `phpbb_dl_banlist` (
`ban_id` int(11) NOT NULL auto_increment,
`user_id` mediumint(8) NOT NULL default '0',
`user_ip` char(8) NOT NULL default '',
`user_agent` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`guests` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ban_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `phpbb_dl_banlist`
--

INSERT INTO `phpbb_dl_banlist` (`ban_id`, `user_id`, `user_ip`, `user_agent`, `username`, `guests`) VALUES
(1, 0, '', 'n/a', '', 0);

-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_bug_history`
--

DROP TABLE IF EXISTS `phpbb_dl_bug_history`;
CREATE TABLE `phpbb_dl_bug_history` (
`report_his_id` int(11) NOT NULL auto_increment,
`df_id` int(11) NOT NULL default '0',
`report_id` int(11) NOT NULL,
`report_his_type` varchar(10) default '',
`report_his_date` int(11) default '0',
`report_his_value` varchar(255) default NULL,
PRIMARY KEY (`report_his_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `phpbb_dl_bug_history`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_bug_tracker`
--

DROP TABLE IF EXISTS `phpbb_dl_bug_tracker`;
CREATE TABLE `phpbb_dl_bug_tracker` (
`report_id` int(11) NOT NULL auto_increment,
`df_id` int(11) NOT NULL default '0',
`report_title` varchar(255) character set utf8 default NULL,
`report_text` blob,
`report_file_ver` varchar(50) character set utf8 default NULL,
`report_date` int(11) default '0',
`report_author_id` mediumint(8) NOT NULL default '0',
`report_assign_id` mediumint(8) NOT NULL default '0',
`report_assign_date` int(11) default '0',
`report_status` tinyint(1) NOT NULL default '0',
`report_status_date` int(11) default '0',
`report_php` varchar(50) default '',
`report_db` varchar(50) default '',
`report_forum` varchar(50) default '',
`bug_uid` varchar(8) NOT NULL default '',
`bug_bitfield` varchar(255) NOT NULL default '',
`bug_flags` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `phpbb_dl_bug_tracker`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_comments`
--

DROP TABLE IF EXISTS `phpbb_dl_comments`;
CREATE TABLE `phpbb_dl_comments` (
`dl_id` bigint(20) unsigned NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`username` varchar(32) NOT NULL default '',
`comment_time` int(11) NOT NULL default '0',
`comment_edit_time` int(11) NOT NULL default '0',
`comment_text` blob,
`approve` tinyint(1) NOT NULL default '0',
`com_uid` varchar(8) NOT NULL default '',
`com_bitfield` varchar(255) NOT NULL default '',
`com_flags` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`dl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `phpbb_dl_comments`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_config`
--

DROP TABLE IF EXISTS `phpbb_dl_config`;
CREATE TABLE `phpbb_dl_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `phpbb_dl_config`
--

INSERT INTO `phpbb_dl_config` (`config_name`, `config_value`) VALUES
('delay_auto_traffic', '30'),
('delay_post_traffic', '30'),
('disable_email', '1'),
('disable_popup', '0'),
('disable_popup_notify', '0'),
('dl_click_reset_time', '1213960955'),
('dl_edit_time', '3'),
('dl_links_per_page', '10'),
('dl_method', '2'),
('dl_method_quota', '2147483648'),
('dl_mod_version', '6.0.7'),
('dl_new_time', '3'),
('dl_posts', '25'),
('dl_stats_perm', '0'),
('download_dir', 'dl_mod/downloads/'),
('download_vc', '1'),
('drop_traffic_postdel', '0'),
('edit_own_downloads', '1'),
('enable_post_dl_traffic', '1'),
('guest_stats_show', '1'),
('hotlink_action', '1'),
('icon_free_for_reg', '0'),
('latest_comments', '1'),
('limit_desc_on_index', '0'),
('newtopic_traffic', '524288'),
('overall_traffic', '104857600'),
('physical_quota', '524288000'),
('prevent_hotlink', '1'),
('recent_downloads', '10'),
('remain_traffic', '0'),
('reply_traffic', '262144'),
('report_broken', '1'),
('report_broken_lock', '1'),
('report_broken_message', '1'),
('report_broken_vc', '1'),
('shorten_extern_links', '10'),
('show_footer_legend', '1'),
('show_footer_stat', '1'),
('show_real_filetime', '1'),
('stop_uploads', '0'),
('sort_preform', '0'),
('thumb_fsize', '0'),
('thumb_xsize', '200'),
('thumb_ysize', '150'),
('traffic_retime', '1213960955'),
('upload_traffic_count', '1'),
('use_ext_blacklist', '1'),
('use_hacklist', '1'),
('user_dl_auto_traffic', '0'),
('user_traffic_once', '0');

-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_ext_blacklist`
--

DROP TABLE IF EXISTS `phpbb_dl_ext_blacklist`;
CREATE TABLE `phpbb_dl_ext_blacklist` (
`extention` varchar(10) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `phpbb_dl_ext_blacklist`
--

INSERT INTO `phpbb_dl_ext_blacklist` (`extention`) VALUES
('asp'),
('cgi'),
('dhtm'),
('dhtml'),
('exe'),
('htm'),
('html'),
('jar'),
('js'),
('php'),
('php3'),
('pl'),
('sh'),
('shtm'),
('shtml');

-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_favorites`
--

DROP TABLE IF EXISTS `phpbb_dl_favorites`;
CREATE TABLE `phpbb_dl_favorites` (
`fav_id` int(11) NOT NULL auto_increment,
`fav_dl_id` int(11) NOT NULL default '0',
`fav_dl_cat` int(11) NOT NULL default '0',
`fav_user_id` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`fav_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `phpbb_dl_favorites`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_hotlink`
--

DROP TABLE IF EXISTS `phpbb_dl_hotlink`;
CREATE TABLE `phpbb_dl_hotlink` (
`user_id` mediumint(8) NOT NULL default '0',
`session_id` varchar(32) NOT NULL default '',
`hotlink_id` varchar(32) NOT NULL default '',
`code` varchar(5) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `phpbb_dl_hotlink`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_notraf`
--

DROP TABLE IF EXISTS `phpbb_dl_notraf`;
CREATE TABLE `phpbb_dl_notraf` (
`user_id` mediumint(8) NOT NULL default '0',
`dl_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `phpbb_dl_notraf`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_ratings`
--

DROP TABLE IF EXISTS `phpbb_dl_ratings`;
CREATE TABLE `phpbb_dl_ratings` (
`dl_id` int(11) default '0',
`user_id` mediumint(8) default '0',
`rate_point` varchar(10) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `phpbb_dl_ratings`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_dl_stats`
--

DROP TABLE IF EXISTS `phpbb_dl_stats`;
CREATE TABLE `phpbb_dl_stats` (
`dl_id` bigint(20) unsigned NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`username` varchar(32) NOT NULL default '',
`traffic` bigint(20) NOT NULL default '0',
`direction` tinyint(1) NOT NULL default '0',
`user_ip` varchar(8) NOT NULL default '',
`browser` varchar(20) NOT NULL default '',
`time_stamp` int(11) NOT NULL default '0',
PRIMARY KEY (`dl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `phpbb_dl_stats`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_downloads`
--

DROP TABLE IF EXISTS `phpbb_downloads`;
CREATE TABLE `phpbb_downloads` (
`id` int(11) NOT NULL auto_increment,
`description` blob,
`file_name` varchar(255) default '',
`klicks` int(11) default '0',
`free` tinyint(1) default '0',
`extern` tinyint(1) default '0',
`long_desc` blob,
`sort` int(11) default '0',
`cat` int(11) default '0',
`hacklist` tinyint(1) default '0',
`hack_author` varchar(255) default '',
`hack_author_email` varchar(255) default '',
`hack_author_website` tinytext,
`hack_version` varchar(32) default '',
`hack_dl_url` tinytext,
`test` varchar(50) default '',
`req` blob,
`todo` blob,
`warning` blob,
`mod_desc` blob,
`mod_list` tinyint(1) default '0',
`file_size` bigint(20) NOT NULL default '0',
`change_time` int(11) default '0',
`add_time` int(11) default '0',
`rating` smallint(5) NOT NULL default '0',
`file_traffic` bigint(20) NOT NULL default '0',
`overall_klicks` int(11) default '0',
`approve` tinyint(1) default '0',
`add_user` mediumint(8) default '0',
`change_user` mediumint(8) default '0',
`last_time` int(11) default '0',
`down_user` mediumint(8) NOT NULL default '0',
`thumbnail` varchar(255) NOT NULL default '',
`broken` tinyint(1) NOT NULL default '0',
`mod_desc_uid` varchar(8) NOT NULL default '',
`mod_desc_bitfield` varchar(255) NOT NULL default '',
`mod_desc_flags` int(11) unsigned NOT NULL default '0',
`long_desc_uid` varchar(8) NOT NULL default '',
`long_desc_bitfield` varchar(255) NOT NULL default '',
`long_desc_flags` int(11) unsigned NOT NULL default '0',
`desc_uid` varchar(8) NOT NULL default '',
`desc_bitfield` varchar(255) NOT NULL default '',
`desc_flags` int(11) unsigned NOT NULL default '0',
`warn_uid` varchar(8) NOT NULL default '',
`warn_bitfield` varchar(255) NOT NULL default '',
`warn_flags` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `phpbb_downloads`
--


-- --------------------------------------------------------

--
-- Structure de la table `phpbb_downloads_cat`
--

DROP TABLE IF EXISTS `phpbb_downloads_cat`;
CREATE TABLE `phpbb_downloads_cat` (
`id` int(11) NOT NULL auto_increment,
`parent` int(11) default '0',
`path` varchar(255) default '',
`cat_name` varchar(255) default '',
`sort` int(11) default '0',
`description` blob,
`rules` blob,
`auth_view` tinyint(1) NOT NULL default '1',
`auth_dl` tinyint(1) NOT NULL default '1',
`auth_up` tinyint(1) NOT NULL default '0',
`auth_mod` tinyint(1) NOT NULL default '0',
`must_approve` tinyint(1) NOT NULL default '0',
`allow_mod_desc` tinyint(1) NOT NULL default '0',
`statistics` tinyint(1) NOT NULL default '1',
`stats_prune` mediumint(8) NOT NULL default '0',
`comments` tinyint(1) NOT NULL default '1',
`cat_traffic` bigint(20) NOT NULL default '0',
`cat_traffic_use` bigint(20) NOT NULL default '0',
`allow_thumbs` tinyint(1) NOT NULL default '0',
`auth_cread` tinyint(1) NOT NULL default '0',
`auth_cpost` tinyint(1) NOT NULL default '1',
`approve_comments` tinyint(1) NOT NULL default '1',
`bug_tracker` tinyint(1) NOT NULL default '0',
`desc_uid` varchar(8) NOT NULL default '',
`desc_bitfield` varchar(255) NOT NULL default '',
`desc_flags` int(11) unsigned NOT NULL default '0',
`rules_uid` varchar(8) NOT NULL default '',
`rules_bitfield` varchar(255) NOT NULL default '',
`rules_flags` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `phpbb_downloads_cat`
--

INSERT INTO `phpbb_downloads_cat` (`id`, `parent`, `path`, `cat_name`, `sort`, `description`, `rules`, `auth_view`, `auth_dl`, `auth_up`, `auth_mod`, `must_approve`, `allow_mod_desc`, `statistics`, `stats_prune`, `comments`, `cat_traffic`, `cat_traffic_use`, `allow_thumbs`, `auth_cread`, `auth_cpost`, `approve_comments`, `bug_tracker`, `desc_uid`, `desc_bitfield`, `desc_flags`, `rules_uid`, `rules_bitfield`, `rules_flags`) VALUES
(1, 0, '/', 'test', 0, 0x74657374, '', 1, 1, 2, 0, 1, 0, 1, 100000, 1, 0, 0, 0, 0, 1, 0, 0, '', '', 7, '', '', 0);

I upload a folder install for mod download and from webbrowzer : http://my_domain.fr/install/index.php, I choose Converting and error :

Conversion not possible!
This release of the MOD can not be converted for the phpBB 3.
The release must min. have release 5.2.0 and not still be made for the phpBB 3
Your release have the version 6.0.7.
If your release is updated at least to 5.0.0, you can start the update inclusive the conclusing conversion.

thus I proceed to his installation and here an error:
Download MOD Installation

Installation not possible!

The script found an existing installation, so you can not use the installation script again.
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Download mod phpbb2 => phpbb3

Beitrag von oxpus »

The installation is only possible at the first time, after this you only can update!

To convert the old installation on from your phpBB 2 you must backup the tables from this forum, NOT from the new one(!) and restore these tables in the NEW forum.
And these tables you can convert.
The converting will NOT work from a fresh installed download mod based on an phpBB 2 installation in an other database!
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Bigbang95

Re: Download mod phpbb2 => phpbb3

Beitrag von Bigbang95 »

One cannot restore the tables of the forum phpbb2 towards the forum phpbb3, the tables do not correspond.


and if I entirely remove the MOD download and then I launch his installation but by making conversion? would that function?


edit :

I have just removed downlod MOD of the forum (phpbb3) and I have just converted my forum phpbb2.

I have just put the repertory install MOD download and while wanting to convert, he says to me:
Download MOD Converting
Conversion not possible!

This release of the MOD can not be converted for the phpBB 3.
The release must min. have release 5.2.0 and not still be made for the phpBB 3
Your release have the version n/a.
If your release is updated at least to 5.0.0, you can start the update inclusive the conclusing conversion.

but I can proceeded has installation.


thus I must make how now ?

If I compare the tables of phpbb2 with phpbb3, they are not identical thus conversion will pose problem: S
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Download mod phpbb2 => phpbb3

Beitrag von oxpus »

Again:
- Drop all Download MOD tables from your phpBB 3
- Backup the Download MOD tables from your phpBB 2
- Restore the tables from the phpBB 2 into the database from your phpBB 3
- Upload/Start the file install/index.php form the Download MOD and choose the tab converting.
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Bigbang95

Re: Download mod phpbb2 => phpbb3

Beitrag von Bigbang95 »

ok but the tables phpbb_users and phpbb_groups cannot be to import on the table phpbb 3…. no importance?
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Download mod phpbb2 => phpbb3

Beitrag von oxpus »

I still wrote, that you should ONLY backup and restore the tables from the Download MOD and do NOT change or use the other phpBB tables!
Each setting by the groups and/or user must be (re)set manually after the converting.
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Bigbang95

Re: Download mod phpbb2 => phpbb3

Beitrag von Bigbang95 »

he groups and/or user must be (re)set manually after the converting.

thus I must make how now ?


edit :

http://support-cssource.fr/test2/

images and language dosen't work after converting :s
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Download mod phpbb2 => phpbb3

Beitrag von oxpus »

Images: Update the template and image cache for all installed styles.
Language: You must translate the files dl_help.php and downloads.php and upload them in the folder language/fr/mods and regard the email textfiles, too.

And how to set the group options?
Like you have set them in your old forum ;)
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Antworten