I would like to use fckeditor to browse for links from a database instead of the file system. I would like to know if a plugin has been developped for this (in asp if possible).
So, all you need to do is re-write the connector.asp, and instead of pulling the files from the filesystem, pull them from a database.
I might write a skeleton of a plug-in, if you were thinking of something different than the default filemanager.... I don't really do much ASP tho. (Testing environment is no longer set up, but I could re-establish it.)
It's really easy tho. Either way. Good coding folks!
Thanks folks for the reply but... I'm not so sure it's "really easy". I've looked at connector.asp file and this is not the only file to modify since it calls functions in other files. I've also looked at connector.cfm but I'm not familiar with ColdFusion.
So I'm asking again : did somebody made something similar, perhaps in PHP?
Well they're basically the same, only broke down more. What's easy is how the filebrowser interacts with the connector. All it's expecting is valid XML, conforming to the stuff that's documented in the _documentation directory.
Thing about the db connector, is that everyone will probably want differnt structure. I could relativly easily switch my db connector to PHP... as I left it, I think it pretty much replicated the filesystem one. using folders, etc. Maybe throw in a switch for storing files in db or using paths to files...
That would take a lot longer than whippin g up a skeleton plug-in that pulls links from a table, and inserts them in the editor window when clicked on...
Which would you prefer? (You in general.) Someone else's structure(not even close to tip top) or a crude example?
If there is public outcry for a PHP db-ized connector for the filebrowser, I'll give it a shot... it would have users and groups tho. Sheesh. That gets all complicated... hrm. That's what I'd do tho. I've got buttons and plug-ins for user and groups... select who you want to be able to view what, etc...
Um... maybe I'll just put up that crude example for now... :-}
Here's a crude example of PHP pulling links from a db and inserting them as <href>s. the meat is the one (ugly) file phpSQL.php. That's how hard it is.
CREATE a table called tblLinks, with linkID as autoincrement and linkURL as varchar. Then try the plugin. doen't do anything really, just proof of concept or whatever. More examples, however lame, help i guess. Oh, it's expecting MSsql for the DBMS. =-/
Well, here' show it goes. After I made my statement about the DB connector (I assume you're talking about the file browser connector... if you want meerly to insert links from a db, check out the crappy example I whipped up for PHP. It's similar to ASP enough you should be able to bang your way through the logic. If not, lemme know and I'll pretty it up and make a ASP example of it as well.) last week I did some poking around in the default file browser. As there is no framework for authentication, or movement or deletion of files, I was stymied(sp?). The expanded PHP connector has a good bit of stuff (good job folks) already 'framed' out. Thus the dilemma. Risk diverging from the core code, or have limited functions that will need to be re-coded later. I'm opting for just banging out a DB powered 'extended' version PHP filebrowser/connector. I don't mind mixing languages ( I suck equally at all of them so if someone wants to update the ASP/whatnot parts of the extended filebrowser, I'll DBize them ass well.
Or, if there is a framework FredCK is close on, and would like to have 'mirrored' DB-wise, I'll make a 'standards' compliant one. =-)
People should really be carefull with allowing uploads to their servers, period. Scary crap. I like the converting stuff to base64/etc, but people will figure out how to get around anything.
That being so, I am gonna work on a DB filebrowser version of the 'extended' PHP browser/connector. Maybe with a twist or two of my own... choose between thumbnails and detail view... hrm...
What fun! Just in spare time unfortunatly, so don't expect stuff the way FredCK et al does it. All super fast and multi-addressing... I'm in awe! Comments welcome...
RE: Database link browser
That's one of the beautiful aspects of FredCK's design with the connector. It's XML
RE: Database link browser
So, all you need to do is re-write the connector.asp, and instead of pulling the files from the filesystem, pull them from a database.
I might write a skeleton of a plug-in, if you were thinking of something different than the default filemanager.... I don't really do much ASP tho. (Testing environment is no longer set up, but I could re-establish it.)
It's really easy tho. Either way. Good coding folks!
RE: Database link browser
RE: Database link browser
So I'm asking again : did somebody made something similar, perhaps in PHP?
RE: Database link browser
Well they're basically the same, only broke down more. What's easy is how the filebrowser interacts with the connector. All it's expecting is valid XML, conforming to the stuff that's documented in the _documentation directory.
Thing about the db connector, is that everyone will probably want differnt structure. I could relativly easily switch my db connector to PHP... as I left it, I think it pretty much replicated the filesystem one. using folders, etc. Maybe throw in a switch for storing files in db or using paths to files...
That would take a lot longer than whippin g up a skeleton plug-in that pulls links from a table, and inserts them in the editor window when clicked on...
Which would you prefer? (You in general.)
Someone else's structure(not even close to tip top) or a crude example?
If there is public outcry for a PHP db-ized connector for the filebrowser, I'll give it a shot... it would have users and groups tho. Sheesh. That gets all complicated... hrm. That's what I'd do tho. I've got buttons and plug-ins for user and groups... select who you want to be able to view what, etc...
Um... maybe I'll just put up that crude example for now... :-}
RE: Database link browser
Here's a crude example of PHP pulling links from a db and inserting them as <href>s. the meat is the one (ugly) file phpSQL.php. That's how hard it is.
CREATE a table called tblLinks, with linkID as autoincrement and linkURL as varchar. Then try the plugin. doen't do anything really, just proof of concept or whatever. More examples, however lame, help i guess. Oh, it's expecting MSsql for the DBMS. =-/
http://www.unm.edu/~valliant/FCKeditor/phpSQL.zip
Happy Trails!
RE: Database link browser
RE: Database link browser
RE: Database link browser
Well, here' show it goes. After I made my statement about the DB connector (I assume you're talking about the file browser connector... if you want meerly to insert links from a db, check out the crappy example I whipped up for PHP. It's similar to ASP enough you should be able to bang your way through the logic. If not, lemme know and I'll pretty it up and make a ASP example of it as well.) last week I did some poking around in the default file browser. As there is no framework for authentication, or movement or deletion of files, I was stymied(sp?). The expanded PHP connector has a good bit of stuff (good job folks) already 'framed' out. Thus the dilemma. Risk diverging from the core code, or have limited functions that will need to be re-coded later. I'm opting for just banging out a DB powered 'extended' version PHP filebrowser/connector. I don't mind mixing languages ( I suck equally at all of them
so if someone wants to update the ASP/whatnot parts of the extended filebrowser, I'll DBize them ass well.
Or, if there is a framework FredCK is close on, and would like to have 'mirrored' DB-wise, I'll make a 'standards' compliant one. =-)
People should really be carefull with allowing uploads to their servers, period. Scary crap. I like the converting stuff to base64/etc, but people will figure out how to get around anything.
That being so, I am gonna work on a DB filebrowser version of the 'extended' PHP browser/connector. Maybe with a twist or two of my own... choose between thumbnails and detail view... hrm...
What fun! Just in spare time unfortunatly, so don't expect stuff the way FredCK et al does it. All super fast and multi-addressing... I'm in awe! Comments welcome...