ToDo R5.5

For issues regarding Unicode please look in our R6.0 ToDo list.

R5.5 is no longer maintained, please upgrade to R6.0. Open issues will be fixed in R6 branch.

R 5.5

Roadmap
ChangeLog

Main Focus: HTML5 support, security related features

HTTP Strict Transport Security (HSTS)
Content-Security-Policy
Cookies, CSRF sectoken
https://www.owasp.org/index.ph[...]tication_Cheat_Sheet

1. MariaDB / MySQL type casting

https://dev.mysql.com/doc/refm[...]type-conversion.html
https://stackoverflow.com/ques[...]d-backticks-in-mysql

whOOt https://dev.mysql.com/doc/refm[...]ent-programming.html

2. Features

normalize links to other language versions of a page
- add table: lang_link[page_id, lang, target_id]
add debug option to send error log into separate file + rotate logs
add IP block to ban bad actors, bots

3. M17

open issues (add)

relative linking seems not working for ((../ back to parent page)), it links to root level (?!)
add delimiter before page handler (_properties)
1. min_href()
2. router.conf
upload of file without extension -> broken
empty body_r after page rename/relocation -> page needs re-rendering
allow multi logins (on/off)
1. add multi login warning: 'Jemand hat sich bereits an diesem Konto angemeldet'
2. This account is currently being used in 1 other location at this IP ().
add access throttling feature
- limit the number of page requests by a single IP address within a given time interval
add array for 'default' AND 'user' menu so both can used independently (create/edit menu sets)
rewrite_mode setting in AP is pointless if it is overwritten in Setting class

4. Fix

check for avoidable SQL roundtrip queries
link() -> default: $anchor_link – should only active inside page_body (?)
- additional check if its better to prefix the id="doc.deutsch.konfiguration"
  - to avoid unintentional mix with CSS settings
- set anchor id only where needed, minimizes also size of attributes
broken list in tree action if levels changes not in order – e.g. depth 1.2 -> depth 2.4
1. show missing levels
search?phrase="sourceforge.net" -> paging fails with "term to search"
bug: news action takes all subpages – is this desired?
improve search (open since ages), add some measures to improve relevance (time, size, user, filter, ...) and provide more and better meta data for search results
implement rating hack (but without mandatory JS)
1. https://www.youtube.com/watch?v=orPVEAipz2A
add unique log message key to filter events (messages may differ)
add regex for this->config['users_page']/[*]/
- Yet the engine does not validate the namespace for the user cluster, so that nobody can create a page under /User except his own [UserName]
- Then we can disallow random pages for the first level in the users cluster except the own [UserName].
- The register action creates this page usually for the user.

5. Notifications

Notifications

5.1. Notice digest

store events notices and compile digest for user [user|moderator|admin]
- new user
- comments
- files
- changes

6. Handler

clone entire cluster is only available for Admins atm., it should also available for ...
improve global upload settings
1. allow groups
2. set individual rights (only images, quota, etc. for a user, group)
send page as email (like print)
show: add option 'Flag as Spam/Inappropriate'
show: Delayed Indexing delay_index
- <meta name=“robots” content=“noindex,nofollow”>
see upload subpage
1. upload: check if the MIME type of the uploaded file matches the file extension
2. upload: add form field to chose another file name (?)
3. upload: add accept attribute depending on config settings https://www.w3.org/TR/html5/fo[...]ml#attr-input-accept
add meta handler namespace ['page', 'account', 'file', 'service']
- This is the simplest way to standardize document locations and for the language-independent single instances of service pages, like login. Next step is the separated cluster for those pages, linked with prefix, for example, ((service:login)).
- this can be easily done with the new URI router
- handler/account/
file: apply access restrictions for global files if Wiki is closed -> $
1. add and enforce global Wiki mode, minimum access rights
2. route global files only for registered users

7. Action

template toc and tree

8. Formatter

Search Highlighter
(/Users/WikiAdmin UserSpace | WikiAdmin)) -fails on |

<# #> adds  on first and  on second appearance of double quote like class=""

caused by race condition in wacko_preprocess()

<#<div class="" style="background:transparent; border:.1em solid #F66; border-left:1em solid #F66; box-sizing:border-box; margin:.5em 0; overflow:hidden; padding:.5em; text-align:left; width:auto;">Unter den Btrfs-spezifischen Anpassungen (1, 2) waren einige, die Latenz- und Stabilitäts-Probleme beseitigen, die bei knapp werdendem Speicherplatz auftreten können.</div>#>
2
<#<div class="" style="background:transparent; border:.1em solid #fcfce9; border-left:1em solid #fcfce9; box-sizing:border-box; margin:.5em 0; overflow:hidden; padding:.5em; text-align:left; width:auto;">Unter den Btrfs-spezifischen Anpassungen (1, 2) waren einige, die Latenz- und Stabilitäts-Probleme beseitigen, die bei knapp werdendem Speicherplatz auftreten können.</div>#>

<!--notypo--><div class="<!--notypo--> style="background:transparent; border:.1em solid #F66; border-left:1em solid #F66; box-sizing:border-box; margin:.5em 0; overflow:hidden; padding:.5em; text-align:left; width:auto;">Unter den Btrfs-spezifischen Anpassungen (1, 2) waren einige, die Latenz- und Stabilitäts-Probleme beseitigen, die bei knapp werdendem Speicherplatz auftreten können.</div>#><br />2<br /><#<div class=<!--/notypo-->" style="background:transparent; border:.1em solid #fcfce9; border-left:1em solid #fcfce9; box-sizing:border-box; margin:.5em 0; overflow:hidden; padding:.5em; text-align:left; width:auto;">Unter den Btrfs-spezifischen Anpassungen (1, 2) waren einige, die Latenz- und Stabilitäts-Probleme beseitigen, die bei knapp werdendem Speicherplatz auftreten können.</div><!--/notypo--><br />

