integrate a FLV video reader

[Mikado]

How to integrate a FLV video reader into an EZ-page?

[yellow1912]

Look at my module in my signature, that may help.

[Mikado]

Thank you Yellow but I can't download files. Where I can download a zip file?

[Mikado]

My video folder is in C:/Program Files/EasyPHP1-8/www/zencart/videos/
What is his absolute path and his relative path?

[yellow1912]

Im guessing: absolute path:
/www/zencart/videos/

Relative path:
videos

[Mikado]

Thank you Yellow!

My server is localhost and the path of www is C:\Program Files\EasyPHP1-8\www
My store name is zencart.

In Configuration/Simple Video Manager my parameters are :

Set the absolute path to your video folder  	/www/zencart/videos/  	 
Set relative path to your video folder 	/zencart/videos/ 
Allowed file types 	flv 
Video height 	350 
Video width 	400 
Video autostart 	true 
Max number of links 	5

In Extras/SIMPLE VIDEO MANAGER, when I clic on List All Files In Directory I have this error :

Warning: closedir(): supplied argument is not a valid Directory resource in c:\program files\easyphp1-8\www\zencart\admin\includes\functions\extra_functions\simple_video_manager.php on line 82

Nota : during the execution of sql_patch.sql I had an error because the configuration_key 'SIMPLE_VIDEO_MANAGER_DIRECTORY' exists twice.

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Set the absolute path to your video folder', 'SIMPLE_VIDEO_MANAGER_DIRECTORY', '', 'Set the absolute path to your video folder. Be sure to leave the trailing \'/\' at the end. i.e: /var/www/vhost/accountname/public_html/store/videos/', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Set relative path to your video folder', 'SIMPLE_VIDEO_MANAGER_DIRECTORY', '', 'Relative path is the path that can be accessed by browser. Be sure to leave the trailing \'/\' at the end. i.e: /store/videos/', @t4, 1, NOW(), NOW(), NULL, NULL);

I have renamed the second key(relative path) SIMPLE_VIDEO_MANAGER_DIRECTORY in SIMPLE_VIDEO_MANAGER_DIRECTORY_REL
Has it an incidence on the error?

[yellow1912]

I dont know why the mysql is messed up like that, but you can download the new one from the server now and re-install the patch.

[Mikado]

All my tables are prefixed 'zen_', I thus modified your file as this :

## Simple Video Manager Alpha 1.0
#
## This script should be able to be run from Admin->Tools->Install SQL Patches
#

DROP TABLE IF EXISTS zen_simple_video_manager;
CREATE TABLE zen_simple_video_manager (
  id int(10) NOT NULL auto_increment,
  name varchar(255) not null,
  description text,
  filename varchar(255) not null,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

DELETE FROM zen_configuration_group WHERE configuration_group_title = 'Simple Video Manager';
INSERT INTO zen_configuration_group VALUES ('', 'Simple Video Manager', 'Set Video Manager Settings', '1', '1');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM zen_configuration_group
WHERE configuration_group_title= 'Simple Video Manager';

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Set the absolute path to your video folder', 'SIMPLE_VIDEO_MANAGER_ABSOLUTE_PATH', '', 'Set the absolute path to your video folder. Be sure to leave the trailing \'/\' at the end. i.e: /var/www/vhost/accountname/public_html/store/videos/', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Set relative path to your video folder', 'SIMPLE_VIDEO_MANAGER_RELATIVE_PATH', '', 'Relative path is the path that can be accessed by browser. Be sure to leave the trailing \'/\' at the end. i.e: /store/videos/', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Allowed file types', 'SIMPLE_VIDEO_MANAGER_FILE_TYPES', 'flv', 'Set allowed video file types, separated by comma. i.e: avi,swf,rm', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Video height', 'SIMPLE_VIDEO_MANAGER_VIDEO_HEIGHT', '350', 'Set video height', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Video width', 'SIMPLE_VIDEO_MANAGER_VIDEO_WIDTH', '400', 'Set video width', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Video autostart', 'SIMPLE_VIDEO_MANAGER_VIDEO_AUTO_START', 'true', 'Do you want to set the video to auto start playing?', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Max number of links', 'SIMPLE_VIDEO_MANAGER_MAX_LINK', '5', 'Set max number of links to be displayed in sidebox', @t4, 1, NOW(), NOW(), NULL, NULL);

I always have the same error

[yellow1912]

If you run it using ZC admin you dont need to add the prefix at all.
Anyhow, add this line right after:

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'Simple Video Manager';

delete from configuration where configuration_id = @t4;

[yellow1912]

My mistake, the extra sql line should be like this:

DELETE FROM configuration WHERE configuration_group_id = @t4;