DZIRCMS

no task description

[07-Jan-2022 10:25:08 Europe/Berlin]  error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'off","correct","correct,fonts","correct,images","correct,fonts,images","full"...' at line 2) - info: /front_content.php?idcat=7&lang=2 INSERT INTO `DZIRCMS_effective_settings` (`setting_id`, `type`, `name`, `default_value`, `short_description`, `long_description`, `possible_values`)  VALUES (61, "generator", "output_compression", "full", "Correct or compress the output", "With this setting you control the output compressor and tell it wether to compress, download fonts, and convert images", "["off","correct","correct,fonts","correct,images","correct,fonts,images","full","full,fonts","full,images","full,fonts,images"]")

Reported by derSteffen: https://www.dzir.org/de/forum/DZIRCMS/DZIRCMS-2.1.x/Bug-Reports-2.1.x/Error-Log-bzgl.-compress/190/p=190/#190

Both in front- and backend, move writable areas (like ‘cache’) into the ‘data’ directory.
This way, only the ‘data’ directories need to be writable.

Implement the Smarty Template Engine both in front- and backend.
Make it available through it’s class name:

$smarty = new Smarty();

Make it use cache and compile directories inside data areas in the respective back- and frontends.

Implement a page in the backend which lists the translatable strings of all modules in two areas:
- all strings that are not translated in at least one language
- all strings
In each list, use a header line with the module name.
Also implement a search possibility for strings.

<p>Rename drugCMS to DZIRcms</p>

<p>As SQL gets more restrictive, one can&#039;t use &#039;0000-00-00 00:00:00&#039; for a datetime field.<br/>Also one can&#039;t GROUP BY or ORDER BY non selected fields, or have fields missing in GROUP BY which are selected.</p>

<p>Implement the &quot;Jaro Winkler Similarity&quot; code in PHP for comparing words</p>

<p>Implement a DB Query Builder based on the one CodeIgniter has (used in Gambio GX2).</p><p>Usage examples:<br/>$aResult = $db-&gt;select(&#039;*&#039;)-&gt;from($cfg[&#039;tab&#039;][&#039;art_lang&#039;])-&gt;where(&#039;idartlang&#039;, 3)-&gt;get()-&gt;result_array();<br/>echo $aResult[0][&#039;title&#039;];</p><p>$db-&gt;select(&#039;*&#039;)-&gt;from($cfg[&#039;tab&#039;][&#039;art_lang&#039;])-&gt;where(&#039;idartlang&#039;, 3);<br/>foreach ($db-&gt;get()-&gt;result_array() as $aResult) {<br/> echo $aResult[&#039;title&#039;];<br/>}</p><p>$db-&gt;update($cfg[&#039;tab&#039;][&#039;art_lang&#039;], array(&#039;title&#039; =&gt; &#039;Hello World&#039;, &#039;urlname&#039; =&gt; Hello_World&#039;), &#039;idartlang=3&#039;);</p><p>$db-&gt;insert($cfg[&#039;tab&#039;][&#039;art_lang&#039;], array(&#039;title&#039; =&gt; &#039;Hello World&#039;, &#039;urlname&#039; =&gt; Hello_World&#039;));</p><p>$db-&gt;replace($cfg[&#039;tab&#039;][&#039;art_lang&#039;], array(&#039;title&#039; =&gt; &#039;Hello World&#039;, &#039;urlname&#039; =&gt; Hello_World&#039;));</p><p>Old methods are supported for compatibility reasons ($db-&gt;query($sql), $db-&gt;next_record(), $db-&gt;f(&#039;title&#039;)).</p>

<p>While testing the new PIM, we found that on some servers, where FTP and Web are different users, there is a write permission problem.<br/>To solve this (not only for the PIM, but for the DesignShop and AutoUpdate as well) we need to implement (S)FTP functionallity.</p>

<p>Output compressor changes relative paths (starting with ../) to the client&#039;s absolute path (like http://domain.com/cms/).<br/>This is okay as long as no file from a different folder is included (like /cms/font-awesome/css/).<br/>In this case, relative paths must be rewritten to the folder the file is in (like http://domain.com/cms/fontawesome/).</p><p>Thanks to Thomas Dubbert for reporting this bug!</p>

<p>If you want to store additional information to your files, you have to edit their settings file by file after you uploaded them probably all at once.<br/>Add those fields to the upload mask, so that after selecting the files, one can immediately enter those info&#039;s for all selected files before uploading them.</p>

<p>When editing an article, on switching the language you have to reselect everything from the navigation down to the article.<br/>As we already have deeplinks to articles, let&#039;s use them in the language switcher.</p>

<p>Recipient import doesn&#039;t recognize groups with special chars like german umlauts</p>

<p>Implement an array holding all(!) culture codes (combination of language codes and country codes).<br/>Rework setup and backend login to show and use installed languages using these culture codes automatically.</p><p>Implement the new language files:<br/>- for setup in /setup/locale + /setup/images/flags<br/>- for backend in /drugcms/locale + /drugcms/xml<br/>Use the culture code for this language in the file names.</p>

<p>On importing recipients, they always get added to the default group, even if you supply false or 0 for this group.</p><p>Solution: don&#039;t add recipients to the default group on importing them, as the groups should be supplied in the import data.</p>

<p>On moving a category up or down within the same parent category, the alias (used for url-building) get&#039;s changed.<br/>This is only nessecary (and allowed) on moving the category into another parent, as there may be another category there with the same alias (which would then have the same url).</p>

<p>When you add a container tag to a layout and want it to show all available modules in the template, you are expected to not enter types, because these types restrict the modules.<br/>In 2.0.6, when you don&#039;t enter a restriction (types=&quot;&quot;), only modules with no type entered are shown, so the restriction is still active.</p>

<p>On editing a template in backend which uses extended template features (like {if ({EDIT} == 0)}) the template won&#039;t show properly and may throw an error.<br/>The problem is, that (in this example) the normal variable EDIT isn&#039;t replaced here and so the if function parser finds {EDIT}, which it can&#039;t handle.</p><p>Solution: Disable extended functionality in the module templates edit area.</p>

<p>When &quot;auto create start articles for new categories&quot; is activated, it only works for new categories, but not for new trees.</p>

<p>Also the article alias has &#039;x-&amp;amp;-y&#039; instead of &#039;x-y&#039; for &#039;X &amp; Y&#039;</p>

<p>For modules, layouts, and the other stuff a history is kept for, the history files show badly encoded signs for for example german umlauts.<br/>This is probably because of the encoding of the xml files.<br/>Make sure we use UTF-8 as the xml encoding to prevent such errors.</p>