Wacko is spamming BRs, in between everything
add option to hide protected links
- You must login to see this link. Register now, if you have no user account yet.
Error: Bad value 4 for attribute type on element ol.
1. see $new_indent_type in wackoformatter -> error prone
  - ```
    1. hallo
      5. should not take the number but 1, same for i, I, a, A
```
2. Block elements inside inline elements
3. http://www.w3.org/TR/html5/gro[...]nt.html#attr-ol-type
allow case insensitive matching of file links, e.g. File:image.jpg
breaks quote
```
<[http://www.example.com]>
```
<[ ]> eats blank line in quote, undesired
broken nested quote
- ```
<[block
<[nested quote]>
quote
]>
```

9. Admin Panel

upload module

PAY ATTENTION TO SECURITY RISKS
 

Before adding random file/MIME types: please think about possible security issues.

For example HTML (.htm, .html), JavaScript (.js) and PHP (.php) file are types you’d better avoid as they can be “executed” on your server where you really would not want that to happen. For most of these kind of files, this should not be a problem though as these files are better off being compressed into a ZIP file anyway.

Only add file types that you REALLY need and that you are comfortable with.

add module to filter, moderate and manage pages, comments, (files)
1. see modules for content like pages
recovery mode: CSS and images won't load
- index.php: (!$db->ap_mode && RECOVERY_MODE) excludes static files!
  - !$db->ap_mode

purge logs (TRUNCATE)

log table
referrers
badbehavior

 <thead class="data-head">
        <tr class="">
        </tr>
        [...]
    </thead>

<tbody id="table-section-one">
[...]
</tbody>

<tbody id="table-section-two">
[...]
</tbody>

10. Database

10.1. Check for SQL STRICT mode violations

Using GROUP BY and selecting an ambiguous column
Inserting the non standard zero date into a datetime column
Inserting a 20 character string into a 10 character column
Division by zero
Inserting a negative value into an unsigned column

so far

#1406 – Data too long for column 'description' at row 1
1. set HTML maxlength="DB_FIELDSIZE" for all (VAR)CHAR form field
  - suggested (JS hint – might differ in some cases – smaller, e.g. meta description 160, meta title 60) + database field size (mandatory enforcement)
  - JS hint: You have <strong>60</strong> characters left
2. set PHP length check before passing to INPUT / UPDATE
#1055 – 'dev.g.group_name' isn't in GROUP BY

SELECT
`DIGEST_TEXT` AS `query`,
`SCHEMA_NAME` AS `db`,
`COUNT_STAR` AS `exec_count`,
`SUM_ERRORS` AS `errors`,
(ifnull((`SUM_ERRORS` / nullif(`COUNT_STAR`,0)),0) * 100) AS `error_pct`,
`SUM_WARNINGS` AS `warnings`,
(ifnull((`SUM_WARNINGS` / nullif(`COUNT_STAR`,0)),0) * 100) AS `warning_pct`,
`FIRST_SEEN` AS `first_seen`,
`LAST_SEEN` AS `last_seen`,
`DIGEST` AS `digest`
FROM
 performance_schema.events_statements_summary_by_digest
WHERE
((`SUM_ERRORS` > 0) OR (`SUM_WARNINGS` > 0))
ORDER BY
 `SUM_ERRORS` DESC,
 `SUM_WARNINGS` DESC;

11. Usability issues

add double-click support for editing comments
When should I use a select box instead of radio buttons?
1. https://www.nngroup.com/articl[...]es-vs-radio-buttons/
Not indicating an active form field
- e.g.
```
textarea:focus {
    border: 1px solid red; }
```
- You can use the ‘:focus’ selector on lots of elements, but it’s super handy when used on inputs and textareas to indicate that the field is active. Add CSS styling such as a highlighted border, or a subtle change to the background color.

Readings

12. Extensions

~~https://github.com/google/code-prettify~~ (abandoned)
https://highlightjs.org/
https://prismjs.com/

13. Ideas

spam / badword handling -> bad_words($text) function
1. https://en.wikipedia.org/wiki/Wordfilter
2. https://stackoverflow.com/ques[...]ood-profanity-filter
3. What you need is a good way for users to flag inappropriate content and a mechanism to deal with it swiftly. One way is to automatically hide/remove content if it's been flagged more than X times.
rel="edit" -> https://tools.ietf.org/html/rfc686
enforce ACL-Policy, e.g. set read to $, user can't overwrite the setting
test PHPThumb alternatives
1. https://github.com/mosbth/cimage
Composer
https://github.com/openpgpjs/openpgpjs

https://www.w3.org/TR/css3-page/
1. https://www.smashingmagazine.c[...]-for-print-with-css/

14. Themes

new mobile ready theme / layout -> on hold (we got a new template engine!)
- https://getbootstrap.com/
- https://getbootstrap.com/docs/[...]tarted/introduction/
https://developers.google.com/web/fundamentals/
https://www.w3.org/Style/Examples/007/leaders

CSS Varibles

CSS colums for index <div class="gimme-columns"><ul>

 
.gimme-columns {
	columns: 20em 3;
	column-count: 3;
	column-width: 20em;
}

.sticky {
  position: sticky;
  top: 0;
}

default theme

change blockquote
- box-shadow: 0 0 6px rgba(0, 0, 0, 0.5);
add option to hide $this->config['site_name'] in theme header, e.g.: To Do R5.5 – WackoWiki -> To Do R5.5
min-height: 200px for .article, #page

Read comments (0 comments)