[ticket/10605] Add a section for updating from 3.0.10 to schema updates.

Without it data updates do not appear to be run.

PHPBB3-10605
[ticket/10605] Fix left join usage.

Previously this produced broken SQL:

SELECT p.msg_id FROM phpbb_privmsgs p
LEFT JOIN 0 phpbb_privmsgs_to ON (p.msg_id = t.msg_id)
WHERE t.user_id IS NULL LIMIT 500 OFFSET 0

PHPBB3-10605
[ticket/10650] Displaying last topic on forum list

The most recent topic title of the forum can now
be displayed on the board index. An option is provided
in the ACP under the 'General Forum Setting' which
allows the admin to enable or disable this feature.

PHPBB3-10650
[ticket/10650] Added static sql files

Ran create_schema_files.php and added
the generated static sql files to the commit.

PHPBB3-10650
[ticket/10650] Changed language files and forumlist

The entry in languages have been changed from
title to subject. Also the IF condition in forumlist_body.html
has been properly intented.

PHPBB3-10650
[ticket/10650] Corrected space before true

Inserted a space before 'true' as per coding
guidelines.

PHPBB3-10650
[ticket/10650] Cropped subject and inserted newline

The subject being displayed in the forum list have been
shortened to 30 characters. Also it is now being shown
in a separate line.

PHPBB3-10650
[ticket/10650]Added permission checking and utf8 functions

Passworded forums and ones in which user doesn't have
read access will be excluded. Also uft8 based string functions and
html encode/decode functions have been used to sanitise subject.

PHPBB3-10650
[ticket/10650] Corrected intendation

Corrected the intendation of if condition.

PHPBB3-10650
[ticket/10650] Added checking for empty subjects

Now empty subjects will not be displayed in a
new line on the forum list.

PHPBB3-10650
[ticket/10650] Changed acp option from per forum to global

Changed the display last subject acp toggle option from
per forum to global. Modified associated database entries.
New option is available in ACP General->Board Features.
Also corrected <br /> in forumlist_body.html.

PHPBB3-10650
[ticket/10650]Removed incorrect newline

Deleted additional line in the end of database_update.php

PHPBB3-10650
[ticket/10650] Removed changes from acp_forums.php

Removed unneccesary changes from acp_forums.php

PHPBB3-10650
[ticket/10650] Made use of truncate_string() function

Removed manual cropping and used truncate_string function.
Also made a new variable  so
that  is preserved.

PHPBB3-10650
[ticket/10650] Added href title to subject link

Added title attribute to anchor tag which displays
last_post_subject so that the full subject can be
seen by hovering over the truncated subject displayed
in forumlist.

PHPBB3-10650
[ticket/10650] Added ellipsis to language file

Added ELLIPSIS to language file common.php and also corrected
language explanation of ACP option.

PHPBB3-10650
[ticket/10650] Added space after if and comment

Added space in proper places in database_update.php. Also
corrected language entry of ELLIPSIS to utf8

PHPBB3-10650
[ticket/10650] Inserted correct utf ELLIPSIS character

Inserted the correct utf-8 ellipsis to the language file.

PHPBB3-10650
[ticket/10650] Added apostrophe in explanation in language file

A missing apostrophe was added to the language file entry
of DISPLAY_LAST_SUBJECT_EXPLAIN

PHPBB3-10650
[ticket/10734] Moved style elements and fixed minor bugs

Moved color related style elements to colours.css and other elements to
common.css
Also added an empty display for corners span.
Removed unwanted space in mcp_topic
Removed DS_Store

PHPBB-10734