[ticket/11219] Update sequence values after loading fixtures

If a value is provide for an auto_increment type of column, certain DBMSes
do not update their internal sequencers. If a row is inserted later, it can
be given an ID that is already in use, resulting in an error. The database
test cases now resynchronise the sequencers before the tests are run.

PHPBB3-11219
[ticket/11219] Add unit test for inserting into a sequence column

PHPBB3-11219
[ticket/11219] Recreate Oracle sequences instead of altering them

The previous method would always leave a gap between the last value and the
new one due to how you have to update the sequence values. To remove gaps in
all situations, the options are to alter the USER_SEQUENCES table or just
drop the sequence and recreate it. The prior requires elevated priveleges
and the latter can break attached objects. Since we don't attach objects to
the sequences, we won't have any problems doing it for the tests.

PHPBB3-11219
[ticket/11219] Only update sequences that are affected by a fixture

PHPBB3-11219
[ticket/10841] Modifying style and language selectors in UCP

Commit also deletes all unnecessary blank spaces at
the end of the lines in both ucp_prefs_personal.html

PHPBB3-10841
[ticket/10841] changing affectedrows check to COUNT in sql

this sould reduce load and be faster. Also freeresult functions added

PHPBB3-10841
[ticket/10841] removing unnecessary spacing

PHPBB3-10841
[ticket/10841] adding space after if

PHPBB3-10841
[ticket/10841] Revert whitespace changes.

PHPBB3-10841
[ticket/10841] Revert more whitespace changes.

PHPBB3-10841
Merge PR #1053 branch 'p/ticket/10841' into develop-olympus

* p/ticket/10841:
  [ticket/10841] Revert more whitespace changes.
  [ticket/10841] Revert whitespace changes.
  [ticket/10841] adding space after if
  [ticket/10841] removing unnecessary spacing
  [ticket/10841] changing affectedrows check to COUNT in sql
  [ticket/10841] Modifying style and language selectors in UCP
Merge PR #1053 branch 'develop-olympus' into develop

* develop-olympus:
  [ticket/10841] Revert more whitespace changes.
  [ticket/10841] Revert whitespace changes.
  [ticket/10841] adding space after if
  [ticket/10841] removing unnecessary spacing
  [ticket/10841] changing affectedrows check to COUNT in sql
  [ticket/10841] Modifying style and language selectors in UCP

Conflicts:
	phpBB/includes/ucp/ucp_prefs.php
	phpBB/styles/prosilver/template/ucp_prefs_personal.html
[ticket/11248] Line endings to LF.

PHPBB3-11248
[ticket/11219] Coding guidelines and naming consistency changes

PHPBB3-11219
Merge PR #1101 branch 'Noxwizard/ticket/11219' into develop-olympus

* Noxwizard/ticket/11219:
  [ticket/11219] Coding guidelines and naming consistency changes
  [ticket/11219] Only update sequences that are affected by a fixture
  [ticket/11219] Recreate Oracle sequences instead of altering them
  [ticket/11219] Add unit test for inserting into a sequence column
  [ticket/11219] Update sequence values after loading fixtures
Merge PR #1101 branch 'develop-olympus' into develop

* develop-olympus:
  [ticket/11219] Coding guidelines and naming consistency changes
  [ticket/11219] Only update sequences that are affected by a fixture
  [ticket/11219] Recreate Oracle sequences instead of altering them
  [ticket/11219] Add unit test for inserting into a sequence column
  [ticket/11219] Update sequence values after loading fixtures
[ticket/10679] Add new permission for changing profile field information

The setting is copied from "Can use signature"

PHPBB3-10679
[ticket/10679] Use module_auth to limit access to the module

PHPBB3-10679
[ticket/10679] Update module basename, we added the xcp_ prefix in 3.1

PHPBB3-10679
Merge PR #607 branch 'nickvergessen/ticket/10679' into develop

* nickvergessen/ticket/10679:
  [ticket/10679] Update module basename, we added the xcp_ prefix in 3.1
  [ticket/10679] Use module_auth to limit access to the module
  [ticket/10679] Add new permission for changing profile field information