From: Chris Farrell <chris@cf...> - 2004-01-04 08:34:23
New module I just finished that I hope will be very useful. It is not
100% done yet but I wanted
to publish it anyway so that I can get feedback.
This module is designed to be a flexible way to move data from one
module to another of the same
type. Examples might include
-Annoucements. The newest announcements go on the homepage but after a
while you want to make
room for new stuff without dumping the old stuff.
-General Site Admin. Say you decide to re-organize your page and don't
want to lose all your content.
You can create a new module wherever and then move the entire content of
the existing module to the
Currently I have only added support for the Annoucements module and FAQ
Module(support there but not tested).
Don't worry, it only takes about 45 seconds to add others. As easy as
adding a item to the rb_ContentManager
table. It is 3:15am now, I'll add the rest tomorrow.
This design isn't the style specified by Mark with modifying the
EditItemClass. Instead I wrote this module
with the idea that it can be put on the Admin This tab or on its own tab
that has Admin Permissions.
1: Right now the module uses SQL Joins(about 4 of em) to get all of the
needed information. I am considering
a temp table that holds all of the needed information, that is kept up to
date by a trigger allowing me to do a
single table query instead of joins. Or perhaps a view would be good too
but I do not think it would be as fast
as a temp table. The query currently performs pretty well because the
tables are small, it is the fact that I have
to keep doing the same join over and over that bothers me.
2: Copy support. Currently I have "Move Item" and "Move All" features
working. Copying is more difficult
than moving. I think I can have this done within a few days.
3: Details(permissions checks, optimization, documentation, etc).
Suggestions needed on
-User Interface. I tried to make it simple, this is actually about my 5th
UI design. I think it is pretty simple
now but can always improve.
-SQL. Got a easier, cleaner way? A faster way? Suggestions??
Code is attached to this email and also available on my
Because this is a Admin module there is no live demo, sorry. I will be
posting screenshots tomorrow, email