What if images are stored as BLOB's in the DB???

http://wiki.fckeditor.net/Developer's_G ... ntegration

FirefoxFirebugLive HTTP headers

oucil wrote:The CMS I've developed stores the images and for that matter all other forms of media in the DB as a BLOB, before anyone turns this into a debate over DB vs. FS, leave it alone, I have my reasons

Is there a way or even a workaround to allow FCK's file browser to be provided with images from my media store in the database rather than browsing a physical folder? On the same token, is there a way for FCK to call a remote procedure of some kind rather than invoke it's own uploader when I want to upload a new file?

Many thanks,

Kevin.

has anyone out there manage to get this working???

i'm looking for a solution to be able to upload files to a mysql db but don't know where to begin with fck's filemanager

You need to mimic the file system and design a set of tables for that. For example, you may have a table with a directory/file name, a parent directory ID, entry type (directory, file, image, media, etc). When you implement GetFolders and GetFoldersAndFiles, you will receive the current directory from the editor and will use it to select a list of records of the selected entry type, such as subdirectories and/or files of a certain type, like images. CreateFolder will then insert a record in this table with a parent directory ID of the current directory.

You don't have to reuse the existing PHP connector. Just change Link/Image/FlashBrowserURL to something like this:

FCKConfig.LinkBrowserURL = FCKConfig.BasePath + "filemanager/browser/default/browser.html?Connector=/my-file-manager.php

, where /my-file-manager.php can be any path you want. This way you won't depend on FCK's hierarchy and can upgrade to the new version without having to worry about wiping any of your changes.

Also change quick upload URLs like this:

FCKConfig.LinkUploadURL = "/my-quick-upload.php";

The former will receive all of the commands (GetFolders, CreateFolder, etc) and the latter will just get a file form post.

Andre

http://www.codeplex.com/fckeditfilemanager