OsCommerce & MP3 Player with MySQL5;PHP5

[csaba911]

Has Anybody already made the nessesary changes to the Contribution MP3 Player for OsCommerce yet ?

http://www.oscommerce.com/community/contributions,2380

 

or anybody has any Idea where it needs to be changed for MySQL5 ?

 

so far I changed the INSERT INTO ...... ('', '',) arguments to INSERT INTO ..... ( null,null) for the *.sql script

 

But there is more to it here is what I did :

 

This is the original code

 
# phpMyAdmin SQL Dump
#
#  Mp3 player module for osCommerce, Open Source E-Commerce Solutions****
#
#  osPlayer - ManMAchine - 09/11/2004 
#  Copyright (c) 2004 ManMAchine
#
#  Released under the GNU General Public License
#

DROP TABLE IF EXISTS `products_mp3`;
CREATE TABLE `products_mp3` (
 `products_id` int(11) NOT NULL default '0',
 `products_folder` varchar(25) NOT NULL default '',
 PRIMARY KEY  (`products_id`),
 UNIQUE KEY `products_folder` (`products_folder`)
) TYPE=MyISAM;


INSERT INTO configuration_group VALUES ('20', 'osplayer', 'osPlayer v2 Options', '20', '1');
INSERT INTO configuration VALUES ('', 'Open player in a pop up', 'ENTRY_OSCP_POPUP', 'true', 'Open a popup window ( true ) or put the player on the page ( false )', '20', '1', '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Lecture automatique', 'ENTRY_OSCP_PLAY', 'false', 'Autoplay ? ', 20, 2, '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Mp3 preview', 'PRODUCT_LIST_MP3', '10', 'Add a listen button ?',	8, 5, now(), now(), NULL, NULL);

 

Changed to

# phpMyAdmin SQL Dump
#
#  Mp3 player module for osCommerce, Open Source E-Commerce Solutions****
#
#  osPlayer - ManMAchine - 09/11/2004 
#  Copyright (c) 2004 ManMAchine
#
#  Released under the GNU General Public License
#

DROP TABLE IF EXISTS `products_mp3`;
CREATE TABLE `products_mp3` (
 `products_id` int(11) NOT NULL default '0',
 `products_folder` varchar(25) NOT NULL default '',
 PRIMARY KEY  (`products_id`),
 UNIQUE KEY `products_folder` (`products_folder`)
) TYPE=MyISAM;


INSERT INTO configuration_group VALUES ('20', 'osplayer', 'osPlayer v2 Options', '20', '1');
INSERT INTO configuration VALUES ( null, 'Open player in a pop up', 'ENTRY_OSCP_POPUP', 'true', 'Open a popup window ( true ) or put the player on the page ( false )', '20', '1', null, null, null, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ( null, 'Lecture automatique', 'ENTRY_OSCP_PLAY', 'false', 'Autoplay ? ', 20, 2, null, null, null, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ( null, 'Mp3 preview', 'PRODUCT_LIST_MP3', '10', 'Add a listen button ?',	8, 5, now(), now(), null, null);

[postma]

Has Anybody already made the nessesary changes to the Contribution MP3 Player for OsCommerce yet ?

http://www.oscommerce.com/community/contributions,2380

 

or anybody has any Idea where it needs to be changed for MySQL5 ?

 

so far I changed the INSERT INTO ...... ('', '',) arguments to INSERT INTO ..... ( null,null) for the *.sql script

 

But there is more to it here is what I did :

 

This is the original code

 
# phpMyAdmin SQL Dump
#
#  Mp3 player module for osCommerce, Open Source E-Commerce Solutions****
#
#  osPlayer - ManMAchine - 09/11/2004 
#  Copyright (c) 2004 ManMAchine
#
#  Released under the GNU General Public License
#

DROP TABLE IF EXISTS `products_mp3`;
CREATE TABLE `products_mp3` (
 `products_id` int(11) NOT NULL default '0',
 `products_folder` varchar(25) NOT NULL default '',
 PRIMARY KEY  (`products_id`),
 UNIQUE KEY `products_folder` (`products_folder`)
) TYPE=MyISAM;
INSERT INTO configuration_group VALUES ('20', 'osplayer', 'osPlayer v2 Options', '20', '1');
INSERT INTO configuration VALUES ('', 'Open player in a pop up', 'ENTRY_OSCP_POPUP', 'true', 'Open a popup window ( true ) or put the player on the page ( false )', '20', '1', '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Lecture automatique', 'ENTRY_OSCP_PLAY', 'false', 'Autoplay ? ', 20, 2, '', '', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Mp3 preview', 'PRODUCT_LIST_MP3', '10', 'Add a listen button ?',	8, 5, now(), now(), NULL, NULL);

 

Changed to

# phpMyAdmin SQL Dump
#
#  Mp3 player module for osCommerce, Open Source E-Commerce Solutions****
#
#  osPlayer - ManMAchine - 09/11/2004 
#  Copyright (c) 2004 ManMAchine
#
#  Released under the GNU General Public License
#

DROP TABLE IF EXISTS `products_mp3`;
CREATE TABLE `products_mp3` (
 `products_id` int(11) NOT NULL default '0',
 `products_folder` varchar(25) NOT NULL default '',
 PRIMARY KEY  (`products_id`),
 UNIQUE KEY `products_folder` (`products_folder`)
) TYPE=MyISAM;
INSERT INTO configuration_group VALUES ('20', 'osplayer', 'osPlayer v2 Options', '20', '1');
INSERT INTO configuration VALUES ( null, 'Open player in a pop up', 'ENTRY_OSCP_POPUP', 'true', 'Open a popup window ( true ) or put the player on the page ( false )', '20', '1', null, null, null, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ( null, 'Lecture automatique', 'ENTRY_OSCP_PLAY', 'false', 'Autoplay ? ', 20, 2, null, null, null, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ( null, 'Mp3 preview', 'PRODUCT_LIST_MP3', '10', 'Add a listen button ?',	8, 5, now(), now(), null, null);

 

Look at the post here about MySQL5 and PHP5 to see all of the changes required to the main store, it may give you an idea for what else needs to be changed here.

Kory