Menu
▾
▴
[mxbb-commits] mx_music db_install.php, 1.16, 1.17 db_upgrade.php, 1.12, 1.13
|
From: Florin C B. <ory...@us...> - 2013-07-21 14:01:14
|
Update of /cvsroot/mxbb/mx_music In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv17103 Modified Files: db_install.php db_upgrade.php Log Message: Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_music/db_install.php,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** db_install.php 9 Apr 2013 12:15:22 -0000 1.16 --- db_install.php 21 Jul 2013 14:01:11 -0000 1.17 *************** *** 33,37 **** } ! $mx_module_version = '2.9.5'; $mx_module_copy = 'Mx-Publisher <i> - Music Center</i> module based on © 2003 <a href="http://cfmanager.net.tf" target="_blank">Cf Manager</a> - <i>Music Online</i> & <a href="http://mxpcms.sourceforge.net/" target="_blank">OryNider</a>'; --- 33,37 ---- } ! $mx_module_version = '2.9.6'; $mx_module_copy = 'Mx-Publisher <i> - Music Center</i> module based on © 2003 <a href="http://cfmanager.net.tf" target="_blank">Cf Manager</a> - <i>Music Online</i> & <a href="http://mxpcms.sourceforge.net/" target="_blank">OryNider</a>'; *************** *** 55,60 **** song_imagename varchar(255) NOT NULL, song_title varchar(255) NOT NULL, ! song_url varchar(255) NOT NULL, ! song_desc text, song_singer varchar(255) NOT NULL, song_user_id mediumint(8) NOT NULL, --- 55,60 ---- song_imagename varchar(255) NOT NULL, song_title varchar(255) NOT NULL, ! song_url TEXT, ! song_desc TEXT, song_singer varchar(255) NOT NULL, song_user_id mediumint(8) NOT NULL, Index: db_upgrade.php =================================================================== RCS file: /cvsroot/mxbb/mx_music/db_upgrade.php,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** db_upgrade.php 9 Apr 2013 12:15:22 -0000 1.12 --- db_upgrade.php 21 Jul 2013 14:01:12 -0000 1.13 *************** *** 30,34 **** } ! $mx_module_version = '2.9.5'; $mx_module_copy = 'Mx-Publisher <i> - Music Center</i> module by Cf Manager & <a href="http://www.mx-publisher.com/" target="_blank">OryNider</a>'; $sql = array(); --- 30,34 ---- } ! $mx_module_version = '2.9.6'; $mx_module_copy = 'Mx-Publisher <i> - Music Center</i> module by Cf Manager & <a href="http://www.mx-publisher.com/" target="_blank">OryNider</a>'; $sql = array(); *************** *** 44,47 **** --- 44,48 ---- $upgrade_206 = 0; $upgrade_207 = 0; + $upgrade_296 = 1; // *************** *** 62,72 **** $upgrade_207 = 1; } ! $message = "<b>Upgrading!</b><br/><br/>"; ! if ( $upgrade_206 == 1 ) { $message .= "<b>Upgrading to v. 2.01(2.06)...</b><br/><br/>"; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "music ADD song_imagename VARCHAR(255) not null AFTER song_filename"; $sql[] = "ALTER TABLE " . $mx_table_prefix . "music ADD song_download_count VARCHAR(255) not null DEFAULT '0' AFTER song_approval"; --- 63,73 ---- $upgrade_207 = 1; } ! $message = "<b>Upgrading!</b><br/><br/>"; ! if ( $upgrade_206 == 1 ) { $message .= "<b>Upgrading to v. 2.01(2.06)...</b><br/><br/>"; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "music ADD song_imagename VARCHAR(255) not null AFTER song_filename"; $sql[] = "ALTER TABLE " . $mx_table_prefix . "music ADD song_download_count VARCHAR(255) not null DEFAULT '0' AFTER song_approval"; *************** *** 81,85 **** $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('qt_allowed', '1')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('rm_allowed', '1')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('max_image_size', '10240')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('max_image_width', '800')"; --- 82,86 ---- $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('qt_allowed', '1')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('rm_allowed', '1')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('max_image_size', '10240')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('max_image_width', '800')"; *************** *** 90,98 **** $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('index', '5')"; } ! if ( $upgrade_207 == 1 ) { $message .= "<b>Upgrading to v. 2.0.7...</b><br/><br/>"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('xs_enabled', '1')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('img_allowed', '1')"; --- 91,99 ---- $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('index', '5')"; } ! if ( $upgrade_207 == 1 ) { $message .= "<b>Upgrading to v. 2.0.7...</b><br/><br/>"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('xs_enabled', '1')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('img_allowed', '1')"; *************** *** 103,115 **** $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('rows_per_page_media', '10')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('cols_per_page_media', '1')"; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "music_cat ADD cat_parent mediumint(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_id"; $sql[] = "ALTER TABLE " . $mx_table_prefix . "music_cat ADD cat_type tinyint NOT NULL DEFAULT '0' AFTER cat_parent"; $sql[] = "ALTER TABLE " . $mx_table_prefix . "music ADD song_filetype varchar(255) NOT NULL AFTER song_filename"; ! $sql[] = "UPDATE ". $mx_table_prefix ."music_config SET config_value = '0.7' WHERE config_name = 'music_version'"; } else { --- 104,123 ---- $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('rows_per_page_media', '10')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "music_config VALUES ('cols_per_page_media', '1')"; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "music_cat ADD cat_parent mediumint(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_id"; $sql[] = "ALTER TABLE " . $mx_table_prefix . "music_cat ADD cat_type tinyint NOT NULL DEFAULT '0' AFTER cat_parent"; $sql[] = "ALTER TABLE " . $mx_table_prefix . "music ADD song_filetype varchar(255) NOT NULL AFTER song_filename"; ! $sql[] = "UPDATE ". $mx_table_prefix ."music_config SET config_value = '0.7' WHERE config_name = 'music_version'"; } + + if ( $upgrade_296 == 1 ) + { + $message .= "<b>Upgrading to v. 2.9.6...</b><br/><br/>"; + + $sql[] = "ALTER TABLE " . $mx_table_prefix . "music CHANGE song_url song_url TEXT"; + } else { *************** *** 121,125 **** module_copy = '" . $mx_module_copy . "' WHERE module_id = '" . $mx_module_id . "'"; ! $message .= mx_do_install_upgrade( $sql ); } --- 129,133 ---- module_copy = '" . $mx_module_copy . "' WHERE module_id = '" . $mx_module_id . "'"; ! $message .= mx_do_install_upgrade( $sql ); } |
