M-am uitat la baza de date la cele 2 softuri: phpBB 2.0.17 si phpBB-php5 2.0.17.5 si nu sunt diferente majore. Deci poti sa-ti pastrezi baza de date veche si sa pui pe site fisierele de la phpBB-php5 2.0.17.5. Stergi directoarele /install si /contrib si suprascrii fisierul config.php de la forumul vechi peste cel nou. Atentie daca ai MODuri, stiluri sau avataruri:
Mutarea forumului de pe un server pe altul. La sfarsit rulezi la baza de date comanda:
Cod: Selectaţi tot
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5');
Comparatie intre bazele de date de la phpBB 2.0.17 si phpBB-php5 2.0.17.5:
phpBB-php5 2.0.17.5: /install/schemas/mysql_basic.sql
Cod: Selectaţi tot
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5');
phpbb 2.0.17: /install/schemas/mysql_basic.sql (user_allowhtml=1)
Cod: Selectaţi tot
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 1, 1, 0, 1, 1, NULL, '', '', 0, '', '', '', 0, 0);
phpBB-php5 2.0.17.5: /install/schemas/mysql_basic.sql (user_allowhtml=0)
Cod: Selectaţi tot
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', 0, '', '', '', 0, 0);
phpbb 2.0.17: /install/schemas/mysql_schema.sql (session_admin tinyint(2))
Cod: Selectaţi tot
CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
session_admin tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
);
phpBB-php5 2.0.17.5: /install/schemas/mysql_schema.sql (session_admin tinyint(1))
Cod: Selectaţi tot
CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
session_admin tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
);