drugCMS

Rename drugCMS to DZIRcms

As SQL gets more restrictive, one can't use '0000-00-00 00:00:00' for a datetime field.
Also one can't GROUP BY or ORDER BY non selected fields, or have fields missing in GROUP BY which are selected.

Resetting all aliases from SEO-URL will reset all aliases in all clients.
We must restrict this to the current client, eventually with an option to do so for all clients.

Output compressor changes relative paths (starting with ../) to the client's absolute path (like http://domain.com/cms/).
This is okay as long as no file from a different folder is included (like /cms/font-awesome/css/).
In this case, relative paths must be rewritten to the folder the file is in (like http://domain.com/cms/fontawesome/).

Thanks to Thomas Dubbert for reporting this bug!

Implement a jQuery table sorter as mentioned here: http://forum.contenido.org/viewtopic.php?f=92&t=36644&p=168637#p168637

Add an option to delete contained articles and sub-categories on deleting a category.
Delete, if set, through this tree step by step, first deleting all articles in the deepest category, then deleting that category.
Repeat this way up until the selected category is empty and then delete it, finishing the job.

User Rights: User with set rights should be able to give other (new) users same rights: http://forum.contenido.org/viewtopic.php?f=92&t=36469&view=unread&sid=7c63b5108740416edb6159e211c9d66f#p167847

Restrict attempts to log into the backend to a certain number.
Check the IP address and/or the browser info for this, not the login (the real user might try to login in between).

On using TinyMCE, the backend pageneeds to reload on opening and saving.
By showing the editor in a popup (or inline, we already have a small one there) and saving through Ajax (and updating the page content), work gets easier and faster because the need to scroll down again to get to the next working position is minimized.

On inserting a link in TinyMCE and opening the target select window, in this window's left pane folders stay marked as active while categories never get marked.

For this, we need a package of functions for checking and deleting different areas in the database and file system.
Each function must be able to first check it's possibility to delete it's stuff and report the status, and only if all functions report status ok, then each function get's called again to actually execute the deleting process.
We must create a backend form (like DB Backup) which keeps calling the main function while outputting the results as the overall process might take a while.
Also, after all ok results on the checking process, the user should confirm the deletion again by pressing a button.

Implement the possibility to redesign a website without showing changes live or working in a copy of the website.

Thoughts:
- use a new "dummmy client" and takeover the changes on button press.
- create a layouts folder and move the design stuff (css, images, js, ...) in there in a subfolder per design (we'll have to save the layouts and templates as files then), then create a backend select field to switch the design at will.
Either case, we need an url parameter to switch to an inactive design for testing purposes.

We have functions createCategorySelect() and createArticleSelect().
To make module delevopment easier, we also need functions createDirectorySelect() and createFileSelect().

createDirectorySelect():
List all directories from the database, include a file extension list to filter by.
Possible uses:
- echo createDirectorySelect("CMS_VAR[0]", "CMS_VALUE[0]");
- echo createDirectorySelect("CMS_VAR[0]", "CMS_VALUE[0]", 'pdf');
- echo createDirectorySelect("CMS_VAR[0]", "CMS_VALUE[0]", array('pdf', 'txt'));

createFileSelect():
List all files given a directory or array of directories, include a file extension list to filter by.
Possible uses:
- echo createFileSelect("CMS_VAR[1]", "CMS_VALUE[1]", "CMS_VALUE[0]");
- echo createFileSelect("CMS_VAR[1]", "CMS_VALUE[1]", "CMS_VALUE[0]", 'pdf');
- echo createFileSelect("CMS_VAR[1]", "CMS_VALUE[1]", "CMS_VALUE[0]", array('pdf', 'txt'));
- echo createFileSelect("CMS_VAR[1]", "CMS_VALUE[1]", array('galleries/main/', 'header/'));
- echo createFileSelect("CMS_VAR[1]", "CMS_VALUE[1]", array('galleries/main/', 'header/'), 'pdf');
- echo createFileSelect("CMS_VAR[1]", "CMS_VALUE[1]", array('galleries/main/', 'header/'), array('pdf', 'txt'));
If an array of directories was specified, include the directory name in the select options texts.

In article properties, a list of categories exists to enable the user to move the article.
In this list, the categories the user has no rights for are also listet.
Filter them out according to the user's rights.

Also rework the function createCategorySelect() for the same filter.
But here we must think of a possibility to remain settings from other users, because they would get lost on saving the configuration.

Plugin "DB Backup".
Add a textfield in which to enter a comment which will be shown in the list of backups.

Possible solutions:
- Save a list of backup files with the comments in the database (not recommended)
- Save the comments as properties in the database
- Save a txt file containing the comment with the backup file (same filename)
Remember to delete the comments on deleting the backup files!

Create a folder named "system" in which the system files and folders get moved.
Only the client folder(s) remain in root.
The new folder must be renamed on setup, so only the sysadmin knows it's name.
In this folder, there must be a .htaccess which routes to the /<new folder>/drugcms/ folder.
The drugCMS backend then is reachable only by entering this folder's name after the domain.
CAUTION: The client's config.php file needs to be altered as well!

As the setup folder get's moved into this new folder too, setup has to change it's address on the renaming process in order to continue.

On (cross-)upgrading from drugCMS 2.0.x/Contenido 4.6.x and 4.8.x, we have to remove the old system folders and files, as they are not within this new folder.
And in this situation the sysadmin (who does the upgrade) also has to enter a new name for this folder, except if he removed it and moved the contained system files and folders back to root (he might already work with a subdomain for the backend).

Make email addresses unreadable for bots on outputting the page while implementing javascript to restore them in the browser.
Caution: The email addresses must not produce w3c invalid code in mailto links (no illegal signs like for example "()[]{} /\|").
Suggested still valid code is info.at.drugcms.org.

Add a system/client/USER option to show category and article names in a prefered language (tooltip).

Inspired by http://forum.contenido.org/viewtopic.php?f=92&t=35247#p164661.

PHPMailer: Upgrade to newest version

Implement an export function for the client with all layouts, modules, templates, categories, articles, languages, and settings (and what else is needed).

Also implement a system which can list designs from a shop webpage and install them with a mouse click.
The shop webpage will handle the payment (if needed) through PayPal (other payment options possible) and deliver a code for the download.
If the payment doesn't immediately occur, the buyer must be sent the code afterwards to enter in his system.
As soon as the system get's the correct code, it will start downloading and installing the client.

The import function will need to use new ID's for all database entries, which the export function will have to take into account.

Implement a system updater, which can, by setting, either update the system on mouse klick, or completely automatically at a set daytime.
The automatic update functionallity must be restricted to either the primary or secondary version number (2.x.x or 2.0.x).

Add options to the preview area which change the size of the viewport to emulate mobile devices.
Offer known sizes with device names (iPhone 5, Galaxy Note 3, ...) as well as free width and height entry fields.
This makes it easier for authors to see what the page would look like on those devices, which reduces responsive sites with non-responsive contents.

Suggestion: http://forum.contenido.org/viewtopic.php?f=36&t=34999.

Take the demo client installation data out of the drugCMS package and make it available through the drugcms.org website as downloadable packages:
- while installing drugCMS
- before installing drugCMS, to upload it into the setup folder
This way we can offer packages for a lot of different languages, each in a separate package, and the user can choose his prefered packages.
The setup routine for the demo client installation data must also be rewritten to enable each selected language to be an additional language.
The user can then choose a language, then a second language, then a third language, and so on.
The setup should prefer uploaded packages and (if possible) list online additional languages.

Recode the login form and code to get the session key ($contenido) after the login process.
As for now, the session key ist in the login form, which makes it impossible to login through an automated script.

As for the internationalization, drugCMS needs to support more languages (setup, backend, plugins, ...).